Wiki: P 2 K_SA

Alias: SRV#

Unique Keys: _
Child Table: _
Parent Table: _

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	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
APPROVED	Varchar2(1)	TOGGLE
REVIEW_DONE_BY	Varchar2(50)	DESCRIPTION
OVERALL_RATING	Varchar2(2)	X_OVERALL_RATING
OVERALL_POINTS	Number(5)	NUMBER5
BASED_ON_PRIOR_JOB	Varchar2(1)	TOGGLE
DESCRIPTION	Varchar2(50)	DESCRIPTION
REVIEW_COMMENTS	Varchar2(2000)	VARCHAR2000
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
MERIT_MONTHS	Number(10)	NUMBER10
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

User Fields: Allowed
Audit Logging: Allowed

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor