GPDE_GR_EEONRAD(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 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
4 | GPDE_GR_SEQ | Number(3,0) | SMALLINT NOT NULL | Garnishment Priority |
5 | EFFDT | Date(10) | DATE | Effective Date |
6 | GPDE_PIN_NUM_ED | Number(8,0) | INTEGER NOT NULL | PIN Number Deduction |
7 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL | entry type element |
8 | GPDE_PIN_NUM_AC | Number(8,0) | INTEGER NOT NULL | PIN Number Accumulator |
9 | GPDE_PIN_NUM_VR | Number(8,0) | INTEGER NOT NULL | Variable for Garnishment Earning/Deduction Override Handling. |
10 | GPDE_GR_OVRD_PCT | Number(3,0) | SMALLINT NOT NULL | Earning/Deduction Percent Override |