VIEW: APPS.IGSBV_AD_ADM_PS_APPL_INST

Source

View Text - Preformatted

SELECT apd.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, apd.ADMISSION_APPL_NUMBER, apd.NOMINATED_COURSE_CD, psv.TITLE, apd.SEQUENCE_NUMBER, apd.PREDICTED_GPA, apd.ACADEMIC_INDEX, apd.ADM_CAL_TYPE, apd.ADM_CI_SEQUENCE_NUMBER, apd.APP_FILE_LOCATION, apd.APP_SOURCE_ID, apd.course_cd, apd.CRV_VERSION_NUMBER, apd.WAITLIST_RANK, apd.LOCATION_CD, apd.ATTENT_OTHER_INST_CD, apd.ATTENDANCE_MODE, apd.EDU_GOAL_PRIOR_ENROLL_ID, apd.ATTENDANCE_TYPE, apd.DECISION_MAKE_ID, apd.UNIT_SET_CD, apd.DECISION_DATE, '_DF:IGS:IGS_AD_APPL_INST_FLEX:apd', apd.DECISION_REASON_ID, apd.US_VERSION_NUMBER, apd.DECISION_NOTES , apd.PENDING_REASON_ID, apd.PREFERENCE_NUMBER, apd.ADM_DOC_STATUS, apd.ADM_ENTRY_QUAL_STATUS, apd.DEFICIENCY_IN_PREP, apd.LATE_ADM_FEE_STATUS, apd.SPL_CONSIDER_COMMENTS, '_LA:apd.APPLY_FOR_FINAID:IGS_LOOKUP_VALUES:YES_NO:MEANING', apd.FINAID_APPLY_DATE, apd.ADM_OUTCOME_STATUS, apd.ADM_OTCM_STATUS_AUTH_PERSON_ID, apd.ADM_OUTCOME_STATUS_AUTH_DT, apd.ADM_OUTCOME_STATUS_REASON, apd.OFFER_DT, apd.OFFER_RESPONSE_DT, apd.PRPSD_COMMENCEMENT_DT, apd.ADM_CNDTNL_OFFER_STATUS, apd.CNDTNL_OFFER_CNDTN, apd.CNDTNL_OFFER_SATISFIED_DT, '_LA:apd.CNDTNL_OFFER_MUST_BE_STSFD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', apd.ADM_OFFER_RESP_STATUS, apd.ACTUAL_RESPONSE_DT, apd.ADM_OFFER_DFRMNT_STATUS, apd.DEFERRED_ADM_CAL_TYPE, apd.DEFERRED_ADM_CI_SEQUENCE_NUM, apd.DEFERRED_TRACKING_ID, apd.ASS_RANK, apd.SECONDARY_ASS_RANK, apd.INTRNTNL_ACCEPTANCE_ADVICE_NUM, apd.ASS_TRACKING_ID, apd.FEE_CAT, apd.HECS_PAYMENT_OPTION, apd.EXPECTED_COMPLETION_YR, apd.EXPECTED_COMPLETION_PERD, apd.CORRESPONDENCE_CAT, apd.ENROLMENT_CAT, apd.FUNDING_SOURCE, apd.APPLICANT_ACPTNCE_CNDTN, apd.SS_APPLICATION_ID, apd.SS_PWD, apd.ENTRY_STATUS, apd.ENTRY_LEVEL, apd.SCH_APL_TO_ID, apd.AUTHORIZED_DT, apd.AUTHORIZING_PERS_ID, apd.IDX_CALC_DATE, '_LA:apd.WAITLIST_STATUS:IGS_LOOKUP_VALUES:ADM_WAITLIST_STATUS:MEANING', apd.FUTURE_ACAD_CAL_TYPE, apd.FUTURE_ACAD_CI_SEQUENCE_NUMBER, apd.FUTURE_ADM_CAL_TYPE, apd.FUTURE_ADM_CI_SEQUENCE_NUMBER, apd.PREVIOUS_TERM_ADM_APPL_NUMBER, apd.PREVIOUS_TERM_SEQUENCE_NUMBER, apd.FUTURE_TERM_ADM_APPL_NUMBER, apd.FUTURE_TERM_SEQUENCE_NUMBER, apd.DEF_ACAD_CAL_TYPE, apd.DEF_ACAD_CI_SEQUENCE_NUM, apd.DEF_PREV_TERM_ADM_APPL_NUM, apd.DEF_PREV_APPL_SEQUENCE_NUM, apd.DEF_TERM_ADM_APPL_NUM, apd.DEF_APPL_SEQUENCE_NUM, apd.CREATED_BY, apd.CREATION_DATE, apd.LAST_UPDATED_BY, apd.LAST_UPDATE_DATE, apd.APPL_INST_STATUS, apd.AIS_REASON AIS_REASON_CODE, '_LA:apd.AIS_REASON:IGS_LOOKUP_VALUES:IGS_AD_WITHDRAW_RSN:MEANING' "_LA:AIS_REASON", apd.DECLINE_OFR_REASON DECLINE_OFR_REASON_CODE, '_LA:apd.DECLINE_OFR_REASON:IGS_LOOKUP_VALUES:IGS_AD_DECL_OFR_REAS:MEANING' "_LA:DECLINE_OFR_REASON" FROM igs_ad_ps_appl_inst_all apd, HZ_PARTIES P, HZ_PERSON_PROFILES PP, IGS_PS_VER_ALL psv WHERE apd.NOMINATED_COURSE_CD = psv.COURSE_CD AND apd.CRV_VERSION_NUMBER = psv.VERSION_NUMBER AND apd.PERSON_ID = p.PARTY_ID AND P.PARTY_ID = PP.PARTY_ID AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED' AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE,SYSDATE) WITH READ ONLY

View Text - HTML Formatted

SELECT APD.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APD.ADMISSION_APPL_NUMBER
, APD.NOMINATED_COURSE_CD
, PSV.TITLE
, APD.SEQUENCE_NUMBER
, APD.PREDICTED_GPA
, APD.ACADEMIC_INDEX
, APD.ADM_CAL_TYPE
, APD.ADM_CI_SEQUENCE_NUMBER
, APD.APP_FILE_LOCATION
, APD.APP_SOURCE_ID
, APD.COURSE_CD
, APD.CRV_VERSION_NUMBER
, APD.WAITLIST_RANK
, APD.LOCATION_CD
, APD.ATTENT_OTHER_INST_CD
, APD.ATTENDANCE_MODE
, APD.EDU_GOAL_PRIOR_ENROLL_ID
, APD.ATTENDANCE_TYPE
, APD.DECISION_MAKE_ID
, APD.UNIT_SET_CD
, APD.DECISION_DATE
, '_DF:IGS:IGS_AD_APPL_INST_FLEX:APD'
, APD.DECISION_REASON_ID
, APD.US_VERSION_NUMBER
, APD.DECISION_NOTES
, APD.PENDING_REASON_ID
, APD.PREFERENCE_NUMBER
, APD.ADM_DOC_STATUS
, APD.ADM_ENTRY_QUAL_STATUS
, APD.DEFICIENCY_IN_PREP
, APD.LATE_ADM_FEE_STATUS
, APD.SPL_CONSIDER_COMMENTS
, '_LA:APD.APPLY_FOR_FINAID:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APD.FINAID_APPLY_DATE
, APD.ADM_OUTCOME_STATUS
, APD.ADM_OTCM_STATUS_AUTH_PERSON_ID
, APD.ADM_OUTCOME_STATUS_AUTH_DT
, APD.ADM_OUTCOME_STATUS_REASON
, APD.OFFER_DT
, APD.OFFER_RESPONSE_DT
, APD.PRPSD_COMMENCEMENT_DT
, APD.ADM_CNDTNL_OFFER_STATUS
, APD.CNDTNL_OFFER_CNDTN
, APD.CNDTNL_OFFER_SATISFIED_DT
, '_LA:APD.CNDTNL_OFFER_MUST_BE_STSFD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APD.ADM_OFFER_RESP_STATUS
, APD.ACTUAL_RESPONSE_DT
, APD.ADM_OFFER_DFRMNT_STATUS
, APD.DEFERRED_ADM_CAL_TYPE
, APD.DEFERRED_ADM_CI_SEQUENCE_NUM
, APD.DEFERRED_TRACKING_ID
, APD.ASS_RANK
, APD.SECONDARY_ASS_RANK
, APD.INTRNTNL_ACCEPTANCE_ADVICE_NUM
, APD.ASS_TRACKING_ID
, APD.FEE_CAT
, APD.HECS_PAYMENT_OPTION
, APD.EXPECTED_COMPLETION_YR
, APD.EXPECTED_COMPLETION_PERD
, APD.CORRESPONDENCE_CAT
, APD.ENROLMENT_CAT
, APD.FUNDING_SOURCE
, APD.APPLICANT_ACPTNCE_CNDTN
, APD.SS_APPLICATION_ID
, APD.SS_PWD
, APD.ENTRY_STATUS
, APD.ENTRY_LEVEL
, APD.SCH_APL_TO_ID
, APD.AUTHORIZED_DT
, APD.AUTHORIZING_PERS_ID
, APD.IDX_CALC_DATE
, '_LA:APD.WAITLIST_STATUS:IGS_LOOKUP_VALUES:ADM_WAITLIST_STATUS:MEANING'
, APD.FUTURE_ACAD_CAL_TYPE
, APD.FUTURE_ACAD_CI_SEQUENCE_NUMBER
, APD.FUTURE_ADM_CAL_TYPE
, APD.FUTURE_ADM_CI_SEQUENCE_NUMBER
, APD.PREVIOUS_TERM_ADM_APPL_NUMBER
, APD.PREVIOUS_TERM_SEQUENCE_NUMBER
, APD.FUTURE_TERM_ADM_APPL_NUMBER
, APD.FUTURE_TERM_SEQUENCE_NUMBER
, APD.DEF_ACAD_CAL_TYPE
, APD.DEF_ACAD_CI_SEQUENCE_NUM
, APD.DEF_PREV_TERM_ADM_APPL_NUM
, APD.DEF_PREV_APPL_SEQUENCE_NUM
, APD.DEF_TERM_ADM_APPL_NUM
, APD.DEF_APPL_SEQUENCE_NUM
, APD.CREATED_BY
, APD.CREATION_DATE
, APD.LAST_UPDATED_BY
, APD.LAST_UPDATE_DATE
, APD.APPL_INST_STATUS
, APD.AIS_REASON AIS_REASON_CODE
, '_LA:APD.AIS_REASON:IGS_LOOKUP_VALUES:IGS_AD_WITHDRAW_RSN:MEANING' "_LA:AIS_REASON"
, APD.DECLINE_OFR_REASON DECLINE_OFR_REASON_CODE
, '_LA:APD.DECLINE_OFR_REASON:IGS_LOOKUP_VALUES:IGS_AD_DECL_OFR_REAS:MEANING' "_LA:DECLINE_OFR_REASON"
FROM IGS_AD_PS_APPL_INST_ALL APD
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_PS_VER_ALL PSV
WHERE APD.NOMINATED_COURSE_CD = PSV.COURSE_CD
AND APD.CRV_VERSION_NUMBER = PSV.VERSION_NUMBER
AND APD.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY