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_PS_OFR_PAT

Object Details

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

IGS_PS_OFR_PAT describes the offering pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_OFR_PAT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COURSE_CD VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER LOCATION_CD ATTENDANCE_MODE ATTENDANCE_TYPE
IGS_PS_OFR_PAT_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	COP_ID
IGS_PS_OFR_PAT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COURSE_CD VERSION_NUMBER LOCATION_CD ATTENDANCE_MODE ATTENDANCE_TYPE
IGS_PS_OFR_PAT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COO_ID
IGS_PS_OFR_PAT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_CD
IGS_PS_OFR_PAT_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_TYPE
IGS_PS_OFR_PAT_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_MODE
IGS_PS_OFR_PAT_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAL_TYPE CI_SEQUENCE_NUMBER
IGS_PS_OFR_PAT_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADING_SCHEMA_CD GS_VERSION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
COURSE_CD	VARCHAR2	(6)	Yes	Unique identifier for the program being offered.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset Expiry Date.
CAL_TYPE	VARCHAR2	(10)	Yes	Academic calendar type in that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organization.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the calendar instance.
LOCATION_CD	VARCHAR2	(10)	Yes	Location name or code. The location represents a geographical location and can be used to indicate if programs and units can be offered.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	Mode of attendance of the program offering pattern.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Attendance type of the program offering pattern.
COP_ID	NUMBER	(7)	Yes	Unique number for referencing the program offering pattern.
COO_ID	NUMBER	(7)	Yes	Unique number for referencing the program offering option.
OFFERED_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the program offering pattern is currently offered. Setting the checkbox ticked makes the program offering pattern available.
CONFIRMED_OFFERING_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the offering detail has been checked and confirmed subsequent to being rolled over from a previous version of the calendar. The confirmed checkbox can be set by default or left for manual checking.
ENTRY_POINT_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the program offering pattern is an admission entry point to the program. Setting the checkbox ticked makes the program offering pattern an entry point.
PRE_ENROL_UNITS_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether student unit attempts for the program offering pattern should be pre-enrolled as part of the pre-enrollment function.
ENROLLABLE_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the program offering pattern is available for student enrollment. Setting the checkbox ticked makes the program offering pattern available.
IVRS_AVAILABLE_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the program offering pattern is available through the Interactive Voice Response system (IVRS).
MIN_ENTRY_ASS_SCORE	NUMBER	(3)		Minimum entry assessment score required by an applicant to be considered for an offer of admission to a program offering pattern.
GUARANTEED_ENTRY_ASS_SCR	NUMBER	(3)		This score guarantees the applicant a firm offer of admission to the program. A program offering pattern assessment score takes precedence over a guaranteed assessment score established at the program offering instance level.
MAX_CROSS_FACULTY_CP	NUMBER	(6)		Maximum number of credit points in that a student can enroll, in an academic calendar, in units owned by faculties other than the faculty owning the student's program.
MAX_CROSS_LOCATION_CP	NUMBER	(6)		Maximum number of credit points in that a student may enroll, in an academic calendar, outside of their enrolled program location..
MAX_CROSS_MODE_CP	NUMBER	(6)		Maximum number of credit points in that a student may enroll, in an academic calendar, outside of their enrolled program attendance mode.
MAX_HIST_CROSS_FACULTY_CP	NUMBER	(6)		Maximum number of credit points in that a student can enroll, over the duration of the program, in units owned by faculties other than the faculty owning the student's program.
ADM_ASS_OFFICER_PERSON_ID	NUMBER	(15)		Person ID of a staff member recognized as the admission assessment officer responsible for the program offering pattern.
ADM_CONTACT_PERSON_ID	NUMBER	(15)		Person ID of a staff member recognized as the contact person responsible for the program offering pattern.
GRADING_SCHEMA_CD	VARCHAR2	(10)		Code that identifies the grading schema. A grading schema describes the set of available marks and grades that can be used in the assessment of student unit attempts. There can be multiple grading schemas for any one institution.
GS_VERSION_NUMBER	NUMBER	(3)		System generated number used to identify the version of the grading schema.
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.

Query Text

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


SELECT COURSE_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      COP_ID
,      COO_ID
,      OFFERED_IND
,      CONFIRMED_OFFERING_IND
,      ENTRY_POINT_IND
,      PRE_ENROL_UNITS_IND
,      ENROLLABLE_IND
,      IVRS_AVAILABLE_IND
,      MIN_ENTRY_ASS_SCORE
,      GUARANTEED_ENTRY_ASS_SCR
,      MAX_CROSS_FACULTY_CP
,      MAX_CROSS_LOCATION_CP
,      MAX_CROSS_MODE_CP
,      MAX_HIST_CROSS_FACULTY_CP
,      ADM_ASS_OFFICER_PERSON_ID
,      ADM_CONTACT_PERSON_ID
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_PS_OFR_PAT;

Dependencies

[top of page]

IGS.IGS_PS_OFR_PAT does not reference any database object

IGS.IGS_PS_OFR_PAT is referenced by following:

APPS: IGS_PS_OFR_PAT