EVENT_CD |
ColumnName | EVENT_CD |
Definition | Name: Event. Description: The event unique identifier. |
ACTIVE_FL |
ColumnName | ACTIVE_FL |
Definition | Name: Active Flag. Description: Logical as to whether this event is active. |
S_INIT_PRIORITY_CD |
ColumnName | S_INIT_PRIORITY_CD |
Definition | Name: Initial Priority. Description: The initial priority for the event. The valid values areL - Low. M - Medium. H - High. |
MED_PRIORITY_DAYS |
ColumnName | MED_PRIORITY_DAYS |
Definition | Name: Number of Days to Medium Priority. Description: The number of days that need to expire before event is upgraded to medium priority. |
MED_PRIORITY_HRS |
ColumnName | MED_PRIORITY_HRS |
Definition | Name: Number of Hours to Medium Priority. Description: The number of hours that need to expire before event is upgraded to medium priority. |
MED_PRIORITY_MINS |
ColumnName | MED_PRIORITY_MINS |
Definition | Name: Number of Minutes to Medium Priority. Description: The number of minutes that need to expire before event is upgraded to medium priority. |
HIGH_PRIORITY_DAYS |
ColumnName | HIGH_PRIORITY_DAYS |
Definition | Name: Number of Days to High Priority. Description: The number of days that need to expire before event is upgraded to high priority. |
HIGH_PRIORITY_HRS |
ColumnName | HIGH_PRIORITY_HRS |
Definition | Name: Number of Hours to High Priority. Description: The number of hours that need to expire before event is upgraded to high priority. |
HIGH_PRIORITY_MINS |
ColumnName | HIGH_PRIORITY_MINS |
Definition | Name: Number of Minutes to High Priority. Description: The number of minutes that need to expire before event is upgraded to high priority. |
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. |
EVENT_DESC |
ColumnName | EVENT_DESC |
Definition | Name: Event Description. Description: The description of the event. |
S_ACTION_CD |
ColumnName | S_ACTION_CD |
Definition | Name: Action. Description: The action performed for the event. The valid values are:OPENTS - Open Timesheet. SAVEREGTS - Save Regular Timesheet . SAVECORTS - Save Correcting Timesheet. SIGNREGTS - Sign Regular Timesheet . SIGNCORTS - Sign Correcting Timesheet. APPREGTS - Approve Regular Timesheet . APPCORTS - Approve Correcting Timesheet. REJREGTS - Reject Regular Timesheet . REJCORTS - Reject Correcting Timesheet. FLOORCHK - Floor Check. MISSSTAT - Missing Timesheet at Status . OPENSTAT - Open Timesheet at Status. SIGNSTAT - Signed Timesheet at Status . REJREGHRS – Reject Regular Timesheet Hours . REJCORHRS – Reject Correcting Timesheet Hours. RECSTAT – Expense Report Receipts Missing at Status Check. DRAFTSTAT – Expense Report Draft at Status Check. REVIEWSTAT – Expense Report In Review at Status Check. ERPAYMENT – Expense Report Paid. REJER – Reject Expense Report. REQUESTVAC – Requested Vacation. APPVAC – Approve Vacation Request. REJVAC – Reject Vacation Request . REJER – Reject Expense Report. REJEXP – Reject Expense Report Expense. |
FUNCTIONAL_ROLE_CD |
ColumnName | FUNCTIONAL_ROLE_CD |
Definition | Name: Functional Role. Description: The functional role of the supervisor/owner. |
S_EVENT_TYPE_CD |
ColumnName | S_EVENT_TYPE_CD |
Definition | Name: Event Type. Description: The type of event. The valid values are:T – Timesheet. E – Expense Report. S - Schedule. |