SP_SURV_MAP_VW

(SQL View)
Index Back

Market Pay Mapping Table

This 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