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

Tables

This table stores the school deferred income, as identified in BRS_DETAIL with brs_user = 'T' and the extract term. Deferred income is the amount of money that has been "paid" by a student and transferred through existing accounting feeds from BRS to GL. The deferred income, grouped by COA, provides the detail needed to process the clearing journal at the beginning of the journal generation process. The total paid_amount for a single date_key should equal the total applied_tuition in the td_instr_program_tuition_fact for the same date_key.
Col #	Column Name	Data Type	Not Null?	Comments
1	INCOME_KEY	INTEGER	Y	Income Key is the Primary Key of the DWST.TD_DEFERRED_INCOME_FACT table
2	DATE_KEY	INTEGER	Y	Date Key is the foreign key to the DWST.TD_TIME_DIMENSION table and records the distinct snapshot for this row.
3	CNAC	VARCHAR2(3 BYTE)	Y	CNAC is a 3 character field, loaded from DWST.BRS_DETAIL.ACCOUNT_2_CNAC, for the deferred income of the tuition transcations.
4	ORG	VARCHAR2(4 BYTE)	Y	ORG is a 4 character field, loaded from DWST.BRS_DETAIL.ACCOUNT_2_ORG, for the deferred income of the tuition transcations.
5	BC	VARCHAR2(1 BYTE)	Y	BC is a 2 character field, loaded from DWST.BRS_DETAIL.ACCOUNT_2_BC, for the deferred income of the tuition transcations.
6	FUND	VARCHAR2(6 BYTE)	Y	FUND is a 6 character field, loaded from DWST.BRS_DETAIL.ACCOUNT_2_FUND, for the deferred income of the tuition transcations.
7	OBJECT	VARCHAR2(4 BYTE)	Y	OBJECT is a 4 character field, loaded from DWST.BRS_DETAIL.ACCOUNT_2_OBJECT, for the deferred income of the tuition transcations.
8	PROGRAM	VARCHAR2(4 BYTE)	Y	PROGRAM is a 4 character field, loaded from DWST.BRS_DETAIL.ACCOUNT_2_PROGRAM, for the deferred income of the tuition transcations.
9	CREF	VARCHAR2(4 BYTE)	Y	CREF is a 4 character field, loaded from DWST.BRS_DETAIL.ACCOUNT_2_CREF, for the deferred income of the tuition transcations.
10	APPLIED_AMOUNT	NUMBER(14,2)	Y	Applied Amount is the aggregated Paid Applied Amount (Payments Received) from DWST.BRS_DETAIL.PAID_APP_AMOUNT where brs_user = 'T' and term = '' for this snapshot. This represents the amount distributed to the schools/centers.

**Indexes on TD_DEFERRED_INCOME_FACT**
Uniqueness	Index Name	Columns
NON-UNIQUE	XIF1TD_DEFERRED_INCOME_FACT	DATE_KEY
UNIQUE	XPKTD_DEFERRED_INCOME_FACT	INCOME_KEY
UNIQUE	SYS_C00511901	DATE_KEY, CNAC, ORG, BC, FUND, OBJECT, PROGRAM, CREF

Triggers on TD_DEFERRED_INCOME_FACT

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_DEFERRED_INCME_FACT_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_DEFERRED_INCOME_FACT_PK_SEQ.NEXTVAL INTO :NEW.INCOME_KEY FROM dual;

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

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

**PK, UK, & Check Constraints on TD_DEFERRED_INCOME_FACT**
Name	Type	Condition	Status	Columns
SYS_C00511901	Unique		ENABLED	DATE_KEY, CNAC, ORG, BC, FUND, OBJECT, PROGRAM, CREF

**Granted Privileges on TD_DEFERRED_INCOME_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
	YALINGX		SELECT
	DWST_SUPPORT		SELECT
	TUITION_DIST_RL		SELECT

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

**Objects which reference table TD_DEFERRED_INCOME_FACT**
Object Owner	Object Name	Object Type
DWST	TD_DEFERRED_INCME_FACT_PK_TRIG	Trigger