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_OFF_ABRV

Object Details

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

Holds the list of UCAS offer abbreviations. It synchronizes with UCAS view 'cvRefOfferAbbrev' and is also used by 'uvOfferAbbrev'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_REF_OFF_ABRV_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ABBREV_CODE DELETED

Columns

Name	Datatype	Length	Mandatory	Comments
ABBREV_CODE	VARCHAR2	(2)	Yes	Offer Abbreviation code
UV_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view uvOfferAbbrev - Obsolete
UV_UPDATER	VARCHAR2	(20)		Synchronizes with UCAS value in uvOfferAbbrev.Updater
ABBREV_TEXT	VARCHAR2	(250)		Abbreviation description. Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev
LETTER_FORMAT	VARCHAR2	(1)		No Longer Used
SUMMARY_CHAR	VARCHAR2	(1)		Summary of Conditions character. Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev
UNCOND	VARCHAR2	(1)	Yes	Flags validity for unconditional offers (Y-Yes, N-No). Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev.
WITHDRAWAL	VARCHAR2	(1)	Yes	Flags validity for withdrawal decisions (Y-Yes, N-No). Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev
RELEASE	VARCHAR2	(1)	Yes	Flags validity for release into Clearing (Y-Yes, N-No). Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev
IMPORTED	VARCHAR2	(1)	Yes	Record imported from UCAS? ('Y' Yes, 'N' No)
SENT_TO_UCAS	VARCHAR2	(1)	Yes	Record sent to UCAS? ('Y' Yes, 'N' No)
DELETED	VARCHAR2	(1)	Yes	Marked for deletion (Y-Yes, N-No)
TARIFF	VARCHAR2	(1)		Indicates whether valid for use in Tariff Offers
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 ABBREV_CODE
,      UV_TIMESTAMP
,      UV_UPDATER
,      ABBREV_TEXT
,      LETTER_FORMAT
,      SUMMARY_CHAR
,      UNCOND
,      WITHDRAWAL
,      RELEASE
,      IMPORTED
,      SENT_TO_UCAS
,      DELETED
,      TARIFF
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_REF_OFF_ABRV;

Dependencies

[top of page]

IGS.IGS_UC_REF_OFF_ABRV does not reference any database object

IGS.IGS_UC_REF_OFF_ABRV is referenced by following:

APPS: IGS_UC_REF_OFF_ABRV