INJ_CLMINVW_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_CLMINVW_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.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_INCD_V3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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 Prompt Table: INJURY_ILL_VW
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LOCATION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Location Name