Oracle Fusion · Data dictionary
HNS_INJURED_PERSONS
SharedUsed in 0 subject areas72 reporting columnsBICC incremental-ready
Health & Safety (HNS).
Likely primary key: INJURED_PERSON_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CASE_NUMBER | ● | Case number. | |
| CLASSIFICATION_CODE | ● | Code identifying the classification. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DAYS_AWAY_FROM_WRK | ● | Days away from wrk. | |
| DELETED_FLAG | ● | Indicator (Y/N) for the deleted. | |
| DESCRIPTION_OF_TREATMENT | ● | Description of treatment. | |
| DISAB_DAYS_AWY_FRM_WRK_DT | ● | Disab days awy frm wrk date. | |
| EMP_RTN_TO_WRK_FLAG | ● | Indicator (Y/N) for the emp rtn to wrk. | |
| FACILITY_ADDRESS_LINE1 | ● | Facility address line1. | |
| FACILITY_ADDRESS_LINE2 | ● | Facility address line2. | |
| FACILITY_CITY | ● | Facility city. | |
| FACILITY_COUNTRY | ● | Facility country. | |
| FACILITY_NAME | ● | Name of the facility. | |
| FACILITY_STATE | ● | Facility state. | |
| FACILITY_ZIP_CODE | ● | Code identifying the facility zip. | |
| FATALITY_DATE | ● | Fatality date. | |
| HRS_AT_WRK_BEFORE_INJ_ILL | ● | Hrs at wrk before inj ill. | |
| ILLNESS_NATURE_CODE | ● | Code identifying the illness nature. | |
| INCIDENT_DETAIL_ID | ● | Identifier for the incident detail. | |
| INCI_INJ_PERSON_ASSIGN_ID | ● | Identifier for the inci inj person assign. | |
| INCI_INJ_PERSON_ID | ● | Identifier for the inci inj person. | |
| INJURED_AREA_CODE | ● | Code identifying the injured area. | |
| INJURED_COUNTRY_CODE_NUM | ● | Injured country code number. | |
| INJURED_EMAIL | ● | Injured email. | |
| INJURED_NAME | ● | Name of the injured. | |
| INJURED_PERSON_ID | PK? | ● | Identifier for the injured person. |
| INJURED_PHONENO | ● | Injured phoneno. | |
| INJURY_MECHANISM_CODE | ● | Code identifying the injury mechanism. | |
| INJURY_MECHANISM_LVL2_CODE | ● | Code identifying the injury mechanism lvl2. | |
| INJURY_MECHANISM_LVL3_CODE | ● | Code identifying the injury mechanism lvl3. | |
| INJURY_MECHANISM_LVL4_CODE | ● | Code identifying the injury mechanism lvl4. | |
| INJ_ILL_DEV_OVER_TIME_FLAG | ● | Indicator (Y/N) for the inj ill dev over time. | |
| INJ_ILL_INFRMD_BY_PER_NAME | ● | Name of the inj ill infrmd by per. | |
| INJ_ILL_OCCURED_DATE | ● | Inj ill occured date. | |
| INJ_PERSON_TYPE_CODE | ● | Code identifying the inj person type. | |
| INJ_PER_NONEMP_TYPE_CD | ● | Inj per nonemp type code. | |
| JOB_TRANSFER_FLAG | ● | Indicator (Y/N) for the job transfer. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LOSTTIME_FLAG | ● | Indicator (Y/N) for the losttime. | |
| LOST_TIME_IN_HRS | ● | Lost time in hrs. | |
| MED_PROF_NAME | ● | Name of the med prof. | |
| MOD_DUTIES_RESTRICTN_DESCR | ● | Mod duties restrictn descr. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PERSON_ACTIVITY_DESCR | ● | Person activity descr. | |
| PER_INFORMED_INJ_ILL_DATE | ● | Per informed inj ill date. | |
| PER_UNABLE_TO_WRK_FLAG | ● | Indicator (Y/N) for the per unable to wrk. | |
| PREV_INJ_ILL_DATE | ● | Prev inj ill date. | |
| RECORDABLE_FLAG | ● | Indicator (Y/N) for the recordable. | |
| RECORDABLE_TYPE_CD | ● | Recordable type code. | |
| RECURRING_FLAG | ● | Indicator (Y/N) for the recurring. | |
| REGULATOR_NOTIFIED_BY | ● | Regulator notified by. | |
| REGULATOR_NOTIFIED_DATE | ● | Regulator notified date. | |
| REGULATOR_NOTIFIED_FLAG | ● | Indicator (Y/N) for the regulator notified. | |
| REGULATR_NOTIFIED_MEDIUM_CD | ● | Regulatr notified medium code. | |
| REPORTABLE_FLAG | ● | Indicator (Y/N) for the reportable. | |
| RTN_TO_WRK_DATE | ● | Rtn to wrk date. | |
| RTN_TO_WRK_TYPE_CD | ● | Rtn to wrk type code. | |
| SOURCE_OF_INJURY_CODE | ● | Code identifying the source of injury. | |
| SOURCE_OF_INJURY_LVL2_CODE | ● | Code identifying the source of injury lvl2. | |
| SOURCE_OF_INJURY_LVL3_CODE | ● | Code identifying the source of injury lvl3. | |
| SOURCE_OF_INJURY_LVL4_CODE | ● | Code identifying the source of injury lvl4. | |
| SYM_FIRST_NOTICED_DATE | ● | Sym first noticed date. | |
| TIME_FINISHED_WORK | ● | Time finished work. | |
| TIME_STARTED_WORK | ● | Time started work. | |
| TREATMENT_FLAG | ● | Indicator (Y/N) for the treatment. | |
| TREATMENT_TYPE_CODE | ● | Code identifying the treatment type. | |
| TX_FACILITY_ZIP_CODE | ● | Code identifying the tx facility zip. | |
| WORKRELATED_FLAG | ● | Indicator (Y/N) for the workrelated. | |
| XFR_RESTRICTN_DAYS | ● | Xfr restrictn days. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Subject areas
- —
Need the extract + dbt staging for HNS_INJURED_PERSONS?
We ship parameterized SQL, BICC config, and dbt models you own.