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

HNS_INCIDENTS_SUMMARY

SharedUsed in 0 subject areas109 reporting columnsBICC incremental-ready

Health & Safety (HNS), summary / aggregate.

Primary key: not yet catalogued for HNS_INCIDENTS_SUMMARY, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ACTION_REQUIRED_FLAG●Indicator (Y/N) for the action required.
ACTUAL_COMPLETION_DATE●Actual completion date.
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.
ATTRIBUTE3●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.
BIZ_CONT_PLAN_ACTIVATED_AT●Biz cont plan activated at.
BIZ_CONT_PLAN_ACTIVATED_FLAG●Indicator (Y/N) for the biz cont plan activated.
BIZ_CONT_PLAN_ACT_BY_EMPID●Biz cont plan act by empid.
COMPLETED_FLAG●Indicator (Y/N) for the completed.
CONFIDENTIAL_FLAG●Indicator (Y/N) for the confidential.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DELETED_FLAG●Indicator (Y/N) for the deleted.
EMERGENCY_FLAG●Indicator (Y/N) for the emergency.
EMERG_ACTION_PLAN_ACTIVATED_AT●Emerg action plan activated at.
EMERG_ACTION_PLAN_ACT_BY_EMPID●Emerg action plan act by empid.
EMERG_ACTION_PLAN_ACT_FLAG●Indicator (Y/N) for the emerg action plan act.
EMPLOYEE_ID●Identifier for the employee.
EVACUATION_FLAG●Indicator (Y/N) for the evacuation.
EVACUATION_LENGTH_OF_TIME●Evacuation length of time.
EVACUATION_ORDERED_AT●Evacuation ordered at.
EVACUATION_ORDERED_BY_EMP_ID●Identifier for the evacuation ordered by emp.
EVACUATION_TYPE_CODE●Code identifying the evacuation type.
FACILITY_CLOSED_AT●Facility closed at.
FACILITY_CLOSED_BY_EMP_ID●Identifier for the facility closed by emp.
FACILITY_CLOSED_FLAG●Indicator (Y/N) for the facility closed.
FACILITY_CLOSED_LENGTH_OF_TIME●Facility closed length of time.
INCIDENT_APPROVER_EMAIL_FLAG●Indicator (Y/N) for the incident approver email.
INCIDENT_CREATE_DATE●Incident create date.
INCIDENT_DATE●Incident date.
INCIDENT_DESCRIPTION●Description of the incident.
INCIDENT_ID●Identifier for the incident.
INCIDENT_IMME_ACT_DESCR●Incident imme act descr.
INCIDENT_NO●Incident number.
INCIDENT_OWNER_ASSIGN_ID●Identifier for the incident owner assign.
INCIDENT_OWNER_ID●Identifier for the incident owner.
INCIDENT_REPORTED_DATE●Incident reported date.
INCIDENT_REVIEWER_EMAIL_FLAG●Indicator (Y/N) for the incident reviewer email.
INCIDENT_SOURCE_CODE●Code identifying the incident source.
INCIDENT_STATUS_CODE●Code identifying the incident status.
INCIDENT_SUMMARY●Incident summary.
INCIDENT_TYPE_CODE●Code identifying the incident 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.
LOCATION_ID●Identifier for the location.
LOCATION_TYPE_CODE●Code identifying the location type.
NOTIFIED_PERSON_ID●Identifier for the notified person.
NOTIFIED_PER_ASSIGN_ID●Identifier for the notified per assign.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
OFFSITE_LOC_TYPE_CODE●Code identifying the offsite loc type.
RADIUS●Radius.
RADIUS_UNIT_CD●Radius unit code.
REPORTER_ASSIGNMENT_ID●Identifier for the reporter assignment.
REPORTER_TYPE_CODE●Code identifying the reporter type.
REPTR_ADDR_LINE1●Reptr addr line1.
REPTR_ADDR_LINE2●Reptr addr line2.
REPTR_AREA_CODE●Code identifying the reptr area.
REPTR_CITY●Reptr city.
REPTR_COUNTRY●Reptr country.
REPTR_COUNTRY_CODE_NUM●Reptr country code number.
REPTR_EMAIL●Reptr email.
REPTR_NAME●Name of the reptr.
REPTR_NONEMP_TYPE_CODE●Code identifying the reptr nonemp type.
REPTR_PHONE_NO●Reptr phone number.
REPTR_SPECIFIC_LOCATION●Reptr specific location.
REPTR_STATE●Reptr state.
REPTR_ZIP_CODE●Code identifying the reptr zip.
SEVERITY_LEVEL_CODE●Code identifying the severity level.
TARGET_COMPLETION_DATE●Target completion date.

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