[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_IVSTARJ_2004_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_IVSTARJ_2004_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
From 2004, applicant HESA information will be held in different Hercules views for different systems. This View selects the applicant HESA 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 | ||
HUSID | NUMBER | (15) | HESA unique student identifier | |
SCOTVEC | VARCHAR2 | (9) | Scottish candidate number | |
SURNAME | VARCHAR2 | (40) | Surname | |
FNAMES | VARCHAR2 | (40) | First name | |
GENDER | VARCHAR2 | (1) | Gender | |
DOMICILE | NUMBER | (15) | Domicile code | |
NATION | NUMBER | (15) | Nationality | |
ETHNIC | VARCHAR2 | (2) | Ethnic code | |
DISABLE | NUMBER | (15) | Disability code | |
YRLLINST | VARCHAR2 | (4) | Year Last left institution | |
OCCCODE | VARCHAR2 | (4) | Occupation code | |
QUALENT2 | VARCHAR2 | (2) | Highest Qualification on entry code | |
SBJQA1 | VARCHAR2 | (4) | Subject of qualification Aim 1 | |
SBJQA2 | VARCHAR2 | (4) | Subject of qualification Aim 2 | |
SBJQA3 | VARCHAR2 | (4) | Subject of qualification Aim 3 | |
SBJBID | VARCHAR2 | (1) | Qualification Aim proportion code | |
FEEELIG | VARCHAR2 | (1) | Fee eligibility | |
POSTCODE | VARCHAR2 | (8) | Post code | |
UCASNUM | NUMBER | (15) | UCAS applicant number | |
SEC | VARCHAR2 | (1) | Socio economic Code | |
SOC2000 | VARCHAR2 | (4) | Social Class indicator code | |
PREVINST | VARCHAR2 | (8) | Previous Institution | |
GCEASN | NUMBER | (15) | Number of GCE AS levels | |
GCEASTS | NUMBER | (15) | GCE AS Levels Tariff Score | |
VCEASN | NUMBER | (15) | No of VCE AS Levels | |
VCEASTS | NUMBER | (15) | VCE AS Levels Tariff Score | |
GCEAN | NUMBER | (15) | No of GCE A Levels | |
GCEATS | NUMBER | (15) | GCE A Levels Tariff Score | |
VCEAN | NUMBER | (15) | No of VCE A Levels | |
VCEATS | NUMBER | (15) | VCE A Levels Tariff Score | |
KSQN | NUMBER | (15) | No of Key Skills | |
KSQTS | NUMBER | (15) | Key Skills Tariff Score | |
UKSAN | NUMBER | (15) | No of 1 unit key skills | |
UKSATS | NUMBER | (15) | 1 unit key skills Tariff Score | |
SAHN | NUMBER | (15) | No of Advanced Highers | |
SAHTS | NUMBER | (15) | Advanced Highers Tariff Score | |
SHN | NUMBER | (15) | No of Highers | |
SHTS | NUMBER | (15) | No of Highers Tariff Score | |
SI2N | NUMBER | (15) | No of Intermediates | |
SI2TS | NUMBER | (15) | Intermediates Tariff Score | |
SSGCN | NUMBER | (15) | No of standard grade | |
SSGCTS | NUMBER | (15) | Standard grade Tariff Score | |
SCSN | NUMBER | (15) | No of Scottish core skills | |
SCSTS | NUMBER | (15) | Scottish core skills Tariff Score | |
AEAN | NUMBER | (15) | No of Advanced Extension Awards | |
AEATS | NUMBER | (15) | Advanced Extension Awards Tariff Score | |
TOTALTS | NUMBER | (15) | Total UCAS Tariff score | |
BIRTHDTE | VARCHAR2 | (10) | Date Of Birth |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, HUSID
, SCOTVEC
, SURNAME
, FNAMES
, GENDER
, DOMICILE
, NATION
, ETHNIC
, DISABLE
, YRLLINST
, OCCCODE
, QUALENT2
, SBJQA1
, SBJQA2
, SBJQA3
, SBJBID
, FEEELIG
, POSTCODE
, UCASNUM
, SEC
, SOC2000
, PREVINST
, GCEASN
, GCEASTS
, VCEASN
, VCEASTS
, GCEAN
, GCEATS
, VCEAN
, VCEATS
, KSQN
, KSQTS
, UKSAN
, UKSATS
, SAHN
, SAHTS
, SHN
, SHTS
, SI2N
, SI2TS
, SSGCN
, SSGCTS
, SCSN
, SCSTS
, AEAN
, AEATS
, TOTALTS
, BIRTHDTE
FROM APPS.IGS_UC_IVSTARJ_2004_V;
APPS.IGS_UC_IVSTARJ_2004_V is not referenced by any database object
|
|
|