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

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

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 2 KB khiggs to previous
5 26-Nov-2021 10:22 2 KB jmyers to previous | to last
4 26-Nov-2021 10:22 1 KB rforbes to previous | to last
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last
2 26-Nov-2021 10:22 1 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB RForbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 2 changed 3 lines
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
(P2K_SA_REVIEWS)
Unique Keys: \\
Child Table: \\
Parent Table:\\
ERD: [ERD-SA04]
At line 11 removed 12 lines
|[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]
|[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]| |
At line 24 removed 3 lines
|[REVIEW_DONE_BY]|Varchar2(50)|[DESCRIPTION]| |
|[OVERALL_RATING]|Varchar2(2)|[X_OVERALL_RATING]| |
|[OVERALL_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
At line 28 removed 4 lines
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[REVIEW_COMMENTS]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
At line 34 changed one line
|[MERIT_MONTHS]|Number(10)|[NUMBER10|NUMBERn]| |
|[COMMENTS_EE]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[COMMENTS_MGR]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[DEN_ID]|Number(10)|[ID]|Y|link to [P2K_CM_ENTITIES]
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[EAS_ID]|Number(10)|[ID]|Y|link to [P2K_HR_ASSIGNMENTS]
At line 28 added 8 lines
|[ID]|Number(10)|[ID]|Y|
|[INCENTIVE_PERCENT]|Number(5)|[NUMBER5|NUMBERn]| |
|[MERIT_MONTHS]|Number(10)|[NUMBER10|NUMBERn]| |
|[MEX_ID]|Number(10)|[ID]| |link to [P2K_AM_EXECUTIONS], originating execution
|[MUS_ID]|Number(10)|[ID]| |link to [P2K_AM_USERS]
|[NEXT_REVIEW_DATE]|Date()|[DATE]| |
|[OVERALL_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[OVERALL_RATING]|Varchar2(2)|[X_OVERALL_RATING]| |
At line 37 added 11 lines
|[REVIEW_COMMENTS]|VARCHAR2(4000)| [VARCHAR4000|VARCHARnn]| |
|[REVIEW_DATE]|Date()|[DATE]|Y|
|[REVIEW_DONE_BY]|Varchar2(50)|[DESCRIPTION]| |
|[REVIEW_METHOD]|Varchar2(2)|[X_REVIEW_METHOD]| |
|[REVIEW_NUMBER]|Number(10)|[NUMBER10|NUMBERn]|Y|
|[REVIEW_PERIOD_FROM]|Date()|[DATE]| |
|[REVIEW_PERIOD_TO]|Date()|[DATE]| |
|[REVIEW_PHASE]|Varchar2(2)|[X_REVIEW_PHASE]| |
|[REVIEW_STATUS]|Varchar2(2)|[X_REVIEW_STATUS]|Y|
|[SMX_ID]|Number(10)|[ID]| |link to [P2K_SA_SALARY_MATRICES]
|[SRT_ID]|Number(10)|[ID]|Y|link to [P2K_SA_REVIEW_TYPES]
At line 49 added 11 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 5 lines
----
![Notes|Edit:Internal.P2K_SA_REVIEWS]
[{InsertPage page='Internal.P2K_SA_REVIEWS' default='Click to create a new notes page'}]