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: Hours Date. Description: The date for this timesheet column. |
IN_TIME_DTT |
|
DATE |
YES |
Name: Time In Date/Time. Description: The date and time the employee reported for work. |
OUT_TIME_DTT |
|
DATE |
NO |
Name: Time Out Date/Time. Description: The date and time the employee left work for the day. |
OFF_SITE_HRS |
|
NUMBER(8, 2) |
NO |
Name: Offsite Hours. Description: The number of hours spent between the time in and time out that was spent off-site. |
NON_WORK_HRS |
|
NUMBER(8, 2) |
NO |
Name: Non Work Hours. Description: The number of hours between time in and time out that did not count as hours worked. |
DAY_TEXT |
|
VARCHAR2(254) |
YES |
Name: Day Comments. Description: User-provided notes for day. |
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. |
LUNCH_START_TIME_DTT |
|
DATE |
NO |
Name: Lunch Start Date/Time. Description: The date and time the employee started lunch. |
LUNCH_END_TIME_DTT |
|
DATE |
NO |
Name: Lunch End Date/Time. Description: The date and time the employee ended lunch. |