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_PROG_OFFERING_PATTERNS

Object Details

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

View Type

A Business Intelligence System view

This is a full view, which describes the Offering Pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_CODE	VARCHAR2	(6)	Yes	The unique identifier for the program being offered.
VERSION_NUMBER	NUMBER	(3)	Yes	The 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	The academic calendar type in which the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organisation.
CAL_INST_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The unique identifier for the calendar instance.
LOCATION_CODE	VARCHAR2	(10)	Yes	Represents a geographical location and used to indicate where program has been offered.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	The mode of attendance of the program offering pattern.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	The attendance type of the program offering pattern.
PROGRAM_OFFERING_PATTERN_ID	NUMBER	(7)	Yes	The unique identifier for referencing the program offering pattern.
OFFERED_INDICATOR	VARCHAR2	(1)	Yes	An indicator which specifies whether the program offering pattern is currently offered. Setting the checkbox (ticked) makes the program offering pattern available.
CONFIRMED_OFFERING_INDICATOR	VARCHAR2	(1)	Yes	An indicator which 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 (ticked) by default or left for manual checking.
ENTRY_POINT_INDICATOR	VARCHAR2	(1)	Yes	An indicator which 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_INDICATOR	VARCHAR2	(1)	Yes	An indicator which specifies whether student unit attempts for the program offering pattern should be pre-enrolled as part of the 'pre-enrolment' function. Setting the checkbox (ticked) will cause any units specified for the program offering pattern to be pre-enrolled.
ENROLLABLE_INDICATOR	VARCHAR2	(1)	Yes	An indicator which specifies whether the program offering pattern is available for student enrolment. Setting the checkbox (ticked) makes the program offering pattern available.
IVRS_AVAILABLE_INDICATOR	VARCHAR2	(1)	Yes	An indicator which specifies whether the program offering pattern is available through the Interactive Voice Response system (IVRS).
MIN_ENTRY_ASS_SCORE	NUMBER	(3)		The minimum entry assessment score required by an applicant to be considered for an offer of admission to a program offering pattern. A program offering pattern assessment score takes precedence over a minimum entry assessment score established at the program offering instance level.
GUARANTEED_ENTRY_ASS_SCR	NUMBER	(3)		An entry assessment score, which if achieved, 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)		The maximum number of credit points in which a student may enrol, in an academic calendar, in units owned by faculties other than the faculty owning the student's program. For example, a part-time student may not be able to enrol in more than two credit points from other faculties in an academic year.
MAX_CROSS_LOCATION_CP	NUMBER	(6)		The maximum number of credit points in which a student may enrol, in an academic calendar, outside of their enrolled program location. For example, a part-time student may not be able to enrol in more than two credit points at another campus in an academic year.
MAX_CROSS_MODE_CP	NUMBER	(6)		The maximum number of credit points in which a student may enrol, in an academic calendar, outside of their enrolled program attendance mode. For example, a part-time student may not be able to enrol in more than two credit points in another attendance mode in an academic year.
MAX_HIST_CROSS_FACULTY_CP	NUMBER	(6)		The maximum number of credit points in which a student may enrol, over the duration of the program, in units owned by faculties other than the faculty owning the student's program. For example, a student may not be able to exceed a cumulative total of eight credit points from other faculties.
GRADING_SCHEMA_CODE	VARCHAR2	(10)		The code that identifies the grading schema. A grading schema describes the set of available marks and grades which can be used in the assessment of student unit attempts. There may be multiple grading schemas for any one institution.
GRADING_SCHEMA_VERSION_NUMBER	NUMBER	(3)		A system generated number used to identify the version of the grading.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title of the program.
CALENDAR_DESCRIPTION	VARCHAR2	(60)	Yes	Description of the calendar.
CALENDAR_INSTANCE_DESC	VARCHAR2	(30)		Description of the calendar instance.
LOCATION_DESCRIPTION	VARCHAR2	(60)	Yes	Description of the location.
ATTENDANCE_MODE_DESCRIPTION	VARCHAR2	(60)	Yes	Description of the attendance mode.
ATTENDANCE_TYPE_DESCRIPTION	VARCHAR2	(60)	Yes	Description of the attendance type
ADM_CONTACT_PERSON_NUMBER	VARCHAR2	(30)		The person number of a staff member recognised as the Admission Assessment Officer responsible for the program offering pattern
ADM_ASSESSMENT_OFFICER_NUMBER	VARCHAR2	(30)		The person number of a staff member recognised as the Admission Assessment Officer responsible for the program offering pattern
ADM_CONTACT_PERSON_NAME	VARCHAR2	(360)		The person name of a staff member recognised as the Admission Assessment Officer responsible for the program offering pattern.
ADM_ASSESSMENT_OFFICER_NAME	VARCHAR2	(360)		The person name of a staff member recognised as the Admission Assessment Officer responsible for the program offering pattern.
GRADING_SCHEMA_DESCRIPTION	VARCHAR2	(60)		Description of grading schema.
ADM_ASS_OFFICER_PERSON_ID	NUMBER	(15)		The person identifier of a staff member recognised as the Admission Assessment Officer responsible for the program offering pattern.
ADM_CONTACT_PERSON_ID	NUMBER	(15)		The person identifier of a staff member recognised as the Contact Person responsible for the program offering pattern.
PROGRAM_OFFERING_OPTION_ID	NUMBER	(7)	Yes	The unique identifier for referencing the program offering option.
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.

Query Text

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


SELECT PROGRAM_CODE
,      VERSION_NUMBER
,      CAL_TYPE
,      CAL_INST_SEQUENCE_NUMBER
,      LOCATION_CODE
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      PROGRAM_OFFERING_PATTERN_ID
,      OFFERED_INDICATOR
,      CONFIRMED_OFFERING_INDICATOR
,      ENTRY_POINT_INDICATOR
,      PRE_ENROL_UNITS_INDICATOR
,      ENROLLABLE_INDICATOR
,      IVRS_AVAILABLE_INDICATOR
,      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
,      GRADING_SCHEMA_CODE
,      GRADING_SCHEMA_VERSION_NUMBER
,      PROGRAM_TITLE
,      CALENDAR_DESCRIPTION
,      CALENDAR_INSTANCE_DESC
,      LOCATION_DESCRIPTION
,      ATTENDANCE_MODE_DESCRIPTION
,      ATTENDANCE_TYPE_DESCRIPTION
,      ADM_CONTACT_PERSON_NUMBER
,      ADM_ASSESSMENT_OFFICER_NUMBER
,      ADM_CONTACT_PERSON_NAME
,      ADM_ASSESSMENT_OFFICER_NAME
,      GRADING_SCHEMA_DESCRIPTION
,      ADM_ASS_OFFICER_PERSON_ID
,      ADM_CONTACT_PERSON_ID
,      PROGRAM_OFFERING_OPTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PROG_OFFERING_PATTERNS;

Dependencies

[top of page]

APPS.IGSFV_PROG_OFFERING_PATTERNS references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION_ALL; IGS_AS_GRD_SCHEMA; IGS_CA_INST_ALL; IGS_CA_TYPE; IGS_EN_ATD_MODE_ALL; IGS_EN_ATD_TYPE_ALL; IGS_PS_OFR_INST; IGS_PS_OFR_OPT_ALL; IGS_PS_OFR_PAT; IGS_PS_VER_ALL

APPS.IGSFV_PROG_OFFERING_PATTERNS is not referenced by any database object