SCC_SFP_R_ISIR

(SQL Table)
 Index Back

SFP ISIR Reporting Table

This SFP Reporting Table tracks ISIR data collected from the SFP ISIR web service.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 SCC_VOC_MSG_SEQ Number(15,0) DECIMAL(15) NOT NULL Vocado message sequence number
4 ISIR_SEQ_NO Number(5,0) INTEGER NOT NULL Sequence Number
5 SCC_SFP_AWARD_YEAR Character(12) VARCHAR2(12) NOT NULL Award Year
6 SCC_SFP_BATCH_YEAR Character(1) VARCHAR2(1) NOT NULL Batch Year
7 SCC_SFP_ORIG_SSN Character(9) VARCHAR2(9) NOT NULL Original SSN
8 SCC_SFP_NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
9 SCC_SFP_TRANS_NBR Character(2) VARCHAR2(2) NOT NULL Transaction Number
10 SCC_SFP_LAST_NAME Character(16) VARCHAR2(16) NOT NULL Student's Last name
11 SCC_SFP_FIRST_NAME Character(12) VARCHAR2(12) NOT NULL Student's First Name
12 SCC_SFP_STU_MI Character(1) VARCHAR2(1) NOT NULL Student Middle Initial
13 SCC_SFP_PERM_ADDR Character(35) VARCHAR2(35) NOT NULL Permanent Mailing Address
14 SCC_SFP_CITY Character(16) VARCHAR2(16) NOT NULL City
15 SCC_SFP_STATE Character(2) VARCHAR2(2) NOT NULL State
16 SCC_SFP_ZIP Character(5) VARCHAR2(5) NOT NULL Zip
17 SCC_SFP_BIRTHDATE Date(10) DATE Date of Birth
18 SCC_SFP_PERM_PHONE Character(10) VARCHAR2(10) NOT NULL Perm Phone Number
19 SCC_SFP_DRVE_LICNO Character(20) VARCHAR2(20) NOT NULL Driver's License #
20 SCC_SFP_DL_STATE Character(2) VARCHAR2(2) NOT NULL Driver's License State Code
21 SCC_SFP_EMAIL Character(50) VARCHAR2(50) NOT NULL Student's Email Address
22 SCC_SFP_CTZN_STAT Character(1) VARCHAR2(1) NOT NULL Citizenship Status
23 SCC_SFP_ALIEN_REG Character(9) VARCHAR2(9) NOT NULL Alien Registration Number
24 SCC_SFP_MAR_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
25 SCC_SFP_MAR_STT_DT Character(6) VARCHAR2(6) NOT NULL Marital Status Date
26 SCC_SFP_STATE_RES Character(2) VARCHAR2(2) NOT NULL State of Legal Residence
27 SCC_SFP_RES_PRIOR Character(1) VARCHAR2(1) NOT NULL Legal Res Before 01-01-XXXX
28 SCC_SFP_LEG_RES_DT Character(6) VARCHAR2(6) NOT NULL Legal Residence Date
29 SCC_SFP_STD_GENDER Character(1) VARCHAR2(1) NOT NULL Are You Male or Female
30 SCC_SFP_SEL_SERV_R Character(1) VARCHAR2(1) NOT NULL Permit Sel Serv to Enroll
31 SCC_SFP_DRUG_OFF_C Character(1) VARCHAR2(1) NOT NULL Drug Offense Conviction
32 SCC_SFP_FAT_GRDLVL Character(1) VARCHAR2(1) NOT NULL Father's Highest Grade Level
33 SCC_SFP_MOT_GRDLVL Character(1) VARCHAR2(1) NOT NULL Mother's Highest Grade Level
34 SCC_SFP_HS_DIP_EQ Character(1) VARCHAR2(1) NOT NULL HS Diploma or Equivalent
35 SCC_SFP_HS_NAME Character(50) VARCHAR2(50) NOT NULL High School Name
36 SCC_SFP_HS_CITY Character(28) VARCHAR2(28) NOT NULL High School City
37 SCC_SFP_HS_STATE Character(2) VARCHAR2(2) NOT NULL High School State
38 SCC_SFP_HS_CODE Character(12) VARCHAR2(12) NOT NULL High School Code
39 SCC_SFP_FRST_BACH Character(1) VARCHAR2(1) NOT NULL Received First Bachelor Degree
40 SCC_SFP_GRADE_LEV Character(1) VARCHAR2(1) NOT NULL 36
41 SCC_SFP_DEGREE_CER Character(1) VARCHAR2(1) NOT NULL Degree/Certificate
42 SCC_SFP_INT_IN_WS Character(1) VARCHAR2(1) NOT NULL Interested In Work-Study
43 SCC_SFP_TAX_FORM Character(1) VARCHAR2(1) NOT NULL Tax Form-Student
44 SCC_SFP_TAX_FORM_F Character(1) VARCHAR2(1) NOT NULL Tax Form Filed
45 SCC_SFP_TAX_RET Character(1) VARCHAR2(1) NOT NULL Student Return Filing Status Added for regs1 1415
46 SCC_SFP_1040A_EZ Character(1) VARCHAR2(1) NOT NULL Eligible For 1040A or EZ
47 SCC_SFP_STU_AGI Signed Number(18,2) DECIMAL(16,2) NOT NULL Student AGI
48 SCC_SFP_TAX_PAID Signed Number(18,2) DECIMAL(16,2) NOT NULL 47
49 SCC_SFP_NBR_EXEMP Character(2) VARCHAR2(2) NOT NULL Number of Exemptions
50 SCC_SFP_WORK_INC Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Income From Work
51 SCC_SFP_SPS_WRKINC Signed Number(18,2) DECIMAL(16,2) NOT NULL Spouse Income From Work
52 SCC_SFP_STU_CASH Signed Number(18,2) DECIMAL(16,2) NOT NULL Cash and Savings
53 SCC_SFP_STU_INVEST Signed Number(18,2) DECIMAL(16,2) NOT NULL Student's Investment Net Worth
54 SCC_SFP_BUS_WORTH Signed Number(18,2) DECIMAL(16,2) NOT NULL Student's Business Net Worth
55 SCC_SFP_EDU_CREDIT Signed Number(18,2) DECIMAL(16,2) NOT NULL Student's Educational Credits
56 SCC_SFP_SUP_PAID Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Child Support Paid
57 SCC_SFP_NEED_EMPL Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Need-Based Employment
58 SCC_SFP_GRANT_AID Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Grant/Scholarship Aid
59 SCC_SFP_COMBAT_PAY Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Combat Pay
60 SCC_SFP_COOP_EARN Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Co-op Earnings
61 SCC_SFP_PEN_PAY Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Pension Payments
62 SCC_SFP_IRA_PAY Signed Number(18,2) DECIMAL(16,2) NOT NULL Student IRA Payments
63 SCC_SFP_SUP_RECV Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Child Support Received
64 SCC_SFP_INT_INCOME Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Interest Income
65 SCC_SFP_IRA_DIST Signed Number(18,2) DECIMAL(16,2) NOT NULL Student IRA Distributions
66 SCC_SFP_UNTAX_PEN Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Untaxed Pensions
67 SCC_SFP_MIL_ALLOW Signed Number(18,2) DECIMAL(16,2) NOT NULL Students Mil/Clergy Allowance
68 SCC_SFP_VET_ED_BEN Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Vet Non-Edu Benefits
69 SCC_SFP_UNTAX_INC Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Other Untaxed Income
70 SCC_SFP_NREP_MONEY Signed Number(18,2) DECIMAL(16,2) NOT NULL Other Non-Reported Money
71 SCC_SFP_BORN_PRIOR Character(1) VARCHAR2(1) NOT NULL Born Before 01-01-XXXX
72 SCC_SFP_MARRIED Character(1) VARCHAR2(1) NOT NULL Student Married
73 SCC_SFP_GRAD_STU Character(1) VARCHAR2(1) NOT NULL Grad Student
74 SCC_SFP_ACTVE_DUTY Character(1) VARCHAR2(1) NOT NULL Active Duty in U.S Military
75 SCC_SFP_VETERAN Character(1) VARCHAR2(1) NOT NULL Veteran
76 SCC_SFP_CHILDREN Character(1) VARCHAR2(1) NOT NULL Have Children you support
77 SCC_SFP_DEPENDENTS Character(1) VARCHAR2(1) NOT NULL Dependents Other Than Spouse
78 SCC_SFP_ORPHAN Character(1) VARCHAR2(1) NOT NULL Orphan or Ward of the Court
79 SCC_SFP_EMNCPTD_MI Character(1) VARCHAR2(1) NOT NULL Emancipated Minor
80 SCC_SFP_LEGAL_GUAR Character(1) VARCHAR2(1) NOT NULL Legal Guardianship
81 SCC_SFP_YOUTH_LIAS Character(1) VARCHAR2(1) NOT NULL Youth determined by SDL
82 SCC_SFP_YOUTH_HUD Character(1) VARCHAR2(1) NOT NULL Youth determined by HUD
83 SCC_SFP_RISK_HOME Character(1) VARCHAR2(1) NOT NULL At Risk of Homelessness
84 SCC_SFP_MAR_STT_PA Character(1) VARCHAR2(1) NOT NULL Marital Status-Parents
85 SCC_SFP_PAR_MAR_DT Character(6) VARCHAR2(6) NOT NULL Parents' Marital Status Date
86 SCC_SFP_FATHER_SSN Character(9) VARCHAR2(9) NOT NULL Father's SSN
87 SCC_SFP_FAT_LNAME Character(16) VARCHAR2(16) NOT NULL Father's Last Name
88 SCC_SFP_FAT_NM_INI Character(1) VARCHAR2(1) NOT NULL Father's First Name Initial
89 SCC_SFP_FATHER_DOB Date(10) DATE Father's Date of Birth
90 SCC_SFP_MOTHER_SSN Character(9) VARCHAR2(9) NOT NULL Mother's SSN
91 SCC_SFP_MOT_LNAME Character(16) VARCHAR2(16) NOT NULL Mother's Last Name
92 SCC_SFP_MOT_NM_INI Character(1) VARCHAR2(1) NOT NULL Mother's First Name Initial
93 SCC_SFP_MOTHER_DOB Date(10) DATE Mother's Date of Birth
94 SCC_SFP_PAR_EMAIL Character(50) VARCHAR2(50) NOT NULL Parent's Email Address
95 SCC_SFP_PAR_STATE Character(2) VARCHAR2(2) NOT NULL State of Legal Residence
96 SCC_SFP_PAR_RES_PR Character(1) VARCHAR2(1) NOT NULL Legal Res Before 01-01-XXXX
97 SCC_SFP_PAR_RES_DT Character(6) VARCHAR2(6) NOT NULL Legal Residence Date
98 SCC_SFP_PAR_FAM_ME Character(2) VARCHAR2(2) NOT NULL Parent Family Members
99 SCC_SFP_PAR_MEM_CO Character(1) VARCHAR2(1) NOT NULL Parents' Number in College
100 SCC_SFP_PAR_SSI_IN Character(1) VARCHAR2(1) NOT NULL SCC_SFP_PAR_SSI_IN
101 SCC_SFP_PAR_FDSTMP Character(1) VARCHAR2(1) NOT NULL Parent Receives Food Stamps
102 SCC_SFP_PAR_LUN_BE Character(1) VARCHAR2(1) NOT NULL Parent School Lunch Program
103 SCC_SFP_PAR_TANF_B Character(1) VARCHAR2(1) NOT NULL Parent TANF Recipient
104 SCC_SFP_PAR_WIC_BE Character(1) VARCHAR2(1) NOT NULL Parent WIC Benefits
105 SCC_SFP_TAX_FRM_PA Character(1) VARCHAR2(1) NOT NULL Tax Form-Parents
106 SCC_SFP_TAX_FRM_FL Character(1) VARCHAR2(1) NOT NULL Tax Form Filed - Parent
107 SCC_SFP_PAR_TAX_RE Character(1) VARCHAR2(1) NOT NULL Parent Tax Return Filing
108 SCC_SFP_1040A_PAR Character(1) VARCHAR2(1) NOT NULL Eligible For 1040A or EZ
109 SCC_SFP_PAR_DISLOC Character(1) VARCHAR2(1) NOT NULL Parent Dislocated Worker
110 SCC_SFP_PAR_AGI Signed Number(18,2) DECIMAL(16,2) NOT NULL Parent AGI
111 SCC_SFP_PAR_TAX_PD Signed Number(18,2) DECIMAL(16,2) NOT NULL 70
112 SCC_SFP_PAR_NBR_EX Character(2) VARCHAR2(2) NOT NULL Number of Exemptions
113 SCC_SFP_FAT_WRK_IN Signed Number(18,2) DECIMAL(16,2) NOT NULL Father Income From Work
114 SCC_SFP_MOT_WRK_IN Signed Number(18,2) DECIMAL(16,2) NOT NULL Mother's Income From Work
115 SCC_SFP_PAR_CASH Character(7) VARCHAR2(7) NOT NULL Cash and Savings
116 SCC_SFP_PAR_INVEST Signed Number(18,2) DECIMAL(16,2) NOT NULL Investment Net Worth
117 SCC_SFP_PAR_BUS_WR Character(7) VARCHAR2(7) NOT NULL Business Net Worth
118 SCC_SFP_PAR_EDU_CR Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Educational Credits
119 SCC_SFP_PAR_SUP_PD Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Child Support Paid
120 SCC_SFP_PAR_NEED_E Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Need-Based Employment
121 SCC_SFP_PAR_GRANT Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Grant/Scholarship Aid
122 SCC_SFP_PAR_COMBAT Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Combat Pay
123 SCC_SFP_PAR_COOP Signed Number(18,2) DECIMAL(16,2) NOT NULL Parent Co-op Earnings
124 SCC_SFP_PAR_PEN_PY Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Pension Payments
125 SCC_SFP_PAR_IRA_PY Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents IRA Payments
126 SCC_SFP_PAR_SUP_RC Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Child Support Received
127 SCC_SFP_PAR_INT_IN Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Interest Income
128 SCC_SFP_PAR_IRA Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents IRA Distributions
129 SCC_SFP_PAR_UN_PEN Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Untaxed Pensions
130 SCC_SFP_PAR_MIL_AL Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Mil/Clergy Allowance
131 SCC_SFP_PAR_VET_ED Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Vet Non-Edu Benefits
132 SCC_SFP_PAR_UN_INC Signed Number(18,2) DECIMAL(16,2) NOT NULL Parents Other Untaxed Income
133 SCC_SFP_STU_FAM_ME Character(2) VARCHAR2(2) NOT NULL Student Family Members
134 SCC_SFP_MEM_COLL Character(1) VARCHAR2(1) NOT NULL Student's Number in College
135 SCC_SFP_SSI_INCOME Character(1) VARCHAR2(1) NOT NULL Receives SSI Income
136 SCC_SFP_FOOD_STAMP Character(1) VARCHAR2(1) NOT NULL Receives Food Stamps
137 SCC_SFP_SCHL_LUNCH Character(1) VARCHAR2(1) NOT NULL Participates in Sch Lunch Prog
138 SCC_SFP_TANF_BEN Character(1) VARCHAR2(1) NOT NULL TANF Recipient
139 SCC_SFP_WIC_BENEFT Character(1) VARCHAR2(1) NOT NULL WIC Benefits Recipient
140 SCC_SFP_DISLOC_WRK Character(1) VARCHAR2(1) NOT NULL Student Dislocated Worker
141 SCC_SFP_SCHL_CH_1 Character(6) VARCHAR2(6) NOT NULL Student's 1st Choice School
142 SCC_SFP_HOUSE_CD_1 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 1
143 SCC_SFP_SCHL_CH_2 Character(6) VARCHAR2(6) NOT NULL Student's 2nd Choice School
144 SCC_SFP_HOUSE_CD_2 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 2
145 SCC_SFP_SCHL_CH_3 Character(6) VARCHAR2(6) NOT NULL Student's 3rd Choice School
146 SCC_SFP_HOUSE_CD_3 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 3
147 SCC_SFP_SCHL_CH_4 Character(6) VARCHAR2(6) NOT NULL Student's 4th Choice School
148 SCC_SFP_HOUSE_CD_4 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 4
149 SCC_SFP_SCHL_CH_5 Character(6) VARCHAR2(6) NOT NULL Student's 5th Choice School
150 SCC_SFP_HOUSE_CD_5 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 5
151 SCC_SFP_SCHL_CH_6 Character(6) VARCHAR2(6) NOT NULL Student's 6th Choice School
152 SCC_SFP_HOUSE_CD_6 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 6
153 SCC_SFP_SCHL_CH_7 Character(6) VARCHAR2(6) NOT NULL Student's 7th Choice School
154 SCC_SFP_HOUSE_CD_7 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 7
155 SCC_SFP_SCHL_CH_8 Character(6) VARCHAR2(6) NOT NULL Student's 8th Choice School
156 SCC_SFP_HOUSE_CD_8 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 8
157 SCC_SFP_SCHL_CH_9 Character(6) VARCHAR2(6) NOT NULL Student's 9th Choice School
158 SCC_SFP_HOUSE_CD_9 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 9
159 SCC_SFP_SCHL_CH_10 Character(6) VARCHAR2(6) NOT NULL Student's 10th Choice School
160 SCC_SFP_HOUSE_CD10 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 10
161 SCC_SFP_DT_APP_CMP Date(10) DATE Date Application Completed
162 SCC_SFP_APP_SIGNBY Character(1) VARCHAR2(1) NOT NULL FAFSA Signed by
163 SCC_SFP_PREP_SSN Character(9) VARCHAR2(9) NOT NULL Preparers SSN
164 SCC_SFP_PREP_EIN Character(9) VARCHAR2(9) NOT NULL Preparers EIN
165 SCC_SFP_PREP_SIGN Character(1) VARCHAR2(1) NOT NULL Preparers Signature
166 SCC_SFP_DEPEND_OVR Character(1) VARCHAR2(1) NOT NULL SCC_SFP_DEPEND_OVR
167 SCC_SFP_INST_NUM Character(6) VARCHAR2(6) NOT NULL FAA Institution Nbr
168 SCC_SFP_DEPND_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
169 SCC_SFP_TRANS_SRCE Character(2) VARCHAR2(2) NOT NULL Transaction Source Site Cd
170 SCC_SFP_TXN_REC_DT Date(10) DATE Transaction Receipt Date
171 SCC_SFP_SPL_CIR_FL Character(1) VARCHAR2(1) NOT NULL Special Circumstances Flag
172 SCC_SFP_STU_IRS_RQ Character(2) VARCHAR2(2) NOT NULL Student IRS Request
173 SCC_SFP_PAR_IRS_RQ Character(2) VARCHAR2(2) NOT NULL Parent IRS Request
174 SCC_SFP_PAR_ASSTHR Character(1) VARCHAR2(1) NOT NULL Parent Asset Threshold Exceed
175 SCC_SFP_STU_ASSTHR Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceeded
176 SCC_SFP_STU_IRSAGI Character(1) VARCHAR2(1) NOT NULL Student IRS AGI Data
177 SCC_SFP_STU_IRSFIT Character(1) VARCHAR2(1) NOT NULL Student IRS FIT Data
178 SCC_SFP_PAR_IRSAGI Character(1) VARCHAR2(1) NOT NULL Parent IRS AGI Data
179 SCC_SFP_PAR_IRSFIT Character(1) VARCHAR2(1) NOT NULL Parent IRS FIT Data
180 SCC_SFP_STU_IRSDIS Character(1) VARCHAR2(1) NOT NULL Student IRS Display
181 SCC_SFP_PAR_IRSDIS Character(1) VARCHAR2(1) NOT NULL Parent IRS Display
182 SCC_SFP_S_IRS_TX_R Character(1) VARCHAR2(1) NOT NULL Student IRS Return Data
183 SCC_SFP_S_IRS_EXMP Character(1) VARCHAR2(1) NOT NULL Student IRS Exemption Data
184 SCC_SFP_S_IRS_EDCR Character(1) VARCHAR2(1) NOT NULL Student IRS ED Credits Data
185 SCC_SFP_S_IRAPAY Character(1) VARCHAR2(1) NOT NULL Student IRS IRA Payment Data
186 SCC_SFP_S_IRS_INT Character(1) VARCHAR2(1) NOT NULL Student IRS Interest Data
187 SCC_SFP_S_IRA_DIS Character(1) VARCHAR2(1) NOT NULL Student IRS IRA Dist Data
188 SCC_SFP_S_IRS_UNTX Character(1) VARCHAR2(1) NOT NULL Student IRS Pension Data
189 SCC_SFP_S_IRS_STAT Character(1) VARCHAR2(1) NOT NULL Student IRS Filing Status Data
190 SCC_SFP_S_IRS_STA2 Character(1) VARCHAR2(1) NOT NULL Student IRS Schedule 1 Filing
191 SCC_SFP_P_IRS_TX_R Character(1) VARCHAR2(1) NOT NULL Parent IRS Return Data
192 SCC_SFP_P_IRS_EXMP Character(1) VARCHAR2(1) NOT NULL Parent IRS Exemption Data
193 SCC_SFP_P_IRS_EDCR Character(1) VARCHAR2(1) NOT NULL Parent IRS ED Credits Data
194 SCC_SFP_P_IRAPAY Character(1) VARCHAR2(1) NOT NULL Parent IRS IRA Payment Data
195 SCC_SFP_P_IRS_INT Character(1) VARCHAR2(1) NOT NULL Parent IRS Interest Data
196 SCC_SFP_P_IRA_DIS Character(1) VARCHAR2(1) NOT NULL Parent IRS IRA Dist Data
197 SCC_SFP_P_IRS_UNTX Character(1) VARCHAR2(1) NOT NULL Parent IRS Pension Data
198 SCC_SFP_P_IRS_STAT Character(1) VARCHAR2(1) NOT NULL Parent IRS Filing Status Data
199 SCC_SFP_P_IRS_STA2 Character(1) VARCHAR2(1) NOT NULL Parent IRS Schedule 1 Filing
200 SCC_SFP_CFH_INDCTR Character(1) VARCHAR2(1) NOT NULL Children of Fallen Heroes
201 SCC_SFP_ASSUM_OVR1 Character(1) VARCHAR2(1) NOT NULL Assumption Override 1
202 SCC_SFP_ASSUM_OVR2 Character(1) VARCHAR2(1) NOT NULL Assumption Override 2
203 SCC_SFP_ASSUM_OVR3 Character(1) VARCHAR2(1) NOT NULL Assumption Override 3
204 SCC_SFP_ASSUM_OVR4 Character(1) VARCHAR2(1) NOT NULL Assumption Override 4
205 SCC_SFP_ASSUM_OVR5 Character(1) VARCHAR2(1) NOT NULL Assumption Override 5
206 SCC_SFP_ASSUM_OVR6 Character(1) VARCHAR2(1) NOT NULL Assumption Override 6
207 SCC_SFP_ETI_DESTCD Character(7) VARCHAR2(7) NOT NULL ETI Destination Code
208 SCC_SFP_S_REJ_TX_O Character(1) VARCHAR2(1) NOT NULL Reject Override 3
209 SCC_SFP_P_REJ_TX_O Character(1) VARCHAR2(1) NOT NULL Reject Override 12
210 SCC_SFP_REJ_OV_NTX Character(1) VARCHAR2(1) NOT NULL Reject Override 20
211 SCC_SFP_REJ_BRTHYR Character(1) VARCHAR2(1) NOT NULL Date of Birth Yr is 1900-1928
212 SCC_SFP_REJ_IND_S Character(1) VARCHAR2(1) NOT NULL Student Independnt Status
213 SCC_SFP_REJ_TX_RNG Character(1) VARCHAR2(1) NOT NULL Taxes paid is high, but < AGI
214 SCC_SFP_REJ_TX_DEP Character(1) VARCHAR2(1) NOT NULL Taxes paid is high, but < AGI
215 SCC_SFP_REJ_DADSSN Character(1) VARCHAR2(1) NOT NULL Reject Override J
216 SCC_SFP_REJ_MOMSSN Character(1) VARCHAR2(1) NOT NULL Reject Override K
217 SCC_SFP_REJ_STU_NM Character(1) VARCHAR2(1) NOT NULL Student First/Last Name
218 SCC_SFP_REJ_BIGFAM Character(1) VARCHAR2(1) NOT NULL Large Family Size
219 SCC_SFP_REJ_MAR_ST Character(1) VARCHAR2(1) NOT NULL Reject Override 21
220 SCC_SFP_SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
221 SCC_SFP_HIS_COR_AP Character(2) VARCHAR2(2) NOT NULL History Correction Applied
222 SCC_SFP_ADJ_EFC_RQ Character(1) VARCHAR2(1) NOT NULL Adjusted EFC Calc Requested
223 SCC_SFP_APP_SOURCE Character(2) VARCHAR2(2) NOT NULL CPS Appl Source Site Cd
224 SCC_SFP_APP_RCVDT Date(10) DATE Application Receipt Date
225 SCC_SFP_ADD_CHG_FL Character(1) VARCHAR2(1) NOT NULL Address Only Change Flag
226 SCC_SFP_CPS_PUSHED Character(1) VARCHAR2(1) NOT NULL CPS Pushed ISIR Flag
227 SCC_SFP_EFC_CHG_FL Character(1) VARCHAR2(1) NOT NULL EFC Change Flag
228 SCC_SFP_LNM_SSN_CH Character(1) VARCHAR2(1) NOT NULL Last Name-SSN Change Flag
229 SCC_SFP_REJ_ST_CHG Character(1) VARCHAR2(1) NOT NULL Rejected Status Change Flag
230 SCC_SFP_SAR_C_CHG Character(1) VARCHAR2(1) NOT NULL ISIR SAR C Flag Changed
231 SCC_SFP_VF_SEL_CHG Character(1) VARCHAR2(1) NOT NULL Verification Select Chng Flag
232 SCC_SFP_COMP_NBR Character(3) VARCHAR2(3) NOT NULL Compute Batch Number
233 SCC_SFP_SRCE_CORR Character(1) VARCHAR2(1) NOT NULL Source of Correction
234 SCC_SFP_DUP_SSN_CD Character(1) VARCHAR2(1) NOT NULL Duplicate SSN Indicator
235 SCC_SFP_GRAD_FLAG Character(1) VARCHAR2(1) NOT NULL Graduate Flag
236 SCC_SFP_PELL_ELIG Character(1) VARCHAR2(1) NOT NULL Federal PELL Eligibility
237 SCC_SFP_PROCESS_DT Date(10) DATE Transaction Process Date
238 SCC_SFP_PROC_TYPE Character(1) VARCHAR2(1) NOT NULL field 133 on the 2002 ISIR
239 SCC_SFP_REJ_CODES Character(14) VARCHAR2(14) NOT NULL Reject Reason Codes
240 SCC_SFP_REJ_CODE_2 Character(14) VARCHAR2(14) NOT NULL Reject Reason Code 2
241 SCC_SFP_REJ_CODE_3 Character(14) VARCHAR2(14) NOT NULL Reject Reason Code 3
242 SCC_SFP_REJ_CODE_4 Character(14) VARCHAR2(14) NOT NULL Reject Reason Code 4
243 SCC_SFP_REJ_CODE_5 Character(14) VARCHAR2(14) NOT NULL Reject Reason Code 5
244 SCC_SFP_REJ_CODE_6 Character(14) VARCHAR2(14) NOT NULL Reject Reason Code 6
245 SCC_SFP_REJ_CODE_7 Character(14) VARCHAR2(14) NOT NULL Reject Reason Code 7
246 SCC_SFP_REPRCS_CD Character(2) VARCHAR2(2) NOT NULL Reprocess Code
247 SCC_SFP_SAR_C_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates When 'C' Printed SAR
248 SCC_SFP_ZERO_EFC Character(1) VARCHAR2(1) NOT NULL Auto Zero EFC
249 SCC_SFP_SMPL_ND_TS Character(1) VARCHAR2(1) NOT NULL Simplified Need Test
250 SCC_SFP_P_XX_TXSTT Character(1) VARCHAR2(1) NOT NULL Parents' Calc XX Tax Stat
251 SCC_SFP_S_XX_TXSTT Character(1) VARCHAR2(1) NOT NULL Student's Calc XX Tax Stat
252 SCC_SFP_STU_WK_C Signed Number(18,2) DECIMAL(16,2) NOT NULL Student's Total from WK C
253 SCC_SFP_STU_WK_B Signed Number(18,2) DECIMAL(16,2) NOT NULL Student's Total from WK B
254 SCC_SFP_PAR_WK_C Signed Number(18,2) DECIMAL(16,2) NOT NULL Parent's Total from WK C
255 SCC_SFP_PAR_WK_B Signed Number(18,2) DECIMAL(16,2) NOT NULL Total from WK B
256 SCC_SFP_HS_FLAG Character(1) VARCHAR2(1) NOT NULL High School Flag
257 SCC_SFP_ASMD_CTZN Character(1) VARCHAR2(1) NOT NULL Assumed Citizenship
258 SCC_SFP_ASMD_S_MS Character(1) VARCHAR2(1) NOT NULL Assumed Student's Mar Status
259 SCC_SFP_ASMD_AGI Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed AGI
260 SCC_SFP_ASMD_S_TAX Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Tax Paid
261 SCC_SFP_ASMD_IFW Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Income From Work
262 SCC_SFP_ASMD_SPS Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Income From Work - SPS
263 SCC_SFP_ASMD_S_WKC Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Stu Inc from WK C
264 SCC_SFP_ASMD_DOBPR Character(1) VARCHAR2(1) NOT NULL Assumed DOB Prior
265 SCC_SFP_S_MARRIED Character(1) VARCHAR2(1) NOT NULL Assumed Student is Married
266 SCC_SFP_ASMD_CHILD Character(1) VARCHAR2(1) NOT NULL Assumed Children
267 SCC_SFP_ASMD_DEP Character(1) VARCHAR2(1) NOT NULL Assumed Stdnt Legal Dependents
268 SCC_SFP_ASMD_FAMNO Character(2) VARCHAR2(2) NOT NULL Assumed Num in Family
269 SCC_SFP_ASMD_COLNO Character(1) VARCHAR2(1) NOT NULL Assumed Num in Coll
270 SCC_SFP_S_ASMD_ASS Character(1) VARCHAR2(1) NOT NULL Assumed Stu Asset Thrs Exceed
271 SCC_SFP_ASMD_P_MS Character(1) VARCHAR2(1) NOT NULL Assumed Parent Marital Status
272 SCC_SFP_ASMD_F_SSN Character(9) VARCHAR2(9) NOT NULL Assumed Father's SSN
273 SCC_SFP_ASMD_M_SSN Character(9) VARCHAR2(9) NOT NULL Assumed Mother's SSN
274 SCC_SFP_AS_P_FAMNO Character(2) VARCHAR2(2) NOT NULL Assumed Par Nbr in Fam
275 SCC_SFP_AS_P_COLNO Character(1) VARCHAR2(1) NOT NULL Assumed Par Nbr in Coll
276 SCC_SFP_ASMD_P_AGI Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Parent AGI
277 SCC_SFP_ASS_P_TXPD Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Parents' Tax Pd
278 SCC_SFP_ASS_F_INC Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Father Income
279 SCC_SFP_ASS_M_INC Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Mother Income
280 SCC_SFP_ASS_P_WKC Signed Number(18,2) DECIMAL(16,2) NOT NULL Assumed Parents' WK C
281 SCC_SFP_P_ASS_THRS Character(1) VARCHAR2(1) NOT NULL Assumed Par Asset Thrs Exceed
282 SCC_SFP_PRI_EFC Character(6) VARCHAR2(6) NOT NULL Primary EFC
283 SCC_SFP_SEC_EFC Character(6) VARCHAR2(6) NOT NULL Secondary EFC
284 SCC_SFP_SGNREJ_EFC Character(6) VARCHAR2(6) NOT NULL Signature Reject EFC
285 SCC_SFP_FORM_TYPE Character(1) VARCHAR2(1) NOT NULL Formula Type
286 SCC_SFP_FORM_TYP_S Character(1) VARCHAR2(1) NOT NULL Formula Type
287 SCC_SFP_PRI_MO_01 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 1
288 SCC_SFP_PRI_MO_02 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 2
289 SCC_SFP_PRI_MO_03 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 3
290 SCC_SFP_PRI_MO_04 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 4
291 SCC_SFP_PRI_MO_05 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 5
292 SCC_SFP_PRI_MO_06 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 6
293 SCC_SFP_PRI_MO_07 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 7
294 SCC_SFP_PRI_MO_08 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 8
295 SCC_SFP_PRI_MO_10 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 10
296 SCC_SFP_PRI_MO_11 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 11
297 SCC_SFP_PRI_MO_12 Character(6) VARCHAR2(6) NOT NULL Primary Alternate Month 12
298 SCC_SFP_SEC_MO_01 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 1
299 SCC_SFP_SEC_MO_02 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 2
300 SCC_SFP_SEC_MO_03 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 3
301 SCC_SFP_SEC_MO_04 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 4
302 SCC_SFP_SEC_MO_05 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 5
303 SCC_SFP_SEC_MO_06 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 6
304 SCC_SFP_SEC_MO_07 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 7
305 SCC_SFP_SEC_MO_08 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 8
306 SCC_SFP_SEC_MO_10 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 10
307 SCC_SFP_SEC_MO_11 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 11
308 SCC_SFP_SEC_MO_12 Character(6) VARCHAR2(6) NOT NULL Secondary Alternate Month 12
309 SCC_SFP_TOT_INC_CH Signed Number(18,2) DECIMAL(16,2) NOT NULL Total Income
310 SCC_SFP_ALWNC_TICH Signed Number(18,2) DECIMAL(16,2) NOT NULL Allowance VS Total Income
311 SCC_SFP_STAX_AL_CH Signed Number(18,2) DECIMAL(16,2) NOT NULL State Tax Allowance
312 SCC_SFP_EMPL_AL_CH Signed Number(18,2) DECIMAL(16,2) NOT NULL Employment Allowance
313 SCC_SFP_INCPR_A_CH Signed Number(18,2) DECIMAL(16,2) NOT NULL Income Protection Allowance
314 SCC_SFP_AVL_INC_CH Signed Number(18,2) DECIMAL(16,2) NOT NULL Available Income
315 SCC_SFP_CA_INC_CH Signed Number(18,2) DECIMAL(16,2) NOT NULL Contribution Available Income
316 SCC_SFP_DNW_CH Signed Number(18,2) DECIMAL(16,2) NOT NULL Discretionary Net Worth
317 SCC_SFP_EFC_NETWRT Signed Number(18,2) DECIMAL(16,2) NOT NULL NW: EFC Net Worth
318 SCC_SFP_AST_PA_CH Signed Number(18,2) DECIMAL(16,2) NOT NULL Asset Protection Allowance
319 SCC_SFP_CONT_ASSCH Signed Number(18,2) DECIMAL(16,2) NOT NULL Contribution from Assets
320 SCC_SFP_ADJ_AVLINC Signed Number(18,2) DECIMAL(16,2) NOT NULL Adjusted Available Income
321 SCC_SFP_TOT_S_CONT Signed Number(18,2) DECIMAL(16,2) NOT NULL Total Student Contribution
322 SCC_SFP_TOT_P_CONT Signed Number(18,2) DECIMAL(16,2) NOT NULL Total Parent Contribution
323 SCC_SFP_ADJ_P_CONT Signed Number(18,2) DECIMAL(16,2) NOT NULL Parent Contribution
324 SCC_SFP_S_TOT_INC Signed Number(18,2) DECIMAL(16,2) NOT NULL Student's Total Income
325 SCC_SFP_SATI Signed Number(18,2) DECIMAL(16,2) NOT NULL Student's Allowance vs TI
326 SCC_SFP_S_INC_CONT Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Income Contribution
327 SCC_SFP_SDNW Signed Number(18,2) DECIMAL(16,2) NOT NULL Student's Disc Net Worth
328 SCC_SFP_S_ASS_CONT Signed Number(18,2) DECIMAL(16,2) NOT NULL Student Asset Contribution
329 SCC_SFP_FISAP_TI Signed Number(18,2) DECIMAL(16,2) NOT NULL FISAP Total Income
330 SCC_SFP_SEC_TI Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary total Income
331 SCC_SFP_SEC_ATI Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Allowance vs Income
332 SCC_SFP_SEC_STX Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary State Tax Allowance
333 SCC_SFP_SEC_EA Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Employment Allowance
334 SCC_SFP_SEC_IPA Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Inc Prot Allowance
335 SCC_SFP_SEC_AI Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Available Income
336 SCC_SFP_SEC_CAI Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Contribution From AI
337 SCC_SFP_SEC_DNW Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary DNW
338 SCC_SFP_SEC_NW Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Net Worth
339 SCC_SFP_SEC_APA Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Asset Protect Allow
340 SCC_SFP_SEC_PCA Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Par Cont From Assets
341 SCC_SFP_SEC_AAI Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Adjusted Avail Inc
342 SCC_SFP_SEC_TSC Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Total Stu Contrib
343 SCC_SFP_SEC_TPC Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Total Parent Contrib
344 SCC_SFP_SEC_PC Character(7) VARCHAR2(7) NOT NULL Secondary Parent Contribution
345 SCC_SFP_SEC_STI Character(8) VARCHAR2(8) NOT NULL Secondary Stu Total Income
346 SCC_SFP_SEC_SATI Character(7) VARCHAR2(7) NOT NULL Secondary Stu All vs TI
347 SCC_SFP_SEC_SIC Character(7) VARCHAR2(7) NOT NULL Secondary Stu Ind Dep IC
348 SCC_SFP_SEC_SDNW Character(9) VARCHAR2(9) NOT NULL Secondary Stu DNW
349 SCC_SFP_SEC_SCA Character(7) VARCHAR2(7) NOT NULL Sec Stdnt Contrib from Assets
350 SCC_SFP_SEC_FTI Character(8) VARCHAR2(8) NOT NULL Secondary FISAP Total Inc
351 SCC_SFP_CORRECTION Character(195) VARCHAR2(195) NOT NULL Corrections
352 SCC_SFP_HIGHLIGHT Character(195) VARCHAR2(195) NOT NULL Highlights
353 SCC_SFP_DATAVERIFY Character(195) VARCHAR2(195) NOT NULL FAFSA Data Verify Flags
354 SCC_SFP_INS_MATCH Character(1) VARCHAR2(1) NOT NULL INS Match
355 SCC_SFP_2INS_MATCH Character(1) VARCHAR2(1) NOT NULL Secondary INS Match Flag
356 SCC_SFP_INS_VRFYNO Character(15) VARCHAR2(15) NOT NULL Ins Verif Num
357 SCC_SFP_F_SSNMATCH Character(1) VARCHAR2(1) NOT NULL Father's SSN Match
358 SCC_SFP_M_SSNMATCH Character(1) VARCHAR2(1) NOT NULL SCC_SFP_F_SSNMATCH
359 SCC_SFP_SS_MATCH Character(1) VARCHAR2(1) NOT NULL Selective Service Match
360 SCC_SFP_SS_REG Character(1) VARCHAR2(1) NOT NULL Selective Service Registration
361 SCC_SFP_SSA_CTZIND Character(1) VARCHAR2(1) NOT NULL SSA Citizenship Indicator
362 SCC_SFP_SSN_MATCH Character(1) VARCHAR2(1) NOT NULL SSN Match
363 SCC_SFP_VA_MATCH Character(1) VARCHAR2(1) NOT NULL Veteran Status Match Flag
364 SCC_SFP_DOD_MTCH Character(1) VARCHAR2(1) NOT NULL Dept of Defense Match
365 SCC_SFP_DOD_PARENT Date(10) DATE DOD Parent Date of Death
366 SCC_SFP_IWD_COMCDS Character(60) VARCHAR2(60) NOT NULL Comment Codes
367 SCC_SFP_COMCDS_2 Character(60) VARCHAR2(60) NOT NULL Comment Codes
368 SCC_SFP_COMCDS_3 Character(60) VARCHAR2(60) NOT NULL Comment Codes
369 SCC_SFP_COMCDS_4 Character(60) VARCHAR2(60) NOT NULL Comment Codes
370 SCC_SFP_COMCDS_5 Character(60) VARCHAR2(60) NOT NULL Comment Codes
371 SCC_SFP_COMCDS_6 Character(60) VARCHAR2(60) NOT NULL Comment Codes
372 SCC_SFP_COMCDS_7 Character(60) VARCHAR2(60) NOT NULL Comment Codes
373 SCC_SFP_COMCDS_8 Character(60) VARCHAR2(60) NOT NULL Comment Codes
374 SCC_SFP_COMCDS_9 Character(60) VARCHAR2(60) NOT NULL Comment Codes
375 SCC_SFP_COMCDS_10 Character(60) VARCHAR2(60) NOT NULL Comment Codes
376 SCC_SFP_COMCDS_11 Character(60) VARCHAR2(60) NOT NULL Comment Codes
377 SCC_SFP_COMCDS_12 Character(60) VARCHAR2(60) NOT NULL Comment Codes
378 SCC_SFP_COMCDS_13 Character(60) VARCHAR2(60) NOT NULL Comment Codes
379 SCC_SFP_COMCDS_14 Character(60) VARCHAR2(60) NOT NULL Comment Codes
380 SCC_SFP_COMCDS_15 Character(60) VARCHAR2(60) NOT NULL Comment Codes
381 SCC_SFP_COMCDS_16 Character(60) VARCHAR2(60) NOT NULL Comment Codes
382 SCC_SFP_COMCDS_17 Character(60) VARCHAR2(60) NOT NULL Comment Codes
383 SCC_SFP_COMCDS_18 Character(60) VARCHAR2(60) NOT NULL Comment Codes
384 SCC_SFP_COMCDS_19 Character(60) VARCHAR2(60) NOT NULL Comment Codes
385 SCC_SFP_COMCDS_20 Character(60) VARCHAR2(60) NOT NULL Comment Codes
386 SCC_SFP_ELE_INSIND Character(1) VARCHAR2(1) NOT NULL Electronic Institution Ind
387 SCC_SFP_ISIR_ETI Character(1) VARCHAR2(1) NOT NULL ISIR Elec Trans Indicator
388 SCC_SFP_MULTINST1 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 1
389 SCC_SFP_MULTINST2 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 2
390 SCC_SFP_MULTINST3 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 3
391 SCC_SFP_MULTINST4 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 4
392 SCC_SFP_MULTINST5 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 5
393 SCC_SFP_MULTINST6 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 6
394 SCC_SFP_MULTINST7 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 7
395 SCC_SFP_MULTINST8 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 8
396 SCC_SFP_MULTINST9 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 9
397 SCC_SFP_MULTINST10 Character(1) VARCHAR2(1) NOT NULL Multiple Institution Flag 10
398 SCC_SFP_VRFYTRKFLG Character(4) VARCHAR2(4) NOT NULL Verification Tracking Flag
399 SCC_SFP_VRFY_SELEC Character(1) VARCHAR2(1) NOT NULL Verification Select/Tracking
400 SCC_SFP_TCH_OVRPAY Character(1) VARCHAR2(1) NOT NULL TEACH Overpayment
401 SCC_SFP_TCH_CNTCT Character(8) VARCHAR2(8) NOT NULL TEACH Overpayment Contact
402 SCC_SFP_IASG_OVPAY Character(1) VARCHAR2(1) NOT NULL NSLDS IASA Overpayment
403 SCC_SFP_IASG_CNTCT Character(8) VARCHAR2(8) NOT NULL NSLDS IASA Overpayment Contact
404 SCC_SFP_FRAUD_FLG Character(1) VARCHAR2(1) NOT NULL Fraud Flag
405 SCC_SFP_LNCNVFLG Character(1) VARCHAR2(1) NOT NULL TEACH Grant Loan Conv
406 SCC_SFP_TCH_LN_BAL Signed Number(18,2) DECIMAL(16,2) NOT NULL Loan Principal Balance
407 SCC_SFP_AGSUBCDTOT Signed Number(18,2) DECIMAL(16,2) NOT NULL Aggregate Subsidized Total
408 SCC_SFP_AGUSBCDTOT Signed Number(18,2) DECIMAL(16,2) NOT NULL Aggregate Unsubsidized Total
409 SCC_SFP_TCHLNTOT Signed Number(18,2) DECIMAL(16,2) NOT NULL Loan Total
410 SCC_SFP_TCHUGRDAMT Signed Number(18,2) DECIMAL(16,2) NOT NULL UG Disbursement Amount
411 SCC_SFP_TCHGRADAMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Graduate Disbursement Amount
412 SCC_SFP_TCH_LNCNV Character(1) VARCHAR2(1) NOT NULL NSLDS TEACH Grant to Loan Chg
413 SCC_SFP_TCH_GRNT Character(1) VARCHAR2(1) NOT NULL TEACH Grant Change Flag
414 SCC_SFP_TCHADDGRNT Character(1) VARCHAR2(1) NOT NULL Additional TEACH Grant
415 SCC_SFP_DL_MPN_FLG Character(1) VARCHAR2(1) NOT NULL DL Master-Prom Note Flag
416 SCC_SFP_GPLUSMPN Character(1) VARCHAR2(1) NOT NULL DL GradPlus MPN Flag
417 SCC_SFP_ISIR_SBLMT Character(1) VARCHAR2(1) NOT NULL ISIR Sub Limit Flag
418 SCC_SFP_ISIRCMBLMT Character(1) VARCHAR2(1) NOT NULL ISIR Combo Limit Flag
419 SCC_SFP_LIFETMELG Number(8,5) DECIMAL(7,5) NOT NULL Lifetime Eligibility Used
420 SCC_SFP_TCH_SEQ1 Character(2) VARCHAR2(2) NOT NULL TEACH Sequence Num (1)
421 SCC_SFP_TCHSCHLCD1 Character(8) VARCHAR2(8) NOT NULL TEACH School Code
422 SCC_SFP_TCH_TRNBR1 Character(2) VARCHAR2(2) NOT NULL TEACH Transaction Num (1)
423 SCC_SFP_TCH_LSTUP1 Date(10) DATE TEACH Last Update Date (1)
424 SCC_SFP_TCH_SCAMT1 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Sched Award Amount (1)
425 SCC_SFP_TCH_AMTPD1 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Amount Paid (1)
426 SCC_SFP_TCH_AWDAT1 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Award Amount (1)
427 SCC_SFP_TCH_SCHYR1 Character(1) VARCHAR2(1) NOT NULL TEACH Academic Year Level (1)
428 SCC_SFP_TCH_SEQCD1 Character(3) VARCHAR2(3) NOT NULL TEACH COD Sequence Code (1)
429 SCC_SFP_TCH_AWDYR1 Character(4) VARCHAR2(4) NOT NULL TEACH Award Year (1)
430 SCC_SFP_TCH_LNCNV1 Character(1) VARCHAR2(1) NOT NULL TEACH Loan Conversion (1)
431 SCC_SFP_TCH_SEQ2 Character(2) VARCHAR2(2) NOT NULL TEACH Sequence Num (2)
432 SCC_SFP_TCHSCHLCD2 Character(8) VARCHAR2(8) NOT NULL TEACH School Code (2)
433 SCC_SFP_TCH_TRNBR2 Character(2) VARCHAR2(2) NOT NULL TEACH Transaction Num (2)
434 SCC_SFP_TCH_LSTUP2 Date(10) DATE TEACH Last Update Date (2)
435 SCC_SFP_TCH_SCAMT2 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Sched Award Amount (2)
436 SCC_SFP_TCH_AMTPD2 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Amount Paid (2)
437 SCC_SFP_TCH_AWDAT2 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Award Amount (2)
438 SCC_SFP_TCH_SCHYR2 Character(1) VARCHAR2(1) NOT NULL TEACH Academic Year Level (2)
439 SCC_SFP_TCH_SEQCD2 Character(3) VARCHAR2(3) NOT NULL TEACH COD Sequence Code (2)
440 SCC_SFP_TCH_AWDYR2 Character(4) VARCHAR2(4) NOT NULL TEACH Award Year (2)
441 SCC_SFP_TCH_LNCNV2 Character(1) VARCHAR2(1) NOT NULL TEACH Loan Conversion (2)
442 SCC_SFP_TCH_SEQ3 Character(2) VARCHAR2(2) NOT NULL TEACH Sequence Num (3)
443 SCC_SFP_TCHSCHLCD3 Character(8) VARCHAR2(8) NOT NULL TEACH School Code (3)
444 SCC_SFP_TCH_TRNBR3 Character(2) VARCHAR2(2) NOT NULL TEACH Transaction Num (3)
445 SCC_SFP_TCH_LSTUP3 Date(10) DATE TEACH Last Update Date (3)
446 SCC_SFP_TCH_SCAMT3 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Schdul Award Amount (3)
447 SCC_SFP_TCH_AMTPD3 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Amount Paid (3)
448 SCC_SFP_TCH_AWDAT3 Signed Number(18,2) DECIMAL(16,2) NOT NULL TEACH Award Amount (3)
449 SCC_SFP_TCH_SCHYR3 Character(1) VARCHAR2(1) NOT NULL TEACH Academic Year Level (3)
450 SCC_SFP_TCH_SEQCD3 Character(3) VARCHAR2(3) NOT NULL TEACH COD Sequence Code (3)
451 SCC_SFP_TCH_AWDYR3 Character(4) VARCHAR2(4) NOT NULL TEACH Award Year (3)
452 SCC_SFP_TCH_LNCNV3 Character(1) VARCHAR2(1) NOT NULL TEACH Loan Conversion (3)
453 SCC_SFP_PAR_CASH2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Cash and Savings
454 SCC_SFP_PAR_BUS_W2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Business Net Worth
455 SCC_SFP_SEC_PC2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Parent Contribution
456 SCC_SFP_SEC_STI2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Stu Total Income
457 SCC_SFP_SEC_SATI2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Stu All vs TI
458 SCC_SFP_SEC_SIC2 Number(17,2) DECIMAL(16,2) NOT NULL Secondary Stu Ind Dep IC
459 SCC_SFP_SEC_SDNW2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary Stu DNW
460 SCC_SFP_SEC_SCA2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Sec Stdnt Contrib from Assets
461 SCC_SFP_SEC_FTI2 Signed Number(18,2) DECIMAL(16,2) NOT NULL Secondary FISAP Total Inc
462 SCC_SFP_INCAR_FLAG Character(1) VARCHAR2(1) NOT NULL Incarcerated Applicant
1=Correctional Facility Address
2=Received via PO Box at IDC
3=Incarcerated Flag set in FAA
4=Incarcerated Flag removed
463 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
464 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
465 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
466 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time