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

Joint degree percentage contains the specification of percentages which should be split between schools for particular joint degrees. A student in the Student Registration System (SRS) has one primary home school; the school in which they matriculated. Occasionally a student may enroll in a program which has pre-arranged splits between schools, commonly called joint degrees. In these cases, the partner schools agree to share the home school portion of the tuition. The student's record in SRS is labeled with a Joint Degree flag. The primary home school of that student maintains the Joint Degree code.
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	JOINT_DEGREE_KEY₁	INTEGER	Y		The primary key of the table.
2	HOME_SCHOOL_KEY₂	INTEGER	Y		The foreign key to the td_school table.
3	HOME_SCHOOL_PERCENT	NUMBER(3)			The percentage which should go to the school in this row.

**Indexes on TD_JOINT_DEGREE_PERCENTAGE**
Uniqueness	Index Name	Columns
NON-UNIQUE	XIF1TD_JOINT_DEGREE_PERCENTAGE	JOINT_DEGREE_KEY
NON-UNIQUE	XIF2TD_JOINT_DEGREE_PERCENTAGE	HOME_SCHOOL_KEY
UNIQUE	SYS_C00511912	JOINT_DEGREE_KEY, HOME_SCHOOL_KEY

--------- No Triggers on TD_JOINT_DEGREE_PERCENTAGE ---------

**Foreign Key Constraints on TD_JOINT_DEGREE_PERCENTAGE**
Name	Columns	Ref Table Owner	Ref Table Name	Ref Columns	Delete Rule	Status	Deferrable	Deferred
SYS_C00511955	JOINT_DEGREE_KEY	DWST	TD_JOINT_DEGREE	JOINT_DEGREE_KEY	NO ACTION	ENABLED	No	No
SYS_C00511956	HOME_SCHOOL_KEY	DWST	TD_SCHOOL	SCHOOL_KEY	NO ACTION	ENABLED	No	No

**PK, UK, & Check Constraints on TD_JOINT_DEGREE_PERCENTAGE**
Name	Type	Condition	Status	Columns
SYS_C00511912	Primary Key		ENABLED	JOINT_DEGREE_KEY, HOME_SCHOOL_KEY

**Granted Privileges on TD_JOINT_DEGREE_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_JOINT_DEGREE_PERCENTAGE**
Object Owner	Object Name	Object Type
DWST	TD_JOINT_DEGREE	Table
DWST	TD_SCHOOL	Table

--------- No objects reference TD_JOINT_DEGREE_PERCENTAGE ---------