EHSI FINDING CATEGORY Table
View exposing EHS inspection finding category reference data including finding status and carryover, restriction, and PI-report indicators.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHSI_FINDING_CATEGORY |
Ehsi finding category associated with the record. |
VARCHAR2 |
20 |
EHSI_FINDING_CATEGORY_KEY |
Surrogate key identifying the ehsi finding category. |
VARCHAR2 |
35 |
EHSI_FINDING_STATUS |
Ehsi finding status associated with the record. |
VARCHAR2 |
30 |
EHSI_FINDING_STATUS_CODE |
Code identifying ehsi finding status. |
VARCHAR2 |
5 |
IS_CARRIED_OVER |
Indicator identifying whether carried over (Y/N). |
VARCHAR2 |
1 |
IS_EXCLUDED_FROM_PI_REPORT |
Indicator identifying whether excluded from pi report (Y/N). |
VARCHAR2 |
1 |
IS_SUBJECT_TO_RESTRICTION |
Indicator identifying whether subject to restriction (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |