EHSI RC ACTION TYPE Table
View exposing EHS inspection root-cause and corrective-action type reference data including action type, assignee type, restriction indicator, and action status.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTION_ASSIGNEE_TYPE |
Action assignee type associated with the record. |
VARCHAR2 |
100 |
ACTION_ASSIGNEE_TYPE_CODE |
Code identifying action assignee type. |
VARCHAR2 |
10 |
ACTION_STATUS |
Action status associated with the record. |
VARCHAR2 |
50 |
ACTION_TYPE |
Action type associated with the record. |
VARCHAR2 |
50 |
ACTION_TYPE_CODE |
Code identifying action type. |
VARCHAR2 |
2 |
EHSI_RC_ACTION_TYPE_KEY |
Surrogate key identifying the ehsi rc action type. |
VARCHAR2 |
100 |
IS_SUBJECT_TO_RESTRICTION |
Indicator identifying whether subject to restriction (Y/N). |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |