| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIndustrial Hygiene and Safety |
1 | CCIHC_AY01 | EHS: Control Table for Analysis Methods | 3 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
2 | CCIHC_AY05 | EHS: Assignment Risk to Rating | 4 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
3 | CCIHC_AY06 | EHS: Analysis Method Questionnaire - Rating | 6 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
4 | CCIHC_IH06 | EHS: Exposure Rating Category | 2 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
5 | CCIHC_IH08 | EHS: Description of Exposure Rating Category | 3 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
6 | CCIHC_IH09 | EHS: Categorized Exposure Rating | 2 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
7 | CCIHC_IH10 | EHS: Categ. Exposure Rating - Language-Dependent Description | 3 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
8 | CCIHC_PB | EHS: Probability of Risk | 3 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
9 | CCIHC_PBTXT | EHS: Probability of Risk - Language-Dependent Description | 4 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
10 | CCIHC_QT06 | EHS: Assignment Measured Value-Reference Value and Rating | 4 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
11 | CCIHC_SV | EHS: Severity of Risk | 3 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
12 | CCIHC_SVTXT | EHS: Severity of Risk - Language-Dependent Description | 4 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
13 | CCIHT_AD08 | EHS: Customer Analysis Method 08 Detail Data | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
14 | CCIHT_AD09 | EHS: Customer Analysis Method 09 Detail Data | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
15 | CCIHT_AD10 | EHS: Customer Analysis Method 10 Detail Data | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
16 | CCIHT_AM01 | EHS: Customer Analysis Method 01 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
17 | CCIHT_AM02 | EHS: Customer Analysis Method 02 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
18 | CCIHT_AM03 | EHS: Customer Analysis Method 03 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
19 | CCIHT_AM04 | EHS: Customer Analysis Method 04 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
20 | CCIHT_AM05 | EHS: Customer Analysis Method 05 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
21 | CCIHT_AM06 | EHS: Customer Analysis Method 06 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
22 | CCIHT_AM07 | EHS: Customer Analysis Method 07 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
23 | CCIHT_AM08 | EHS: Customer Analysis Method 08 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
24 | CCIHT_AM09 | EHS: Customer Analysis Method 09 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
25 | CCIHT_AM10 | EHS: Customer Analysis Method 10 | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
26 | CCIHT_ANML | EHS: Analysis Method - Meas. Value - Ref. Value Comparison | 44 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
27 | CCIHT_ANNC | EHS: Analysis Method - Standardized Criteria | 20 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
28 | CCIHT_ANQS | EHS: Analysis Method Questionnaire | 19 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
29 | CCIHT_ANSC | EHS: Analysis Method - Summated Rating (Header) | 17 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
30 | CCIHT_ANSE | EHS: Analysis Method - Summated Rating (Details) | 44 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
31 | CCIHT_EPI | EHS: Exposure Profile Entry | 20 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
32 | CCIHT_ERH | EHS: Risk Assessment - Header | 25 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |
33 | CCIHT_ERRA | EHS: - Obsolete - Exposure Assignment - Risk Assessment | 18 | RATINGCAT | Exposure Rating Category | nvarchar | 3 | 0 | | |