[Home] [Help] [Dependency Information]
Object Name: | IGSFV_PGM_OFR_PATTERN_ADM_PERD |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_PGM_OFR_PATTERN_ADM_PERD |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds the information about the Program Offering Options that are available for this Admission Period. This Full View will be based on the existing relational view 'IGS_PS_OFR_PAT_ADM_PERD_V'. The forms navigation is Admission > Admission Setup > Setup Calendar > Admission Period Calendars -> Admission Period Program Offering Pattern. The full view will be based upon the underlying view of this form".
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROGRAM_CODE | VARCHAR2 | (6) | Yes | Unique identifier for the program being offered. |
PROGRAM_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. |
PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Title or full name of the program. |
ACADEMIC_CALENDAR_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. |
ACADEMIC_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique identifier for the calendar instance. |
ACADEMIC_CALENDAR_DESC | VARCHAR2 | (30) | Description for the Calendar Instance | |
LOCATION_CODE | 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. |
LOCATION_DESC | VARCHAR2 | (60) | Yes | The description of a physical location owned or used by an institution. Each location has a location type, such as Campus, that defines its use in the system. |
ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | Mode of attendance of the program offering pattern. |
ATTENDANCE_MODE_DESC | VARCHAR2 | (60) | Yes | Description of an institution-defined attendance mode. An attendance mode identifies the mode of attendance for a program that student undertakes. Each attendance mode must be mapped to a government attendance type. |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | Attendance type of the program offering pattern. |
ATTENDANCE_TYPE_DESC | VARCHAR2 | (60) | Yes | Description of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year. |
PROG_OFFERING_OPTION_ID | NUMBER | (7) | Yes | Unique number for referencing the program offering option. |
_LA:OFFERED_IND_FLAG | CHAR | (52) | ||
_LA:ENTRY_POINT_IND | CHAR | (56) | ||
ADMISSION_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | |
ADMISSION_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | |
ADMISSION_CALENDAR_DESC | VARCHAR2 | (30) | ||
ADMISSION_CATEGORY | VARCHAR2 | (10) | Yes | |
ADMISSION_CATEGORY_DESC | VARCHAR2 | (60) | Yes | |
_LA:ADM_PROCESS_TYPE_MEANING | CHAR | (83) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PROGRAM_CODE
, PROGRAM_VERSION_NUMBER
, PROGRAM_TITLE
, ACADEMIC_CALENDAR_TYPE
, ACADEMIC_CI_SEQUENCE_NUMBER
, ACADEMIC_CALENDAR_DESC
, LOCATION_CODE
, LOCATION_DESC
, ATTENDANCE_MODE
, ATTENDANCE_MODE_DESC
, ATTENDANCE_TYPE
, ATTENDANCE_TYPE_DESC
, PROG_OFFERING_OPTION_ID
, _LA:OFFERED_IND_FLAG
, _LA:ENTRY_POINT_IND
, ADMISSION_CALENDAR_TYPE
, ADMISSION_CI_SEQUENCE_NUMBER
, ADMISSION_CALENDAR_DESC
, ADMISSION_CATEGORY
, ADMISSION_CATEGORY_DESC
, _LA:ADM_PROCESS_TYPE_MEANING
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_PGM_OFR_PATTERN_ADM_PERD;
APPS.IGSFV_PGM_OFR_PATTERN_ADM_PERD is not referenced by any database object
|
|
|