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 current revision of the timesheet. |
S_STATUS_CD |
|
VARCHAR(1) |
NO |
Name: Status. Description: Status of timesheet. Valid options are as follows: O - Open. S - Signed. A - Approved. P - Processed. R - Rejected |
CLASS_CD |
|
VARCHAR(20) |
NO |
Name: Timesheet Class. Description: The employee class for the employee at the time of this timesheet. |
SHORT_HEADER_TEXT |
|
VARCHAR(4000) |
YES |
Name: Timesheet Notes. Description: Notes about the entire timesheet. |
WORK_SCHEDULE_CD |
|
VARCHAR(10) |
NO |
Name: Work Schedule. Description: The work schedule for the employee at the time of this timesheet. |
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. |
UNAVAILABLE_FL |
|
VARCHAR(1) |
NO |
Name: Unavailable Flag. Description: Logical as to whether this timesheet is unavailable. |
BATCH_ID |
|
VARCHAR(10) |
YES |
Name: Batch ID. Description: The ID of the process that currently has the timesheet unavailable |
CP_COMPANY_CD |
|
VARCHAR(10) |
NO |
Name: Costpoint Company. Description: Costpoint Company Code of timesheet. (Employee) |
SAVE_WARNING_TEXT |
|
VARCHAR(1000) |
YES |
Name: Save Warnings. Description: Warnings received during last timesheet save. |
SIGN_WARNING_TEXT |
|
VARCHAR(1000) |
YES |
Name: Sign Warnings. Description: Warnings received during last timesheet sign. |
OFFLINE_TS_SECURITY_KEY_S |
|
VARCHAR(60) |
YES |
Name: Offline Key. Description: Security key used to validate offline timesheets as being authentic |
OT_DIALOG_CD |
|
VARCHAR(1) |
YES |
Name: Overtime Dialog Response. Description: Stores supervisor selection from OT dialog |
S_START_STOP_TIME_MODE_CD |
|
VARCHAR(10) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
APPROVE_WARNING_TEXT |
|
VARCHAR(1000) |
YES |
|
Key Name |
Key Type |
Keys |
RI_F00039 |
Inversion Entry |
TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
RI_F00038 |
Inversion Entry |
EMPL_ID |
SI_0079 |
Alternate Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, S_STATUS_CD |
SI_0039 |
Inversion Entry |
BATCH_ID, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
RI_F00141 |
Inversion Entry |
CP_COMPANY_CD |
PI_0039 |
PrimaryKey |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
RI_F00041 |
Inversion Entry |
WORK_SCHEDULE_CD |
RI_F00040 |
Inversion Entry |
CLASS_CD |