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.

Entity

Person Code

Employment Type

Date of Hire

Unit

Group

Country Name

Home State

Work State

ToDate Type

Calendar Period

School

Work GEO Code

Home GEO Code

PC Code

Amount $

Description