[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Base View for Applicant Choices |
| Implementation/DBA Data: | Not implemented in this database |
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