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. |
REVISION_NO |
ColumnName | REVISION_NO |
Definition | Name: Revision Number. Description: The current revision of the timesheet. |
S_STATUS_CD |
ColumnName | S_STATUS_CD |
Definition | Name: Status. Description: Status of timesheet. Valid options are as follows: O - Open. S - Signed. A - Approved. P - Processed. R - Rejected |
CLASS_CD |
ColumnName | CLASS_CD |
Definition | Name: Timesheet Class. Description: The employee class for the employee at the time of this timesheet. |
SHORT_HEADER_TEXT |
ColumnName | SHORT_HEADER_TEXT |
Definition | Name: Timesheet Notes. Description: Notes about the entire timesheet. |
WORK_SCHEDULE_CD |
ColumnName | WORK_SCHEDULE_CD |
Definition | Name: Work Schedule. Description: The work schedule for the employee at the time of this timesheet. |
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. |
UNAVAILABLE_FL |
ColumnName | UNAVAILABLE_FL |
Definition | Name: Unavailable Flag. Description: Logical as to whether this timesheet is unavailable. |
BATCH_ID |
ColumnName | BATCH_ID |
Definition | Name: Batch ID. Description: The ID of the process that currently has the timesheet unavailable |
CP_COMPANY_CD |
ColumnName | CP_COMPANY_CD |
Definition | Name: Costpoint Company. Description: Costpoint Company Code of timesheet. (Employee) |
SAVE_WARNING_TEXT |
ColumnName | SAVE_WARNING_TEXT |
Definition | Name: Save Warnings. Description: Warnings received during last timesheet save. |
SIGN_WARNING_TEXT |
ColumnName | SIGN_WARNING_TEXT |
Definition | Name: Sign Warnings. Description: Warnings received during last timesheet sign. |
OFFLINE_TS_SECURITY_KEY_S |
ColumnName | OFFLINE_TS_SECURITY_KEY_S |
Definition | Name: Offline Key. Description: Security key used to validate offline timesheets as being authentic |
OT_DIALOG_CD |
ColumnName | OT_DIALOG_CD |
Definition | Name: Overtime Dialog Response. Description: Stores supervisor selection from OT dialog |
S_START_STOP_TIME_MODE_CD |
ColumnName | S_START_STOP_TIME_MODE_CD |
Definition | Name: Start/Stop Times Mode. Description: Indicates which start/stop time mode was in effect when timesheet was created. The valid options are as follows: DISABLED - Disabled. BREAK – Breaks Only. SUMMARY – Breaks/Summary Work. DETAIL – Breaks/Detail Work |
S_START_STOP_TIME_EDIT_CD |
ColumnName | S_START_STOP_TIME_EDIT_CD |
Definition | Name: Start/Stop Times Edit Type. Description: Indicates which what type of edit is performed during timesheet save routine. The valid options are as follows: N – No Edit. S – Soft Edit. H – Hard Edit |
S_START_STOP_TIME_ROUNDING_CD |
ColumnName | S_START_STOP_TIME_ROUNDING_CD |
Definition | Name: Start/Stop Times Rounding Option. Description: Indicates how the calculated charge hours based on start/stop times should be rounded to the hour increment. The valid options are as follows: U – Round Up. D – Round Down |