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

Tables

*This table stores valid Concentrations for a student's primary instructional program.*
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	CONCENTRATION_KEY	INTEGER	Y		The primary key for the Concentration Dimension. Populated by a trigger, using the TD_Concentration_pk_seq. This field is not visible through Business Objects.
2	CONCENTRATION	VARCHAR2(3 BYTE)	Y		Concentration is a three character code, populated from the Data Warehouse, Degree Term table. While this table stores valid Concentrations, it only stores those concentrations for the student's primary instructional program.
3	CONCENTRATION_DESC	VARCHAR2(50 BYTE)	Y		Concentration Description is populated from the Data Warehouse, Concentration Lookup table, at the time of the Concentration load.
4	BEGIN_EFF_DATE	DATE	Y	sysdate	Begin Eff Date is populated when a new row is added.
5	END_EFF_DATE	DATE			End Eff Date is populated only when a newer version of this dimension record is added. The default is null.
6	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.

**Indexes on TD_CONCENTRATION**
Uniqueness	Index Name	Columns
UNIQUE	PK_TD_CONCENTRATION	CONCENTRATION_KEY

Triggers on TD_CONCENTRATION

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_CONCENTRATION_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_CONCENTRATION_PK_SEQ.NEXTVAL INTO :NEW.CONCENTRATION_KEY FROM dual;

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

**PK, UK, & Check Constraints on TD_CONCENTRATION**
Name	Type	Condition	Status	Columns
PK_TD_CONCENTRATION	Primary Key		ENABLED	CONCENTRATION_KEY

**Granted Privileges on TD_CONCENTRATION**
Column	Grantee	Grantable Privilege(s)	Non-Grantable Privilege(s)
	DWADMIN		ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK
	YALINGX		SELECT
	TUITION_DIST_RL		SELECT

--------- TD_CONCENTRATION does not reference any objects ---------

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