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_UC_CRAMEND_INTS

Object Details

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

Holds date time stamps of Hercules views information loaded from UCAS

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Comments
APRDATE	DATE	Date time stamp of CVREFAPR view
DISDATE	DATE	Date time stamp of CVREFDIS view
ERRORDATE	DATE	Date time stamp of CVREFERROR view
ETHNICDATE	DATE	Date time stamp of CVREFETHNIC view
EXAMDATE	DATE	Date time stamp of CVREFEXAM view
FEEDATE	DATE	Date time stamp of CVREFFEE view
KEYWORDDATE	DATE	Date time stamp of CVREFKEYWORD view
OEQDATE	DATE	Date time stamp of CVREFOEQ view
OFFERABBREVDATE	DATE	Date time stamp of CVREFOFFERABBREV view
OFFERSUBJDATE	DATE	Date time stamp of CVREFOFFERSUBJ view
POCCDATE	DATE	Date time stamp of CVREFPOCC view
RESCATDATE	DATE	Date time stamp of CVREFRESCAT view
AWARDBODYDATE	DATE	Date time stamp of CVREFAWARDBODY view
STATUSDATE	DATE	Date time stamp of CVREFSTATUS view
UCASGROUPDATE	DATE	Date time stamp of CVREFUCASGROUP view
ESTABGROUP	DATE	Date time stamp of CVREFESTGROUP view
SCHOOLTYPE	DATE	Date time stamp of CVREFSCHOOLTYPE view
TARIFFDATE	DATE	Date time stamp of CVREFTARIFF view
JOINTADMISSIONS	DATE	Date time stamp of CVJOINTADMISSIONS view
COUNTRY	DATE	Date time stamp of CVREFCOUNTRY view
NATIONALITY	DATE	Date time stamp of CVREFNATIONALITY view

Query Text

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


SELECT APRDATE
,      DISDATE
,      ERRORDATE
,      ETHNICDATE
,      EXAMDATE
,      FEEDATE
,      KEYWORDDATE
,      OEQDATE
,      OFFERABBREVDATE
,      OFFERSUBJDATE
,      POCCDATE
,      RESCATDATE
,      AWARDBODYDATE
,      STATUSDATE
,      UCASGROUPDATE
,      ESTABGROUP
,      SCHOOLTYPE
,      TARIFFDATE
,      JOINTADMISSIONS
,      COUNTRY
,      NATIONALITY
FROM IGS.IGS_UC_CRAMEND_INTS;

Dependencies

[top of page]

IGS.IGS_UC_CRAMEND_INTS does not reference any database object

IGS.IGS_UC_CRAMEND_INTS is referenced by following:

APPS: IGS_UC_CRAMEND_INTS