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

Object Details

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

View Type

A Business Intelligence System view

This is the base view for the entity Calendar Period Types which describe available calendar types.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Institution-defined name of a type of calendar used within the organization.
DESCRIPTION	VARCHAR2	(60)	Yes	Description of a type of calendar used within the institution.
_LA:S_CALENDAR_CATEGORY	CHAR	(50)		System-defined categorization of calendar types. Each calendar type is assigned a calendar category to enable the system to determine associated functionality for each type of calendar.
ABBREVIATION	VARCHAR2	(30)		Abbreviated description of a type of calendar used within the institution.
ARTS_TEACHING_CAL_TYPE_CD	VARCHAR2	(2)		Describes the ARTS teaching calendar type code that defines the teaching period. ARTS is the Automated Results Transfer System used by Tertiary Admissions Centres to transfer academic records between post-secondary educational institutions.
CLOSED_INDICATOR	VARCHAR2	(1)	Yes	Indicator that specifies if the calendar type is closed. If the Calendar Type is 'closed', then the system prevents use of the calendar type in new calendar instance records.
NOTES	VARCHAR2	(2000)		Text containing additional information or details about a calendar type.
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 CALENDAR_TYPE
,      DESCRIPTION
,      _LA:S_CALENDAR_CATEGORY
,      ABBREVIATION
,      ARTS_TEACHING_CAL_TYPE_CD
,      CLOSED_INDICATOR
,      NOTES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_CALENDAR_PERIOD_TYPES;

Dependencies

[top of page]

APPS.IGSBV_CALENDAR_PERIOD_TYPES references the following:

APPS: IGS_CA_TYPE

APPS.IGSBV_CALENDAR_PERIOD_TYPES is not referenced by any database object