View: IGF_AP_CSS_PROFILE_V

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_AP_CSS_PROFILE_V

View Text

SELECT CSS.ROW_ID ROW_ID
, CSS.CSSP_ID
, FARV.BASE_ID
, CSS.ACTIVE_PROFILE
, CSS.COLLEGE_CODE
, CSS.ACADEMIC_YEAR
, CSS.STU_RECORD_TYPE
, CSS.CSS_ID_NUMBER
, CSS.REGISTRATION_RECEIPT_DATE
, CSS.REGISTRATION_TYPE
, CSS.APPLICATION_RECEIPT_DATE
, CSS.APPLICATION_TYPE
, CSS.ORIGINAL_FNAR_COMPUTE
, CSS.REVISION_FNAR_COMPUTE_DATE
, CSS.ELECTRONIC_EXTRACT_DATE
, CSS.INSTITUTIONAL_REPORTING_TYPE
, CSS.ASR_RECEIPT_DATE
, CSS.LAST_NAME
, CSS.FIRST_NAME
, CSS.MIDDLE_INITIAL
, CSS.ADDRESS_NUMBER_AND_STREET
, CSS.CITY
, CSS.STATE_MAILING
, CSS.ZIP_CODE
, CSS.S_TELEPHONE_NUMBER
, CSS.S_TITLE
, CSS.DATE_OF_BIRTH
, CSS.SOCIAL_SECURITY_NUMBER
, CSS.STATE_LEGAL_RESIDENCE
, CSS.FOREIGN_ADDRESS_INDICATOR
, CSS.FOREIGN_POSTAL_CODE
, CSS.COUNTRY
, CSS.FINANCIAL_AID_STATUS
, CSS.YEAR_IN_COLLEGE
, CSS.MARITAL_STATUS
, CSS.WARD_COURT
, CSS.LEGAL_DEPENDENTS_OTHER
, CSS.HOUSEHOLD_SIZE
, CSS.NUMBER_IN_COLLEGE
, CSS.CITIZENSHIP_STATUS
, CSS.CITIZENSHIP_COUNTRY
, CSS.VISA_CLASSIFICATION
, CSS.TAX_FIGURES
, CSS.NUMBER_EXEMPTIONS
, CSS.ADJUSTED_GROSS_INC
, CSS.US_TAX_PAID
, CSS.ITEMIZED_DEDUCTIONS
, CSS.STU_INCOME_WORK
, CSS.SPOUSE_INCOME_WORK
, CSS.DIVID_INT_INC
, CSS.SOC_SEC_BENEFITS
, CSS.WELFARE_TANF
, CSS.CHILD_SUPP_RCVD
, CSS.EARNED_INCOME_CREDIT
, CSS.OTHER_UNTAX_INCOME
, CSS.TAX_STU_AID
, CSS.CASH_SAV_CHECK
, CSS.IRA_KEOGH
, CSS.INVEST_VALUE
, CSS.INVEST_DEBT
, CSS.HOME_VALUE
, CSS.HOME_DEBT
, CSS.OTH_REAL_VALUE
, CSS.OTH_REAL_DEBT
, CSS.BUS_FARM_VALUE
, CSS.BUS_FARM_DEBT
, CSS.LIVE_ON_FARM
, CSS.HOME_PURCH_PRICE
, CSS.HOPE_LL_CREDIT
, CSS.HOME_PURCH_YEAR
, CSS.TRUST_AMOUNT
, CSS.TRUST_AVAIL
, CSS.TRUST_ESTAB
, CSS.CHILD_SUPPORT_PAID
, CSS.MED_DENT_EXPENSES
, CSS.VET_US
, CSS.VET_BEN_AMOUNT
, CSS.VET_BEN_MONTHS
, CSS.STU_SUMMER_WAGES
, CSS.STU_SCHOOL_YR_WAGES
, CSS.SPOUSE_SUMMER_WAGES
, CSS.SPOUSE_SCHOOL_YR_WAGES
, CSS.SUMMER_OTHER_TAX_INC
, CSS.SCHOOL_YR_OTHER_TAX_INC
, CSS.SUMMER_UNTAX_INC
, CSS.SCHOOL_YR_UNTAX_INC
, CSS.GRANTS_SCHOL_ETC
, CSS.TUIT_BENEFITS
, CSS.CONT_PARENTS
, CSS.CONT_RELATIVES
, CSS.P_SIBLINGS_PRE_TUIT
, CSS.P_STUDENT_PRE_TUIT
, CSS.P_HOUSEHOLD_SIZE
, CSS.P_NUMBER_IN_COLLEGE
, CSS.P_PARENTS_IN_COLLEGE
, CSS.P_MARITAL_STATUS
, CSS.P_STATE_LEGAL_RESIDENCE
, CSS.P_NATURAL_PAR_STATUS
, CSS.P_CHILD_SUPP_PAID
, CSS.P_REPAY_ED_LOANS
, CSS.P_MED_DENT_EXPENSES
, CSS.P_TUIT_PAID_AMOUNT
, CSS.P_TUIT_PAID_NUMBER
, CSS.P_EXP_CHILD_SUPP_PAID
, CSS.P_EXP_REPAY_ED_LOANS
, CSS.P_EXP_MED_DENT_EXPENSES
, CSS.P_EXP_TUIT_PD_AMOUNT
, CSS.P_EXP_TUIT_PD_NUMBER
, CSS.P_CASH_SAV_CHECK
, CSS.P_MONTH_MORTGAGE_PAY
, CSS.P_INVEST_VALUE
, CSS.P_INVEST_DEBT
, CSS.P_HOME_VALUE
, CSS.P_HOME_DEBT
, CSS.P_HOME_PURCH_PRICE
, CSS.P_OWN_BUSINESS_FARM
, CSS.P_BUSINESS_VALUE
, CSS.P_BUSINESS_DEBT
, CSS.P_FARM_VALUE
, CSS.P_FARM_DEBT
, CSS.P_LIVE_ON_FARM
, CSS.P_OTH_REAL_ESTATE_VALUE
, CSS.P_OTH_REAL_ESTATE_DEBT
, CSS.P_OTH_REAL_PURCH_PRICE
, CSS.P_SIBLINGS_ASSETS
, CSS.P_HOME_PURCH_YEAR
, CSS.P_OTH_REAL_PURCH_YEAR
, CSS.P_PRIOR_AGI
, CSS.P_PRIOR_US_TAX_PAID
, CSS.P_PRIOR_ITEM_DEDUCTIONS
, CSS.P_PRIOR_OTHER_UNTAX_INC
, CSS.P_TAX_FIGURES
, CSS.P_NUMBER_EXEMPTIONS
, CSS.P_ADJUSTED_GROSS_INC
, CSS.P_WAGES_SAL_TIPS
, CSS.P_INTEREST_INCOME
, CSS.P_DIVIDEND_INCOME
, CSS.P_NET_INC_BUS_FARM
, CSS.P_OTHER_TAXABLE_INCOME
, CSS.P_ADJ_TO_INCOME
, CSS.P_US_TAX_PAID
, CSS.P_ITEMIZED_DEDUCTIONS
, CSS.P_FATHER_INCOME_WORK
, CSS.P_MOTHER_INCOME_WORK
, CSS.P_SOC_SEC_BEN
, CSS.P_WELFARE_TANF
, CSS.P_CHILD_SUPP_RCVD
, CSS.P_DED_IRA_KEOGH
, CSS.P_TAX_DEFER_PENS_SAVS
, CSS.P_DEP_CARE_MED_SPENDING
, CSS.P_EARNED_INCOME_CREDIT
, CSS.P_LIVING_ALLOW
, CSS.P_TAX_EXMPT_INT
, CSS.P_FOREIGN_INC_EXCL
, CSS.P_OTHER_UNTAX_INC
, CSS.P_HOPE_LL_CREDIT
, CSS.P_YR_SEPARATION
, CSS.P_YR_DIVORCE
, CSS.P_EXP_FATHER_INC
, CSS.P_EXP_MOTHER_INC
, CSS.P_EXP_OTHER_TAX_INC
, CSS.P_EXP_OTHER_UNTAX_INC
, CSS.LINE_2_RELATION
, CSS.LINE_2_ATTEND_COLLEGE
, CSS.LINE_3_RELATION
, CSS.LINE_3_ATTEND_COLLEGE
, CSS.LINE_4_RELATION
, CSS.LINE_4_ATTEND_COLLEGE
, CSS.LINE_5_RELATION
, CSS.LINE_5_ATTEND_COLLEGE
, CSS.LINE_6_RELATION
, CSS.LINE_6_ATTEND_COLLEGE
, CSS.LINE_7_RELATION
, CSS.LINE_7_ATTEND_COLLEGE
, CSS.LINE_8_RELATION
, CSS.LINE_8_ATTEND_COLLEGE
, CSS.P_AGE_FATHER
, CSS.P_AGE_MOTHER
, CSS.P_DIV_SEP_IND
, CSS.B_CONT_NON_CUSTODIAL_PAR
, CSS.COLLEGE_TYPE_2
, CSS.COLLEGE_TYPE_3
, CSS.COLLEGE_TYPE_4
, CSS.COLLEGE_TYPE_5
, CSS.COLLEGE_TYPE_6
, CSS.COLLEGE_TYPE_7
, CSS.COLLEGE_TYPE_8
, CSS.SCHOOL_CODE_1
, CSS.HOUSING_CODE_1
, CSS.SCHOOL_CODE_2
, CSS.HOUSING_CODE_2
, CSS.SCHOOL_CODE_3
, CSS.HOUSING_CODE_3
, CSS.SCHOOL_CODE_4
, CSS.HOUSING_CODE_4
, CSS.SCHOOL_CODE_5
, CSS.HOUSING_CODE_5
, CSS.SCHOOL_CODE_6
, CSS.HOUSING_CODE_6
, CSS.SCHOOL_CODE_7
, CSS.HOUSING_CODE_7
, CSS.SCHOOL_CODE_8
, CSS.HOUSING_CODE_8
, CSS.SCHOOL_CODE_9
, CSS.HOUSING_CODE_9
, CSS.SCHOOL_CODE_10
, CSS.HOUSING_CODE_10
, CSS.ADDITIONAL_SCHOOL_CODE_1
, CSS.ADDITIONAL_SCHOOL_CODE_2
, CSS.ADDITIONAL_SCHOOL_CODE_3
, CSS.ADDITIONAL_SCHOOL_CODE_4
, CSS.ADDITIONAL_SCHOOL_CODE_5
, CSS.ADDITIONAL_SCHOOL_CODE_6
, CSS.ADDITIONAL_SCHOOL_CODE_7
, CSS.ADDITIONAL_SCHOOL_CODE_8
, CSS.ADDITIONAL_SCHOOL_CODE_9
, CSS.ADDITIONAL_SCHOOL_CODE_10
, CSS.EXPLANATION_SPEC_CIRCUM
, CSS.SIGNATURE_STUDENT
, CSS.SIGNATURE_SPOUSE
, CSS.SIGNATURE_FATHER
, CSS.SIGNATURE_MOTHER
, CSS.MONTH_DAY_COMPLETED
, CSS.YEAR_COMPLETED
, CSS.AGE_LINE_2
, CSS.AGE_LINE_3
, CSS.AGE_LINE_4
, CSS.AGE_LINE_5
, CSS.AGE_LINE_6
, CSS.AGE_LINE_7
, CSS.AGE_LINE_8
, CSS.A_ONLINE_SIGNATURE
, CSS.QUESTION_1_NUMBER
, CSS.QUESTION_1_SIZE
, CSS.QUESTION_1_ANSWER
, CSS.QUESTION_2_NUMBER
, CSS.QUESTION_2_SIZE
, CSS.QUESTION_2_ANSWER
, CSS.QUESTION_3_NUMBER
, CSS.QUESTION_3_SIZE
, CSS.QUESTION_3_ANSWER
, CSS.QUESTION_4_NUMBER
, CSS.QUESTION_4_SIZE
, CSS.QUESTION_4_ANSWER
, CSS.QUESTION_5_NUMBER
, CSS.QUESTION_5_SIZE
, CSS.QUESTION_5_ANSWER
, CSS.QUESTION_6_NUMBER
, CSS.QUESTION_6_SIZE
, CSS.QUESTION_6_ANSWER
, CSS.QUESTION_7_NUMBER
, CSS.QUESTION_7_SIZE
, CSS.QUESTION_7_ANSWER
, CSS.QUESTION_8_NUMBER
, CSS.QUESTION_8_SIZE
, CSS.QUESTION_8_ANSWER
, CSS.QUESTION_9_NUMBER
, CSS.QUESTION_9_SIZE
, CSS.QUESTION_9_ANSWER
, CSS.QUESTION_10_NUMBER
, CSS.QUESTION_10_SIZE
, CSS.QUESTION_10_ANSWER
, CSS.QUESTION_11_NUMBER
, CSS.QUESTION_11_SIZE
, CSS.QUESTION_11_ANSWER
, CSS.QUESTION_12_NUMBER
, CSS.QUESTION_12_SIZE
, CSS.QUESTION_12_ANSWER
, CSS.QUESTION_13_NUMBER
, CSS.QUESTION_13_SIZE
, CSS.QUESTION_13_ANSWER
, CSS.QUESTION_14_NUMBER
, CSS.QUESTION_14_SIZE
, CSS.QUESTION_14_ANSWER
, CSS.QUESTION_15_NUMBER
, CSS.QUESTION_15_SIZE
, CSS.QUESTION_15_ANSWER
, CSS.QUESTION_16_NUMBER
, CSS.QUESTION_16_SIZE
, CSS.QUESTION_16_ANSWER
, CSS.QUESTION_17_NUMBER
, CSS.QUESTION_17_SIZE
, CSS.QUESTION_17_ANSWER
, CSS.QUESTION_18_NUMBER
, CSS.QUESTION_18_SIZE
, CSS.QUESTION_18_ANSWER
, CSS.QUESTION_19_NUMBER
, CSS.QUESTION_19_SIZE
, CSS.QUESTION_19_ANSWER
, CSS.QUESTION_20_NUMBER
, CSS.QUESTION_20_SIZE
, CSS.QUESTION_20_ANSWER
, CSS.QUESTION_21_NUMBER
, CSS.QUESTION_21_SIZE
, CSS.QUESTION_21_ANSWER
, CSS.QUESTION_22_NUMBER
, CSS.QUESTION_22_SIZE
, CSS.QUESTION_22_ANSWER
, CSS.QUESTION_23_NUMBER
, CSS.QUESTION_23_SIZE
, CSS.QUESTION_23_ANSWER
, CSS.QUESTION_24_NUMBER
, CSS.QUESTION_24_SIZE
, CSS.QUESTION_24_ANSWER
, CSS.QUESTION_25_NUMBER
, CSS.QUESTION_25_SIZE
, CSS.QUESTION_25_ANSWER
, CSS.QUESTION_26_NUMBER
, CSS.QUESTION_26_SIZE
, CSS.QUESTION_26_ANSWER
, CSS.QUESTION_27_NUMBER
, CSS.QUESTION_27_SIZE
, CSS.QUESTION_27_ANSWER
, CSS.QUESTION_28_NUMBER
, CSS.QUESTION_28_SIZE
, CSS.QUESTION_28_ANSWER
, CSS.QUESTION_29_NUMBER
, CSS.QUESTION_29_SIZE
, CSS.QUESTION_29_ANSWER
, CSS.QUESTION_30_NUMBER
, CSS.QUESTIONS_30_SIZE
, CSS.QUESTION_30_ANSWER
, CSS.CREATION_DATE
, CSS.CREATED_BY
, CSS.LAST_UPDATE_DATE
, CSS.LAST_UPDATED_BY
, CSS.LAST_UPDATE_LOGIN
, FARV.PROFILE_STATUS
, FARV.PROFILE_STATUS_DATE
, FARV.PROFILE_FC
, FNAR.COMP_CSS_DEPENDENCY_STATUS
, CSS.SYSTEM_RECORD_TYPE
, CSS.LEGACY_RECORD_FLAG
, CSS.COA_DURATION_EFC_AMT
, CSS.COA_DURATION_NUM
, CSS.P_SOC_SEC_BEN_STUDENT_AMT
, CSS.P_TUIT_FEE_DEDUCT_AMT
, CSS.STU_LIVES_WITH_NUM
, CSS.STU_MOST_SUPPORT_FROM_NUM
, CSS.LOCATION_COMPUTER_NUM
FROM IGF_AP_CSS_PROFILE CSS
, IGF_AP_FA_BASE_REC FARV
, IGF_AP_CSS_FNAR FNAR
WHERE CSS.BASE_ID = FARV.BASE_ID
AND CSS.CSSP_ID = FNAR.CSSP_ID

Columns