SCC_PERSSA_VW

(SQL View)
 Index Back

Person SA View

Person SA View used by personal data view SCC_PERDATA_VW.

SELECT P.EMPLID , SA.VA_BENEFIT , SA.CAMPUS_ID , DEATH_CERTIF_NBR , FERPA , PLACE_OF_DEATH FROM PS_PERSON P , PS_PERSON_SA SA , PS_PERSON_DT_SETUP S WHERE SA.EMPLID = P.EMPLID AND S.SA_FLG = 'Y' UNION SELECT PX.EMPLID , 'N' , ' ' , ' ' , 'N' , ' ' FROM PS_PERSON PX WHERE NOT EXISTS ( SELECT 'X' FROM PS_PERSON_SA SAX , PS_PERSON_DT_SETUP SX WHERE SAX.EMPLID = PX.EMPLID AND SX.SA_FLG = 'Y' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 VA_BENEFIT Character(1) VARCHAR2(1) NOT NULL VA Benefit

Y/N Table Edit

Default Value: N

3 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
4 DEATH_CERTIF_NBR Character(10) VARCHAR2(10) NOT NULL Death Certificate Nbr
5 FERPA Character(1) VARCHAR2(1) NOT NULL FERPA

Y/N Table Edit

Default Value: N

6 PLACE_OF_DEATH Character(30) VARCHAR2(30) NOT NULL Place of Death