INJ_INCVW2_LNG (SQL View)	Index Back
Injury Claims Incident View INJ_CLM_INCD_VW is a view of selected data from INJURY_ILL and INCIDENT_DATA that sorts incident data by employee ID or non-employee ID. This view is used in Health and Safety as an edit table for the INCIDENT_NBR field, retrieving only the incidents in which a particular person was involved.

INJ_INCVW2_LNG

(SQL View)

Injury Claims Incident View

INJ_CLM_INCD_VW is a view of selected data from INJURY_ILL and INCIDENT_DATA that sorts incident data by employee ID or non-employee ID. This view is used in Health and Safety as an edit table for the INCIDENT_NBR field, retrieving only the incidents in which a particular person was involved.

SELECT A.EmplID , A.Incident_Nbr , C.LANGUAGE_CD , C.Location_Name FROM PS_INJURY_ILL A , PS_INCIDNT_DTA_LNG C WHERE A.INCIDENT_NBR = C.INCIDENT_NBR

Related Language Record for INJ_CLM_INC2_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
Prompt Table: INJURY_ILL_VW

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number Prompt Table: INJURY_ILL_VW
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LOCATION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Location Name