| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADJ_GROSS_INCOME
|
|
NUMBER
|
|
|
|
AID_YEAR
|
|
VARCHAR2(4)
|
|
|
|
AID_YEAR_DESC
|
|
VARCHAR2(30)
|
|
|
|
APPLICATION_NUMBER
|
|
NUMBER
|
|
|
|
APPLICATION_SSN
|
|
VARCHAR2(9)
|
|
|
|
APPL_IM_PARENT_CONTRIB
|
|
NUMBER
|
|
|
|
APPL_IM_STUDENT_CONTRIB
|
|
NUMBER
|
|
|
|
BUSINESS_DEBT
|
|
NUMBER
|
|
|
|
BUSINESS_VALUE
|
|
NUMBER
|
|
|
|
CASH_SAVINGS
|
|
NUMBER
|
|
|
|
COLLEGE
|
|
VARCHAR2(6)
|
|
|
|
COLLEGE_DESC
|
|
VARCHAR2(30)
|
|
|
|
CURRENT_RECORD_IND
|
|
VARCHAR2(1)
|
|
|
|
DEPENDENCY_STATUS
|
|
VARCHAR2(1)
|
|
|
|
DEPEND_INDEPEND_IND
|
|
VARCHAR2(1)
|
|
|
|
DOMAIN_VALUE
|
|
VARCHAR2(6)
|
|
|
|
EPS_REGION
|
|
VARCHAR2(4)
|
|
|
|
EPS_REGION_DESC
|
|
VARCHAR2(30)
|
|
|
|
EXPECTED_ENROLL_STATUS
|
|
VARCHAR2(1)
|
|
|
|
FAMILY_IN_COLLEGE
|
|
NUMBER
|
|
|
|
FAMILY_SIZE
|
|
NUMBER
|
|
|
|
FM_PARENT_CONTRIB_ASSET
|
|
NUMBER
|
|
|
|
FM_PARENT_CONTRIB_INCOME
|
|
NUMBER
|
|
|
|
FM_STUDENT_CONTRIB_ASSET
|
|
NUMBER
|
|
|
|
FM_STUDENT_CONTRIB_INCOME
|
|
NUMBER
|
|
|
|
FM_TOTAL_INCOME
|
|
NUMBER
|
|
|
|
HOME_DEBT
|
|
NUMBER
|
|
|
|
HOME_VALUE
|
|
NUMBER
|
|
|
|
HOUSING_CODE
|
|
VARCHAR2(1)
|
|
|
|
IM_PARENT_CONTRIB_ASSET
|
|
NUMBER
|
|
|
|
IM_PARENT_CONTRIB_INCOME
|
|
NUMBER
|
|
|
|
IM_STUDENT_CONTRIB_ASSET
|
|
NUMBER
|
|
|
|
IM_STUDENT_CONTRIB_INCOME
|
|
NUMBER
|
|
|
|
IM_TOTAL_INCOME
|
|
NUMBER
|
|
|
|
INAS_PC
|
|
NUMBER
|
|
|
|
INAS_SC
|
|
NUMBER
|
|
|
|
INAS_TFC
|
|
NUMBER
|
|
|
|
INTERFACE_TAPE_CODE
|
|
VARCHAR2(7)
|
|
|
|
INTERFACE_TAPE_DESC
|
|
VARCHAR2(30)
|
|
|
|
LOAD_DATE
|
|
DATE
|
|
|
|
MARITAL_STATUS
|
|
VARCHAR2(1)
|
|
|
|
MIF_DESC
|
|
VARCHAR2(30)
|
|
|
|
MIF_VALUE
|
|
VARCHAR2(6)
|
|
|
|
PARENTAL_CONTRIBUTION
|
|
NUMBER
|
|
|
|
PARENTS_TOTAL_INCOME
|
|
NUMBER
|
|
|
|
PARENT_2_TOT_INCOME
|
|
NUMBER
|
|
|
|
PARENT_ADJ_GROSS_INCOME
|
|
NUMBER
|
|
|
|
PARENT_CONTRIB_OFFICIAL_IND
|
|
VARCHAR2(1)
|
|
|
|
PELL_PGI
|
|
NUMBER
|
|
|
|
PERSON_UID
|
|
NUMBER
|
|
|
|
REAL_ESTATE_DEBT
|
|
NUMBER
|
|
|
|
REAL_ESTATE_VALUE
|
|
NUMBER
|
|
|
|
SAR_EFC
|
|
NUMBER
|
|
|
|
SELECTED_FOR_VERIFICATION
|
|
VARCHAR2(1)
|
|
|
|
SSN
|
|
VARCHAR2(9)
|
|
|
|
STATE_OF_RESIDENCE
|
|
VARCHAR2(2)
|
|
|
|
STATE_OF_RESIDENCE_DESC
|
|
VARCHAR2(30)
|
|
|
|
STUDENT_CONTRIBUTION
|
|
NUMBER
|
|
|
|
STUDENT_CONTRIB_OFFICIAL_IND
|
|
VARCHAR2(1)
|
|
|
|
TOTAL_FAMILY_CONTRIBUTION_FED
|
|
NUMBER
|
|
|
|
TOTAL_FAMILY_CONTRIBUTION_INST
|
|
NUMBER
|
|
|
|
VERIFICATION_PRIORITY
|
|
VARCHAR2(4)
|
|
|
|
YEAR_IN_COLLEGE
|
|
VARCHAR2(1)
|
|
|
|
ZONE_VALUE
|
|
VARCHAR2(6)
|
|
|