SCC_RULE_CAT(SQL Table) |
Index Back |
---|---|
Rules Engine CategoriesThis table contains the setup the category data used for the rules in the Rules Engine |
# | 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 |
2 | SCC_RULE_CAT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Rule Name for the Rules Engine |
3 | SCC_DESCRLONG | Character(254) | VARCHAR2(254) NOT NULL | This field is a long description field used in Campus Community |
4 | SCC_BASE_APPACKAGE | Character(190) | VARCHAR2(190) NOT NULL | Base Application Package used by the Rules Engine |
5 | SCC_RULE_ALW_FNCTN | Character(1) | VARCHAR2(1) NOT NULL |
This field is a Y/N field used to identify if the rule in the Rules Engines allows functions.
Y/N Table Edit Default Value: N |
6 | SCC_RULE_ALW_RULES | Character(1) | VARCHAR2(1) NOT NULL |
This field identifies is a rule in the Rules Engine allows Rules
Y/N Table Edit Default Value: N |
7 | SCC_RULE_ALW_TRGRS | Character(1) | VARCHAR2(1) NOT NULL |
This field identifies if a rule in the Rules Engine allows triggers
Y/N Table Edit Default Value: N |
8 | SCC_RULE_ALW_DVLPR | Character(1) | VARCHAR2(1) NOT NULL |
This field is a Y/N field used to identify if the rule in the Rules Engines allows developer mode.
Y/N Table Edit Default Value: N |
9 | SCC_RULE_CATRG_RQD | Character(1) | VARCHAR2(1) NOT NULL |
This field is a yes/no flag on the rule category setup that is used to identify when a rule category must have rule groups attached to the rules.
Y/N Table Edit Default Value: N |
10 | SCC_RULE_AVAIL_ALL | Character(1) | VARCHAR2(1) NOT NULL |
This field is a Yes/No field used to identify if a rule category is a generic category that should be available to all other categories in the Rules Engine.
Y/N Table Edit Default Value: N |
11 | SCC_ENT_PRFL_ID | Character(40) | VARCHAR2(40) NOT NULL |
Entity Profile ID
Prompt Table: SCC_ENTPR_RL_VW |
12 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
13 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
14 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
15 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |