ISDG
Back to current versionRestore this version

MAINTAIN DEVELOPMENT GOALS#

The Maintain Development Goals ISDG form displays .......

Experience Data is maintained on the P2K_SA_REVIEWS, P2K_SA_GOAL_GROUPS, P2K_SA_DEVELOPMENT_GOALS, and P2K_SA_GOAL_ACTIVITES tables.

Number
Status
Review Phase
Reset Goals Dev
Period From/Period To
These fields define the review period.
Merit Month
Sign Off Received
Assignment
Entity
Submit Goals For
Cancel Review
Show Activities



Review Goals tab#

Competencies
Descriptions
Weight
Overall Point

Goals#

Seq
Job
Description
Start Date
Completion Date
Wgt
EE Rating
MRG Rating



Details tab#

End Date
Goal Status
Category
Competence Origin
Months in Job
Range
Activity Required By
Completion Level
Employee Comments
Manager Comments



Metric#

Metric



Activities#

Start Date
End Date
Review Phase
Comments
Management Only
Comments By
Goal Activity Type
Goal Activity Status



Review Comments tab#

General
Employee
This field allows the employee to add comments regarding the review.
Manager
This field allows the manager to add comments regarding the review.


Notes #

Click to create a new notes page

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYlink to P2K_CM_ENTITIES
REVIEW_NUMBERNumber(10)NUMBER10Y
SRT_IDNumber(10)IDYlink to P2K_SA_REVIEW_TYPES
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
MUS_IDNumber(10)ID link to P2K_AM_USERS
MEX_IDNumber(10)ID link to P2K_AM_EXECUTIONS, originating execution
SMX_IDNumber(10)ID link to P2K_SA_SALARY_MATRICES
REVIEW_STATUSVarchar2(2)X_REVIEW_STATUSY
REVIEW_DATEDate()DATEY
NEXT_REVIEW_DATEDate()DATE
REVIEW_METHODVarchar2(2)X_REVIEW_METHOD
APPROVEDVarchar2(1)TOGGLE
REVIEW_DONE_BYVarchar2(50)DESCRIPTION
OVERALL_RATINGVarchar2(2)X_OVERALL_RATING
OVERALL_POINTSNumber(5)NUMBER5
BASED_ON_PRIOR_JOBVarchar2(1)TOGGLE
DESCRIPTIONVarchar2(50)DESCRIPTION
REVIEW_COMMENTSVarchar2(2000)VARCHAR2000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
MERIT_MONTHSNumber(10)NUMBER10
EE_SIGN_OFFVarchar2(1)TOGGLE
EID_ID_REVIEWERNumber(10)ID link to P2K_HR_IDENTITIES
RASE_IDNumber(10)ID link to P2K_RE_ASSESSMENT_EVENTS
INCENTIVE_PERCENTNumber(5)NUMBER5
REVIEW_PHASEVarchar2(2)X_REVIEW_PHASE
REVIEW_PERIOD_FROMDate()DATE
REVIEW_PERIOD_TODate()DATE
COMMENTS_EEVarchar2(4000)VARCHAR4000
COMMENTS_MGRVarchar2(4000)VARCHAR4000

Derived Fields#

Column Name
DRV_APPROVAL_BAR
DRV_APPROVAL_COMMENTS
DRV_AVERAGE_POINTS
DRV_TOTAL_REVIEW_POINTS
DRV_TOTAL_WEIGHTED_POINTS

GOAL_GROUP_CODEVarchar2(16) Y
SRV_IDNumber(10)IDYlink to P2K_SA_REVIEWS
SRS_IDNumber(10)IDYlink to P2K_SA_RATING_SCALES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
OVERALL_POINTSNumber(5)NUMBER5
GROUP_WEIGHTNumber(5)NUMBER5

SGG_IDNumber(10)IDYlink to P2K_SA_GOAL_GROUPS
DJB_IDNumber(10)IDYlink to P2K_CM_JOBS
GOAL_STATUSVarchar2(2)X_GOAL_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_...
SAR_ID_EENumber(10)ID link to P2K_....
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