GPDE_GR_EE1(SQL Table) |
Index Back |
|---|---|
Payee Garnishment AssignmentPayee Garnishment Assignment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
| 3 | Number(3,0) | SMALLINT NOT NULL |
Garnishment Priority
Default Value: 1 |
|
| 4 | GPDE_GR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Garnishment Type
1=General Garnishment 2=Support Garnishment |
| 5 | GPDE_GR_ID | Character(20) | VARCHAR2(20) NOT NULL | Garnishment Identificator |
| 6 | GPDE_GR_COURT_NAME | Character(20) | VARCHAR2(20) NOT NULL | Garnishment Identificator |
| 7 | GPDE_GR_RECEIVE_DT | DateTime(26) | TIMESTAMP |
Garnishment Received Date
Default Value: %date |
| 8 | DESCR1_GER | Character(30) | VARCHAR2(30) NOT NULL | Description |