| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 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 |
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
Prompt Table:
INST_CONTROL
|
| 5 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 6 |
SA_APP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Aid Status
1=First-time App, New Student
2=Renewal App, Cont. Student
3=First-time App, Cont. Student
|
| 7 |
NUM_FAMILY_MEMBERS |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr in Family
|
| 8 |
NUMBER_IN_COLLEGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr in College
|
| 9 |
VETERAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran
1=Yes
2=No
N=No
Y=Yes
|
| 10 |
ORPHAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Orphan or Ward of the Court
1=Yes
2=No
N=No
Y=Yes
|
| 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 |
NUMBER_EXEMPTIONS |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr of Exemptions
00=00
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
1=1
10=10
11=11
12=12
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
?=?
Default Value: 00
|
| 14 |
AGI |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Adjusted Gross Income
|
| 15 |
TAXES_PAID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
U.S. Tax Paid
|
| 16 |
ITEMIZED_DEDUCTION |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Itemized Deductions
|
| 17 |
STD_EARNED_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Student's Earned Income
|
| 18 |
SPS_EARNED_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Spouse's Earned Income
|
| 19 |
DIVID_INT_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Dividend and Interest Income
|
| 20 |
SOC_SEC_BENEFITS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
SS Benefits
|
| 21 |
AFDC_BENEFITS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
AFDC Benefits
|
| 22 |
CHILD_SUPPORT_RCVD |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Child Supp Rec'd
|
| 23 |
EARNED_INC_CREDIT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Earned Income Credit
|
| 24 |
UNTAXED_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Untaxed Income
|
| 25 |
STU_AID_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Taxable Student Aid Income
|
| 26 |
CASH_SAVINGS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Cash Savings
|
| 27 |
IRA_VALUE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
IRA, Keogh, 401K Value
|
| 28 |
RE_INVEST_VALUE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Real Estate Invest Value
|
| 29 |
INVEST_VALUE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Investment Value
|
| 30 |
INVEST_DEBT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Investment Debt
|
| 31 |
RE_INVEST_DEBT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Real Estate Invest Debt
|
| 32 |
HOME_VALUE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Home Value
|
| 33 |
HOME_DEBT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Home Debt
|
| 34 |
BUS_FARM_VALUE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Business/Farm Value
|
| 35 |
BUS_FARM_DEBT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Business/Farm Debt
|
| 36 |
LIVE_ON_FARM |
Character(1) |
VARCHAR2(1) NOT NULL |
Reside on Farm
1=Yes
2=No
N=No
Y=Yes
|
| 37 |
HOME_PURCH_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Home Purchase Year
|
| 38 |
HOME_PURCH_PRICE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Home Purchase Price
|
| 39 |
TRUST_AMOUNT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Value of Trust Fund
|
| 40 |
TRUST_AVAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Trust Available
1=Yes
2=No
N=No
Y=Yes
|
| 41 |
TRUST_ESTABLISHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Trust Established by
1=Parents
2=Other
O=Other
P=Parents
|
| 42 |
CHILD_SUPPORT_PAID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Child Support Paid
|
| 43 |
MED_DENT_EXPENSES |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Medical/Dental
|
| 44 |
MONTHLY_VET_BEN |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Monthly Vet Edu Benefits
|
| 45 |
NUM_MONTH_VET_BEN |
Character(2) |
VARCHAR2(2) NOT NULL |
VA Ben Number of Months
|
| 46 |
SUMMER_WAGES |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Summer Wages
|
| 47 |
SCHOOL_YR_WAGES |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
School Year Wages
|
| 48 |
SPS_SUMM_WAGES |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Spouse's Summer Wages
|
| 49 |
SPS_SCH_YR_WAGES |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Spouses School Year Wages
|
| 50 |
SUMMER_OTH_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Summer Other Taxable Income
|
| 51 |
SCH_YR_OTH_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
School Year Other Income
|
| 52 |
SUMMER_UNTAXED |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Summer Untaxed Income
|
| 53 |
SCHOOL_YR_UNTAXED |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
School Year Untaxed Income
|
| 54 |
GRANT_SCHOLARSHIP |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Grant/Scholarship
|
| 55 |
TUITION_BENEFITS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Tuition Benefits
|
| 56 |
PARENTS_CONTRIB |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Parents Contribution
|
| 57 |
RELATIVES_CONTRIB |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Relative's Contributions
|
| 58 |
CURRENT_GRADE_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Current Grade Level
01=1st yr Never Attended
02=1st yr Attended Before
03=2nd yr Sophmore
04=3rd yr Junior
05=4th yr Senior
06=5th yr other UG
07=1st yr Grad/Prof
08=2nd yr Grad/Prof
09=3rd yr Grad/Prof
10=Beyond 3rd yr Grad/Prof
|
| 59 |
MARITAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
1=Single
2=Married
3=Separated
4=Divorced
5=Widowed
|
| 60 |
STATE_RESIDENCE |
Character(6) |
VARCHAR2(6) NOT NULL |
State of Residence
Prompt Table:
SFA_PF_2STCD_VW
|
| 61 |
HOPE_LL_CREDIT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Hope Lifetime Learning Credit
|
| 62 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 63 |
CHLD_NUM_AESA_CLC |
Character(1) |
VARCHAR2(1) NOT NULL |
Number Children Under 18
|
| 64 |
CHLD_AGES_CESA_CLC |
Character(3) |
VARCHAR2(3) NOT NULL |
Sum of Childrens Ages < 18
|
| 65 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 66 |
SFA_STU_LIVES_WITH |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Lives With
1=Father
2=Mother
3=Neither Parent
|
| 67 |
SFA_STU_MOST_SUPRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Most Support From
1=Father
2=Mother
|
| 68 |
SFA_FEE_WAIVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Fee Waiver
1=Yes
2=No
N=No
Y=Yes
|
| 69 |
TAX_FORM_FILED_07 |
Character(2) |
VARCHAR2(2) NOT NULL |
Tax Form Filed
01=Estimated 1040
02=Estimated 1040A
03=Estimated 1040EZ
04=Estimated Canadian
05=Estimated Puerto Rican
06=Estimated Other Non-US Return
07=Completed 1040
08=Completed 1040A
09=Completed 1040EZ
10=Completed Canadian
11=Completed Puerto Rican
12=Completed Other Non-US Return
13=Will Not File
|
| 70 |
SFA_TAX_FILED_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Filed Status
1=Completed
2=Will File but Not Completed
3=Will Not File Not Required to
|
| 71 |
SFA_MEANS_TSTD_BEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Means Tested Benefits
1=Yes
2=No
N=No
Y=Yes
|
| 72 |
SFA_EMPL_GT_100 |
Character(1) |
VARCHAR2(1) NOT NULL |
FTE Employees > 100
1=Yes
2=No
N=No
Y=Yes
|
| 73 |
SFA_SELF_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Self Employed
1=Yes
2=No
N=No
Y=Yes
|
| 74 |
SFA_LOWEST_INC_FLR |
Character(1) |
VARCHAR2(1) NOT NULL |
Lowest Income Filer
N=No
Y=Yes
|
| 75 |
LEGAL_RESIDENCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Legal Residence
Prompt Table:
SFA_PF_2STCD_VW
|
| 76 |
AP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
AP-Flag
Y=Yes
|
| 77 |
SFA_DISLOCATED_WRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Dislocated Worker?
Y/N Table Edit
|
| 78 |
SFA_ORPHANFOST |
Character(1) |
VARCHAR2(1) NOT NULL |
Orphan/Foster/Ward after 13?
Y/N Table Edit
|
| 79 |
SFA_HOMELESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Homeless?
Y/N Table Edit
|
| 80 |
SFA_COMBAT_PAY |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Combat Pay
|
| 81 |
SFA_PROF_CITZ_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reported Status
1=U.S CITIZEN
2=ELIG NON-CITIZEN
3=NEITHER
|
| 82 |
SFA_PROF_CITZ_CTRY |
Character(15) |
VARCHAR2(15) NOT NULL |
Reported Country
|
| 83 |
SFA_PF_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 84 |
SFA_PF_CURRENCY_RT |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Currency Rate
|
| 85 |
SFA_PF_CNTRY_COEFF |
Signed Number(10,7) |
DECIMAL(8,7) NOT NULL |
Country Coefficient
|
| 86 |
SFA_PF_CONV_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Converted Currency Code
|
| 87 |
SFA_PF_CONV_CUR_RT |
Signed Number(20,9) |
DECIMAL(18,9) NOT NULL |
Converted Currency Rate
|
| 88 |
SFA_PF_VA_BEN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
VA Benefits Received Code
1=GI Bill - Active Duty
2=Post-9/11 GI Bill
3=GI Bill - Selective Reserve
4=REAP
5=Voc Rehab and Employment
6=DEAP
7=Any other type of VA education
|
| 89 |
SFA_PF_RCV_TUITBEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Receive Tuition Benefits
1=Yes
2=No
N=No
Y=Yes
|
| 90 |
SFA_PF_GOV_SUPPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Government Support
1=Yes
2=No
N=No
Y=Yes
|
| 91 |
SFA_PF_AGENCY_SUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Agencies/ Foundation Support
1=Yes
2=No
N=No
Y=Yes
|
| 92 |
SFA_PF_FADDR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreign Address Indicator
|
| 93 |
SFA_PF_RECV_SSI |
Character(1) |
VARCHAR2(1) NOT NULL |
Received SSI
N=No
Y=Yes
|
| 94 |
SFA_PF_FOOD_STAMPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Food Stamps
N=No
Y=Yes
|
| 95 |
SFA_PF_FREE_LUNCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Free Lunch
N=No
Y=Yes
|
| 96 |
SFA_PF_RCVD_TANF |
Character(1) |
VARCHAR2(1) NOT NULL |
Received TANF
N=No
Y=Yes
|
| 97 |
SFA_PF_RCVD_WIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Received WIC
N=No
Y=Yes
|
| 98 |
SFA_PF_UPD_BOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Upward Bound
N=No
Y=Yes
|
| 99 |
SFA_PF_TX_FL_STA |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Filing Status Code
1=Single
2=Married filing jointly
3=Married filing separately
4=Head of Household
5=Qualifying widow with dep
|
| 100 |
SFA_PF_ADM_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Admission Type
|
| 101 |
SFA_PF_TRANS_STU |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Student
N=No
Y=Yes
|
| 102 |
SFA_PF_EFMCORPWARD |
Character(1) |
VARCHAR2(1) NOT NULL |
EFM Comp OrphanWard Foster Ind
N=No
Y=Yes
|
| 103 |
SFA_PF_RCVD_MEDAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Received Medicaid
N=No
Y=Yes
|
| 104 |
SFA_PF_FARM_VAL |
Number(10,0) |
DECIMAL(10) NOT NULL |
Farm
|
| 105 |
SFA_PF_FARM_DEBT19 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Farm
|
| 106 |
SFA_PF_FINAPP_ST19 |
Character(7) |
VARCHAR2(7) NOT NULL |
Financial Aid Appl Status
|
| 107 |
HOUSING_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Housing Code
1=Campus Housing
2=Off-Campus Housing
3=With Parents
4=With Relatives
|
| 108 |
SFA_PF_PCTRY_COEFF |
Signed Number(10,7) |
DECIMAL(8,7) NOT NULL |
Parent Country Co-Effecient
|
| 109 |
SFA_PF_SCTRY_COEFF |
Signed Number(10,7) |
DECIMAL(8,7) NOT NULL |
Student Country Co-Effecient
|
| 110 |
SFA_PF_STDNTIM_ZIP |
Character(17) |
VARCHAR2(17) NOT NULL |
Student IM Zip
|
| 111 |
SFA_PF_PRNTIM_ZIP |
Character(17) |
VARCHAR2(17) NOT NULL |
Parent IM Zip
|
| 112 |
SFA_FEE_CD_USE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Fee Payment Code Indicator
N=No
Y=Yes
|
| 113 |
SFA_PF_SCHOOL_NM |
Character(50) |
VARCHAR2(50) NOT NULL |
Name of School
|
| 114 |
MONTH_MORTGAGE_PMT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Monthly Mortgage/Rent Payment
|
| 115 |
SFA_SP_EXPEARN_INC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Spouse's Expected Earned Inc
|
| 116 |
SFA_SP_EXPOTH_INC |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Spouse's Expected Oth Tax Inc
|
| 117 |
SFA_SP_EXPUNTX_INC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Spouse's Expected UnTax Inc
|
| 118 |
SFA_PF_TRUST_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Trust Type
|
| 119 |
SFA_PF_EDLN_BRFED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Federal Amount Borrowed
|
| 120 |
SFA_PF_EDLN_BRPVT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Private Amount Borrowed
|
| 121 |
SFA_PF_EDLN_OSFED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Federal Amount Outstanding
|
| 122 |
SFA_PF_EDLN_OSPVT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Private Amount Outstanding
|
| 123 |
SFA_PF_POST911_PER |
Number(3,0) |
SMALLINT NOT NULL |
Post 911 Benefit Percent
|