Table TD_TEACHING_SCHOOL_PERCENTAGE in DWST@WHSE.ISC-AIT.UPENN.EDU

This table contains data indicating the percentage of income which should go to a particular school for a particular course. A teaching group is an aggregate of schools which split the income from a course.
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	TEACHING_GROUP_KEY₁	INTEGER	Y		This is a portion of the primary key of the table and also a foreign key to the td_teaching_group table.
2	TEACHING_SCHOOL_KEY₂	INTEGER	Y		This is a portion of the primary key of the table and also represents the school which should receive the percentage..
3	TEACHING_SCHOOL_PERCENT	NUMBER(3)	Y	100	This is the percentage which the school should receive.

**Indexes on TD_TEACHING_SCHOOL_PERCENTAGE**
Uniqueness	Index Name	Columns
NON-UNIQUE	XIF2TD_TEACHING_SCHOOL_PERCENT	TEACHING_SCHOOL_KEY
NON-UNIQUE	XIF3TD_TEACHING_SCHOOL_PERCENT	TEACHING_GROUP_KEY
UNIQUE	SYS_C00511924	TEACHING_GROUP_KEY, TEACHING_SCHOOL_KEY

--------- No Triggers on TD_TEACHING_SCHOOL_PERCENTAGE ---------

**Foreign Key Constraints on TD_TEACHING_SCHOOL_PERCENTAGE**
Name	Columns	Ref Table Owner	Ref Table Name	Ref Columns	Delete Rule	Status	Deferrable	Deferred
SYS_C00511970	TEACHING_GROUP_KEY	DWST	TD_TEACHING_GROUP	TEACHING_GROUP_KEY	NO ACTION	ENABLED	No	No

**PK, UK, & Check Constraints on TD_TEACHING_SCHOOL_PERCENTAGE**
Name	Type	Condition	Status	Columns
SYS_C00511924	Primary Key		ENABLED	TEACHING_GROUP_KEY, TEACHING_SCHOOL_KEY

**Granted Privileges on TD_TEACHING_SCHOOL_PERCENTAGE**
Column	Grantee	Grantable Privilege(s)	Non-Grantable Privilege(s)
	ESTEMMLE		SELECT
	DWADMIN		ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK
	YALINGX		SELECT
	DWST_SUPPORT		SELECT
	TUITION_DIST_RL		SELECT

**Objects referenced by table TD_TEACHING_SCHOOL_PERCENTAGE**
Object Owner	Object Name	Object Type
DWST	TD_TEACHING_GROUP	Table

--------- No objects reference TD_TEACHING_SCHOOL_PERCENTAGE ---------