Alias: TWT#

(P2K_TS_WORK_TEAMS)

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


Work Teams

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
TSP_IDNumber(10)IDYlink to P2K_TS_SHIFT_PATTERNS
TWS_IDNumber(10)IDYlink to P2K_TS_WORK_STATIONS
WORK_TEAM_CODEVarchar2(16)CODEY
RELATIVE_START_DAYNumber(5)NUMBER5Y
START_DATEDate()DATEY
END_DATEDate()DATE
DESCRIPTIONVarchar2(50)DESCRIPTION
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed