This page (revision-24) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
24 26-Nov-2021 10:22 3 KB jmyers to previous
23 26-Nov-2021 10:22 3 KB jmyers to previous | to last
22 26-Nov-2021 10:22 3 KB jmyers to previous | to last
21 26-Nov-2021 10:22 3 KB jmyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 4 changed one line
The Maintain Development Goals (ISDG) form displays .......
The Maintain Development Goals ISDG form displays .......
At line 6 changed one line
Maintain Development Goals is maintained on the [P2K_SA_REVIEWS], [P2K_SA_GOAL_GROUPS], [P2K_SA_DEVELOPMENT_GOALS] and [P2K_SA_GOAL_ACTIVITES] tables.
Experience Data is maintained on the [P2K_SA_REVIEWS], [P2K_SA_GOAL_GROUPS], [P2K_SA_DEVELOPMENT_GOALS], and [P2K_SA_GOAL_ACTIVITES] tables.
At line 8 changed 4 lines
;[Number|REVIEW_NUMBER]:This field indicates the identifying number of the review.
;[Status|REVIEW_STATUS]:The status of the review is listed in this field.
;[Review Phase|REVIEW_PHASE]:The current phase of the review is listed in this field.
;[Reset Goals Dev| ]:This button allows you to reset the development goals.
;[Number|REVIEW_NUMBER]:
;[Status|REVIEW_STATUS]:
;[Review Phase|REVIEW_PHASE]:
;[Reset Goals Dev| ]:
At line 14 changed 6 lines
;[Sign Off Received| ]:If this is toggled, the sign off has been received.
;[Assignment|ASSIGNMENT_CODE]:This field displays the assignment associated with the development goals.
;[Entity|ENTITY]:This field displays the entity associated with the development goals.
;[Submit Goals For| ]:This button allows you to submit the development goals.
;[Cancel Review| ]:This button allows you to cancel the review.
;[Show Activities| ]:This button will show the activities associated with the development goals.
;[Sign Off Received| ]:
;[Assignment|ASSIGNMENT_CODE]:
;[Entity|ENTITY]:
;[Submit Goals For| ]:
;[Cancel Review| ]:
;[Show Activities| ]:
At line 23 changed 4 lines
;[Competencies|COMPETENCE_CODE]:The competencies related to the goal are listed here.
;[Descriptions|DESCRIPTION]:A description of the competency is provided in this field
;[Weight|GROUP_WEIGHT]:The weight of the competency is listed in this field.
;[Overall Point|OVERALL_POINTS]:The overall points of the competency for the goal are displayed in this field.
;[Competencies| ]:
;[Descriptions| ]:
;[Weight| ]:
;[Overall Point|]:
At line 29 changed 8 lines
;[Seq|GOAL_SEQUENCE]:The numerical sequence of the goals are listed in this field.
;[Job|JOB_CODE]:The job associated with the goal is listed in this field.
;[Description|DESCRIPTION]:A description of the goal is provided in this field.
;[Start Date|START_DATE]:The start date of the goal is listed in this field.
;[Completion Date|COMPLETION_DATE]:The completion date of the goal is listed in this field.
;[Wgt|GROUP_WEIGHT]:The weight of the goal is listed in this field.
;[EE Rating|SAR_ID_EE]:
;[MRG Rating|SAR_ID_MGR]:
;[Seq|GOAL_SEQUENCE]:
;[Job| ]:
;[Description| ]:
;[Start Date| ]:
;[Completion Date| ]:
;[Wgt| ]:
;[EE Rating| ]:
;[MRG Rating| ]:
At line 40 changed 10 lines
;[End Date|END_DATE]:
;[Goal Status|GOAL_STATUS]:
;[Category|CATEGORY_CODE]:
;[Competence Origin| ]:
;[Months in Job|MONTHS_IN_JOB]:
;[Range|SSR_ID]:
;[Activity Required By|ACTIVITY_REQUIRED_BY]:
;[Completion Level|COMPLETION_LEVEL]:
;[Employee Comments|COMMENTS_EE]:
;[Manager Comments|COMMENTS_MGR]:
;[End Date| ]:
;[Goal Status| ]:
;[Category| ]:
;[Competence Origin| ]:
;[Months in Job| ]:
;[Range| ]:
;[Activity Required By| ]:
;[Completion Level| ]:
;[Employee Comments| ]:
;[Manager Comments| ]:
At line 53 changed one line
;[Metric|METRIC]:
;[Metric| ]:
At line 57 changed 8 lines
;[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]:
;[Start Date| ]:
;[End Date| ]:
;[Review Phase| ]:
;[Comments| ]:
;[Management Only| ]:
;[Comments By| ]:
;[Goal Activity Type| ]:
;[Goal Activity Status| ]:
At line 68 changed one line
;[General|COMMENTS]:
;[General| ]:
At line 72 added one line
At line 76 removed one line
[CLEANUP]
At line 78 added 94 lines
||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]||