P 2 K_CP_DEVELOPMENT_ACTIVITIES
Back to current versionRestore this version

Alias: CDA#

(P2K_CP_DEVELOPMENT_ACTIVITIES)

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


Development Activities

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
CRS_IDNumber(10)ID link to P2K_CP_COURSES
CDP_IDNumber(10)ID link to P2K_CP_DEVELOPMENT_PROGRAMS
RCA_IDNumber(10)ID link to P2K_RE_CANDIDATES
CDPS_IDNumber(10)ID link to P2K_CP_PROGRAM_STEPS
RAS_IDNumber(10)ID link to P2K_RE_ASSESSMENTS
ACTIVITY_SEQUENCENumber(5)NUMBER5Y
ACTIVITY_STATUSVarchar2(2)X_ACTIVITY_STATUSY
APPROVEDVarchar2(1)TOGGLE
ACTIVITY_TYPEVarchar2(2)X_ACTIVITY_TYPE
ACTIVITY_CATEGORYVarchar2(2)X_ACTIVITY_CATEGORY
DESCRIPTIONVarchar2(50)DESCRIPTION
ACTIVITY_START_DATEDate()DATE
ACTIVITY_END_DATEDate()DATE
DURATIONNumber(9)AMT5V4
DURATION_BASISVarchar2(2)X_PERIOD_BASIS
BUDGET_AMOUNTNumber(18)AMT12V6
ACTUAL_AMOUNTNumber(18)AMT12V6
CURRENCYVarchar2(2)X_CURRENCY
ACTIVITY_TEXTVarchar2(4000)VARCHAR4000
COMPETENCY_RATINGVarchar2(2)X_COMPETENCY_RATING
DESIGNATED_SUCCESSORVarchar2(1)TOGGLE
LOSS_IMPACTVarchar2(1)TOGGLE
PLAN_POTENTIALVarchar2(1)TOGGLE
SUCCESSION_READINESS Varchar2(2)X_SUCCESSION_READINESS
SUCCESSION_RANKING Number(5)TOGGLE
SUCCESSION_STATUSVarchar2(2)X_SUCCESSION_STATUS

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation