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
WC_MKT_DSP_TBL(SQL Table) |
Index Back |
|---|---|
Market Display TableContains the display properties and rules for the Maanager application for which Market Pay fields to show. 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 |