[Home] [Help] [Dependency Information]
Object Name: | IGSBV_PROG_OFFERING_PATTERNS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_PROG_OFFERING_PATTERNS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This is a base view, which describes the Offering Pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.
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_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. |
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_ASS_OFFICER_PERSON_ID
, ADM_CONTACT_PERSON_ID
, PROGRAM_OFFERING_OPTION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_PROG_OFFERING_PATTERNS;
APPS.IGSBV_PROG_OFFERING_PATTERNS is not referenced by any database object
|
|
|