VIEW: APPS.IGF_GR_RFMS_V

Source

View Text - Preformatted

SELECT RFMS.ROW_ID, RFMS.ORIGINATION_ID, RFMS.CI_CAL_TYPE, RFMS.CI_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT, RFMS.SYS_ORIG_SSN, RFMS.SYS_ORIG_NAME_CD, RFMS.TRANSACTION_NUM, ISIR.ORIGINAL_SSN||ISIR.ORIG_NAME_ID||ISIR.TRANSACTION_NUM TRANSACTION_NUM_DESC, RFMS.EFC, RFMS.VER_STATUS_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_VER_STAT_CD',RFMS.VER_STATUS_CODE), RFMS.SECONDARY_EFC, RFMS.SECONDARY_EFC_CD, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_SEC_EFC_CD',RFMS.SECONDARY_EFC_CD), RFMS.PELL_AMOUNT, NULL, RFMS.ENROLLMENT_STATUS, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_RFMS_ENROL_STAT',RFMS.ENROLLMENT_STATUS), RFMS.ENROLLMENT_DT, RFMS.COA_AMOUNT, RFMS.ACADEMIC_CALENDAR, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_ACAD_CAL',RFMS.ACADEMIC_CALENDAR), RFMS.PAYMENT_METHOD, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PAYMENT_METHOD',RFMS.PAYMENT_METHOD), RFMS.TOTAL_PYMT_PRDS, RFMS.INCRCD_FED_PELL_RCP_CD, RFMS.ATTENDING_CAMPUS_ID, RFMS.EST_DISB_DT1, RFMS.ORIG_ACTION_CODE, RFMS.ORIG_STATUS_DT, RFMS.ORIG_ED_USE_FLAGS, RFMS.FT_PELL_AMOUNT, RFMS.PREV_ACCPT_EFC, RFMS.PREV_ACCPT_TRAN_NO, RFMS.PREV_ACCPT_SEC_EFC_CD, RFMS.PREV_ACCPT_COA, RFMS.ORIG_REJECT_CODE, RFMS.WK_INST_TIME_CALC_PYMT, RFMS.WK_INT_TIME_PRG_DEF_YR, RFMS.CR_CLK_HRS_PRDS_SCH_YR, RFMS.CR_CLK_HRS_ACAD_YR, RFMS.INST_CROSS_REF_CD, RFMS.LOW_TUTION_FEE, RFMS.BASE_ID, RFMS.AWARD_ID, RFMS.RFMB_ID, RFMS.REP_PELL_ID, RFMB.BATCH_ID, RFMB.RFMS_PROCESS_DT, RFMS.REC_SOURCE, RFMS.CREATED_BY, RFMS.CREATION_DATE, RFMS.LAST_UPDATED_BY, RFMS.LAST_UPDATE_DATE, RFMS.LAST_UPDATE_LOGIN, RFMS.PROGRAM_APPLICATION_ID, RFMS.PROGRAM_ID, RFMS.PROGRAM_UPDATE_DATE, RFMS.REQUEST_ID, RFMS.FIRST_NAME, RFMS.MIDDLE_NAME, RFMS.LAST_NAME, RFMS.BIRTH_DT, RFMS.PENDING_AMOUNT, PE.PERSON_NUMBER, PE.FIRST_NAME || ','|| PE.LAST_NAME, RFMS.CURRENT_SSN, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_ORIG_STATUS',RFMS.ORIG_ACTION_CODE), IGF_AW_GEN.LOOKUP_DESC('IGF_GR_STU_INCARCE_STATUS',RFMS.INCRCD_FED_PELL_RCP_CD) ,rfms.legacy_record_flag ,RFMS.DOCUMENT_ID_TXT ,RFMS.REP_ENTITY_ID_TXT ,RFMS.ATD_ENTITY_ID_TXT ,RFMS.NOTE_MESSAGE ,RFMS.FULL_RESP_CODE ,PE.PERSON_ID FROM IGF_GR_RFMS RFMS, IGS_CA_INST CI, IGF_GR_PERSON_V PE, IGF_GR_RFMS_BATCH RFMB, igf_aw_award awd, IGF_AP_ISIR_MATCHED ISIR WHERE RFMS.CI_CAL_TYPE = CI.CAL_TYPE AND RFMS.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND RFMS.BASE_ID = PE.BASE_ID AND RFMS.RFMB_ID = RFMB.RFMB_ID(+) AND RFMS.AWARD_ID = AWD.AWARD_ID AND ISIR.BASE_ID = RFMS.BASE_ID AND ISIR.TRANSACTION_NUM = RFMS.TRANSACTION_NUM AND ISIR.SYSTEM_RECORD_TYPE = 'ORIGINAL'

View Text - HTML Formatted

SELECT RFMS.ROW_ID
, RFMS.ORIGINATION_ID
, RFMS.CI_CAL_TYPE
, RFMS.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, RFMS.SYS_ORIG_SSN
, RFMS.SYS_ORIG_NAME_CD
, RFMS.TRANSACTION_NUM
, ISIR.ORIGINAL_SSN||ISIR.ORIG_NAME_ID||ISIR.TRANSACTION_NUM TRANSACTION_NUM_DESC
, RFMS.EFC
, RFMS.VER_STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_VER_STAT_CD'
, RFMS.VER_STATUS_CODE)
, RFMS.SECONDARY_EFC
, RFMS.SECONDARY_EFC_CD
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_SEC_EFC_CD'
, RFMS.SECONDARY_EFC_CD)
, RFMS.PELL_AMOUNT
, NULL
, RFMS.ENROLLMENT_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_RFMS_ENROL_STAT'
, RFMS.ENROLLMENT_STATUS)
, RFMS.ENROLLMENT_DT
, RFMS.COA_AMOUNT
, RFMS.ACADEMIC_CALENDAR
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_ACAD_CAL'
, RFMS.ACADEMIC_CALENDAR)
, RFMS.PAYMENT_METHOD
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PAYMENT_METHOD'
, RFMS.PAYMENT_METHOD)
, RFMS.TOTAL_PYMT_PRDS
, RFMS.INCRCD_FED_PELL_RCP_CD
, RFMS.ATTENDING_CAMPUS_ID
, RFMS.EST_DISB_DT1
, RFMS.ORIG_ACTION_CODE
, RFMS.ORIG_STATUS_DT
, RFMS.ORIG_ED_USE_FLAGS
, RFMS.FT_PELL_AMOUNT
, RFMS.PREV_ACCPT_EFC
, RFMS.PREV_ACCPT_TRAN_NO
, RFMS.PREV_ACCPT_SEC_EFC_CD
, RFMS.PREV_ACCPT_COA
, RFMS.ORIG_REJECT_CODE
, RFMS.WK_INST_TIME_CALC_PYMT
, RFMS.WK_INT_TIME_PRG_DEF_YR
, RFMS.CR_CLK_HRS_PRDS_SCH_YR
, RFMS.CR_CLK_HRS_ACAD_YR
, RFMS.INST_CROSS_REF_CD
, RFMS.LOW_TUTION_FEE
, RFMS.BASE_ID
, RFMS.AWARD_ID
, RFMS.RFMB_ID
, RFMS.REP_PELL_ID
, RFMB.BATCH_ID
, RFMB.RFMS_PROCESS_DT
, RFMS.REC_SOURCE
, RFMS.CREATED_BY
, RFMS.CREATION_DATE
, RFMS.LAST_UPDATED_BY
, RFMS.LAST_UPDATE_DATE
, RFMS.LAST_UPDATE_LOGIN
, RFMS.PROGRAM_APPLICATION_ID
, RFMS.PROGRAM_ID
, RFMS.PROGRAM_UPDATE_DATE
, RFMS.REQUEST_ID
, RFMS.FIRST_NAME
, RFMS.MIDDLE_NAME
, RFMS.LAST_NAME
, RFMS.BIRTH_DT
, RFMS.PENDING_AMOUNT
, PE.PERSON_NUMBER
, PE.FIRST_NAME || '
, '|| PE.LAST_NAME
, RFMS.CURRENT_SSN
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_ORIG_STATUS'
, RFMS.ORIG_ACTION_CODE)
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_STU_INCARCE_STATUS'
, RFMS.INCRCD_FED_PELL_RCP_CD)
, RFMS.LEGACY_RECORD_FLAG
, RFMS.DOCUMENT_ID_TXT
, RFMS.REP_ENTITY_ID_TXT
, RFMS.ATD_ENTITY_ID_TXT
, RFMS.NOTE_MESSAGE
, RFMS.FULL_RESP_CODE
, PE.PERSON_ID
FROM IGF_GR_RFMS RFMS
, IGS_CA_INST CI
, IGF_GR_PERSON_V PE
, IGF_GR_RFMS_BATCH RFMB
, IGF_AW_AWARD AWD
, IGF_AP_ISIR_MATCHED ISIR
WHERE RFMS.CI_CAL_TYPE = CI.CAL_TYPE
AND RFMS.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND RFMS.BASE_ID = PE.BASE_ID
AND RFMS.RFMB_ID = RFMB.RFMB_ID(+)
AND RFMS.AWARD_ID = AWD.AWARD_ID
AND ISIR.BASE_ID = RFMS.BASE_ID
AND ISIR.TRANSACTION_NUM = RFMS.TRANSACTION_NUM
AND ISIR.SYSTEM_RECORD_TYPE = 'ORIGINAL'