SF_STDNT_PRS_VW (SQL View)	Index Back
SF Student Personal Data View This is a view of Personal Data fields needed in FERPA processing.

SF_STDNT_PRS_VW

(SQL View)

SF Student Personal Data View

This is a view of Personal Data fields needed in FERPA processing.

SELECT A.EMPLID , A.NAME , C.SEX , D.CAMPUS_ID FROM PS_SCC_PRI_NAME_VW A , PS_HCR_PER_PDE_I C , PS_SCC_PERS_SA_VW D WHERE A.EMPLID = C.EMPLID AND A.EMPLID = D.EMPLID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_HCR_PER_PDE_I C1 WHERE C1.EMPLID = C.EMPLID AND C1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

4 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
4	CAMPUS_ID	Character(16)	VARCHAR2(16) NOT NULL	Campus ID