Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
1 | EHHSSD_CINSP_RT | Control Inspection - Root | 39 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
2 | EHPRCD_CMP_POS | Campaign Position | 14 | PLANT_ID | Plant | nvarchar | 4 | 0 | ||
3 | EHPRCD_COD_SUPL | Supplier Listing | 8 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
Incident Recording | ||||||||||
4 | EHHSSC_INV_TMPL | Investigation Template | 5 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
5 | EHHSSD_INC_BINFA | Incident - Basic Information All | 10 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
6 | EHHSSD_INC_EQU | Incident - Equipment | 12 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
7 | EHHSSD_INC_PROP | Incident - Property | 13 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
8 | EHHSSD_INC_VEHIC | Incident - Vehicle | 12 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
Incident Reporting | ||||||||||
9 | EHHSSD_ISR_SURPT | Incident Report - Summary Report | 10 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
Incident Workflow and Tasks | ||||||||||
10 | EHHSSD_IAC_ROOT | Action - Root | 39 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
Locations Location Structure | ||||||||||
11 | EHFNDD_LOC_REV | Location - Revisions | 15 | PLANT_ID | Plant ID | nvarchar | 4 | 0 | ||
Production Planning and Control | ||||||||||
12 | LPO_INTMODEL_MAT | Integration model LPO: Integrated Materials | 3 | PLANT_ID | Plant | nvarchar | 4 | 0 | ||
13 | LPO_INTMODEL_WC | Integration model LPO: Integrated Work centers | 3 | PLANT_ID | Plant | nvarchar | 4 | 0 | ||
Risk Assessment | ||||||||||
14 | EHHSSD_RAC_ROOT | Risk Assesment Actions | 39 | PLANT_ID | Plant ID | nvarchar | 4 | 0 |