HNS_INJURED_PERSONS_

HNS INJURED PERSONS. This table stores injured person related data.

Details

  • Schema: FUSION

  • Object owner: HNS

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

HNS_INJURED_PERSONS_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, INJURED_PERSON_ID

Columns

Name Datatype Length Precision Not-null Comments Status
INJURED_PERSON_ID NUMBER 18 Yes INJURED_PERSON_ID unique identifier. Primary key for HNS_INJURED_PERSON table. Active
INCIDENT_DETAIL_ID NUMBER 18 Incident Detail identifier. Foreign key for HNS_INCIDENTS_DETAIL table.
INJ_PERSON_SUMMARY_ID NUMBER 18 Foreign key for hns_injured_persons_summary table. Active
INCI_INJ_PERSON_ID NUMBER 18 Employee ID of the injured person . The column will be blank if the injured person is not an employee. Active
INCI_INJ_PERSON_ASSIGN_ID NUMBER 18 Assignment ID of the injured person . The column will be blank if the injured person is not an employee. Active
INJURED_NAME VARCHAR2 200 The name of the person (employee/non employee) who got injured. Active
INJURED_EMAIL VARCHAR2 250 The email ID of the person (employee/ non employee) injured. Active
INJURED_COUNTRY_CODE_NUM VARCHAR2 30 INJURED_COUNTRY_CODE_NUM column : Injured Person phone country code number. Active
INJURED_AREA_CODE VARCHAR2 30 INJURED_AREA_CODE column : Injured Person phone area code. Active
INJURED_PHONENO VARCHAR2 18 The phone number of the person (employee/ non employee) injured. Active
INJ_PERSON_TYPE_CODE VARCHAR2 30 Injured person type. Lookup from FND_LOOKUP EMP/NON EMP lookup. Active
ILLNESS_NATURE_CODE VARCHAR2 1000 Injured Person Illness nature Code. This column is optional and populated if the nature is illness. Active
CLASSIFICATION_CODE VARCHAR2 30 Type of injury (injury/ illness/fatality). Lookup FND_LOOKUP CLASSIFICATION_ID Active
INJ_PER_NONEMP_TYPE_CD VARCHAR2 30 Lookup column for non employee type code. FND_Lookup HNS_NON_EMPLOYEE_TYPE Active
REPORTABLE_FLAG VARCHAR2 1 REPORTABLE flag. This column signifies whether the injury is reportable. Active
WORKRELATED_FLAG VARCHAR2 1 WORK RELATED flag. Is the injury work related. Active
DELETED_FLAG VARCHAR2 1 Flag to check whether is record is deleted. Active
TIME_STARTED_WORK TIMESTAMP Time when the injured person started the work. Active
LOSTTIME_FLAG VARCHAR2 1 lost time flag. Signifies whether there was a lost of time due to injury. Active
LOST_TIME_IN_HRS VARCHAR2 10 Number of hours lost due to the incident. This is asociated with the inury. Active
RECURRING_FLAG VARCHAR2 1 Recurring flag.This column signifies whetherthe injury/incident is recurring. Active
TREATMENT_FLAG VARCHAR2 1 Treatment flag.This column signifies whether there was a treatment. Active
TREATMENT_TYPE_CODE VARCHAR2 1000 Treatment Type identifier. Lookup FND_LOOKUP TREATMENT_TYPE. Active
FATALITY_DATE TIMESTAMP The date the fatality occured if any. This column is related to injury/illness incident. Active
MED_PROF_NAME VARCHAR2 200 Medical profession name incase there was a treatment. Active
FACILITY_ADDRESS_LINE1 VARCHAR2 255 Facility address Line1 of the medical professional. Active
FACILITY_ADDRESS_LINE2 VARCHAR2 255 Facility address Line2 of the medical professional. Active
FACILITY_CITY VARCHAR2 100 Facility city of the medical professional. Active
FACILITY_COUNTRY VARCHAR2 100 Facility country of the medical professional. Active
FACILITY_STATE VARCHAR2 100 Facility state of the medical professional. Active
FACILITY_ZIP_CODE NUMBER Facility zipcode of the medical professional. Active
PERSON_ACTIVITY_DESCR CLOB Description of the activity for the injuried person. Active
PER_INFORMED_INJ_ILL_DATE TIMESTAMP Date and Time Person was Informed about the Injury, Illness or Fatality.
INJ_ILL_INFRMD_BY_PER_NAME NUMBER 18 Name of the Person Informed about the Injury, Illness or Fatality.
INJ_ILL_OCCURED_DATE TIMESTAMP Date and Time Injury, Illness or Fatality Occurred.
TIME_FINISHED_WORK TIMESTAMP Date and Time Finished Work.
HRS_AT_WRK_BEFORE_INJ_ILL NUMBER 18 Number of Hours at Work Before Injury, Illness or Fatality Occurred.
REGULATOR_NOTIFIED_FLAG VARCHAR2 20 Regulator Notified Flag.
REGULATOR_NOTIFIED_DATE TIMESTAMP Date and Time Regulator Notified.
REGULATOR_NOTIFIED_BY NUMBER 18 Regulator Notified by Whom.
REGULATR_NOTIFIED_MEDIUM_CD VARCHAR2 1000 How was the regulator notified.Lookup from FND_LOOKUP.ORA_HNS_HOW_NOTIFIED.
RECORDABLE_TYPE_CD VARCHAR2 2000 Recordable Type.Lookup from FND_LOOKUP.ORA_HNS_RECORDABLE_TYPE.
DESCRIPTION_OF_TREATMENT VARCHAR2 4000 Description of Treatment.
FACILITY_NAME VARCHAR2 255 Facility Name.
PREV_INJ_ILL_DATE TIMESTAMP Date of Previous Injury or Illness.
INJ_ILL_DEV_OVER_TIME_FLAG VARCHAR2 1 Did the injury or illness develop over time.
SYM_FIRST_NOTICED_DATE TIMESTAMP Date Symptoms First Noticed.
PER_UNABLE_TO_WRK_FLAG VARCHAR2 1 Was the person unable to work for at least one full day after the injury or illness.
DAYS_AWAY_FROM_WRK NUMBER 18 Number of Days Away from Work.
DISAB_DAYS_AWY_FRM_WRK_DT TIMESTAMP Date that Disability or Days Away from Work Began.
EMP_RTN_TO_WRK_FLAG VARCHAR2 1 Has the employee returned to work Flag.
RTN_TO_WRK_DATE TIMESTAMP Return to Work Date.
RTN_TO_WRK_TYPE_CD VARCHAR2 30 Return to Work Type.Lookup from FND_LOOKUP.ORA_HNS_RETURN_TO_WORK.
XFR_RESTRICTN_DAYS NUMBER 18 Number of Days on Transfer or Restriction.
MOD_DUTIES_RESTRICTN_DESCR VARCHAR2 4000 Describe Modified Duties or Restrictions.
SOURCE_OF_INJURY_LVL2_CODE VARCHAR2 30 Source of Injury Level 2. Used to declare the level 2 sources for injury or illness analysis. Lookup from FND_LOOKUP.ORA_HNS_SOURCE_II.
SOURCE_OF_INJURY_LVL3_CODE VARCHAR2 30 Source of Injury Level 3. Used to declare the level 3 sources for injury or illness analysis. Lookup from FND_LOOKUP.ORA_HNS_SOURCE_LEVEL_III.
SOURCE_OF_INJURY_LVL4_CODE VARCHAR2 30 Source of Injury Level 4. Used to declare the level 4 sources for injury or illness analysis. Lookup from FND_LOOKUP.ORA_HNS_SOURCE_LEVEL_IV.
INJURY_MECHANISM_LVL2_CODE VARCHAR2 30 Mechanism of Injury Level 2. Used to declare the level 2 mechanisms for injury or illness analysis. Lookup from FND_LOOKUP.ORA_HNS_MECHANISM_II.
INJURY_MECHANISM_LVL3_CODE VARCHAR2 30 Mechanism of Injury Level 3. Used to declare the level 3 mechanisms for injury or illness analysis. Lookup from FND_LOOKUP.ORA_HNS_MECHANISM_III.
INJURY_MECHANISM_LVL4_CODE VARCHAR2 30 Mechanism of Injury Level 4. Used to declare the level 4 mechanisms for injury or illness analysis. Lookup from FND_LOOKUP.ORA_HNS_MECHANISM_IV.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
RECORDABLE_FLAG VARCHAR2 1 Recordable Flag Column. Lookup from FND_LOOKUP.YES_NO. Active
JOB_TRANSFER_FLAG VARCHAR2 1 Job Transfer or Restriction Flag Column. Lookup from FND_LOOKUP.YES_NO. Active
INJURY_MECHANISM_CODE VARCHAR2 30 Mechanism of Injury Column. Lookup from FND_LOOKUP.ORA_HNS_MECHANISM. Active
SOURCE_OF_INJURY_CODE VARCHAR2 30 Source of Injury Column. Lookup from FND_LOOKUP.ORA_HNS_SOURCE. Active
CASE_NUMBER VARCHAR2 256 Unique system generated sequential case number of injured or ill person record.
TX_FACILITY_ZIP_CODE VARCHAR2 100 Treatment Facility zipcode of the medical professional.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns Status
HNS_INJURED_PERSONSN1_ Non Unique Default INJURED_PERSON_ID, LAST_UPDATE_DATE
HNS_INJURED_PERSONS_UK1_ Unique FUSION_TS_TX_IDX LAST_UPDATE_DATE, LAST_UPDATED_BY, INJURED_PERSON_ID Active