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_ST_UNT_LOAD_APPO

Object Details

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

IGS_ST_UNT_LOAD_APPO describes the apportion of load for a particular unit in a teaching period. For example, 75 percent in semester 1 only and 25 percent in semester 2 only.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_ST_UNT_LOAD_APPO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DLA_CAL_TYPE CI_SEQUENCE_NUMBER UNIT_CD VERSION_NUMBER TEACH_CAL_TYPE
IGS_ST_UNT_LOAD_APPO_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CD VERSION_NUMBER TEACH_CAL_TYPE
IGS_ST_UNT_LOAD_APPO_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DLA_CAL_TYPE CI_SEQUENCE_NUMBER TEACH_CAL_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
DLA_CAL_TYPE	VARCHAR2	(10)	Yes	Abbreviated name of the load calendar type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance
UNIT_CD	VARCHAR2	(10)	Yes	Code of a unit that contributes load to a specified load calendar during a particular teaching period
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the unit. Students are normally enrolled in the current version. Prior versions are end-dated.
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Name of the teaching calendar
PERCENTAGE	NUMBER	(5)	Yes	The proportion of student load that is effective full time student units expressed as a percentage, contributed by the unit in the teaching period to the specified load calendar instance. Unit load apportionment overrides standard teaching period load apportionment.
SECOND_PERCENTAGE	NUMBER	(5)		The proportion of student load that is effective full time student units expressed as a percentage, contributed by the unit in the teaching period to the second instance of the specified load calendar. It is used in cases where a single teaching calendar is related to two instances of the same load calendar. Unit load apportionment overrides the standard teaching load apportionment.
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 DLA_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      UNIT_CD
,      VERSION_NUMBER
,      TEACH_CAL_TYPE
,      PERCENTAGE
,      SECOND_PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_ST_UNT_LOAD_APPO;

Dependencies

[top of page]

IGS.IGS_ST_UNT_LOAD_APPO does not reference any database object

IGS.IGS_ST_UNT_LOAD_APPO is referenced by following:

APPS: IGS_ST_UNT_LOAD_APPO