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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.