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_DFT_LOAD_APPO

Object Details

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

IGS_ST_DFT_LOAD_APPO describes the portion of load that is attributed to a teaching period, that is defined as a percentage value. Used for determining load to be reported to the government. If no apportionment exists, 100 percent is assumed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_ST_DFT_LOAD_APPO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAL_TYPE CI_SEQUENCE_NUMBER TEACH_CAL_TYPE
IGS_ST_DFT_LOAD_APPO_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEACH_CAL_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
CAL_TYPE	VARCHAR2	(10)	Yes	Name of a type calendar used within the institution. For example, ACAD-YR, SEM-1, LOAD-1.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier of the calendar instance
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Name of the teaching calendar type that contributes load to the specified load calendar
PERCENTAGE	NUMBER	(5)	Yes	Default proportion of student load, expressed as a percentage, contributed by the teaching period to the specified load calendar instance. For example, 100 percent of the load generated in Semester 1 and 50 percent of the load generated in the YR-LONG teaching periods are included in load calendar 1. The second 50 percent of the load generated in the YR-LONG teaching period is included in load calendar 2.The default load apportionment can be overridden for particular units. The apportionment of student load to load calendars is used to calculate student program attendance type, effective full time student units credit point-based fees, contribution liabilities and for reporting to government.
SECOND_PERCENTAGE	NUMBER	(5)		The default proportion of student load, expressed as a percentage, contributed by the teaching period to the second instance of the specified load calendar. It is used in cases if a single teaching calendar is related to two instances of the same load calendar. For example, the teaching calendar S2-E1 that is start semester 2 - end semester 1 the following year contributes 0 percent of its load to the first instance of load calendar 1 that is because the census date in load calendar 1 precedes the commencement of teaching and 50 percent of its load to the second instance of load calenda 1. The remaining 50 percent of the load generated by S2-E1 is included in the first instance ofload calendar 2. This default load apportionment can be over-ridden for particular units.
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 CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      TEACH_CAL_TYPE
,      PERCENTAGE
,      SECOND_PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_ST_DFT_LOAD_APPO;

Dependencies

[top of page]

IGS.IGS_ST_DFT_LOAD_APPO does not reference any database object

IGS.IGS_ST_DFT_LOAD_APPO is referenced by following:

APPS: IGS_ST_DFT_LOAD_APPO