P 2 K_SA_GOAL_GROUPS
Back to current versionRestore this version

Alias: SGG#

(P2K_SA_GOAL_GROUPS)

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


Reviews

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
GOAL_GROUP_CODEVarchar2(16) Y
SRV_IDNumber(10)IDYlink to P2K_SA_GOAL_GROUPS

SRS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
MUS_IDNumber(10)ID link to P2K_AM_USERS
MEX_IDNumber(10)ID link to P2K_AM_EXECUTIONS, originating execution
SMX_IDNumber(10)ID link to P2K_SA_SALARY_MATRICES
REVIEW_STATUSVarchar2(2)X_REVIEW_STATUSY
REVIEW_DATEDate()DATEY
NEXT_REVIEW_DATEDate()DATE
REVIEW_METHODVarchar2(2)X_REVIEW_METHOD
APPROVEDVarchar2(1)TOGGLE
REVIEW_DONE_BYVarchar2(50)DESCRIPTION
OVERALL_RATINGVarchar2(2)X_OVERALL_RATING
OVERALL_POINTSNumber(5)NUMBER5
BASED_ON_PRIOR_JOBVarchar2(1)TOGGLE
DESCRIPTIONVarchar2(50)DESCRIPTION
REVIEW_COMMENTSVarchar2(2000)VARCHAR2000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
MERIT_MONTHSNumber(10)NUMBER10
EE_SIGN_OFFVarchar2(1)TOGGLE
EID_ID_REVIEWERNumber(10)ID link to P2K_HR_IDENTITIES
RASE_IDNumber(10)ID link to P2K_RE_ASSESSMENT_EVENTS
INCENTIVE_PERCENTNumber(5)NUMBER5
REVIEW_PHASEVarchar2(2)X_REVIEW_PHASE
REVIEW_PERIOD_FROMDate()DATE
REVIEW_PERIOD_TODate()DATE
COMMENTS_EEVarchar2(4000)VARCHAR4000
COMMENTS_MGRVarchar2(4000)VARCHAR4000

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