SP_SURV_MAP_VW(SQL View) |
Index Back |
---|---|
Market Pay Mapping TableThis table defines the mapping definition between Workforce Rewards and Market Pay functionality. This record will also maintain the mapping definition between the old Salary Survey application fields to the new Market Pay application. |
SELECT DISTINCT SETID , LOOKUP_ID , EFFDT FROM PS_SP_SURV_MAP_TBL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_02 |
2 | LOOKUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Main unique identifier for Configurable Matrices. |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |