Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
BATCH_ID |
|
VARCHAR(10) |
NO |
Name: Batch ID. Description: The ID of the batch of which this record is a member. This value defaults from screen input. |
TIMESHEET_DT |
|
DATE |
NO |
Name: Timesheet Date. Description: The column date for this cell. This value defaults from screen input. |
EMPL_ID |
|
VARCHAR(20) |
NO |
Name: Employee ID. Description: Employee ID identifier. This value defaults from the TS table. |
TS_SCHEDULE_CD |
|
VARCHAR(10) |
NO |
Name: Timesheet Schedule. Description: Timesheet frequency identifier. This value defaults from the TS table. |
YEAR_NO_CD |
|
VARCHAR(4) |
NO |
|
PERIOD_NO_CD |
|
VARCHAR(3) |
NO |
Name: Timesheet Period Number. Description: Period number for timesheet frequency. This value defaults from the TS table. |
LINE_NO |
|
NUMERIC(10, 0) |
NO |
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 |
|
DATE |
NO |
Name: Hours Date. Description: The column date for this cell. This value defaults from the TS_CELL table. |
PAYROLL_ID |
|
VARCHAR(20) |
YES |
Name: Payroll ID. Description: The payroll ID for the employee. This value defaults from the EMPL table. |
PAYROLL_EMPL_ID |
|
VARCHAR(20) |
YES |
Name: Payroll Employee ID. Description: The employees Employee ID for payroll. This value defaults from the EMPL table. |
UDT10_ID |
|
VARCHAR(20) |
NO |
Name: UDT10 ID. Description: The UDT10 identifier for the line. This value defaults from the TS_LINE table. |
HRS |
|
NUMERIC(8, 2) |
NO |
Name: Hours. Description: The exported labor hours for this cell. This value defaults from the TS_CELL table. |
CORRECT_FL |
|
VARCHAR(1) |
NO |
Name: Correct Flag. Description: Logical as to whether this cell is a correcting entry. This value defaults from the TS_CELL table. |
OT_FL |
|
VARCHAR(1) |
NO |
Name: Overtime Flag. Description: Logical as to whether this UDT10 ID is for overtime. This value defaults from the UPD10 table. |
COST_FL |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(30) |
YES |
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 |
|
VARCHAR(30) |
YES |
Name: Payroll Earnings Code. Description: Earnings code for this UDT10 ID. This value defaults from the UDT10 table. |
S_PAYROLL_MAP_CD |
|
VARCHAR(10) |
YES |
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 |
|
VARCHAR(20) |
NO |
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 |
|
NUMERIC(15, 5) |
NO |
Name: Rate 1 Amount. Description: User-defined amount 1. |
CODE1_CD |
|
VARCHAR(20) |
YES |
Name: User Defined Code 1. Description: First user-defined alphanumeric field from the EMPL table. |
CODE2_CD |
|
VARCHAR(20) |
YES |
Name: User Defined Code 2. Description: Second user-defined alphanumeric field from the EMPL table. |
CODE3_CD |
|
VARCHAR(20) |
YES |
Name: User Defined Code 3. Description: Third user-defined alphanumeric field from the EMPL table. |
SEQ_NO |
|
NUMERIC(10, 0) |
NO |
Name: Sequence Number. Description: Synthetic key to support recasts |
RATE1_RATE |
|
NUMERIC(15, 5) |
NO |
Name: User Defined Rate 1. Description: User-defined rate 1. |
TS_UDT10_ID |
|
VARCHAR(20) |
YES |
Name: UDT10 used for recast Description: UDT10 ID that started the recasting process. |
S_STATUS_CD |
|
VARCHAR(1) |
YES |
Name: Status code for export Description: Status code used in export of Labor records. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|