# 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, 2025, Oracle and/or its affiliates.