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
ISDG
ISDG

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
Experience Data is maintained on the [P2K_SA_REVIEWS], [P2K_SA_GOAL_GROUPS], [P2K_SA_DEVELOPMENT_GOALS], and [P2K_SA_GOAL_ACTIVITES] tables.
Maintain Development Goals 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]:
;[Status|REVIEW_STATUS]:
;[Review Phase|REVIEW_PHASE]:
;[Reset Goals Dev| ]:
;[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.
At line 14 changed 6 lines
;[Sign Off Received| ]:
;[Assignment|ASSIGNMENT_CODE]:
;[Entity|ENTITY]:
;[Submit Goals For| ]:
;[Cancel Review| ]:
;[Show Activities| ]:
;[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.
At line 23 changed 4 lines
;[Competencies| ]:
;[Descriptions|DESCRIPTION]:
;[Weight|GROUP_WEIGHT]:
;[Overall Point|OVERALL_POINTS]:
;[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.
At line 29 changed 8 lines
;[Seq|GOAL_SEQUENCE]:
;[Job|JOB_CODE]:
;[Description|DESCRIPTION]:
;[Start Date|START_DATE]:
;[Completion Date|COMPLETION_DATE]:
;[Wgt|GROUP_WEIGHT]:
;[EE Rating| ]:
;[MRG Rating| ]:
;[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]:
At line 40 changed 10 lines
;[End Date| ]:
;[Goal Status| ]:
;[Category| ]:
;[Competence Origin| ]:
;[Months in Job| ]:
;[Range| ]:
;[Activity Required By| ]:
;[Completion Level| ]:
;[Employee Comments| ]:
;[Manager Comments| ]:
;[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]:
At line 53 changed one line
;[Metric| ]:
;[Metric|METRIC]:
At line 57 changed 2 lines
;[Start Date| ]:
;[End Date| ]:
;[Start Date|START_DATE]:
;[End Date|END_DATE]:
At line 60 changed one line
;[Comments| ]:
;[Comments|COMMENTS]:
At line 62 changed one line
;[Comments By| ]:
;[Comments By|COMMENTS_BY_MANAGER]:
At line 68 changed one line
;[General| ]:
;[General|COMMENTS]:
At line 72 removed one line
At line 76 added one line
[CLEANUP]
At line 78 removed 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]||
This page (revision-24) was last changed on 26-Nov-2021 10:22 by jmyersTop