| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
STDNT_AID_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:
ISIR_CONTROL
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
TABLE_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Table Key
Default Value: 1
|
| 7 |
NUM_FAMILY_MEMBERS |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr in Family
|
| 8 |
DFLT_NUM_FAM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Nbr Family Default Set
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 9 |
NUMBER_IN_COLLEGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr in College
|
| 10 |
DFLT_NUM_COLL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Nbr in College Default Set
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 11 |
DOB_PRIOR |
Character(1) |
VARCHAR2(1) NOT NULL |
DOB Before 1/1/74
1=Yes
2=No
|
| 12 |
DFLT_DOB_PRIOR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
DOB Prior Defaulted
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 13 |
VETERAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran
1=Yes
2=No
N=No
Y=Yes
|
| 14 |
GRADUATE_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Grad Student
1=Yes
2=No
|
| 15 |
MARRIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Married
1=Yes
2=No
|
| 16 |
DFLT_MARRIED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Married Defaulted
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 17 |
MARITAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
1=Single
2=Married
3=Separated
4=Divorced
5=Widowed
|
| 18 |
MAR_STATUS_DT |
Date(10) |
DATE |
This is the date that the employee's Marital status is/was effective.
/* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons.
1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user.
2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
|
| 19 |
DFLT_MAR_STAT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status Defaulted
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 20 |
ORPHAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Orphan or Ward of the Court
1=Yes
2=No
N=No
Y=Yes
|
| 21 |
DEPENDENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependents Other Than Spouse
1=Yes
2=No
N=No
Y=Yes
|
| 22 |
DFLT_DEPEND_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependents Defaulted
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 23 |
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
|
| 24 |
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
?=?
|
| 25 |
AGI |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Adjusted Gross Income
|
| 26 |
DFLT_AGI_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
AGI Default Set
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 27 |
TAXES_PAID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
U.S. Tax Paid
|
| 28 |
DFLT_TAXES_PD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Taxes Paid Default Set
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 29 |
STD_EARNED_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Student's Earned Income
|
| 30 |
DFLT_STD_INC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Income Default Set
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 31 |
SPS_EARNED_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Spouse's Earned Income
|
| 32 |
DFLT_SPS_INC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Spouse Income Default Set
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 33 |
SOC_SEC_BENEFITS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
SS Benefits
|
| 34 |
DFLT_SS_BEN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Soc Sec Benefits Default Set
A=Assumption
B=Blank
R=Reported
V=Verified
|
| 35 |
AFDC_BENEFITS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
AFDC Benefits
|
| 36 |
DFLT_AFDC_BEN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
AFDC Benefit Default Set
A=Assumption
B=Blank
R=Reported
V=Verified
|
| 37 |
CHILD_SUPPORT |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Child Support
|
| 38 |
DFLT_CHLD_SPPT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Support Default Set
A=Assumption
B=Blank
R=Reported
V=Verified
|
| 39 |
UNTAXED_INCOME |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Untaxed Income
|
| 40 |
DFLT_UNTXD_INC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Untaxed Income Default Set
A=Assumption
B=Blank
R=Reported
V=Verified
|
| 41 |
CASH_SAVINGS |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Cash Savings
|
| 42 |
RE_INVEST_VALUE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Real Estate Invest Value
|
| 43 |
RE_INVEST_DEBT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Real Estate Invest Debt
|
| 44 |
BUSINESS_VALUE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Business Value
|
| 45 |
BUSINESS_DEBT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Business Debt
|
| 46 |
FARM_VALUE |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Investment Farm Value
|
| 47 |
FARM_DEBT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Investment Farm Debt
|
| 48 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 49 |
SCHOOL_CHOICE_1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 1st Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 50 |
HOUSING_CODE_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 1
1=On-Campus
2=Off-Campus
3=Parents
|
| 51 |
SCHOOL_CHOICE_2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 2nd Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 52 |
HOUSING_CODE_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 2
1=On-Campus
2=Off-Campus
3=Parents
|
| 53 |
SCHOOL_CHOICE_3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 3rd Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 54 |
HOUSING_CODE_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 3
1=On-Campus
2=Off-Campus
3=Parents
|
| 55 |
SCHOOL_CHOICE_4 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 4th Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 56 |
HOUSING_CODE_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 4
1=On-Campus
2=Off-Campus
3=Parents
|
| 57 |
SCHOOL_CHOICE_5 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 5th Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 58 |
HOUSING_CODE_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 5
1=On-Campus
2=Off-Campus
3=Parents
|
| 59 |
SCHOOL_CHOICE_6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 6th Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 60 |
HOUSING_CODE_6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 6
1=On-Campus
2=Off-Campus
3=Parents
|
| 61 |
STATE_AGNCY_RLSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Send Info to the State Agency
1=Yes
2=No
|
| 62 |
SEL_SERV_REGISTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Permit Sel Serv to Enroll
1=Yes
2=No
|
| 63 |
SIGNED_BY_APPLICNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Signed
1=Yes
2=No
Default Value: 1
|
| 64 |
SIGNED_BY_SPOUSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Spouse Signed
1=Yes
|
| 65 |
SIGNED_BY_FATHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Father Signed
1=Yes
|
| 66 |
SIGNED_BY_MOTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Mother Signed
1=Yes
|
| 67 |
FIRST_BACH_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Received First Bachelor Degree
1=Yes
2=No
|
| 68 |
MONTHLY_VET_BEN |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Monthly Vet Edu Benefits
|
| 69 |
NUM_MONTH_VET_BEN |
Character(2) |
VARCHAR2(2) NOT NULL |
VA Ben Number of Months
|
| 70 |
INTERESTED_IN_WS |
Character(1) |
VARCHAR2(1) NOT NULL |
Interested In Work-Study
1=Yes
2=No
3=Don't Know
|
| 71 |
INTERESTED_IN_SL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interested In Student Loans
1=Yes
2=No
|
| 72 |
INTERESTED_IN_PLUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Interested In PLUS
1=Yes
2=No
|
| 73 |
APP_SIGNED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Signed By
A=Applicant
B=Applicant and Parent
|
| 74 |
DT_APP_COMPLETED |
Date(10) |
DATE |
Date Application Completed
|
| 75 |
DT_GED_EARNED |
Date(10) |
DATE |
Date GED Earned
|
| 76 |
HS_GRAD_DT |
Date(10) |
DATE |
Highschool graduation date
|
| 77 |
ATTEND_SAME_COLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Attend Same College
1=Yes
2=No
|
| 78 |
ENROLL_CURNT_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Current Sumr
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 79 |
ENROLL_FALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Fall
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 80 |
ENROLL_WINTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Winter
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 81 |
ENROLL_SPRING |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Spring
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 82 |
ENROLL_NEXT_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Next Sumr
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 83 |
DEGREE_CERTIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Degree/Certificate
1=1st Bachelor Degree
2=2nd Bachelor Degree
3=Associate Degree (Occ/Tech)
4=Associate Degree (Gen Ed)
5=Certificate or Diploma < 2 yrs
6=Certificate or Diplome >= 2yrs
7=Teaching Credential
8=Graduate or Professional
9=Other/Undecided
|
| 84 |
COURSE_OF_STUDY |
Character(2) |
VARCHAR2(2) NOT NULL |
Course of Study
01=Agriculture
02=Architecture
03=Biological Sciences
04=Business Management
05=Communications (Journalism)
06=Computer Science
07=Education
08=Engineering
09=English Lang/Literature
10=Fine & Performing Arts
11=Foreign Lang/Literature
12=Health (Not Nursing)
13=Home Economics
14=Law
15=Liberal Arts
16=Library Sciences
17=Mathematics
18=Nursing
19=Personal/Miscellaneous
20=Philosophy
21=Physical Science
22=Social Science
23=Psychology
24=Theological studies
25=Vocational/Technical
26=Wildlife/Forestry
27=Other/Undecided
|
| 85 |
DT_EXPCT_TO_COMP |
Date(10) |
DATE |
Date Expected to Complete Prog
|
| 86 |
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
|
| 87 |
PAY_NUM_DEPENDENTS |
Character(2) |
VARCHAR2(2) NOT NULL |
Care for how many Dependents
|
| 88 |
TOTAL_FROM_WS3 |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Total from Worksheet 3
|
| 89 |
DFLT_WS3_TOT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Total from WrkSht 3 Defaulted
A=Assumption
B=Blank
R=Reported
V=Verified
|
| 90 |
DEPNDNCY_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependency Status
1=Independent
2=Dependent
3=Indepenedent/Pro Judgmnt
D=Dependent
I=Independent
X=Dependent Reject
Y=Independent Reject
Z=Provisional Independent
|
| 91 |
PROJECTED_YR_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Projected Year Income
N=No
Y=Yes
Default Value: N
|
| 92 |
EARLY_ADMISSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Early Admission
1=Estim. of Elig, Not Enrolling
|
| 93 |
ERND_INC_CREDIT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Earned Income Credit
|
| 94 |
DFLT_EIC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Earned Inc Source Ind
A=Assumption
B=Blank
R=Reported
V=Verified
|
| 95 |
GRADUATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduate
Y=Yes
|
| 96 |
EXP_TOT_WS3 |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Expected Tot From Worksheet 3
|
| 97 |
DFLT_EXP_WS3_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
WS3 Total Defaulted
A=Assumption
B=Blank
R=Reported
V=Verified
|
| 98 |
STATE_RESIDENCE |
Character(6) |
VARCHAR2(6) NOT NULL |
State of Residence
Prompt Table:
SFA_ISIRSTATEVW
|
| 99 |
RESIDENCY_DT |
Date(10) |
DATE |
Residency Date
|
| 100 |
DRIV_LIC_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Issuing State
|
| 101 |
HS_GED_RCVD |
Character(1) |
VARCHAR2(1) NOT NULL |
HS Diploma or GED Received
1=Yes
2=No
|
| 102 |
FISAP_TOT_INC |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
FISAP Total Income
|
| 103 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
|
| 104 |
LEGAL_RES_PRI_94 |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Resident Before 01-01-94
1=Yes
2=No
|
| 105 |
STUDENT_MALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Are You Male?
1=Yes
2=No
|
| 106 |
TAX_RETURN_FILED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Return Filed?
1=Already Filed/Completed
2=Will File
3=Will Not File
|
| 107 |
ELIG_FOR_1040A_EZ |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible For 1040A or 1040EZ
1=Yes
2=No/Don't Know
|
| 108 |
TOTAL_FROM_WKA |
Number(5,0) |
INTEGER NOT NULL |
Total Amount from WK A
|
| 109 |
INV_NET_WORTH |
Number(10,0) |
DECIMAL(10) NOT NULL |
Investment Net Worth
|
| 110 |
BUS_NET_WORTH |
Number(10,0) |
DECIMAL(10) NOT NULL |
Business Net Worth
|
| 111 |
FARM_NET_WORTH |
Number(6,0) |
INTEGER NOT NULL |
Farm Net Worth
|
| 112 |
STUDENT_HAVE_DL |
Character(1) |
VARCHAR2(1) NOT NULL |
Do you have a driver's license
1=Yes
2=No
|
| 113 |
DRUG_OFFENSE_CONV |
Character(1) |
VARCHAR2(1) NOT NULL |
Drug Offense Conviction
1=Eligible
2=Partially Eligible
3=Ineligible or Don't know
I=Institutional Override
|
| 114 |
LEGAL_RES_PRIOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Resident Before 01-01-95
1=Yes
2=No
|
| 115 |
DFLT_WSA_TOT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Total from Worksheet A
A=Assumption
B=Blank
R=Reported
V=Verified
|
| 116 |
DFLT_VETERAN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Veteran Indicator
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 117 |
DFLT_CITIZEN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Citizenship Indicator
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 118 |
IWD_PERM_ADDR02 |
Character(35) |
VARCHAR2(35) NOT NULL |
Permanent Mailing Address
|
| 119 |
IWD_CITY |
Character(16) |
VARCHAR2(16) NOT NULL |
City
|
| 120 |
IWD_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
State
|
| 121 |
IWD_ZIP |
Character(5) |
VARCHAR2(5) NOT NULL |
Zip
|
| 122 |
IWD_PERM_PHONE |
Character(10) |
VARCHAR2(10) NOT NULL |
Perm Phone Number
|
| 123 |
IWD_STD_LAST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
Last Name
|
| 124 |
IWD_STD_FIRST_NM02 |
Character(35) |
VARCHAR2(35) NOT NULL |
Student's First Name
|
| 125 |
IWD_STU_MI |
Character(15) |
VARCHAR2(15) NOT NULL |
Student Middle Initial
|
| 126 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 127 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 128 |
DRIVERS_LICENSE_NO |
Character(20) |
VARCHAR2(20) NOT NULL |
Driver's License #
Prompt Table:
ISIR_DRVLIC2_VW
|
| 129 |
IWD_STU_ALIEN_REG |
Character(9) |
VARCHAR2(9) NOT NULL |
Alien Registration Number
Prompt Table:
ALIEN_REG2_VW
|
| 130 |
CHILDREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Have Children you support
1=Yes
2=No
|
| 131 |
DFLT_CHILDREN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Veteran Indicator
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 132 |
TOTAL_FROM_WKC |
Number(8,0) |
INTEGER NOT NULL |
Total Amount from WK C
|
| 133 |
DFLT_WKC_TOT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Total from WrkSht C Defaulted
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 134 |
IWD_STD_EMAIL |
Character(50) |
VARCHAR2(50) NOT NULL |
Student's Email Address
|
| 135 |
BLANK_AGI |
Character(1) |
VARCHAR2(1) NOT NULL |
AGI value is blank
N=Not Blank
Y=Blank
Y/N Table Edit
Default Value: N
|
| 136 |
BLANK_TAXES_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Taxes Paid value is blank
N=Not Blank
Y=Blank
Y/N Table Edit
Default Value: N
|
| 137 |
BLANK_STD_EARN_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Earned Income blank
N=Not Blank
Y=Blank
Y/N Table Edit
Default Value: N
|
| 138 |
BLANK_SPS_EARN_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Spouse's Earned Income blank
N=Not Blank
Y=Blank
Y/N Table Edit
Default Value: N
|
| 139 |
BLANK_TOT_FROM_WS3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Total From Wksheet B is blank
N=Not Blank
Y=Blank
Y/N Table Edit
Default Value: N
|
| 140 |
BLANK_TOT_FROM_WKA |
Character(1) |
VARCHAR2(1) NOT NULL |
Total From Wksheet A is blank
N=Not Blank
Y=Blank
Y/N Table Edit
Default Value: N
|
| 141 |
BLANK_INV_NET_WRTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Investment Net Worth is blank
N=Not Blank
Y=Blank
Y/N Table Edit
Default Value: N
|
| 142 |
ISIR_STU_ENRL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enrollment Status
1=Full Time
2=Three Quarter Time
3=Half Time
4=Less than Half Time
5=Don't Know
|
| 143 |
BLANK_CASH_SAV |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash savings value is blank
N=Non Blank
Y=Blank
Y/N Table Edit
Default Value: N
|
| 144 |
SFA_ACTIVE_DUTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Duty in U.S Military
1=Yes
2=No
|
| 145 |
SFA_SSI_INCOME |
Character(1) |
VARCHAR2(1) NOT NULL |
Receives SSI Income
1=Yes
2=No
|
| 146 |
SFA_FOOD_STAMPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Receives Food Stamps
1=Yes
2=No
|
| 147 |
SFA_SCHL_LUNCH_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Participates in Sch Lunch Prog
1=Yes
2=No
|
| 148 |
SFA_TANF_BENEFITS |
Character(1) |
VARCHAR2(1) NOT NULL |
TANF Recipient
1=Yes
2=No
|
| 149 |
SFA_WIC_BENEFITS |
Character(1) |
VARCHAR2(1) NOT NULL |
WIC Benefits Recipient
1=Yes
2=No
|
| 150 |
SFA_INTRSTD_IN_WSL |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Study or Student Loans
1=Work Study
2=Student Loans
3=Both
4=Neither
5=Don't Know
|
| 151 |
SFA_STDNT_GENDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Are You Male or Female
1=Male
2=Female
|
| 152 |
SFA_HS_DIP_EQUIV |
Character(1) |
VARCHAR2(1) NOT NULL |
HS Diploma or Equivalent
1=High School Diploma
2=GED
3=Home Schooled
4=Other
|
| 153 |
SFA_SCHL_CHOICE_7 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 7th Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 154 |
SFA_HOUSING_CODE7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 7
1=On-Campus
2=Off-Campus
3=Parents
|
| 155 |
SFA_SCHL_CHOICE_8 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 8th Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 156 |
SFA_HOUSING_CODE8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 8
1=On-Campus
2=Off-Campus
3=Parents
|
| 157 |
SFA_SCHL_CHOICE_9 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 9th Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 158 |
SFA_HOUSING_CODE9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 9
1=On-Campus
2=Off-Campus
3=Parents
|
| 159 |
SFA_SCHL_CHOICE_10 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 10th Choice School
Prompt Table:
TITLE_IV_SRCH
|
| 160 |
SFA_HOUSING_CODE10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 10
1=On-Campus
2=Off-Campus
3=Parents
|
| 161 |
SFA_TCH_COURSE_WRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Teacher Coursework
1=Yes
2=No
3=Don't Know
|
| 162 |
SFA_EMANCIPT_MINOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Emancipated Minor
1=Yes
2=No
|
| 163 |
SFA_LEGAL_GUARDIAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Guardianship
1=Yes
2=No
|
| 164 |
SFA_YOUTH_LIASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Youth determined by SDL
1=Yes
2=No
|
| 165 |
SFA_YOUTH_HUD |
Character(1) |
VARCHAR2(1) NOT NULL |
Youth determined by HUD
1=Yes
2=No
|
| 166 |
SFA_RISK_HOMELESS |
Character(1) |
VARCHAR2(1) NOT NULL |
At Risk of Homelessness
1=Yes
2=No
|
| 167 |
SFA_DISLOCATE_WRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Dislocated Worker
1=Yes
2=No
3=Don't Know
|
| 168 |
SFA_EDU_CREDITS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Educational Credits
|
| 169 |
SFA_CHILD_SUP_PAID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Child Support Paid
|
| 170 |
SFA_NEED_EMPLOYMNT |
Number(7,0) |
INTEGER NOT NULL |
Need-Based Employment
|
| 171 |
SFA_GRANT_AID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Grant/Scholarship Aid
|
| 172 |
SFA_COMBATPAY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Combat Pay
|
| 173 |
SFA_PENSION_PAY |
Number(7,0) |
INTEGER NOT NULL |
Pension Payments
|
| 174 |
SFA_IRA_PAY |
Number(7,0) |
INTEGER NOT NULL |
IRA Payments
|
| 175 |
SFA_CHILD_SUP_RECV |
Number(10,0) |
DECIMAL(10) NOT NULL |
Child Support Received
|
| 176 |
SFA_INTERST_INCOME |
Number(7,0) |
INTEGER NOT NULL |
Interest Income
|
| 177 |
SFA_IRA_DIST |
Number(7,0) |
INTEGER NOT NULL |
IRA Distributions
|
| 178 |
SFA_UNTAX_PENSION |
Number(7,0) |
INTEGER NOT NULL |
Untaxed Pensions
|
| 179 |
SFA_MILITARY_ALLOW |
Number(10,0) |
DECIMAL(10) NOT NULL |
Military/Clergy Allowances
|
| 180 |
SFA_VET_NONEDU_BEN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Veterans Non-Ed Benefits
|
| 181 |
SFA_UNTAX_INCOME |
Number(10,0) |
DECIMAL(10) NOT NULL |
Other Untaxed Income
|
| 182 |
SFA_NON_REP_MONEY |
Number(7,0) |
INTEGER NOT NULL |
Other Non-Reported Money
|
| 183 |
SFA_RECV_VET_BEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiving Veterans Benefits
1=Yes
2=No
|
| 184 |
SFA_VET_BEN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Veterans Benefits
1=GI Bill - Active Duty
2=Post-9/11 GI Bill
3=GI Bill - Selected Reserve
4=Reserve Edu Assistance Program
5=Vocational Rehab & Employment
6=Dependents Educational Assist
7=Other Type of Vet Edu Benefits
|
| 185 |
SFA_COOP_EARN |
Number(7,0) |
INTEGER NOT NULL |
Co-op Earnings
|
| 186 |
SFA_DFLT_YOUTH_SCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Homeless Youth - School
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 187 |
SFA_DFLT_YOUTH_HUD |
Character(1) |
VARCHAR2(1) NOT NULL |
Homeless Youth - HUD
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 188 |
SFA_DFLT_RISK_HOME |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk of Homelessness
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 189 |
SFA_BLANK_BUSNET |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Net Worth is Blank
N=Not Blank
Y=Blank
|
| 190 |
SFA_BLANK_EDUCREDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Educational Credit is Blank
N=Not Blank
Y=Blank
|
| 191 |
SFA_BLANK_CHILDSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Support Paid is Blank
N=Not Blank
Y=Blank
|
| 192 |
SFA_BLANK_NEEDEMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Need Employment is Blank
N=Not Blank
Y=Blank
|
| 193 |
SFA_BLANK_GRANTAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Grant Aid is Blank
N=Not Blank
Y=Blank
|
| 194 |
SFA_BLANK_COMBAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Combat Pay is Blank
N=Not Blank
Y=Blank
|
| 195 |
SFA_BLANK_COOPEARN |
Character(1) |
VARCHAR2(1) NOT NULL |
Co-op Earnings is Blank
N=Not Blank
Y=Blank
|
| 196 |
SFA_BLANK_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Pay is Blank
N=Not Blank
Y=Blank
|
| 197 |
SFA_BLANK_IRA_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Self Employment Pay is Blank
N=Not Blank
Y=Blank
|
| 198 |
SFA_BLANK_CHILDREC |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Support Receive is Blank
N=Not Blank
Y=Blank
|
| 199 |
SFA_BLANK_INT_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Interest is Blank
N=Not Blank
Y=Blank
|
| 200 |
SFA_BLANK_IRA_DIST |
Character(1) |
VARCHAR2(1) NOT NULL |
IRA Distributions is Blank
N=Not Blank
Y=Blank
|
| 201 |
SFA_BLANK_UNTAXPEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Untax Pension is Blank
N=Not Blank
Y=Blank
|
| 202 |
SFA_BLANK_MILITARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Allowance is Blank
N=Not Blank
Y=Blank
|
| 203 |
SFA_BLANK_VET_NON |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Non-Ed Ben is Blank
N=Not Blank
Y=Blank
|
| 204 |
SFA_BLANK_UNTAXINC |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Untax Income is Blank
N=Not Blank
Y=Blank
|
| 205 |
SFA_BLANK_NON_REP |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Unreported Inc is Blank
N=Not Blank
Y=Blank
|
| 206 |
SFA_HIGH_SCHL_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
High School Name
|
| 207 |
SFA_HIGH_SCHL_CITY |
Character(28) |
VARCHAR2(28) NOT NULL |
High School City
|
| 208 |
SFA_HIGH_SCHL_STAT |
Character(2) |
VARCHAR2(2) NOT NULL |
High School State
Prompt Table:
SFA_ISIRSTATEVW
|
| 209 |
SFA_HIGH_SCHL_CODE |
Character(12) |
VARCHAR2(12) NOT NULL |
High School Code
|
| 210 |
SFA_STU_ASSET_THRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Threshold Exceeded
1=Yes
2=No
|
| 211 |
SFA_DFLT_ASM_ASSET |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Threshold Exceed Def
A=Assumption
B=Blank
R=Reported
S=Simulation
V=Verified
|
| 212 |
SFA_STU_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 House
5=Widow(er)
6=Don't Know
|
| 213 |
SFA_1040_SCHEDULE |
Character(1) |
VARCHAR2(1) NOT NULL |
1040 Schedule 1 Filed
1=No
2=Yes
3=Dont Know
|