!!!Alias: CDP (P2K_CP_DEVELOPMENT_PROGRAMS) Unique Keys: \\ Child Table: \\ Parent Table: \\ ERD:[ERD-CP03] \\ Development Programs !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[DEN_ID]|Number(10)|[ID]| |link to [P2K_CM_ENTITIES] |[CTS_ID]|Number(10)|[ID]| |link to [P2K_CP_TRAINING_SUPPLIERS] |[PROGRAM_CODE]|Varchar2(16)|[CODE]|Y| |[COMPETENCE_GROUP]|Varchar2(2)|[X_COMPETENCE_GROUP]|Y| |[PROGRAM_STATUS]|Varchar2(2)|[X_PROGRAM_STATUS]|Y| |[APPROVED]|Varchar2(1)|[TOGGLE]| | |[PROGRAM_TYPE]|Varchar2(2)|[X_PROGRAM_TYPE]| | |[PROGRAM_CATEGORY]|Varchar2(2)|[X_PROGRAM_CATEGORY]| | |[PROGRAM_TITLE]|Varchar2(50)|[DESCRIPTION]| | |[FONT_HTML]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[WEB_ADDRESS]|Varchar2(200)|[URL]| | |[PROGRAM_START_DATE]|Date()|[DATE]| | |[PROGRAM_END_DATE]|Date()|[DATE]| | |[PROGRAM_BUDGET]|Number(18)|[AMT12V6|AMTnn]| | |[CURRENCY]|Varchar2(2)|[X_CURRENCY]| | |[SPONSOR]|Varchar2(50)|[DESCRIPTION]| | |[OBJECTIVES]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[AUDIENCE]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[PREREQUISITES]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[COMPLETION_CRITERIA]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[PROGRAM_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| !![Derived Fields|DERIVED FIELDS] ||Column Name |[DRV_APPROVAL_BAR] User Fields: Allowed\\ Audit Logging: Allowed\\ ---- ![Notes|Edit:Internal.P2K_CP_DEVELOPMENT_PROGRAMS] [{InsertPage page='Internal.P2K_CP_DEVELOPMENT_PROGRAMS' default='Click to create a new notes page'}]