Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
EMPL_ID |
|
VARCHAR(20) |
NO |
Name: Employee ID. Description: Employee ID identifier. |
TS_SCHEDULE_CD |
|
VARCHAR(10) |
NO |
Name: Timesheet Schedule. Description: Timesheet frequency identifier. |
YEAR_NO_CD |
|
VARCHAR(4) |
NO |
|
PERIOD_NO_CD |
|
VARCHAR(3) |
NO |
Name: Period Number. Description: Period number for timesheet frequency. |
REVISION_NO |
|
NUMERIC(10, 0) |
NO |
Name: Revision Number. Description: The identifying revision number for this timesheet revision. |
SIGN_EMPL_ID |
|
VARCHAR(20) |
YES |
Name: Sign Employee ID. Description: Employee ID of person who signed timesheet. |
SIGN_DTT |
|
DATE |
YES |
Name: Sign Date/Time. Description: Date and time timesheet was signed. |
APPROVE_FL |
|
VARCHAR(1) |
NO |
Name: Approved Flag. Description: Logical as to whether this revision of the timesheet has been approved. |
APPROVE_EMPL_ID |
|
VARCHAR(20) |
YES |
Name: Approve Employee ID. Description: The Employee ID of the person who approved the timesheet. |
APPROVE_DTT |
|
DATE |
YES |
Name: Approve Date/Time. Description: Date and time the timesheet was approved. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(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. |
EXPLANATION_TEXT |
|
VARCHAR(254) |
YES |
Name: Revision Explanation. Description: User-provided explanations for the timesheet revision. |