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_ISTARC_INTS

Object Details

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

Holds application choice information loaded from UCAS

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_ISTARC_INTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RECORD_STATUS APPNO CHOICENO UCAS_CYCLE

Columns

Name	Datatype	Length	Comments
APPNO	NUMBER	(22)	Application Number
CHOICENO	NUMBER	(22)	Choice Number
UCAS_CYCLE	NUMBER	(15)	UCAS Cycle to which this interface record belongs to
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)	UCAS Decision. Values are C,U,R,W or Blank
DECISIONDATE	DATE		Date when the decision was made
DECISIONNUMBER	NUMBER	(22)	Pre SOD reply: 0 - no decision ,1 - 1st decision (LD), 2-9 - 2nd etc decision (LA). Post SOD reply: 0 - SOD reply , 1 - Confirmation decision , 2 - UF amendment
REPLY	VARCHAR2	(1)	UCAS Reply. Values can be, F, I, D or Blank
SUMMARYCONDITIONS	VARCHAR2	(6)	Summary of conditions column
ENTRYMONTH	NUMBER	(22)	Month course starts
ENTRYYEAR	NUMBER	(22)	Year the course starts
ENTRYPOINT	VARCHAR2	(1)	Null = year 1 entry, 1-4 = Year of entry, 0 = Foundation Year entry
CHOICECANCELLED	VARCHAR2	(1)	Y means 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 or applied after 15th Dec, 3 - substitution or 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	(22)	Route B preference, Rounds Priority 1,2 or3
ROUTEBROUND	NUMBER	(22)	Route B Actual Round
DETAIL	VARCHAR2	(20)	Detail
EXTRAROUND	NUMBER	(22)	Extra round choice number
RESIDENTIAL	VARCHAR2	(1)	NMAS- Residential Accommodation Required
RECORD_STATUS	VARCHAR2	(1)	Status of the interface record , takes values N, O, D etc
ERROR_CODE	VARCHAR2	(4)	Code for the error encountered during processing of this interface record data

Query Text

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


SELECT APPNO
,      CHOICENO
,      UCAS_CYCLE
,      LASTCHANGE
,      INST
,      COURSE
,      CAMPUS
,      FACULTY
,      HOME
,      DECISION
,      DECISIONDATE
,      DECISIONNUMBER
,      REPLY
,      SUMMARYCONDITIONS
,      ENTRYMONTH
,      ENTRYYEAR
,      ENTRYPOINT
,      CHOICECANCELLED
,      ACTION
,      SUBSTITUTION
,      DATESUBSTITUTED
,      PREVIOUSINST
,      PREVIOUSCOURSE
,      PREVIOUSCAMPUS
,      UCASAMENDMENT
,      ROUTEBPREF
,      ROUTEBROUND
,      DETAIL
,      EXTRAROUND
,      RESIDENTIAL
,      RECORD_STATUS
,      ERROR_CODE
FROM IGS.IGS_UC_ISTARC_INTS;

Dependencies

[top of page]

IGS.IGS_UC_ISTARC_INTS does not reference any database object

IGS.IGS_UC_ISTARC_INTS is referenced by following:

APPS: IGS_UC_ISTARC_INTS