Alias: IVPTD#
The INF_CV_TODATES table is used to import employee’s work assignment information and attendant data into the software data structures. The TODATES table stores pay component information for year, quarter, month, fiscal and assignment to-date periods. The information is stored in two tables: a “header” and “pay component details”. A new header record is created for each combination of the following fields: Employment record (entity, person_code, employment_type, hire_date), group (for specific unit), state/province of work, state/province of residence (within the country specified), School District Code, GEO Code for work, GEO Code for residence, type of To-date (year, month, etc.) and specific period for that to-date type.Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | ||
| ENTITY_CODE | Varchar2(16) | CODE | Y | |
| PERSON_CODE | Varchar2(16) | CODE | Y | |
| EMPLOYMENT_TYPE | Varchar2(30) | VARCHAR30 | ||
| HIRE_DATE | Date() | DATE | ||
| UNIT_CODE | Varchar2(16) | CODE | Y | |
| GROUP_CODE | Varchar2(16) | CODE | Y | |
| COUNTRY_CODE | Varchar2(16) | CODE | Y | |
| STATE_PROVINCE_CODE_HOME | Varchar2(16) | CODE | ||
| STATE_PROVINCE_CODE_WORK | Varchar2(16) | CODE | ||
| TODATE_TYPE | Varchar2(30) | VARCHAR30 | Y | |
| CALENDAR_PERIOD | Number(10) | NUMBER10 | ||
| SCHOOL_DISTRICT_CODE | Varchar2(16) | CODE | ||
| GEO_CODE_WORK | Varchar2(16) | CODE | ||
| GEO_CODE_HOME | Varchar2(16) | CODE | ||
| PC_CODE | Number(4) | CODE NUMERIC | ||
| AMOUNT | Number(18) | AMT12V6 | ||
| DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| CREATE_DATE | Date() | DATE | ||
| CREATE_USER | Varchar2(30) | VARCHAR30 | ||
| CHANGE_DATE | Date() | DATE | ||
| CHANGE_USER | Varchar2(30) | VARCHAR30 |
