| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInformation Consistency |
1 | SIC_NORM_ANORMRR | Attribute Normalization Rules: Rules | 3 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
2 | SIC_NORM_ANORMRV | Assignment of Variables in Attribute Normalizing Rules | 3 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
3 | SIC_NORM_BRTY | Basic Normalizing Rule Types | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
4 | SIC_NORM_BRTYI | Interface Variables for Basic Rule Types | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
5 | SIC_NORM_BRTYIT | Descriptioins for Interface Variables for Basic Rule Types | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
6 | SIC_NORM_BRTYT | Descriptions for Basic Normalizing Rule Types | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
7 | SIC_NORM_CASECON | Rules for Case Conversion | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
8 | SIC_NORM_CASECOT | Descriptions for Rules for Case Conversion | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
9 | SIC_NORM_CONDRUR | Conditional Rules | 4 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
10 | SIC_NORM_CONDRUV | Variables Assignment of Conditional Rules | 4 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
11 | SIC_NORM_QUACON | Rules for Quantitiy Conversions (C_SIC_NORM_QUANTITIY_C...) | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
12 | SIC_NORM_QUACONR | Rules for Quantity Conversions | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
13 | SIC_NORM_QUACONT | Descriptions to Rules for Quantity Conversions | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
14 | SIC_NORM_REGEX | Basic Rules to Rule Type REGEX (CL_SIC_NORM_REGEX) | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
15 | SIC_NORM_REGEXR | Basic Rules to Rule Type REGEX (CL_SIC_NORM_REGEX) | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |
16 | SIC_NORM_REGEXT | Descriptions for Regular Expressions | 2 | BASIC_RULE_TYPE | Rule Type for Basic Normalizing Rule | nvarchar | 30 | 0 | | |