VIEW: APPS.IGS_UC_APPL_DTLS_V

Source

View Text - Preformatted

SELECT Ucapch.ROWID, Ucap.ROWID, Ucclr.ROWID, ucap.APP_ID, ucap.APP_NO, ucap.CHECK_DIGIT, ucap.ENQUIRY_NO, ucap.OSS_PERSON_ID, ucap.APPLICATION_SOURCE, ucap.NAME_CHANGE_DATE, ucap.STUDENT_SUPPORT, ucap.ADDRESS_AREA, ucap.APPLICATION_DATE, ucap.APPLICATION_SENT_DATE, ucap.APPLICATION_SENT_RUN, ucap.LEA_CODE, ucap.FEE_PAYER_CODE, ucap.FEE_TEXT, ucap.DOMICILE_APR, ucap.CODE_CHANGED_DATE, ucap.SCHOOL, ucap.WITHDRAWN, ucap.WITHDRAWN_DATE, ucap.REL_TO_CLEAR_REASON, ucap.ROUTE_B, ucap.EXAM_CHANGE_DATE, ucap.A_LEVELS, ucap.AS_LEVELS, ucap.HIGHERS, ucap.CSYS, ucap.WINTER, ucap.PREVIOUS, ucap.GNVQ, ucap.BTEC, ucap.ILC, ucap.AILC, ucap.IB, ucap.MANUAL, ucap.REG_NUM, ucap.OEQ, ucap.EAS, ucap.ROA, ucap.STATUS, ucap.FIRM_NOW, ucap.FIRM_REPLY, ucap.INSURANCE_REPLY, ucap.CONF_HIST_FIRM_REPLY, ucap.CONF_HIST_INS_REPLY, ucap.RESIDENTIAL_CATEGORY, ucap.PERSONAL_STATEMENT, ucap.MATCH_PREV, ucap.MATCH_PREV_DATE, ucap.MATCH_WINTER, ucap.MATCH_SUMMER, ucap.GNVQ_DATE, ucap.IB_DATE, ucap.ILC_DATE, ucap.AILC_DATE, ucap.GCSEQA_DATE, ucap.UK_ENTRY_DATE, ucap.PREV_SURNAME, ucap.CRIMINAL_CONVICTIONS, ucap.SENT_TO_HESA, ucap.BATCH_IDENTIFIER, ucap.GCE, ucap.VCE, ucap.SQA, ucap.PREVIOUSAS, ucap.KEYSKILLS, ucap.VOCATIONAL, ucap.SCN, ucap.PREVOEQ, ucap.CHOICES_TRANSPARENT_IND, ucap.EXTRA_STATUS, ucap.EXTRA_PASSPORT_NO, ucap.REQUEST_APP_DETS_IND, ucap.REQUEST_COPY_APP_FRM_IND, ucap.CEF_NO, ucap.SYSTEM_CODE, ucap.GCSE_ENG, ucap.GCSE_MATH, ucap.DEGREE_SUBJECT, ucap.DEGREE_STATUS, ucap.DEGREE_CLASS, ucap.GCSE_SCI, ucap.WELSHSPEAKER, ucap.NI_NUMBER, ucap.EARLIEST_START, ucap.NEAR_INST, ucap.PREF_REG, ucap.QUAL_ENG, ucap.QUAL_MATH, ucap.QUAL_SCI, ucap.MAIN_QUAL, ucap.QUAL_5, ucap.FUTURE_SERV, ucap.FUTURE_SET, ucap.PRESENT_SERV, ucap.PRESENT_SET, ucap.CURR_EMPLOYMENT, ucap.EDU_QUALIFICATION, ucapch.APP_CHOICE_ID, ucapch.CHOICE_NO, ucapch.LAST_CHANGE, ucapch.INSTITUTE_CODE, ucapch.UCAS_PROGRAM_CODE, ucapch.OSS_PROGRAM_CODE, ucapch.OSS_PROGRAM_VERSION, ucapch.OSS_ATTENDANCE_TYPE, ucapch.OSS_ATTENDANCE_MODE, ucapch.CAMPUS, ucapch.OSS_LOCATION, ucapch.FACULTY, ucapch.ENTRY_YEAR, ucapch.ENTRY_MONTH, ucapch.POINT_OF_ENTRY, ucapch.HOME, ucapch.DEFERRED, ucapch.ROUTE_B_PREF_ROUND, ucapch.ROUTE_B_ACTUAL_ROUND, ucapch.CONDITION_CATEGORY, ucapch.CONDITION_CODE, ucapch.DECISION, ucapch.DECISION_DATE, ucapch.DECISION_NUMBER, ucapch.REPLY, ucapch.SUMMARY_OF_COND, ucapch.CHOICE_CANCELLED, ucapch.ACTION, ucapch.SUBSTITUTION, ucapch.DATE_SUBSTITUTED, ucapch.PREV_INSTITUTION, ucapch.PREV_COURSE, ucapch.PREV_CAMPUS, ucapch.UCAS_AMENDMENT, ucapch.WITHDRAWAL_REASON, ucapch.OFFER_COURSE, ucapch.OFFER_CAMPUS, ucapch.OFFER_CRSE_LENGTH, ucapch.OFFER_ENTRY_MONTH, ucapch.OFFER_ENTRY_YEAR, ucapch.OFFER_ENTRY_POINT, ucapch.OFFER_TEXT, ucapch.EXPORT_TO_OSS_STATUS, ucapch.ERROR_CODE, ucapch.REQUEST_ID, ucapch.BATCH_ID, ucapch.EXTRA_ROUND_NBR, ucapch.PART_TIME, ucapch.INTERVIEW, ucapch.LATE_APPLICATION, ucapch.MODULAR, ucapch.RESIDENTIAL, ucclr.CEF_RECEIVED, ucclr.RESULT, ucclr.CLEARING_APP_SOURCE, ucclr.DATE_CEF_SENT, ucclr.CLEARING_APP_ID, ucapch.CREATED_BY, ucapch.CREATION_DATE, ucapch.LAST_UPDATED_BY, ucapch.LAST_UPDATE_DATE, ucapch.LAST_UPDATE_LOGIN FROM IGS_UC_APPLICANTS ucap, IGS_UC_APP_CHOICES ucapch, IGS_UC_APP_CLEARING ucclr WHERE ucap.APP_NO = ucapch.APP_NO (+) AND ucap.app_no = ucclr.app_no (+)

View Text - HTML Formatted

SELECT UCAPCH.ROWID
, UCAP.ROWID
, UCCLR.ROWID
, UCAP.APP_ID
, UCAP.APP_NO
, UCAP.CHECK_DIGIT
, UCAP.ENQUIRY_NO
, UCAP.OSS_PERSON_ID
, UCAP.APPLICATION_SOURCE
, UCAP.NAME_CHANGE_DATE
, UCAP.STUDENT_SUPPORT
, UCAP.ADDRESS_AREA
, UCAP.APPLICATION_DATE
, UCAP.APPLICATION_SENT_DATE
, UCAP.APPLICATION_SENT_RUN
, UCAP.LEA_CODE
, UCAP.FEE_PAYER_CODE
, UCAP.FEE_TEXT
, UCAP.DOMICILE_APR
, UCAP.CODE_CHANGED_DATE
, UCAP.SCHOOL
, UCAP.WITHDRAWN
, UCAP.WITHDRAWN_DATE
, UCAP.REL_TO_CLEAR_REASON
, UCAP.ROUTE_B
, UCAP.EXAM_CHANGE_DATE
, UCAP.A_LEVELS
, UCAP.AS_LEVELS
, UCAP.HIGHERS
, UCAP.CSYS
, UCAP.WINTER
, UCAP.PREVIOUS
, UCAP.GNVQ
, UCAP.BTEC
, UCAP.ILC
, UCAP.AILC
, UCAP.IB
, UCAP.MANUAL
, UCAP.REG_NUM
, UCAP.OEQ
, UCAP.EAS
, UCAP.ROA
, UCAP.STATUS
, UCAP.FIRM_NOW
, UCAP.FIRM_REPLY
, UCAP.INSURANCE_REPLY
, UCAP.CONF_HIST_FIRM_REPLY
, UCAP.CONF_HIST_INS_REPLY
, UCAP.RESIDENTIAL_CATEGORY
, UCAP.PERSONAL_STATEMENT
, UCAP.MATCH_PREV
, UCAP.MATCH_PREV_DATE
, UCAP.MATCH_WINTER
, UCAP.MATCH_SUMMER
, UCAP.GNVQ_DATE
, UCAP.IB_DATE
, UCAP.ILC_DATE
, UCAP.AILC_DATE
, UCAP.GCSEQA_DATE
, UCAP.UK_ENTRY_DATE
, UCAP.PREV_SURNAME
, UCAP.CRIMINAL_CONVICTIONS
, UCAP.SENT_TO_HESA
, UCAP.BATCH_IDENTIFIER
, UCAP.GCE
, UCAP.VCE
, UCAP.SQA
, UCAP.PREVIOUSAS
, UCAP.KEYSKILLS
, UCAP.VOCATIONAL
, UCAP.SCN
, UCAP.PREVOEQ
, UCAP.CHOICES_TRANSPARENT_IND
, UCAP.EXTRA_STATUS
, UCAP.EXTRA_PASSPORT_NO
, UCAP.REQUEST_APP_DETS_IND
, UCAP.REQUEST_COPY_APP_FRM_IND
, UCAP.CEF_NO
, UCAP.SYSTEM_CODE
, UCAP.GCSE_ENG
, UCAP.GCSE_MATH
, UCAP.DEGREE_SUBJECT
, UCAP.DEGREE_STATUS
, UCAP.DEGREE_CLASS
, UCAP.GCSE_SCI
, UCAP.WELSHSPEAKER
, UCAP.NI_NUMBER
, UCAP.EARLIEST_START
, UCAP.NEAR_INST
, UCAP.PREF_REG
, UCAP.QUAL_ENG
, UCAP.QUAL_MATH
, UCAP.QUAL_SCI
, UCAP.MAIN_QUAL
, UCAP.QUAL_5
, UCAP.FUTURE_SERV
, UCAP.FUTURE_SET
, UCAP.PRESENT_SERV
, UCAP.PRESENT_SET
, UCAP.CURR_EMPLOYMENT
, UCAP.EDU_QUALIFICATION
, UCAPCH.APP_CHOICE_ID
, UCAPCH.CHOICE_NO
, UCAPCH.LAST_CHANGE
, UCAPCH.INSTITUTE_CODE
, UCAPCH.UCAS_PROGRAM_CODE
, UCAPCH.OSS_PROGRAM_CODE
, UCAPCH.OSS_PROGRAM_VERSION
, UCAPCH.OSS_ATTENDANCE_TYPE
, UCAPCH.OSS_ATTENDANCE_MODE
, UCAPCH.CAMPUS
, UCAPCH.OSS_LOCATION
, UCAPCH.FACULTY
, UCAPCH.ENTRY_YEAR
, UCAPCH.ENTRY_MONTH
, UCAPCH.POINT_OF_ENTRY
, UCAPCH.HOME
, UCAPCH.DEFERRED
, UCAPCH.ROUTE_B_PREF_ROUND
, UCAPCH.ROUTE_B_ACTUAL_ROUND
, UCAPCH.CONDITION_CATEGORY
, UCAPCH.CONDITION_CODE
, UCAPCH.DECISION
, UCAPCH.DECISION_DATE
, UCAPCH.DECISION_NUMBER
, UCAPCH.REPLY
, UCAPCH.SUMMARY_OF_COND
, UCAPCH.CHOICE_CANCELLED
, UCAPCH.ACTION
, UCAPCH.SUBSTITUTION
, UCAPCH.DATE_SUBSTITUTED
, UCAPCH.PREV_INSTITUTION
, UCAPCH.PREV_COURSE
, UCAPCH.PREV_CAMPUS
, UCAPCH.UCAS_AMENDMENT
, UCAPCH.WITHDRAWAL_REASON
, UCAPCH.OFFER_COURSE
, UCAPCH.OFFER_CAMPUS
, UCAPCH.OFFER_CRSE_LENGTH
, UCAPCH.OFFER_ENTRY_MONTH
, UCAPCH.OFFER_ENTRY_YEAR
, UCAPCH.OFFER_ENTRY_POINT
, UCAPCH.OFFER_TEXT
, UCAPCH.EXPORT_TO_OSS_STATUS
, UCAPCH.ERROR_CODE
, UCAPCH.REQUEST_ID
, UCAPCH.BATCH_ID
, UCAPCH.EXTRA_ROUND_NBR
, UCAPCH.PART_TIME
, UCAPCH.INTERVIEW
, UCAPCH.LATE_APPLICATION
, UCAPCH.MODULAR
, UCAPCH.RESIDENTIAL
, UCCLR.CEF_RECEIVED
, UCCLR.RESULT
, UCCLR.CLEARING_APP_SOURCE
, UCCLR.DATE_CEF_SENT
, UCCLR.CLEARING_APP_ID
, UCAPCH.CREATED_BY
, UCAPCH.CREATION_DATE
, UCAPCH.LAST_UPDATED_BY
, UCAPCH.LAST_UPDATE_DATE
, UCAPCH.LAST_UPDATE_LOGIN
FROM IGS_UC_APPLICANTS UCAP
, IGS_UC_APP_CHOICES UCAPCH
, IGS_UC_APP_CLEARING UCCLR
WHERE UCAP.APP_NO = UCAPCH.APP_NO (+)
AND UCAP.APP_NO = UCCLR.APP_NO (+)