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

Tables

This table is used to contain taxable status. Rows which reference the non taxable row of this table represent courses which do not pay University Tax. Rows which reference the taxable row represent courses which do pay University Tax.
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	NON_TAXABLE_KEY	INTEGER	Y		Non Taxable Key is the Primary Key for the DWST.TD_NON_TAXABLE table
2	TAXABLE_DESC	VARCHAR2(13 BYTE)			Taxable Desc(ription) is a 13 character field, loaded manually during schema creation.

**Indexes on TD_NON_TAXABLE**
Uniqueness	Index Name	Columns
UNIQUE	SYS_C00511913	NON_TAXABLE_KEY

Triggers on TD_NON_TAXABLE

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_NON_TAXABLE_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_NON_TAXABLE_PK_SEQ.NEXTVAL INTO :NEW.NON_TAXABLE_KEY FROM dual;

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

**PK, UK, & Check Constraints on TD_NON_TAXABLE**
Name	Type	Condition	Status	Columns
SYS_C00511913	Primary Key		ENABLED	NON_TAXABLE_KEY

**Granted Privileges on TD_NON_TAXABLE**
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_NON_TAXABLE does not reference any objects ---------

**Objects which reference table TD_NON_TAXABLE**
Object Owner	Object Name	Object Type
DWST	TD_DISTRIBUTION_FACT	Table (FK)
DWST	TD_INSTR_PROGRAM_TUITION_FACT	Table (FK)
DWST	TD_NON_TAXABLE_PK_TRIG	Trigger