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

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

It will display the exam schedule for the sections for the students

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
UOO_ID	NUMBER	(7)	Yes	Unit Section ID
COURSE_CD	VARCHAR2	(6)	Yes	Program code for the section for the student
COURSEVERSION	NUMBER	(3)	Yes	Program version for the section for the student
CAL_TYPE	VARCHAR2	(10)	Yes	Teaching calendar for the section
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Calendar Instance Identifier for the section
PERSON_ID	NUMBER	(15)	Yes	Student Identifier
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)	Yes	Unit Section status
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit Class
CALL_NUMBER	NUMBER			Call Number
TITLE	VARCHAR2	(4000)		Title for the section
EXAM_DATE_TIME	VARCHAR2	(30)		Examination date and time
EXAM_DAY	VARCHAR2	(9)		Examination Day
LOCATION_CD	VARCHAR2	(10)		Exam Location Code
LOCATION_DESC	VARCHAR2	(60)		Exam Location Description
BUILDING	VARCHAR2	(164)		Building for exam
INSTRUCTOR_PERSON_NUMBER	VARCHAR2	(30)		Lead Instructor for the section
INSTRUCTOR_SURNAME	VARCHAR2	(363)		Lead Instructor name
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
SUA_LOCATION_CD	VARCHAR2	(10)	Yes	Unit Section Location Code
CORE_INDICATOR_CODE	VARCHAR2	(30)		The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null.
EXAM_TIMETABLE	VARCHAR2	(27)		EXAM TIMETABLE
EXAM_LOCATION	VARCHAR2	(172)		EXAM LOCATION

Query Text

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


SELECT ROW_ID
,      UOO_ID
,      COURSE_CD
,      COURSEVERSION
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      PERSON_ID
,      UNIT_ATTEMPT_STATUS
,      UNIT_CD
,      UNIT_CLASS
,      CALL_NUMBER
,      TITLE
,      EXAM_DATE_TIME
,      EXAM_DAY
,      LOCATION_CD
,      LOCATION_DESC
,      BUILDING
,      INSTRUCTOR_PERSON_NUMBER
,      INSTRUCTOR_SURNAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SUA_LOCATION_CD
,      CORE_INDICATOR_CODE
,      EXAM_TIMETABLE
,      EXAM_LOCATION
FROM APPS.IGS_SS_EN_USEC_EXAM_SCH_V;

Dependencies

[top of page]

APPS.IGS_SS_EN_USEC_EXAM_SCH_V references the following:

APPS: HZ_PARTIES; IGS_EN_STDNT_PS_ATT; IGS_EN_SU_ATTEMPT; IGS_PS_UNIT_OFR_OPT; IGS_PS_USEC_AS_V; IGS_PS_USEC_TCH_RESP; IGS_SS_ENR_DETAILS - show dependent code

APPS.IGS_SS_EN_USEC_EXAM_SCH_V is not referenced by any database object