STATE_GARN_LAWPrompt Table: STATE_NAMES_VW
STATE_ZGARN_VW(SQL View) |
Index Back |
|---|---|
Garnishment Rules / State ViewThis record contains state garnishment law descriptions. |
| SELECT A.STATE ,A.DESCR FROM PS_STATE_TBL A , PS_INSTALLATION C WHERE A.COUNTRY=C.COUNTRY AND EXISTS ( SELECT 'X' FROM PS_GARN_RULE_TBL B WHERE B.STATE_GARN_LAW=A.STATE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE_GARN_LAW |
Character(6) | VARCHAR2(6) NOT NULL |
Garnish Law Source
Prompt Table: STATE_NAMES_VW |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |