GB_GROUP_IDSP_FROM_DATESP_TO_DATEEP_REVIEW_TYPEPrompt Table: EP_REVW_TYP_VW
Prompt Table: SP_MER_INCR_TBL
SP_MER_INC_ELIG(SQL Table) |
Index Back |
|---|---|
Merit Increase EligibilityThe Merit Increase Eligibility table is used to define a Group and eligibility criteria for employee review results (in ePerformance Management). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 2 | SP_FROM_DATE |
Date(10) | DATE NOT NULL | From Date - used in Salary Planning |
| 3 | SP_TO_DATE |
Date(10) | DATE NOT NULL | To Date - used in Salary Planning |
| 4 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL |
Review type
Prompt Table: EP_REVW_TYP_VW |
| 5 | SP_MER_INCR_ID | Character(5) | VARCHAR2(5) NOT NULL |
Merit Increase ID
Prompt Table: SP_MER_INCR_TBL |