ColumnName |
Domain |
Datatype |
NULL |
Definition |
EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Employee ID. Description: Employee ID identifier. |
TS_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Timesheet Schedule. Description: Timesheet frequency identifier. |
YEAR_NO_CD |
|
VARCHAR2(4) |
NO |
|
PERIOD_NO_CD |
|
VARCHAR2(3) |
NO |
Name: Period Number. Description: Period number for timesheet frequency. |
COLUMN_DT |
|
DATE |
NO |
Name: Date. Description: The date for this timesheet column. |
SEQ_NO |
|
NUMBER(10, 0) |
NO |
Name: Sequence Number. Description: Sequence number to allow unique key |
S_START_STOP_TYPE_CD |
|
VARCHAR2(1) |
NO |
Name: Start/Stop Time Type. Description: Indicates the type of start/stop time it is. The valid values areC – Charge. B – Break. L – Lunch. W - Work. |
LINE_NO |
|
NUMBER(10, 0) |
YES |
Name: Line Number. Description: The timesheet line number if start/stop time is for a charge. |
START_DTT |
|
DATE |
NO |
Name: Start Date/Time. Description: The start date/time for the record. |
STOP_DTT |
|
DATE |
YES |
Name: Stop Date/Time. Description: The stop date/time for the record. |
START_STOP_TEXT |
|
VARCHAR2(254) |
YES |
Name: Comments. Description: User-provided comments for start/stop time. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |