This page (revision-9) 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
9 26-Nov-2021 10:22 932 bytes jmyers to previous
8 26-Nov-2021 10:22 935 bytes jmyers to previous | to last
7 26-Nov-2021 10:22 906 bytes jmyers to previous | to last
6 26-Nov-2021 10:22 910 bytes jmyers to previous | to last
5 26-Nov-2021 10:22 2 KB jmyers to previous | to last
4 26-Nov-2021 10:22 2 KB jmyers to previous | to last
3 26-Nov-2021 10:22 2 KB jmyers to previous | to last
2 26-Nov-2021 10:22 2 KB jmyers to previous | to last P2K_GOAL_GROUPS ==> P2K_SA_GOAL_GROUPS
1 26-Nov-2021 10:22 2 KB jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 5 changed one line
Child Table:[P2K_SA_DEVELOPMENT_GOALS]\\
Child Table: \\
At line 10 changed one line
Goal Groups
Reviews
At line 16 changed 3 lines
|[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]
|[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]| |
At line 23 changed 3 lines
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[OVERALL_POINTS]|Number(7)|[AMT5V2|AMTnn]| |
|[GROUP_WEIGHT]|Number(5)|[NUMBER5|NUMBERn]| |
|[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]| |
At line 49 added 10 lines
!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_APPROVAL_BAR]
|[DRV_APPROVAL_COMMENTS]
|[DRV_AVERAGE_POINTS]
|[DRV_TOTAL_REVIEW_POINTS]
|[DRV_TOTAL_WEIGHTED_POINTS]
At line 62 added one line
At line 31 changed 2 lines
![Notes|Edit:Internal.P2K_SA_GOAL_GROUPS]
[{InsertPage page='Internal.P2K_SA_GOAL_GROUPS' default='Click to create a new notes page'}]
![Notes|Edit:Internal.P2K_SA_REVIEWS]
[{InsertPage page='Internal.P2K_SA_REVIEWS' default='Click to create a new notes page'}]