IVPTD
Back to current versionRestore this version

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.

Tab 1#

ID
This field uniquely identifies the todate record within the data base.