INCIDENT_VEH_VW (SQL View)	Index Back
Vehicle Incident Search View INCIDENT_VEH_VW is a view of INCIDENT_DATA used in Health and Safety as a search view to select only those incidents that involved company vehicles and/or heavy equipment.

INCIDENT_VEH_VW

(SQL View)

Vehicle Incident Search View

INCIDENT_VEH_VW is a view of INCIDENT_DATA used in Health and Safety as a search view to select only those incidents that involved company vehicles and/or heavy equipment.

SELECT INCIDENT_NBR ,LOCATION_NAME ,COUNTRY ,STATE FROM PS_INCIDENT_DATA WHERE INCIDENT_TYPE = 'V'

Related Language Record: INC_VEHVW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

2 LOCATION_NAME Character(30) VARCHAR2(30) NOT NULL Location Name

3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table: COUNTRY_TBL

4 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
2	LOCATION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Location Name
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL
4	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL