[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_UC_IVSTARK_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_UC_IVSTARK_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| APPNO | NUMBER | (8) | Application Number | |
| TIMESTAMP | DATE | Time stamp - date and time of last change | ||
| APPLICATIONDATE | DATE | Application Date | ||
| SENTDATE | DATE | Date sent out | ||
| RUNSENT | NUMBER | (3) | Run/Batch number when sent | |
| CODEDCHANGEDATE | DATE | Coded information changed date | ||
| SCHOOL | NUMBER | (5) | School code | |
| RESCAT | VARCHAR2 | (1) | Residential Category | |
| FEELEVEL | VARCHAR2 | (1) | F - full fee ,S - single entry fee(UCAS fee level received from applicant) | |
| FEEPAYER | NUMBER | (2) | Fee Payer Code see CvRefFee | |
| FEETEXT | VARCHAR2 | (30) | EAS fee payer name | |
| APR | NUMBER | (3) | Refers to CvrefAPR - all values | |
| COUNTRYBIRTH | NUMBER | (3) | Refers to CvrefAPR - Countries | |
| NATIONALITY | NUMBER | (3) | Refers to cvrefAPR - Countries | |
| DUALNATIONALITY | VARCHAR2 | (40) | EAS - same format as Nationality, but contains other nationality | |
| WITHDRAWN | VARCHAR2 | (1) | Null - not withdrawn , C - candidate withdrew , R - reinstated ,W- UF withdrawal | |
| WITHDRAWNDATE | DATE | Date candidate withdrew or was reinstated | ||
| ROUTEB | VARCHAR2 | (1) | Y - route B is required | |
| EXAMCHANGEDATE | DATE | Exam details changed date | ||
| GCE | NUMBER | (1) | Number of GCE (A + AS) expected | |
| VCE | NUMBER | (1) | Number of VCE (A + AS + Double) expected | |
| SQA | VARCHAR2 | (1) | Y - SQA Candidate | |
| WINTER | NUMBER | (1) | Number of Winter A Levels | |
| PREVIOUSA | NUMBER | (1) | Number of previous A/AS/Higher/CSYS | |
| PREVIOUSAS | NUMBER | (1) | Number of previous Summer AS levels | |
| KEYSKILLS | NUMBER | (1) | Key Skills | |
| VOCATIONAL | VARCHAR2 | (1) | Null - not taking vocational exams , 1 - taking Higher BTEC (HNC/HND) , 2 - taking Lower BTEC (NC/ND) , 3 - taking Foundation Art and Design course | |
| BTEC | VARCHAR2 | (1) | Y - BTEC | |
| ILC | VARCHAR2 | (1) | Y - ILC | |
| AICE | VARCHAR2 | (1) | Y - AICE | |
| IB | VARCHAR2 | (1) | Y - International Baccalaureate | |
| MANUAL | VARCHAR2 | (1) | Y - manual investigation of previous results required | |
| REGNO | VARCHAR2 | (10) | TEC registration number | |
| SCN | VARCHAR2 | (9) | Scottish Candidate Number | |
| OEQ | VARCHAR2 | (1) | Other Examination Qualifications | |
| PREVOEQ | VARCHAR2 | (1) | Previous Other Examination Qualifications | |
| EAS | VARCHAR2 | (1) | Y - Applied through EAS | |
| ROA | VARCHAR2 | (1) | Y - record of achievement | |
| 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 | |
| CRIMINALCONV | VARCHAR2 | (1) | Criminal Convictions - Y, N, NULL | |
| UKENTRYDATE | DATE | Date of first entry to UK | ||
| STATUS | VARCHAR2 | (1) | Status | |
| FIRMNOW | NUMBER | (1) | Firm choice number | |
| FIRMREPLY | NUMBER | (1) | Firm Reply | |
| INSURANCEREPLY | NUMBER | (1) | insurance Reply | |
| CONFHISTFIRMREPLY | NUMBER | (1) | Confirmation history firm reply | |
| CONFHISTINSURANCEREPLY | NUMBER | (1) | Confirmation history insurance reply | |
| CHOICESALLTRANSPARENT | VARCHAR2 | (1) | Indicates whether the Student Applications Choices are visible to institution or not | |
| EXTRASTATUS | NUMBER | (1) | Indicates whether the applicant is in extra processing | |
| EXTRAPASSPORTNO | VARCHAR2 | (6) | Passport ID used in UCAS Extra. For applicants applying on web will contain WEB | |
| WELSHSPEAKER | VARCHAR2 | (1) | SWAS - Welsh Speaker | |
| NINUMBER | VARCHAR2 | (9) | NMAS - National Insurance Number | |
| EARLIESTSTART | VARCHAR2 | (4) | NMAS - Earliest Start Date | |
| NEARINST | VARCHAR2 | (4) | NMAS - Nearest Institution | |
| PREFREG | NUMBER | NMAS - Preferred Region | ||
| QUALENG | VARCHAR2 | (1) | NMAS - Qualified in English | |
| QUALMATH | VARCHAR2 | (1) | NMAS - Qualified in Maths | |
| QUALSCI | VARCHAR2 | (1) | NMAS - Qualified in Science | |
| MAINQUAL | VARCHAR2 | (1) | NMAS - Main Qualification | |
| QUAL5 | VARCHAR2 | (1) | NMAS - Qualified with 5 Points |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, APPLICATIONDATE
, SENTDATE
, RUNSENT
, CODEDCHANGEDATE
, SCHOOL
, RESCAT
, FEELEVEL
, FEEPAYER
, FEETEXT
, APR
, COUNTRYBIRTH
, NATIONALITY
, DUALNATIONALITY
, WITHDRAWN
, WITHDRAWNDATE
, ROUTEB
, EXAMCHANGEDATE
, GCE
, VCE
, SQA
, WINTER
, PREVIOUSA
, PREVIOUSAS
, KEYSKILLS
, VOCATIONAL
, BTEC
, ILC
, AICE
, IB
, MANUAL
, REGNO
, SCN
, OEQ
, PREVOEQ
, EAS
, ROA
, SPECIALNEEDS
, CRIMINALCONV
, UKENTRYDATE
, STATUS
, FIRMNOW
, FIRMREPLY
, INSURANCEREPLY
, CONFHISTFIRMREPLY
, CONFHISTINSURANCEREPLY
, CHOICESALLTRANSPARENT
, EXTRASTATUS
, EXTRAPASSPORTNO
, WELSHSPEAKER
, NINUMBER
, EARLIESTSTART
, NEARINST
, PREFREG
, QUALENG
, QUALMATH
, QUALSCI
, MAINQUAL
, QUAL5
FROM APPS.IGS_UC_IVSTARK_V;
APPS
IGS_UC_MV_IVSTARK
IGS_UC_SS_IVSTARK
APPS.IGS_UC_IVSTARK_V is not referenced by any database object
|
|
|
|