[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_IVNSTARK_2007_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_IVNSTARK_2007_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for IVNSTARK for the UCAS 2007 Cycle
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPNO | NUMBER | (22) | Application Number | |
TIMESTAMP | DATE | Time stamp - date and time of last change | ||
APPLICATIONDATE | DATE | Application Date | ||
SENTDATE | DATE | Date sent out | ||
RUNSENT | NUMBER | (22) | Run or Batch number when sent | |
CODEDCHANGEDATE | DATE | Coded information changed date | ||
RESCAT | VARCHAR2 | (1) | Residency category code | |
FEELEVEL | VARCHAR2 | (1) | F-full fee, S-single entry fee, UCAS fee level received from applicant | |
APR | NUMBER | (22) | Refers to cvrefAPR - all values | |
COUNTRYBIRTH | NUMBER | (22) | Refers to cvrefAPR - Countries | |
NATIONALITY | NUMBER | (22) | Refers to cvrefAPR - Countries | |
WITHDRAWN | VARCHAR2 | (1) | Null - not withdrawn, C - candidate withdrew, R - reinstated, W - UF withdrawal | |
WITHDRAWNDATE | DATE | Date candidate withdrew or was reinstated | ||
QUALENGLISH | VARCHAR2 | (1) | Qualified in English | |
QUALMATHS | VARCHAR2 | (1) | Qualified in Maths | |
QUALSCIENCE | VARCHAR2 | (1) | Qualified in Science | |
QUAL5POINT | VARCHAR2 | (1) | Qualified with 5 Points | |
QUALMAIN | VARCHAR2 | (1) | Main qualification | |
NATIONALINSURANCE | VARCHAR2 | (12) | National Insurance Number | |
STARTDATE | VARCHAR2 | (4) | Earliest Start Date | |
NEARESTINST | VARCHAR2 | (4) | Nearest Institution | |
PREFREGION | NUMBER | (22) | Preferred Region | |
SPECIALNEEDS | VARCHAR2 | (1) | 0 - No disability, 1 - Dyslexia, 2 - Blind or partial sight, 3 - Deaf or partial hearing, 4 - Wheelchair or mobility, 5 - Personal care, 6 - Mental health, 7 - Unseen disability, 8 - Multiple disabilities, 9 - Other disability | |
STATUS | VARCHAR2 | (3) | See cvRefStatus | |
FIRMNOW | NUMBER | (22) | Firm choice number | |
UKENTRYDATE | DATE | Date of first entry to UK | ||
EAS | VARCHAR2 | (1) | EAS | |
DISABILITY | VARCHAR2 | (1) | See cvRefDis |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, APPLICATIONDATE
, SENTDATE
, RUNSENT
, CODEDCHANGEDATE
, RESCAT
, FEELEVEL
, APR
, COUNTRYBIRTH
, NATIONALITY
, WITHDRAWN
, WITHDRAWNDATE
, QUALENGLISH
, QUALMATHS
, QUALSCIENCE
, QUAL5POINT
, QUALMAIN
, NATIONALINSURANCE
, STARTDATE
, NEARESTINST
, PREFREGION
, SPECIALNEEDS
, STATUS
, FIRMNOW
, UKENTRYDATE
, EAS
, DISABILITY
FROM APPS.IGS_UC_IVNSTARK_2007_V;
|
|
|