ColumnName |
Domain |
Datatype |
NULL |
Definition |
WKC5606EMP |
|
CHAR(20) |
NO |
Name: Employee ID. Description: The unique identifier of the employee. |
WKC5606TS |
|
CHAR(10) |
NO |
Name: Timesheet Schedle. Description: Timesheet frequency identifier. |
WKC5606FYR |
|
CHAR(4) |
NO |
Name: Timesheet Year. Description: The timesheet frequency’s year code. |
WKC5606PER |
|
CHAR(3) |
NO |
Name: Timesheet Period. Description: Period number for timesheet frequency. |
WKEDLN |
|
FLOAT(126) |
NO |
Name: Timeheet Line Number. Description: The timesheet line number to which the timesheet cell record belongs. |
WKC5606CDT |
|
CHAR(10) |
NO |
Name: Hours Date. Description: The column (cell) date for this row. |
WKC5606SDT |
|
CHAR(10) |
YES |
Name: Period Start Date. Description: Start date of the period. |
WKC5606EDT |
|
CHAR(10) |
YES |
Name: Period End Date. Description: End date of the period. |
WKEDBT |
|
CHAR(15) |
YES |
Name: Batch ID. Description: Batch Number. |
WKC5606TSD |
|
CHAR(10) |
YES |
Name: Timesheet Date. Description: The date associated with the timesheet. |
WKC5606SID |
|
CHAR(10) |
YES |
Name: Site ID. Description: The site ID that the timesheet and employee are from. |
WKC5606CCD |
|
CHAR(10) |
YES |
Name: Timesheet Class. Description: The current class that the employee belongs to. |
WKC5606OTH |
|
CHAR(20) |
YES |
Name: Overtime Hours. Description: The number of overtime hours. |
WKC5606LDS |
|
CHAR(120) |
YES |
Name: Charge Description. Description: Description of the charge on the line. (Line Description) |
WKC5606GRP |
|
CHAR(20) |
YES |
Name: Employee Group. Description: Group Code. |
WKC5606CHG |
|
CHAR(45) |
YES |
Name: Charge Tree. Description: Charge number for the timesheet line. |
WKC5606CAI |
|
CHAR(20) |
YES |
Name: Charge Abbreviation. Description: Charge abbreviation code. |
WKC5606UTL |
|
CHAR(10) |
YES |
Name: . Description: Utilization Code. |
WKC5606T01 |
|
CHAR(30) |
YES |
Name: UDT01 ID. Description: The UDT01 identifier for the timesheet line. (Proj/Task or Work Order) |
WKC5606T02 |
|
CHAR(30) |
YES |
Name: UDT02 ID. Description: The UDT02 identifier for the timesheet line. |
WKC5606T03 |
|
CHAR(20) |
YES |
Name: UDT03 ID. Description: The UDT03 identifier for the timesheet line. |
WKC5606T04 |
|
CHAR(20) |
YES |
Name: UDT04 ID. Description: The UDT04 identifier for the timesheet line. |
WKC5606T05 |
|
CHAR(20) |
YES |
Name: UDT05 ID. Description: The UDT05 identifier for the timesheet line. |
WKC5606T06 |
|
CHAR(20) |
YES |
Name: UDT06 ID. Description: The UDT06 identifier for the timesheet line. (Job Step) |
WKC5606T07 |
|
CHAR(20) |
YES |
Name: UDT07 ID. Description: The UDT07 identifier for the timesheet line. (Job Type) |
WKC5606T08 |
|
CHAR(20) |
YES |
Name: UDT08 ID. Description: The UDT08 identifier for the timesheet line. |
WKC5606T09 |
|
CHAR(20) |
YES |
Name: UDT09 ID. Description: The UDT09 identifier for the timesheet line. |
WKC5606T10 |
|
CHAR(20) |
YES |
Name: UDT10 ID. Description: The UDT10 identifier for the timesheet line. (Pay Type) |
WKC5606TST |
|
CHAR(254) |
YES |
Name: Timesheet Comment. Description: Timesheet Text. |
WKC5606LBR |
|
CHAR(20) |
YES |
Name: User Defined Rate 1. Description: The labor rate. |
WKC5606LAM |
|
CHAR(20) |
YES |
Name: User Defined Rate 1 Amount. Description: The labor amount. |
WKC5606BRT |
|
CHAR(20) |
YES |
Name: User Defined Rate 2 . Description: The billing rate. |
WKC5606BAM |
|
CHAR(20) |
YES |
Name: User Defined Rate 2 Amount. Description: The billing amount. |
WKC5606HRS |
|
CHAR(20) |
YES |
Name: Hours. Description: The entered labor hours for this cell. |
WKC5606CRF |
|
CHAR(1) |
YES |
Name: Correcting Flag. Description: Logical as to whether this cell is a correcting entry. |
WKC5606CTX |
|
CHAR(254) |
YES |
Name: Timesheet Cell Comment. Description: User-provided notes about the timesheet cell. |
WKC5606LTX |
|
CHAR(254) |
YES |
Name: Timesheet Line Comment. Description: User-provided notes about the timesheet line. |
WKC5606STS |
|
CHAR(1) |
YES |
Name: Timesheet Cell Status. Description: Status of the cell. |
WKEDSP |
|
CHAR(1) |
YES |
Name: Record Pickup Flag. Description: (EditSuccessfullyProcess) Logical as to whether this cell record has been confirmed. “N” – Record has not been picked up. “Y” – Record has been picked up. |
WKC5606ETX |
|
CHAR(254) |
YES |
Name: Error Text. Description: Error Text. |
WKC5606ETK |
|
CHAR(50) |
YES |
Name: Record Key. Description: ET Key ID |
WKUSER |
|
CHAR(10) |
YES |
Name: User ID. Description: User ID |
WKPID |
|
CHAR(10) |
YES |
Name: Program ID. Description: Program ID |
WKJOBN |
|
CHAR(10) |
YES |
Name: Workstation ID. Description: Workstation ID |
WKUPMJ |
|
NUMBER(6, 0) |
YES |
Name: Update Date. Description: Date - Updated |
WKUPMT |
|
NUMBER(6, 0) |
YES |
Name: Update Time. Description: Time - Updated |
WKC5606T11 |
|
CHAR(30) |
YES |
Name: UDT11 ID. Description: The UDT11 identifier for the timesheet line. |
WKC5606T12 |
|
CHAR(30) |
YES |
Name: UDT12 ID. Description: The UDT12 identifier for the timesheet line. |
WKC5606T13 |
|
CHAR(30) |
YES |
Name: UDT13 ID. Description: The UDT13 identifier for the timesheet line. |
WKC5606T14 |
|
CHAR(30) |
YES |
Name: UDT14 ID. Description: The UDT14 identifier for the timesheet line. |
WKC5606T15 |
|
CHAR(30) |
YES |
Name: UDT15 ID. Description: The UDT15 identifier for the timesheet line. |