GPUS_GRN_TYPE10=Child Support
20=Dependent Support
30=Spousal Support
40=Tax Levy
50=Creditor Garnishment
60=Student Loan
70=Chapter 13 Bankruptcy
80=AWG - Wage Garnishment
90=Wage Assignment
GPUS_RLAWSRCGPUS_GRN_ST_VW(SQL View) |
Index Back |
|---|---|
Garnishment Law SourceGarnishment Law Source |
| SELECT DISTINCT G.GPUS_GRN_TYPE , G.GPUS_LAWSRC , S.DESCR FROM PS_GPUS_GRN_STRUL G , PS_STATE_TBL S WHERE G.GPUS_LAWSRC = S.STATE AND S.COUNTRY = 'USA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPUS_GRN_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
GPUS_GARNTYPE
10=Child Support 20=Dependent Support 30=Spousal Support 40=Tax Levy 50=Creditor Garnishment 60=Student Loan 70=Chapter 13 Bankruptcy 80=AWG - Wage Garnishment 90=Wage Assignment |
| 2 | GPUS_RLAWSRC |
Character(6) | VARCHAR2(6) NOT NULL | GPUS_LAWSRC |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |