GPUS_RLAWSRCGPUS_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_RULEIDPrompt Table: GPUS_GRN_RUL
GPUS_GRN_RUL_VW(SQL View) |
Index Back |
|---|---|
Garnishment Rules ViewGarnishment Rules View |
| SELECT GPUS_LAWSRC ,GPUS_GRN_TYPE , GPUS_RULEID ,DESCR60 FROM PS_GPUS_GRN_STRUL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPUS_RLAWSRC |
Character(6) | VARCHAR2(6) NOT NULL | GPUS_LAWSRC |
| 2 | 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 |
| 3 | GPUS_RULEID |
Character(30) | VARCHAR2(30) NOT NULL |
GPUS_RULEID
Prompt Table: GPUS_GRN_RUL |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |