VIEW: APPS.IGSFV_UC_APPLICANT_CHOICES

Source

View Text - Preformatted

SELECT CH.APP_CHOICE_ID APPLICANT_CHOICE_ID, CH.APP_ID APPLICANT_ID, CH.APP_NO APPLICANT_UCAS_NUMBER, CH.CHOICE_NO APPLICANT_CHOICE_NUMBER, CH.UCAS_CYCLE UCAS_CYCLE, CH.LAST_CHANGE DATE_OF_LAST_CHANGE, CH.INSTITUTE_CODE UCAS_INSTITUTE_CODE, CH.UCAS_PROGRAM_CODE UCAS_PROGRAM_CODE, CH.OSS_PROGRAM_CODE OSS_PROGRAM_CODE, CH.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION, CH.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE, CH.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE, CH.CAMPUS UCAS_CAMPUS, CH.OSS_LOCATION OSS_LOCATION, CH.FACULTY UCAS_FACULTY, CH.ENTRY_YEAR ENTRY_YEAR, CH.ENTRY_MONTH ENTRY_MONTH, CH.POINT_OF_ENTRY POINT_OF_ENTRY, CH.HOME HOME_FLAG, CH.DEFERRED DEFERRED_FLAG, CH.ROUTE_B_PREF_ROUND ROUTE_B_PREFERENCE_ROUND_FLAG, CH.ROUTE_B_ACTUAL_ROUND ROUTE_B_ACTUAL_ROUND_FLAG, CH.CONDITION_CATEGORY CONDITION_CATEGORY, CH.CONDITION_CODE CONDITION_CODE, CH.DECISION DECISION, CH.DECISION_DATE DECISION_DATE, CH.DECISION_NUMBER DECISION_NUMBER, CH.REPLY REPLY, CH.SUMMARY_OF_COND SUMMARY_OF_CONDITIONS, CH.CHOICE_CANCELLED CHOICE_CANCELLED_FLAG, CH.ACTION ACTION, CH.SUBSTITUTION SUBSTITUTION, CH.DATE_SUBSTITUTED SUBSTITUTED_DATE, CH.PREV_INSTITUTION PREVIOUS_INSTITUTION, CH.PREV_COURSE PREVIOUS_COURSE, CH.PREV_CAMPUS PREVIOUS_CAMPUS, CH.UCAS_AMENDMENT UCAS_AMENDMENT, CH.WITHDRAWAL_REASON WITHDRAWAL_REASON, CH.OFFER_COURSE OFFERED_COURSE, CH.OFFER_CAMPUS OFFERED_CAMPUS, CH.OFFER_CRSE_LENGTH OFFERED_COURSE_LENGTH, CH.OFFER_ENTRY_MONTH OFFERED_ENTRY_MONTH, CH.OFFER_ENTRY_YEAR OFFERED_ENTRY_YEAR, CH.OFFER_ENTRY_POINT OFFERED_ENTRY_POINT, CH.OFFER_TEXT OFFERED_TEXT, CH.EXPORT_TO_OSS_STATUS EXPORT_TO_OSS_STATUS, CH.ERROR_CODE EXPORT_PROCESS_ERROR_CODE, CH.BATCH_ID ADM_IMPORT_PROCESS_BATCH_ID, CH.EXTRA_ROUND_NBR EXTRA_ROUND_NUMBER, CH.SYSTEM_CODE UCAS_SYSTEM_CODE, CH.PART_TIME GTTR_PART_TIME, CH.INTERVIEW GTTR_INTERVIEW_DATE, CH.LATE_APPLICATION GTTR_LATE_APPLICATION_FLAG, CH.MODULAR GTTR_MODULAR_FLAG, CH.RESIDENTIAL NMAS_RESIDENTIAL_FLAG, DE.NAME UCAS_SYSTEM_NAME, DE.DESCRIPTION UCAS_SYSTEM_DESCRIPTION, IN1.INST_CODE UCAS_INSTITUTION_ABBREVIATION, IN1.INST_NAME UCAS_INSTITUTION_NAME, VE.TITLE OSS_PROGRAM_TITLE, VE.SHORT_TITLE OSS_PROGRAM_SHORT_TITLE, TY.DESCRIPTION OSS_ATTENDANCE_TYPE_DESC, MO.DESCRIPTION OSS_ATTENDANCE_MODE_DESC, CR1.SHORT_TITLE UCAS_COURSE_SHORT_TITLE, IN2.INST_NAME PREVIOUS_INSTITUTION_NAME, CR2.SHORT_TITLE PREVIOUS_UCAS_COURSE_TITLE, HZ.PARTY_NUMBER OSS_PERSON_NUMBER, HZ.PARTY_NAME OSS_PERSON_NAME, CH.CREATED_BY CREATED_BY, CH.CREATION_DATE CREATION_DATE, CH.LAST_UPDATED_BY LAST_UPDATED_BY, CH.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_UC_APP_CHOICES CH, IGS_UC_DEFAULTS DE, IGS_UC_COM_INST IN1, IGS_PS_VER_ALL VE, IGS_EN_ATD_TYPE_ALL TY, IGS_EN_ATD_MODE_ALL MO, IGS_UC_COM_INST IN2, IGS_UC_CRSE_DETS CR1, IGS_UC_CRSE_DETS CR2, HZ_PARTIES HZ, IGS_UC_APPLICANTS AP WHERE CH.SYSTEM_CODE = DE.SYSTEM_CODE AND CH.INSTITUTE_CODE = IN1.INST AND CH.OSS_PROGRAM_CODE = VE.COURSE_CD (+) AND CH.OSS_PROGRAM_VERSION = VE.VERSION_NUMBER (+) AND CH.OSS_ATTENDANCE_TYPE = TY.ATTENDANCE_TYPE (+) AND CH.OSS_ATTENDANCE_MODE = MO.ATTENDANCE_MODE (+) AND CH.UCAS_PROGRAM_CODE = CR1.UCAS_PROGRAM_CODE (+) AND CH.CAMPUS = CR1.UCAS_CAMPUS (+) AND CH.INSTITUTE_CODE = CR1.INSTITUTE (+) AND CH.SYSTEM_CODE = CR1.SYSTEM_CODE (+) AND CH.PREV_COURSE = CR2.UCAS_PROGRAM_CODE (+) AND CH.PREV_CAMPUS = CR2.UCAS_CAMPUS (+) AND CH.PREV_INSTITUTION = CR2.INSTITUTE (+) AND CH.SYSTEM_CODE = CR2.SYSTEM_CODE (+) AND CH.PREV_INSTITUTION = IN2.INST (+) AND CH.APP_ID = AP.APP_ID AND CH.APP_NO = AP.APP_NO AND AP.OSS_PERSON_ID = HZ.PARTY_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT CH.APP_CHOICE_ID APPLICANT_CHOICE_ID
, CH.APP_ID APPLICANT_ID
, CH.APP_NO APPLICANT_UCAS_NUMBER
, CH.CHOICE_NO APPLICANT_CHOICE_NUMBER
, CH.UCAS_CYCLE UCAS_CYCLE
, CH.LAST_CHANGE DATE_OF_LAST_CHANGE
, CH.INSTITUTE_CODE UCAS_INSTITUTE_CODE
, CH.UCAS_PROGRAM_CODE UCAS_PROGRAM_CODE
, CH.OSS_PROGRAM_CODE OSS_PROGRAM_CODE
, CH.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION
, CH.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE
, CH.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE
, CH.CAMPUS UCAS_CAMPUS
, CH.OSS_LOCATION OSS_LOCATION
, CH.FACULTY UCAS_FACULTY
, CH.ENTRY_YEAR ENTRY_YEAR
, CH.ENTRY_MONTH ENTRY_MONTH
, CH.POINT_OF_ENTRY POINT_OF_ENTRY
, CH.HOME HOME_FLAG
, CH.DEFERRED DEFERRED_FLAG
, CH.ROUTE_B_PREF_ROUND ROUTE_B_PREFERENCE_ROUND_FLAG
, CH.ROUTE_B_ACTUAL_ROUND ROUTE_B_ACTUAL_ROUND_FLAG
, CH.CONDITION_CATEGORY CONDITION_CATEGORY
, CH.CONDITION_CODE CONDITION_CODE
, CH.DECISION DECISION
, CH.DECISION_DATE DECISION_DATE
, CH.DECISION_NUMBER DECISION_NUMBER
, CH.REPLY REPLY
, CH.SUMMARY_OF_COND SUMMARY_OF_CONDITIONS
, CH.CHOICE_CANCELLED CHOICE_CANCELLED_FLAG
, CH.ACTION ACTION
, CH.SUBSTITUTION SUBSTITUTION
, CH.DATE_SUBSTITUTED SUBSTITUTED_DATE
, CH.PREV_INSTITUTION PREVIOUS_INSTITUTION
, CH.PREV_COURSE PREVIOUS_COURSE
, CH.PREV_CAMPUS PREVIOUS_CAMPUS
, CH.UCAS_AMENDMENT UCAS_AMENDMENT
, CH.WITHDRAWAL_REASON WITHDRAWAL_REASON
, CH.OFFER_COURSE OFFERED_COURSE
, CH.OFFER_CAMPUS OFFERED_CAMPUS
, CH.OFFER_CRSE_LENGTH OFFERED_COURSE_LENGTH
, CH.OFFER_ENTRY_MONTH OFFERED_ENTRY_MONTH
, CH.OFFER_ENTRY_YEAR OFFERED_ENTRY_YEAR
, CH.OFFER_ENTRY_POINT OFFERED_ENTRY_POINT
, CH.OFFER_TEXT OFFERED_TEXT
, CH.EXPORT_TO_OSS_STATUS EXPORT_TO_OSS_STATUS
, CH.ERROR_CODE EXPORT_PROCESS_ERROR_CODE
, CH.BATCH_ID ADM_IMPORT_PROCESS_BATCH_ID
, CH.EXTRA_ROUND_NBR EXTRA_ROUND_NUMBER
, CH.SYSTEM_CODE UCAS_SYSTEM_CODE
, CH.PART_TIME GTTR_PART_TIME
, CH.INTERVIEW GTTR_INTERVIEW_DATE
, CH.LATE_APPLICATION GTTR_LATE_APPLICATION_FLAG
, CH.MODULAR GTTR_MODULAR_FLAG
, CH.RESIDENTIAL NMAS_RESIDENTIAL_FLAG
, DE.NAME UCAS_SYSTEM_NAME
, DE.DESCRIPTION UCAS_SYSTEM_DESCRIPTION
, IN1.INST_CODE UCAS_INSTITUTION_ABBREVIATION
, IN1.INST_NAME UCAS_INSTITUTION_NAME
, VE.TITLE OSS_PROGRAM_TITLE
, VE.SHORT_TITLE OSS_PROGRAM_SHORT_TITLE
, TY.DESCRIPTION OSS_ATTENDANCE_TYPE_DESC
, MO.DESCRIPTION OSS_ATTENDANCE_MODE_DESC
, CR1.SHORT_TITLE UCAS_COURSE_SHORT_TITLE
, IN2.INST_NAME PREVIOUS_INSTITUTION_NAME
, CR2.SHORT_TITLE PREVIOUS_UCAS_COURSE_TITLE
, HZ.PARTY_NUMBER OSS_PERSON_NUMBER
, HZ.PARTY_NAME OSS_PERSON_NAME
, CH.CREATED_BY CREATED_BY
, CH.CREATION_DATE CREATION_DATE
, CH.LAST_UPDATED_BY LAST_UPDATED_BY
, CH.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_APP_CHOICES CH
, IGS_UC_DEFAULTS DE
, IGS_UC_COM_INST IN1
, IGS_PS_VER_ALL VE
, IGS_EN_ATD_TYPE_ALL TY
, IGS_EN_ATD_MODE_ALL MO
, IGS_UC_COM_INST IN2
, IGS_UC_CRSE_DETS CR1
, IGS_UC_CRSE_DETS CR2
, HZ_PARTIES HZ
, IGS_UC_APPLICANTS AP
WHERE CH.SYSTEM_CODE = DE.SYSTEM_CODE
AND CH.INSTITUTE_CODE = IN1.INST
AND CH.OSS_PROGRAM_CODE = VE.COURSE_CD (+)
AND CH.OSS_PROGRAM_VERSION = VE.VERSION_NUMBER (+)
AND CH.OSS_ATTENDANCE_TYPE = TY.ATTENDANCE_TYPE (+)
AND CH.OSS_ATTENDANCE_MODE = MO.ATTENDANCE_MODE (+)
AND CH.UCAS_PROGRAM_CODE = CR1.UCAS_PROGRAM_CODE (+)
AND CH.CAMPUS = CR1.UCAS_CAMPUS (+)
AND CH.INSTITUTE_CODE = CR1.INSTITUTE (+)
AND CH.SYSTEM_CODE = CR1.SYSTEM_CODE (+)
AND CH.PREV_COURSE = CR2.UCAS_PROGRAM_CODE (+)
AND CH.PREV_CAMPUS = CR2.UCAS_CAMPUS (+)
AND CH.PREV_INSTITUTION = CR2.INSTITUTE (+)
AND CH.SYSTEM_CODE = CR2.SYSTEM_CODE (+)
AND CH.PREV_INSTITUTION = IN2.INST (+)
AND CH.APP_ID = AP.APP_ID
AND CH.APP_NO = AP.APP_NO
AND AP.OSS_PERSON_ID = HZ.PARTY_ID (+) WITH READ ONLY