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

The grain of this table is one record per student per term per section_id. The primary key is made up of those three attributes. All primary and foreign keys in this table will be obtained through the related dimension and views. The only metrics in the table are weighted course unit and headcount (default = 1).
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	STUDENT_KEY₁	INTEGER	Y		The surrogate key to the TD_STUDENT table
2	SECTION_KEY₂	INTEGER	Y		The surrogate key to the TD_COURSE_SECTION table
3	DATE_KEY₃	INTEGER	Y		The surrogate key to the TD_TIME_DIMENSION table
4	WEIGHTED_COURSE_UNIT	NUMBER(7,4)			The Weighted Course Unit is the actual Term Registered Credit which has been modified by the value of the dissertation terms and/or the credit type. Semester Hours are divided by 3, Credit Hours are divided by 6 and various schools weighted their dissertation credits.
5	HEADCOUNT	NUMBER(5,4)		1	Headcount will always be 1 in this table.
6	HOME_SCHOOL_KEY	INTEGER	Y		The surrogate key to the TD_JOINT_DEGREE table. Home School Key holds only records which are joint degrees, filtering out those joint degree records which are not joint degrees
7	JOINT_DEGREE_KEY	INTEGER	Y		The surrogate to the TD_JOINT_DEGREE table. This decodes all joint degrees whether they are true joints or not.
8	INSTRUCTIONAL_PROGRAM_KEY	INTEGER	Y		The surrogate key to the TD_INSTRUCTIONAL_PROGRAM table, representing the primary academic program of the student
9	DUAL_DEGREE_KEY	INTEGER	Y		Dual Degree Key is a foreign key to the td_dual_degree and indicates the dual degree status for this record.
10	TEACHING_SCHOOL_KEY	INTEGER	Y		The surrogate key to the TD_TEACHING_GROUP table.
11	SESSION_KEY	INTEGER	Y		Session Key is a foreign key to the td_term_session table, which contains data indicating whether this row represents a first session, second session, special offering, summer 12 week session, or is a full semester.
12	TITLE_KEY	INTEGER	Y		Title Key is a foreign key to the td_section_title table, where the title of the course represented in this row is stored.
13	SECONDARY_PROGRAM_KEY	INTEGER	Y		The surrogate key to the TD_INSTRUCTIONAL_PROGRAM table, representing the secondary academic program of the student
14	CONCENTRATION_KEY	INTEGER	Y		The surrogate key to the TD_CONCENTRATION table. This is stored only for the primary instructional program.

**Indexes on TD_STUDENT_REGISTRATION_FACT**
Uniqueness	Index Name	Columns
NON-UNIQUE	TD_STUDENT_REGIS_CONCEN_IDX	CONCENTRATION_KEY
NON-UNIQUE	XIF4TD_STUDENT_REGISTRATION_FA	STUDENT_KEY
NON-UNIQUE	XIF1TD_STUDENT_REGISTRATION_FA	DATE_KEY
NON-UNIQUE	XIF14TD_STUDENT_REGISTRATION_F	SECONDARY_PROGRAM_KEY
NON-UNIQUE	XIF13TD_STUDENT_REGISTRATION_F	TITLE_KEY
NON-UNIQUE	XIF12TD_STUDENT_REGISTRATION_F	SESSION_KEY
NON-UNIQUE	XIF11TD_STUDENT_REGISTRATION_F	TEACHING_SCHOOL_KEY
NON-UNIQUE	XIF10TD_STUDENT_REGISTRATION_F	DUAL_DEGREE_KEY
NON-UNIQUE	XIF7TD_STUDENT_REGISTRATION_FA	JOINT_DEGREE_KEY
NON-UNIQUE	XIF5TD_STUDENT_REGISTRATION_FA	SECTION_KEY
NON-UNIQUE	XIF2TD_STUDENT_REGISTRATION_FA	HOME_SCHOOL_KEY
NON-UNIQUE	XIF8TD_STUDENT_REGISTRATION_FA	INSTRUCTIONAL_PROGRAM_KEY
UNIQUE	SYS_C00511922	STUDENT_KEY, SECTION_KEY, DATE_KEY

--------- No Triggers on TD_STUDENT_REGISTRATION_FACT ---------

**Foreign Key Constraints on TD_STUDENT_REGISTRATION_FACT**
Name	Columns	Ref Table Owner	Ref Table Name	Ref Columns	Delete Rule	Status	Deferrable	Deferred
SYS_C00511958	SECONDARY_PROGRAM_KEY	DWST	TD_INSTRUCTIONAL_PROGRAM	INSTRUCTIONAL_PROGRAM_KEY	NO ACTION	ENABLED	No	No
SYS_C00511959	TITLE_KEY	DWST	TD_SECTION_TITLE	TITLE_KEY	NO ACTION	ENABLED	No	No
SYS_C00511960	SESSION_KEY	DWST	TD_TERM_SESSION	SESSION_KEY	NO ACTION	ENABLED	No	No
SYS_C00511961	TEACHING_SCHOOL_KEY	DWST	TD_TEACHING_GROUP	TEACHING_GROUP_KEY	NO ACTION	ENABLED	No	No
SYS_C00511962	DUAL_DEGREE_KEY	DWST	TD_DUAL_DEGREE	DUAL_DEGREE_KEY	NO ACTION	ENABLED	No	No
SYS_C00511963	JOINT_DEGREE_KEY	DWST	TD_JOINT_DEGREE	JOINT_DEGREE_KEY	NO ACTION	ENABLED	No	No
SYS_C00511964	SECTION_KEY	DWST	TD_COURSE_SECTION	SECTION_KEY	NO ACTION	ENABLED	No	No
SYS_C00511965	STUDENT_KEY	DWST	TD_STUDENT	STUDENT_KEY	NO ACTION	ENABLED	No	No
SYS_C00511966	DATE_KEY	DWST	TD_TIME_DIMENSION	DATE_KEY	NO ACTION	ENABLED	No	No
SYS_C00511967	INSTRUCTIONAL_PROGRAM_KEY	DWST	TD_INSTRUCTIONAL_PROGRAM	INSTRUCTIONAL_PROGRAM_KEY	NO ACTION	ENABLED	No	No
TD_STUDENT_REGISTRATION_FA_R12	CONCENTRATION_KEY	DWST	TD_CONCENTRATION	CONCENTRATION_KEY	NO ACTION	ENABLED	No	No
TD_STUD_REGIST_FACT_HOME_JD_C	HOME_SCHOOL_KEY	DWST	TD_JOINT_DEGREE	JOINT_DEGREE_KEY	NO ACTION	ENABLED	No	No

**PK, UK, & Check Constraints on TD_STUDENT_REGISTRATION_FACT**
Name	Type	Condition	Status	Columns
SYS_C00511922	Primary Key		ENABLED	STUDENT_KEY, SECTION_KEY, DATE_KEY

**Granted Privileges on TD_STUDENT_REGISTRATION_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_STUDENT_REGISTRATION_FACT**
Object Owner	Object Name	Object Type
DWST	TD_INSTRUCTIONAL_PROGRAM	Table
DWST	TD_SECTION_TITLE	Table
DWST	TD_TERM_SESSION	Table
DWST	TD_TEACHING_GROUP	Table
DWST	TD_DUAL_DEGREE	Table
DWST	TD_JOINT_DEGREE	Table
DWST	TD_COURSE_SECTION	Table
DWST	TD_STUDENT	Table
DWST	TD_TIME_DIMENSION	Table
DWST	TD_CONCENTRATION	Table

--------- No objects reference TD_STUDENT_REGISTRATION_FACT ---------