PERS_INJ_VW (SQL View)	Index Back
EE Personal Injury View PERS_INJ_VW is a view used as F4 prompt support on the Health and Safety individual search record. It retrieves only employees who have had an injury or illness.

PERS_INJ_VW

(SQL View)

EE Personal Injury View

PERS_INJ_VW is a view used as F4 prompt support on the Health and Safety individual search record. It retrieves only employees who have had an injury or illness.

SELECT A.EMPLID ,B.NAME FROM PS_INJURY_ILL A ,PS_PERSON_NAME B WHERE B.EMPLID = A.EMPLID AND A.INCIDENT_NBR = ( SELECT MAX(INCIDENT_NBR) FROM PS_INJURY_ILL C WHERE C.EMPLID = A.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name