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_CALENDAR_PERIOD_TYPES

Object Details

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

View Type

A Business Intelligence System view

This is the full view for the entity Calendar Period Types which describes 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.
ARTS_TEACHING_CAL_TYPE_DESC	VARCHAR2	(60)		Explanation for the automated results transfer system teaching calendar type code.
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
,      ARTS_TEACHING_CAL_TYPE_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_CALENDAR_PERIOD_TYPES;

Dependencies

[top of page]

APPS.IGSFV_CALENDAR_PERIOD_TYPES references the following:

APPS: IGS_CA_ARTS_TC_CA_CD; IGS_CA_TYPE

APPS.IGSFV_CALENDAR_PERIOD_TYPES is not referenced by any database object