SCC_RULE_DS_HVW

(SQL View)
 Index Back

Rules Engine Data Set Header

This record is used to track the data set default values on a variable in the rules engine.

SELECT SCC_RULE_ID , SCC_RULE_VERSION , SCC_RULE_SEQNUM , SCC_RULE_DS_SEQ , SCC_RULE_ORDER , SCC_ENTITY_ID , SCC_ENTITY_XML FROM PS_SCC_RULE_DS_HDR

  • Parent record: SCC_RULE_VARS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_RULE_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule ID for rules used in the Rules Engine
    2 SCC_RULE_VERSION Number(3,0) SMALLINT NOT NULL This field is the version of a rule or rule group in the rules engine.

    Default Value: 1

    3 SCC_RULE_SEQNUM Number(4,0) SMALLINT NOT NULL This field is a sequence number used to create a unqiue key in the Rules Engine setup
    4 SCC_RULE_DS_SEQ Number(4,0) SMALLINT NOT NULL This field is a sequence number used to create a unqiue key in the Rules Engine setup
    5 SCC_RULE_ORDER Number(4,0) SMALLINT NOT NULL This field is used to identify the order of the rows in the rules engine setup for the Rules Engine
    6 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
    7 SCC_ENTITY_XML Long Character CLOB Entity XML