!!!Alias: SRV
(P2K_SA_REVIEWS)

Unique Keys: \\
Child Table: \\
Parent Table:\\
ERD: [ERD-SA04]

\\
Reviews

!!Table Columns
\\
||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]


!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_APPROVAL_BAR]
|[DRV_APPROVAL_COMMENTS]
|[DRV_AVERAGE_POINTS]
|[DRV_TOTAL_REVIEW_POINTS]
|[DRV_TOTAL_WEIGHTED_POINTS]


User Fields: Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_SA_REVIEWS] 	
[{InsertPage page='Internal.P2K_SA_REVIEWS' default='Click to create a new notes page'}]