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_PS_OFR_PAT_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COURSE_CD	VARCHAR2	(6)	Yes	The unique identifier for a course being offered.
VERSION_NUMBER	NUMBER	(3)	Yes	The version number of the course being offered. There can only be one version of a course with a system status of ACTIVE and an unset EXPIRY DATE.
ACAD_CAL_TYPE	VARCHAR2	(10)	Yes	The academic calendar type in which the course is offered. A calendar type is the institution-defined name of a type of calendar used within the organisation.
ACAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The unique identifier for the academic calendar instance.
ALTERNATE_CODE	VARCHAR2	(10)		The alternate short reference code for identifying a teaching or academic calendar instance. This code is used for mass keying of enrolments and unit/course offerings.
START_DT	DATE		Yes	The date from which the calendar instance becomes effective.
END_DT	DATE		Yes	The date from which the calendar instance is no longer effective.
CAL_STATUS	VARCHAR2	(10)	Yes	The status of the calendar instance, which indicates the level of activity of the calendar. Each status is mapped to one of the system statuses of ACTIVE, INACTIVE or PLANNED.
LOCATION_CD	VARCHAR2	(10)	Yes	This field is the location name or code. The location represents a geographical location and may be used to indicate where courses and units can be offered.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	The mode of attendance of the course offering pattern.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	The attendance type of the course offering pattern.
ENTRY_POINT_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether the course offering pattern is an admission entry point to the course. Setting the checkbox (ticked) makes the course offering pattern an entry point
ADM_CONTACT_PERSON_ID	NUMBER	(15)		The Person ID of a staff member recognised as the Contact Person responsible for the course offering pattern.
ADM_ASS_OFFICER_PERSON_ID	NUMBER	(15)		The Person ID of a staff member recognised as the Admission Assessment Officer responsible for the course offering pattern.
COURSE_TITLE	VARCHAR2	(90)	Yes	The full name of the course, (DETYA element 308).
COURSE_STATUS	VARCHAR2	(10)	Yes	An institution-defined course status which indicates the level of activity of the course version. A course is established with a status of PLANNED. For students to be enrolled in the course it must be ACTIVE.
COURSE_TYPE	VARCHAR2	(10)	Yes	An institution-defined course type. Course type indicates the type of higher education course. Each course type must map to a Government course type (DETYA element reference number 310). Examples: 1 (higher doctorate), 21 (diploma), 50 (non-award course).
STD_FT_COMPLETION_TIME	NUMBER	(3)		OBSOLETE. A DETYA code which indicates the standard time to complete therequirements of the course on a full-time basis (e.g. 30 = 3 years).Not in current use by DETYA, however this value is used inAdmissions to calculate the Expected Completion Period andYear values for an application.
STD_PT_COMPLETION_TIME	NUMBER	(3)		OBSOLETE A DETYA code which indicates the standard time to complete therequirements of the course on a part-time basis (e.g. 60 = 6 years).Not in current use by DETYA, however this value is used inAdmissions to calculate the Expected Completion Period andYear values for an application.
CREDIT_POINTS_REQUIRED	NUMBER	(6)		The minimum number of credit points required to complete course requirements.
STD_ANNUAL_LOAD	NUMBER	(7)		The number of credit points which constitute an annual full-time enrolment. This figure is used to calculate the EFTSU value of each unit. If the standard annual load varies across years of the course, this field is left blank and the Course Annual Load must be recorded in form CRSF12C0.
COURSE_TOTAL_EFTSU	NUMBER	(5)		The total Effective Full Time Student Units (EFTSU) for the course.
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


SELECT COURSE_CD
,      VERSION_NUMBER
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ALTERNATE_CODE
,      START_DT
,      END_DT
,      CAL_STATUS
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      ENTRY_POINT_IND
,      ADM_CONTACT_PERSON_ID
,      ADM_ASS_OFFICER_PERSON_ID
,      COURSE_TITLE
,      COURSE_STATUS
,      COURSE_TYPE
,      STD_FT_COMPLETION_TIME
,      STD_PT_COMPLETION_TIME
,      CREDIT_POINTS_REQUIRED
,      STD_ANNUAL_LOAD
,      COURSE_TOTAL_EFTSU
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_OFR_PAT_V;

Dependencies

[top of page]

APPS.IGS_PS_OFR_PAT_V references the following:

APPS: IGS_CA_INST; IGS_PS_OFR_PAT; IGS_PS_VER

APPS.IGS_PS_OFR_PAT_V is not referenced by any database object