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_CRSE_DETS

Object Details

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

Holds additional details for a course that are updated to UCAS views . Also holds details of courses run by other institutes , to synchronize with UCAS views 'cvCourse','uvCourse'

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_CRSE_DETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SYSTEM_CODE UCAS_PROGRAM_CODE INSTITUTE UCAS_CAMPUS

Columns

Name	Datatype	Length	Mandatory	Comments
UCAS_PROGRAM_CODE	VARCHAR2	(6)	Yes	UCAS course code
OSS_PROGRAM_CODE	VARCHAR2	(6)		Mapped OSS program code
OSS_PROGRAM_VERSION	NUMBER	(3)		Mapped OSS program version
INSTITUTE	VARCHAR2	(3)	Yes	Institute at which course is held
CVCOURSE_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view cvCourse - Obsolete
UVCOURSE_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view uvCourse - Obsolete
UVCRSEVAC_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view uvCrseVac - Obsolete
UVCOURSE_UPDATER	VARCHAR2	(20)		No Longer used
UVCRSEVAC_UPDATER	VARCHAR2	(20)		No Longer used
SHORT_TITLE	VARCHAR2	(20)		Course short title Synchronizes with UCAS view cvCourse , uvCourse
LONG_TITLE	VARCHAR2	(100)		Course long title Synchronizes with UCAS view cvCourse , uvCourse
UCAS_CAMPUS	VARCHAR2	(1)	Yes	UCAS campus code.Synchronizes with UCAS view cvcourse,uvCourse,uvCourseVacancies
OSS_LOCATION	VARCHAR2	(10)		Mapped OSS location code
FACULTY	VARCHAR2	(20)		UCAS faculty code.Synchronizes with UCAS view cvCourse , uvCourse
TOTAL_NO_OF_SEATS	NUMBER	(3)		Total number of seats on program
MIN_ENTRY_POINTS	NUMBER	(3)		Minimum entry points for program
MAX_ENTRY_POINTS	NUMBER	(3)		Maximum entry points for program
CURRENT_VALIDITY	VARCHAR2	(1)		validity for current year.Synchronizes with UCAS view cvCourse , uvCourse
DEFERRED_VALIDITY	VARCHAR2	(1)		Validity for deferred year.Synchronizes with UCAS view cvCourse , uvCourse
TERM_1_START	DATE			First term start date . Synchronizes with UCAS view uvCourse
TERM_1_END	DATE			First term end date . Synchronizes with UCAS view uvCourse
TERM_2_START	DATE			Second term start date . Synchronizes with UCAS view uvCourse
TERM_2_END	DATE			Second term end date . Synchronizes with UCAS view uvCourse
TERM_3_START	DATE			Third term start date . Synchronizes with UCAS view uvCourse
TERM_3_END	DATE			Third term end date . Synchronizes with UCAS view uvCourse
TERM_4_START	DATE			Fourth term start date . Synchronizes with UCAS view uvCourse
TERM_4_END	DATE			Fourth term end date . Synchronizes with UCAS view uvCourse
CL_UPDATED	VARCHAR2	(1)		Vacancies updated not notified (Y - yes).Synchronizes with UCAS view uvCourseVacancies
CL_DATE	DATE			Vacancies updated date.Synchronizes with UCAS view uvCourseVacancies
VACANCY_STATUS	VARCHAR2	(1)		Vacancy status(open/closed/overseas etc.) .Synchronizes with UCAS view uvCourseVacancies
NO_OF_VACANCY	VARCHAR2	(2)		Number of vacancies .Synchronizes with UCAS view uvCourseVacancies
SCORE	NUMBER	(3)		(00-30) synchronizes with UCAS view uvCourseVacancies
RB_FULL	VARCHAR2	(1)		(null - open , F-full) synchronizes with UCAS view uvCourseVacancies
SCOT_VAC	VARCHAR2	(6)		Up to 6 grades of 'A' ,'B', or 'C' .Synchronizes with UCAS view uvCourseVacancies
SENT_TO_UCAS	VARCHAR2	(1)	Yes	Update sent to UCAS ('Y' Yes, 'N' No)
UCAS_SYSTEM_ID	NUMBER	(15)		UCAS System Identifier
OSS_ATTENDANCE_TYPE	VARCHAR2	(2)		OSS Attendance Type
OSS_ATTENDANCE_MODE	VARCHAR2	(2)		OSS Attendance Mode
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
JOINT_ADMISSION_IND	VARCHAR2	(1)		Indicates that the course is joint admissions entity course. The value 'Y' indicates that the course is a joint admissions course.
OPEN_EXTRA_IND	VARCHAR2	(1)		Indicates whether the course is open for EXTRA applications or not.
SYSTEM_CODE	VARCHAR2	(1)	Yes	UCAS System Code
CLEARING_OPTIONS	VARCHAR2	(1)		Indicates whether to use Clearing Option Codes for this course
IMPORTED	VARCHAR2	(1)		Flag set to Y when record is imported from UCAS
KEYWRDS_CHANGED	VARCHAR2	(1)		Indicates whether the Course related Keywords are changed or not

Query Text

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


SELECT UCAS_PROGRAM_CODE
,      OSS_PROGRAM_CODE
,      OSS_PROGRAM_VERSION
,      INSTITUTE
,      CVCOURSE_TIMESTAMP
,      UVCOURSE_TIMESTAMP
,      UVCRSEVAC_TIMESTAMP
,      UVCOURSE_UPDATER
,      UVCRSEVAC_UPDATER
,      SHORT_TITLE
,      LONG_TITLE
,      UCAS_CAMPUS
,      OSS_LOCATION
,      FACULTY
,      TOTAL_NO_OF_SEATS
,      MIN_ENTRY_POINTS
,      MAX_ENTRY_POINTS
,      CURRENT_VALIDITY
,      DEFERRED_VALIDITY
,      TERM_1_START
,      TERM_1_END
,      TERM_2_START
,      TERM_2_END
,      TERM_3_START
,      TERM_3_END
,      TERM_4_START
,      TERM_4_END
,      CL_UPDATED
,      CL_DATE
,      VACANCY_STATUS
,      NO_OF_VACANCY
,      SCORE
,      RB_FULL
,      SCOT_VAC
,      SENT_TO_UCAS
,      UCAS_SYSTEM_ID
,      OSS_ATTENDANCE_TYPE
,      OSS_ATTENDANCE_MODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      JOINT_ADMISSION_IND
,      OPEN_EXTRA_IND
,      SYSTEM_CODE
,      CLEARING_OPTIONS
,      IMPORTED
,      KEYWRDS_CHANGED
FROM IGS.IGS_UC_CRSE_DETS;

Dependencies

[top of page]

IGS.IGS_UC_CRSE_DETS does not reference any database object

IGS.IGS_UC_CRSE_DETS is referenced by following:

APPS: IGS_UC_CRSE_DETS