GB_GROUP_IDPrompt Table: GB_GROUP_TBL
EP_REVIEW_TYPEPrompt Table: EP_REVW_TYP_VW
SP_FROM_DATESP_TO_DATESP_MER_TO_DT_VW(SQL View) |
Index Back |
|---|---|
Merit Increase To Date PromptMerit Increase by Group - To Date Prompt Table. This table is used as prompt table for the To Date. |
| SELECT GB_GROUP_ID , EP_REVIEW_TYPE , SP_FROM_DATE , SP_TO_DATE FROM PS_SP_MER_INC_ELIG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 2 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL |
Review type
Prompt Table: EP_REVW_TYP_VW |
| 3 | SP_FROM_DATE |
Date(10) | DATE NOT NULL | From Date - used in Salary Planning |
| 4 | SP_TO_DATE |
Date(10) | DATE NOT NULL | To Date - used in Salary Planning |