EHSI FINDING DETAIL NEW Table
View exposing EHS inspection finding detail using the newer finding structure including finding category, assignee, action taken, carried-over finding identifiers, sort values, long text, and audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CARRIED_FROM_FINDING_ID |
Business identifier for the carried from finding. |
NUMBER |
30 |
CARRIED_TO_FINDING_ID |
Business identifier for the carried to finding. |
NUMBER |
30 |
EHSI_ACTION_TAKEN_KEY |
Surrogate key identifying the ehsi action taken. |
NUMBER |
34 |
EHSI_CURRENT_ASSIGNEE_KEY |
Surrogate key identifying the ehsi current assignee. |
VARCHAR2 |
15 |
EHSI_FINDING_CATEGORY_KEY |
Surrogate key identifying the ehsi finding category. |
VARCHAR2 |
35 |
EHSI_FINDING_ID |
Business identifier for the ehsi finding. |
NUMBER |
20 |
EHSI_FINDING_LONG_TEXT |
Ehsi finding long text associated with the record. |
VARCHAR2 |
2500 |
EHSI_FINDING_ROOMS |
Ehsi finding rooms associated with the record. |
VARCHAR2 |
1000 |
EHSI_FINDING_SORT |
Ehsi finding sort associated with the record. |
VARCHAR2 |
6 |
EHSI_FINDING_TYPE_KEY |
Surrogate key identifying the ehsi finding type. |
NUMBER |
20 |
EHSI_HEADER_KEY |
Surrogate key identifying the ehsi header. |
NUMBER |
20 |
EHSI_PREVIOUS_ASSIGNEE_KEY |
Surrogate key identifying the ehsi previous assignee. |
VARCHAR2 |
15 |
FINDING_CREATE_DATE |
Date associated with finding create. |
DATE |
|
FINDING_CREATE_USER |
Finding create user associated with the record. |
VARCHAR2 |
12 |
FINDING_LAST_UPDATE_DATE |
Date associated with finding last update. |
DATE |
|
FINDING_LAST_UPDATE_USER |
Finding last update user associated with the record. |
VARCHAR2 |
12 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |