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_REF_DATETIME

Object Details

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

Contains only one record at any given time. Each column will hold a date-time value with the following attributes -
Day
Month
Year
Hours
Minutes
Seconds
Each date-time stamp is associated with a single view and enables tracking of changes to the reference views at UCAS. It synchronizes with UCAS view 'cvRefAmendments'.
- OBSOLETE

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REF_APR	DATE			Timestamp to synchronize with UCAS view cvRefAPR
REF_DIS	DATE			Timestamp to synchronize with UCAS view cvRefDis
REF_ERROR	DATE			Timestamp to synchronize with UCAS view cvRefError
REF_ETHNIC	DATE			Timestamp to synchronize with UCAS view cvRefEthnic
REF_EXAM	DATE			Timestamp to synchronize with UCAS view cvRefExam
REF_FEE	DATE			Timestamp to synchronize with UCAS view cvRefFee
REF_KEYWORD	DATE			Timestamp to synchronize with UCAS view cvRefKeyword
REF_OEQ	DATE			Timestamp to synchronize with UCAS view cvRefOEQ
REF_OFFER_ABBREV	DATE			Timestamp to synchronize with UCAS view cvRefOfferAbbrev
REF_OFFER_SUBJ	DATE			Timestamp to synchronize with UCAS view cvRefOfferSubj
REF_POCC	DATE			Timestamp to synchronize with UCAS view cvRefPOCC
REF_RES_CAT	DATE			Timestamp to synchronize with UCAS view cvRefResCat
REF_AWARD_BODY	DATE			Timestamp to synchronize with UCAS view cvRefAwardBody
REF_STATUS	DATE			Timestamp to synchronize with UCAS view cvRefStatus
REF_UCAS_GROUP	DATE			Timestamp to synchronize with UCAS view cvRefUcasGroup
REF_EST_GROUP	DATE			Timestamp to synchronize with UCAS view cvRefEstGroup
REF_SCHOOL_TYPE	DATE			Timestamp to synchronize with UCAS view cvRefSchoolType
UCAS_SYNC	DATE			Timestamp of last data import from UCAS as seen in the 'Data Import' process screen.
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
REF_TARIFF	DATE			Timestamp to Synchronize with UCAS view cvRefTariff.
REF_JOINT_ADM	DATE			Timestamp to Synchronize with UCAS view cvJointAdmissions.

Query Text

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


SELECT REF_APR
,      REF_DIS
,      REF_ERROR
,      REF_ETHNIC
,      REF_EXAM
,      REF_FEE
,      REF_KEYWORD
,      REF_OEQ
,      REF_OFFER_ABBREV
,      REF_OFFER_SUBJ
,      REF_POCC
,      REF_RES_CAT
,      REF_AWARD_BODY
,      REF_STATUS
,      REF_UCAS_GROUP
,      REF_EST_GROUP
,      REF_SCHOOL_TYPE
,      UCAS_SYNC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REF_TARIFF
,      REF_JOINT_ADM
FROM IGS.IGS_UC_REF_DATETIME;

Dependencies

[top of page]

IGS.IGS_UC_REF_DATETIME does not reference any database object

IGS.IGS_UC_REF_DATETIME is referenced by following:

APPS: IGS_UC_REF_DATETIME