Alias: CCC#

(P2K_CP_CORE_COMPETENCIES)

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


Core Competencies

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
CCG_IDNumber(10)IDYlink to P2K_CP_COMPETENCE_CATEGORIES
COMPETENCE_CODEVarchar2(16)CODEY
DESCRIPTIONVarchar2(50)DESCRIPTION
COMPETENCE_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
SRS_IDNUMBER(10,0) ID
COMPETENCE_WEIGHTNUMBER(5,0) NUMBER5
COMPETENCE_STATUSVARCHAR2(2) X_COMPETENCE_STATUS

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page