[{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]:This field displays the entity associated with the todate record.
;[Person Code|PERSON_CODE]:This field displays the person associated with the todate record.
;[Employment Type|EMPLOYMENT_TYPE]:This employee's employment type is displayed in this field.
;[Date of Hire|HIRE_DATE]:The employee's hire date is displayed in this field.
;[Unit|UNIT_CODE]:This is the union that the employee’s pays were processed under.
;[Group|GROUP_CODE]:This is the group code that the employee’s pays were processed under.
;[Country Name|COUNTRY_CODE]:The employee's country of residence is displayed in this field.
;[Home State|STATE_PROVINCE_CODE_HOME]:This field displays the state or province from the employee’s home address.
;[Work State|STATE_PROVINCE_CODE_WORK]:This field displays the state or province from the employee’s work location.
;[ToDate Type|TODATE_TYPE]:This field indicates the type of to-date record this record relates to.
;[Calendar Period|CALENDAR_PERIOD]:This field identifies the calendar associated with the record.
;[School|SCHOOL_DISTRICT_CODE]:The School District code for the employee’s home address.
;[Work GEO Code|GEO_CODE_WORK]:The field shows the Tax Jurisdiction code for the employee’s work location.
;[Home GEO Code|GEO_CODE_HOME]:This field shows the Tax Jurisdiction code for the employee’s home address.
;[PC Code|PC_CODE]:This field shows the pay component associated with the record.
;[Amount $|AMOUNT]:This field shows the amount associated with the record.
;[Description|DESCRIPTION]:This field provides a short description of the the record.

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

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

}]