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_SAL_SURV_TBL(SQL Table) |
Index Back |
|---|---|
Market Pay DetailsThis table contains the defintion of the data contained in the configurable matrix for the Salary Survey. This table is effective dated to allow the user to have different definitions based on the date. |
| # | 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 |