| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 2 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 3 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 4 |
ISIR_SEQ_NO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 5 |
ORIG_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Original SSN
|
| 6 |
NAME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Name Code
|
| 7 |
IWD_TRANS_NBR |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Number
|
| 8 |
IWD_EARLY_ANALYSIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Early Analysis Flag
|
| 9 |
IWD_ELEC_APP_SOURC |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic App Entry Source
2=FAA Entry
3=Easy FAFSA
4=FAFSA Express Diskette
5=FAFSA Web Download
6=Spanish - FOTW
7=Renewal FOTW
8=English FOTW
9=FAA Access
|
| 10 |
IWD_APP_VERSION_NO |
Character(6) |
VARCHAR2(6) NOT NULL |
Electronic App Version No.
|
| 11 |
IWD_ETI_DEST_CODE |
Character(7) |
VARCHAR2(7) NOT NULL |
ETI Destination Code
|
| 12 |
REJ_OVR_IND_STDNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Independnt Status
1=Yes
2=No
|
| 13 |
REJ_OVR_STDNT_NAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Student First/Last Name
1=Yes
2=No
|
| 14 |
REJ_OVR_BIG_FAMILY |
Character(1) |
VARCHAR2(1) NOT NULL |
Large Family Size
1=Yes
2=No
|
| 15 |
IWD_ASSUM_OVER_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 1
|
| 16 |
IWD_ASSUM_OVER_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 2
|
| 17 |
IWD_ASSUM_OVER_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 3
|
| 18 |
IWD_ASSUM_OVER_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 4
|
| 19 |
IWD_ASSUM_OVER_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 5
|
| 20 |
IWD_ASSUM_OVER_6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 6
|
| 21 |
IWD_ASSUM_OVER_7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 7
|
| 22 |
IWD_APP_RECV_DT_O |
Date(10) |
DATE |
Application Receipt Date
|
| 23 |
IWD_RECORD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Type
7=PIN Request
A=Initial Applications
C=Corrections/Duplicates
F=FDR Request
H=Corrections/Duplicate Req
R=Renewal Applications
S=Signature Corrections
|
| 24 |
IWD_HIST_CORR_APP |
Character(2) |
VARCHAR2(2) NOT NULL |
History Correction Applied
|
| 25 |
SYSTEM_GENERATED |
Character(1) |
VARCHAR2(1) NOT NULL |
System Generated Indicator
A=Release from Drug Enf Hold
D=Duplicate Request
H=Applcation Released from Hold
I=INS Secondary Confirmation
L=Dup Req, Match data changed
N=NSLDS post-screening transact
P=Dup Req/Prison Match Change
R=Rematched Transaction
S=Dup SSN and no activity
Z=Reprocessed Transaction
|
| 26 |
DUPLICATE_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Request Indicator
|
| 27 |
IWD_PAR_98_TAXSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parents' Calc 1998 Tax Stat
|
| 28 |
IWD_STU_98_TAXSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Calc 1998 Tax Stat
|
| 29 |
IWD_GRAD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduate Flag
|
| 30 |
AUTO_ZERO_EFC |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Zero EFC
Y=EFC Set To Zero
|
| 31 |
SAR_C_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates When 'C' Printed SAR
Y=SAR C Flag Set
|
| 32 |
IWD_SIMPLE_NEEDTST |
Character(1) |
VARCHAR2(1) NOT NULL |
Simplified Need Test
|
| 33 |
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
|
| 34 |
IWD_REJECT_CODES |
Character(110) |
VARCHAR2(110) NOT NULL |
Reject Reason Codes
|
| 35 |
SS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Selective Service Match
I=Institutional Override
L=Record Returned Late
N=Regist Status Not Confirmed
T=Temporarily Exempt
Y=Registration Status Confirmed
Z=Record Mismatch
|
| 36 |
SS_REGISTRATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Selective Service Registration
I=Institutional Override
L=Record Returned Late
N=Registration not completed
T=Temporarily Exempt
Y=Registration Confirmed
Z=Record Mismatch
|
| 37 |
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
|
| 38 |
IWD_INS_VERIF_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Ins Verif Num
|
| 39 |
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
|
| 40 |
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
|
| 41 |
IWD_SSN_DT_DEATH_O |
Date(10) |
DATE |
SSN Date of Death
|
| 42 |
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
|
| 43 |
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
|
| 44 |
VERIFCATION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Verfication Type
|
| 45 |
VERF_SELECTION_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Verification Selection Ind
*=Subsequent Trans Select
N=Not Selected
Y=Selected
|
| 46 |
IWD_SUB_APP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Subsequent App Flag
|
| 47 |
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
|
| 48 |
APP_SOURCE_SITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Appl Source Site Code
1=Site 1
2=Site 2
|
| 49 |
TRANS_SOURCE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Source Code
|
| 50 |
TRANS_SOURCE_SITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Site Source Code
|
| 51 |
TRANS_PROCESS_DT |
Date(10) |
DATE |
Transaction Process Date
|
| 52 |
IWD_COMP_BTCH_NBR |
Character(3) |
VARCHAR2(3) NOT NULL |
Compute Batch Number
|
| 53 |
IWD_CORRECTIONS |
Character(195) |
VARCHAR2(195) NOT NULL |
Corrections
|
| 54 |
IWD_HIGHLIGHT |
Character(195) |
VARCHAR2(195) NOT NULL |
Highlights
|
| 55 |
IWD_PAID_EFC |
Character(5) |
VARCHAR2(5) NOT NULL |
Paid EFC
|
| 56 |
IWD_PRIMARY_EFC |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary EFC
|
| 57 |
IWD_SECONDARY_EFC |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary EFC
|
| 58 |
PELL_PAID_EFC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Paid EFC Type
|
| 59 |
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
|
| 60 |
FORMULA_TYPE_SEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Formula Type
|
| 61 |
PRM_ALT_MONTH_1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 1
|
| 62 |
PRM_ALT_MONTH_2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 2
|
| 63 |
PRM_ALT_MONTH_3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 3
|
| 64 |
PRM_ALT_MONTH_4 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 4
|
| 65 |
PRM_ALT_MONTH_5 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 5
|
| 66 |
PRM_ALT_MONTH_6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 6
|
| 67 |
PRM_ALT_MONTH_7 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 7
|
| 68 |
PRM_ALT_MONTH_8 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 8
|
| 69 |
PRM_ALT_MONTH_10 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 10
|
| 70 |
PRM_ALT_MONTH_11 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 11
|
| 71 |
PRM_ALT_MONTH_12 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Alternate Month 12
|
| 72 |
SEC_ALT_MONTH_1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 1
|
| 73 |
SEC_ALT_MONTH_2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 2
|
| 74 |
SEC_ALT_MONTH_3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 3
|
| 75 |
SEC_ALT_MONTH_4 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 4
|
| 76 |
SEC_ALT_MONTH_5 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 5
|
| 77 |
SEC_ALT_MONTH_6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 6
|
| 78 |
SEC_ALT_MONTH_7 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 7
|
| 79 |
SEC_ALT_MONTH_8 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 8
|
| 80 |
SEC_ALT_MONTH_10 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 10
|
| 81 |
SEC_ALT_MONTH_11 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 11
|
| 82 |
SEC_ALT_MONTH_12 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary Alternate Month 12
|
| 83 |
TOTAL_INCOME_CH |
Character(15) |
VARCHAR2(15) NOT NULL |
Total Income
|
| 84 |
ALWNC_AGAINST_TICH |
Character(7) |
VARCHAR2(7) NOT NULL |
Allowance VS Total Income
|
| 85 |
STATE_TAX_ALWNC_CH |
Character(7) |
VARCHAR2(7) NOT NULL |
State Tax Allowance
|
| 86 |
EMPLOYMENT_ALWNCCH |
Character(7) |
VARCHAR2(7) NOT NULL |
Employment Allowance
|
| 87 |
INC_PROTECTN_AL_CH |
Character(7) |
VARCHAR2(7) NOT NULL |
Income Protection Allowance
|
| 88 |
AVAILABLE_INCOMECH |
Character(8) |
VARCHAR2(8) NOT NULL |
Available Income
|
| 89 |
CONTRIB_AVAIL_INCH |
Character(7) |
VARCHAR2(7) NOT NULL |
Contribution Available Income
|
| 90 |
DESCRTN_NETWRTHCH |
Character(9) |
VARCHAR2(9) NOT NULL |
Discretionary Net Worth
|
| 91 |
IWD_EFC_NET_WORTH |
Character(9) |
VARCHAR2(9) NOT NULL |
NW: EFC Net Worth
|
| 92 |
AST_PROTECTN_ALWCH |
Character(9) |
VARCHAR2(9) NOT NULL |
Asset Protection Allowance
|
| 93 |
CONTRIB_FROM_ASSCH |
Character(7) |
VARCHAR2(7) NOT NULL |
Contribution from Assets
|
| 94 |
ADJ_AVAILABLEIN_CH |
Character(8) |
VARCHAR2(8) NOT NULL |
Adjusted Available Income
|
| 95 |
TOTAL_STU_CONT_CH |
Character(7) |
VARCHAR2(7) NOT NULL |
Total Student Contribution
|
| 96 |
TOTAL_PAR_CONT_CH |
Character(7) |
VARCHAR2(7) NOT NULL |
Total Parent Contribution
|
| 97 |
ADJ_PAR_CONTRIB_CH |
Character(7) |
VARCHAR2(7) NOT NULL |
Parent Contribution
|
| 98 |
STU_TOTAL_INC_CH |
Character(15) |
VARCHAR2(15) NOT NULL |
Student's Total Income
|
| 99 |
IWD_SATI |
Character(7) |
VARCHAR2(7) NOT NULL |
Student's Allowance vs TI
|
| 100 |
DEP_STU_I_CONT_CH |
Character(7) |
VARCHAR2(7) NOT NULL |
Student Income Contribution
|
| 101 |
IWD_SDNW |
Character(9) |
VARCHAR2(9) NOT NULL |
Student's Disc Net Worth
|
| 102 |
DEP_STU_A_CONRB_CH |
Character(7) |
VARCHAR2(7) NOT NULL |
Student Asset Contribution
|
| 103 |
FISAP_TOT_INC_CH |
Character(15) |
VARCHAR2(15) NOT NULL |
FISAP Total Income
|
| 104 |
IWD_SEC_TI |
Character(8) |
VARCHAR2(8) NOT NULL |
Secondary total Income
|
| 105 |
IWD_SEC_ATI |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Allowance vs Income
|
| 106 |
IWD_SEC_STX |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary State Tax Allowance
|
| 107 |
IWD_SEC_EA |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Employment Allowance
|
| 108 |
IWD_SEC_IPA |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Inc Prot Allowance
|
| 109 |
IWD_SEC_AI |
Character(8) |
VARCHAR2(8) NOT NULL |
Secondary Available Income
|
| 110 |
IWD_SEC_CAI |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Contribution From AI
|
| 111 |
IWD_SEC_DNW |
Character(9) |
VARCHAR2(9) NOT NULL |
Secondary DNW
|
| 112 |
IWD_SEC_NW |
Character(9) |
VARCHAR2(9) NOT NULL |
Secondary Net Worth
|
| 113 |
IWD_SEC_APA |
Character(9) |
VARCHAR2(9) NOT NULL |
Secondary Asset Protect Allow
|
| 114 |
IWD_SEC_PCA |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Par Cont From Assets
|
| 115 |
IWD_SEC_AAI |
Character(8) |
VARCHAR2(8) NOT NULL |
Secondary Adjusted Avail Inc
|
| 116 |
IWD_SEC_TSC |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Total Stu Contrib
|
| 117 |
IWD_SEC_TPC |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Total Parent Contrib
|
| 118 |
IWD_SEC_PC |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Parent Contribution
|
| 119 |
IWD_SEC_STI |
Character(8) |
VARCHAR2(8) NOT NULL |
Secondary Stu Total Income
|
| 120 |
IWD_SEC_SATI |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Stu All vs TI
|
| 121 |
IWD_SEC_SIC |
Character(7) |
VARCHAR2(7) NOT NULL |
Secondary Stu Ind Dep IC
|
| 122 |
IWD_SEC_SDNW |
Character(9) |
VARCHAR2(9) NOT NULL |
Secondary Stu DNW
|
| 123 |
IWD_SEC_SCA |
Character(7) |
VARCHAR2(7) NOT NULL |
Sec Stdnt Contrib from Assets
|
| 124 |
IWD_SEC_FTI |
Character(8) |
VARCHAR2(8) NOT NULL |
Secondary FISAP Total Inc
|
| 125 |
ASMD_CITIZENSHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Citizenship
1=Assumed Student is a Citizen
2=Assumd Student Is Elg Non-Cit
|
| 126 |
IWD_ASSUM_STU_MS |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Student's Mar Status
|
| 127 |
IWD_ASSUMED_DOBPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed DOB Prior
|
| 128 |
IWD_STU_MARRIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Student is Married
|
| 129 |
IWD_ASSUMED_VA_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed VA Status
|
| 130 |
IWD_ASSUMED_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Stdnt Legal Dependents
|
| 131 |
IWD_ASSUMED_FAM_NO |
Character(2) |
VARCHAR2(2) NOT NULL |
Assumed Num in Family
|
| 132 |
IWD_ASSUMED_COL_NO |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Num in Coll
|
| 133 |
IWD_ASSUMED_AGI |
Character(7) |
VARCHAR2(7) NOT NULL |
Assumed AGI
|
| 134 |
IWD_ASSUMED_IFW |
Character(7) |
VARCHAR2(7) NOT NULL |
Assumed Income From Work
|
| 135 |
IWD_ASSUM_IFW_SPS |
Character(7) |
VARCHAR2(7) NOT NULL |
Assumed Income From Work - SPS
|
| 136 |
IWD_ASS_STU_EIC |
Character(5) |
VARCHAR2(5) NOT NULL |
Assumed Stu EIC
|
| 137 |
IWD_ASS_STU_WKB |
Character(5) |
VARCHAR2(5) NOT NULL |
Assumed Stu Inc from WK B
|
| 138 |
IWD_ASS_STU_TAX |
Character(7) |
VARCHAR2(7) NOT NULL |
Assumed Tax Paid
|
| 139 |
IWD_ASS_PAR_MS |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Parent Marital Status
|
| 140 |
IWD_ASS_PAR_FAM_NO |
Character(2) |
VARCHAR2(2) NOT NULL |
Assumed Par Nbr in Fam
|
| 141 |
IWD_ASS_PAR_COL_NO |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Par Nbr in Coll
|
| 142 |
IWD_ASS_PAR_AGI |
Character(7) |
VARCHAR2(7) NOT NULL |
Assumed Parent AGI
|
| 143 |
IWD_ASS_FTHR_INC |
Character(7) |
VARCHAR2(7) NOT NULL |
Assumed Father Income
|
| 144 |
IWD_ASS_MOM_INC |
Character(7) |
VARCHAR2(7) NOT NULL |
Assumed Mother Income
|
| 145 |
IWD_ASS_PAR_EIC |
Character(5) |
VARCHAR2(5) NOT NULL |
Assumed Par EIC
|
| 146 |
IWD_ASS_PAR_WKB |
Character(5) |
VARCHAR2(5) NOT NULL |
Assumed Parents' WK B
|
| 147 |
IWD_ASS_PAR_TAXPD |
Character(7) |
VARCHAR2(7) NOT NULL |
Assumed Parents' Tax Pd
|
| 148 |
IWD_COMMENT_CDS |
Character(60) |
VARCHAR2(60) NOT NULL |
Comment Codes
|
| 149 |
IWD_SAR_ACK_COMCDS |
Character(20) |
VARCHAR2(20) NOT NULL |
SAR Ack Comment Codes
|
| 150 |
PELL_ELIGIBILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal PELL Eligibility
Y=Yes
|
| 151 |
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
|
| 152 |
SFA_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type.
0=EDE Initial Application
1=Paper Application
2=EDE Correction
3=EDE Duplicate Request
5=EDE Renewal App
|
| 153 |
ELEC_INSTITUT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Institution Ind
0=Federal School Code #10
1=Federal School Code #1
2=Federal School Code #2
3=Federal School Code #3
4=Federal School Code #4
5=Federal School Code #5
6=Federal School Code #6
7=Federal School Code #7
8=Federal School Code #8
9=Federal School Code #9
|
| 154 |
MULTI_INSTITUTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Multiple Institution Flags
|
| 155 |
DUPLICATE_DATE_O |
Date(10) |
DATE |
Duplicate Transaction Proc Dt
|
| 156 |
IWD_PROC_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
field 133 on the 2002 ISIR
C=Correction Application
H=History/Duplicate
|
| 157 |
PRISONER_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Prisoner Match
0=Not sent to SSA/Not a Prisoner
1=Prisoner in Local Facility
2=In State or Federal Facility
8=Not sent for match
I=Institutional Override
|
| 158 |
IWD_PAR_XX_TAXSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parents' Calc XX Tax Stat
|
| 159 |
IWD_STU_XX_TAXSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Calc XX Tax Stat
|
| 160 |
VERIFICATION_SELEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Select/Tracking
*=Subsequent Trans Selected
N=Not Selected
Y=Selected
|
| 161 |
IWD_APP_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
CPS Appl Source Site Cd
|
| 162 |
IWD_TRANS_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Source Site Cd
|
| 163 |
IWD_PAR_WK_C |
Character(8) |
VARCHAR2(8) NOT NULL |
Parent's Total from WK C
|
| 164 |
IWD_STD_EMAIL |
Character(50) |
VARCHAR2(50) NOT NULL |
Student's Email Address
|
| 165 |
IWD_SOURCE_CORR |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Correction
A=Applicant
D=CPS
S=School
|
| 166 |
IWD_EFC_CHNG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC Change Flag
1=SAI Increase
2=SAI Decrease
|
| 167 |
IWD_SEC_INS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary INS Match Flag
|
| 168 |
IWD_SEC_INS_VNUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Secondary Ins Verif Num
|
| 169 |
IWD_ASS_CHILDREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Children
|
| 170 |
IWD_DUP_SSN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate SSN Indicator
|
| 171 |
IWD_ASS_STU_WKC |
Character(8) |
VARCHAR2(8) NOT NULL |
Assumed Stu Inc from WK C
|
| 172 |
IWD_ASS_PAR_WKC |
Character(8) |
VARCHAR2(8) NOT NULL |
Assumed Parents' WK C
|
| 173 |
IWD_ASS_FATHER_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Assumed Father's SSN
|
| 174 |
IWD_ASS_MOTHER_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Assumed Mother's SSN
|
| 175 |
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
|
| 176 |
REJ_OVR_BIRTH_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Date of Birth Yr is 1900-1928
1=Yes
|
| 177 |
REJ_OVR_TAX_RANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Taxes paid is high, but < AGI
1=Yes
|
| 178 |
IWD_DATA_VERIFY |
Character(195) |
VARCHAR2(195) NOT NULL |
FAFSA Data Verify Flags
|
| 179 |
ADDR_ONLY_CHNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Only Change Flag
1=Student's Mailing Address
2=Student's E-mail Address
3=Parent's E-mail Address
4=More than one address
|
| 180 |
ISIR_CPS_PUSHED |
Character(1) |
VARCHAR2(1) NOT NULL |
CPS Pushed ISIR Flag
|
| 181 |
ISIR_SAR_C_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR SAR C Flag Changed
Y=FPS C Flag Has Changed
|
| 182 |
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
|
| 183 |
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
|
| 184 |
MULTI_INSTITUTION1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 1
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 185 |
MULTI_INSTITUTION2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 2
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 186 |
MULTI_INSTITUTION3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 3
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 187 |
MULTI_INSTITUTION4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 4
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 188 |
MULTI_INSTITUTION5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 5
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 189 |
MULTI_INSTITUTION6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 6
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 190 |
ISIR_ETI |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR Elec Trans Indicator
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=State Resdnt, daily ISIR
B=Non-Resdnt,daily ISIR
C=State Resdnt,pushed ISIR
D=Non-Resdnt,pushed ISIR
E=State Resdnt,ISIR reqst
F=Non-Resdnt,ISIR reqst
|
| 191 |
REJ_OVR_TAXRNG_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Taxes paid is high, but < AGI
1=Yes
|
| 192 |
SFA_REJ_OVR_TX_STU |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override 3
1=Yes
2=No
|
| 193 |
SFA_REJ_OVR_TX_PAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override 12
1=Yes
2=No
|
| 194 |
SFA_REJ_OVR_DADSSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override J
1=Yes
2=No
|
| 195 |
SFA_REJ_OVR_MOMSSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override K
1=Yes
2=No
|
| 196 |
SFA_REJ_ST_CHG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected Status Change Flag
1=REJ ST C Flag Has Changed
|
| 197 |
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
|
| 198 |
SFA_REJ_OVR_MR_STU |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override 4
1=Yes
|
| 199 |
SFA_REJ_OVR_NO_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override 20
1=Yes
|
| 200 |
SFA_IW_SIGNREJ_EFC |
Character(6) |
VARCHAR2(6) NOT NULL |
Signature Reject EFC
|
| 201 |
SFA_MULTI_INST7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 7
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 202 |
SFA_MULTI_INST8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 8
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 203 |
SFA_MULTI_INST9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 9
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 204 |
SFA_MULTI_INST10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Institution Flag 10
0=School Generated, Daily
1=Non-School Generated, Daily
2=School Generated, Request
3=Non-School Generated, Request
4=School Gen, Daily, Pushed
5=Non-School Gen, Daily, Pushed
6=School Gen, Request, Pushed
7=Non-School Gen, Request, Pushe
8=Non-School Gen,Daily,SysGen
9=Non-School Gen,Request,SysGen
A=Correction to ACG data
|
| 205 |
SFA_SPL_CIRCUM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Circumstances Flag
1=Dep w/o Parent Data
2=Parent Data Corrected
3=Unaccompanied Homeless
4=Dep Unsub Loan Only
|
| 206 |
SFA_ASM_YTH_SCHOOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Homeless Youth-School
|
| 207 |
SFA_ASM_YTH_HUD |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Homeless Youth - HUD
|
| 208 |
SFA_ASM_RISK_HOME |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Risk of Homelessness
|
| 209 |
SFA_DOD_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Dept of Defense Match
Y=SSN included in DOD file
|
| 210 |
SFA_DOD_PARENT |
Date(10) |
DATE |
DOD Parent Date of Death
|
| 211 |
SFA_STU_IRS_REQUST |
Character(2) |
VARCHAR2(2) NOT NULL |
Student IRS Request
00=Ineligible
01=Used and Not Transferred
02=Transferred and Not Changed
03=Transferred and Changed
04=Transferred and Corrected
05=Eligible and Not Used
06=Eligible to Not Eligible
07=Transferred but Amended
B=Not Available
|
| 212 |
SFA_PAR_IRS_REQUST |
Character(2) |
VARCHAR2(2) NOT NULL |
Parent IRS Request
00=Ineligible
01=Used and Not Transferred
02=Transferred and Not Changed
03=Transferred and Changed
04=Transferred and Corrected
05=Eligible and Not Used
06=Eligible to Not Eligible
07=Transferred but Amended
B=Not Available
|
| 213 |
SFA_HIGH_SCHL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
High School Flag
Y=High School not found
|
| 214 |
SFA_REJ_OVR_MAR_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override 21
1=Yes
|
| 215 |
SFA_STU_ASM_ASSET |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Stu Asset Thrs Exceed
|
| 216 |
SFA_PAR_ASM_ASSET |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Par Asset Thrs Exceed
|
| 217 |
SFA_STU_IRS_AGI |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS AGI Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
|
| 218 |
SFA_STU_IRS_FIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS FIT Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
|
| 219 |
SFA_PAR_IRS_AGI |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS AGI Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
|
| 220 |
SFA_PAR_IRS_FIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS FIT Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
|
| 221 |
SFA_STU_IRS_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Display
A=No DRT - Skipped Income/Asset
B=DRT was displayed to student
C=No DRT - Tax Return Status
D=No DRT - Marital Status Date
E=No DRT - SSN Starts with '666'
H=No DRT - Amended Tax Return
J=No DRT - Foreign Tax Return
K=No DRT - Married Filed Separat
L=No DRT - Married Filed Head
M=No DRT - Marital/Filing Cnflct
Z=Not Available
|
| 222 |
SFA_PAR_IRS_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Display
A=No DRT - Special Circumstances
B=DRT was displayed to parent
C=No DRT - Tax Return Status
D=No DRT - Marital Status Date
E=No DRT - SSN Starts with '666'
F=No DRT - SSN All Zeroes
G=No DRT - SSN Invalid
H=No DRT - Amended Tax Return
J=No DRT - Foreign Tax Return
K=No DRT - Married Filed Separat
L=No DRT - Married Filed Head
M=No DRT - Marital/Filing Cnflct
N=No DRT - Unmarried
Z=Not Available
|
| 223 |
SFA_STU_IRS_TAXRET |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Return Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 224 |
SFA_STU_IRS_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Exemption Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 225 |
SFA_STU_IRS_EDCRDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS ED Credits Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 226 |
SFA_STU_IRS_IRAPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS IRA Payment Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 227 |
SFA_STU_IRS_INTRST |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Interest Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 228 |
SFA_STU_IRS_IRADIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS IRA Dist Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 229 |
SFA_STU_IRS_UNTAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Pension Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 230 |
SFA_STU_IRS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Filing Status Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 231 |
SFA_PAR_IRS_TAXRET |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Return Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 232 |
SFA_PAR_IRS_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Exemption Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 233 |
SFA_PAR_IRS_EDCRDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS ED Credits Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 234 |
SFA_PAR_IRS_IRAPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS IRA Payment Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 235 |
SFA_PAR_IRS_INTRST |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Interest Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 236 |
SFA_PAR_IRS_IRADIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS IRA Dist Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 237 |
SFA_PAR_IRS_UNTAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Pension Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 238 |
SFA_PAR_IRS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Filing Status Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 239 |
SFA_CFH_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Children of Fallen Heroes
1=Yes
2=No
|
| 240 |
SFA_STU_IRS_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Schedule 1 Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 241 |
SFA_PAR_IRS_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Schedule 1 Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 242 |
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
|
| 243 |
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
|
| 244 |
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
|
| 245 |
SFA_TRANSACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425 Transaction Type
A=Application
C=Correction
|
| 246 |
SFA_TRANSACT_LANG |
Character(1) |
VARCHAR2(1) NOT NULL |
2425 Transaction Language
E=English
S=Spanish
|
| 247 |
SFA_TRANSACT_STAT |
Character(30) |
VARCHAR2(30) NOT NULL |
2425 : Transaction Status
|
| 248 |
SFA_RENEWAL_DAT |
Character(3) |
VARCHAR2(3) NOT NULL |
2425:Renewal Data Used
1=Yes
2=Blank
|
| 249 |
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
|
| 250 |
ASSIGNED_PIN |
Number(4,0) |
SMALLINT NOT NULL |
Unique Nbr Assigned to Student
|
| 251 |
SFA_COMPUT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
2425 : Computation Type
|
| 252 |
SFA_MAX_PELLIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: Maximum Pell Indicator
|
| 253 |
SFA_MIN_PELLIND |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: Minimum Pell Indicator
|
| 254 |
SFA_STD_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Affirmation Status
1=Yes
X=Blank
|
| 255 |
SFA_SPS_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Spouse Affirmation Status�
1=Yes
X=Blank
|
| 256 |
SFA_PAR_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Parent Affirmation Status
1=Yes
X=Blank
|
| 257 |
SFA_OTH_AFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Other Parent Affirmation Status
1=Yes
X=Blank
|
| 258 |
SFA_STD_CONGRANT |
Date(10) |
DATE |
2425:Student Date Consent Granted�
|
| 259 |
SFA_STD_CONREVOK |
Date(10) |
DATE |
2425:Student Date Consent Revoked
|
| 260 |
SFA_SPS_CONGRANT |
Date(10) |
DATE |
2425:Spouse Date Consent Granted
|
| 261 |
SFA_SPS_CONREVOK |
Date(10) |
DATE |
2425:Spouse Date Consent Revoked
|
| 262 |
SFA_PAR_CONGRANT |
Date(10) |
DATE |
2425:Parent Date Consent Granted�
|
| 263 |
SFA_PAR_CONREVOK |
Date(10) |
DATE |
2425:Parent Date Consent Revoked�
|
| 264 |
SFA_OTH_CONGRANT |
Date(10) |
DATE |
2425:Other Parent Date Consent Granted�
|
| 265 |
SFA_OTH_CONREVOK |
Date(10) |
DATE |
2425:Parent Date Consent Revoked�
|
| 266 |
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
|
| 267 |
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
|
| 268 |
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
|
| 269 |
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
|
| 270 |
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
|
| 271 |
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
|
| 272 |
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
|
| 273 |
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
|
| 274 |
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
|
| 275 |
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
|
| 276 |
SFA_STD_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Pending PAS SSA Match Flag
|
| 277 |
SFA_SPS_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Student Spouse Pending PAS SSA Match Flag
|
| 278 |
SFA_PAR_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Parent Pending PAS SSA Match Flag
|
| 279 |
SFA_OTH_PAS_SSA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Other Parent Pending PAS SSA Match Flag
|
| 280 |
SFA_IDENT_CHNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Identification Change Flag
1=ID C Flag Has Changed
|
| 281 |
SFA_SAR_C_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: SAR C Change Flag
1=SAR C Flag Has Changed
|
| 282 |
SFA_STD_TOT_FWS |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Student Total Federal Work Study Earnings
|
| 283 |
SFA_SPS_TOT_FWS |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Spouse Total Federal Work Study Earnings
|
| 284 |
SFA_PAR_TOT_FWS |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Parent Total Federal Work Study Earnings
|
| 285 |
SFA_OTH_TOT_FWS |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Other Parent Total Federal Work Study Earnings
|
| 286 |
SFA_PAR_TOT_ALLOW |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Total Parent Allowances Against Income
|
| 287 |
SFA_PAR_PAYROLLTAX |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Parent Payroll Tax Allowance
|
| 288 |
SFA_PAR_IPA |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Parent Income Protection Allowance (IPA)�
|
| 289 |
SFA_PAR_PEEA |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Parent Employment Expense Allowance (PEEA)
|
| 290 |
SFA_PAR_PAI |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Parent Available Income (PAI)
|
| 291 |
SFA_PAR_PAAI |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Parent Adjusted Available Income (PAAI)
|
| 292 |
SFA_PAR_CONTRIB |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Parent Contribution (PC)
|
| 293 |
SFA_STD_PAYROLLTAX |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Student Payroll Tax Allowance
|
| 294 |
SFA_STD_IPA |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Student Income Protection Allowance (IPA)�
|
| 295 |
SFA_STD_PAR_ALLOW |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Student Allowance for Parents negative Adjusted Available
Income
|
| 296 |
SFA_STD_SEEA |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Student Employment Expense Allowance (SEEA)
|
| 297 |
SFA_STD_TOT_ALLOW |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Total Student Allowances Against Income
|
| 298 |
SFA_STD_STAI |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Student Available Income (StAI)
|
| 299 |
SFA_STD_SCI |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Student Contribution from Income (SCI)
|
| 300 |
SFA_STD_SAAI |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Student Adjusted Available Income (SAAI)
|
| 301 |
SFA_STD_TOT_CONTRI |
Character(15) |
VARCHAR2(15) NOT NULL |
2425:Total Student Contribution from SAAI
|
| 302 |
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
|
| 303 |
SFA_ELECT_FED_SCHL |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Electronic Federal School Code
|
| 304 |
SFA_STD_FTIM_FTI |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:FTI label start
|
| 305 |
SFA_STD_FTIM_TAXRE |
Character(4) |
VARCHAR2(4) NOT NULL |
2425:Returned tax year
|
| 306 |
SFA_STD_FTIM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filing status code
|
| 307 |
SFA_FTIM_STU_AGI |
Character(10) |
VARCHAR2(10) NOT NULL |
2425:Adjusted Gross Income
|
| 308 |
SFA_FTIM_STU_NOE |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Number of exemptions
|
| 309 |
SFA_FTIM_STU_NOD |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Number of dependents
|
| 310 |
SFA_FTIM_STU_TI |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Total income earned amount�
|
| 311 |
SFA_FTIM_STU_TAXP |
Character(9) |
VARCHAR2(9) NOT NULL |
2425:Total tax paid amount�
|
| 312 |
SFA_FTIM_STU_EDUC |
Character(9) |
VARCHAR2(9) NOT NULL |
2425:Educational credits
|
| 313 |
SFA_FTIM_STU_UNIRA |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Untaxed IRA distributions
|
| 314 |
SFA_FTIM_STU_DEIRA |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:IRA deductible and payments
|
| 315 |
SFA_FTIM_STU_TAXEM |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Tax exempt interest
|
| 316 |
SFA_FTIM_STU_UNTAX |
Character(11) |
VARCHAR2(11) NOT NULL |
Untaxed pensions amount
|
| 317 |
SFA_FTIM_STU_CSCHD |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Schedule C net profit/loss�
|
| 318 |
SFA_STD_FTIM_SCHDA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 319 |
SFA_STD_FTIM_SCHDB |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 320 |
SFA_STD_FTIM_SCHDD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 321 |
SFA_STD_FTIM_SCHDE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 322 |
SFA_STD_FTIM_SCHDF |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 323 |
SFA_STD_FTIM_SCHDH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
1=Yes
2=No
|
| 324 |
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
|
| 325 |
SFA_SPS_FTIM_TAXRE |
Character(4) |
VARCHAR2(4) NOT NULL |
2425:Returned tax year
|
| 326 |
SFA_SPS_FTIM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filing status code
|
| 327 |
SFA_FTIM_SPS_AGI |
Character(10) |
VARCHAR2(10) NOT NULL |
2425:AGI
|
| 328 |
SFA_FTIM_SPS_NOE |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Number of exemptions
|
| 329 |
SFA_FTIM_SPS_NOD |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Number of dependents
|
| 330 |
SFA_FTIM_SPS_TI |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Total income earned amount�
|
| 331 |
SFA_FTIM_SPS_TAXP |
Character(9) |
VARCHAR2(9) NOT NULL |
2425:Total tax paid amount�
|
| 332 |
SFA_FTIM_SPS_EDUC |
Character(9) |
VARCHAR2(9) NOT NULL |
2425:Educational credits
|
| 333 |
SFA_FTIM_SPS_UNIRA |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Untaxed IRA distributions
|
| 334 |
SFA_FTIM_SPS_DEIRA |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:IRA deductible and payments
|
| 335 |
SFA_FTIM_SPS_TAXEM |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Tax exempt interest
|
| 336 |
SFA_FTIM_SPS_UNTAX |
Character(11) |
VARCHAR2(11) NOT NULL |
Untaxed pensions amount
|
| 337 |
SFA_FTIM_SPS_CSCHD |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Schedule C net profit/loss�
|
| 338 |
SFA_SPS_FTIM_SCHDA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 339 |
SFA_SPS_FTIM_SCHDB |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 340 |
SFA_SPS_FTIM_SCHDD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 341 |
SFA_SPS_FTIM_SCHDE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 342 |
SFA_SPS_FTIM_SCHDF |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 343 |
SFA_SPS_FTIM_SCHDH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 344 |
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
|
| 345 |
SFA_PAR_FTIM_TAXRE |
Character(4) |
VARCHAR2(4) NOT NULL |
2425:Returned tax year
|
| 346 |
SFA_PAR_FTIM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filing status code
|
| 347 |
SFA_FTIM_PAR_AGI |
Character(10) |
VARCHAR2(10) NOT NULL |
2425:AGI
|
| 348 |
SFA_FTIM_PAR_NOE |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Number of exemptions
|
| 349 |
SFA_FTIM_PAR_NOD |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Number of dependents
|
| 350 |
SFA_FTIM_PAR_TI |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Total income earned amount�
|
| 351 |
SFA_FTIM_PAR_TAXP |
Character(9) |
VARCHAR2(9) NOT NULL |
2425:Total tax paid amount�
|
| 352 |
SFA_FTIM_PAR_EDUC |
Character(9) |
VARCHAR2(9) NOT NULL |
2425:Educational credits
|
| 353 |
SFA_FTIM_PAR_UNIRA |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Untaxed IRA distributions
|
| 354 |
SFA_FTIM_PAR_DEIRA |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:IRA deductible and payments
|
| 355 |
SFA_FTIM_PAR_TAXEM |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Tax exempt interest
|
| 356 |
SFA_FTIM_PAR_UNTAX |
Character(11) |
VARCHAR2(11) NOT NULL |
Untaxed pensions amount
|
| 357 |
SFA_FTIM_PAR_CSCHD |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Schedule C net profit/loss�
|
| 358 |
SFA_PAR_FTIM_SCHDA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 359 |
SFA_PAR_FTIM_SCHDB |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 360 |
SFA_PAR_FTIM_SCHDD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 361 |
SFA_PAR_FTIM_SCHDE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 362 |
SFA_PAR_FTIM_SCHDF |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule F indicator
|
| 363 |
SFA_PAR_FTIM_SCHDH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 364 |
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
|
| 365 |
SFA_OTH_FTIM_TAXRE |
Character(4) |
VARCHAR2(4) NOT NULL |
2425:Returned tax year
|
| 366 |
SFA_OTH_FTIM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filing status code
|
| 367 |
SFA_FTIM_OTH_AGI |
Character(10) |
VARCHAR2(10) NOT NULL |
2425:AGI
|
| 368 |
SFA_FTIM_OTH_NOE |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Number of exemptions
|
| 369 |
SFA_FTIM_OTH_NOD |
Character(2) |
VARCHAR2(2) NOT NULL |
2425:Number of dependents
|
| 370 |
SFA_FTIM_OTH_TI |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Total income earned amount�
|
| 371 |
SFA_FTIM_OTH_TAXP |
Character(9) |
VARCHAR2(9) NOT NULL |
2425:Total tax paid amount�
|
| 372 |
SFA_FTIM_OTH_EDUC |
Character(9) |
VARCHAR2(9) NOT NULL |
2425:Educational credits
|
| 373 |
SFA_FTIM_OTH_UNIRA |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Untaxed IRA distributions
|
| 374 |
SFA_FTIM_OTH_DEIRA |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:IRA deductible and payments
|
| 375 |
SFA_FTIM_OTH_TAXEM |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:Tax exempt interest
|
| 376 |
SFA_FTIM_OTH_UNTAX |
Character(11) |
VARCHAR2(11) NOT NULL |
Untaxed pensions amount
|
| 377 |
SFA_FTIM_OTH_CSCHD |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Schedule C net profit/loss�
|
| 378 |
SFA_OTH_FTIM_SCHDA |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule A indicator
|
| 379 |
SFA_OTH_FTIM_SCHDB |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule B indicator
|
| 380 |
SFA_OTH_FTIM_SCHDD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule D indicator
|
| 381 |
SFA_OTH_FTIM_SCHDE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule E indicator
|
| 382 |
SFA_OTH_FTIM_SCHDF |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule F indicator
|
| 383 |
SFA_OTH_FTIM_SCHDH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Schedule H indicator
|
| 384 |
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
|
| 385 |
SFA_OTH_FTIM_FTI |
Character(11) |
VARCHAR2(11) NOT NULL |
2425:FTI label end
|
| 386 |
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
|
| 387 |
SFA_PAR_DNW |
Character(7) |
VARCHAR2(7) NOT NULL |
2425:Parent Discretionary Net Worth
|
| 388 |
SFA_PAR_NW |
Character(7) |
VARCHAR2(7) NOT NULL |
2425:Parent Net Worth
|
| 389 |
SFA_PAR_APA |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Parent Asset Protection Allowance
|
| 390 |
SFA_PAR_CA |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Parent Contribution from Assets
|
| 391 |
SFA_STD_NW |
Character(7) |
VARCHAR2(7) NOT NULL |
2425:Student Net Worth
|
| 392 |
SFA_STD_APA |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Student Asset Protection Allowance
|
| 393 |
SFA_STD_CA |
Character(12) |
VARCHAR2(12) NOT NULL |
2425:Student Contribution from Assets
|
| 394 |
SFA_ASMD_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
2425:Assumed Student Family Size
|
| 395 |
SFA_ASMD_PAR |
Character(3) |
VARCHAR2(3) NOT NULL |
2425:Assumed Parent Family Size
|
| 396 |
SFA_USER_PROV_DATA |
Character(5) |
VARCHAR2(5) NOT NULL |
2425:Use User Provided Data Only
|