[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_UC_ISTARC_INTS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
RECORD_STATUS
APPNO CHOICENO UCAS_CYCLE |
Name | Datatype | Length | Mandatory | 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 |
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;
IGS.IGS_UC_ISTARC_INTS does not reference any database object
IGS.IGS_UC_ISTARC_INTS is referenced by following:
|
|
|