SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_02
LOOKUP_IDPrompt Table: WCS_LK_MPAY_VW
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
SP_SURV_MAP_TBL(SQL Table) |
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. |
| # | 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.
Prompt Table: WCS_LK_MPAY_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |