Table of Contents
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.
- ID
- This field uniquely identifies the todate record within the data base.
- Entity
- This field displays the entity associated with the todate record.
- Person Code
- This field displays the person associated with the todate record.
- Employment Type
- This employee's employment type is displayed in this field.
- Date of Hire
- The employee's hire date is displayed in this field.
- Unit
- This is the union that the employee’s pays were processed under.
- Group
- This is the group code that the employee’s pays were processed under.
- Country Name
- The employee's country of residence is displayed in this field.
- Home State
- This field displays the state or province from the employee’s home address.
- Work State
- This field displays the state or province from the employee’s work location.
- ToDate Type
- This field indicates the type of to-date record this record relates to.
- Calendar Period
- This field identifies the calendar associated with the record.
- School
- The School District code for the employee’s home address.
- Work GEO Code
- The field shows the Tax Jurisdiction code for the employee’s work location.
- Home GEO Code
- This field shows the Tax Jurisdiction code for the employee’s home address.
- PC Code
- This field shows the pay component associated with the record.
- Amount $
- This field shows the amount associated with the record.
- Description
- This field provides a short description of the the record.
