Alias: TTX#

(P2K_TS_TIME_EXCEPTIONS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-TS32


Time Exceptions

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
TTP_IDNumber(10)ID link to P2K_TS_TEAM_POSTS
EAS_IDNumber(10)ID link to P2K_HR_ASSIGNMENTS
DTC_IDNumber(10)ID link to P2K_CM_TIME_CODES
TSS_IDNumber(10)ID link to P2K_TS_SHIFTS
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS
AAL_IDNumber(10)ID link to P2K_AT_LEAVE_LINES
TIME_EXCEPTION_STATUSVarchar2(2)X_TIME_EXCEPTION_STATUSY
TIME_EXCEPTION_TYPEVarchar2(2)X_TIME_EXCEPTION_TYPEY
START_DATEDate()DATEY
END_DATEDate()DATE
START_TIMENumber(5)MINUTES
END_TIMENumber(5)MINUTES
REASON_FOR_TIMEVarchar2(2)X_REASON_FOR_TIME
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
REFERENCE_INFOVarchar2(2000)VARCHAR2000
AUDIT_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
TSH_IDNumber(10)ID link to P2K_TS_SCHEDULED_SHIFTS
DDP_IDNumber(10)ID link to P2K_CM_DEPARTMENTS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
DJB_IDNumber(10)ID link to P2K_CM_JOBS
TIME_EXCEPTION_VALUENumber(18)AMT12V6
WORK_ORDERVarchar2(50)VARCHAR50
TIME_EXCEPTION_SOURCEVarchar2(2)X_TIME_EXCEPTION_SOURCE
PTS_IDNumber(10)ID link to P2K_PR_TIME_SHEETS
TIME_EXCEPTION_ACTIONVarchar2(2)X_TIME_EXCEPTION_ACTION
TES_IDNumber(10)ID link to P2K_TS_EVENT_SITES
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
TTXT_IDNumber(10)ID link to P2K_TS_TIME_EXCEPTION_CONTROLS
TRT_IDNumber(10)ID link to P2K_TS_TIME_RULE_TYPES
AUTHORIZATION_STATUSVarchar2(2)X_AUTHORIZATION_STATUS

Derived Fields#

Column Name
DRV_SORT_ORDER

User Fields: Allowed
Audit Logging: Not Allowed

This particular version was published on 26-Nov-2021 10:22 by JEscott.Top