SCC_RULE_CAT7VW(SQL View) |
Index Back |
---|---|
Rule Engine Category ViewThis view is used in displaying the triggers assigned to a specific rule category in the cross reference page. |
SELECT SCC_RULE_CATEGORY , SCC_RULE_TRIG_ID , SCC_RULE_TRIG_NAME FROM PS_SCC_RULE_TRIG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_RULE_CATEGORY | Character(40) | VARCHAR2(40) NOT NULL |
Rule Category for the Rules Engine
Prompt Table: SCC_RULE_CAT |
2 | SCC_RULE_TRIG_ID | Character(40) | VARCHAR2(40) NOT NULL |
Trigger ID
Prompt Table: SCC_RULE_TRIG |
3 | SCC_RULE_TRIG_NAME | Character(80) | VARCHAR2(80) NOT NULL | Trigger Name |