DW_HNS_ACTION_F (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Incident Action information

Details

Module: Workforce Health and Safety Incidents

Key Columns

ACTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACTION_ID NUMBER 38 0 True System generated primary key column.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Unique Source Record Identifier with action_id
INCIDENT_ID NUMBER 38 0 Incident Summary Identifier
ACTION_SUMMARY VARCHAR2 999 Summary information for an Action.This is a user entered field.
ACTION_DATE DATE The date when the action was created and assigned to the action owner.
ACTION_DATE_TIME TIMESTAMP The date time when the action was created and assigned to the action owner.
ACTION_TYPE_CODE VARCHAR2 32 Type of Action identifier.E.g. Corrective, preventive
ACTION_STATUS_CODE VARCHAR2 32 Current Action Status.
PRIORITY_CODE VARCHAR2 32 Priority Identifier.
ACTION_NUMBER VARCHAR2 64 Unique user-defined identifierfor Action table.
REQUIRED_RESOURCE_CODE VARCHAR2 256 Required Resources for an action. The column is comma delimited with the req resources will be separated by comma.
REQUIRED_RESOURCE_CODE1 VARCHAR2 256 Required Resources for an action 1.
REQUIRED_RESOURCE_CODE2 VARCHAR2 256 Required Resources for an action 2.
REQUIRED_RESOURCE_CODE3 VARCHAR2 256 Required Resources for an action 3.
ESTIMATED_COST NUMBER Estimated cost associated with the Action.
ESTIMATED_COST_CURRENCY_CODE VARCHAR2 16 Estimated Cost Currency Code. Currency code related to the estimated cost. Default to USD.
LESSONS_LEARNED VARCHAR2 999 Lessons Learned.
DELETED_FLAG VARCHAR2 16 Signifies whether the Action is deleted
CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.