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_CAL_OFFERINGS

Object Details

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

View Type

A Business Intelligence System view

This entity describes the offerings for a program calendar containing details of Program Code, calendar instance details and minimum / guaranteed assessment score.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_CODE	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.
LOCATION_CD	VARCHAR2	(10)	Yes	Location code, or campus, of the program offering option.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	Mode of attendance of the program offering option.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Attendance type of the program offering option.
FORCED_LOCATION_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the student program attempt location is forced or restricted. Setting the checkbox ticked causes the system to highlight the student program attempt location should a unit attempt location conflict with the forced attendance mode.
FORCED_ATT_MODE_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the student program attempt attendance mode is forced or restricted. Setting the checkbox ticked causes the system to highlight the student program attempt attendance mode should a unit attempt attendance mode conflict with the forced attendance mode.
FORCED_ATT_TYPE_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the student program attempt attendance type is forced or restricted. Setting the checkbox ticked causes the system to highlight the student program attempt attendance type should the derived attendance type conflict with the forced attendance type.
TIME_LIMITATION	NUMBER	(4)		Time limit in years for completion of the program offering option. Students who exceed this limit can be asked to show cause why they should not be excluded from further enrollment in the program.
ENR_OFFICER_PERSON_ID	NUMBER	(15)		The ID of a staff member recognized as the enrollment officer for the program offering option.
_DF	CHAR	(35)		Descriptive flex field.
PROGRAM_LENGTH	NUMBER	(10)		Length of the program
_LA:PROGRAM_LENGTH_MEASURE	CHAR	(83)		Program length measurement
DELETE_FLAG	VARCHAR2	(1)		This indicator to indicate a record is logically deleted or not. If set to 'Y' the record is logically deleted else not.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Program description.
CALENDAR_DESCRIPTION	VARCHAR2	(60)	Yes	Calendar description.
LOCATION_DESCRIPTION	VARCHAR2	(60)	Yes	Location description.
ATTENDANCE_TYPE_DESC	VARCHAR2	(60)	Yes	Attendance type description.
ATTENDANCE_MODE_DESC	VARCHAR2	(60)	Yes	Attendance mode description.
ENR_OFFICER_PERSON_NAME	VARCHAR2	(360)		Name of the staff member recognized as the enrollment officer for the program offering option.
COO_ID	NUMBER	(7)	Yes	Unique number that references the particular 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
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      FORCED_LOCATION_IND
,      FORCED_ATT_MODE_IND
,      FORCED_ATT_TYPE_IND
,      TIME_LIMITATION
,      ENR_OFFICER_PERSON_ID
,      _DF
,      PROGRAM_LENGTH
,      _LA:PROGRAM_LENGTH_MEASURE
,      DELETE_FLAG
,      PROGRAM_TITLE
,      CALENDAR_DESCRIPTION
,      LOCATION_DESCRIPTION
,      ATTENDANCE_TYPE_DESC
,      ATTENDANCE_MODE_DESC
,      ENR_OFFICER_PERSON_NAME
,      COO_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PROG_CAL_OFFERINGS;

Dependencies

[top of page]

APPS.IGSFV_PROG_CAL_OFFERINGS references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION_ALL; IGS_CA_TYPE; IGS_EN_ATD_MODE_ALL; IGS_EN_ATD_TYPE_ALL; IGS_PS_OFR_OPT_ALL; IGS_PS_VER_ALL

APPS.IGSFV_PROG_CAL_OFFERINGS is not referenced by any database object