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

Tables

*This table contains valid dual degrees used throughout the university.*
Col #	Column Name	Data Type	Not Null?	Comments
1	DUAL_DEGREE_KEY	INTEGER	Y	Dual Degree Key is the Primary Key for the DWST.TD_DUAL_DEGREE table. This is used in all tables as a foreign key (TD_STUDENT_REGISTRATION_FACT, TD_DISTRIBUTION_FACT)
2	DUAL_DEGREE_CODE	VARCHAR2(1 BYTE)		Dual Degree Code is a 1 character field, populated from SRS Data Dictionary values plus one record for all NULL values in the student data.
3	DUAL_DEGREE_DESC	VARCHAR2(30 BYTE)		Dual Degree Desc(ription) is a 30 character field, loaded from the SRS Data Dictionary for its related Dual Degree Code.

**Indexes on TD_DUAL_DEGREE**
Uniqueness	Index Name	Columns
UNIQUE	SYS_C00511903	DUAL_DEGREE_KEY

Triggers on TD_DUAL_DEGREE

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_DUAL_DEGREE_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_DUAL_DEGREE_PK_SEQ.NEXTVAL INTO :NEW.DUAL_DEGREE_KEY FROM dual;

   EXCEPTION
     WHEN OTHERS THEN
       -- Consider logging the error and then re-raise
       RAISE;
END ;

**PK, UK, & Check Constraints on TD_DUAL_DEGREE**
Name	Type	Condition	Status	Columns
SYS_C00511903	Primary Key		ENABLED	DUAL_DEGREE_KEY

**Granted Privileges on TD_DUAL_DEGREE**
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

--------- TD_DUAL_DEGREE does not reference any objects ---------

**Objects which reference table TD_DUAL_DEGREE**
Object Owner	Object Name	Object Type
DWST	TD_DISTRIBUTION_FACT	Table (FK)
DWST	TD_STUDENT_REGISTRATION_FACT	Table (FK)
DWST	TD_DUAL_DEGREE_PK_TRIG	Trigger