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_ENQUIRY_DETAILS

Object Details

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

View Type

A Business Intelligence System view

Full View for basic person details of a UCAS applicant making an Extra or Clearing application.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UCAS_APPLICANT_NUMBER	NUMBER	(8)	Yes	The UCAS applicant number
SURNAME	VARCHAR2	(150)		Surname of the Person.
GIVEN_NAMES	VARCHAR2	(150)		Given name of the Person.
SEX_CODE	VARCHAR2	(30)		Sex Code of the Person.
_LA:SEX_DESC	CHAR	(40)
BIRTH_DATE	DATE			Birth Date of the Person
PREFIX	VARCHAR2	(60)		Title of the Person
ADDRESS_LINE1	VARCHAR2	(240)		First line of the Identifying Address
ADDRESS_LINE2	VARCHAR2	(240)		Second line of the Identifying Address
ADDRESS_LINE3	VARCHAR2	(240)		Third line of the Identifying Address
ADDRESS_LINE4	VARCHAR2	(240)		Fourth line of the Identifying Address
COUNTRY	VARCHAR2	(60)		Country of the Identifying Address
POSTCODE	VARCHAR2	(60)		Postal Code of the Identifying Address
EMAIL	VARCHAR2	(240)		E-mail Address
TELEPHONE	VARCHAR2	(40)		Telephone Number
UCAS_SYSTEM_CODE	VARCHAR2	(1)		UCAS System Code
EXTRA_PASSPORT_NUMBER	VARCHAR2	(6)		Holds the applicants extra processing passport Number
REQUEST_APPL_DETAILS_IND	VARCHAR2	(1)		Request Applicant Details Indicator
REQUEST_COPY_APPL_FORM_IND	VARCHAR2	(1)		Request Copy Applicant Form Details Indicator
CLEARING_ENTRY_FORM_NUMBER	NUMBER	(9)		Applicant Clearing Entry Form Number
OSS_PERSON_IDENTIFIER	NUMBER	(15)		OSS Person ID
OSS_PERSON_NUMBER	VARCHAR2	(30)		OSS Person number
OSS_PERSON_NAME	VARCHAR2	(360)		OSS Person name
UCAS_SYSTEM_NAME	VARCHAR2	(10)		UCAS System name
UCAS_SYSTEM_DESCRIPTION	VARCHAR2	(240)		UCAS System Description
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

Query Text

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


SELECT UCAS_APPLICANT_NUMBER
,      SURNAME
,      GIVEN_NAMES
,      SEX_CODE
,      _LA:SEX_DESC
,      BIRTH_DATE
,      PREFIX
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      COUNTRY
,      POSTCODE
,      EMAIL
,      TELEPHONE
,      UCAS_SYSTEM_CODE
,      EXTRA_PASSPORT_NUMBER
,      REQUEST_APPL_DETAILS_IND
,      REQUEST_COPY_APPL_FORM_IND
,      CLEARING_ENTRY_FORM_NUMBER
,      OSS_PERSON_IDENTIFIER
,      OSS_PERSON_NUMBER
,      OSS_PERSON_NAME
,      UCAS_SYSTEM_NAME
,      UCAS_SYSTEM_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_ENQUIRY_DETAILS;

Dependencies

[top of page]

APPS.IGSFV_UC_ENQUIRY_DETAILS references the following:

APPS: HZ_PARTIES; IGS_UC_APPLICANTS; IGS_UC_DEFAULTS; IGS_UC_ENQ_DETAILS

APPS.IGSFV_UC_ENQUIRY_DETAILS is not referenced by any database object