Analytics Catalog/Data dictionary/HNS_INCIDENTS_DETAIL
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

HNS_INCIDENTS_DETAIL

SharedUsed in 0 subject areas117 reporting columnsBICC incremental-ready

Health & Safety (HNS), detail-level data.

Primary key: not yet catalogued for HNS_INCIDENTS_DETAIL, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): ISSUE_TYPE_CODE → PJE_ISSUE_TYPES_VL

Columns

ColumnKeyIn reportsDescription (inferred)
ACTION_REQUIRED_FLAG●Indicator (Y/N) for the action required.
ACTUAL_COMPLETION_DATE●Actual completion date.
AIR_QUALITY_TYPE_CODE●Code identifying the air quality type.
AMOUNT_RECOVERED●Amount recovered.
AMOUNT_RECOVERED_UNIT_CD●Amount recovered unit code.
AMOUNT_SPILLED●Amount spilled.
AMOUNT_SPILLED_UNIT_CD●Amount spilled unit code.
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
ATTRIBUTE_TIMESTAMP1●Attribute timestamp1.
ATTRIBUTE_TIMESTAMP10●Attribute timestamp10.
ATTRIBUTE_TIMESTAMP2●Attribute timestamp2.
ATTRIBUTE_TIMESTAMP3●Attribute timestamp3.
ATTRIBUTE_TIMESTAMP4●Attribute timestamp4.
ATTRIBUTE_TIMESTAMP5●Attribute timestamp5.
ATTRIBUTE_TIMESTAMP6●Attribute timestamp6.
ATTRIBUTE_TIMESTAMP7●Attribute timestamp7.
ATTRIBUTE_TIMESTAMP8●Attribute timestamp8.
ATTRIBUTE_TIMESTAMP9●Attribute timestamp9.
CITATION_NUM●Citation number.
CLEANUP_TEAM_NOTIFIED●Cleanup team notified.
CLEANUP_TEAM_NOTIFIED_AT●Cleanup team notified at.
COMPLETED_FLAG●Indicator (Y/N) for the completed.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DATE_DISCLOSED●Date disclosed.
DELETED_FLAG●Indicator (Y/N) for the deleted.
EMPLOYEE_ASSIGN_ID●Identifier for the employee assign.
EMPLOYEE_ID●Identifier for the employee.
ERGONOMIC_ASS_REQ_CODE●Code identifying the ergonomic ass req.
ERGONOMIC_TYPE_CODE●Code identifying the ergonomic type.
EVENT_CREATION_DATE●Event creation date.
IMPROVEMENT_TYPE_CODE●Code identifying the improvement type.
INCIDENT_DETAIL_ID●Identifier for the incident detail.
INCIDENT_EVENT_CODE●Code identifying the incident event.
INCIDENT_EVENT_DATE●Incident event date.
INCIDENT_EVENT_NO●Incident event number.
INCIDENT_EVENT_OWNER_ID●Identifier for the incident event owner.
INCIDENT_EVENT_SUMMARY●Incident event summary.
INCIDENT_ID●Identifier for the incident.
INCI_DETAIL_DESCR●Inci detail descr.
INCI_EVENT_STATUS_CODE●Code identifying the inci event status.
INC_EVENT_OWNER_ASSIGN_ID●Identifier for the inc event owner assign.
ISSUE_TYPE_CODE●Code identifying the issue type.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●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.
LESSONS_LEARNED●Lessons learned.
LIGHT_CONDITION_CODE●Code identifying the light condition.
NEAR_MISS_CODE●Code identifying the near miss.
NOTICE_OF_VIOLATION_CD●Notice of violation code.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
POLICE_AGENCY_LOCATION●Police agency location.
POLICE_BADGE_NUM●Police badge number.
POLICE_REPORT_FLAG●Indicator (Y/N) for the police report.
PROPERTY_DAMAGE_CODE●Code identifying the property damage.
REPLN_SPILL_KIT_FLAG●Indicator (Y/N) for the repln spill kit.
RESULT_CODE●Code identifying the result.
ROAD_CONDITION_CODE●Code identifying the road condition.
SEVERITY_LEVEL_CODE●Code identifying the severity level.
SPILLKIT_DEPLOYED_FLAG●Indicator (Y/N) for the spillkit deployed.
SPILL_POSSIBLE_CAUSE_CODE●Code identifying the spill possible cause.
SPILL_RELEASE_CODE●Code identifying the spill release.
SPILL_SOURCE_CODE●Code identifying the spill source.
TARGET_COMPLETION_DATE●Target completion date.
THIRD_PARTY_DETAILS●Third party details.
TRAFFIC_CONDITION_CODE●Code identifying the traffic condition.
TRAFFIC_CONTROLS_CODE●Code identifying the traffic controls.
UNSAFE_ACT_TYPE_CODE●Code identifying the unsafe act type.
UNSAFE_CONDITION_CODE●Code identifying the unsafe condition.
VEHICLE_ACC_CATEGORY_CODE●Code identifying the vehicle acc category.
VEHICLE_COLLISION_TYPE_CODE●Code identifying the vehicle collision type.
VEHICLE_SPEED_LIMIT●Vehicle speed limit.
VEHICLE_SPEED_UNIT_CD●Vehicle speed unit code.
VEHICLE_STRUCK_BY_CODE●Code identifying the vehicle struck by.
VEHICLE_STRUCK_CODE●Code identifying the vehicle struck.
WEATHER_CONDITION_CODE●Code identifying the weather condition.
WHAT_WAS_SPILLED_OR_RELEASED●What was spilled or released.

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_INCIDENTS_DETAIL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern