DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_UC_IVSTARJ_2004

Object Details
Object Name: IGS_UC_IVSTARJ_2004
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_UC_IVSTARJ_2004
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.IGS_UC_IVSTARJ_2004 references the following:

SchemaAPPS
SynonymIGS_UC_ISTARJ_INTS
APPS.IGS_UC_IVSTARJ_2004 is referenced by following:

SchemaAPPS
SynonymIGS_UC_U_IVSTARJ_2004