SFA_PF_IN_LD_VW(SQL View) |
Index Back |
---|---|
PROFILE/NA Load viewPROFILE/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 |