EMPL_ID |
ColumnName | EMPL_ID |
Definition | Name: Employee ID. Description: Employee ID identifier. |
TS_SCHEDULE_CD |
ColumnName | TS_SCHEDULE_CD |
Definition | Name: Timesheet Schedule. Description: Timesheet frequency identifier. |
YEAR_NO_CD |
ColumnName | YEAR_NO_CD |
Definition |
PERIOD_NO_CD |
ColumnName | PERIOD_NO_CD |
Definition | Name: Period Number. Description: Period number for timesheet frequency. |
COLUMN_DT |
ColumnName | COLUMN_DT |
Definition | Name: Date. Description: The date for this timesheet column. |
SEQ_NO |
ColumnName | SEQ_NO |
Definition | Name: Sequence Number. Description: Sequence number to allow unique key |
S_START_STOP_TYPE_CD |
ColumnName | S_START_STOP_TYPE_CD |
Definition | 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 |
ColumnName | LINE_NO |
Definition | Name: Line Number. Description: The timesheet line number if start/stop time is for a charge. |
START_DTT |
ColumnName | START_DTT |
Definition | Name: Start Date/Time. Description: The start date/time for the record. |
STOP_DTT |
ColumnName | STOP_DTT |
Definition | Name: Stop Date/Time. Description: The stop date/time for the record. |
START_STOP_TEXT |
ColumnName | START_STOP_TEXT |
Definition | Name: Comments. Description: User-provided comments for start/stop time. |
MODIFIED_BY |
ColumnName | MODIFIED_BY |
Definition | Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
ColumnName | ROWVERSION |
Definition | Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition | Name: Time Stamp. Description: Date and time the record was last modified. |