SFA_PF_SRCH_VW

(SQL View)
 Index Back

Profile/NA Suspended People

Profile/NA Suspended People

SELECT DISTINCT B.OPRCLASS ,A.CSS_ID ,A.INSTITUTION ,A.AID_YEAR ,A.APP_SOURCE_CODE ,A.SFA_PF_QUEUE_INST ,A.SFA_PF_ALT_INST ,A.SFA_PF_HHOLD_TYPE ,A.SFA_PF_LOAD_STATUS ,A.SUSPEND_REASON ,A.SFA_PF_SKIP_REASON ,B.SSN ,B.SSN_MSK ,A.CSS_SCHOOL_CODE ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH FROM PS_SFA_PF_CNTRL_ST A , PS_SFA_PF_COM_VW B WHERE A.SFA_PF_QUEUE_INST = B.SFA_PF_QUEUE_INST AND A.INSTITUTION=B.INSTITUTION AND A.CSS_ID=B.CSS_ID AND A.AID_YEAR=B.AID_YEAR AND A.APP_SOURCE_CODE=B.APP_SOURCE_CODE AND (A.SFA_PF_LOAD_STATUS = 'S' OR A.SFA_PF_LOAD_STATUS = 'K' OR A.SFA_PF_LOAD_STATUS ='Q')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Prompt Table: SFA_PF_AID_YEAR

5 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

Default Value: 8

6 SFA_PF_QUEUE_INST Number(9,0) DECIMAL(9) NOT NULL Load Instance

Prompt Table: SFA_PF_LDINS_VW

7 SFA_PF_ALT_INST Character(5) VARCHAR2(5) NOT NULL Alternate Institution

Prompt Table: INSTITUTION_TBL

8 SFA_PF_HHOLD_TYPE Character(1) VARCHAR2(1) NOT NULL HouseHold Type
A=HHA
B=HHB
C=HHA / HHB
9 SFA_PF_LOAD_STATUS Character(1) VARCHAR2(1) NOT NULL Load Status
D=Discarded
E=Error Encountered
K=Skipped
L=Loaded
P=Processed
Q=User Delete
S=Suspended
U=Unprocessed
10 SUSPEND_REASON Character(1) VARCHAR2(1) NOT NULL Suspend Reason
1=1 - Student ID not Found
2=2 - Student not at Load Level
3=3 - Final Review Flag Set
4=4 - No SAI Calculation
5=5 - Invalid School Code
6=6 - Student Id already Exists
7=ISIR Tran Nbr out of Sequence
8=8 - Registration Only Record
9=9 -Non-Unique Student ID Found
A=A - Student not at Admit Level
E=SAI Mismatch
F=10 - FA Term Not Built
H=13 - HHB Add Person Suspend
L=Load Update Profile Set To No
M=11 - Manually Set to Suspended
P=12- Packaging Completed
T=Prof Tran Nbr out of Sequence
11 SFA_PF_SKIP_REASON Character(1) VARCHAR2(1) NOT NULL Skip Reason
1=Student Already Exists
2=Final Review Flag Set
3=Student Not at Suspend Level
4=Manually Set to Skipped
12 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
13 SSN_MSK Character(9) VARCHAR2(9) NOT NULL Social Security #
14 CSS_SCHOOL_CODE Character(4) VARCHAR2(4) NOT NULL CSS School Code
15 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
16 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name