VEH_EQ_INC_VW(SQL View) |
Index Back |
|---|---|
Vehicle Equip Incident ViewView used by Crystal report OHS016-- Veh/Equip Incident Summary |
| select a.incident_nbr, a.incident_dt, a.road_condition, a.weather_condition, b.property_id, d.descr, d.veh_equip_make, d.veh_equip_model, d.veh_equip_year, d.license_plate_id, c.est_veh_eqp_damage, c.est_prpty_dmg_amt, c.veh_eqp_dmg_amt, c.prpty_dmg_amt, b.emplid, b.non_employee_id, b.employee_role from PS_INCIDENT_DATA a, ps_incdnt_veh_empl b, ps_incidnt_vehicle c, ps_comp_prop_tbl d where a.incident_nbr = b.incident_nbr and a.incident_nbr = c.incident_nbr and b.property_id = d.property_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 2 | INCIDENT_DT | Date(10) | DATE | Incident Date |
| 3 | ROAD_CONDITION | Character(1) | VARCHAR2(1) NOT NULL |
Road Condition
D=Dry I=Icy L=Loose Sand/Gravel M=Muddy N=Not Applicable S=Snow W=Wet |
| 4 | WEATHER_CONDITION | Character(2) | VARCHAR2(2) NOT NULL |
Weather Condition
CL=Cloudy EQ=Earthquake FF=Flash Flood FL=Flood FO=Foggy HU=Hurricane NA=Not Applicable RA=Rain SL=Sleet SN=Snow SU=Sunny/Clear TO=Tornado UN=Unclassified |
| 5 | PROPERTY_ID | Character(10) | VARCHAR2(10) NOT NULL | Property Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | VEH_EQUIP_MAKE | Character(18) | VARCHAR2(18) NOT NULL | Make / Manufacturer |
| 8 | VEH_EQUIP_MODEL | Character(18) | VARCHAR2(18) NOT NULL | Vehicle/Equipment Model |
| 9 | VEH_EQUIP_YEAR | Number(4,0) | SMALLINT NOT NULL | Vehicle/Equipment Year |
| 10 | LICENSE_PLATE_ID | Character(7) | VARCHAR2(7) NOT NULL | License Plate |
| 11 | EST_VEH_EQP_DAMAGE | Number(19,3) | DECIMAL(18,3) NOT NULL | Est Veh/Equip Damage Amount |
| 12 | EST_PRPTY_DMG_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Est Property Damage Amount |
| 13 | VEH_EQP_DMG_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Veh/Equip Damage Amount |
| 14 | PRPTY_DMG_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Property Damage Amount |
| 15 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 16 | NON_EMPLOYEE_ID | Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 17 | EMPLOYEE_ROLE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Role
B=Bystander/Pedestrian D=Driver|Operator P=Passenger |