[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_UC_MV_IVSTARK |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_UC_MV_IVSTARK
|
| Subobject Name: | |
| Status: | VALID |
Coded information TABLE. This will contain a row for each applicant that you are allowed to see. - OBSOLETE
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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 0 cvRefFee | |
| FEETEXT | VARCHAR2 | (30) | EAS fee payer name | |
| APR | NUMBER | (3) | Refers to 0cvrefAPR - all values | |
| COUNTRYBIRTH | NUMBER | (3) | Refers to 0cvrefAPR - Countries | |
| NATIONALITY | NUMBER | (3) | Refers to 0cvrefAPR - 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 | ||
| WINTER | NUMBER | (1) | Number of Winter A Levels | |
| PREVIOUSA | NUMBER | (1) | Number of previous A/AS/Higher/CSYS | |
| 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 | |
| OEQ | VARCHAR2 | (1) | 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/partial sight, 3 - Deaf/partial hearing, 4 - Wheelchair/mobility, 5 - Personal care, 6 - Mental health, 7 - Unseen disability, 8 - Multiple disabilities, 9 - Other disability | |
| 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 | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| SCN | VARCHAR2 | (9) | Scottish Candidate Number | |
| PREVOEQ | VARCHAR2 | (1) | Previous Other Examination Qualifications | |
| 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 | |
| PREVIOUSAS | NUMBER | (1) | Number of previous Summer AS levels | |
| KEYSKILLS | NUMBER | (1) | Key Skills | |
| VOCATIONAL | VARCHAR2 | (1) | Null - not taking vocational exams1 - taking Higher BTEC (HNC/HND)2 - taking Lower BTEC (NC/ND)3 - taking Foundation Art & Design course | |
| CRIMINALCONV | VARCHAR2 | (1) | Criminal Convictions - Y, N, NULL | |
| UKENTRYDATE | DATE | Date of first entry to UK | ||
| 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'. |
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
, WINTER
, PREVIOUSA
, BTEC
, ILC
, AICE
, IB
, MANUAL
, REGNO
, OEQ
, EAS
, ROA
, SPECIALNEEDS
, STATUS
, FIRMNOW
, FIRMREPLY
, INSURANCEREPLY
, CONFHISTFIRMREPLY
, CONFHISTINSURANCEREPLY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SCN
, PREVOEQ
, GCE
, VCE
, SQA
, PREVIOUSAS
, KEYSKILLS
, VOCATIONAL
, CRIMINALCONV
, UKENTRYDATE
, CHOICESALLTRANSPARENT
, EXTRASTATUS
, EXTRAPASSPORTNO
FROM IGS.IGS_UC_MV_IVSTARK;
IGS.IGS_UC_MV_IVSTARK does not reference any database object
IGS.IGS_UC_MV_IVSTARK is referenced by following:
APPS
IGS_UC_MV_IVSTARK
|
|
|
|