This table requires activation of Health and Safety functional area. Table stores Health and Safety Incident Summary information
Module: Workforce Health and Safety Incidents
INCIDENT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| INCIDENT_ID | NUMBER | 38 | 0 | True | Incident Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| INCIDENT_NUMBER | VARCHAR2 | 32 | Incident Number | ||||
| REPORTER_TYPE_CODE | VARCHAR2 | 32 | Reporter Type Code | ||||
| REPORTER_NONEMP_TYPE_CODE | VARCHAR2 | 32 | Reporter Non Employee Type Code | ||||
| REPORTER_PERSON_ID | NUMBER | 38 | 0 | Person Identifier | DW_PERSON_D | PERSON_ID | |
| REPORTER_ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment ID of the reporter (employee) at the time when Incident happened. | |||
| REPORTER_NAME | VARCHAR2 | 256 | Reporter Name | ||||
| INCIDENT_DATE | DATE | Incident Date | |||||
| INCIDENT_DATE_TIME | TIMESTAMP | Incident Date Time | |||||
| INCIDENT_REPORTED_DATE | TIMESTAMP | This is the date that the incident reporter informed a person in authority | |||||
| INCIDENT_CREATE_DATE | DATE | Incident Creation Date | |||||
| LOCATION_TYPE_CODE | VARCHAR2 | 32 | Location Type Code | ||||
| OFFSITE_LOCATION_TYPE_CODE | VARCHAR2 | 32 | Offsite Location Type Code | ||||
| REPORTED_SPECIFIC_LOCATION | VARCHAR2 | 256 | Reported Specific Location | ||||
| REPORTED_CITY | VARCHAR2 | 128 | Reported City | ||||
| REPORTED_COUNTRY | VARCHAR2 | 128 | Reported Country | ||||
| INCIDENT_SUMMARY | VARCHAR2 | 999 | Incident Summary | ||||
| SEVERITY_LEVEL_CODE | VARCHAR2 | 32 | Severity Level Code | ||||
| INCIDENT_OWNER_PERSON_ID | NUMBER | 38 | 0 | Incident Owner Person Identifier | DW_PERSON_D | PERSON_ID | |
| INCIDENT_OWNER_ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment Id for ther person/employee who owns the incident. | |||
| NOTIFIED_PERSON_ID | NUMBER | 38 | 0 | Employee ID of the person who was notified about the incident. | |||
| NOTIFIED_PERSON_ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment ID of the person who was notified about the incident. | |||
| TARGET_COMPLETION_DATE | TIMESTAMP | Target Completion Date | |||||
| ACTUAL_COMPLETION_DATE | TIMESTAMP | Actual Completion Date | |||||
| INCIDENT_STATUS_CODE | VARCHAR2 | 32 | Incident Status Code | ||||
| EMERGENCY_FLAG | VARCHAR2 | 16 | Deleted flag.This column signifies whether the incident is checked for deletion | ||||
| CONFIDENTIAL_FLAG | VARCHAR2 | 16 | Is Confidential flag. This column signifies whether the incident is checked confidential. | ||||
| COMPLETED_FLAG | VARCHAR2 | 16 | COMPLETED flag.This signifies if the incident is completed or not. | ||||
| REPORTED_STATE | VARCHAR2 | 128 | REPTR_STATE column : Incident state reported by the reporter. | ||||
| REPORTED_ZIP_CODE | VARCHAR2 | 128 | REPTR_ZIP_CODE column : Incident zipcode reported by the reporter. | ||||
| LOCATION_ID | NUMBER | 38 | 0 | Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID | |
| BIZ_CONT_PLAN_ACT_BY_PERSON_ID | NUMBER | 38 | 0 | Person Identifier of the person who activated the business continuity plan. | DW_PERSON_D | PERSON_ID | |
| BIZ_CONT_PLAN_ACTIVATED_DATE | TIMESTAMP | At what time the business continuity plan is activated. | |||||
| BIZ_CONT_PLAN_ACTIVATED_FLAG | VARCHAR2 | 16 | Business continuity plan activated flag | ||||
| EMRGNCY_ACTN_PLAN_ACTVTD_BY_PERSON_ID | NUMBER | 38 | 0 | Person Identifier of the person who activated the emergency action plan. | DW_PERSON_D | PERSON_ID | |
| EMRGNCY_ACTN_PLAN_ACTVTD_FLAG | VARCHAR2 | 16 | Emergency Action Plan Activated Flag | ||||
| EMRGNCY_ACTN_PLAN_ACTVTD_DATE | TIMESTAMP | At what time the Emergency Action Plan is Activated. | |||||
| EVACUATION_FLAG | VARCHAR2 | 16 | Evacuation Flag | ||||
| EVACUATION_LENGTH_OF_TIME | VARCHAR2 | 16 | Length of Time(Hrs) the evacuation is happened for | ||||
| EVACUATION_ORDERED_DATE | TIMESTAMP | At what time the evacuation is ordered. | |||||
| EVACUATION_ORDERED_BY_PERSON_ID | NUMBER | 38 | 0 | Person Identifier of the person who ordered the evacuation. | DW_PERSON_D | PERSON_ID | |
| EVACUATION_TYPE_CODE | VARCHAR2 | 32 | Evacuation Type Code | ||||
| FACILITY_CLOSED_DATE | TIMESTAMP | At what time the facility is closed. | |||||
| FACILITY_CLOSED_BY_PERSON_ID | NUMBER | 38 | 0 | Person Identifier of the person who closed the facility. | DW_PERSON_D | PERSON_ID | |
| FACILITY_CLOSED_FLAG | VARCHAR2 | 16 | Facility Closed or Operations Ceased Flag | ||||
| FACILITY_CLOSED_LENGTH_OF_TIME | VARCHAR2 | 16 | Length of Time(Hrs) the facility is closed. | ||||
| INCIDENT_SOURCE_CODE | VARCHAR2 | 32 | Source for Incident creation | ||||
| INCIDENT_TYPE_CODE | VARCHAR2 | 32 | Incident Type Code | ||||
| ACTION_REQUIRED_FLAG | VARCHAR2 | 16 | Check box to confirm whether an action is required. | ||||
| LESSONS_LEARNED | VARCHAR2 | 999 | Lessons Learned | ||||
| RADIUS | NUMBER | Distance in terms of radiating circles from the facility where the fire or explosion occurred. | |||||
| RADIUS_UNIT_CODE | VARCHAR2 | 32 | Radius Unit Code. Unit of measure for distance | ||||
| DELETED_FLAG | VARCHAR2 | 16 | Deleted Flag | ||||
| CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. |
Copyright © 2019, 2024, Oracle and/or its affiliates.