SFA_PF_IN_LD_VW

(SQL View)
Index Back

PROFILE/NA Load view

PROFILE/NA Load view

SELECT A.SFA_PF_QUEUE_INST ,A.CSS_ID ,A.INSTITUTION ,A.AID_YEAR ,A.APP_SOURCE_CODE ,A.SFA_APPL_TYPE ,A.SFA_PF_CRET_DT_STG ,A.SUSPEND_REASON ,A.SFA_PF_SKIP_REASON ,A.ADMIT_LVL ,A.SFA_PF_LOAD_STATUS ,A.SFA_PF_REC_TYPE ,A.SFA_PF_ALT_INST ,B.SSN ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH ,B.MIDDLE_NAME ,B.SFA_CR_BIRTH_DT ,B.EMPLID ,B.CITIZENSHIP_STATUS ,B.PHONE ,C.DEPNDNCY_STAT , D.SA_APP_STATUS , A.SFA_PF_HHOLD_TYPE , A.SFA_PF_STU_REC_19 , A.SFA_PF_APP_TYPE_19 , D.SFA_PF_FINAPP_ST19 , A.SFA_PF_TXN_STG , A.SFA_PF_CORECTN_IND , A.SFA_PF_CRTN_DT_STG FROM PS_SFA_PF_CNTRL_ST A , PS_SFA_PF_COMM_ST B ,PS_SFA_PF_INTRP_ST C ,PS_SFA_PF_STDNT_ST D WHERE A.SFA_PF_QUEUE_INST = B.SFA_PF_QUEUE_INST AND A.CSS_ID = B.CSS_ID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.APP_SOURCE_CODE = B.APP_SOURCE_CODE AND B.SFA_PF_QUEUE_INST = C.SFA_PF_QUEUE_INST AND B.CSS_ID = C.CSS_ID AND B.INSTITUTION = C.INSTITUTION AND B.AID_YEAR = C.AID_YEAR AND B.APP_SOURCE_CODE = C.APP_SOURCE_CODE AND C.SFA_PF_QUEUE_INST = D.SFA_PF_QUEUE_INST AND C.CSS_ID = D.CSS_ID AND C.INSTITUTION = D.INSTITUTION AND C.AID_YEAR = D.AID_YEAR AND C.APP_SOURCE_CODE = D.APP_SOURCE_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SFA_PF_QUEUE_INST Number(9,0) DECIMAL(9) NOT NULL Load Instance
2 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Award 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
6 SFA_APPL_TYPE Character(1) VARCHAR2(1) NOT NULL Application Type
1=Domestic PROFILE
2=Noncustodial PROFILE
3=Registration Only Record
4=International PROFILE
7 SFA_PF_CRET_DT_STG Character(10) VARCHAR2(10) NOT NULL Created Date
8 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
9 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
10 ADMIT_LVL Character(1) VARCHAR2(1) NOT NULL Student's Admit Level
0=0 - Student Not Found
1=1 - Has Not Applied
2=2 - Inactive
3=3 - Applied/Pending
4=4 - Admitted
5=5 - Accepted/Continuing
11 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
12 SFA_PF_REC_TYPE Character(1) VARCHAR2(1) NOT NULL Student Record Type
1=Original Data
3=ACR
4=Duplicate Record
13 SFA_PF_ALT_INST Character(5) VARCHAR2(5) NOT NULL Alternate Institution
14 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
15 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

Prompt Table: HCR_NM_PREFIX_I

16 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
17 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
18 SFA_CR_BIRTH_DT Character(10) VARCHAR2(10) NOT NULL Birthdate
19 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
20 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
21 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
22 DEPNDNCY_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
1=Independent
2=Dependent
3=Indepenedent/Pro Judgmnt
D=Dependent
I=Independent
X=Dependent Reject
Y=Independent Reject
Z=Provisional Independent
23 SA_APP_STATUS Character(1) VARCHAR2(1) NOT NULL Financial Aid Status
1=First-time App, New Student
2=Renewal App, Cont. Student
3=First-time App, Cont. Student
24 SFA_PF_HHOLD_TYPE Character(1) VARCHAR2(1) NOT NULL HouseHold Type
A=HHA
B=HHB
C=HHA / HHB
25 SFA_PF_STU_REC_19 Character(1) VARCHAR2(1) NOT NULL Student Record Type
1=Initial
2=School Added
26 SFA_PF_APP_TYPE_19 Character(1) VARCHAR2(1) NOT NULL Application Type
1=Domestic
2=Canadian
3=International
27 SFA_PF_FINAPP_ST19 Character(7) VARCHAR2(7) NOT NULL Financial Aid Appl Status
28 SFA_PF_TXN_STG Character(1) VARCHAR2(1) NOT NULL This field is used to hold the Transaction umber of the Profile files
29 SFA_PF_CORECTN_IND Character(1) VARCHAR2(1) NOT NULL This field is used to hold the Correction Record Indictor of the Profile files
N=No
Y=Yes
30 SFA_PF_CRTN_DT_STG Character(10) VARCHAR2(10) NOT NULL Correction Date