[{TableOfContents }]
!!!TODATE INTERFACE FILE

The ToDate Interface File screen is used to import employee’s to-date (YTD, MTD, QTD) amounts 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.


ToDate Interface File data is maintained on the [INF_CV_TODATES] table.

!!Tab 1
;[ID|ID]:This field uniquely identifies the todate record within the data base.
;[Entity|ENTITY_CODE]:
;[Person Code|PERSON_CODE]:
;[Employment Type|EMPLOYMENT_TYPE]:
;[Date of Hire|HIRE_DATE]:
;[Unit|UNIT_CODE]:
;[Group|GROUP_CODE]:
;[Country Name|COUNTRY_CODE]:
;[Home State|STATE_PROVINCE_CODE_HOME]:
;[Work State|STATE_PROVINCE_CODE_WORK]:
;[ToDate Type|TODATE_TYPE]:
;[Calendar Period|CALENDAR_PERIOD]:
;[School|SCHOOL_DISTRICT_CODE]:
;[Work GEO Code|GEO_CODE_WORK]:
;[Home GEO Code|GEO_CODE_HOME]:
;[PC Code|PC_CODE]:
;[Amount $|AMOUNT]:
;[Description|DESCRIPTION]:

[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.IVPTD] 	
[{InsertPage page='Internal.IVPTD' default='Click to create a new discussion page'}] 	

}]