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_PGM_OFR_PATTERN_ADM_PERD

Object Details

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

View Type

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".

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.IGSFV_PGM_OFR_PATTERN_ADM_PERD references the following:

APPS: IGS_AD_CAT_ALL; IGS_AD_LOCATION_ALL; IGS_AD_PRD_AD_PRC_CA; IGS_CA_INST_ALL; IGS_CA_INST_REL; IGS_EN_ATD_MODE_ALL; IGS_EN_ATD_TYPE_ALL; IGS_PS_OFR_PAT; IGS_PS_OF_OPT_AD_CAT; IGS_PS_VER_ALL

APPS.IGSFV_PGM_OFR_PATTERN_ADM_PERD is not referenced by any database object