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

Tables

This table should contain one record per course_section and begin_eff_date. The data is loaded primarily from dwadmin.course_section, with subject_area_desc, section_school_desc, and section_division_desc being populated respectively by dwadmin.subject_area, dwadmin.school, and dwadmin.division.
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	SECTION_KEY	INTEGER	Y		Section Key is the primary key for the TD Course Section table
2	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. The values for Section ID are loaded from the DWADMIN.Course_Section table in the Student Data Warehouse collection. There will be one record per Section ID. The data values that are term specific are stored in other dimensions, allowing this table to hold only unique Sections. 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)
3	SUBJECT_AREA	VARCHAR2(4 BYTE)	Y		Subject Area is a 4 character field, loaded from the DWADMIN.Course_Section table.
4	SUBJECT_AREA_DESC	VARCHAR2(31 BYTE)			Subject Area Desc(ription) is loaded from the DWADMIN.Subject Area Lookup table
5	COURSE_NUMBER	VARCHAR2(3 BYTE)	Y		Course Number is a 3 character field, loaded from DWADMIN.Course_Section.
6	SECTION_NUMBER	VARCHAR2(3 BYTE)	Y		Section Number is a 3 character field, loaded from the DWADMIN.Course_Section table
7	SECTION_SCHOOL	VARCHAR2(2 BYTE)			Section School is a 2 character field, loaded from DWADMIN.Course_Section table. The Section School is the Administrative School offering the section
8	SECTION_SCHOOL_DESC	VARCHAR2(40 BYTE)			Section School Desc(ription) is a 40 character field, loaded from DWADMIN.School table.
9	SECTION_DIVISION	VARCHAR2(3 BYTE)			Section Division is a 3 character field, loaded from the DWADMIN.Course_Section table. The Section Division is the administrative Division within a school offering this course. All Divisions are shown in this table. However, only CGS and SS are valid teaching divisions in Tuition Distribution.
10	SECTION_DIVISION_DESC	VARCHAR2(41 BYTE)			Section Division Desc(ription) is a 41 character field, loaded from DWADMIN.Division table
11	ACTIVITY_TYPE	VARCHAR2(3 BYTE)			Activity Type is a 3 character field, loaded from DWADMIN.Course_Section table. Each section has an activity type, indicating the type of instructional delivery (i.e., Lecture, Seminar)
12	BEGIN_EFF_DATE	DATE	Y	sysdate	Begin Eff Date is populated when a new row is added.
13	END_EFF_DATE	DATE			End Eff Date is populated only when a newer version of this dimension record is added. The default is null.
14	CURRENT_RECORD	CHAR(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.
15	XLIST	VARCHAR2(1 BYTE)			XList is a 1 character field, loaded from the DWADMIN.Course_Section table. It is the Flag which identifies a course which is either P(rimary), S(econdary), or Null (not crosslisted).
16	XLIST_PRIMARY	VARCHAR2(10 BYTE)			XList Primary is a 10 character field, holding the section_id of the primary crosslisting. The Xlist Primary is loaded from the DWADMIN.Course_Section table. The XList Primary will be populated for all sections.
17	SECTION_DEPT	CHAR(4 BYTE)			Section Dept (Department) is a 4 character field, loaded from the DWADMIN.Course_Section table. This field is the parent department for each subject area and is used to group sections on the CER/RCR report.

**Indexes on TD_COURSE_SECTION**
Uniqueness	Index Name	Columns
NON-UNIQUE	TD_COURSE_SECTION_SEC_ID_IDX	SECTION_ID
NON-UNIQUE	TD_COURSE_SECTION_CURR_IDX	CURRENT_RECORD
NON-UNIQUE	TD_COURSE_SECTION_IDX1	SECTION_ID, SECTION_DIVISION, SECTION_SCHOOL, ACTIVITY_TYPE, XLIST
UNIQUE	SYS_C00511899	SECTION_KEY

Triggers on TD_COURSE_SECTION

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_COURSE_SECTION_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_COURSE_SECTION_PK_SEQ.NEXTVAL INTO :NEW.SECTION_KEY FROM dual;

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

**PK, UK, & Check Constraints on TD_COURSE_SECTION**
Name	Type	Condition	Status	Columns
SYS_C00511899	Primary Key		ENABLED	SECTION_KEY

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

--------- TD_COURSE_SECTION does not reference any objects ---------

**Objects which reference table TD_COURSE_SECTION**
Object Owner	Object Name	Object Type
DWST	TD_DISTRIBUTION_FACT	Table (FK)
DWST	TD_INSTRUCTOR_SECTION_FACT	Table (FK)
DWST	TD_STUDENT_REGISTRATION_FACT	Table (FK)
DWST	TD_COURSE_SECTION_PK_TRIG	Trigger