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]

VIEW: APPS.IGSBV_UC_TRANSACTIONS

Object Details

Object Name:	IGSBV_UC_TRANSACTIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_UC_TRANSACTIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Base View for UCAS Transactions table

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_SEQUENCE_ID	NUMBER		Yes	Unique Record Identifier
TRANSACTION_ID	NUMBER	(8)		Generated transaction identifier 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.)
APPLICANT_UCAS_NUMBER	NUMBER	(8)		Application number
APPLICANT_CHOICE_NUMBER	NUMBER	(2)		Application choice number
UCAS_CYCLE	NUMBER	(15)	Yes	UCAS cycle to which this application choice transaction belongs to
DECISION	VARCHAR2	(2)		Decision
UCAS_PROGRAM_CODE	VARCHAR2	(6)		UCAS course code
UCAS_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
SUMMARY_OF_CONDITIONS	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_FLAG	VARCHAR2	(1)	Yes	Update Sent to UCAS Flag
TEST_CONDITION_CATEGORY	VARCHAR2	(450)		Condition category for Test Transaction
TEST_CONDITION_NAME	VARCHAR2	(450)		Condition name for Test Transaction
INSTITUTION_REFERENCE	VARCHAR2	(8)		For Institute Reference
AUTO_GENERATED_FLAG	VARCHAR2	(1)		To Indicate whether the transaction generated manually or Automatically.
UCAS_SYSTEM_CODE	VARCHAR2	(1)	Yes	UCAS System Code
MODULAR	VARCHAR2	(1)		Valid for GTTR only
PART_TIME	VARCHAR2	(1)
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

Query Text

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


SELECT TRANSACTION_SEQUENCE_ID
,      TRANSACTION_ID
,      UPDATER
,      ERROR_CODE
,      TRANSACTION_TYPE
,      APPLICANT_UCAS_NUMBER
,      APPLICANT_CHOICE_NUMBER
,      UCAS_CYCLE
,      DECISION
,      UCAS_PROGRAM_CODE
,      UCAS_CAMPUS
,      ENTRY_MONTH
,      ENTRY_YEAR
,      ENTRY_POINT
,      SUMMARY_OF_CONDITIONS
,      COMMENTS_IN_OFFER
,      RETURN1
,      RETURN2
,      HOLD_FLAG
,      SENT_TO_UCAS_FLAG
,      TEST_CONDITION_CATEGORY
,      TEST_CONDITION_NAME
,      INSTITUTION_REFERENCE
,      AUTO_GENERATED_FLAG
,      UCAS_SYSTEM_CODE
,      MODULAR
,      PART_TIME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_UC_TRANSACTIONS;

Dependencies

[top of page]

APPS.IGSBV_UC_TRANSACTIONS references the following:

APPS: IGS_UC_TRANSACTIONS

APPS.IGSBV_UC_TRANSACTIONS is not referenced by any database object