Table: IGS_UC_APP_CHOICES

Product:	IGS - Student System
Description:	Holds applicant choice details and related offer details. It is also used to synchronize with UCAS view 'ivOffer'.It also syncs. to 'ivStarC'.This table will hold child records only when the parent table 'IGS_UC_APPLICANTS' has 'App_No' pop
Implementation/DBA Data:	IGS.IGS_UC_APP_CHOICES

Primary Key: IGS_UC_APP_CHOICES_PK

1. APP_CHOICE_ID

Primary Key: IGS_UC_APP_CHOICES_UK

1. APP_NO
2. CHOICE_NO
3. UCAS_CYCLE

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_UC_APP_CHOICES		IGS_UC_CRSE_DETS	IGS_UC_APP_CHOICES.SYSTEM_CODE IGS_UC_APP_CHOICES.UCAS_PROGRAM_CODE IGS_UC_APP_CHOICES.INSTITUTE_CODE IGS_UC_APP_CHOICES.CAMPUS
IGS_UC_APP_CHOICES		IGS_UC_APPLICANTS	IGS_UC_APP_CHOICES.APP_ID
IGS_UC_APP_CHOICES		IGS_UC_OFFER_CONDS	IGS_UC_APP_CHOICES.CONDITION_CATEGORY IGS_UC_APP_CHOICES.CONDITION_CODE
IGS_UC_APP_CHO_CNDS		IGS_UC_APP_CHOICES	IGS_UC_APP_CHO_CNDS.APP_CHOICE_ID