eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_UC_APP_CHOICES

Object Details

Object Name:	IGS_UC_APP_CHOICES
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_UC_APP_CHOICES
Subobject Name:
Status:	VALID

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' populated i.e. not null

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_APP_CHOICES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APP_CHOICE_ID
IGS_UC_APP_CHOICES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	APP_NO CHOICE_NO UCAS_CYCLE
IGS_UC_APP_CHOICES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPORT_TO_OSS_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
APP_CHOICE_ID	NUMBER		Yes	Unique Record Identifier
APP_ID	NUMBER		Yes	Unique applicant identifier
APP_NO	NUMBER	(8)	Yes	UCAS application number
CHOICE_NO	NUMBER	(2)	Yes	UCAS application choice number
LAST_CHANGE	DATE		Yes	Choice level time stamp to synchronize with UCAS view ivStarC
INSTITUTE_CODE	VARCHAR2	(5)	Yes	Institution code to synchronize with UCAS view ivStarC
UCAS_PROGRAM_CODE	VARCHAR2	(6)	Yes	UCAS course code to synchronize with UCAS view ivStarC
OSS_PROGRAM_CODE	VARCHAR2	(6)		Mapped OSS program code
OSS_PROGRAM_VERSION	NUMBER	(3)		Mapped OSS program version
OSS_ATTENDANCE_TYPE	VARCHAR2	(2)		OSS attendance type
OSS_ATTENDANCE_MODE	VARCHAR2	(2)		OSS attendance mode
CAMPUS	VARCHAR2	(1)	Yes	UCAS campus code to synchronize with UCAS view ivStarC
OSS_LOCATION	VARCHAR2	(10)		OSS location code
FACULTY	VARCHAR2	(1)		UCAS faculty code to synchronize with UCAS view ivStarC
ENTRY_YEAR	NUMBER	(2)	Yes	Year of entry to synchronize with UCAS view ivStarC
ENTRY_MONTH	NUMBER	(2)	Yes	Month of entry to synchronize with UCAS view ivStarC
POINT_OF_ENTRY	NUMBER	(1)		Point of entry to synchronize with UCAS view ivStarC
HOME	VARCHAR2	(1)	Yes	Applicant will live at home (Y - yes, N - no) to synchronize with UCAS view ivStarC
DEFERRED	VARCHAR2	(1)	Yes	Applied for deferred entry (Y - yes, N - no). Default is No
ROUTE_B_PREF_ROUND	NUMBER			Route B preference round number (1,2,3) to synchronize with UCAS view ivStarC
ROUTE_B_ACTUAL_ROUND	NUMBER			Route B actual round number (1,2,3) to synchronize with UCAS view ivStarC
CONDITION_CATEGORY	VARCHAR2	(10)		Attached offer condition category. Links an offer to a choice
CONDITION_CODE	VARCHAR2	(20)		Attached offer condition name. Links an offer to a choice
DECISION	VARCHAR2	(1)		Decision, to synchronize with UCAS view ivStarC
DECISION_DATE	DATE			Decision date, to synchronize with UCAS view ivStarC
DECISION_NUMBER	NUMBER			Decision number, to synchronize with UCAS view ivStarC
REPLY	VARCHAR2	(1)		Applicant reply, to synchronize with UCAS view ivStarC
SUMMARY_OF_COND	VARCHAR2	(6)		Summary of conditions, to synchronize with UCAS view ivStarC
CHOICE_CANCELLED	VARCHAR2	(1)		Choice cancelled (Y - yes, N - no), to synchronize with UCAS view ivStarC
ACTION	VARCHAR2	(1)		Action by default, to synchronize with UCAS view ivStarC
SUBSTITUTION	VARCHAR2	(1)		Indicates substitution made, to synchronize with UCAS view ivStarC
DATE_SUBSTITUTED	DATE			Date a substitution was applied or made, post-15thDec, to synchronize with UCAS view ivStarC
PREV_INSTITUTION	VARCHAR2	(3)		Previous institution code, to synchronize with UCAS view ivStarC
PREV_COURSE	VARCHAR2	(6)		Previous UCAS course code, to synchronize with UCAS view ivStarC
PREV_CAMPUS	VARCHAR2	(1)		Previous UCAS campus code to synchronize with UCAS view ivStarC
UCAS_AMENDMENT	VARCHAR2	(1)		UCAS Amendment to synchronize with UCAS view ivStarC
WITHDRAWAL_REASON	VARCHAR2	(20)		Reason for 'W' in 'LD', 'LA'
IVOFFER_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view ivOffer - Obsolete
OFFER_COURSE	VARCHAR2	(6)		UCAS Course code in offer, to synchronize with UCAS view ivOffer
OFFER_CAMPUS	VARCHAR2	(1)		UCAS campus in offer, to synchronize with UCAS view ivOffer
OFFER_CRSE_LENGTH	NUMBER	(1)		Duration of course in offer, to synchronize with UCAS view ivOffer
OFFER_ENTRY_MONTH	VARCHAR2	(2)		Month of entry in offer, to synchronize with UCAS view ivOffer
OFFER_ENTRY_YEAR	VARCHAR2	(2)		Year of entry in offer, to synchronize with UCAS view ivOffer
OFFER_ENTRY_POINT	VARCHAR2	(1)		Point of entry in offer, to synchronize with UCAS view ivOffer
OFFER_TEXT	VARCHAR2	(2000)		Text version of offer letter to synchronize with UCAS view ivOffer
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
EXPORT_TO_OSS_STATUS	VARCHAR2	(10)		Default Value NEW,identifies the status of exporting this application choice
ERROR_CODE	VARCHAR2	(10)		Identifies the error encountered while exporting the application choice to OSS ,meaningless when export_to_oss_status = 'NEW'
REQUEST_ID	NUMBER	(15)		Request Id of the run of 'export applications to oss' process
BATCH_ID	NUMBER	(15)		Admissions import process batch in which the last error was encountered
EXTRA_ROUND_NBR	NUMBER	(3)		Holds the UCAS EXTRA processing round number.
SYSTEM_CODE	VARCHAR2	(1)	Yes	UCAS System Code
IVSTARG_TIMESTAMP	DATE			IVSTARG Timestamp - Obsolete
PART_TIME	VARCHAR2	(1)		GTTR - Part Time
INTERVIEW	DATE			GTTR - Interview date
LATE_APPLICATION	VARCHAR2	(1)		GTTR - Late Application flag
MODULAR	VARCHAR2	(1)		GTTR - Modular flag
RESIDENTIAL	VARCHAR2	(1)		NMAS - Residential Accommodation required
UCAS_CYCLE	NUMBER	(15)	Yes	UCAS cycle to which this Application Choice belongs

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APP_CHOICE_ID
,      APP_ID
,      APP_NO
,      CHOICE_NO
,      LAST_CHANGE
,      INSTITUTE_CODE
,      UCAS_PROGRAM_CODE
,      OSS_PROGRAM_CODE
,      OSS_PROGRAM_VERSION
,      OSS_ATTENDANCE_TYPE
,      OSS_ATTENDANCE_MODE
,      CAMPUS
,      OSS_LOCATION
,      FACULTY
,      ENTRY_YEAR
,      ENTRY_MONTH
,      POINT_OF_ENTRY
,      HOME
,      DEFERRED
,      ROUTE_B_PREF_ROUND
,      ROUTE_B_ACTUAL_ROUND
,      CONDITION_CATEGORY
,      CONDITION_CODE
,      DECISION
,      DECISION_DATE
,      DECISION_NUMBER
,      REPLY
,      SUMMARY_OF_COND
,      CHOICE_CANCELLED
,      ACTION
,      SUBSTITUTION
,      DATE_SUBSTITUTED
,      PREV_INSTITUTION
,      PREV_COURSE
,      PREV_CAMPUS
,      UCAS_AMENDMENT
,      WITHDRAWAL_REASON
,      IVOFFER_TIMESTAMP
,      OFFER_COURSE
,      OFFER_CAMPUS
,      OFFER_CRSE_LENGTH
,      OFFER_ENTRY_MONTH
,      OFFER_ENTRY_YEAR
,      OFFER_ENTRY_POINT
,      OFFER_TEXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EXPORT_TO_OSS_STATUS
,      ERROR_CODE
,      REQUEST_ID
,      BATCH_ID
,      EXTRA_ROUND_NBR
,      SYSTEM_CODE
,      IVSTARG_TIMESTAMP
,      PART_TIME
,      INTERVIEW
,      LATE_APPLICATION
,      MODULAR
,      RESIDENTIAL
,      UCAS_CYCLE
FROM IGS.IGS_UC_APP_CHOICES;

Dependencies

[top of page]

IGS.IGS_UC_APP_CHOICES does not reference any database object

IGS.IGS_UC_APP_CHOICES is referenced by following:

APPS: IGS_UC_APP_CHOICES