P 2 K_CP_COMPETENCE_USAGES
Back to current versionRestore this version

Alias: CCCU#

(P2K_CP_COMPETENCE_USAGES)

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


Competence Usages

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
CCCL_IDNumber(10)IDYlink to P2K_CP_COMPETENCE_LEVELS
RJP_IDNumber(10)ID link to P2K_RE_JOB_PROFILES
RCA_IDNumber(10)ID link to P2K_RE_CANDIDATES
RAS_IDNumber(10)ID link to P2K_RE_ASSESSMENTS
CDP_ID_DEVELOPNumber(10)ID link to P2K_CP_DEVELOPMENT_PROGRAMS
CDP_ID_REQUIRENumber(10)ID link to P2K_CP_DEVELOPMENT_PROGRAMS
CRS_ID_DEVELOPNumber(10)ID link to P2K_CP_COURSES
CRS_ID_REQUIRENumber(10)ID link to P2K_CP_COURSES
CDPS_IDNumber(10)ID link to P2K_CP_PROGRAM_STEPS
CDA_IDNumber(10)ID link to P2K_CP_DEVELOPMENT_ACTIVITIES
CONFIRMED_STATUSVarchar2(2)X_CONFIRMED_STATUSY
DATE_CONFIRMEDDate()DATE
CONFIRMATION_BYVarchar2(4000)VARCHAR4000
START_DATEDate()DATE
END_DATEDate()DATE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page