DISABLTY_ESP_VW (SQL View)	Index Back
Disability View ESP Disability View for Spain. Outer Join with Personal Data

DISABLTY_ESP_VW

(SQL View)

Disability View ESP

Disability View for Spain. Outer Join with Personal Data

SELECT A.EMPLID ,%Coalesce(B.DISABLED, 'N') FROM PS_PERSONAL_DATA A LEFT OUTER JOIN PS_DISABILITY B ON A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled.