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

*This table contains data relating an instructor to a particular section.*
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	INSTRUCTOR_KEY₁	INTEGER	Y		This is the instructor surrogate key to the td_instructor table.
2	SECTION_KEY₂	INTEGER	Y		This is the course section surrogate key to the td_course_section table
3	DATE_KEY₃	INTEGER	Y		This is the time dimension surrogate key to the td_time_dimension table
4	INSTRUCTOR_LOAD	INTEGER			The instructor_load field comes from the dwadmin.course_section_instructor.instructor_load field. If there is no record in the dwadmin.course_section_instructor table for an existing course_section, then a record for "Dr. Staff" is entered with 100% load.
5	TTL_WEIGHTED_COURSE_UNIT	NUMBER(7,2)			TTL_WEIGHTED_COURSE_UNIT is a calculated value, using the WEIGHTED_COURSE_UNIT values in the TD_STUDENT_REGISTRATION_FACT table for this specific Section_key. The field is further modified by the INSTRUCTOR_LOAD value, adjusting for multiple instructors.
6	TTL_HEADCOUNT	INTEGER			TTL_HEADCOUNT is a calculated value, using the HEADCOUNT values in the TD_STUDENT_REGISTRATION_FACT table for this specific Section_key. The field is further modified by the INSTRUCTOR_LOAD value, adjusting for multiple instructors.
7	TITLE_KEY	INTEGER	Y		This field is the TITLE surrogate key to the TD_SECTION_TITLE table
8	SESSION_KEY	INTEGER	Y		This field is the Term Session surrogate key to the TD_TERM_SESSION table.
9	PRI_APPT_JOB_LINK_ID	NUMBER(9)			This field contains the Primary Appointment Job Link ID from the DWADMIN.EMPLOYEE_GENERAL table for this instructor on the extract date.
10	PRI_ACAD_APPT_JOB_LINK_ID	NUMBER(9)			This field contains the Primary Academic Appointment Job Link ID from the DWADMIN.EMPLOYEE_GENERAL table for this instructor on the extract date.
11	TEACHING_GROUP_KEY	INTEGER	Y		This field contains the Teaching Group surrogate key for the TD_TEACHING_GROUP table.
12	PRIMARY_APPOINTMENT_KEY	INTEGER			This field contains the Primary Appointment surrogate key to the TD_INSTRUCTOR_APPOINTMENT table, based on the value in the DWADMIN.EMPLOYEE_GENERAL for this instructor at the extract date.
13	PRIMARY_ACAD_APPOINTMENT_KEY	INTEGER			This field contains the Primary Academic Appointment surrogate key to the TD_INSTRUCTOR_APPOINTMENT table, based on the value in the DWADMIN.EMPLOYEE_GENERAL for this instructor at the extract date.

**Indexes on TD_INSTRUCTOR_SECTION_FACT**
Uniqueness	Index Name	Columns
NON-UNIQUE	XIF5TD_INSTRUCTOR_SECTION_FACT	DATE_KEY
NON-UNIQUE	XIF10TD_INSTRUCTOR_SECTION_FAC	TEACHING_GROUP_KEY
NON-UNIQUE	XIF7TD_INSTRUCTOR_SECTION_FACT	SESSION_KEY
NON-UNIQUE	XIF6TD_INSTRUCTOR_SECTION_FACT	TITLE_KEY
NON-UNIQUE	XIF2TD_INSTRUCTOR_SECTION_FACT	SECTION_KEY
NON-UNIQUE	XIF1TD_INSTRUCTOR_SECTION_FACT	INSTRUCTOR_KEY
NON-UNIQUE	XIF9TD_INSTRUCTOR_SECT_FACT	PRIMARY_ACAD_APPOINTMENT_KEY
NON-UNIQUE	XIF3TD_INSTRUCTOR_SECT_FACT	PRIMARY_APPOINTMENT_KEY
UNIQUE	SYS_C00511908	INSTRUCTOR_KEY, SECTION_KEY, DATE_KEY

--------- No Triggers on TD_INSTRUCTOR_SECTION_FACT ---------

**Foreign Key Constraints on TD_INSTRUCTOR_SECTION_FACT**
Name	Columns	Ref Table Owner	Ref Table Name	Ref Columns	Delete Rule	Status	Deferrable	Deferred
SYS_C00511942	TEACHING_GROUP_KEY	DWST	TD_TEACHING_GROUP	TEACHING_GROUP_KEY	NO ACTION	ENABLED	No	No
SYS_C00511943	SESSION_KEY	DWST	TD_TERM_SESSION	SESSION_KEY	NO ACTION	ENABLED	No	No
SYS_C00511944	TITLE_KEY	DWST	TD_SECTION_TITLE	TITLE_KEY	NO ACTION	ENABLED	No	No
SYS_C00511945	SECTION_KEY	DWST	TD_COURSE_SECTION	SECTION_KEY	NO ACTION	ENABLED	No	No
SYS_C00511946	INSTRUCTOR_KEY	DWST	TD_INSTRUCTOR	INSTRUCTOR_KEY	NO ACTION	ENABLED	No	No
SYS_C00511947	DATE_KEY	DWST	TD_TIME_DIMENSION	DATE_KEY	NO ACTION	ENABLED	No	No
SYS_C00511948	PRIMARY_APPOINTMENT_KEY	DWST	TD_INSTRUCTOR_APPOINTMENT	INSTRUCTOR_APPT_KEY	NO ACTION	ENABLED	No	No
SYS_C00511949	PRIMARY_ACAD_APPOINTMENT_KEY	DWST	TD_INSTRUCTOR_APPOINTMENT	INSTRUCTOR_APPT_KEY	NO ACTION	ENABLED	No	No

**PK, UK, & Check Constraints on TD_INSTRUCTOR_SECTION_FACT**
Name	Type	Condition	Status	Columns
SYS_C00511908	Primary Key		ENABLED	INSTRUCTOR_KEY, SECTION_KEY, DATE_KEY

**Granted Privileges on TD_INSTRUCTOR_SECTION_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_INSTRUCTOR_SECTION_FACT**
Object Owner	Object Name	Object Type
DWST	TD_TEACHING_GROUP	Table
DWST	TD_TERM_SESSION	Table
DWST	TD_SECTION_TITLE	Table
DWST	TD_COURSE_SECTION	Table
DWST	TD_INSTRUCTOR	Table
DWST	TD_TIME_DIMENSION	Table
DWST	TD_INSTRUCTOR_APPOINTMENT	Table

--------- No objects reference TD_INSTRUCTOR_SECTION_FACT ---------