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
APPROVED	Varchar2(1)	TOGGLE
BASED_ON_PRIOR_JOB	Varchar2(1)	TOGGLE
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
COMMENTS_EE	Varchar2(4000)	VARCHAR4000
COMMENTS_MGR	Varchar2(4000)	VARCHAR4000
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	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
EE_SIGN_OFF	Varchar2(1)	TOGGLE
EID_ID_REVIEWER	Number(10)	ID		link to P2K_HR_IDENTITIES
ID	Number(10)	ID	Y
INCENTIVE_PERCENT	Number(5)	NUMBER5
MERIT_MONTHS	Number(10)	NUMBER10
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
OVERALL_RATING	Varchar2(2)	X_OVERALL_RATING
RASE_ID	Number(10)	ID		link to P2K_RE_ASSESSMENT_EVENTS
REVIEW_COMMENTS	VARCHAR2(4000)	VARCHAR4000
REVIEW_DATE	Date()	DATE	Y
REVIEW_DONE_BY	Varchar2(50)	DESCRIPTION
REVIEW_METHOD	Varchar2(2)	X_REVIEW_METHOD
REVIEW_NUMBER	Number(10)	NUMBER10	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

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 #

Click to create a new notes page