This page (revision-6) 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
6 26-Nov-2021 10:22 1 KB jmyers to previous
5 26-Nov-2021 10:22 1018 bytes jmyers to previous | to last
4 26-Nov-2021 10:22 1018 bytes jmyers to previous | to last
3 26-Nov-2021 10:22 1018 bytes jmyers to previous | to last
2 26-Nov-2021 10:22 975 bytes jmyers to previous | to last
1 26-Nov-2021 10:22 2 KB jmyers to last

Page References

Incoming links Outgoing links
P 2 K_SA_GOAL_ACTIVITES
P2K_SA_GOAL_ACTIVITES

Version management

Difference between version and

At line 1 changed one line
!!!Alias: SGA
!!!Alias: SRV
At line 6 changed 2 lines
Parent Table: [P2K_SA_DEVELOPMENT_GOALS]\\
ERD: [ERD-SA08]
Parent Table:\\
ERD: [ERD-SA04]
At line 10 changed one line
Goal Activities
Reviews
At line 19 changed one line
|[START_DATE]|Date()|[DATE]|Y|
|[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 24 changed 4 lines
|[END_DATE]|Date()|[DATE]| |
|[COMMENTS]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[MANAGEMENT_ONLY]|Varchar2(1)|[TOGGLE]| |
|[REVIEW_STATUS]|Varchar2(2)|[X_REVIEW_STATUS]||
|[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 55 added 9 lines
!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_APPROVAL_BAR]
|[DRV_APPROVAL_COMMENTS]
|[DRV_AVERAGE_POINTS]
|[DRV_TOTAL_REVIEW_POINTS]
|[DRV_TOTAL_WEIGHTED_POINTS]
This page (revision-6) was last changed on 26-Nov-2021 10:22 by jmyersTop