DW_HNS_NOTICE_VIOLATION_EVENT_D (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Notice Violation Event information

Details

Module: Workforce Health and Safety Incidents

Key Columns

NOTICE_VIO_EVT_DETAIL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
NOTICE_VIO_EVT_DETAIL_ID NUMBER 38 0 True System generated primary key column.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Unique Source Record Identifier with NOTICE_VIO_EVT_DETAIL_ID
INCIDENT_DETAIL_ID NUMBER 38 0 Incident Detail identifier.
NOTICE_OF_VIOLATION_CODE VARCHAR2 32 Notice of violation sent per incident event.
DELETED_FLAG VARCHAR2 16 This column signifies whether the incident event is checked for deletion.