44CREATE TABLE &LIBREF..RULE_SET_CONFIG (
45 RULE_SET_GROUP_ID VARCHAR(100) label =
'Rule Set Group Id',
46 PRIMARY_KEY VARCHAR(10000) label =
'Primary Key',
47 RULE_ID VARCHAR(32) label =
'Rule Id',
48 RULE_NAME VARCHAR(100) label =
'Rule Name',
49 RULE_DESC VARCHAR(100) label =
'Rule Description',
50 RULE_COMPONENT VARCHAR(10) label =
'Rule Component',
51 OPERATOR VARCHAR(10) label =
'Operator',
52 PARENTHESIS VARCHAR(1) label =
'Parenthesis',
53 COLUMN_NM VARCHAR(32) label =
'Column Name',
54 RULE_TYPE VARCHAR(100) label =
'Rule Type',
55 RULE_DETAILS VARCHAR(4000) label =
'Rule Details',
56 MESSAGE_TXT VARCHAR(4096) label =
'Message Text',
57 LOOKUP_SCHEMA_NAME VARCHAR(100) label =
'Lookup Schema Name',
58 LOOKUP_SCHEMA_VERSION VARCHAR(100) label =
'Lookup Schema Version',
59 LOOKUP_TABLE_PRIMARY_KEY VARCHAR(1) label =
'Lookup Key Source',
60 LOOKUP_KEY VARCHAR(10000) label =
'Lookup key',
61 LOOKUP_DATA VARCHAR(10000) label =
'Lookup Data',
62 AGGR_VAR_NM VARCHAR(32) label =
'Aggregated Variable Name',
63 AGGR_EXPRESSION_TXT VARCHAR(10000) label =
'Aggregated Expression Text',
64 AGGR_GROUP_BY_VARS VARCHAR(10000) label =
'Aggregated Group By Vars',
65 AGGREGATED_RULE_FLG VARCHAR(1) label =
'Aggregated Rule Flag',
66 RULE_REPORTING_LEV1 VARCHAR(1024) label =
'Rule Reporting Level 1',
67 RULE_REPORTING_LEV2 VARCHAR(1024) label =
'Rule Reporting Level 2',
68 RULE_REPORTING_LEV3 VARCHAR(1024) label =
'Rule Reporting Level 3',
69 RULE_WEIGHT NUMERIC(8) label =
'Rule Weight'