P 2 K_SA_DEVELOPMENT_GOALS

Alias: SDG#

(P2K_SA_DEVELOPMENT_GOALS)

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


Reviews

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
SGG_IDNumber(10)IDYlink to P2K_SA_GOAL_GROUPS
DJB_IDNumber(10)IDYlink to P2K_CM_JOBS
GOAL_STATUSVarchar2(2)X_GOAL_ACTIVITY_STATUSY
START_DATEDate()DATEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
END_DATEDate()DATE
SSR_IDNumber(10)ID link to P2K_SA_SALARY_RANGES
CCCL_IDNumber(10)ID link to P2K_CP_COMPETENCE_LEVELS
SAR_ID_MGRNumber(10)ID link to P2K_SA_ACHIEVEMENT_RATINGS
SAR_ID_EENumber(10)ID link to P2K_SA_ACHIEVEMENT_RATINGS
REVIEW_CATEGORYVarchar2(2)X_REVIEW_CATEGORY
DESCRIPTIONVarchar2(50)DESCRIPTION
COMMENTSVarchar2(4000)VARCHAR4000
COMMENTS_BY_MANAGERVarchar2(4000)VARCHAR4000
COMPLETION_DATEDate()DATE
GROUP_WEIGHTNumber(5)NUMBER5
MONTHS_IN_JOBNumber(5)NUMBER5
COMPLETION_LEVELVarchar2(2)X_COMPLETION_LEVEL
ACTIVITY_REQUIRED_BYDate()DATE
METRICVarchar2(4000)VARCHAR4000
GOAL_SEQUENCENumber(5)NUMBER5
EID_IDNumber(10)IDYlink to P2K_SA_GOAL_GROUPS

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page