EMPLIDEMPL_RCDGPDE_GR_SEQDefault Value: 1
EFFDTDefault Value: %date
Prompt Table: GP_ENT_OVRD4_VW
GPDE_PIN_NUM_EDPrompt Table: %RECNAME_EDIT
Prompt Table: GPDE_GR_AC_VW
Prompt Table: GPDE_GR_VR_VW
GPDE_GR_EE_OVRD(SQL Table) |
Index Back |
|---|---|
Payee Garnishment OverrideIndividual Payee Garnishment Override concerning Earnings and Deductions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | GPDE_GR_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Garnishment Priority
Default Value: 1 |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Prompt Table: GP_ENT_OVRD4_VW |
| 6 | GPDE_PIN_NUM_ED |
Number(8,0) | INTEGER NOT NULL |
PIN Number Deduction
Prompt Table: %RECNAME_EDIT |
| 7 | GPDE_PIN_NUM_AC | Number(8,0) | INTEGER NOT NULL |
PIN Number Accumulator
Prompt Table: GPDE_GR_AC_VW |
| 8 | GPDE_PIN_NUM_VR | Number(8,0) | INTEGER NOT NULL |
Variable for Garnishment Earning/Deduction Override Handling.
Prompt Table: GPDE_GR_VR_VW |
| 9 | GPDE_GR_OVRD_PCT | Number(3,0) | SMALLINT NOT NULL | Earning/Deduction Percent Override |