The table RULE_SET_CONFIG contains business rules definitions. More...
Go to the source code of this file.
The table RULE_SET_CONFIG contains business rules definitions.
PK | Variable | Type | Required? | Label | Description |
---|---|---|---|---|---|
![]() | RULE_SET_GROUP_ID | VARCHAR(100) | Y | Rule Set Group Id | Rule Set Group Identifier |
PRIMARY_KEY | VARCHAR(10000) | N | Primary Key | (Optional) List of primary key variables of the source table. Only used if parameter DS_OUT_DETAILS is not blank | |
RULE_ID | VARCHAR(32) | Y | Rule Id | Rule Identifier | |
RULE_NAME | VARCHAR(100) | N | Rule Name | Rule Name | |
RULE_DESC | VARCHAR(100) | N | Rule Description | Rule Description | |
RULE_COMPONENT | VARCHAR(10) | Y | Rule Component | Specifes if the current record relates to the Condition or the Action portion of the rule. Valid Values (case insensitive): - Condition - Action | |
OPERATOR | VARCHAR(10) | N | Operator | Boolean Operator. It can be used to combine multiple conditions within a rule. Valid Values (case insensitive): - <blank> - And - Or -Not -And Not -Or Not | |
PARENTHESIS | VARCHAR(1) | N | Parenthesis | Opening/Closing parenthesis. It can be used to create more complex boolean conditions. Valid Values: - <blank> - ( - ) | |
COLUMN_NM | VARCHAR(32) | Y | Column Name | Required unless RULE_TYPE = "CUSTOM". Name of the variable used to build the condition expression | |
RULE_TYPE | VARCHAR(100) | Y | Rule Type | Controls how the expression for evaluating the condition/action is built. | |
RULE_DETAILS | VARCHAR(4000) | Y | Rule Details | Provides additional details needed to build the expression for evaluating the condition/action. | |
MESSAGE_TXT | VARCHAR(4096) | N | Message Text | Provides a custom message for reporting the results of rules evaluation. Only one message per rule can be specified: for any given rule id, the first non-blank value that is used. | |
LOOKUP_SCHEMA_NAME | CHARACTER(100) | N | Lookup Schema Name | Required if this rule uses a lookup table. Used to specify the schema name of the data definition for this lookup table. | |
LOOKUP_SCHEMA_VERSION | CHARACTER(100) | N | Lookup Schema Version | Required if this rule uses a lookup table. Used to specify the schema version of the data definition for this lookup table. | |
LOOKUP_TABLE_PRIMARY_KEY | CHARACTER(1) | N | Lookup Key Source | Used if this rule has a lookup table. If set to Y then only primary key variables from the lookup table are available for LOOKUP_KEY. If set to N then all variables from the lookup table are available for LOOKUP_KEY | |
LOOKUP_KEY | VARCHAR(10000) | N | Lookup key | Space separated list of lookup key variables. These variables must be found in both the SOURCE_TABLE and the LOOKUP table | |
LOOKUP_DATA | VARCHAR(10000) | N | Lookup Data | Space separated list of lookup data variables to retrieve. These variables must be found in the LOOKUP table | |
AGGR_VAR_NM | VARCHAR(32) | N | Aggregated Variable Name | Name (Alias) given to the result of the aggregated expression | |
AGGR_EXPRESSION_TXT | VARCHAR(10000) | N | Aggregated Expression Text | Summary-type of expression (i.e. SUM(<varname>). Orthogonal query expressions can be used to perform filtered aggregation (i.e. SUM(<varname> * (<other_varname> = "some value")) | |
AGGR_GROUP_BY_VARS | VARCHAR(10000) | N | Aggregated Group By Vars | (Optional) Space separated list of group-by variables for the aggregation. | |
AGGREGATED_RULE_FLG | VARCHAR(1) | Y | Aggregated Rule Flag | Flag (Y/N). Specifies if the rule operates at the detail level (for each record of the SOURCE_TABLE) or at aggregated level | |
RULE_REPORTING_LEV1 | VARCHAR(1024) | N | Rule Reporting Level 1 | This field is used to classify rules for reporting purpose | |
RULE_REPORTING_LEV2 | VARCHAR(1024) | N | Rule Reporting Level 2 | This field is used to classify rules for reporting purpose | |
RULE_REPORTING_LEV3 | VARCHAR(1024) | N | Rule Reporting Level 3 | This field is used to classify rules for reporting purpose | |
RULE_WEIGHT | NUMERIC(8) | Y | Rule Weight | A weight assigned to the rule. Used for reporting purpose (weighted aggregation for building performance indicators) |
See irm_run_rules.sas for details for details.
Definition in file rule_set_config.sas.