P 2 K_SA_REVIEWS

Alias: SRV#

(P2K_SA_REVIEWS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-SA04


Reviews

Table Columns#


Column nameData Type / SizeDomainMand.Notes
APPROVEDVarchar2(1)TOGGLE
BASED_ON_PRIOR_JOBVarchar2(1)TOGGLE
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
COMMENTS_EEVarchar2(4000)VARCHAR4000
COMMENTS_MGRVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
DEN_IDNumber(10)IDYlink to P2K_CM_ENTITIES
DESCRIPTIONVarchar2(50)DESCRIPTION
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
EE_SIGN_OFFVarchar2(1)TOGGLE
EID_ID_REVIEWERNumber(10)ID link to P2K_HR_IDENTITIES
IDNumber(10)IDY
INCENTIVE_PERCENTNumber(5)NUMBER5
MERIT_MONTHSNumber(10)NUMBER10
MEX_IDNumber(10)ID link to P2K_AM_EXECUTIONS, originating execution
MUS_IDNumber(10)ID link to P2K_AM_USERS
NEXT_REVIEW_DATEDate()DATE
OVERALL_POINTSNumber(5)NUMBER5
OVERALL_RATINGVarchar2(2)X_OVERALL_RATING
RASE_IDNumber(10)ID link to P2K_RE_ASSESSMENT_EVENTS
REVIEW_COMMENTSVARCHAR2(4000) VARCHAR4000
REVIEW_DATEDate()DATEY
REVIEW_DONE_BYVarchar2(50)DESCRIPTION
REVIEW_METHODVarchar2(2)X_REVIEW_METHOD
REVIEW_NUMBERNumber(10)NUMBER10Y
REVIEW_PERIOD_FROMDate()DATE
REVIEW_PERIOD_TODate()DATE
REVIEW_PHASEVarchar2(2)X_REVIEW_PHASE
REVIEW_STATUSVarchar2(2)X_REVIEW_STATUSY
SMX_IDNumber(10)ID link to P2K_SA_SALARY_MATRICES
SRT_IDNumber(10)IDYlink 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

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

All content © High Line Corporation