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.    

Copyright © 2019, 2024, Oracle and/or its affiliates.