PY_GARN_RULE_LN

(SQL View)
 Index Back

Garnishment Rule RelLngPrompt

This view is used as related language 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.LANGUAGE_CD , A.DESCR FROM PS_GARN_RULE_LANG A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GARN_RULE_LANG A1 WHERE A1.STATE_GARN_LAW = A.STATE_GARN_LAW AND A1.GARN_RULE_ID = A.GARN_RULE_ID AND A1.LANGUAGE_CD = A.LANGUAGE_CD AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record for PY_GARN_RULE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description