[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Selects the Application , Application choice and clearing details for the applicants you can see |
| Implementation/DBA Data: | Not implemented in this database |
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 (+)