This table requires activation of Health and Safety functional area. Table stores Health and Safety Incident Action information
Module: Workforce Health and Safety Incidents
ACTION_ID
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 | 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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.