CS_RULES_STD_VW

(SQL View)
 Index Back

Standard Rules No Repeats

SCC - 10/14/04 - View of only Standard Rules that do not have repeat binds

SELECT A.SETID , A.CS_RULE_ID , A.DESCR60 , A.CS_RULE_TYPE FROM PS_CS_RULES A WHERE A.CS_RULE_TYPE = 'S' AND NOT EXISTS ( SELECT 'X' FROM PS_CS_RULE_SOURCE B WHERE A.SETID=B.SETID AND A.CS_RULE_ID=B.CS_RULE_ID AND B.CS_LEVEL > 0)

  • Related Language Record: CS_RULES_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 CS_RULE_ID Character(20) VARCHAR2(20) NOT NULL t

    Prompt Table: CS_RULES

    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 CS_RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Rule Type
    A=Alternate
    S=Standard

    Default Value: S