nebraska mapping
← All states
Crash fields (14)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
StateCode |
Constant |
Always Nebraska (USStateNumericCode) |
StateUniqueCrashID |
Column |
Raw passthrough of column 'K.original_crash_key' |
AgencyOrPoliceJurisdiction |
Column |
Raw passthrough of column 'I.agency_name' (default "(not available in this source year)" if blank) |
PoliceReportedCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
StateReportableCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
CrashDate |
ExcelSerialDateTimeSplit |
Excel-serial date/time split from column 'GI.crash_date_time' |
RoadwayClearanceDate |
SameAs |
Copies the already-computed value of 'CrashDate' |
RoadwayClearanceTime |
ConstantSentinel |
Always the sentinel RoadClearanceTimeExtCode.Unknown (no real source data for this field) |
AtmosphericConditionsCode |
ListLookup |
Crosswalk lookup (single value wrapped in a list): column 'CC.weather1' via weather.csv |
LightConditionCode |
Lookup |
Crosswalk lookup: column 'CC.light_condition' via light-condition.csv |
SchoolBusRelatedCode |
Lookup |
Crosswalk lookup: column 'CC.school_bus_related' via school-bus-related.csv |
MannerofCollisionCode |
Lookup |
Crosswalk lookup: column 'CC.fhe_manner_of_crash' via manner-of-collision.csv |
CrashCountyCode |
CountyLookup |
County FIPS lookup from column 'CL.county_id' via county-crosswalk.csv |
GlobalPosition |
CoordinatePair |
Lat/long pair from 'SML.latitude' (lat) / 'SML.longitude' (lon) - (0,0) treated as "no location" |
Vehicle fields (11)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
VehicleNumber |
IntColumn |
Integer passthrough of column 'V.vehicle_reference_number' |
VINCode |
UnionValue |
Raw passthrough of column 'VD.vin' into a value-or-sentinel field |
MotorVehicleModelYearCode |
NumericOrZeroSentinel |
Numeric passthrough of column 'VD.vehicle_model_year'; 0 is treated as the sentinel ModelYearCode.Unknown |
VehicleBodyCategory.VehicleBodyTypeCode |
Lookup |
Crosswalk lookup: column 'VD.vehicle_body_style' via vehicle-body-style.csv |
ExtentofDamageCode |
Lookup |
Crosswalk lookup: column 'VDA.extent_of_damage' via extent-of-damage.csv |
VehicleStatusPriortoCriticalEventCode |
Lookup |
Crosswalk lookup: column 'VM.vehicle_maneuver' via vehicle-maneuver.csv |
MotorVehicleUnitTypeCode |
Lookup |
Crosswalk lookup: column 'VD.vehicle_unit_type' via vehicle-unit-type.csv |
TrafficControlDeviceCode |
Lookup |
Crosswalk lookup: column 'VR.traffic_control_devices1' via traffic-control-device.csv |
DeviceFunctioningCode |
Lookup |
Crosswalk lookup: column 'VR.traffic_control_device_inoperative1' via device-functioning.csv |
InitialContactPointCode |
Lookup |
Crosswalk lookup: column 'VDA.impact_point' via initial-contact-point.csv |
DamagedAreasCode |
RepeatedRowLookup |
One row per real value in child table 'damage_areas', column 'VDDA.damaged_area' via damaged-areas.csv (1 code(s) expand to multiple target values) |
Person fields (6)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
PersonTypeCode |
Lookup |
Crosswalk lookup: column 'PI.person_type' via occupant-person-type.csv (default PersonTypeCode.UnknownOccupantTypeInAMotorVehicleInTransport if unmapped) |
SexCode |
Lookup |
Crosswalk lookup: column 'PI.sex' via sex.csv |
VehicleNumber |
IntColumn |
Integer passthrough of column 'V.vehicle_reference_number' |
InjuryStatusCode |
Lookup |
Crosswalk lookup: column 'PI.injury_severity' via injury-status.csv |
EjectionCode |
Lookup |
Crosswalk lookup: column 'OCCI.ejected' via ejection.csv |
RestraintSystemUse.RestraintSysteminUseCode |
Lookup |
Crosswalk lookup: column 'OCCI.restraint_use' via restraint-system-in-use.csv |
Person overrides (1)
When PersonTypeCode = DriverOfAMotorVehicleInTransport, source the fields below
from the joined vehicles row (V.vehicle_reference_number = V.vehicle_reference_number):
| Target (MMUCC6) |
Rule kind |
Source |
|---|
Driver.DriverLicenseJurisdiction.DriverLicenseJurisdictionTypeCode |
Lookup |
Crosswalk lookup: column 'DL.type_of_jurisdiction' via driver-license-jurisdiction.csv |
Driver.SpeedingRelatedCode |
Lookup |
Crosswalk lookup: column 'DI.speeding_related' via speeding-related.csv |
Driver.DriverRelatedFactorsCode |
MultiColumnSetLookup |
Multiple source columns/tables combined into one deduplicated list: DI.action_at_time_of_crash1, DI.action_at_time_of_crash2, DI.action_at_time_of_crash3, DI.action_at_time_of_crash4 via driver-actions.csv; OI.operator_condition1, OI.operator_condition2 via driver-condition.csv |
Driver.DriverDistractionCode |
ConditionalThenComposite |
Sentinel short-circuits on 'OI.distracted_action' (3 case(s)), else composite lookup 'OI.distracted_action' + 'OI.distracted_source' via driver-distracted-by.csv |
AlcoholTest.AlcoholTestStatusCode |
Lookup |
Crosswalk lookup: column 'AT.alcohol_test_status' via alcohol-test-status.csv |
AlcoholTest.AlcoholTestSpecimenCode |
Lookup |
Crosswalk lookup: column 'AT.alcohol_test_type' via alcohol-test-type.csv |
AlcoholTest.AlcoholTestResultCode |
NumericOrSentinelLookup |
Primary numeric value from 'AT.blood_alcohol_level'; if blank/zero, sentinel looked up from 'AT.blood_alcohol_result' via alcohol-test-result.csv |
LawEnforcementSuspectsAlcoholInvolvementCode |
Lookup |
Crosswalk lookup: column 'AT.alcohol_suspected' via alcohol-suspected.csv |
LawEnforcementSuspectsDrugInvolvementCode |
Lookup |
Crosswalk lookup: column 'DT.drug_suspected' via drugs-suspected.csv |