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 | This column is for Oracle Internal use only. 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. | ||||
| CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. |
Copyright © 2019, 2025, Oracle and/or its affiliates.