SFA_FAN_FTI_VW

(SQL View)
 Index Back

Internals Control View

This is a view of the ISIR_CONTROL table used for Financial Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.ISIR_TXN_NBR ,A.ORIG_SSN ,A.NAME_CD ,A.LAST_NAME_SSN_CHNG ,A.SS_MATCH ,A.SS_REGISTRATION ,A.INS_MATCH ,A.SSN_MATCH ,A.DT_APP_RECEIVED ,A.PELL_ELIGIBILITY ,A.ASSIGNED_PIN ,A.DUPLICATE_REQUEST ,A.SAR_C_FLAG ,A.MDE_EDE_SITE_CODE ,A.MDE_SITE_NBR ,A.VERF_SELECTION_IND ,A.HOLD_IND ,A.SYSTEM_GENERATED ,A.TRANS_RECEIPT_DT ,A.TRANS_PROCESS_DT ,A.CPS_REPROCESS_CD ,A.APP_SOURCE_CODE ,A.APP_SOURCE_SITE ,A.BATCH_NUMBER ,A.SFA_TRANS_TYPE ,A.ELEC_INSTITUT_IND ,A.VERIFCATION_TYPE ,A.CORRECTION_APPLIED ,A.FAA_INSTITUT_NUM ,A.INS_VERF_NUM ,A.FULL_PARTIAL_ESAR ,A.MULTI_INSTITUTION ,A.SEND_ISAR_SW ,A.FINAL_REVIEW_SW ,A.DEPNDNCY_OVERRIDE ,A.FAA_SIGNATURE ,A.APPLICATION_STAT ,A.APP_STAT_DT ,A.EFC_STATUS ,A.OPRID ,A.ADJ_EFC_CALC_REQ ,A.ASSUMPTION_OVRRIDE ,A.CORRECTION_STATUS ,A.CORR_STAT_DT ,A.CORR_NAME ,A.CORR_ADDRESS ,A.CORR_SSN ,A.CORR_DOB ,A.CORR_PHONE ,A.CORR_STATE_RES ,A.CORR_STATE_RES_DT ,A.CORR_LICENSE ,A.CORR_LICENSE_STATE ,A.CORR_CIT_STATUS ,A.CORR_ALIEN_REG_NUM ,A.CORR_MARITAL_STAT ,A.CORR_MARITAL_DATE ,A.TITLEIV_ELIG ,A.ISIR_PRINT_REQUEST ,A.ISIR_PRINT_DT ,A.INST_PROCESS_DT ,A.ADJ_EFC ,A.SSA_CITIZENSHP_IND ,A.ISIR_SERIAL_NUM ,A.OWNING_SCHOOL_CD ,A.SEND_VERIFY_FIELDS ,A.NSLDS_TXN_NBR ,A.INAS_RFC_CALL ,A.EARLY_ANALYSIS_FLG ,A.ELECTRONIC_APP_VER ,A.ETI_DEST_CD ,A.ISIR_REC_TYPE ,A.SIMP_NEED_TEST ,A.SSN_DATE_OF_DEATH ,A.SUB_APP_FLAG ,A.COMPUTE_BTCH_NO ,A.DUP_PROC_DT ,A.VA_MATCH ,A.PRISONER_MATCH ,A.PROCESS_INSTANCE ,A.PROCESS_DT ,A.APP_SOURCE ,A.TRANS_SOURCE ,A.ADDRESS_TYPE ,A.OVRD_ADDR_TYPE ,A.PREP_SSN ,A.PREP_SIGNATURE ,A.PREP_EIN ,A.ISIR_CORR_SRC ,A.ISIR_EFC_CHANGE ,A.ISIR_SEC_INS_MATCH ,A.ISIR_SEC_INS_VERF ,A.ISIR_DUP_SSN_CD ,A.CORR_EMAIL_ADDR ,A.ISIR_ORIG_IND ,CASE WHEN A.VERIF_TRK_FLG <> ' ' THEN RTRIM(LTRIM(A.VERIF_TRK_FLG)) ELSE A.VERIF_TRK_FLG END ,A.EFC_OVRD_DSPLAY_FM ,A.ISIR_CPS_PUSHED ,A.ISIR_SAR_C_CHNG ,A.FATHER_SSN_MATCH ,A.MOTHER_SSN_MATCH ,A.SFA_VF_SEL_CHG_FLG ,A.SFA_REJ_ST_CHG_FLG ,A.ISIR_OVRD_E_TYPE ,A.ISIR_OVRD_P_TYPE ,A.PHONE_TYPE ,A.E_ADDR_TYPE ,A.SFA_SPL_CIRCUM_FLG ,A.SFA_DOD_MATCH ,A.SFA_DOD_PARENT ,A.SFA_STU_IRS_REQUST ,A.SFA_PAR_IRS_REQUST ,A.SFA_HIGH_SCHL_FLAG ,A.SFA_STU_IRS_AGI ,A.SFA_STU_IRS_FIT ,A.SFA_PAR_IRS_AGI ,A.SFA_PAR_IRS_FIT ,A.SFA_STU_IRS_DISP ,A.SFA_PAR_IRS_DISP ,A.SFA_CFH_INDICATOR ,A.SFA_INCAR_APP_FLAG ,D.SFA_PREP_FIRSTNAME ,D.SFA_PREP_LASTNAME ,D.SFA_PREP_AFF ,D.SFA_PREP_STREET ,D.SFA_PREP_CITY ,D.SFA_PREP_STATE ,D.SFA_PREP_ZIPCODE ,D.SFA_PREP_SIGNDATE ,D.SFA_APP_SOURCE ,D.SFA_TRANSACT_SRC ,D.SFA_TRANSACT_TYPE ,D.SFA_TRANSACT_LANG ,D.SFA_TRANSACT_STAT ,D.SFA_RENEWAL_DAT ,D.SFA_FPS_CORR ,D.SFA_STD_AFFIRM ,D.SFA_SPS_AFFIRM ,D.SFA_PAR_AFFIRM ,D.SFA_OTH_AFFIRM ,D.SFA_STD_CONGRANT ,D.SFA_SPS_CONGRANT ,D.SFA_PAR_CONGRANT ,D.SFA_OTH_CONGRANT ,D.SFA_STD_TRANSUNION ,D.SFA_SPS_TRANSUNION ,D.SFA_PAR_TRANSUNION ,D.SFA_OTH_TRANSUNION ,D.SFA_IASG_INDICATOR ,D.SFA_STD_SIGNEDIND ,D.SFA_SPS_SIGNEDIND ,D.SFA_PAR_SIGNEDIND ,D.SFA_OTH_SIGNEDIND ,D.SFA_SPL_HANDIND ,D.SFA_SPS_SSN_MATCH ,D.SFA_ELECT_FED_SCHL ,D.SFA_DHS_SEC_MATCH ,D.SFA_STD_FTIM_FTI ,D.SFA_STD_FTIM_TAXRE ,D.SFA_STD_FTIM_STAT ,D.SFA_STD_FTIM_AGI ,D.SFA_STD_FTIM_NOE ,D.SFA_STD_FTIM_NOD ,D.SFA_STD_FTIM_TI ,D.SFA_STD_FTIM_TAXP ,D.SFA_STD_FTIM_EDUC ,D.SFA_STD_FTIM_UNIRA ,D.SFA_STD_FTIM_DEIRA ,D.SFA_STD_FTIM_TAXEM ,D.SFA_STD_FTIM_UNTAX ,D.SFA_STD_FTIM_CSCHD ,D.SFA_STD_FTIM_SCHDA ,D.SFA_STD_FTIM_SCHDB ,D.SFA_STD_FTIM_SCHDD ,D.SFA_STD_FTIM_SCHDE ,D.SFA_STD_FTIM_SCHDF ,D.SFA_STD_FTIM_SCHDH ,D.SFA_STD_FTIM_IRSCD ,D.SFA_SPS_FTIM_TAXRE ,D.SFA_SPS_FTIM_STAT ,D.SFA_SPS_FTIM_AGI ,D.SFA_SPS_FTIM_NOE ,D.SFA_SPS_FTIM_NOD ,D.SFA_SPS_FTIM_TI ,D.SFA_SPS_FTIM_TAXP ,D.SFA_SPS_FTIM_EDUC ,D.SFA_SPS_FTIM_UNIRA ,D.SFA_SPS_FTIM_DEIRA ,D.SFA_SPS_FTIM_TAXEM ,D.SFA_SPS_FTIM_UNTAX ,D.SFA_SPS_FTIM_CSCHD ,D.SFA_SPS_FTIM_SCHDA ,D.SFA_SPS_FTIM_SCHDB ,D.SFA_SPS_FTIM_SCHDD ,D.SFA_SPS_FTIM_SCHDE ,D.SFA_SPS_FTIM_SCHDF ,D.SFA_SPS_FTIM_SCHDH ,D.SFA_SPS_FTIM_IRSCD ,D.SFA_PAR_FTIM_TAXRE ,D.SFA_PAR_FTIM_STAT ,D.SFA_PAR_FTIM_AGI ,D.SFA_PAR_FTIM_NOE ,D.SFA_PAR_FTIM_NOD ,D.SFA_PAR_FTIM_TI ,D.SFA_PAR_FTIM_TAXP ,D.SFA_PAR_FTIM_EDUC ,D.SFA_PAR_FTIM_UNIRA ,D.SFA_PAR_FTIM_DEIRA ,D.SFA_PAR_FTIM_TAXEM ,D.SFA_PAR_FTIM_UNTAX ,D.SFA_PAR_FTIM_CSCHD ,D.SFA_PAR_FTIM_SCHDA ,D.SFA_PAR_FTIM_SCHDB ,D.SFA_PAR_FTIM_SCHDD ,D.SFA_PAR_FTIM_SCHDE ,D.SFA_PAR_FTIM_SCHDF ,D.SFA_PAR_FTIM_SCHDH ,D.SFA_PAR_FTIM_IRSCD ,D.SFA_OTH_FTIM_TAXRE ,D.SFA_OTH_FTIM_STAT ,D.SFA_OTH_FTIM_AGI ,D.SFA_OTH_FTIM_NOE ,D.SFA_OTH_FTIM_NOD ,D.SFA_OTH_FTIM_TI ,D.SFA_OTH_FTIM_TAXP ,D.SFA_OTH_FTIM_EDUC ,D.SFA_OTH_FTIM_UNIRA ,D.SFA_OTH_FTIM_DEIRA ,D.SFA_OTH_FTIM_TAXEM ,D.SFA_OTH_FTIM_UNTAX ,D.SFA_OTH_FTIM_CSCHD ,D.SFA_OTH_FTIM_SCHDA ,D.SFA_OTH_FTIM_SCHDB ,D.SFA_OTH_FTIM_SCHDD ,D.SFA_OTH_FTIM_SCHDE ,D.SFA_OTH_FTIM_SCHDF ,D.SFA_OTH_FTIM_SCHDH ,D.SFA_OTH_FTIM_IRSCD FROM PS_ISIR_CONTROL A LEFT JOIN PS_SFA_ISIR_CONT D ON A.EMPLID = D.EMPLID AND A.INSTITUTION = D.INSTITUTION AND A.AID_YEAR = D.AID_YEAR AND A.EFFDT = D.EFFDT AND A.EFFSEQ = D.EFFSEQ WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ISIR_CONTROL B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_ISIR_CONTROL C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR = A.AID_YEAR AND C.EFFDT = A.EFFDT)

# 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 ISIR_TXN_NBR Number(2,0) SMALLINT NOT NULL Transaction Num
5 ORIG_SSN Character(9) VARCHAR2(9) NOT NULL Original SSN
6 NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
7 LAST_NAME_SSN_CHNG Character(1) VARCHAR2(1) NOT NULL Last Name-SSN Change Flag
8 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
9 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
10 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
11 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
12 DT_APP_RECEIVED Date(10) DATE Date Application Received

Default Value: %date

13 PELL_ELIGIBILITY Character(1) VARCHAR2(1) NOT NULL Federal PELL Eligibility
Y=Yes
14 ASSIGNED_PIN Number(4,0) SMALLINT NOT NULL Unique Nbr Assigned to Student
15 DUPLICATE_REQUEST Character(1) VARCHAR2(1) NOT NULL Duplicate Request Indicator
16 SAR_C_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates When 'C' Printed SAR
Y=SAR C Flag Set
17 MDE_EDE_SITE_CODE Character(1) VARCHAR2(1) NOT NULL MDE/EDE Site Code
1=Site 1
2=Site 2
18 MDE_SITE_NBR Character(1) VARCHAR2(1) NOT NULL MDE Site Nbr
19 VERF_SELECTION_IND Character(2) VARCHAR2(2) NOT NULL Verification Selection Ind
*=Subsequent Trans Select
N=Not Selected
Y=Selected
20 HOLD_IND Character(1) VARCHAR2(1) NOT NULL Hold Indicator. Enables user to indicate whether a transaction should be kept from processing (until the indicator is turned "OFF" again)
A=On Hold Drug Abuse
C=On Hold
D=On Hold
F=On Hold
G=On Hold Drug Abuse
H=On Hold
J=On Hold Drug Abuse
M=On Hold
N=On Hold SSS
S=Selected for Verf, Hold Rlsd
U=Selected for Verf, Hold Rlsd
Y=Removed SSS Hold
21 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
22 TRANS_RECEIPT_DT Date(10) DATE Transaction Receipt Date
23 TRANS_PROCESS_DT Date(10) DATE Transaction Process Date
24 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
25 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
26 APP_SOURCE_SITE Character(1) VARCHAR2(1) NOT NULL Appl Source Site Code
1=Site 1
2=Site 2
27 BATCH_NUMBER Character(23) VARCHAR2(23) NOT NULL CPS Batch Number
28 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
29 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
30 VERIFCATION_TYPE Character(2) VARCHAR2(2) NOT NULL Verfication Type
31 CORRECTION_APPLIED Character(2) VARCHAR2(2) NOT NULL Correction Applied
32 FAA_INSTITUT_NUM Character(6) VARCHAR2(6) NOT NULL FAA Institution Nbr
33 INS_VERF_NUM Character(15) VARCHAR2(15) NOT NULL INS Verification Nbr
34 FULL_PARTIAL_ESAR Character(1) VARCHAR2(1) NOT NULL Full or Partial ESAR Recvd
35 MULTI_INSTITUTION Character(10) VARCHAR2(10) NOT NULL Multiple Institution Flags
36 SEND_ISAR_SW Character(1) VARCHAR2(1) NOT NULL Send ISAR to Student

Default Value: Y

37 FINAL_REVIEW_SW Character(1) VARCHAR2(1) NOT NULL Final Review
N=No - Student Data Not Reviewed
Y=Yes - Student Data Reviewed
38 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
39 FAA_SIGNATURE Character(1) VARCHAR2(1) NOT NULL FAA Signature
1=Signed
40 APPLICATION_STAT Character(1) VARCHAR2(1) NOT NULL Application Status
1=Send Electronic Application
2=Pending
3=Application Sent
41 APP_STAT_DT Date(10) DATE Application Status Date
42 EFC_STATUS Character(1) VARCHAR2(1) NOT NULL EFC Status Indicator
O=Official
R=Rejected
U=Unofficial
Z=Provisional
43 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
44 ADJ_EFC_CALC_REQ Character(1) VARCHAR2(1) NOT NULL Adjusted EFC Calc Requested
1=Calc Adjustment Processed
2=Calc Adjustment Failed
45 ASSUMPTION_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Send Assumptions/Overrides
N=No
Y=Yes
46 CORRECTION_STATUS Character(1) VARCHAR2(1) NOT NULL Correction Status
1=Correction(s) Pending
2=Send Correction(s)
3=Correction(s) Sent
4=Correction(s) Accepted
5=Corrections Rejected
6=Do Not Send Corrections
47 CORR_STAT_DT Date(10) DATE Correction Status Date
48 CORR_NAME Character(1) VARCHAR2(1) NOT NULL Correct Name Flag
49 CORR_ADDRESS Character(1) VARCHAR2(1) NOT NULL Correct Address Flag
50 CORR_SSN Character(1) VARCHAR2(1) NOT NULL Correct SSN Flag
51 CORR_DOB Character(1) VARCHAR2(1) NOT NULL Correct Date of Birth Flag
52 CORR_PHONE Character(1) VARCHAR2(1) NOT NULL Correct Phone Flag
53 CORR_STATE_RES Character(1) VARCHAR2(1) NOT NULL Correct State Residency Flag
54 CORR_STATE_RES_DT Character(1) VARCHAR2(1) NOT NULL Correct State Res Date Flag
55 CORR_LICENSE Character(1) VARCHAR2(1) NOT NULL Correct Drivers License Flag
56 CORR_LICENSE_STATE Character(1) VARCHAR2(1) NOT NULL Correct Driver Lic State Flag
57 CORR_CIT_STATUS Character(1) VARCHAR2(1) NOT NULL Correct Citzenship Status Flag
58 CORR_ALIEN_REG_NUM Character(1) VARCHAR2(1) NOT NULL Correct Alien Reg Nbr
59 CORR_MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Correct Marital Status Flag
60 CORR_MARITAL_DATE Character(1) VARCHAR2(1) NOT NULL Correct Marital Stat Date Flag
61 TITLEIV_ELIG Character(1) VARCHAR2(1) NOT NULL Title IV Fund Eligibility
I=Institutional Override
62 ISIR_PRINT_REQUEST Character(1) VARCHAR2(1) NOT NULL Print ISIR
63 ISIR_PRINT_DT Date(10) DATE ISIR Print Date
64 INST_PROCESS_DT Date(10) DATE Institution Process Date
65 ADJ_EFC Number(4,0) SMALLINT NOT NULL Unofficial Estimated EFC
66 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
67 ISIR_SERIAL_NUM Number(5,0) INTEGER NOT NULL Serial Nbr
68 OWNING_SCHOOL_CD Character(6) VARCHAR2(6) NOT NULL Owning School Cd
69 SEND_VERIFY_FIELDS Character(1) VARCHAR2(1) NOT NULL Include Verify Fields
70 NSLDS_TXN_NBR Character(2) VARCHAR2(2) NOT NULL NSLDS Transaction Nbr
71 INAS_RFC_CALL Character(1) VARCHAR2(1) NOT NULL Calc EFC via Remote Call
N=No
Y=Yes
72 EARLY_ANALYSIS_FLG Character(1) VARCHAR2(1) NOT NULL Early Analysis Flag
73 ELECTRONIC_APP_VER Character(6) VARCHAR2(6) NOT NULL Electronic App Version No
74 ETI_DEST_CD Character(7) VARCHAR2(7) NOT NULL ETI Destination Code
75 ISIR_REC_TYPE Character(1) VARCHAR2(1) NOT NULL ISIR Record Code
C=Correction Application
D=Duplicate Request
H=Correction
Q=EDE Quick Correction
R=Renewal FAFSA Web or Paper
S=Web Signatures
V=EDE Verification Corrections
76 SIMP_NEED_TEST Character(1) VARCHAR2(1) NOT NULL Simplified Need Test
77 SSN_DATE_OF_DEATH Date(10) DATE SSN Date of Death
78 SUB_APP_FLAG Character(1) VARCHAR2(1) NOT NULL Subsequent Application Flag
79 COMPUTE_BTCH_NO Character(3) VARCHAR2(3) NOT NULL Compute Batch Number
80 DUP_PROC_DT Date(10) DATE Process Date of Dup Rqst
81 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
82 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
83 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
84 PROCESS_DT Date(10) DATE Process Date
85 APP_SOURCE Character(2) VARCHAR2(2) NOT NULL CPS Appl Source Site Cd
86 TRANS_SOURCE Character(2) VARCHAR2(2) NOT NULL Transaction Data Source
87 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
88 OVRD_ADDR_TYPE Character(1) VARCHAR2(1) NOT NULL Override Address Type
89 PREP_SSN Character(9) VARCHAR2(9) NOT NULL Preparers SSN
90 PREP_SIGNATURE Character(1) VARCHAR2(1) NOT NULL Preparers Signature
1=Yes
X=Blank
91 PREP_EIN Character(9) VARCHAR2(9) NOT NULL Preparers EIN
92 ISIR_CORR_SRC Character(1) VARCHAR2(1) NOT NULL Correction Source
A=Applicant
D=CPS
S=School
93 ISIR_EFC_CHANGE Character(1) VARCHAR2(1) NOT NULL EFC Change Flag
1=EFC Increase
2=EFC Decrease
94 ISIR_SEC_INS_MATCH Character(1) VARCHAR2(1) NOT NULL Sec INS Match Flag
C=Not yet confirmed by INS
N=Citizenship Not Confirmed
P=Pending Confirmation
X=Not enough info to confirm
Y=Citizenship Confirmed
95 ISIR_SEC_INS_VERF Character(15) VARCHAR2(15) NOT NULL Sec INS Verification Number
96 ISIR_DUP_SSN_CD Character(1) VARCHAR2(1) NOT NULL Duplicate SSN Code
97 CORR_EMAIL_ADDR Character(1) VARCHAR2(1) NOT NULL Correct Email Address
98 ISIR_ORIG_IND Character(1) VARCHAR2(1) NOT NULL Original ISIR
99 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
100 EFC_OVRD_DSPLAY_FM Character(1) VARCHAR2(1) NOT NULL Flag that triggers the display of EFC Override labels.
101 ISIR_CPS_PUSHED Character(1) VARCHAR2(1) NOT NULL CPS Pushed ISIR Flag
102 ISIR_SAR_C_CHNG Character(1) VARCHAR2(1) NOT NULL ISIR SAR C Flag Changed
Y=FPS C Flag Has Changed
103 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
104 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
105 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
106 SFA_REJ_ST_CHG_FLG Character(1) VARCHAR2(1) NOT NULL Rejected Status Change Flag
1=REJ ST C Flag Has Changed
107 ISIR_OVRD_E_TYPE Character(1) VARCHAR2(1) NOT NULL Override Email Type
108 ISIR_OVRD_P_TYPE Character(1) VARCHAR2(1) NOT NULL Override Phone Type
109 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
110 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
111 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
112 SFA_DOD_MATCH Character(1) VARCHAR2(1) NOT NULL Dept of Defense Match
Y=SSN included in DOD file
113 SFA_DOD_PARENT Date(10) DATE DOD Parent Date of Death
114 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
115 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
116 SFA_HIGH_SCHL_FLAG Character(1) VARCHAR2(1) NOT NULL High School Flag
Y=High School not found
117 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
118 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
119 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
120 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
121 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
122 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
123 SFA_CFH_INDICATOR Character(1) VARCHAR2(1) NOT NULL Children of Fallen Heroes
1=Yes
2=No
124 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
125 SFA_PREP_FIRSTNAME Character(35) VARCHAR2(35) NOT NULL 2425: First Name
126 SFA_PREP_LASTNAME Character(35) VARCHAR2(35) NOT NULL 2425:Last Name
127 SFA_PREP_AFF Character(30) VARCHAR2(30) NOT NULL 2425:Affiliation
128 SFA_PREP_STREET Character(40) VARCHAR2(40) NOT NULL 2425: Spouse Street Address
129 SFA_PREP_CITY Character(30) VARCHAR2(30) NOT NULL 2425:Spouse City
130 SFA_PREP_STATE Character(2) VARCHAR2(2) NOT NULL 2425:Spouse State
131 SFA_PREP_ZIPCODE Character(10) VARCHAR2(10) NOT NULL 2425:Spouse Zip Code
132 SFA_PREP_SIGNDATE Date(10) DATE 2425:Signature Date
133 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
134 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
135 SFA_TRANSACT_TYPE Character(1) VARCHAR2(1) NOT NULL 2425 Transaction Type
A=Application
C=Correction
136 SFA_TRANSACT_LANG Character(1) VARCHAR2(1) NOT NULL 2425 Transaction Language
E=English
S=Spanish
137 SFA_TRANSACT_STAT Character(30) VARCHAR2(30) NOT NULL 2425 : Transaction Status
138 SFA_RENEWAL_DAT Character(3) VARCHAR2(3) NOT NULL 2425:Renewal Data Used
1=Yes
2=Blank
139 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
140 SFA_STD_AFFIRM Character(1) VARCHAR2(1) NOT NULL 2425:Student Affirmation Status
1=Yes
X=Blank
141 SFA_SPS_AFFIRM Character(1) VARCHAR2(1) NOT NULL 2425:Spouse Affirmation Status�
1=Yes
X=Blank
142 SFA_PAR_AFFIRM Character(1) VARCHAR2(1) NOT NULL 2425:Parent Affirmation Status
1=Yes
X=Blank
143 SFA_OTH_AFFIRM Character(1) VARCHAR2(1) NOT NULL 2425:Other Parent Affirmation Status
1=Yes
X=Blank
144 SFA_STD_CONGRANT Date(10) DATE 2425:Student Date Consent Granted�
145 SFA_SPS_CONGRANT Date(10) DATE 2425:Spouse Date Consent Granted
146 SFA_PAR_CONGRANT Date(10) DATE 2425:Parent Date Consent Granted�
147 SFA_OTH_CONGRANT Date(10) DATE 2425:Other Parent Date Consent Granted�
148 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
149 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
150 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
151 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
152 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
153 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
154 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
155 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
156 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
157 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
158 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
159 SFA_ELECT_FED_SCHL Character(2) VARCHAR2(2) NOT NULL 2425:Electronic Federal School Code
160 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
161 SFA_STD_FTIM_FTI Character(11) VARCHAR2(11) NOT NULL 2425:FTI label start
162 SFA_STD_FTIM_TAXRE Character(4) VARCHAR2(4) NOT NULL 2425:Returned tax year
163 SFA_STD_FTIM_STAT Character(1) VARCHAR2(1) NOT NULL 2425:Filing status code
164 SFA_STD_FTIM_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
165 SFA_STD_FTIM_NOE Number(2,0) SMALLINT NOT NULL 2425:Number of exemptions
166 SFA_STD_FTIM_NOD Number(2,0) SMALLINT NOT NULL 2425:Number of dependents
167 SFA_STD_FTIM_TI Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Total income earned amount�
168 SFA_STD_FTIM_TAXP Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Total tax paid amount�
169 SFA_STD_FTIM_EDUC Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Educational credits
170 SFA_STD_FTIM_UNIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Untaxed IRA distributions
171 SFA_STD_FTIM_DEIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:IRA deductible and payments
172 SFA_STD_FTIM_TAXEM Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Tax exempt interest
173 SFA_STD_FTIM_UNTAX Signed Number(13,0) DECIMAL(12) NOT NULL Untaxed pensions amount
174 SFA_STD_FTIM_CSCHD Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C net profit/loss�
175 SFA_STD_FTIM_SCHDA Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
1=Yes
2=No
176 SFA_STD_FTIM_SCHDB Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
1=Yes
2=No
177 SFA_STD_FTIM_SCHDD Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
1=Yes
2=No
178 SFA_STD_FTIM_SCHDE Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
1=Yes
2=No
179 SFA_STD_FTIM_SCHDF Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
1=Yes
2=No
180 SFA_STD_FTIM_SCHDH Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
1=Yes
2=No
181 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
182 SFA_SPS_FTIM_TAXRE Character(4) VARCHAR2(4) NOT NULL 2425:Returned tax year
183 SFA_SPS_FTIM_STAT Character(1) VARCHAR2(1) NOT NULL 2425:Filing status code
184 SFA_SPS_FTIM_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
185 SFA_SPS_FTIM_NOE Number(2,0) SMALLINT NOT NULL 2425:Number of exemptions
186 SFA_SPS_FTIM_NOD Number(2,0) SMALLINT NOT NULL 2425:Number of dependents
187 SFA_SPS_FTIM_TI Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Total income earned amount�
188 SFA_SPS_FTIM_TAXP Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Total tax paid amount�
189 SFA_SPS_FTIM_EDUC Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Educational credits
190 SFA_SPS_FTIM_UNIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Untaxed IRA distributions
191 SFA_SPS_FTIM_DEIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:IRA deductible and payments
192 SFA_SPS_FTIM_TAXEM Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Tax exempt interest
193 SFA_SPS_FTIM_UNTAX Signed Number(13,0) DECIMAL(12) NOT NULL Untaxed pensions amount
194 SFA_SPS_FTIM_CSCHD Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C net profit/loss�
195 SFA_SPS_FTIM_SCHDA Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
196 SFA_SPS_FTIM_SCHDB Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
197 SFA_SPS_FTIM_SCHDD Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
198 SFA_SPS_FTIM_SCHDE Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
199 SFA_SPS_FTIM_SCHDF Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
200 SFA_SPS_FTIM_SCHDH Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
201 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
202 SFA_PAR_FTIM_TAXRE Character(4) VARCHAR2(4) NOT NULL 2425:Returned tax year
203 SFA_PAR_FTIM_STAT Character(1) VARCHAR2(1) NOT NULL 2425:Filing status code
204 SFA_PAR_FTIM_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
205 SFA_PAR_FTIM_NOE Number(2,0) SMALLINT NOT NULL 2425:Number of exemptions
206 SFA_PAR_FTIM_NOD Number(2,0) SMALLINT NOT NULL 2425:Number of dependents
207 SFA_PAR_FTIM_TI Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Total income earned amount�
208 SFA_PAR_FTIM_TAXP Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Total tax paid amount�
209 SFA_PAR_FTIM_EDUC Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Educational credits
210 SFA_PAR_FTIM_UNIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Untaxed IRA distributions
211 SFA_PAR_FTIM_DEIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:IRA deductible and payments
212 SFA_PAR_FTIM_TAXEM Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Tax exempt interest
213 SFA_PAR_FTIM_UNTAX Signed Number(13,0) DECIMAL(12) NOT NULL Untaxed pensions amount
214 SFA_PAR_FTIM_CSCHD Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C net profit/loss�
215 SFA_PAR_FTIM_SCHDA Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
216 SFA_PAR_FTIM_SCHDB Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
217 SFA_PAR_FTIM_SCHDD Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
218 SFA_PAR_FTIM_SCHDE Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
219 SFA_PAR_FTIM_SCHDF Character(1) VARCHAR2(1) NOT NULL 2425:Schedule F indicator
220 SFA_PAR_FTIM_SCHDH Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
221 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
222 SFA_OTH_FTIM_TAXRE Character(4) VARCHAR2(4) NOT NULL 2425:Returned tax year
223 SFA_OTH_FTIM_STAT Character(1) VARCHAR2(1) NOT NULL 2425:Filing status code
224 SFA_OTH_FTIM_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
225 SFA_OTH_FTIM_NOE Number(2,0) SMALLINT NOT NULL 2425:Number of exemptions
226 SFA_OTH_FTIM_NOD Number(2,0) SMALLINT NOT NULL 2425:Number of dependents
227 SFA_OTH_FTIM_TI Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Total income earned amount�
228 SFA_OTH_FTIM_TAXP Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Total tax paid amount�
229 SFA_OTH_FTIM_EDUC Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Educational credits
230 SFA_OTH_FTIM_UNIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Untaxed IRA distributions
231 SFA_OTH_FTIM_DEIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:IRA deductible and payments
232 SFA_OTH_FTIM_TAXEM Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Tax exempt interest
233 SFA_OTH_FTIM_UNTAX Signed Number(13,0) DECIMAL(12) NOT NULL Untaxed pensions amount
234 SFA_OTH_FTIM_CSCHD Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C net profit/loss�
235 SFA_OTH_FTIM_SCHDA Character(1) VARCHAR2(1) NOT NULL 2425:Schedule A indicator
236 SFA_OTH_FTIM_SCHDB Character(1) VARCHAR2(1) NOT NULL 2425:Schedule B indicator
237 SFA_OTH_FTIM_SCHDD Character(1) VARCHAR2(1) NOT NULL 2425:Schedule D indicator
238 SFA_OTH_FTIM_SCHDE Character(1) VARCHAR2(1) NOT NULL 2425:Schedule E indicator
239 SFA_OTH_FTIM_SCHDF Character(1) VARCHAR2(1) NOT NULL 2425:Schedule F indicator
240 SFA_OTH_FTIM_SCHDH Character(1) VARCHAR2(1) NOT NULL 2425:Schedule H indicator
241 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