SFA_NAC_IM_SRCH

(SQL View)
 Index Back

Srch View for IM Test Harness

This Record is used as Search View for IM Tester Harness Utility

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.APP_SOURCE_CODE , ( SELECT SFA_PF_TXN_NBR FROM PS_INST_CONTROL C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR= A.AID_YEAR AND C.APP_SOURCE_CODE = A.APP_SOURCE_CODE) AS SFA_PF_TXN_NBR , A.SFA_PF_HHOLD_TYPE FROM PS_INST_PARENT A WHERE A.AID_YEAR >= '2025' AND A.SFA_PF_HHOLD_TYPE <> ' ' UNION SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.APP_SOURCE_CODE , ( SELECT SFA_PF_TXN_NBR FROM PS_INST_CONTROL C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR= A.AID_YEAR AND C.APP_SOURCE_CODE = A.APP_SOURCE_CODE) AS SFA_PF_TXN_NBR , A.SFA_PF_HHOLD_TYPE FROM PS_INST_PARENT_N A WHERE A.AID_YEAR >= '2025' AND A.SFA_PF_HHOLD_TYPE <> ' '

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

Prompt Table: PERSONAL_DATA

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: SFA_NAC_TST_VW

4 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Electronic Renewal Aplication
3=Electronic Correction
4=FAFSA Express
5=ACT
6=I-NET
7=NCS
8=Profile
9=Institutional Application
O=FT Canada Student Loan
P=PT Canada Student Loan
5 SFA_PF_TXN_NBR Number(1,0) SMALLINT NOT NULL This field is used to hold the Transaction umber of the Profile files
6 SFA_PF_HHOLD_TYPE Character(1) VARCHAR2(1) NOT NULL HouseHold Type
A=HHA
B=HHB
C=HHA / HHB