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 AND b.property_id = c.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 |