DW_HNS_INCIDENT_AGENCY_D (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Incident Agency information

Details

Module: Workforce Health and Safety Incidents

Key Columns

INCIDENT_AGENCY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INCIDENT_AGENCY_ID NUMBER 38 0 True Incident Agency Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
INCIDENT_ID NUMBER 38 0 Incident Identifier
NOTIFIED_AGENCY_CODE VARCHAR2 32 Notified Agency Code
DATE_NOTIFIED TIMESTAMP Date the agencies are notified
NOTIFIED_BY VARCHAR2 64 Agencies notified by person(employee)
DATE_SITE_ATTENDED TIMESTAMP The date the site was attended by the notified agency
ATTENDED_SITE_FLAG VARCHAR2 16 Attended Site flag. To check if the agencies attended the site
DELETED_FLAG VARCHAR2 16 Deleted flag.This column signifies whether the incident agency is checked for deletion