[{TableOfContents }] !!!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|REVIEW_NUMBER]: ;[Status|REVIEW_STATUS]: ;[Review Phase|REVIEW_PHASE]: ;[Reset Goals Dev| ]: ;[Period From|REVIEW_PERIOD_FROM]/[Period To|REVIEW_PERIOD_TO]: These fields define the review period. ;[Merit Month|MERIT_MONTHS]: ;[Sign Off Received| ]: ;[Assignment|ASSIGNMENT_CODE]: ;[Entity|ENTITY]: ;[Submit Goals For| ]: ;[Cancel Review| ]: ;[Show Activities| ]: \\ \\ ---- !!Review Goals tab ;[Competencies| ]: ;[Descriptions|DESCRIPTION]: ;[Weight|GROUP_WEIGHT]: ;[Overall Point|OVERALL_POINTS]: !Goals ;[Seq|GOAL_SEQUENCE]: ;[Job|JOB_CODE]: ;[Description|DESCRIPTION]: ;[Start Date|START_DATE]: ;[Completion Date|COMPLETION_DATE]: ;[Wgt|GROUP_WEIGHT]: ;[EE Rating| ]: ;[MRG Rating| ]: \\ \\ ---- !Details tab ;[End Date|END_DATE]: ;[Goal Status| ]: ;[Category| ]: ;[Competence Origin| ]: ;[Months in Job| ]: ;[Range| ]: ;[Activity Required By|ACTIVITY_REQUIRED_BY]: ;[Completion Level|COMPLETION_LEVEL]: ;[Employee Comments| ]: ;[Manager Comments| ]: \\ \\ ---- !Metric ;[Metric|METRIC]: \\ \\ ---- !Activities ;[Start Date|START_DATE]: ;[End Date|END_DATE]: ;[Review Phase|REVIEW_PHASE]: ;[Comments|COMMENTS]: ;[Management Only|MANAGEMENT_ONLY]: ;[Comments By|COMMENTS_BY_MANAGER]: ;[Goal Activity Type|GOAL_ACTIVITY_TYPE]: ;[Goal Activity Status|GOAL_ACTIVITY_STATUS]: \\ \\ ---- !!Review Comments tab ;[General|COMMENTS]: ;[Employee|COMMENTS_EE]:This field allows the employee to add comments regarding the review. ;[Manager|COMMENTS_MGR]:This field allows the manager to add comments regarding the review. ---- ![Notes|Edit:Internal.ISDG] [{InsertPage page='Internal.ISDG' default='Click to create a new notes page'}] ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[DEN_ID]|Number(10)|[ID]|Y|link to [P2K_CM_ENTITIES] |[REVIEW_NUMBER]|Number(10)|[NUMBER10|NUMBERn]|Y| |[SRT_ID]|Number(10)|[ID]|Y|link to [P2K_SA_REVIEW_TYPES] |[EAS_ID]|Number(10)|[ID]|Y|link to [P2K_HR_ASSIGNMENTS] |[MUS_ID]|Number(10)|[ID]| |link to [P2K_AM_USERS] |[MEX_ID]|Number(10)|[ID]| |link to [P2K_AM_EXECUTIONS], originating execution |[SMX_ID]|Number(10)|[ID]| |link to [P2K_SA_SALARY_MATRICES] |[REVIEW_STATUS]|Varchar2(2)|[X_REVIEW_STATUS]|Y| |[REVIEW_DATE]|Date()|[DATE]|Y| |[NEXT_REVIEW_DATE]|Date()|[DATE]| | |[REVIEW_METHOD]|Varchar2(2)|[X_REVIEW_METHOD]| | |[APPROVED]|Varchar2(1)|[TOGGLE]| | |[REVIEW_DONE_BY]|Varchar2(50)|[DESCRIPTION]| | |[OVERALL_RATING]|Varchar2(2)|[X_OVERALL_RATING]| | |[OVERALL_POINTS]|Number(5)|[NUMBER5|NUMBERn]| | |[BASED_ON_PRIOR_JOB]|Varchar2(1)|[TOGGLE]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[REVIEW_COMMENTS]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[MERIT_MONTHS]|Number(10)|[NUMBER10|NUMBERn]| | |[EE_SIGN_OFF]|Varchar2(1)|[TOGGLE]| | |[EID_ID_REVIEWER]|Number(10)|[ID]| |link to [P2K_HR_IDENTITIES] |[RASE_ID]|Number(10)|[ID]| |link to [P2K_RE_ASSESSMENT_EVENTS] |[INCENTIVE_PERCENT]|Number(5)|[NUMBER5|NUMBERn]| | |[REVIEW_PHASE]|Varchar2(2)|[X_REVIEW_PHASE]| | |[REVIEW_PERIOD_FROM]|Date()|[DATE]| | |[REVIEW_PERIOD_TO]|Date()|[DATE]| | |[COMMENTS_EE]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[COMMENTS_MGR]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | !![Derived Fields|DERIVED FIELDS] ||Column Name |[DRV_APPROVAL_BAR] |[DRV_APPROVAL_COMMENTS] |[DRV_AVERAGE_POINTS] |[DRV_TOTAL_REVIEW_POINTS] |[DRV_TOTAL_WEIGHTED_POINTS] |[GOAL_GROUP_CODE]|Varchar2(16)| |Y| |[SRV_ID]|Number(10)|[ID]|Y|link to [P2K_SA_REVIEWS] |[SRS_ID]|Number(10)|[ID]|Y|link to [P2K_SA_RATING_SCALES] |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[OVERALL_POINTS]|Number(5)|[NUMBER5|NUMBERn]| | |[GROUP_WEIGHT]|Number(5)|[NUMBER5|NUMBERn]| | |[SGG_ID]|Number(10)|[ID]|Y|link to [P2K_SA_GOAL_GROUPS] |[DJB_ID]|Number(10)|[ID]|Y|link to [P2K_CM_JOBS] |[GOAL_STATUS]|Varchar2(2)|[X_GOAL_STATUS]|Y | |[START_DATE]|Date()|[DATE]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[END_DATE]|Date()|[DATE]| | |[SSR_ID]|Number(10)|[ID]| |link to [P2K_SA_SALARY_RANGES] |[CCCL_ID]|Number(10)|[ID]| |link to [P2K_CP_COMPETENCE_LEVELS] |[SAR_ID_MGR]|Number(10)|[ID]| |link to [P2K_...] |[SAR_ID_EE]|Number(10)|[ID]| |link to [P2K_....] |[REVIEW_CATEGORY]|Varchar2(2)|[X_REVIEW_CATEGORY]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[COMMENTS]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[COMMENTS_BY_MANAGER]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[COMPLETION_DATE]|Date()|[DATE]| | |[GROUP_WEIGHT]|Number(5)|[NUMBER5|NUMBERn]| | |[MONTHS_IN_JOB]|Number(5)|[NUMBER5|NUMBERn]| | |[COMPLETION_LEVEL]|Varchar2(2)|[X_COMPLETION_LEVEL]| | |[ACTIVITY_REQUIRED_BY]|Date()|[DATE]| | |[METRIC]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[GOAL_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[EID_ID]|Number(10)|[ID]|Y|link to [P2K_SA_GOAL_GROUPS] |[ID]|Number(10)|[ID]|Y| |[EID_ID]|Number(10)|[ID]|Y|link to [P2K_CM_ENTITIES] |[GOAL_ACTIVITY_STATUS]|Varchar2(2)|[X_GOAL_ACTIVITY_STATUS]|Y| |[GOAL_ACTIVITY_TYPE]|Varchar2(2)|[X_GOAL_ACTIVITY_TYPE]| | |[START_DATE]|Date()|[DATE]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[END_DATE]|Date()|[DATE]| | |[COMMENTS]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[MANAGEMENT_ONLY]|Varchar2(1)|[TOGGLE]| | |[REVIEW_STATUS]|Varchar2(2)|[X_REVIEW_STATUS]||