GPCN_DISABLE_VW

(SQL View)
Index Back

Employee Disability View

This view will list the disability of the employees give on Disability record.

SELECT DISTINCT A.EMPLID ,A.DISABLED FROM PS_DISABILITY A , PS_JOB B WHERE A.EMPLID = B.EMPLID AND B.REG_REGION ='CHN'

# 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.