[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_UC_IVSTARK_2003_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_UC_IVSTARK_2003_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
From 2004, applicant information will be held in different Hercules views for different systems. This View selects the pplicant information belonging to all the systems.
| 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 | ||
| SCHOOL | NUMBER | (22) | School code | |
| RESCAT | VARCHAR2 | (1) | Residency category code | |
| FEELEVEL | VARCHAR2 | (1) | F - full fee, S - single entry fee, (UCAS fee level received from applicant) | |
| FEEPAYER | NUMBER | (22) | Fee Payer Code see cvRefFee | |
| FEETEXT | VARCHAR2 | (30) | EAS fee payer name | |
| APR | NUMBER | (22) | Refers to cvrefAPR - all values | |
| LEA | VARCHAR2 | (1) | **FIELD NO LONGER USED (2002)** | |
| COUNTRYBIRTH | NUMBER | (22) | Refers to cvrefAPR - Countries | |
| NATIONALITY | NUMBER | (22) | Refers to cvrefAPR - Countries | |
| DUALNATIONALITY | NUMBER | (22) | 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 | ||
| ALEVELS | VARCHAR2 | (1) | ** FIELD NO LONGER USED (2002)** | |
| ASLEVELS | VARCHAR2 | (1) | ** FIELD NO LONGER USED (2002)** | |
| HIGHERS | VARCHAR2 | (1) | ** FIELD NO LONGER USED (2002)** | |
| CSYS | VARCHAR2 | (1) | ** FIELD NO LONGER USED (2002)** | |
| GCE | NUMBER | (22) | Number of GCE (A + AS) expected | |
| VCE | NUMBER | (22) | Number of VCE (A + AS + Double) expected | |
| SQA | VARCHAR2 | (1) | Y - SQA Candidate | |
| WINTER | NUMBER | (22) | Number of Winter A Levels | |
| PREVIOUSA | NUMBER | (22) | Number of previous Summer A levels | |
| PREVIOUSAS | NUMBER | (22) | Number of previous Summer AS levels | |
| KEYSKILLS | VARCHAR2 | (1) | Y - taking Key Skills, N - not taking Key Skills | |
| VOCATIONAL | VARCHAR2 | (1) | Null - not taking vocational exams, 1 - taking Higher BTEC (HNC or HND), 2 - taking Lower BTEC (NC or ND), 3 - taking Foundation Art & Design course | |
| GNVQ | VARCHAR2 | (1) | ** FIELD NO LONGER USED (2002)** | |
| 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 | (7) | BTEC 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 (EAS applicants only) | |
| 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 Conviction, Null - not know, Y - Yes, N - No | |
| UKENTRYDATE | DATE | Date of first entry to UK | ||
| STATUS | VARCHAR2 | (3) | See cvRefStatus | |
| FIRMNOW | NUMBER | (22) | Firm choice number | |
| FIRMREPLY | NUMBER | (22) | Firm Reply | |
| INSURANCEREPLY | NUMBER | (22) | Insurance Reply | |
| CONFHISTFIRMREPLY | NUMBER | (22) | Confirmation history firm reply | |
| CONFHISTINSURANCEREPLY | NUMBER | (22) | Confirmation history insurance reply | |
| CHOICESALLTRANSPARENT | VARCHAR2 | (1) | Applications Choices are visible to institution or not | |
| EXTRASTATUS | NUMBER | (22) | 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' |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, APPLICATIONDATE
, SENTDATE
, RUNSENT
, CODEDCHANGEDATE
, SCHOOL
, RESCAT
, FEELEVEL
, FEEPAYER
, FEETEXT
, APR
, LEA
, COUNTRYBIRTH
, NATIONALITY
, DUALNATIONALITY
, WITHDRAWN
, WITHDRAWNDATE
, ROUTEB
, EXAMCHANGEDATE
, ALEVELS
, ASLEVELS
, HIGHERS
, CSYS
, GCE
, VCE
, SQA
, WINTER
, PREVIOUSA
, PREVIOUSAS
, KEYSKILLS
, VOCATIONAL
, GNVQ
, BTEC
, ILC
, AICE
, IB
, MANUAL
, REGNO
, SCN
, OEQ
, PREVOEQ
, EAS
, ROA
, SPECIALNEEDS
, CRIMINALCONV
, UKENTRYDATE
, STATUS
, FIRMNOW
, FIRMREPLY
, INSURANCEREPLY
, CONFHISTFIRMREPLY
, CONFHISTINSURANCEREPLY
, CHOICESALLTRANSPARENT
, EXTRASTATUS
, EXTRAPASSPORTNO
FROM APPS.IGS_UC_IVSTARK_2003_V;
APPS
IGS_UC_U_IVSTARK_2003
APPS
IGS_UC_LOAD_HERCULES_DATA
- show dependent code
|
|
|
|