DW_HNS_INJURED_PERSON_PART_D (Preview)

This table requires activation of Health and Safety functional area. Table stores Health and Safety Injured Person Body Part information

Details

Module: Workforce Health and Safety Incidents

Key Columns

INJURED_PERSON_PART_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INJURED_PERSON_PART_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 INJURED_PERSON_PART_ID    
INJURED_PERSON_ID NUMBER 38 0   Injured person identifier.    
INJURED_PART_CODE VARCHAR2 32     Injured person part identifer.    
INJURY_NATURE_CODE VARCHAR2 999     The nature of injury.    
INJURY_NATURE_CODE1 VARCHAR2 999     The nature of injury 1.    
INJURY_NATURE_CODE2 VARCHAR2 999     The nature of injury 2.    
INJURY_NATURE_CODE3 VARCHAR2 999     The nature of injury 3.    
DELETED_FLAG VARCHAR2 16     Flag to check whether is record is deleted.    

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