| # |
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
|
| 4 |
NUMBER_IN_COLL_STU |
Character(2) |
VARCHAR2(2) NOT NULL |
Number In College
|
| 5 |
NUMBER_IN_COLL_PAR |
Character(2) |
VARCHAR2(2) NOT NULL |
Number In College
|
| 6 |
NBR_FMLY_MBRS_STU |
Character(2) |
VARCHAR2(2) NOT NULL |
Number of Family Members
|
| 7 |
NBR_FMLY_MBRS_PAR |
Character(2) |
VARCHAR2(2) NOT NULL |
Number of Family Members
|
| 8 |
NBR_EXEMPT_STU |
Character(2) |
VARCHAR2(2) NOT NULL |
Number of Exemptions
|
| 9 |
NBR_EXEMPT_PAR |
Character(2) |
VARCHAR2(2) NOT NULL |
Number of Exemptions
|
| 10 |
AGI_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
AGI-Student
|
| 11 |
AGI_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
AGI-Parent
|
| 12 |
TAXES_PD_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Taxes Paid by the Student
|
| 13 |
TAXES_PD_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Taxes Paid by the Parent
|
| 14 |
WAGE_INCOME_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wage Income-Student
|
| 15 |
WAGE_INCOME_FATHER |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wage Income Father
|
| 16 |
WAGE_INCOME_SPS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wage Income Spouse
|
| 17 |
WAGE_INCOME_MOTHER |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wage Income-Mother
|
| 18 |
SS_BENEFIT_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Social Security Benefits Stu
|
| 19 |
SS_BENEFIT_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Social Security Benefit Par
|
| 20 |
AFDC_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
AFDC Benefits
|
| 21 |
AFDC_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
AFDC Benefits
|
| 22 |
CHILD_SUP_REC_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Child Support Received
|
| 23 |
CHILD_SUP_REC_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Child Support Received
|
| 24 |
OTHR_UTAX_INC_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Other Untaxed Income
|
| 25 |
OTHR_UTAX_INC_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Other Untaxed Income
|
| 26 |
WS3_STU |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Total from WK B
|
| 27 |
WS3_PAR |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Total from WK B
|
| 28 |
MARITAL_STAT_STU |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status-Student
|
| 29 |
MARITAL_STAT_PAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status-Parents
1=Single
2=Married
3=Separated
4=Divorced
5=Widowed
6=Never Married
|
| 30 |
TAX_FORM_STU |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Form-Student
|
| 31 |
TAX_FORM_PAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Form-Parents
|
| 32 |
EIC_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Earned Income Credit
|
| 33 |
EIC_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Earned Income Credit
|
| 34 |
TOTAL_FROM_WKA |
Number(5,0) |
INTEGER NOT NULL |
Total Amount from WK A
|
| 35 |
TOTAL_FROM_WKA_P |
Number(5,0) |
INTEGER NOT NULL |
Total Amount from WK A
|
| 36 |
SPECIAL_PROCESSING |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Circumstances
1=Yes
N=No
Y=Yes
|
| 37 |
FOREIGN_EXCL_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Foreign Income Exclusions
|
| 38 |
FOREIGN_EXCL_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Foreign Income Exclusions
|
| 39 |
IRA_KEOGH_DED_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
IRA/KEOGH Deduction
|
| 40 |
IRA_KEOGH_DED_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
IRA/KEOGH Deduction
|
| 41 |
LIVING_ALWNC_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Living Allowance
|
| 42 |
LIVING_ALWNC_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Living Allowance
|
| 43 |
MED_DEP_PMTS_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tax-deferred Med/Dep Care Pmts
|
| 44 |
MED_DEP_PMTS_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tax-deferred Med/Dep Care Pmts
|
| 45 |
PRETAX_PMNT_PAR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tax-deferred Pension/Savings
|
| 46 |
PRETAX_PMNT_STU |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tax-deferred Pension/Savings
|
| 47 |
UNTAX_INTEREST_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tax Exempt Interest Income
|
| 48 |
UNTAX_INTEREST_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tax Exempt Interest Income
|
| 49 |
TOTAL_FROM_WKC |
Number(8,0) |
INTEGER NOT NULL |
Total Amount from WK C
|
| 50 |
TOTAL_FROM_WKC_P |
Number(5,0) |
INTEGER NOT NULL |
Total Amount from WK C
|
| 51 |
TAX_RETURN_FILED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Return Filed?
1=Already Filed/Completed
2=Will File
3=Will Not File
|
| 52 |
TAX_RETURN_FILED_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Return Filed?
1=Already Filed/Completed
2=Will File
3=Will Not File
|
| 53 |
ELIG_FOR_1040A_EZ |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible For 1040A or 1040EZ
1=Yes
2=No/Don't Know
|
| 54 |
ELIG_FOR_1040AEZ_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible For 1040A or 1040EZ?
1=Yes
2=No/Don't Know
|
| 55 |
DIVID_INT_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Dividend and Interest Income
|
| 56 |
DIVIDEND_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Dividend Income
|
| 57 |
INTEREST_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Interest Income
|
| 58 |
ITEMIZED_DEDCTN_S |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Itemized Deductions
|
| 59 |
ITEMIZED_DEDCTN_P |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Itemized Deductions
|
| 60 |
DEPENDENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependents Other Than Spouse
1=Yes
2=No
N=No
Y=Yes
|
| 61 |
INCOME_ADJUSTMENTS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Income Adjustments
|
| 62 |
NET_INC_BUS_FARM |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Bus/Farm Income
|
| 63 |
CHILD_SUPPORT |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Child Support
|
| 64 |
CHILD_SUPPORT_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Parent's Child Support
|
| 65 |
OTHER_TAXABLE_INC |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Other Taxable Income
|
| 66 |
WAGES_SAL_TIPS_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Wages, Salaries, & Tips
|
| 67 |
TUITION_FEE_DED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tuition and fees deduction
|
| 68 |
SFA_ED_CRE_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Education Credit
|
| 69 |
SFA_ED_CRE_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Education Credit
|
| 70 |
SFA_NONED_VET_STU |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Non-Ed Vet Benefit
|
| 71 |
SFA_NONED_VET_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Non-Ed Vet Benefit
|
| 72 |
SFA_OTH_UNREP_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Other Unreported Income
|
| 73 |
SFA_OTH_UNREP_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Other Unreported Income
|
| 74 |
SFA_UNTAX_IRA_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Untaxed IRA
|
| 75 |
SFA_UNTAX_IRA_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Untaxed IRA
|
| 76 |
SFA_UNTAX_PEN_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Untaxed Pension
|
| 77 |
SFA_UNTAX_PEN_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Untaxed Pension
|
| 78 |
SFA_COMBATPAY_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Combat Pay
|
| 79 |
SFA_COMBATPAY_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Combat Pay
|
| 80 |
SFA_TAX_WS_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tax Work-Study/Fellow/Assist
|
| 81 |
SFA_TAX_WS_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tax Work-Study/Fellow/Assist
|
| 82 |
SFA_GRANT_SCH_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Grant/Scholarship
|
| 83 |
SFA_GRANT_SCH_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Grant/Scholarship
|
| 84 |
SFA_TAX_FINAID_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Taxed Financial Aid
|
| 85 |
SFA_WORKCOMP_STU |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Workers Compensation
|
| 86 |
SFA_WORKCOMP_PAR |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Workers Compensation
|
| 87 |
SFA_COOP_EARN_STU |
Number(10,0) |
DECIMAL(10) NOT NULL |
Co-Operation Earnings
|
| 88 |
SFA_COOP_EARN_PAR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Co-Operation Earnings
|
| 89 |
SFA_ADDCHD_TAXCRE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Additional Child Tax Credit
|
| 90 |
SFA_FAMSUPINC_PAR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Family Support Income
|
| 91 |
SFA_IMUNTAINC_PAR |
Number(10,0) |
DECIMAL(10) NOT NULL |
IM Other Untaxed Income
|
| 92 |
SFA_LIV_ALLOW_PAR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Living Allowance
|
| 93 |
SFA_MIL_ALLOW_PAR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Military Allowance
|
| 94 |
SFA_VE_VA_NEDBE_PA |
Number(10,0) |
DECIMAL(10) NOT NULL |
Vet Other Benefits
|
| 95 |
SFA_SSI_INCOME_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Received SSI Income
1=Yes
2=No
N=No
Y=Yes
|
| 96 |
SFA_SSI_INCOME_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Received SSI Income
1=Yes
2=No
N=No
Y=Yes
|
| 97 |
SFA_FOOD_STAMPS_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Food Stamps
1=Yes
2=No
N=No
Y=Yes
|
| 98 |
SFA_FOOD_STAMPS_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Food Stamps
1=Yes
2=No
N=No
Y=Yes
|
| 99 |
SFA_SCH_LUN_PRG_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Free Lunch
1=Yes
2=No
N=No
Y=Yes
|
| 100 |
SFA_SCH_LUN_PRG_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Free Lunch
1=Yes
2=No
N=No
Y=Yes
|
| 101 |
SFA_TANF_BEN_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Received TANF
1=Yes
2=No
N=No
Y=Yes
|
| 102 |
SFA_TANF_BEN_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Received TANF
1=Yes
2=No
N=No
Y=Yes
|
| 103 |
SFA_WIC_BEN_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Received WIC
1=Yes
2=No
N=No
Y=Yes
|
| 104 |
SFA_WIC_BEN_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Received WIC
1=Yes
2=No
N=No
Y=Yes
|
| 105 |
SFA_VER_FDEPCAE_PR |
Number(10,0) |
DECIMAL(10) NOT NULL |
FSA Dependent Care
|
| 106 |
SFA_VER_FHLTCRE_PR |
Number(10,0) |
DECIMAL(10) NOT NULL |
FSA Health Care
|
| 107 |
SFA_VER_HSAVACC_PR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Health Savings Account
|
| 108 |
SFA_PF_ADD_MED_TAX |
Number(10,0) |
DECIMAL(10) NOT NULL |
Additional Medicare Tax
|
| 109 |
SFA_PF_HSA_TAXCONT |
Number(10,0) |
DECIMAL(10) NOT NULL |
HSA Pre Tax Contribution
|
| 110 |
SFA_VER_TAX_RET_FS |
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
|
| 111 |
SFA_VER_TAX_RET_FP |
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
|
| 112 |
SFA_VER_DIS_WRK_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Dislocated Worker?
N=No
Y=Yes
|
| 113 |
SFA_VER_DIS_WRK_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Dislocated Worker?
N=No
Y=Yes
|
| 114 |
SFA_VER_HOMELESS_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Homeless?
N=No
Y=Yes
|
| 115 |
SFA_VER_ORPFOST_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Orphan/Foster/Ward
N=No
Y=Yes
|
| 116 |
SFA_PF_UPD_BOUND_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Upward Bound
N=No
Y=Yes
|
| 117 |
SFA_VER_CHSUP_PD |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Child Support Paid
|
| 118 |
SFA_VER_EFMCORWD_S |
Character(1) |
VARCHAR2(1) NOT NULL |
EFM Comp OrphanWard Foster Ind
N=No
Y=Yes
|
| 119 |
SFA_VER_DEPENDTS_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependents Other Than Spouse
1=Yes
2=No
N=No
Y=Yes
|
| 120 |
SFA_VER_VETERAN_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran
1=Yes
2=No
N=No
Y=Yes
|
| 121 |
SFA_VER_RCVD_MAD_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Medicaid
N=No
Y=Yes
|
| 122 |
SFA_VER_RCVD_MD_NC |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Medicaid
N=No
Y=Yes
|
| 123 |
SFA_VER_CHDSU_C_NC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Child Support Paid For Student
|
| 124 |
SFA_VER_ALMPD_C_NC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Alimony Paid
|
| 125 |
SFA_QUAL_INC_DED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Qualified Income Deduction
|
| 126 |
SFA_1040_SCHEDUL_P |
Character(1) |
VARCHAR2(1) NOT NULL |
1040 Schedule 1 Filed
1=No
2=Yes
3=Dont Know
|