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_COURSE_VAC_OPTIONS

Object Details

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

View Type

A Business Intelligence System view

Full View for Course Vacancy Options

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UCAS_PROGRAM_CODE	VARCHAR2	(6)	Yes	UCAS course code
UCAS_INSTITUTE_CODE	VARCHAR2	(3)	Yes	UCAS Institute code
UCAS_CAMPUS_CODE	VARCHAR2	(1)	Yes	UCAS campus code
UCAS_SYSTEM_CODE	VARCHAR2	(1)	Yes	UCAS System Code
OPTION_CODE	VARCHAR2	(2)	Yes	Option code
CLEARING_UPDATED	VARCHAR2	(1)		Vacancies updated not notified (Y - yes)
CLEARING_UPDATED_DATE	DATE			Vacancies updated date
VACANCY_STATUS	VARCHAR2	(1)		Vacancy Status
_LA:VACANCY_STATUS_DESC	CHAR	(65)
SENT_TO_UCAS	VARCHAR2	(1)	Yes	Update sent to UCAS (Y - Yes, N - No)
UCAS_COURSE_SHORT_TITLE	VARCHAR2	(20)		Course short title
UCAS_COURSE_LONG_TITLE	VARCHAR2	(100)		Course long title
OSS_PROGRAM_CODE	VARCHAR2	(6)		Mapped OSS Program Code
OSS_PROGRAM_VERSION	NUMBER	(3)		Mapped OSS Program version
OSS_LOCATION_CODE	VARCHAR2	(10)		Mapped OSS location code
OSS_ATTENDANCE_TYPE	VARCHAR2	(2)		Mapped OSS Attendance Type
OSS_ATTENDANCE_MODE	VARCHAR2	(2)		Mapped OSS Attendance Mode
CLEARING_OPTIONS_FLAG	VARCHAR2	(1)		Indicates whether to use Clearing Option Codes for this course
UCAS_SYSTEM_NAME	VARCHAR2	(10)		UCAS System Name
UCAS_SYSTEM_DESCRIPTION	VARCHAR2	(240)		UCAS System Description
UCAS_INSTITUTION_ABBREVIATION	VARCHAR2	(5)		UCAS Institution Abbreviation
UCAS_INSTITUTION_NAME	VARCHAR2	(20)		UCAS Institution Name
OSS_PROGRAM_TITLE	VARCHAR2	(90)		OSS Program Title
OSS_PROGRAM_SHORT_TITLE	VARCHAR2	(40)		OSS Program Short Title
OSS_ATTENDANCE_TYPE_DESC	VARCHAR2	(60)		OSS Attendance Type Description
OSS_ATTENDANCE_MODE_DESC	VARCHAR2	(60)		OSS Attendance Mode Description
UPDATER_IDENTIFIER	VARCHAR2	(20)	Yes	Identifier of the last updater
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 UCAS_PROGRAM_CODE
,      UCAS_INSTITUTE_CODE
,      UCAS_CAMPUS_CODE
,      UCAS_SYSTEM_CODE
,      OPTION_CODE
,      CLEARING_UPDATED
,      CLEARING_UPDATED_DATE
,      VACANCY_STATUS
,      _LA:VACANCY_STATUS_DESC
,      SENT_TO_UCAS
,      UCAS_COURSE_SHORT_TITLE
,      UCAS_COURSE_LONG_TITLE
,      OSS_PROGRAM_CODE
,      OSS_PROGRAM_VERSION
,      OSS_LOCATION_CODE
,      OSS_ATTENDANCE_TYPE
,      OSS_ATTENDANCE_MODE
,      CLEARING_OPTIONS_FLAG
,      UCAS_SYSTEM_NAME
,      UCAS_SYSTEM_DESCRIPTION
,      UCAS_INSTITUTION_ABBREVIATION
,      UCAS_INSTITUTION_NAME
,      OSS_PROGRAM_TITLE
,      OSS_PROGRAM_SHORT_TITLE
,      OSS_ATTENDANCE_TYPE_DESC
,      OSS_ATTENDANCE_MODE_DESC
,      UPDATER_IDENTIFIER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_COURSE_VAC_OPTIONS;

Dependencies

[top of page]

APPS.IGSFV_UC_COURSE_VAC_OPTIONS references the following:

APPS: IGS_EN_ATD_MODE_ALL; IGS_EN_ATD_TYPE_ALL; IGS_PS_VER_ALL; IGS_UC_COM_INST; IGS_UC_CRSE_DETS; IGS_UC_CRSE_VAC_OPS; IGS_UC_DEFAULTS

APPS.IGSFV_UC_COURSE_VAC_OPTIONS is not referenced by any database object