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

Tables

Reserve is a financial concept, used to account for the amount of money which offsets unpaid receivables. In double entry accounting, reserve offsets bad debt. Student Financial Services (SFS) is responsible for making the reserve and bad debt journal entries, based on their billing rates. They track the collection rates for each academic division at Penn.
Col #	Column Name	Data Type	Not Null?	Comments
1	RESERVE_KEY	INTEGER	Y	The primary key of the table.
2	DATE_KEY	INTEGER	Y	The foreign key to the td_time_dimension table.
3	DIVISION	VARCHAR2(3 BYTE)		The division represented by this rate.
4	RESERVE_RATE	NUMBER(5,2)		The rate of reserve.

**Indexes on TD_RESERVE_RATE_FACT**
Uniqueness	Index Name	Columns
UNIQUE	XPKTD_RESERVE_RATE_FACT	RESERVE_KEY
NON-UNIQUE	XIF1TD_RESERVE_RATE_FACT	DATE_KEY
UNIQUE	TD_RESERVE_RATE_FACT_U01	DATE_KEY, DIVISION, RESERVE_RATE

Triggers on TD_RESERVE_RATE_FACT

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_RESERVE_RATE_FACT_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_RESERVE_RATE_FACT_PK_SEQ.NEXTVAL INTO :NEW.RESERVE_KEY FROM dual;

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

**Foreign Key Constraints on TD_RESERVE_RATE_FACT**
Name	Columns	Ref Table Owner	Ref Table Name	Ref Columns	Delete Rule	Status	Deferrable	Deferred
SYS_C00511957	DATE_KEY	DWST	TD_TIME_DIMENSION	DATE_KEY	NO ACTION	ENABLED	No	No

**PK, UK, & Check Constraints on TD_RESERVE_RATE_FACT**
Name	Type	Condition	Status	Columns
SYS_C00511915	Primary Key		ENABLED	RESERVE_KEY
TD_RESERVE_RATE_FACT_U01	Unique		ENABLED	DATE_KEY, DIVISION, RESERVE_RATE

**Granted Privileges on TD_RESERVE_RATE_FACT**
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
	DWST_SUPPORT		SELECT

**Objects referenced by table TD_RESERVE_RATE_FACT**
Object Owner	Object Name	Object Type
DWST	TD_TIME_DIMENSION	Table

**Objects which reference table TD_RESERVE_RATE_FACT**
Object Owner	Object Name	Object Type
DWST	TD_RESERVE_RATE_FACT_PK_TRIG	Trigger