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_TRANSACTIONS

Object Details

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

Holds the admission process transactions that are need to be written to the UCAS view 'TranIn'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UC_TRAN_ID
IGS_UC_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APP_NO CHOICE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
UC_TRAN_ID	NUMBER		Yes	Unique Record Identifier
TRANSACTION_ID	NUMBER	(8)		Generated transaction identifier from UCAS .
DATETIMESTAMP	DATE			Timestamp of record from UCAS
UPDATER	VARCHAR2	(20)		ID of last updater
ERROR_CODE	NUMBER	(3)		Error code from UCAS .
TRANSACTION_TYPE	VARCHAR2	(2)	Yes	Transaction type('LD',LA' etc.)
APP_NO	NUMBER	(8)		Application Number
CHOICE_NO	NUMBER	(2)		Application choice number.
DECISION	VARCHAR2	(2)		Decision
PROGRAM_CODE	VARCHAR2	(6)		UCAS Program code
CAMPUS	VARCHAR2	(1)		UCAS campus code
ENTRY_MONTH	NUMBER	(2)		Month of entry
ENTRY_YEAR	NUMBER	(2)		Year of entry
ENTRY_POINT	NUMBER	(1)		Point of entry
SOC	VARCHAR2	(6)		Summary of conditions
COMMENTS_IN_OFFER	VARCHAR2	(591)		Comments in offer
RETURN1	NUMBER	(5)		Holds value returned by IGS_UC_TRANSACTIONS.return1
RETURN2	VARCHAR2	(1280)		Holds value returned by IGS_UC_TRANSACTIONS.return2
HOLD_FLAG	VARCHAR2	(1)	Yes	Do not transmit transaction(Y- yes , N-no)
SENT_TO_UCAS	VARCHAR2	(1)	Yes	Update sent to UCAS ('Y' Yes, 'N' No)
CREATED_BY	NUMBER	(15)	Yes	Standard WHO columns
CREATION_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO columns
TEST_COND_CAT	VARCHAR2	(450)		Condition Category for test transaction type. Not populated for non-test transaction types.
TEST_COND_NAME	VARCHAR2	(450)		Condition Name for test transaction type. Not populated for non-test transaction types.
INST_REFERENCE	VARCHAR2	(8)		For institution use
AUTO_GENERATED_FLAG	VARCHAR2	(1)		To indicate whether the Transaction is created automatically or manually (Y-yes, N - No).
SYSTEM_CODE	VARCHAR2	(1)	Yes	UCAS System Code
UCAS_CYCLE	NUMBER	(15)	Yes	UCAS Cycle to which this application choice belongs to
MODULAR	VARCHAR2	(1)		Valid for GTTR only, default value = NULL
PART_TIME	VARCHAR2	(1)		Valid for GTTR only, default value = NULL

Query Text

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


SELECT UC_TRAN_ID
,      TRANSACTION_ID
,      DATETIMESTAMP
,      UPDATER
,      ERROR_CODE
,      TRANSACTION_TYPE
,      APP_NO
,      CHOICE_NO
,      DECISION
,      PROGRAM_CODE
,      CAMPUS
,      ENTRY_MONTH
,      ENTRY_YEAR
,      ENTRY_POINT
,      SOC
,      COMMENTS_IN_OFFER
,      RETURN1
,      RETURN2
,      HOLD_FLAG
,      SENT_TO_UCAS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TEST_COND_CAT
,      TEST_COND_NAME
,      INST_REFERENCE
,      AUTO_GENERATED_FLAG
,      SYSTEM_CODE
,      UCAS_CYCLE
,      MODULAR
,      PART_TIME
FROM IGS.IGS_UC_TRANSACTIONS;

Dependencies

[top of page]

IGS.IGS_UC_TRANSACTIONS does not reference any database object

IGS.IGS_UC_TRANSACTIONS is referenced by following:

APPS: IGS_UC_TRANSACTIONS