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

Tables

This data primarily comes from the TUDADMIN schema and, barring changes to schools, is unlikely to change often. The Chart of Account data will be entered by a member of the client group. There will be records for each teaching school (13) as well as distinct values for those schools with authorized section divisions (CGS,SS). Each school/center may designate one 22-character account sequence, excluding the object code.
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	SCHOOL_CENTER_KEY	INTEGER	Y		The primary key of the table.
2	BUDGET_CHECK	VARCHAR2(1 BYTE)			The BC code for the school.
3	FUND	VARCHAR2(6 BYTE)			The fund for the school.
4	PROGRAM_CODE	VARCHAR2(4 BYTE)			The program code for the school.
5	BEGIN_EFF_DATE	DATE	Y	SYSDATE	Begin Eff Date is populated when a new row is added.
6	END_EFF_DATE	DATE			End Eff Date is populated only when a newer version of this dimension record is added. The default is null.
7	CURRENT_RECORD	VARCHAR2(1 BYTE)	Y	'T'	Current Record is a T(rue)/ F(alse) Flag, indicating which of the dimension records are current. This is used for all lookups when loading the fact table.
8	CENTER_NET_ASSET_CLASS	VARCHAR2(3 BYTE)			The cnac for the school.
9	ORGANIZATION	VARCHAR2(4 BYTE)			The org code for the school.
10	CENTER_REFERENCE_CODE	VARCHAR2(4 BYTE)			The cref code for the school.
11	SCHOOL_KEY	NUMBER			The key representing the school.

**Indexes on TD_SCHOOL_CENTER**
Uniqueness	Index Name	Columns
UNIQUE	SYS_C00511919	SCHOOL_CENTER_KEY
NON-UNIQUE	TD_SCHOOL_CENTER_CURR_IDX	CURRENT_RECORD

Triggers on TD_SCHOOL_CENTER

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_SCHOOL_CENTER_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_SCHOOL_CENTER_PK_SEQ.NEXTVAL INTO :NEW.SCHOOL_CENTER_KEY FROM dual;

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

**PK, UK, & Check Constraints on TD_SCHOOL_CENTER**
Name	Type	Condition	Status	Columns
SYS_C00511919	Primary Key		ENABLED	SCHOOL_CENTER_KEY

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

**Objects which reference table TD_SCHOOL_CENTER**
Object Owner	Object Name	Object Type
DWST	TD_SCHOOL_CENTER_PK_TRIG	Trigger