PY_GARN_RULE_VW

(SQL View)
 Index Back

Garnishment Rule Prompt View

This view is used as prompt for Law Source and Rule ID of rule that will be cloned or rule that is referenced in Calculation Formula page.

SELECT DISTINCT A.STATE_GARN_LAW , A.GARN_RULE_ID , A.DESCR FROM PS_GARN_RULE_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GARN_RULE_TBL A1 WHERE A1.STATE_GARN_LAW = A.STATE_GARN_LAW AND A1.GARN_RULE_ID = A.GARN_RULE_ID AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record: PY_GARN_RULE_LN

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description