STATE_GARN_LAWGARN_RULE_IDEFFDTERNCDPrompt Table: EARNINGS_TBL
+=Include
-=Exclude
Default Value: -
GARN_DE_EARN(SQL Table) |
Index Back |
|---|---|
Garnishment DE Earnings TableGarnishment DE Earnings Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE_GARN_LAW |
Character(6) | VARCHAR2(6) NOT NULL | Garnish Law Source |
| 2 | GARN_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Garnish Rule ID |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
| 5 | INCLUD_EXCLUDE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Include Exclude
+=Include -=Exclude Default Value: - |