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

HNS_VEH_INC_EVENT_DETAIL

SharedUsed in 0 subject areas175 reporting columnsBICC incremental-ready

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

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

Columns

ColumnKeyIn reportsDescription (inferred)
AIRBAG_DEPLOYED_FLAG●Indicator (Y/N) for the airbag deployed.
ALCOHOL_TEST_PERFORM_FLAG●Indicator (Y/N) for the alcohol test perform.
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.
CASE_NUMBER●Case number.
CELL_PHONE_IN_USE_FLAG●Indicator (Y/N) for the cell phone in use.
COMPANY_ADDR_CITY●Company addr city.
COMPANY_ADDR_COUNTRY●Company addr country.
COMPANY_ADDR_LINE1●Company addr line1.
COMPANY_ADDR_LINE2●Company addr line2.
COMPANY_ADDR_STATE●Company addr state.
COMPANY_ADDR_ZIP_CODE●Code identifying the company addr zip.
COMPANY_VEHICLE_FLAG●Indicator (Y/N) for the company vehicle.
COMPUTER_IN_USE_FLAG●Indicator (Y/N) for the computer in use.
CONTACT_ID●Identifier for the contact.
COST_OF_RENTAL_VEHICLE●Cost of rental vehicle.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DAMAGE_DESCR●Damage descr.
DELETED_FLAG●Indicator (Y/N) for the deleted.
DESCRIBE_DAMAGE●Describe damage.
DRIVERS_LICENSE_EXP_DATE●Drivers license exp date.
DRUG_TEST_PERFORM_FLAG●Indicator (Y/N) for the drug test perform.
EMPLOYEE_ASSIGN_ID●Identifier for the employee assign.
EMPLOYEE_ID●Identifier for the employee.
EXPIRY_DATE●Expiry date.
FATALITY_FLAG●Indicator (Y/N) for the fatality.
FLEET_VEHICLE_FLG●Fleet vehicle flag.
INCIDENT_DETAIL_ID●Identifier for the incident detail.
INJURED_FLAG●Indicator (Y/N) for the injured.
INSURANCE_ADD_FLG●Insurance add flag.
INSURANCE_AGENT●Insurance agent.
INSURANCE_COMPANY_NAME●Name of the insurance company.
INSURANCE_INFORMATION_FLG●Insurance information flag.
INSURANCE_POLICY_NUMBER●Insurance policy number.
INS_EMAIL●Ins email.
INS_PHONE_AREA_CODE●Code identifying the ins phone area.
INS_PHONE_COUNTRY_CODE●Code identifying the ins phone country.
INS_PHONE_NUM●Ins phone number.
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.
LOCATION_OF_PEDESTRIAN●Location of pedestrian.
NON_COM_VEH_ADD_CITY●Non com veh add city.
NON_COM_VEH_ADD_COUNTRY●Non com veh add country.
NON_COM_VEH_ADD_LINE1●Non com veh add line1.
NON_COM_VEH_ADD_LINE2●Non com veh add line2.
NON_COM_VEH_ADD_STATE●Non com veh add state.
NON_COM_VEH_ADD_ZIP_CODE●Code identifying the non com veh add zip.
NON_COM_VEH_BODY_TYPE●Type of non com veh body.
NON_COM_VEH_CONTACT_NAME●Name of the non com veh contact.
NON_COM_VEH_LICENSE_NUM●Non com veh license number.
NON_COM_VEH_MAKE●Non com veh make.
NON_COM_VEH_MODEL●Non com veh model.
NON_COM_VEH_OWNER_NAME●Name of the non com veh owner.
NON_COM_VEH_REGISTER_FLG●Non com veh register flag.
NON_COM_VEH_REGI_COUNTRY●Non com veh regi country.
NON_COM_VEH_REGI_NUM●Non com veh regi number.
NON_COM_VEH_REGI_STATE●Non com veh regi state.
NON_COM_VEH_VIN_NUM●Non com veh vin number.
NON_COM_VEH_YEAR●Non com veh year.
NON_EMP_ADDR_CITY●Non emp addr city.
NON_EMP_ADDR_COUNTRY●Non emp addr country.
NON_EMP_ADDR_LINE1●Non emp addr line1.
NON_EMP_ADDR_LINE2●Non emp addr line2.
NON_EMP_ADDR_STATE●Non emp addr state.
NON_EMP_ADDR_ZIP_CODE●Code identifying the non emp addr zip.
NON_EMP_EMAIL●Non emp email.
NON_EMP_NAME●Name of the non emp.
NON_REL_COM_VEH_CONTACT_NAME●Name of the non rel com veh contact.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
OWNER_NAME●Name of the owner.
PAID_BY_COMPANY_FLG●Paid by company flag.
PED_DOING_PRIOR_TO_INCIDENT●Ped doing prior to incident.
PED_SAFETY_EQUIPMENT●Ped safety equipment.
PERSON_TYPE_CODE●Code identifying the person type.
PHONE_AREA_CODE●Code identifying the phone area.
PHONE_COUNTRY_CODE_NUM●Phone country code number.
PHONE_NUM●Phone number.
REGISTRATION_DATE●Registration date.
RELATED_COMPANY_FLG●Related company flag.
RELATED_COMPNAY_ID●Identifier for the related compnay.
RENTAL_AGREEMENT_NUMBER●Rental agreement number.
RENTAL_COMPANY_NAME●Name of the rental company.
RENTAL_DATE●Rental date.
RENTAL_LOCATION●Rental location.
RENTAL_VEH_REPLACEMENT_FLG●Rental veh replacement flag.
REPAIR_COST●Repair cost.
REP_COST_OF_RENTAL_VEHICLE●Rep cost of rental vehicle.
REP_INSURANCE_ADD_FLG●Rep insurance add flag.
REP_PAID_BY_COMPANY_FLG●Rep paid by company flag.
REP_RENTAL_AGREEMENT_NUMBER●Rep rental agreement number.
REP_RENTAL_COMPANY_NAME●Name of the rep rental company.
REP_RENTAL_DATE●Rep rental date.
REP_RENTAL_LOCATION●Rep rental location.
SEAT_BELT_IN_USE_FLAG●Indicator (Y/N) for the seat belt in use.
STATE_ISSUED_DRIVERS_LICENSE●State issued drivers license.
TAKEN_TO_HOSPITAL_FLAG●Indicator (Y/N) for the taken to hospital.
TOWING_COMPANY_CONTACT_DETAIL●Towing company contact detail.
VEHICLE_AREA_IMPACT_CODE●Code identifying the vehicle area impact.
VEHICLE_BODY_TYPE●Type of vehicle body.
VEHICLE_CLASSIFICATION_CODE●Code identifying the vehicle classification.
VEHICLE_COMPANY_ID_NUM●Vehicle company id number.
VEHICLE_DESCRIPTION●Description of the vehicle.
VEHICLE_DRIVERS_LICENSE_NUM●Vehicle drivers license number.
VEHICLE_DRIVER_LOCATION_CODE●Code identifying the vehicle driver location.
VEHICLE_GROSS_WEIGHT●Vehicle gross weight.
VEHICLE_HAS_AIRBAG_FLAG●Indicator (Y/N) for the vehicle has airbag.
VEHICLE_HAS_PASSENGER_FLAG●Indicator (Y/N) for the vehicle has passenger.
VEHICLE_LICENSE_PLATE_NUM●Vehicle license plate number.
VEHICLE_MAKE●Vehicle make.
VEHICLE_MODEL●Vehicle model.
VEHICLE_MODEL_YEAR●Vehicle model year.
VEHICLE_MOVEMENT_CODE●Code identifying the vehicle movement.
VEHICLE_POSITION_CODE●Code identifying the vehicle position.
VEHICLE_REGISTERED_FLAG●Indicator (Y/N) for the vehicle registered.
VEHICLE_REGISTRATION_COUNTRY●Vehicle registration country.
VEHICLE_REGISTRATION_NUM●Vehicle registration number.
VEHICLE_REGISTRATION_STATE●Vehicle registration state.
VEHICLE_SPEED●Vehicle speed.
VEHICLE_SPEED_UNIT_CD●Vehicle speed unit code.
VEHICLE_TOWED_FLAG●Indicator (Y/N) for the vehicle towed.
VEHICLE_VIN_NUM●Vehicle vin number.
VEHICLE_WEIGHT_UNIT_CD●Vehicle weight unit code.
VEH_INC_EVT_DETAIL_ID●Identifier for the veh inc evt detail.
WAS_RENTAL_FLAG●Indicator (Y/N) for the was rental.

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_VEH_INC_EVENT_DETAIL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us