| # |
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 |
ISIR_TXN_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Transaction Num
|
| 7 |
SFA_PREP_FIRSTNAME |
Character(35) |
VARCHAR2(35) NOT NULL |
2425: First Name
|
| 8 |
SFA_PREP_LASTNAME |
Character(35) |
VARCHAR2(35) NOT NULL |
2425:Last Name
|
| 9 |
SFA_PREP_AFF |
Character(30) |
VARCHAR2(30) NOT NULL |
2425:Affiliation
|
| 10 |
SFA_PREP_STREET |
Character(40) |
VARCHAR2(40) NOT NULL |
2425: Spouse Street Address
|
| 11 |
SFA_PREP_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
2425:Spouse City
|
| 12 |
SFA_PREP_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Spouse State
|
| 13 |
SFA_PREP_ZIPCODE |
Character(10) |
VARCHAR2(10) NOT NULL |
2425:Spouse Zip Code
|
| 14 |
SFA_PREP_SIGNDATE |
Date(10) |
DATE |
2425:Signature Date
|
| 15 |
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
|
| 16 |
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
|
| 17 |
SFA_TRANSACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425 Transaction Type
A=Application
C=Correction
|
| 18 |
SFA_TRANSACT_LANG |
Character(1) |
VARCHAR2(1) NOT NULL |
2425 Transaction Language
E=English
S=Spanish
|
| 19 |
SFA_TRANSACT_STAT |
Character(30) |
VARCHAR2(30) NOT NULL |
2425 : Transaction Status
|
| 20 |
SFA_RENEWAL_DAT |
Character(3) |
VARCHAR2(3) NOT NULL |
2425:Renewal Data Used
1=Yes
2=Blank
|
| 21 |
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
|
| 22 |
SFA_STD_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Affirmation Status
1=Yes
X=Blank
|
| 23 |
SFA_SPS_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Spouse Affirmation Status�
1=Yes
X=Blank
|
| 24 |
SFA_PAR_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Parent Affirmation Status
1=Yes
X=Blank
|
| 25 |
SFA_OTH_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Other Parent Affirmation Status
1=Yes
X=Blank
|
| 26 |
SFA_STD_CONGRANT |
Date(10) |
DATE |
2425:Student Date Consent Granted�
|
| 27 |
SFA_STD_CONREVOK |
Date(10) |
DATE |
2425:Student Date Consent Revoked
|
| 28 |
SFA_SPS_CONGRANT |
Date(10) |
DATE |
2425:Spouse Date Consent Granted
|
| 29 |
SFA_SPS_CONREVOK |
Date(10) |
DATE |
2425:Spouse Date Consent Revoked
|
| 30 |
SFA_PAR_CONGRANT |
Date(10) |
DATE |
2425:Parent Date Consent Granted�
|
| 31 |
SFA_PAR_CONREVOK |
Date(10) |
DATE |
2425:Parent Date Consent Revoked�
|
| 32 |
SFA_OTH_CONGRANT |
Date(10) |
DATE |
2425:Other Parent Date Consent Granted�
|
| 33 |
SFA_OTH_CONREVOK |
Date(10) |
DATE |
2425:Parent Date Consent Revoked�
|
| 34 |
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
|
| 35 |
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
|
| 36 |
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
|
| 37 |
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
|
| 38 |
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
|
| 39 |
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
|
| 40 |
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
|
| 41 |
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
|
| 42 |
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
|
| 43 |
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
|
| 44 |
SFA_STD_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Pending PAS SSA Match Flag
|
| 45 |
SFA_SPS_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Spouse Pending PAS SSA Match Flag
|
| 46 |
SFA_PAR_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Parent Pending PAS SSA Match Flag
|
| 47 |
SFA_OTH_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Other Parent Pending PAS SSA Match Flag
|
| 48 |
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
|
| 49 |
SFA_ELECT_FED_SCHL |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Electronic Federal School Code
|
| 50 |
SFA_STD_FTIM_FTI |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:FTI label start
|
| 51 |
SFA_STD_FTIM_TAXRE |
Character(4) |
VARCHAR2(4) NOT NULL |
2425:Returned tax year
|
| 52 |
SFA_STD_FTIM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filing status code
|
| 53 |
SFA_STD_FTIM_AGI |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:AGI
|
| 54 |
SFA_STD_FTIM_NOE |
Number(2,0) |
SMALLINT NOT NULL |
2425:Number of exemptions
|
| 55 |
SFA_STD_FTIM_NOD |
Number(2,0) |
SMALLINT NOT NULL |
2425:Number of dependents
|
| 56 |
SFA_STD_FTIM_TI |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Total income earned amount�
|
| 57 |
SFA_STD_FTIM_TAXP |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Total tax paid amount�
|
| 58 |
SFA_STD_FTIM_EDUC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Educational credits
|
| 59 |
SFA_STD_FTIM_UNIRA |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Untaxed IRA distributions
|
| 60 |
SFA_STD_FTIM_DEIRA |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:IRA deductible and payments
|
| 61 |
SFA_STD_FTIM_TAXEM |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Tax exempt interest
|
| 62 |
SFA_STD_FTIM_UNTAX |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
Untaxed pensions amount
|
| 63 |
SFA_STD_FTIM_CSCHD |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Schedule C net profit/loss�
|
| 64 |
SFA_STD_FTIM_SCHDA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 65 |
SFA_STD_FTIM_SCHDB |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 66 |
SFA_STD_FTIM_SCHDD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 67 |
SFA_STD_FTIM_SCHDE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 68 |
SFA_STD_FTIM_SCHDF |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 69 |
SFA_STD_FTIM_SCHDH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 70 |
SFA_STD_FTIM_IRSCD |
Character(3) |
VARCHAR2(3) NOT NULL |
2425: IRS response code
200=Successful Request
203=PII Match Failed
206=Partial Delivery of Content
212=Cannot Verify Return Data
214=No Return on File
|
| 71 |
SFA_SPS_FTIM_TAXRE |
Character(4) |
VARCHAR2(4) NOT NULL |
2425:Returned tax year
|
| 72 |
SFA_SPS_FTIM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filing status code
|
| 73 |
SFA_SPS_FTIM_AGI |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:AGI
|
| 74 |
SFA_SPS_FTIM_NOE |
Number(2,0) |
SMALLINT NOT NULL |
2425:Number of exemptions
|
| 75 |
SFA_SPS_FTIM_NOD |
Number(2,0) |
SMALLINT NOT NULL |
2425:Number of dependents
|
| 76 |
SFA_SPS_FTIM_TI |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Total income earned amount�
|
| 77 |
SFA_SPS_FTIM_TAXP |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Total tax paid amount�
|
| 78 |
SFA_SPS_FTIM_EDUC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Educational credits
|
| 79 |
SFA_SPS_FTIM_UNIRA |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Untaxed IRA distributions
|
| 80 |
SFA_SPS_FTIM_DEIRA |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:IRA deductible and payments
|
| 81 |
SFA_SPS_FTIM_TAXEM |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Tax exempt interest
|
| 82 |
SFA_SPS_FTIM_UNTAX |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
Untaxed pensions amount
|
| 83 |
SFA_SPS_FTIM_CSCHD |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Schedule C net profit/loss�
|
| 84 |
SFA_SPS_FTIM_SCHDA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 85 |
SFA_SPS_FTIM_SCHDB |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 86 |
SFA_SPS_FTIM_SCHDD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 87 |
SFA_SPS_FTIM_SCHDE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 88 |
SFA_SPS_FTIM_SCHDF |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 89 |
SFA_SPS_FTIM_SCHDH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 90 |
SFA_SPS_FTIM_IRSCD |
Character(3) |
VARCHAR2(3) NOT NULL |
2425: IRS response code
200=Successful Request
203=PII Match Failed
206=Partial Delivery of Content
212=Cannot Verify Return Data
214=No Return on File
|
| 91 |
SFA_PAR_FTIM_TAXRE |
Character(4) |
VARCHAR2(4) NOT NULL |
2425:Returned tax year
|
| 92 |
SFA_PAR_FTIM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filing status code
|
| 93 |
SFA_PAR_FTIM_AGI |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:AGI
|
| 94 |
SFA_PAR_FTIM_NOE |
Number(2,0) |
SMALLINT NOT NULL |
2425:Number of exemptions
|
| 95 |
SFA_PAR_FTIM_NOD |
Number(2,0) |
SMALLINT NOT NULL |
2425:Number of dependents
|
| 96 |
SFA_PAR_FTIM_TI |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Total income earned amount�
|
| 97 |
SFA_PAR_FTIM_TAXP |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Total tax paid amount�
|
| 98 |
SFA_PAR_FTIM_EDUC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Educational credits
|
| 99 |
SFA_PAR_FTIM_UNIRA |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Untaxed IRA distributions
|
| 100 |
SFA_PAR_FTIM_DEIRA |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:IRA deductible and payments
|
| 101 |
SFA_PAR_FTIM_TAXEM |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Tax exempt interest
|
| 102 |
SFA_PAR_FTIM_UNTAX |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
Untaxed pensions amount
|
| 103 |
SFA_PAR_FTIM_CSCHD |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Schedule C net profit/loss�
|
| 104 |
SFA_PAR_FTIM_SCHDA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 105 |
SFA_PAR_FTIM_SCHDB |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 106 |
SFA_PAR_FTIM_SCHDD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 107 |
SFA_PAR_FTIM_SCHDE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 108 |
SFA_PAR_FTIM_SCHDF |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule F indicator
|
| 109 |
SFA_PAR_FTIM_SCHDH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 110 |
SFA_PAR_FTIM_IRSCD |
Character(3) |
VARCHAR2(3) NOT NULL |
2425: IRS response code
200=Successful Request
203=PII Match Failed
206=Partial Delivery of Content
212=Cannot Verify Return Data
214=No Return on File
|
| 111 |
SFA_OTH_FTIM_TAXRE |
Character(4) |
VARCHAR2(4) NOT NULL |
2425:Returned tax year
|
| 112 |
SFA_OTH_FTIM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filing status code
|
| 113 |
SFA_OTH_FTIM_AGI |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:AGI
|
| 114 |
SFA_OTH_FTIM_NOE |
Number(2,0) |
SMALLINT NOT NULL |
2425:Number of exemptions
|
| 115 |
SFA_OTH_FTIM_NOD |
Number(2,0) |
SMALLINT NOT NULL |
2425:Number of dependents
|
| 116 |
SFA_OTH_FTIM_TI |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Total income earned amount�
|
| 117 |
SFA_OTH_FTIM_TAXP |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Total tax paid amount�
|
| 118 |
SFA_OTH_FTIM_EDUC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Educational credits
|
| 119 |
SFA_OTH_FTIM_UNIRA |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Untaxed IRA distributions
|
| 120 |
SFA_OTH_FTIM_DEIRA |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:IRA deductible and payments
|
| 121 |
SFA_OTH_FTIM_TAXEM |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Tax exempt interest
|
| 122 |
SFA_OTH_FTIM_UNTAX |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
Untaxed pensions amount
|
| 123 |
SFA_OTH_FTIM_CSCHD |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
2425:Schedule C net profit/loss�
|
| 124 |
SFA_OTH_FTIM_SCHDA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 125 |
SFA_OTH_FTIM_SCHDB |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule B indicator
|
| 126 |
SFA_OTH_FTIM_SCHDD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule D indicator
|
| 127 |
SFA_OTH_FTIM_SCHDE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule E indicator
|
| 128 |
SFA_OTH_FTIM_SCHDF |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule F indicator
|
| 129 |
SFA_OTH_FTIM_SCHDH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule H indicator
|
| 130 |
SFA_OTH_FTIM_IRSCD |
Character(3) |
VARCHAR2(3) NOT NULL |
2425: IRS response code
200=Successful Request
203=PII Match Failed
206=Partial Delivery of Content
212=Cannot Verify Return Data
214=No Return on File
|
| 131 |
SFA_OTH_FTIM_FTI |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:FTI label end
|
| 132 |
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
|
| 133 |
SFA_USER_PROV_DATA |
Character(5) |
VARCHAR2(5) NOT NULL |
2425:Use User Provided Data Only
|