EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: %GP_EDIT_FLD1
Prompt Table: %GP_EDIT_FLD1
Prompt Table: %GP_EDIT_FLD5
Prompt Table: %GP_EDIT_FLD6
Y/N Table Edit
Default Value: N
GPAU_WL_DATA_VW(SQL View) |
Index Back |
|---|---|
WH lim control field defWithholding limit control field configuration data |
| SELECT A.EFFDT ,A.EFF_STATUS ,A.GPAU_PIN_WL1_NUM ,A.GPAU_PIN_WL2_NUM ,B.GPAU_WL_CTL_VAL1 ,B.GPAU_WL_CTL_VAL2 ,B.GPAU_WL_DFLT_VAL FROM PS_GPAU_WL_DEF A ,PS_GPAU_WL_CTL_VAL B WHERE A.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 2 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 3 | GPAU_PIN_WL1_NUM | Number(8,0) | INTEGER NOT NULL |
Withholding limit control field 1 - Typically SETID when available
Prompt Table: %GP_EDIT_FLD1 |
| 4 | GPAU_PIN_WL2_NUM | Number(8,0) | INTEGER NOT NULL |
Withholding limit control field 2- Typically the actual control field
Prompt Table: %GP_EDIT_FLD1 |
| 5 | GPAU_WL_CTL_VAL1 | Character(22) | VARCHAR2(22) NOT NULL |
Withholding limit control field value1
Prompt Table: %GP_EDIT_FLD5 |
| 6 | GPAU_WL_CTL_VAL2 | Character(22) | VARCHAR2(22) NOT NULL |
Withholding limit control field value2
Prompt Table: %GP_EDIT_FLD6 |
| 7 | GPAU_WL_DFLT_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Withholding limit control fields values default
Y/N Table Edit Default Value: N |