SSR_HE_FLDRV_VW

(SQL View)
Index Back

HESA Rule ID View

HESA Rule ID View - Field Derivation

SELECT SCC_RULE_ID , SCC_RULE_VERSION , SCC_RULE_NAME , SCC_RULE_LONGNAME FROM %Table(SCC_RULE_HDR) WHERE SCC_RULE_STATUS = '2' AND SCC_RULE_CATEGORY = 'SCC_RULE_CAT_20180625213833'

# 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.
3 SCC_RULE_NAME Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine
4 SCC_RULE_LONGNAME Long Character CLOB This field is used for the long description used to describe a rule.