SFA_NSLDS_STUVW (SQL View)	Index Back
Student Aid/People Data View SFA_NSLDS_STUVW is a copy of STDNT_AID_SRCH but with the key ordering of OPRCLASS, INSTITUTION, AID_YEAR and EMPLID. This view is used as a prompt table for NSLDS Request Process.

SFA_NSLDS_STUVW

(SQL View)

Student Aid/People Data View

SFA_NSLDS_STUVW is a copy of STDNT_AID_SRCH but with the key ordering of OPRCLASS, INSTITUTION, AID_YEAR and EMPLID. This view is used as a prompt table for NSLDS Request Process.

SELECT A.OPRCLASS , N.INSTITUTION , N.AID_YEAR , N.EMPLID , B.COUNTRY , B.NATIONAL_ID_TYPE , B.NID_DESCRSHORT , B.NATIONAL_ID , B.NATIONAL_ID_MSK , A.BIRTHDATE , A.BIRTHDATE_MSK , D.NAME , D.FIRST_NAME , D.LAST_NAME , A.CAMPUS_ID , D.LAST_NAME_SRCH , D.FIRST_NAME_SRCH FROM PS_PERSON_MSK_VW A , PS_PERS_NID_MSK_VW B , PS_HCR_PERSON_NM_I D , PS_STUDENT_AID N WHERE A.OPRCLASS = B.OPRCLASS AND A.EMPLID = B.EMPLID AND A.EMPLID = D.EMPLID AND A.EMPLID = D.EMPLID AND A.EMPLID = N.EMPLID

Parent record: STUDENT_AID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table: AID_YEAR_TBL

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

5 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country

6 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
Prompt Table: HCR_NID_TYP_I

7 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description

8 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

9 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID

10 BIRTHDATE Date(10) DATE Date of Birth

11 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth

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

13 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

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

16 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

17 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
3	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
5	NID_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	National ID Country
6	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type Prompt Table: HCR_NID_TYP_I
7	NID_DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	NID Short Description
8	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
9	NATIONAL_ID_MSK	Character(20)	VARCHAR2(20) NOT NULL	National ID
10	BIRTHDATE	Date(10)	DATE	Date of Birth
11	BIRTHDATE_MSK	Character(10)	VARCHAR2(10) NOT NULL	Date of Birth
12	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
15	CAMPUS_ID	Character(16)	VARCHAR2(16) NOT NULL	Campus ID
16	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
17	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name