|
SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.EFFDT , A.EFFSEQ , C.TABLE_ID , B.SFA_APP_SOURCE , A.DT_APP_RECEIVED , B.SFA_TRANSACT_SRC , B.SFA_TRANSACT_TYPE , B.SFA_TRANSACT_LANG , A.TRANS_RECEIPT_DT , A.TRANS_PROCESS_DT , B.SFA_TRANSACT_STAT , B.SFA_RENEWAL_DAT , B.SFA_FPS_CORR , A.ISIR_CORR_SRC , B.SFA_PREP_FIRSTNAME , B.SFA_PREP_LASTNAME , A.PREP_SSN , A.PREP_EIN , B.SFA_PREP_AFF , A.PREP_SIGNATURE , B.SFA_PREP_SIGNDATE , B.SFA_STD_AFFIRM , B.SFA_SPS_AFFIRM , B.SFA_PAR_AFFIRM , B.SFA_OTH_AFFIRM , B.SFA_STD_CONGRANT , B.SFA_STD_CONREVOK , B.SFA_SPS_CONGRANT , B.SFA_SPS_CONREVOK , B.SFA_PAR_CONGRANT , B.SFA_PAR_CONREVOK , B.SFA_OTH_CONGRANT , B.SFA_OTH_CONREVOK , B.SFA_STD_TRANSUNION , B.SFA_SPS_TRANSUNION , B.SFA_PAR_TRANSUNION , B.SFA_OTH_TRANSUNION , A.CORRECTION_APPLIED , A.ADJ_EFC_CALC_REQ , A.DEPNDNCY_OVERRIDE , A.FAA_SIGNATURE , B.SFA_IASG_INDICATOR , A.SFA_CFH_INDICATOR , B.SFA_STD_SIGNEDIND , B.SFA_SPS_SIGNEDIND , B.SFA_PAR_SIGNEDIND , B.SFA_OTH_SIGNEDIND , B.SFA_SPL_HANDIND , C.PRIMARY_EFC , A.INAS_RFC_CALL , C.SECONDARY_EFC , C.FORMULA_TYPE , C.SFA_COMPUT_TYPE , C.SFA_SIG_REJ_EFC , C.SFA_MAX_PELLIND , C.SFA_MIN_PELLIND , C.SFA_FPS_STD_FWS , C.SFA_FPS_SPS_FWS , C.SFA_FPS_PAR_FWS , C.SFA_FPS_OTH_FWS , C.SFA_FPS_PAR_ALLOW , C.SFA_FPS_PAR_PAYROL , C.SFA_FPS_PAR_IPA , C.SFA_FPS_PEEA , C.SFA_FPS_PAI , C.SFA_FPS_PAAI , C.SFA_FPS_PC , C.SFA_FPS_STD_PAYROL , C.SFA_FPS_STD_IPA , C.SFA_FPS_ALLOW , C.SFA_FPS_SEEA , C.SFA_FPS_STD_ALLOW , C.SFA_FPS_STAI , C.SFA_FPS_SCI , C.SFA_FPS_SAAI , C.SFA_FPS_TOT_SAAI , B.SFA_STD_PAS_SSA , B.SFA_SPS_PAS_SSA , B.SFA_PAR_PAS_SSA , B.SFA_OTH_PAS_SSA , A.ISIR_CPS_PUSHED , A.SFA_REJ_ST_CHG_FLG , A.VERIF_TRK_FLG , A.VERF_SELECTION_IND , A.SFA_INCAR_APP_FLAG , A.NSLDS_TXN_NBR , A.SFA_HIGH_SCHL_FLAG , A.INS_MATCH , B.SFA_DHS_SEC_MATCH , A.INS_VERF_NUM , D.NSLDS_MATCH , A.SSA_CITIZENSHP_IND , A.SSN_MATCH , A.FATHER_SSN_MATCH , A.MOTHER_SSN_MATCH , B.SFA_SPS_SSN_MATCH , A.VA_MATCH , A.PELL_ELIGIBILITY , A.CPS_REPROCESS_CD , A.SAR_C_FLAG , A.ISIR_SAR_C_CHNG , A.LAST_NAME_SSN_CHNG , B.SFA_ELECT_FED_SCHL , A.SFA_VF_SEL_CHG_FLG , B.SFA_USER_PROV_DATA , A.ETI_DEST_CD FROM PS_ISIR_CONTROL A , (PS_SFA_ISIR_CONT B LEFT OUTER JOIN PS_ISIR_INTERPRET D ON D.EMPLID = B.EMPLID AND D.INSTITUTION = B.INSTITUTION AND D.AID_YEAR = B.AID_YEAR AND D.EFFDT = B.EFFDT AND D.EFFSEQ = B.EFFSEQ) , PS_ISIR_COMPUTED C WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND C.EMPLID = B.EMPLID AND C.INSTITUTION = B.INSTITUTION AND C.AID_YEAR = B.AID_YEAR AND C.EFFDT = B.EFFDT AND C.EFFSEQ = B.EFFSEQ
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table:
STUDENT_AID
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
TABLE_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Table Key
|
| 7 |
SFA_APP_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Application Source
1=Electronic Data Exchange
2=Online FAFSA
3=FAFSA Partner Portal
4=Paper
5=FPS
6=FSAIC
|
| 8 |
DT_APP_RECEIVED |
Date(10) |
DATE |
Date Application Received
|
| 9 |
SFA_TRANSACT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
2425 Transaction Source
1=Electronic Data Exchange
2=Online FAFSA
3=FAFSA Partner Portal
4=Paper
5=FPS
6=FSAIC
|
| 10 |
SFA_TRANSACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425 Transaction Type
A=Application
C=Correction
|
| 11 |
SFA_TRANSACT_LANG |
Character(1) |
VARCHAR2(1) NOT NULL |
2425 Transaction Language
E=English
S=Spanish
|
| 12 |
TRANS_RECEIPT_DT |
Date(10) |
DATE |
Transaction Receipt Date
|
| 13 |
TRANS_PROCESS_DT |
Date(10) |
DATE |
Transaction Process Date
|
| 14 |
SFA_TRANSACT_STAT |
Character(30) |
VARCHAR2(30) NOT NULL |
2425 : Transaction Status
|
| 15 |
SFA_RENEWAL_DAT |
Character(3) |
VARCHAR2(3) NOT NULL |
2425:Renewal Data Used
1=Yes
2=Blank
|
| 16 |
SFA_FPS_CORR |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: FPS Corr Reason
C=COD FWS Update
D=Drug Absue Hold Release Expire
F=Drug Abuse Hold Release FSA
L=Identity Hold Release
M=DHS Secondry Rsults Processing
N=NSLDS Postscreening
P=Reprocessing
W=NTIS Death File Match
X=Blank
Y=Identity Verification
|
| 17 |
ISIR_CORR_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction Source
A=Applicant
D=CPS
S=School
|
| 18 |
SFA_PREP_FIRSTNAME |
Character(35) |
VARCHAR2(35) NOT NULL |
2425: First Name
|
| 19 |
SFA_PREP_LASTNAME |
Character(35) |
VARCHAR2(35) NOT NULL |
2425:Last Name
|
| 20 |
PREP_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Preparers SSN
|
| 21 |
PREP_EIN |
Character(9) |
VARCHAR2(9) NOT NULL |
Preparers EIN
|
| 22 |
SFA_PREP_AFF |
Character(30) |
VARCHAR2(30) NOT NULL |
2425:Affiliation
|
| 23 |
PREP_SIGNATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Preparers Signature
1=Yes
X=Blank
|
| 24 |
SFA_PREP_SIGNDATE |
Date(10) |
DATE |
2425:Signature Date
|
| 25 |
SFA_STD_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Affirmation Status
1=Yes
X=Blank
|
| 26 |
SFA_SPS_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Spouse Affirmation Status�
1=Yes
X=Blank
|
| 27 |
SFA_PAR_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Parent Affirmation Status
1=Yes
X=Blank
|
| 28 |
SFA_OTH_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Other Parent Affirmation Status
1=Yes
X=Blank
|
| 29 |
SFA_STD_CONGRANT |
Date(10) |
DATE |
2425:Student Date Consent Granted�
|
| 30 |
SFA_STD_CONREVOK |
Date(10) |
DATE |
2425:Student Date Consent Revoked
|
| 31 |
SFA_SPS_CONGRANT |
Date(10) |
DATE |
2425:Spouse Date Consent Granted
|
| 32 |
SFA_SPS_CONREVOK |
Date(10) |
DATE |
2425:Spouse Date Consent Revoked
|
| 33 |
SFA_PAR_CONGRANT |
Date(10) |
DATE |
2425:Parent Date Consent Granted�
|
| 34 |
SFA_PAR_CONREVOK |
Date(10) |
DATE |
2425:Parent Date Consent Revoked�
|
| 35 |
SFA_OTH_CONGRANT |
Date(10) |
DATE |
2425:Other Parent Date Consent Granted�
|
| 36 |
SFA_OTH_CONREVOK |
Date(10) |
DATE |
2425:Parent Date Consent Revoked�
|
| 37 |
SFA_STD_TRANSUNION |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Transunion Match Status
1=No match
2=Date of birth mismatch
3=First name mismatch
4=Last name mismatch
5=Address mismatch
6=Full match
7=Inconclusive
X=Not needed
|
| 38 |
SFA_SPS_TRANSUNION |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Spouse Transunion Match Status
1=No match
2=Data of birth mismatch
3=First name mismatch
4=Last name mismatch
5=Address mismatch
6=Full match
7=Inconclusive
X=Not needed
|
| 39 |
SFA_PAR_TRANSUNION |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Parent Transunion Match Status
1=No match
2=Date of birth mismatch
3=First name mismatch
4=Last name mismatch
5=Address mismatch
6=Full match
7=Inconclusive
X=Not needed
|
| 40 |
SFA_OTH_TRANSUNION |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Transunion Match Status
1=No match
2=Date of birth mismatch
3=First name mismatch
4=Last name mismatch
5=Address mismatch
6=Full match
7=Inconclusive
X=Not needed
|
| 41 |
CORRECTION_APPLIED |
Character(2) |
VARCHAR2(2) NOT NULL |
Correction Applied
|
| 42 |
ADJ_EFC_CALC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusted EFC Calc Requested
1=Calc Adjustment Processed
2=Calc Adjustment Failed
|
| 43 |
DEPNDNCY_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependency Override Indicator
1=Dependent To Independent
2=Cancel Dep Override-Corr Only
3=Override Failed
4=Homeless Youth Determination
|
| 44 |
FAA_SIGNATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
FAA Signature
1=Signed
|
| 45 |
SFA_IASG_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:IASG Indicator
1=Eligible for IASG
2=Grandfathered for IASG
3=Not Eligible for IASG
X=No Determination
|
| 46 |
SFA_CFH_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Children of Fallen Heroes
1=Yes
2=No
|
| 47 |
SFA_STD_SIGNEDIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Signed Indicator�
1=Paper
2=FSA ID
3=FAA or EDE
E=Student Signed Electronically
P=Student Signed on Paper
X=Not Signed
|
| 48 |
SFA_SPS_SIGNEDIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Spouse Signed Indicator
1=Paper
2=FSA ID
3=FAA or EDE
E=Stdnt Sps Signd Electronically
P=Student Spouse Signed on Paper
X=Not Signed
|
| 49 |
SFA_PAR_SIGNEDIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Parent Signed Indicator
1=Paper
2=FSA ID
3=FAA or EDE
E=Parent Signed Electronically
P=Parent Signed on Paper
X=Not Signed
|
| 50 |
SFA_OTH_SIGNEDIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Other Parent Signed Indicator
1=Paper
2=FSA ID
3=FAA or EDE
E=Othr Prnt Signd Electronically
P=Other Parent Signed on Paper
X=Not Signed
|
| 51 |
SFA_SPL_HANDIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Special Handling Indicator
*=Damaged Form
@=ED Special Handle Request
C=Incarcerated Applicant
D=Applcnt Youngr Thn 13 at Start
X=No Special Handling Required
|
| 52 |
PRIMARY_EFC |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Primary EFC
|
| 53 |
INAS_RFC_CALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc EFC via Remote Call
N=No
Y=Yes
|
| 54 |
SECONDARY_EFC |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Secondary EFC
|
| 55 |
FORMULA_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Formula Type
1=Full Needs Test: Dependent
2=Full Needs Test: Ind w/out Dep
3=Full Needs Test: Ind w/Deps
4=Simplified: Dependent
5=Simplified: Ind w/out Deps
6=Simplified: Indep w/Deps
A=Dependent
B=Independent w/o dependents
C=Independent with dependents
G=Boolean
I=Iterative
R=Regular
|
| 56 |
SFA_COMPUT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
2425 : Computation Type
|
| 57 |
SFA_SIG_REJ_EFC |
Number(6,0) |
INTEGER NOT NULL |
Signature Reject EFC
|
| 58 |
SFA_MAX_PELLIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: Maximum Pell Indicator
|
| 59 |
SFA_MIN_PELLIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: Minimum Pell Indicator
|
| 60 |
SFA_FPS_STD_FWS |
Number(12,0) |
DECIMAL(12) NOT NULL |
2425:Student Total Federal Work Study Earnings
|
| 61 |
SFA_FPS_SPS_FWS |
Number(12,0) |
DECIMAL(12) NOT NULL |
2425:Student Spouse Total Federal Work Study Earnings
|
| 62 |
SFA_FPS_PAR_FWS |
Number(12,0) |
DECIMAL(12) NOT NULL |
2425:Parent Total Federal Work Study Earnings
|
| 63 |
SFA_FPS_OTH_FWS |
Number(12,0) |
DECIMAL(12) NOT NULL |
2425:Other Parent Total Federal Work Study Earnings
|
| 64 |
SFA_FPS_PAR_ALLOW |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Total Parent Allowances Against Income
|
| 65 |
SFA_FPS_PAR_PAYROL |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Parent Payroll Tax Allowance
|
| 66 |
SFA_FPS_PAR_IPA |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Parent Income Protection Allowance (IPA)�
|
| 67 |
SFA_FPS_PEEA |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Parent Employment Expense Allowance (PEEA)
|
| 68 |
SFA_FPS_PAI |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
2425:Parent Available Income (PAI)
|
| 69 |
SFA_FPS_PAAI |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
2425:Parent Adjusted Available Income (PAAI)
|
| 70 |
SFA_FPS_PC |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
2425:Parent Contribution (PC)
|
| 71 |
SFA_FPS_STD_PAYROL |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Student Payroll Tax Allowance
|
| 72 |
SFA_FPS_STD_IPA |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Student Income Protection Allowance (IPA)�
|
| 73 |
SFA_FPS_ALLOW |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Student Allowance for Parents negative Adjusted Available
Income
|
| 74 |
SFA_FPS_SEEA |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Student Employment Expense Allowance (SEEA)
|
| 75 |
SFA_FPS_STD_ALLOW |
Number(15,0) |
DECIMAL(15) NOT NULL |
2425:Total Student Allowances Against Income
|
| 76 |
SFA_FPS_STAI |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
2425:Student Available Income (StAI)
|
| 77 |
SFA_FPS_SCI |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
2425:Student Contribution from Income (SCI)
|
| 78 |
SFA_FPS_SAAI |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
2425:Student Adjusted Available Income (SAAI)
|
| 79 |
SFA_FPS_TOT_SAAI |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
2425:Total Student Contribution from SAAI
|
| 80 |
SFA_STD_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Pending PAS SSA Match Flag
|
| 81 |
SFA_SPS_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Spouse Pending PAS SSA Match Flag
|
| 82 |
SFA_PAR_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Parent Pending PAS SSA Match Flag
|
| 83 |
SFA_OTH_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Other Parent Pending PAS SSA Match Flag
|
| 84 |
ISIR_CPS_PUSHED |
Character(1) |
VARCHAR2(1) NOT NULL |
CPS Pushed ISIR Flag
|
| 85 |
SFA_REJ_ST_CHG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected Status Change Flag
1=REJ ST C Flag Has Changed
|
| 86 |
VERIF_TRK_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Verification Tracking Flag
V1=Standard Group
V2=FSA Use Only
V3=Child Support Group
V4=Custom Group
V5=Aggregate Group
V6=Household Resources Grp
|
| 87 |
VERF_SELECTION_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Verification Selection Ind
*=Subsequent Trans Select
N=Not Selected
Y=Selected
|
| 88 |
SFA_INCAR_APP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Added new field for 2324
1=Corr Facility Address File
2=Received via PO Box at IDC
3=Incarcerated App Flag Set
4=Incarcerated App Flag Removed
|
| 89 |
NSLDS_TXN_NBR |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Transaction Nbr
|
| 90 |
SFA_HIGH_SCHL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
High School Flag
Y=High School not found
|
| 91 |
INS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
INS Match
D=Duplicate case
I=Invalid ARN
L=Record Returned Late
N=Citizenship Not Confirmed
Y=Citizenship Confirmed
Z=Record Mismatch
|
| 92 |
SFA_DHS_SEC_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: DHS Secondary Match Status
C=Continue to Process
N=Not Confirmed Eligible Non-Cit
P=Pending
X=Blank
Y=Confirmed Eligible Non-Citizen
|
| 93 |
INS_VERF_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
INS Verification Nbr
|
| 94 |
NSLDS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Match
0=Init of Flag or Late
1=Eligible for Title IV aid
2=Default
3=Overpayment
4=Default and Overpayment
5=Eligible Partial Title IV Aid
7=Match, but no data
8=Transaction Not Sent
9=Mismatch
|
| 95 |
SSA_CITIZENSHP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
SSA Citizenship Indicator
*=Foreign born
A=U.S. Citizen
B=Legal Alien, work eligible
C=Legal Alien, work ineligible
D=Other
E=Alien/student restrc/wk elig
F=Alien, conditionally legal
I=Institutional Override
N=No Match on Name or DOB
|
| 96 |
SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
SSN Match
0=Record Returned Late
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
9=Record Mismatch
I=Institutional Override
|
| 97 |
FATHER_SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Father's SSN Match
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
I=Institutional Override
|
| 98 |
MOTHER_SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Mother's SSN Match
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
I=Institutional Override
|
| 99 |
SFA_SPS_SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Spouse SSA Match Flag
1=Not found by SSA
2=DOB mismatch
3=Name mismatch
4=Full match
5=Deceased
6=SSN not verified
8=Not sent
9=Not needed
X=Blank
|
| 100 |
VA_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran Status Match Flag
1=Veteran status confirmed
2=Record found on VA db not Qual
3=Record not found on VA db
4=Active Duty
8=Record not sent to VA
|
| 101 |
PELL_ELIGIBILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal PELL Eligibility
Y=Yes
|
| 102 |
CPS_REPROCESS_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Reprocess Code
A=Rls From Drug Enforcement Hold
D=Duplicate Request
H=Application Released from Hold
L=NSLDS History Correction
R=Rematched Transaction
S=Duplicate SSN
Z=Reprocessed Transaction
|
| 103 |
SAR_C_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates When 'C' Printed SAR
Y=SAR C Flag Set
|
| 104 |
ISIR_SAR_C_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR SAR C Flag Changed
Y=FPS C Flag Has Changed
|
| 105 |
LAST_NAME_SSN_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name-SSN Change Flag
|
| 106 |
SFA_ELECT_FED_SCHL |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Electronic Federal School Code
|
| 107 |
SFA_VF_SEL_CHG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Select Chng Flag
C=Change in Verif Tracking Grp
Y=VF SEL C Flag Has Changed
|
| 108 |
SFA_USER_PROV_DATA |
Character(5) |
VARCHAR2(5) NOT NULL |
2425:Use User Provided Data Only
|
| 109 |
ETI_DEST_CD |
Character(7) |
VARCHAR2(7) NOT NULL |
ETI Destination Code
|