P 2 K_TS_TIME_RULES

Alias: TRL#

(P2K_TS_TIME_RULES)

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


Time Rules

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DWRD_IDNumber(10)IDYlink to P2K_CM_WORK_RULE_DETAILS
TRT_IDNumber(10)IDYlink to P2K_TS_TIME_RULE_TYPES
SPM_IDNumber(10)ID link to P2K_SA_PREMIUMS
DTC_IDNumber(10)ID link to P2K_CM_TIME_CODES
MUC_IDNumber(10)ID link to P2K_AM_USER_CALCS
QUALIFYING_BANDNumber(9)AMT5V4Y
TIME_RULE_ACTIONVarchar2(2)X_TIME_RULE_ACTIONY
TIME_RULE_VALUENumber(18)AMT12V6
FROM_CLOCK_TIMENumber(5)MINUTES
TO_CLOCK_TIMENumber(5)MINUTES
GENERATE_WARNINGVarchar2(1)TOGGLE
MESSAGE_TEXTVarchar2(2000)VARCHAR2000
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
TRACE_LEVELVarchar2(1)X_TRACE_LEVEL
DTCS_ID_TARGETNumber(10)ID link to P2K_CM_TIME_CODE_SETS
CAN_BE_WAIVEDVarchar2(1)TOGGLE
PROCESSING_SEQUENCENumber(5)NUMBER5
DAY_OF_WEEKVarchar2(3)X_DAY_OF_WEEK
DISABLE_RULEVarchar2(1)TOGGLE
DTCS_ID_APPLYNumber(10)ID link to P2K_CM_TIME_CODE_SETS
CYCLE_NUMBERNumber(5)NUMBER5

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page