[{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_CODE]:
;[|PERSON_CODE]:
;[|EMPLOYMENT_TYPE]:
;[|HIRE_DATE]:
;[|UNIT_CODE]:
;[|GROUP_CODE]:
;[|COUNTRY_CODE]:
;[|STATE_PROVINCE_CODE_HOME]:
;[|STATE_PROVINCE_CODE_WORK]:
;[|TODATE_TYPE]:
;[|CALENDAR_PERIOD]:
;[|SCHOOL_DISTRICT_CODE]:
;[|GEO_CODE_WORK]:
;[|GEO_CODE_HOME]:
;[|PC_CODE]:
;[|AMOUNT]:
;[|DESCRIPTION]:

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

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

}]