[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_UC_IVSTARK_2007_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_UC_IVSTARK_2007_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View that points to the IGS_UC_U_IVSTARK_2007 synonym
| 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' | |
| DISABILITY | 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 |
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
, DISABILITY
FROM APPS.IGS_UC_IVSTARK_2007_V;
APPS
IGS_UC_U_IVSTARK_2007
APPS
IGS_UC_LOAD_HERCULES_DATA
- show dependent code
|
|
|
|