This table requires activation of Health and Safety functional area. Table stores Health and Safety Incident Event information
Module: Workforce Health and Safety Incidents
INCIDENT_DETAIL_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
INCIDENT_DETAIL_ID | NUMBER | 38 | 0 | True | Incident Detail Identifier | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | Unique Source Record Identifier which in this case is nothing but Incident Detail Identifier | ||||
INCIDENT_ID | NUMBER | 38 | 0 | Incident identifier | |||
PERSON_ID | NUMBER | 38 | 0 | Person Identifier of the Employee. | DW_PERSON_D | PERSON_ID | |
ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment ID of the Employee. | |||
INCIDENT_EVENT_NUMBER | VARCHAR2 | 64 | Incident Event Number | ||||
INCIDENT_EVENT_SUMMARY | VARCHAR2 | 999 | The Summary information entered by the reporter for each incident event. | ||||
INCIDENT_EVENT_DATE | DATE | Date incident event was reported. | |||||
INCIDENT_EVENT_DATE_TIME | TIMESTAMP | Date time incident event was reported. | |||||
INCIDENT_EVENT_STATUS_CODE | VARCHAR2 | 32 | Current Incident Event Status. | ||||
TARGET_COMPLETION_DATE | TIMESTAMP | Target completion date set for each incident event. | |||||
ACTUAL_COMPLETION_DATE | TIMESTAMP | Actual Completion date set per incident event. | |||||
INCIDENT_EVNT_OWNR_PERSON_ID | NUMBER | 38 | 0 | Owner Person Identifier for an Incident Event. Owner is an employee. | DW_PERSON_D | PERSON_ID | |
INCIDENT_EVNT_OWNR_ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment Id of the incident event owner. | |||
COMPLETED_FLAG | VARCHAR2 | 16 | Incident event completed flag. This signifies if the incident event is completed. | ||||
SEVERITY_LEVEL_CODE | VARCHAR2 | 32 | Severity level set per incident event. | ||||
EVENT_CREATION_DATE | TIMESTAMP | The date incident event was created in the system. | |||||
LESSONS_LEARNED | VARCHAR2 | 999 | Lessons Learned. | ||||
ACTION_REQUIRED_FLAG | VARCHAR2 | 16 | Check box to confirm whether an action is required. | ||||
DATE_DISCLOSED | TIMESTAMP | Date employee notified the organization about the event. | |||||
INCIDENT_EVENT_CODE | VARCHAR2 | 32 | Incident Event Code | ||||
ERGONOMIC_EVT_DETAIL_ID | NUMBER | 38 | 0 | Ergonomic Event Detail Identifier | |||
FIRE_INC_EVT_DETAIL_ID | NUMBER | 38 | 0 | Fire Incident Event Detail Identifier | |||
AIR_QUALITY_EVT_DETAIL_ID | NUMBER | 38 | 0 | Air Quality Event Detail Identifier | |||
ISSUE_EVT_DETAIL_ID | NUMBER | 38 | 0 | Issue Event Detail Identifier | |||
NEAR_MISS_EVT_DETAIL_ID | NUMBER | 38 | 0 | Near Miss Event Detail Identifier | |||
NOTICE_VIO_EVT_DETAIL_ID | NUMBER | 38 | 0 | Notice Violation Event Detail Identifier | |||
PROP_DAMAGE_EVT_DETAIL_ID | NUMBER | 38 | 0 | Property Damage Event Detail Identifier | |||
SPILL_REL_EVT_DETAIL_ID | NUMBER | 38 | 0 | Spill Release Event Detail Identifier | |||
SUGG_IMPROV_EVT_DETAIL_ID | NUMBER | 38 | 0 | Suggestion Improvement Event Detail Identifier | |||
UNSAFE_ACT_EVT_DETAIL_ID | NUMBER | 38 | 0 | Unsafe Act Event Detail Identifier | |||
UNSAFE_COND_EVT_DETAIL_ID | NUMBER | 38 | 0 | Unsafe Condition Event Detail Identifier | |||
INJURED_PERSON_SUMMARY_ID | NUMBER | 38 | 0 | Injured Person Summary Identifier | |||
DELETED_FLAG | VARCHAR2 | 16 | This column signifies whether the incident event is checked for deletion. |
Copyright © 2019, 2023, Oracle and/or its affiliates.