P 2 K_TS_TEAM_POST_DETAILS
Back to current versionRestore this version

Alias: TTPD#

Unique Keys: _
Child Table:
_
Parent Table: _

Team Post Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
TTP_IDNumber(10)IDYlink to P2K_TS_TEAM_POSTS
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
EAS_IDNumber(10)ID link to P2K_HR_ASSIGNMENTS
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
ASSIGNED_WSENumber(16)AMT12V4Y
START_TIMENumber(5)MINUTES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
TSP_IDNumber(10)ID link to P2K_TS_SHIFT_PATTERNS
SHIFT_PATTERN_START_DATEDate()DATE
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS

User Fields: Allowed
Audit Logging: Allowed