BATCH_ID |
ColumnName | BATCH_ID |
Definition | Name: Batch ID. Description: The ID of the batch of which this record is a member. This value defaults from screen input. |
TIMESHEET_DT |
ColumnName | TIMESHEET_DT |
Definition | Name: Timesheet Date. Description: The column date for this cell. This value defaults from screen input. |
EMPL_ID |
ColumnName | EMPL_ID |
Definition | Name: Employee ID. Description: Employee ID identifier. This value defaults from the TS table. |
TS_SCHEDULE_CD |
ColumnName | TS_SCHEDULE_CD |
Definition | Name: Timesheet Schedule. Description: Timesheet frequency identifier. This value defaults from the TS table. |
YEAR_NO_CD |
ColumnName | YEAR_NO_CD |
Definition |
PERIOD_NO_CD |
ColumnName | PERIOD_NO_CD |
Definition | Name: Timesheet Period Number. Description: Period number for timesheet frequency. This value defaults from the TS table. |
LINE_NO |
ColumnName | LINE_NO |
Definition | Name: Timesheet Line Number. Description: The timesheet line number that this timesheet cell belongs to. This value defaults from the TS_LINE table. |
HRS_DT |
ColumnName | HRS_DT |
Definition | Name: Hours Date. Description: The column date for this cell. This value defaults from the TS_CELL table. |
PAYROLL_ID |
ColumnName | PAYROLL_ID |
Definition | Name: Payroll ID. Description: The payroll ID for the employee. This value defaults from the EMPL table. |
PAYROLL_EMPL_ID |
ColumnName | PAYROLL_EMPL_ID |
Definition | Name: Payroll Employee ID. Description: The employees Employee ID for payroll. This value defaults from the EMPL table. |
UDT10_ID |
ColumnName | UDT10_ID |
Definition | Name: UDT10 ID. Description: The UDT10 identifier for the line. This value defaults from the TS_LINE table. |
HRS |
ColumnName | HRS |
Definition | Name: Hours. Description: The exported labor hours for this cell. This value defaults from the TS_CELL table. |
CORRECT_FL |
ColumnName | CORRECT_FL |
Definition | Name: Correct Flag. Description: Logical as to whether this cell is a correcting entry. This value defaults from the TS_CELL table. |
OT_FL |
ColumnName | OT_FL |
Definition | Name: Overtime Flag. Description: Logical as to whether this UDT10 ID is for overtime. This value defaults from the UPD10 table. |
COST_FL |
ColumnName | COST_FL |
Definition | Name: Cost Flag. Description: Logical as to whether this UDT10 ID is for "cost only" hours. This value defaults from the UDT10 table. |
MISC_PAYROLL_CD |
ColumnName | MISC_PAYROLL_CD |
Definition | Name: Miscellaneous Payroll Code. Description: Miscellaneous field contains codes used to feed the payroll file during export. This value defaults from the UDT10 table. |
PAYROLL_EARNINGS_CD |
ColumnName | PAYROLL_EARNINGS_CD |
Definition | Name: Payroll Earnings Code. Description: Earnings code for this UDT10 ID. This value defaults from the UDT10 table. |
S_PAYROLL_MAP_CD |
ColumnName | S_PAYROLL_MAP_CD |
Definition | Name: Payroll Earnings Map Code. Description: Shows how the Earnings Code will be mapped during export. The valid options are as follows: N - None. R - Regular. O - Overtime. 3 - Earnings 3. 4 - Earnings 4. 5 - Earnings 5. H3 - Hours 3 . H4 - Hours 4 |
CLASS_CD |
ColumnName | CLASS_CD |
Definition | Name: Timesheet Class. Description: The employee class for the employee at the time of the export. The code is from the TS table. |
RATE1_AMT |
ColumnName | RATE1_AMT |
Definition | Name: Rate 1 Amount. Description: User-defined amount 1. |
CODE1_CD |
ColumnName | CODE1_CD |
Definition | Name: User Defined Code 1. Description: First user-defined alphanumeric field from the EMPL table. |
CODE2_CD |
ColumnName | CODE2_CD |
Definition | Name: User Defined Code 2. Description: Second user-defined alphanumeric field from the EMPL table. |
CODE3_CD |
ColumnName | CODE3_CD |
Definition | Name: User Defined Code 3. Description: Third user-defined alphanumeric field from the EMPL table. |
SEQ_NO |
ColumnName | SEQ_NO |
Definition | Name: Sequence Number. Description: Synthetic key to support recasts |
RATE1_RATE |
ColumnName | RATE1_RATE |
Definition | Name: User Defined Rate 1. Description: User-defined rate 1. |
TS_UDT10_ID |
ColumnName | TS_UDT10_ID |
Definition | Name: UDT10 used for recast Description: UDT10 ID that started the recasting process. |
S_STATUS_CD |
ColumnName | S_STATUS_CD |
Definition | Name: Status code for export Description: Status code used in export of Labor records. |
MODIFIED_BY |
ColumnName | MODIFIED_BY |
Definition |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition |