VIEW: APPS.IGSBV_UC_APPLICANT_CHOICES

Source

View Text - Preformatted

SELECT AP.APP_CHOICE_ID APPLICANT_CHOICE_ID, AP.APP_ID APPLICANT_ID, AP.APP_NO APPLICANT_UCAS_NUMBER, AP.CHOICE_NO APPLICANT_CHOICE_NUMBER, AP.UCAS_CYCLE UCAS_CYCLE, AP.LAST_CHANGE DATE_OF_LAST_CHANGE, AP.INSTITUTE_CODE UCAS_INSTITUTE_CODE, AP.UCAS_PROGRAM_CODE UCAS_PROGRAM_CODE, AP.OSS_PROGRAM_CODE OSS_PROGRAM_CODE, AP.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION, AP.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE, AP.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE, AP.CAMPUS UCAS_CAMPUS, AP.OSS_LOCATION OSS_LOCATION, AP.FACULTY UCAS_FACULTY, AP.ENTRY_YEAR ENTRY_YEAR, AP.ENTRY_MONTH ENTRY_MONTH, AP.POINT_OF_ENTRY POINT_OF_ENTRY, AP.HOME HOME_FLAG, AP.DEFERRED DEFERRED_FLAG, AP.ROUTE_B_PREF_ROUND ROUTE_B_PREFERENCE_ROUND_FLAG, AP.ROUTE_B_ACTUAL_ROUND ROUTE_B_ACTUAL_ROUND_FLAG, AP.CONDITION_CATEGORY CONDITION_CATEGORY, AP.CONDITION_CODE CONDITION_CODE, AP.DECISION DECISION, AP.DECISION_DATE DECISION_DATE, AP.DECISION_NUMBER DECISION_NUMBER, AP.REPLY REPLY, AP.SUMMARY_OF_COND SUMMARY_OF_CONDITIONS, AP.CHOICE_CANCELLED CHOICE_CANCELLED_FLAG, AP.ACTION ACTION, AP.SUBSTITUTION SUBSTITUTION, AP.DATE_SUBSTITUTED SUBSTITUTED_DATE, AP.PREV_INSTITUTION PREVIOUS_INSTITUTION, AP.PREV_COURSE PREVIOUS_COURSE, AP.PREV_CAMPUS PREVIOUS_CAMPUS, AP.UCAS_AMENDMENT UCAS_AMENDMENT, AP.WITHDRAWAL_REASON WITHDRAWAL_REASON, AP.OFFER_COURSE OFFERED_COURSE, AP.OFFER_CAMPUS OFFERED_CAMPUS, AP.OFFER_CRSE_LENGTH OFFERED_COURSE_LENGTH, AP.OFFER_ENTRY_MONTH OFFERED_ENTRY_MONTH, AP.OFFER_ENTRY_YEAR OFFERED_ENTRY_YEAR, AP.OFFER_ENTRY_POINT OFFERED_ENTRY_POINT, AP.OFFER_TEXT OFFERED_TEXT, AP.EXPORT_TO_OSS_STATUS EXPORT_TO_OSS_STATUS, AP.ERROR_CODE EXPORT_PROCESS_ERROR_CODE, AP.BATCH_ID ADM_IMPORT_PROCESS_BATCH_ID, AP.EXTRA_ROUND_NBR EXTRA_ROUND_NUMBER, AP.SYSTEM_CODE UCAS_SYSTEM_CODE, AP.PART_TIME GTTR_PART_TIME, AP.INTERVIEW GTTR_INTERVIEW_DATE, AP.LATE_APPLICATION GTTR_LATE_APPLICATION_FLAG, AP.MODULAR GTTR_MODULAR_FLAG, AP.RESIDENTIAL NMAS_RESIDENTIAL_FLAG, AP.CREATED_BY CREATED_BY, AP.CREATION_DATE CREATION_DATE, AP.LAST_UPDATED_BY LAST_UPDATED_BY, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_UC_APP_CHOICES AP WITH READ ONLY

View Text - HTML Formatted

SELECT AP.APP_CHOICE_ID APPLICANT_CHOICE_ID
, AP.APP_ID APPLICANT_ID
, AP.APP_NO APPLICANT_UCAS_NUMBER
, AP.CHOICE_NO APPLICANT_CHOICE_NUMBER
, AP.UCAS_CYCLE UCAS_CYCLE
, AP.LAST_CHANGE DATE_OF_LAST_CHANGE
, AP.INSTITUTE_CODE UCAS_INSTITUTE_CODE
, AP.UCAS_PROGRAM_CODE UCAS_PROGRAM_CODE
, AP.OSS_PROGRAM_CODE OSS_PROGRAM_CODE
, AP.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION
, AP.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE
, AP.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE
, AP.CAMPUS UCAS_CAMPUS
, AP.OSS_LOCATION OSS_LOCATION
, AP.FACULTY UCAS_FACULTY
, AP.ENTRY_YEAR ENTRY_YEAR
, AP.ENTRY_MONTH ENTRY_MONTH
, AP.POINT_OF_ENTRY POINT_OF_ENTRY
, AP.HOME HOME_FLAG
, AP.DEFERRED DEFERRED_FLAG
, AP.ROUTE_B_PREF_ROUND ROUTE_B_PREFERENCE_ROUND_FLAG
, AP.ROUTE_B_ACTUAL_ROUND ROUTE_B_ACTUAL_ROUND_FLAG
, AP.CONDITION_CATEGORY CONDITION_CATEGORY
, AP.CONDITION_CODE CONDITION_CODE
, AP.DECISION DECISION
, AP.DECISION_DATE DECISION_DATE
, AP.DECISION_NUMBER DECISION_NUMBER
, AP.REPLY REPLY
, AP.SUMMARY_OF_COND SUMMARY_OF_CONDITIONS
, AP.CHOICE_CANCELLED CHOICE_CANCELLED_FLAG
, AP.ACTION ACTION
, AP.SUBSTITUTION SUBSTITUTION
, AP.DATE_SUBSTITUTED SUBSTITUTED_DATE
, AP.PREV_INSTITUTION PREVIOUS_INSTITUTION
, AP.PREV_COURSE PREVIOUS_COURSE
, AP.PREV_CAMPUS PREVIOUS_CAMPUS
, AP.UCAS_AMENDMENT UCAS_AMENDMENT
, AP.WITHDRAWAL_REASON WITHDRAWAL_REASON
, AP.OFFER_COURSE OFFERED_COURSE
, AP.OFFER_CAMPUS OFFERED_CAMPUS
, AP.OFFER_CRSE_LENGTH OFFERED_COURSE_LENGTH
, AP.OFFER_ENTRY_MONTH OFFERED_ENTRY_MONTH
, AP.OFFER_ENTRY_YEAR OFFERED_ENTRY_YEAR
, AP.OFFER_ENTRY_POINT OFFERED_ENTRY_POINT
, AP.OFFER_TEXT OFFERED_TEXT
, AP.EXPORT_TO_OSS_STATUS EXPORT_TO_OSS_STATUS
, AP.ERROR_CODE EXPORT_PROCESS_ERROR_CODE
, AP.BATCH_ID ADM_IMPORT_PROCESS_BATCH_ID
, AP.EXTRA_ROUND_NBR EXTRA_ROUND_NUMBER
, AP.SYSTEM_CODE UCAS_SYSTEM_CODE
, AP.PART_TIME GTTR_PART_TIME
, AP.INTERVIEW GTTR_INTERVIEW_DATE
, AP.LATE_APPLICATION GTTR_LATE_APPLICATION_FLAG
, AP.MODULAR GTTR_MODULAR_FLAG
, AP.RESIDENTIAL NMAS_RESIDENTIAL_FLAG
, AP.CREATED_BY CREATED_BY
, AP.CREATION_DATE CREATION_DATE
, AP.LAST_UPDATED_BY LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_APP_CHOICES AP WITH READ ONLY