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]

TABLE: IGS.IGS_CA_INST_REL

Object Details

Object Name:	IGS_CA_INST_REL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_CA_INST_REL
Subobject Name:
Status:	VALID

IGS_CA_INST_REL describes the relationships among calendar instances.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_CA_INST_REL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUB_CAL_TYPE SUB_CI_SEQUENCE_NUMBER SUP_CAL_TYPE SUP_CI_SEQUENCE_NUMBER
IGS_CA_INST_REL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUP_CAL_TYPE SUP_CI_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
SUB_CAL_TYPE	VARCHAR2	(10)	Yes	Institution-defined name of the subordinate calendar instance represented in the relationship. Typically the SEMESTER 1, TRIMESTER 2 teaching calendars would be subordinate to the STANDARD ACADEMIC YEAR calendar.
SUB_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the subordinate calendar instance.
SUP_CAL_TYPE	VARCHAR2	(10)	Yes	Institution-defined name of the superior calendar instance represented in the relationship. Typically the STANDARD ACADEMIC YEAR calendar would be superior to the SEMESTER 1 and TRIMESTER 2 teaching calendars.
SUP_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the superior calendar instance.
LOAD_RESEARCH_PERCENTAGE	NUMBER	(5)		Field describes the percentage of the parent academic calendar that applies to the related load subordinate calendar. For example, percentages applied against academic or load calendar relationships indicate how much of the annual research EFTSU applies to the load calendar. Where the standard academic year is measured across two load calendars, this value is generally set at 50%.
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUB_CAL_TYPE
,      SUB_CI_SEQUENCE_NUMBER
,      SUP_CAL_TYPE
,      SUP_CI_SEQUENCE_NUMBER
,      LOAD_RESEARCH_PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_CA_INST_REL;

Dependencies

[top of page]

IGS.IGS_CA_INST_REL does not reference any database object

IGS.IGS_CA_INST_REL is referenced by following:

APPS: IGS_CA_INST_REL