[Home] [Help]
| Product: | IGF - Financial Aid (Obsolete) |
|---|---|
| Description: | This view is obsolete now. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT FAH.ROW_ID
, FAH.FABH_ID
, FAH.BASE_ID
, FAH.PERSON_ID
, FAH.PRIMARY_REC
, FAH.REC_LAST_UPDATED
, FAH.ENCUMBRANCE_TYPE
, FIEN.DESCRIPTION
, FAH.VISA_TYPE
, FAH.CITIZENSHIP_STATUS
, FAH.RESIDENCY_STATUS
, FAH.MIL_SERVICE_TYPE
, FAH.ADMISSION_APPL_NUMBER
, FAH.ADM_APPL_STATUS
, FAH.S_ADM_APPL_STATUS
, FAH.APPL_DT
, FAH.CLASS_STANDING
, FAH.PERSON_TYPE
, FAH.CUR_ENROL_CREDIT_POINTS
, FAH.ADMISSION_CAT
, FAH.S_ADMISSION_PROCESS_TYPE
, FAH.PROG_ATT_COURSE_CD||' '||TO_CHAR(FAH.PROG_ATT_VER_NUM)
, FAH.PROG_ATT_COURSE_CD
, FAH.PROG_ATT_VER_NUM
, FAH.PROG_ATT_ATTEND_MODE
, FAH.PROG_ATT_ATTEND_TYPE
, FAH.ADM_ORG_UNIT_CD
, FAH.ADM_OUTCOME_STATUS
, FAH.S_ADM_OUTCOME_STATUS
, FAH.DECISION_DATE
, FAH.ADM_OFFER_RESP_STATUS
, FAH.S_ADM_OFFER_RESP_STATUS
, FAH.ACTUAL_RESPONSE_DATE
, FAH.ADM_FEE_STATUS
, FAH.S_ADM_FEE_STATUS
, FAH.SP_PROGRAM_1
, FAH.SP_PROGRAM_2
, FAH.ENTRY_LEVEL
, FAH.ANTICIP_COMPL_DATE
, FAH.ATHLETIC_SPORT_ID
, FAH.ATHELETIC_SPORT
, FAH.ACADEMIC_INDEX
, FAH.FINAL_UNIT_SET_COURSE_CD||' '||TO_CHAR(FAH.FINAL_UNIT_SET_VER_NUM)
, FAH.FINAL_UNIT_SET_COURSE_CD
, FAH.FINAL_UNIT_SET_VER_NUM
, FAH.PROG_ATT_START_DT
, FAH.TRANSFERED
, FAH.ATB
, CA.ALTERNATE_CODE
, FAH.ENRL_LOAD_CAL_TYPE
, FAH.ENRL_LOAD_SEQ_NUM
, FAH.SAP_EVALUATION_DATE
, FAH.SAP_SELECTED_FLAG
, FAH.ENRL_PRIMARY_PROG_COURSE_CD||' '||FAH.ENRL_PRIMARY_PROG_VER_NUM
, FAH.ENRL_PRIMARY_PROG_COURSE_CD
, FAH.ENRL_PRIMARY_PROG_VER_NUM
, FAH.ENRL_PROGRAM_TYPE
, FAH.ENRL_USET_COURSE_CD||' '||FAH.ENRL_USET_VER_NUM
, FAH.ENRL_USET_COURSE_CD
, FAH.ENRL_USET_VER_NUM
, FAH.ENRL_COURSE_ATTEMPT_STATUS
, FAH.DERIVED_ATTEND_TYPE
, FAH.CURRENT_GPA
, FAH.CUMULATIVE_GPA
, FAH.ACHEIVED_CR_PTS
, FAH.PRED_CLASS_STANDING
, FAH.ENRL_ORG_UNIT_CD
, FAH.ENRL_ATTEND_MODE
, FAH.ENRL_LOCATION_CD
, FAH.ENRL_TOTAL_CP
, FAH.ENRL_CUML_CP
, FAH.ENRL_CUML_TRANS_CP
, FAH.ORG_ID
, FAH.CREATED_BY
, FAH.CREATION_DATE
, FAH.LAST_UPDATED_BY
, FAH.LAST_UPDATE_DATE
, FAH.LAST_UPDATE_LOGIN
, FAH.REQUEST_ID
, FAH.PROGRAM_APPLICATION_ID
, FAH.PROGRAM_ID
, FAH.PROGRAM_UPDATE_DATE
, FAH.KEY_PROGRAM
FROM IGF_AP_FA_BASE_H FAH
, IGS_FI_ENCMB_TYPE FIEN
, IGS_CA_INST CA
WHERE FAH.ENCUMBRANCE_TYPE = FIEN.ENCUMBRANCE_TYPE(+)
AND FAH.ENRL_LOAD_CAL_TYPE = CA.CAL_TYPE(+)
AND FAH.ENRL_LOAD_SEQ_NUM = CA.SEQUENCE_NUMBER(+)