eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_HE_POPDLHE_INTS

Object Details

Object Name:	IGS_HE_POPDLHE_INTS
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_HE_POPDLHE_INTS
Subobject Name:
Status:	VALID

Interface table to hold records loaded from the POPDLHE file supplied by HESA.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_HE_POPDLHE_INTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	POPDLHE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POPDLHE_ID	NUMBER		Yes	Unique record ID
HOME	VARCHAR2	(1)		Home / Other EU Flag
LVLQUAL	VARCHAR2	(1)		Level of qualification obtained
LINE	VARCHAR2	(13)		Data Transaction and Line Number
HUSID	VARCHAR2	(13)		Unique HESA ID
HIGHQUAL	VARCHAR2	(2)		DLHE Highest qualification obtained
SURNAME	VARCHAR2	(40)		Surname
FNAMES	VARCHAR2	(40)		Forenames
XQMODE01	VARCHAR2	(1)		Qualification mode of study
PTITLE	VARCHAR2	(80)		Program of study title
QUAL1	VARCHAR2	(2)		Qualification obtained 1
QUAL2	VARCHAR2	(2)		Qualification obtained 2
TTCID	VARCHAR2	(1)		Teacher training course identifier
OWNSTU	VARCHAR2	(20)		Institution's own student identifier
OWNPSD	VARCHAR2	(20)		Institution's own program identifier
POPDLHE	VARCHAR2	(1)		DLHE population identifier
RCIDENT	VARCHAR2	(1)		Research Council population identifier
CENSUS	VARCHAR2	(3)		Census (APR/JAN)
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column indicates who created this record
CREATION_DATE	DATE		Yes	Standard WHO column indicates when this record was created
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column indicates who updated this record last
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column indicates when this record was last updated
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT POPDLHE_ID
,      HOME
,      LVLQUAL
,      LINE
,      HUSID
,      HIGHQUAL
,      SURNAME
,      FNAMES
,      XQMODE01
,      PTITLE
,      QUAL1
,      QUAL2
,      TTCID
,      OWNSTU
,      OWNPSD
,      POPDLHE
,      RCIDENT
,      CENSUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_HE_POPDLHE_INTS;

Dependencies

[top of page]

IGS.IGS_HE_POPDLHE_INTS does not reference any database object

IGS.IGS_HE_POPDLHE_INTS is referenced by following:

APPS: IGS_HE_POPDLHE_INTS