SCC_NSIPDATA_VW (SQL View)	Index Back
National Student Index Person National Student Index Personal Data View

SCC_NSIPDATA_VW

(SQL View)

National Student Index Person

National Student Index Personal Data View

SELECT A.EMPLID ,A.NAME ,B.SEX ,C.BIRTHDATE FROM PS_HCR_PERS_DTA_I A ,PS_HCR_PER_PDE_I B ,PS_HCR_PERSON_I C WHERE B.EMPLID = A.EMPLID AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_HCR_PER_PDE_I B2 WHERE B2.EMPLID = B.EMPLID AND B2.EFFDT <= %CurrentDateIn ) AND C.EMPLID = B.EMPLID

# 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 BIRTHDATE Date(10) DATE Date of Birth

#	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	BIRTHDATE	Date(10)	DATE	Date of Birth