| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
STUDENT_AID
|
| 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 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 5 |
RELATIONSHIP_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Relationship Nbr
Prompt Table:
RELATIONSHIPS
|
| 6 |
GUARDIAN_RELATIONS |
Character(2) |
VARCHAR2(2) NOT NULL |
Guardian Relationship
LG=Legal Guardian
NA=Not Applicable
OT=Other
PG=Parent Guardian
SG=Self Guardian
XG=Primary Guardian
|
| 7 |
NUM_FAMILY_MEMBERS |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr in Family
|
| 8 |
OR_FAMILY_MEMBERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Family Members
Y/N Table Edit
Default Value: N
|
| 9 |
NUMBER_IN_COLLEGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr in College
|
| 10 |
OR_NUM_COLLEGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Number in College
Y/N Table Edit
Default Value: N
|
| 11 |
DEPENDENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependents Other Than Spouse
1=Yes
2=No
N=No
Y=Yes
|
| 12 |
TAX_FORM_FILED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Form Filed
1=Completed 1040A/EZ
2=Completed 1040
3=Estimated 1040A/EZ
4=Estimated 1040
5=Will Not File
|
| 13 |
TAX_FILING_STAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Tax Form Filing Status
HH=Head of Household
MJ=Married, Filing Jointly
MS=Married, Filing Separately
QW=Qualified Widower
S=Single
|
| 14 |
AGI |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Adjusted Gross Income
|
| 15 |
WAGES |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Wages
|
| 16 |
INTEREST_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Interest Income
|
| 17 |
DIVIDEND_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Dividend Income
|
| 18 |
OTHER_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Other Taxed Income
|
| 19 |
INCOME_ADJUSTMENTS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Income Adjustments
|
| 20 |
CHILD_SUPPORT |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Child Support
|
| 21 |
SOC_SEC_BENEFITS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
SS Benefits
|
| 22 |
AFDC_BENEFITS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
AFDC Benefits
|
| 23 |
IRA_PAYMENTS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
IRA/KEOGH Payments
|
| 24 |
PENSION_PMTS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Pension Payments Received
|
| 25 |
MED_DEP_PMTS |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Tax-deferred Med/Dep Care Pmts
|
| 26 |
EIC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Earned Income Credit
|
| 27 |
NONTAX_EIC |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Nontaxable Earned Income
|
| 28 |
UNTAX_INTEREST |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tax Exempt Interest Income
|
| 29 |
FOREIGN_INC_EXCL |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Foreign Income Exclusions
|
| 30 |
OTHER_UNTAX_INC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Other Untaxed
|
| 31 |
TAXES_PAID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
U.S. Tax Paid
|
| 32 |
LIVING_ALLOWANCE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Living Allowance
|
| 33 |
CHILD_SUP_PAID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Child Support Paid
|
| 34 |
FINANCIAL_AID_INC |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Financial Aid Reported Income
|
| 35 |
TAX_WITHHELD |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Taxes Withheld
|
| 36 |
ALIMONY |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Alimony Income
|
| 37 |
BUSINESS_INC_LOSS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Business Income/Loss
|
| 38 |
CAPITAL_GAINS_LOSS |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Capital Gains/Loss
|
| 39 |
OTHER_GAIN_LOSS |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Other Gains/Losses
|
| 40 |
TAXED_IRA |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Taxable IRA/Keogh
|
| 41 |
TAXED_PENSION |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Taxed Pension
|
| 42 |
RENTAL_INCOME |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Rental Income, Trusts
|
| 43 |
FARM_INC |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Farm Income/Losses
|
| 44 |
UNEMPLOYMENT_BNFTS |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Unemployment Benefits
|
| 45 |
TAXED_SS_BNFT |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Taxed Social Security Benefits
|
| 46 |
FILERS_IRA_DEDCTN |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Filer's IRA deduction
|
| 47 |
SPOUSE_IRA_DEDCTN |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Spouse's IRA Deduction
|
| 48 |
ESTM_PYMNT_APPLD |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Estimated Tax Pymnt/Applied
|
| 49 |
TOT_PYMNTS |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Total Payments
|
| 50 |
TOT_PYMNTS_1040 |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Total Payments - 1040
|
| 51 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 52 |
ITEMIZED_DEDUCTION |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Itemized Deductions
|
| 53 |
CREDIT_DEPENDENT |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Credit for dependent expense
|
| 54 |
CREDIT_ELDERLY |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
24b Credit for the elderly
|
| 55 |
CREDIT_CHILD_TAX |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Child tax credit
|
| 56 |
CREDIT_EDUCATION |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Education credit
|
| 57 |
CREDIT_TOTAL |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Total Credits
|
| 58 |
HOUSEHOLD_EMP_TAX |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
27 Household EmploymentTaxes
|
| 59 |
HALF_SELF_EMP_TAX |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
25 One-Half of Self-Emp Tax
|
| 60 |
SELF_EMP_TAX |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
45 Self-Employment Tax
|
| 61 |
INAS_RELAT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Inas Relationship Code
1=Parent 1
2=Parent 2
3=NC/Other/Step Parent
F=Father
M=Mother
N=None
O=Other Parent/Step Parent
P=Spouse
S=Student
Default Value: S
|
| 62 |
INAS_TAX_CONSL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Inas Tax Consolidation Code
N=Tax Data Not Consolidated
Y=Tax Data Consolidated
Y/N Table Edit
Default Value: N
|
| 63 |
NBR_EXEMPTIONS |
Number(2,0) |
SMALLINT NOT NULL |
Number of exemptions
|
| 64 |
TOTAL_TAX |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tax
|
| 65 |
OTHER_PYMNTS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Other Payments
|
| 66 |
STU_LOAN_INT_DED |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Student loan interest
|
| 67 |
KEOGH_SEP_DED |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Keogh and Self-Empl Plans Ded
|
| 68 |
WAGE_INCOME_FATHER |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wage Income Father
|
| 69 |
WAGE_INCOME_MOTHER |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wage Income-Mother
|
| 70 |
WAGE_INCOME_SPS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wage Income Spouse
|
| 71 |
WAGE_INCOME_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wage Income-Student
|
| 72 |
TOTAL_FROM_WKA |
Number(5,0) |
INTEGER NOT NULL |
Total Amount from WK A
|
| 73 |
TOTAL_FROM_WKA_P |
Number(5,0) |
INTEGER NOT NULL |
Total Amount from WK A
|
| 74 |
ELIG_FOR_1040A_EZ |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible For 1040A or 1040EZ
1=Yes
2=No/Don't Know
|
| 75 |
ELIG_FOR_1040AEZ_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible For 1040A or 1040EZ?
1=Yes
2=No/Don't Know
|
| 76 |
TAX_FORM_FILED00 |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Form Filed 2000
1=IRS 1040
2=IRS 1040A/EZ/Telefile
3=Foreign Tax Return
4=U.S. Territory Tax Return
|
| 77 |
UNTAXED_IRA_BEN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Untaxed IRA Distributions
|
| 78 |
UNTAXED_PENSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Untaxed Pension
|
| 79 |
UNTAXED_SS_BEN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Untaxed SS Benefits
|
| 80 |
UNTAXED_INC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Untaxed Income
|
| 81 |
MARITAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
1=Single
2=Married
3=Separated
4=Divorced
5=Widowed
|
| 82 |
TOTAL_OTHER_INCOME |
Signed Number(13,0) |
DECIMAL(12) NOT NULL |
Total Other Income
|
| 83 |
PRETAX_PAYMENTS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tax-deferred Pension/Savings
|
| 84 |
TAXABLE_INCOME |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Taxable Income
|
| 85 |
OTHER_CREDITS_WKA |
Number(5,0) |
INTEGER NOT NULL |
Other Credits & Benefits
|
| 86 |
TOTAL_FROM_WS3 |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Total from Worksheet 3
|
| 87 |
SPECIAL_PROCESSING |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Circumstances
1=Yes
N=No
Y=Yes
|
| 88 |
MED_SAVINGS_DEDCTN |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Medical savings acct deduction
|
| 89 |
MOVING_EXPENSE |
Number(6,0) |
INTEGER NOT NULL |
Moving expenses
|
| 90 |
WD_SAVINGS_PENALTY |
Number(6,0) |
INTEGER NOT NULL |
Penalty on early w/d of Saving
|
| 91 |
ALIMONY_PAID |
Number(6,0) |
INTEGER NOT NULL |
Alimony paid
|
| 92 |
SE_HEALTH_INS_DED |
Number(6,0) |
INTEGER NOT NULL |
SE health insurance deduction
|
| 93 |
CREDIT_ADOPTION |
Number(6,0) |
INTEGER NOT NULL |
Adoption credit
|
| 94 |
CREDIT_FOREIGN_TAX |
Number(6,0) |
INTEGER NOT NULL |
Foreign tax credit
|
| 95 |
CREDIT_OTHER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Other credits
|
| 96 |
ALT_MIN_TAX |
Number(6,0) |
INTEGER NOT NULL |
Alternative minimum tax
|
| 97 |
CREDIT_CHILD_OTHER |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Additional Child Tax Credit
|
| 98 |
TOTAL_FROM_WKC |
Number(8,0) |
INTEGER NOT NULL |
Total Amount from WK C
|
| 99 |
TAX_RETURN_FILED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Return Filed?
1=Already Filed/Completed
2=Will File
3=Will Not File
|
| 100 |
ADD_BUSINESS_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to Total Wages
Y/N Table Edit
Default Value: N
|
| 101 |
ADD_FARM_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to Total Wages
Y/N Table Edit
Default Value: N
|
| 102 |
TAXABLE_REFUND |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Taxable Refund
|
| 103 |
OTHER_TAXABLE_INC |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Other Taxable Income
|
| 104 |
RATE_REDUX_CREDIT |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Rate reduction credit
|
| 105 |
FOREIGN_INC_EXCL04 |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Replaces FOREIGN_INC_EXCL in INST_PARENT as of AY 2003/04. The reason is byte size increased from 6 to 7.
|
| 106 |
OTHER_UNTAX_INC_04 |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Replaces OTHER_UNTAX_INC on INST_PARENT as of 2003/04. The reason is that the byte size increased from 6 to 7.
|
| 107 |
CREDIT_RETIREMENT |
Number(6,0) |
INTEGER NOT NULL |
Retirement savings credit
|
| 108 |
CREDIT_FROM_FORMS |
Number(6,0) |
INTEGER NOT NULL |
Credit from Forms 8396/8859
|
| 109 |
EDUCATOR_EXP_DED |
Number(6,0) |
INTEGER NOT NULL |
Educator expenses
|
| 110 |
TUITION_FEE_DED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tuition and fees deduction
|
| 111 |
SFA_BUS_EXP_DED |
Number(6,0) |
INTEGER NOT NULL |
Certain business expenses
|
| 112 |
SFA_DMSTC_PROD_DED |
Number(6,0) |
INTEGER NOT NULL |
Domestic production activities
|
| 113 |
SFA_INTERST_INC |
Number(6,0) |
INTEGER NOT NULL |
Interest Income
|
| 114 |
SFA_IRA_UNEMP_BEN |
Number(6,0) |
INTEGER NOT NULL |
Unemployment Benefits
|
| 115 |
SFA_OTH_UREP_MONEY |
Number(7,0) |
INTEGER NOT NULL |
Other Non-Reported Money
|
| 116 |
SFA_TAX_GRANT_AID |
Number(7,0) |
INTEGER NOT NULL |
Grant/Scholarship Aid
|
| 117 |
SFA_TAX_WORK_STUD |
Number(7,0) |
INTEGER NOT NULL |
Taxed Work-Study/Fellow/Assist
|
| 118 |
SFA_UNTA_COMBATPAY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Combat Pay
|
| 119 |
SFA_VET_NONED_BENI |
Number(10,0) |
DECIMAL(10) NOT NULL |
Veterans Non-Ed Benefits
|
| 120 |
SFA_WORK_COMPENST |
Number(6,0) |
INTEGER NOT NULL |
Workers Compensation
|
| 121 |
SFA_VA_WORK_STUDY |
Number(6,0) |
INTEGER NOT NULL |
VA Work-Study
|
| 122 |
SFA_BLUNG_REFUGEE |
Number(6,0) |
INTEGER NOT NULL |
Black Lung/Refugee
|
| 123 |
SFA_FED_SPE_FULTAX |
Number(6,0) |
INTEGER NOT NULL |
Fed Special Fuel Tax
|
| 124 |
SFA_UNTX_RAIL_ROAD |
Number(6,0) |
INTEGER NOT NULL |
Untaxed Railroad Retirement
|
| 125 |
SFA_IRAKEO_SEP_DED |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Keogh and Self-Empl Plans Ded
|
| 126 |
SFA_FED_INST_INDI |
Character(1) |
VARCHAR2(1) NOT NULL |
Institution or Federal Indica
|
| 127 |
SFA_VER_FED_UNTINC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Other Untaxed Income
|
| 128 |
SFA_TAX_FIN_AID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Taxed Financial Aid
|
| 129 |
SFA_FED_UNTAXD_INC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Untaxed Income
|
| 130 |
SFA_INST_TOI |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Other Income
|
| 131 |
SFA_INST_UNTAX_INC |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Other Untaxed Income
|
| 132 |
SFA_FED_FIWC_TOT |
Signed Number(10,0) |
DECIMAL(9) NOT NULL |
Total Fed Untax Variance
|
| 133 |
SFA_COOP_EARN |
Number(7,0) |
INTEGER NOT NULL |
Co-op Earnings
|
| 134 |
SFA_IM_UNTAX_INC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Other Untaxed Income
|
| 135 |
SFA_VER_LIV_ALLOW |
Number(10,0) |
DECIMAL(10) NOT NULL |
Living Allowance
|
| 136 |
SFA_FAM_SUP_INC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Family Support Income
|
| 137 |
SFA_VER_MIL_ALLOW |
Number(10,0) |
DECIMAL(10) NOT NULL |
Military Allowance
|
| 138 |
SFA_VER_TCONSL_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Consolidation Type
1=Federal
2=Institutional
|
| 139 |
SFA_VE_VA_NOEDBEN |
Number(5,0) |
INTEGER NOT NULL |
Vet Other Benefits
|
| 140 |
SFA_SSI_INCOME |
Character(1) |
VARCHAR2(1) NOT NULL |
Receives SSI Income
1=Yes
2=No
|
| 141 |
SFA_FOOD_STAMPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Receives Food Stamps
1=Yes
2=No
|
| 142 |
SFA_SCHL_LUNCH_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Participates in Sch Lunch Prog
1=Yes
2=No
|
| 143 |
SFA_TANF_BENEFITS |
Character(1) |
VARCHAR2(1) NOT NULL |
TANF Recipient
1=Yes
2=No
|
| 144 |
SFA_WIC_BENEFITS |
Character(1) |
VARCHAR2(1) NOT NULL |
WIC Benefits Recipient
1=Yes
2=No
|
| 145 |
SFA_VER_FSA_DEPCAE |
Number(10,0) |
DECIMAL(10) NOT NULL |
FSA Dependent Care
|
| 146 |
SFA_VER_FSA_HLTCRE |
Number(10,0) |
DECIMAL(10) NOT NULL |
FSA Health Care
|
| 147 |
SFA_VER_HTHSAVACNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Health Savings Account
|
| 148 |
SFA_PF_RECV_SSI |
Character(1) |
VARCHAR2(1) NOT NULL |
Received SSI
N=No
Y=Yes
|
| 149 |
SFA_PF_FOOD_STAMPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Food Stamps
N=No
Y=Yes
|
| 150 |
SFA_PF_FREE_LUNCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Free Lunch
N=No
Y=Yes
|
| 151 |
SFA_PF_RCVD_TANF |
Character(1) |
VARCHAR2(1) NOT NULL |
Received TANF
N=No
Y=Yes
|
| 152 |
SFA_PF_RCVD_WIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Received WIC
N=No
Y=Yes
|
| 153 |
SFA_PF_ADD_MED_TAX |
Number(10,0) |
DECIMAL(10) NOT NULL |
Additional Medicare Tax
|
| 154 |
SFA_PF_HSA_TAXCONT |
Number(10,0) |
DECIMAL(10) NOT NULL |
HSA Pre Tax Contribution
|
| 155 |
SFA_VER_TAX_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Return Filing Status Added for regs1 1415
1=Single
2=Married-Joint
3=Married-Separate
4=Head of Household
5=Widow(er)
6=Don't Know
|
| 156 |
SFA_VER_CHSUP_RECV |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Child Support
|
| 157 |
SFA_VER_FED_AFT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Total Amount from WK C
|
| 158 |
SFA_VER_PG_MALL_15 |
Character(2) |
VARCHAR2(2) NOT NULL |
Used in Profile to display new translate values for 2012
1=Never Married
10=Unmarried
2=Single
3=Married
4=Remarried
5=Married/Remarried
6=Divorced
7=Separated
8=Divorced/Separated
9=Widowed
|
| 159 |
SFA_VER_DIS_WRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Dislocated Worker?
N=No
Y=Yes
|
| 160 |
SFA_VER_HOMELESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Homeless?
N=No
Y=Yes
|
| 161 |
SFA_VER_ORPHANFOST |
Character(1) |
VARCHAR2(1) NOT NULL |
Orphan/Foster/Ward
N=No
Y=Yes
|
| 162 |
SFA_PF_UPD_BOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Upward Bound
N=No
Y=Yes
|
| 163 |
SFA_VER_TTLC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Line 56 Tax Total less Credits
|
| 164 |
SFA_VER_TOTTAX |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Line 63 Total Tax
|
| 165 |
SFA_VER_TOTPAY |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Line 74 Total Payments
|
| 166 |
SFA_VER_OPMT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Line 56 Tax Total less Credits
|
| 167 |
SFA_VER_AMT_OWE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Line 56 Tax Total less Credits
|
| 168 |
SFA_VER_EFMCORWARD |
Character(1) |
VARCHAR2(1) NOT NULL |
EFM Comp OrphanWard Foster Ind
N=No
Y=Yes
|
| 169 |
SFA_VER_DEPENDENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependents Other Than Spouse
1=Yes
2=No
N=No
Y=Yes
|
| 170 |
SFA_VER_VETERAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran
1=Yes
2=No
N=No
Y=Yes
|
| 171 |
SFA_VER_RCVD_MEAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Medicaid
N=No
Y=Yes
|
| 172 |
SFA_VER_CHDSUPRECP |
Number(10,0) |
DECIMAL(10) NOT NULL |
Child Support Received Student
|
| 173 |
SFA_VER_ALMPD_NC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Alimony Paid
|
| 174 |
SFA_VER_CHDSUP_NC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Child Support Paid For Student
|
| 175 |
SFA_1040_SCHEDULE |
Character(1) |
VARCHAR2(1) NOT NULL |
1040 Schedule 1 Filed
1=No
2=Yes
3=Dont Know
|
| 176 |
SFA_QUAL_INC_DED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Qualified Income Deduction
|
| 177 |
SFA_VER_ORD_DIVINC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Ordinary Dividend Income
|
| 178 |
SFA_STD_1040 |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filed 1040 or 1040NR
1=Yes
2=No
|
| 179 |
SFA_STD_NON_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filed Non-U.S. Tax Return
1=Yes
2=No
|
| 180 |
SFA_STD_JOINT_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Filed Joint Return with Current Spouse
1=Yes
2=No
|
| 181 |
SFA_STD_TAX_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: Student Tax Return Filing Status
1=Yes
2=No
|
| 182 |
CHILDREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Have Children you support
1=Yes
2=No
|
| 183 |
SFA_FED_TAX1 |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
2425:Foreign Income Exempt from Federal Taxation
|
| 184 |
SFA_STD_FED_NONE |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Federal Benefits: None of the Above�
1=Yes
|
| 185 |
SFA_STD_ETIC |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Received EITC
1=Yes
|
| 186 |
SFA_STD_HOUSING |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Received Federal Housing Assistance
1=Yes
|
| 187 |
SFA_STD_MEDICAID |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Received Medicaid
1=Yes
|
| 188 |
SFA_STD_36B |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Received Refundable Credit for 36B Health Plan
1=Yes
|