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 | 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 | 38 | 0 | 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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.