P 2 K_CM_DEPARTMENTS

Alias: DDP#

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

Department code and standing.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEPARTMENT_CODEVarchar2(16)CODEY
DEN_ID_LEGALNumber(10)IDYlink to P2K_CM_ENTITIES
DEN_ID_SUB_DIVISIONNumber(10)IDYlink to P2K_CM_ENTITIES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
STANDINGVarchar2(2)X_STANDING
GENERIC_CODEVarchar2(16)CODE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page