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

TABLE: IGS.IGS_UC_MV_IVSTARH

Object Details
Object Name: IGS_UC_MV_IVSTARH
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_UC_MV_IVSTARH
Subobject Name:
Status: VALID


This view is HESA data for each applicant accepted by your institution. - OBSOLETE


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (8)
Application Number
TIMESTAMP DATE

Time stamp - date and time of last change
ETHNIC NUMBER (2)
Ethnic code
SOCIALCLASS VARCHAR2 (1)
Social Class
POCCEDUCHANGEDATE DATE

Date of change of Parental Occupation/Education details
POCC VARCHAR2 (4)
Parental Occupation Code
POCCTEXT VARCHAR2 (30)
EAS Parental Occupation Text
LASTEDUCATION NUMBER

Last educational establishment: Last school attended (DFE number) Last HE inst attended (HESA code) Zero if no details of leaving
EDUCATIONLEAVEDATE NUMBER

Year of leaving
LEA NUMBER (3)
Y = LEA in England/Wales N = not an LEA
SOCIALECONOMIC NUMBER (1)
Socio-economic classification
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPNO
,      TIMESTAMP
,      ETHNIC
,      SOCIALCLASS
,      POCCEDUCHANGEDATE
,      POCC
,      POCCTEXT
,      LASTEDUCATION
,      EDUCATIONLEAVEDATE
,      LEA
,      SOCIALECONOMIC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_MV_IVSTARH;

Dependencies

[top of page]

IGS.IGS_UC_MV_IVSTARH does not reference any database object

IGS.IGS_UC_MV_IVSTARH is referenced by following:

SchemaAPPS
SynonymIGS_UC_MV_IVSTARH