# ACTN

ACTN_LONG_DESC:
Getting on or off stopped or parked vehicle


ACTN_LONG_DESC:
Overhanging load struck another vehicle, etc.


ACTN_LONG_DESC:
Stopped in traffic not waiting to make a left turn


ACTN_LONG_DESC:
Stopped because of left turn signal or waiting, etc.


ACTN_LONG_DESC:
Proceed after stopping for a stop sign/flashing red.


ACTN_LONG_DESC:
Entering street or highway from alley or driveway


ACTN_LONG_DESC:
Entering alley or driveway from street or highway


ACTN_LONG_DESC:
Before entering roadway, struck pedestrian, etc. on sidewalk or shoulder


ACTN_LONG_DESC:
Struck, or was struck by, vehicle or pedestrian in prior collision before acc. stabilized


ACTN_LONG_DESC:
Vehicle crossed, plunged over, or through median barrier


ACTN_LONG_DESC:
Pursuing or attempting to stop another vehicle


ACTN_LONG_DESC:
Crossing at intersection - no traffic signal present


ACTN_LONG_DESC:
Crossing at intersection - traffic signal present


ACTN_LONG_DESC:
Walking, running, riding, etc., on shoulder WITH traffic


ACTN_LONG_DESC:
Walking, running, riding, etc., on shoulder FACING traffic


ACTN_LONG_DESC:
Walking, running, riding, etc., on pavement WITH traffic


ACTN_LONG_DESC:
Walking, running, riding, etc., on pavement FACING traffic


ACTN_LONG_DESC:
Pushing or working on vehicle in road or on shoulder


ACTN_LONG_DESC:
Entering / starting in traffic lane from off-road


# CAUSE

CAUSE_LONG_DESC:
Too fast for conditions (not exceed posted speed)


CAUSE_LONG_DESC:
Disregarded other traffic control device


# CRASH

JRSDCT_GRP_LONG_DESC:
Other Type Jurisdiction (non-federal land)


# CRASH_TYP

CRASH_TYP_LONG_DESC:
From same direction - both going straight


CRASH_TYP_LONG_DESC:
From same direction - one turn, one straight


CRASH_TYP_LONG_DESC:
From same direction-all others, including parking


CRASH_TYP_LONG_DESC:
From opposite direction - both going straight


CRASH_TYP_LONG_DESC:
From opposite direction - one turn, one straight


CRASH_TYP_LONG_DESC:
From opposite direction-all others incl. Parking


# DRVR_LIC_STAT

DRVR_LIC_STAT_LONG_DESC:
Unknown if driver was licensed at time of crash


# DRVR_RES_STAT

DRVR_RES_LONG_DESC:
Oregon resident 25 or more miles from home


DRVR_RES_LONG_DESC:
Oregon resident - unknown distance from home


# ERR

CRASH_ERR_LONG_DESC:
Failed to obey mandatory traffic turn signal, sign or lane markings


CRASH_ERR_LONG_DESC:
Improper or no lights (vehicle in traffic)


CRASH_ERR_LONG_DESC:
Failed to dim lights  (until 4/1/97) / Inattention (after 4/1/97)


CRASH_ERR_LONG_DESC:
Driving unsafe vehicle (no other error apparent)


CRASH_ERR_LONG_DESC:
Entering/exiting parked position w/ insufficient clearance; other improper parking maneuver


CRASH_ERR_LONG_DESC:
Disregarded warning sign, flares or flashing amber


CRASH_ERR_LONG_DESC:
Disregarded siren or warning of emergency vehicle


CRASH_ERR_LONG_DESC:
Disregarded RR signal, RR sign, or RR flagman


CRASH_ERR_LONG_DESC:
Failed to avoid stopped or parked vehicle ahead other than school bus


CRASH_ERR_LONG_DESC:
Did not have right-of-way over pedalcyclist


CRASH_ERR_LONG_DESC:
Failed to yield right-of-way to pedestrian


CRASH_ERR_LONG_DESC:
Passing on straight road under unsafe conditions


CRASH_ERR_LONG_DESC:
Passed vehicle stopped at crosswalk for pedestrian


CRASH_ERR_LONG_DESC:
Driving through safety zone or over island


CRASH_ERR_LONG_DESC:
Failed to decrease speed for slower moving vehicle


CRASH_ERR_LONG_DESC:
Following too closely (must be on officer's report)


CRASH_ERR_LONG_DESC:
Wrong way on one-way roadway (deliberately traveling on wrong side)


CRASH_ERR_LONG_DESC:
Driving too fast for conditions (not exceeding posted speed)


CRASH_ERR_LONG_DESC:
Crossing at intersection, no traffic signal present


CRASH_ERR_LONG_DESC:
Crossing at intersection, traffic signal present


CRASH_ERR_LONG_DESC:
Walking, running, riding, etc., on shoulder WITH traffic


CRASH_ERR_LONG_DESC:
Walking, running, riding, etc., on shoulder FACING traffic


CRASH_ERR_LONG_DESC:
Walking, running, riding, etc., on pavement WITH traffic


CRASH_ERR_LONG_DESC:
Walking, running, riding, etc., on pavement FACING traffic


CRASH_ERR_LONG_DESC:
Pushing or working on vehicle in road or on shoulder


CRASH_ERR_LONG_DESC:
Overloading or improper loading of vehicle with cargo or passengers


CRASH_ERR_LONG_DESC:
Unable to determine which driver disregarded traffic control device


# EVNT

EVNT_LONG_DESC:
Occupant fell, jumped or was ejected from moving vehicle


EVNT_LONG_DESC:
Animal or insect in vehicle interfered with driver


EVNT_LONG_DESC:
“Sub-Ped”: pedestrian injured subsequent to collision, etc.


EVNT_LONG_DESC:
Passenger being towed or pushed on conveyance


EVNT_LONG_DESC:
Getting on or off stopped or parked vehicle (occupants only)


EVNT_LONG_DESC:
Vehicle towed or had been towing another vehicle


EVNT_LONG_DESC:
Vehicle forced by impact into another vehicle, pedalcyclist or pedestrian


EVNT_LONG_DESC:
Vehicle set in motion by non-driver (child released brakes, etc.)


EVNT_LONG_DESC:
At or on railroad right-of-way (not Light Rail)


EVNT_LONG_DESC:
Jackknife; trailer or towed vehicle struck towing vehicle


EVNT_LONG_DESC:
Detached trailing object struck other vehicle, non-motorist, or object


EVNT_LONG_DESC:
Vehicle door opened into adjacent traffic lane


EVNT_LONG_DESC:
Stock: cow, calf, bull, steer, sheep, etc.


EVNT_LONG_DESC:
Wild animal, game (includes birds; not deer or elk)


EVNT_LONG_DESC:
Curb  (also narrow sidewalks on bridges)


EVNT_LONG_DESC:
Jiggle bars or traffic snake for channelization


EVNT_LONG_DESC:
Bridge pillar or column (even though struck protective guard rail first)


EVNT_LONG_DESC:
Bridge girder (horizontal structure overhead)


EVNT_LONG_DESC:
Pole – traffic signal and ped signal only


EVNT_LONG_DESC:
Tree branch or other vegetation overhead, etc.


EVNT_LONG_DESC:
Temporary sign or barricade in road, etc.


EVNT_LONG_DESC:
Foreign obstruction/debris in road  (not gravel)


EVNT_LONG_DESC:
Other equipment in or off road (includes parked trailer, boat)


EVNT_LONG_DESC:
Wrecker, street sweeper, snow plow or sanding equipment


EVNT_LONG_DESC:
Speed bump, other bump, pothole or pavement irregularity (per PAR)


EVNT_LONG_DESC:
Chuckhole in road, low or high shoulder at pavement edge


EVNT_LONG_DESC:
Struck by rock or other object set in motion by other vehicle (incl. lost loads)


EVNT_LONG_DESC:
View obscured by fence, sign, phone booth, etc.


EVNT_LONG_DESC:
Accident related to another separate accident


EVNT_LONG_DESC:
Two-way traffic on divided roadway all routed to one side


EVNT_LONG_DESC:
Other (phantom) non-contact vehicle (on PAR or report)


EVNT_LONG_DESC:
Teenage driver in violation of graduated license pgm


EVNT_LONG_DESC:
Cell Phone use witnessed by other participant


EVNT_LONG_DESC:
Street Car/Trolley (on rails and/or overhead wire system) struck vehicle


EVNT_LONG_DESC:
Vehicle struck Street Car/Trolley (on rails and/or overhead wire system)


EVNT_LONG_DESC:
At or on Street Car/Trolley right-of-way


EVNT_LONG_DESC:
Vehicle struck railroad equipment (not train) on tracks


EVNT_LONG_DESC:
Sliding or swerving due to wet, icy, slippery or loose surface


# FUNC_CLASS

FC_DESC:
URBAN PRINCIPAL ARTERIAL - OTHER FREEWAYS AND EXP


# INJ_SVRTY

INJ_SVRTY_LONG_DESC:
Incapacitating Injury - bleeding, broken bones


INJ_SVRTY_LONG_DESC:
Participant uninjured, over the age of 4


# INVSTG_AGY

INVSTG_AGY_LONG_DESC:
Other police (incl safety and security officers)


# JRSDCT_GRP

JRSDCT_GRP_LONG_DESC:
Other Type Jurisdiction (non-federal land)


# NON_MOTRST_LOC

NON_MOTRST_LOC_LONG_DESC:
At intersection - in roadway, outside crosswalk


NON_MOTRST_LOC_LONG_DESC:
At intersection - in roadway, xwalk avail unknwn


NON_MOTRST_LOC_LONG_DESC:
Not at intersection - within traffic right-of-way


NON_MOTRST_LOC_LONG_DESC:
Not at intersection - inside mid-block crosswalk


# PARTIC_TYP

PARTIC_TYP_LONG_DESC:
Pedestrian using a pedestrian conveyance


PARTIC_TYP_LONG_DESC:
Pedestrian towing or trailering an object, etc


PARTIC_TYP_LONG_DESC:
Pedalcyclist towing or trailering an object, etc


# RD_CNTL

RD_CNTL_LONG_DESC:
Urban Highway System outside of Portland City Limits


RD_CNTL_LONG_DESC:
Rural City Street (City not in an Urban Area)


RD_CNTL_LONG_DESC:
Sub-Urban Highway System (outside City Limits but inside Urban Boundary)


RD_CNTL_LONG_DESC:
Sub-Urban County Road (outside City Limits but inside Urban Boundary)


# RDWY

RDWY_DESC:
Add-mileage on divided highway or an undivided hwy


RDWY_DESC:
Non-add alignment on divided highway or couplet


RDWY_DESC:
Add-mileage alignment of a split roadway


RDWY_DESC:
Non-add mileage alignment of a split roadway


RDWY_DESC:
Alignment not yet built or non-state rdwy


# tblLookupTableList

LookupSql:
SELECT ACTN_CD, ACTN_LONG_DESC, ACTN_MED_DESC, ACTN_SHORT_DESC, ACTN_PARTIC_VALID_FLG, ACTN_VHCL_VALID_FLG, ACTN_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM ACTN


LookupSql:
SELECT CAUSE_CD, CAUSE_LONG_DESC, CAUSE_MED_DESC, CAUSE_SHORT_DESC, CAUSE_CRASH_VALID_FLG, CAUSE_PARTIC_VALID_FLG, CAUSE_VHCL_VALID_FLG, CAUSE_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM CAUSE


LookupSql:
SELECT CITY_SECT_ID, CITY_FIPS_HIST_START_YR_NO, CITY_FIPS_HIST_TERMNT_YR_NO, FIPS_CITY_ID, CITY_SECT_URB_RURAL_AREA_IND, LAST_UD_DT, LAST_UD_USER_ID FROM CITY_FIPS_HIST


LookupSql:
SELECT CITY_SECT_ID, CITY_SECT_NM, CITY_SECT_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM CITY_SECT


LookupSql:
SELECT CMPSS_DIR_CD, CMPSS_DIR_SHORT_DESC, CMPSS_DIR_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM CMPSS_DRCT


LookupSql:
SELECT CNTY_ID, CNTY_NM, FIPS_CNTY_ID, CNTY_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM CNTY


LookupSql:
SELECT COLLIS_TYP_CD, COLLIS_TYP_LONG_DESC, COLLIS_TYP_ALT_LONG_DESC, COLLIS_TYP_MED_DESC, COLLIS_TYP_SHORT_DESC, COLLIS_TYP_SORT_ORDR_NO, COLLIS_TYP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM COLLIS_TYP


LookupSql:
SELECT CRASH_HR_NO, CRASH_HR_LONG_DESC, CRASH_HR_MED_DESC, CRASH_HR_SHORT_DESC, CRASH_HR_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM CRASH_HR


LookupSql:
SELECT CRASH_SVRTY_CD, CRASH_SVRTY_LONG_DESC, CRASH_SVRTY_SHORT_DESC, CRASH_SVRTY_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM CRASH_SVRTY


LookupSql:
SELECT CRASH_TYP_CD, CRASH_TYP_LONG_DESC, CRASH_TYP_MED_DESC, CRASH_TYP_SHORT_DESC, CRASH_TYP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM CRASH_TYP


LookupSql:
SELECT DRVR_LIC_STAT_CD, DRVR_LIC_STAT_LONG_DESC, DRVR_LIC_STAT_SHORT_DESC, DRVR_LIC_STAT_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM DRVR_LIC_STAT


LookupSql:
SELECT DRVR_RES_STAT_CD, DRVR_RES_LONG_DESC, DRVR_RES_SHORT_DESC, DRVR_RES_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM DRVR_RES_STAT


LookupSql:
SELECT CRASH_ERR_CD, CRASH_ERR_LONG_DESC, CRASH_ERR_MED_DESC, CRASH_ERR_SHORT_DESC, CRASH_ERR_PARTIC_VALID_FLG, CRASH_ERR_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM ERR


LookupSql:
SELECT EVNT_CD, EVNT_LONG_DESC, EVNT_MED_DESC, EVNT_SHORT_DESC, EVNT_CRASH_VALID_FLG, EVNT_PARTIC_VALID_FLG, EVNT_VHCL_VALID_FLG, EVNT_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM EVNT


LookupSql:
SELECT FC_CD, FC_DESC, FC_START_YR_NO, FC_TERMNT_YR_NO, LAST_UD_DT, LAST_UD_USER_ID, FC_SHORT_DESC FROM FUNC_CLASS


LookupSql:
SELECT HWY_COMPNT_CD, HWY_COMPNT_LONG_DESC, HWY_COMPNT_MED_DESC, HWY_COMPNT_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID, HWY_COMPNT_SHORT_DESC FROM HWY_COMPNT


LookupSql:
SELECT HWY_NO, HWY_SFX_NO, HWY_LONG_NM, HWY_MED_NM, HWY_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID, ALT_HWY_NO FROM HWY_HIST


LookupSql:
SELECT IMPCT_LOC_CD, IMPCT_LOC_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM IMPCT_LOC


LookupSql:
SELECT INJ_SVRTY_CD, INJ_SVRTY_LONG_DESC, INJ_SVRTY_MED_DESC, INJ_SVRTY_SHORT_DESC, INJ_SVRTY_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM INJ_SVRTY


LookupSql:
SELECT INVSTG_AGY_CD, INVSTG_AGY_LONG_DESC, INVSTG_AGY_SHORT_DESC, INVSTG_AGY_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM INVSTG_AGY


LookupSql:
SELECT ISECT_TYP_CD, ISECT_TYP_SHORT_DESC, ISECT_TYP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM ISECT_TYP


LookupSql:
SELECT JRSDCT_GRP_CD, JRSDCT_GRP_LONG_DESC, JRSDCT_GRP_MED_DESC, JRSDCT_GRP_SHORT_DESC, JRSDCT_GRP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM JRSDCT_GRP


LookupSql:
SELECT LGT_COND_CD, LGT_COND_LONG_DESC, LGT_COND_MED_DESC, LGT_COND_SHORT_DESC, LGT_COND_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM LGT_COND


LookupSql:
SELECT MEDN_TYP_CD, MEDN_TYP_LONG_DESC, MEDN_TYP_SHORT_DESC, MEDN_TYP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM MEDN_TYP


LookupSql:
SELECT MLGE_TYP_CD, MLGE_TYP_LONG_DESC, MLGE_TYP_MED_DESC, MLGE_TYP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID, MLGE_TYP_SHORT_DESC FROM MLGE_TYP


LookupSql:
SELECT MVMNT_CD, MVMNT_LONG_DESC, MVMNT_MED_DESC, MVMNT_SHORT_DESC, MVMNT_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM MVMNT


LookupSql:
SELECT NON_MOTRST_LOC_CD, NON_MOTRST_LOC_LONG_DESC, NON_MOTRST_LOC_MED_DESC, NON_MOTRST_LOC_SHORT_DESC, NON_MOTRST_LOC_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM NON_MOTRST_LOC


LookupSql:
SELECT PARTIC_TYP_CD, PARTIC_TYP_LONG_DESC, PARTIC_TYP_MED_DESC, PARTIC_TYP_SHORT_DESC, PARTIC_TYP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM PARTIC_TYP


LookupSql:
SELECT POP_RNG_CD, POP_RNG_MED_DESC, POP_RNG_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM POP_RNG


LookupSql:
SELECT RD_CHAR_CD, RD_CHAR_LONG_DESC, RD_CHAR_MED_DESC, RD_CHAR_SHORT_DESC, RD_CHAR_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM RD_CHAR


LookupSql:
SELECT RD_CNTL_CD, RD_CNTL_MED_DESC, RD_CNTL_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID, RD_CNTL_LONG_DESC FROM RD_CNTL


LookupSql:
SELECT RD_SURF_COND_CD, RD_SURF_MED_DESC, RD_SURF_SHORT_DESC, RD_SURF_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM RD_SURF_COND


LookupSql:
SELECT RDWY_NO, RDWY_DESC, RDWY_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM RDWY


LookupSql:
SELECT RTE_TYP_CD, RTE_ID, RTE_NM, RTE_HIER_NO, RTE_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM RTE


LookupSql:
SELECT SEX_CD, SEX_DESC, SEX_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM SEX


LookupSql:
SELECT SFTY_EQUIP_USE_CD, SFTY_EQUIP_USE_LONG_DESC, SFTY_EQUIP_USE_MED_DESC, SFTY_EQUIP_USE_SHORT_DESC, SFTY_EQUIP_USE_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM SFTY_EQUIP_USE


LookupSql:
SELECT SPECL_JRSDCT_ID, JRSDCT_GRP_CD, SPECL_JRSDCT_LONG_DESC, SPECL_JRSDCT_MED_DESC, SPECL_JRSDCT_SHORT_DESC, SPECL_JRSDCT_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM SPECL_JRSDCT


LookupSql:
SELECT TRAF_CNTL_DEVICE_CD, TRAF_CNTL_DEVICE_LONG_DESC, TRAF_CNTL_DEVICE_SHORT_DESC, TRAF_CNTL_DEVICE_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM TRAF_CNTL_DEVICE


LookupSql:
SELECT URB_AREA_CD, URB_AREA_LONG_NM, URB_AREA_SHORT_NM, URB_AREA_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM URB_AREA


LookupSql:
SELECT URB_AREA_CD, URB_AREA_HIST_START_YR_NO, URB_AREA_HIST_TERMNT_YR_NO, FIPS_URB_AREA_ID, LAST_UD_DT, LAST_UD_USER_ID FROM URB_AREA_FIPS_HIST


LookupSql:
SELECT VHCL_OWNSHP_CD, VHCL_OWNSHP_LONG_DESC, VHCL_OWNSHP_SHORT_DESC, VHCL_OWNSHP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM VHCL_OWNSHP


LookupSql:
SELECT VHCL_TYP_CD, VHCL_TYP_LONG_DESC, VHCL_TYP_SHORT_DESC, VHCL_TYP_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM VHCL_TYP


LookupSql:
SELECT VHCL_USE_CD, VHCL_USE_LONG_DESC, VHCL_USE_SHORT_DESC, VHCL_USE_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM VHCL_USE


LookupSql:
SELECT WTHR_COND_CD, WTHR_COND_LONG_DESC, WTHR_COND_MED_DESC, WTHR_COND_SHORT_DESC, WTHR_COND_TERMNT_DT, LAST_UD_DT, LAST_UD_USER_ID FROM WTHR_COND


# TRAF_CNTL_DEVICE

TRAF_CNTL_DEVICE_LONG_DESC:
Left Turn Green Arrow, Lane Markings, or Signal


TRAF_CNTL_DEVICE_LONG_DESC:
Right Turn Green Arrow, Lane Markings, or Signal


TRAF_CNTL_DEVICE_LONG_DESC:
Wigwag or Flashing Lights W/O Drop-Arm Gate


TRAF_CNTL_DEVICE_LONG_DESC:
Supplemental Overhead Signal (RR xing only)


TRAF_CNTL_DEVICE_LONG_DESC:
Left Turn Refuge (when refuge is involved)


TRAF_CNTL_DEVICE_LONG_DESC:
Right Turn Prohibited on Red After Stopping


# VHCL_TYP

VHCL_TYP_LONG_DESC:
Truck tractor with no trailers (bobtail)


VHCL_TYP_LONG_DESC:
Farm tractor or self-propelled farm equipment


VHCL_TYP_LONG_DESC:
Truck Tractor with trailer/mobile home in tow


VHCL_TYP_LONG_DESC:
Truck with non-detachable bed, panel, etc.


VHCL_TYP_LONG_DESC:
Moped, minibike, motor scooter, or motor bicycle


VHCL_TYP_LONG_DESC:
Motorized Street Car/Trolley (no rails/wires)


