Alias: CDP#

(P2K_CP_DEVELOPMENT_PROGRAMS)

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


Development Programs

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)ID link to P2K_CM_ENTITIES
CTS_IDNumber(10)ID link to P2K_CP_TRAINING_SUPPLIERS
PROGRAM_CODEVarchar2(16)CODEY
COMPETENCE_GROUPVarchar2(2)X_COMPETENCE_GROUPY
PROGRAM_STATUSVarchar2(2)X_PROGRAM_STATUSY
APPROVEDVarchar2(1)TOGGLE
PROGRAM_TYPEVarchar2(2)X_PROGRAM_TYPE
PROGRAM_CATEGORYVarchar2(2)X_PROGRAM_CATEGORY
PROGRAM_TITLEVarchar2(50)DESCRIPTION
FONT_HTMLVarchar2(2000)VARCHAR2000
WEB_ADDRESSVarchar2(200)URL
PROGRAM_START_DATEDate()DATE
PROGRAM_END_DATEDate()DATE
PROGRAM_BUDGETNumber(18)AMT12V6
CURRENCYVarchar2(2)X_CURRENCY
SPONSORVarchar2(50)DESCRIPTION
OBJECTIVESVarchar2(4000)VARCHAR4000
AUDIENCEVarchar2(4000)VARCHAR4000
PREREQUISITESVarchar2(4000)VARCHAR4000
COMPLETION_CRITERIAVarchar2(4000)VARCHAR4000
PROGRAM_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

Derived Fields#

Column Name
DRV_APPROVAL_BAR

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page