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

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.