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_MV_IVSTARC

Object Details

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

This table stores the applicant choices. You can see all the choices for all the applicants you are allowed to see. - OBSOLETE

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
APPNO	NUMBER	(8)		Application Number
CHOICENO	NUMBER	(2)		Choice number
TIMESTAMP	DATE			Time stamp - date and time of last change to any choice for this applicant
LASTCHANGE	DATE			Date and time of last change to this choice.
INST	VARCHAR2	(3)		Institution Code
COURSE	VARCHAR2	(6)		Course Code
CAMPUS	VARCHAR2	(1)		Campus Code
FACULTY	VARCHAR2	(1)		Faculty Code
HOME	VARCHAR2	(1)		H - Live at home
DECISION	VARCHAR2	(1)		C,U,R,W or Blank
DECISIONDATE	DATE			Date when the decision was made
DECISIONNUMBER	NUMBER	(1)		Pre SOD reply: 0 - no decision 1 - 1st decision (LD) 2-9 - 2nd etc decision (LA). Post SOD reply: 0 - SOD reply in 1 - Confirmation decision in 2 - UF amendment
REPLY	VARCHAR2	(1)		F, I, D or Blank
SUMMARYCONDITIONS	VARCHAR2	(6)		Summary of conditions column
ENTRYMONTH	NUMBER	(2)		Month course starts
ENTRYYEAR	NUMBER	(2)		Year the course starts
ENTRYPOINT	VARCHAR2	(1)		Null = year 1 entry 1-4 = Year of entry 0 = Foundation Year entry
CHOICECANCELLED	VARCHAR2	(1)		Y - Choice cancelled
ACTION	VARCHAR2	(1)		D - DBD (Decline by Default), R - RBD (Reject by Default), U - up rated (UI-UF, CI-CF), X - assumed decline (no answer on AS6C, AS6F, AS6R, AS6W, AS7)
SUBSTITUTION	VARCHAR2	(1)		Space - no substitution 1 - substitution up to 15th Dec 2 - substitution/applied after 15th Dec 3 - substitution/applied after 16th May C - substitution in confirmation (UF only)
DATESUBSTITUTED	DATE			Date a substitution was made or applied post 15th Dec
PREVIOUSINST	VARCHAR2	(3)		Previous institution
PREVIOUSCOURSE	VARCHAR2	(6)		Previous course
PREVIOUSCAMPUS	VARCHAR2	(1)		Previous campus
UCASAMENDMENT	VARCHAR2	(1)		Null - No UCAS amendment A - latest amendment P - previous amendment
ROUTEBPREF	NUMBER	(1)		Route B preference, Rounds Priority 1,2 or3
ROUTEBROUND	NUMBER	(1)		Route B Actual Round
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
EXTRAROUND	NUMBER	(3)		Extra round choice number.

Query Text

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


SELECT APPNO
,      CHOICENO
,      TIMESTAMP
,      LASTCHANGE
,      INST
,      COURSE
,      CAMPUS
,      FACULTY
,      HOME
,      DECISION
,      DECISIONDATE
,      DECISIONNUMBER
,      REPLY
,      SUMMARYCONDITIONS
,      ENTRYMONTH
,      ENTRYYEAR
,      ENTRYPOINT
,      CHOICECANCELLED
,      ACTION
,      SUBSTITUTION
,      DATESUBSTITUTED
,      PREVIOUSINST
,      PREVIOUSCOURSE
,      PREVIOUSCAMPUS
,      UCASAMENDMENT
,      ROUTEBPREF
,      ROUTEBROUND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EXTRAROUND
FROM IGS.IGS_UC_MV_IVSTARC;

Dependencies

[top of page]

IGS.IGS_UC_MV_IVSTARC does not reference any database object

IGS.IGS_UC_MV_IVSTARC is referenced by following:

APPS: IGS_UC_MV_IVSTARC