SCC_RULE_DS_HDR

(SQL Table)
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.

  • 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_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    11 SCC_ENTITY_XML Long Character CLOB Entity XML