| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHPRCC_EC1MAP | CP: Map Valuation Categories | 3 | ESTCAT | Mapped Value Assignment Type | nvarchar | 30 | 0 | | |
2 | EHPRCC_EC2MAP | CP: Map Characteristics | 4 | ESTCAT | Mapped Value Assignment Type | nvarchar | 30 | 0 | | |
3 | EHPRCC_EXPL_P | CP: BOS-Explosion configuration composition priorities | 4 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
4 | EHPRCC_IMMAP | Mapping table | 11 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
5 | EHPRCC_PROP | CP: definition of properties and characteristics | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
6 | EHPRCI_PAWM | Phrase Set <-> characteristics check table for filling TCG66 | 1 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
TOPEnvironment, Health and Safety |
7 | /TDAG/CPC_EC1MAP | CP: Map Valuation Categories | 3 | ESTCAT | Mapped Value Assignment Type | nvarchar | 30 | 0 | | |
8 | /TDAG/CPC_EC2MAP | CP: Map Characteristics | 4 | ESTCAT | Mapped Value Assignment Type | nvarchar | 30 | 0 | | |
9 | /TDAG/CPC_EXMAP | CP: Export Mapping | 9 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
10 | /TDAG/CPC_EXPL_P | CP: BOS-Explosion configuration composition priorities | 4 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
11 | /TDAG/CPC_IMMAP | Mapping table | 11 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
12 | /TDAG/CPC_PROP | CP: definition of properties and characteristics | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
13 | /TDAG/CPC_PROPH | CP: Definition of Property Mapping | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
14 | /TDAG/CPC_REP005 | CP: Define attributes for element | 10 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
15 | /TDAG/RCSW_PAWM | Phrase Set <-> characteristics check table for filling TCG66 | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
16 | EHQMT_MAIN1 | EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation | 18 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
TOPEnvironment, Health and Safety Master Data |
17 | TCG11 | EHS: Value Assignment Type | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
18 | TCG12 | EHS: Language-Dependent Description for Value Assignmt Type | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
19 | TCG66 | EHS: Value Assignment Type Class Characteristic | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
20 | THM063 | DG: Dangerous Goods Regulation | 8 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
21 | THM157 | DG: Profiles for Dangerous Goods User-Defined Texts | 4 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
TOPIndustrial Hygiene and Safety |
22 | CCIHC_IH05 | EHS: Assignment Display Field to Agent Characteristic | 4 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
23 | CCIHC_IHOBJ | EHS: Value Assignment Type - Object Type Assignment | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
24 | CCIHC_IHTYPE | EHS: Object Type - Object Subtype Assignment | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
TOPProduct Safety |
25 | CVDDCS | EHS: Control Structure (Report Shipping) | 17 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
26 | ESTDCS | EHS: Control Structure (Report Body) | 17 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
27 | ESTOCC | EHS: OCC: Table for Saving Import Information | 10 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
28 | ESTVH | EHS: Specification - Value Assignment Type Assignment | 16 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
29 | EST_CHANGE_DOCS | EHS: Change Documents in the EH&S System | 18 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
30 | TCG11SET | EHS: Definition of the Sequence of Tab Pages | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
31 | TCG11TAB | EHS: Permitted Tab Pages for Value Assignment Type | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
32 | TCG11_LYT | EHS: Assignment Table Value Assgmt Type <-> Workbench Layout | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
33 | TCG11_VAI | EHS: Table-Based Value Assignment of Specifications | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
34 | TCG13 | EHS: Value Assignment Type - Specification Type Assignment | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
35 | TCG29 | EHS: Override for identification listing definitions | 6 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
36 | TCG53 | EHS: Property Tree - Value Assignment Type Assignment | 4 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
37 | TCG76OBJCON | EHS: Object-Parameter-Component Type Assignment | 5 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
38 | TCG78OBJCON | EHS: Object-Parameter-Exception Value Assignment | 5 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
39 | TCGA6 | EHS: Report Symbol | 8 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
40 | TCGOBJCON | EHS: Object-Parameter Assignment | 4 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
41 | TCGRULPOSMCHANGE | EHS: Easy Expert Set of Rules, Changes to Characteristics | 5 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
42 | TCGRULPOSMREST | EHS: Easy Expert Set of Rules, Characteristic Restrictions | 5 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
43 | TCGST02 | EHS: Assignment Value Assignment Type to Status | 4 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
44 | TCGTPLP | EHS: Inheritance Templates - Properties | 16 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
45 | TCGWF3 | EHS: Event list for start condition | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
46 | TCGWF4 | EHS: Value Assignment Types for Task Profile | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
47 | TCGWF7 | EHS: Value Assignment Types for Workflow Start Condition | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
TOPRecipe |
48 | RCPT_PPMIG_PPID | RMS-RCP: PP Migration Log | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
TOPRecipe Development |
49 | /PLMB/RCA_COMP | Value Assignment Type of Composition | 4 | ESTCAT | Value Assignment Type for Composition | nvarchar | 30 | 0 | | |
50 | /PLMB/RCA_COSTS | Parameter for Costs | 4 | ESTCAT | Value Assignment Type for Substance Price | nvarchar | 30 | 0 | | |
51 | /PLMB/RCA_INGR | Value Assignment Type of Composition | 4 | ESTCAT | Value Assignment Type for Ingredients | nvarchar | 30 | 0 | | |
52 | /PLMB/RSP_VATC | Assignment Value Assignment Type - Calculation ID | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
TOPResourcen Management |
53 | RMSAC_PPDEF | RMS-ATL: Definition of Process Parameters | 3 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
54 | RMSAC_PP_DEF | RMS-ATL: (Obsolete) | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |
55 | RMSAC_VAI_PP | RMS-ATL: Phrased Process Parameter Names | 2 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | | |