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.IGSFV_UC_TRANSACTIONS

Object Details

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

View Type

A Business Intelligence System view

Full 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.)
PERSONAL_ID	VARCHAR2	(10)		Unique Personal Identifier
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)		Valid for GTTR only
UCAS_SYSTEM_NAME	VARCHAR2	(10)		UCAS System Name
UCAS_SYSTEM_DESCRIPTION	VARCHAR2	(240)		UCAS System Description
TRANSACTION_TYPE_DESCRIPTION	VARCHAR2	(60)		UCAS Transaction Type description
OSS_PERSON_NUMBER	VARCHAR2	(30)		OSS Person Number
OSS_PERSON_NAME	VARCHAR2	(360)		OSS Person Name
ERROR_CODE_DESCRIPTION	VARCHAR2	(300)		Error Code Description
UCAS_COURSE_SHORT_TITLE	VARCHAR2	(20)		UCAS Course Title
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
,      PERSONAL_ID
,      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
,      UCAS_SYSTEM_NAME
,      UCAS_SYSTEM_DESCRIPTION
,      TRANSACTION_TYPE_DESCRIPTION
,      OSS_PERSON_NUMBER
,      OSS_PERSON_NAME
,      ERROR_CODE_DESCRIPTION
,      UCAS_COURSE_SHORT_TITLE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_TRANSACTIONS;

Dependencies

[top of page]

APPS.IGSFV_UC_TRANSACTIONS references the following:

APPS: HZ_PARTIES; IGS_UC_APPLICANTS; IGS_UC_CRSE_DETS; IGS_UC_DEFAULTS; IGS_UC_REF_CODES; IGS_UC_TRANSACTIONS; IGS_UC_TRANS_TYPES

APPS.IGSFV_UC_TRANSACTIONS is not referenced by any database object