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

These values are loaded during the DWADMIN.TD_DIMENSION_LOAD insertcoursesectiongrouprow process. There will be one record per Section ID per term, with an assigned "Teaching Group Key". When descriptions or other attributes in this table change, a new record is inserted and the Current Record indicator of the previous record is changed to F(alse)
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	SECTION_ID	VARCHAR2(10 BYTE)	Y		Section ID is a 10 character field, consisting of the Subject Area, Course Number, and Section Number concatenated together.
2	TERM	VARCHAR2(5 BYTE)	Y		Term is a 5 character field, consisting of year and term code from SRS
3	TEACHING_GROUP_KEY	NUMBER	Y		Teaching Group Key is a foreign key from the DWST.TD_TEACHING_GROUP table, signifying the type of split for Multiple Teaching Schools
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)		'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_COURSE_SECTION_GROUP**
Uniqueness	Index Name	Columns
UNIQUE	TD_COURSE_SECTION_GROUP_U01	SECTION_ID, TERM, TEACHING_GROUP_KEY, BEGIN_EFF_DATE

--------- No Triggers on TD_COURSE_SECTION_GROUP ---------

**Foreign Key Constraints on TD_COURSE_SECTION_GROUP**
Name	Columns	Ref Table Owner	Ref Table Name	Ref Columns	Delete Rule	Status	Deferrable	Deferred
TD_COURSE_SECTION_GROUP_R01	TEACHING_GROUP_KEY	DWST	TD_TEACHING_GROUP	TEACHING_GROUP_KEY	NO ACTION	ENABLED	No	No

**PK, UK, & Check Constraints on TD_COURSE_SECTION_GROUP**
Name	Type	Condition	Status	Columns
TD_COURSE_SECTION_GROUP_U01	Unique		ENABLED	SECTION_ID, TERM, TEACHING_GROUP_KEY, BEGIN_EFF_DATE

**Granted Privileges on TD_COURSE_SECTION_GROUP**
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_COURSE_SECTION_GROUP**
Object Owner	Object Name	Object Type
DWST	TD_TEACHING_GROUP	Table

--------- No objects reference TD_COURSE_SECTION_GROUP ---------