PY_GARN_LAW_FROMPY_GARN_RULE_FROMEFFDT_FROMPY_GARN_EFF_VW(SQL View) |
Index Back |
|---|---|
Garnishment Rules Effdt PromptThis view is used as prompt for Effective Date of rule that will be cloned or rule that is referenced in Calculation Formula page. |
| SELECT DISTINCT STATE_GARN_LAW , GARN_RULE_ID , EFFDT FROM PS_GARN_RULE_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PY_GARN_LAW_FROM |
Character(6) | VARCHAR2(6) NOT NULL | Defines Law Source that will be used in cloning process or in referencing the rule whose formula is used in Calculation Formula page. |
| 2 | PY_GARN_RULE_FROM |
Character(10) | VARCHAR2(10) NOT NULL | Defines Garnishment Rule ID that will be used in cloning process or in referencing the rule whose formula is used in Calculation Formula page. |
| 3 | EFFDT_FROM |
Date(10) | DATE NOT NULL | Effective Date From |