INC_VEHVW_LNG (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.

INC_VEHVW_LNG

(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 ,LANGUAGE_CD ,LOCATION_NAME FROM PS_INCIDNT_DTA_LNG

Related Language Record for INCIDENT_VEH_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LOCATION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Location Name