| Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
| 1 | STUDENT_KEY1 | INTEGER | Y | The surrogate key to the TD_STUDENT table | |
| 2 | SECTION_KEY2 | INTEGER | Y | The surrogate key to the TD_COURSE_SECTION table | |
| 3 | DATE_KEY3 | INTEGER | Y | The surrogate key to the TD_TIME_DIMENSION table | |
| 4 | TEACHING_SCHOOL_KEY4 | INTEGER | Y | The surrogate key to the TD_SCHOOL table representing the teaching school of the course section | |
| 5 | HOME_SCHOOL_KEY5 | INTEGER | Y | The surrogate key of the TD_SCHOOL table, representing the home school portion of the student | |
| 6 | JOINT_DEGREE_KEY | INTEGER | Y | The surrogate key to the TD_JOINT_DEGREE table | |
| 7 | INSTRUCTOR_KEY6 | INTEGER | Y | The surrogate key to the TD_INSTRUCTOR table | |
| 8 | PRIMARY_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 | WEIGHTED_COURSE_UNIT | NUMBER(7,4) | The Weighted Course Unit after the teaching school splits, home school splits, and instructor load splits have been applied. | ||
| 11 | HEADCOUNT | NUMBER(5,4) | The HeadCount after the teaching school splits, home school splits, and instructor load splits have been applied | ||
| 12 | APPLIED_TEACHING_RATE | NUMBER(8,2) | The Applied Teaching Amount after the teaching school splits, home school splits, and instructor load splits have been applied to the Export Rate times Weighted Course Unit | ||
| 13 | APPLIED_HOME_RATE | NUMBER(8,2) | The Applied Home Amount after the teaching school splits, home school splits, and instructor load splits have been applied to the Export Rate times the Weighted Course Unit | ||
| 14 | APPLIED_TAX_RATE | NUMBER(8,2) | The Applied Tax Amount after the teaching school splits, home school splits, and instructor load splits have been applied to the Export Rate times the Weighted Course Unit | ||
| 15 | BILLED_TEACHING_RATE | NUMBER(8,2) | The Billed Teaching Amount after the teaching school splits, home school splits, and instructor load splits were applied to the Export Rate times the Weighted Course Unit | ||
| 16 | BILLED_HOME_RATE | NUMBER(8,2) | The Billed Home Amount after the teaching school splits, home school splits, and instructor load splits were applied to the Export Rate times the Weighted Course Unit | ||
| 17 | BILLED_TAX_RATE | NUMBER(8,2) | The Billed Tax Amount after the teaching school splits, home school splits, and instructor load splits were applied to the Export Rate times the Weighted Course Unit | ||
| 18 | NON_TAXABLE_KEY | INTEGER | Y | Non Taxable Key is a foreign key to the td_non_taxable table and indicates whether University Tax should be applied to this row. | |
| 19 | 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. | |
| 20 | 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. | |
| 21 | SECONDARY_PROGRAM_KEY | INTEGER | Y | The surrogate key to the TD_INSTRUCTIONAL_PROGRAM table, representing the secondary academic program of the student | |
| 22 | PRIMARY_APPOINTMENT_KEY | INTEGER | Y | The surrogate key to the TD_INSTRUCTOR_APPOINTMENT table, representing the primary appointment for the instructor | |
| 23 | PRIMARY_ACAD_APPOINTMENT_KEY | INTEGER | Y | The surrogate key to the TD_INSTRUCTOR_APPOINTMENT table, representing the primary academic appointment for the instructor | |
| 24 | CONCENTRATION_KEY | INTEGER | Y | The surrogate key to the TD_CONCENTRATION table. This is stored only for the primary instructional program. |
| Uniqueness | Index Name | Columns |
|---|---|---|
| NON-UNIQUE | XIF4TD_DISTRIBUTION_FACT | TEACHING_SCHOOL_KEY |
| NON-UNIQUE | XIF5TD_DISTRIBUTION_FACT | HOME_SCHOOL_KEY |
| NON-UNIQUE | XIF9TD_DISTRIB_FACT | SECONDARY_PROGRAM_KEY |
| NON-UNIQUE | XIF12TD_DISTRIB_FACT | PRIMARY_ACAD_APPOINTMENT_KEY |
| NON-UNIQUE | XIF13TD_DISTRIB_FACT | PRIMARY_APPOINTMENT_KEY |
| UNIQUE | SYS_C00511902 | STUDENT_KEY, SECTION_KEY, DATE_KEY, TEACHING_SCHOOL_KEY, HOME_SCHOOL_KEY, INSTRUCTOR_KEY |
| NON-UNIQUE | TC_CONCENTRATION_IDX | CONCENTRATION_KEY |
| NON-UNIQUE | XIF14TD_DISTRIBUTION_FACT | SESSION_KEY |
| NON-UNIQUE | XIF2TD_DISTRIBUTION_FACT | SECTION_KEY |
| NON-UNIQUE | XIF15TD_DISTRIBUTION_FACT | TITLE_KEY |
| NON-UNIQUE | XIF11TD_DISTRIBUTION_FACT | NON_TAXABLE_KEY |
| NON-UNIQUE | XIF10TD_DISTRIBUTION_FACT | DUAL_DEGREE_KEY |
| NON-UNIQUE | XIF7TD_DISTRIBUTION_FACT | INSTRUCTOR_KEY |
| NON-UNIQUE | XIF6TD_DISTRIBUTION_FACT | JOINT_DEGREE_KEY |
| NON-UNIQUE | XIF3TD_DISTRIBUTION_FACT | DATE_KEY |
| NON-UNIQUE | XIF1TD_DISTRIBUTION_FACT | STUDENT_KEY |
| NON-UNIQUE | XIF8TD_DISTRIBUTION_FACT | PRIMARY_PROGRAM_KEY |
--------- No Triggers on TD_DISTRIBUTION_FACT ---------
| Name | Columns | Ref Table Owner | Ref Table Name | Ref Columns | Delete Rule | Status | Deferrable | Deferred |
|---|---|---|---|---|---|---|---|---|
| SYS_C00511930 | TITLE_KEY | DWST | TD_SECTION_TITLE | TITLE_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511931 | SESSION_KEY | DWST | TD_TERM_SESSION | SESSION_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511932 | NON_TAXABLE_KEY | DWST | TD_NON_TAXABLE | NON_TAXABLE_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511933 | DUAL_DEGREE_KEY | DWST | TD_DUAL_DEGREE | DUAL_DEGREE_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511934 | INSTRUCTOR_KEY | DWST | TD_INSTRUCTOR | INSTRUCTOR_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511935 | JOINT_DEGREE_KEY | DWST | TD_JOINT_DEGREE | JOINT_DEGREE_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511936 | SECTION_KEY | DWST | TD_COURSE_SECTION | SECTION_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511937 | STUDENT_KEY | DWST | TD_STUDENT | STUDENT_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511938 | DATE_KEY | DWST | TD_TIME_DIMENSION | DATE_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511939 | PRIMARY_ACAD_APPOINTMENT_KEY | DWST | TD_INSTRUCTOR_APPOINTMENT | INSTRUCTOR_APPT_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511940 | PRIMARY_APPOINTMENT_KEY | DWST | TD_INSTRUCTOR_APPOINTMENT | INSTRUCTOR_APPT_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511941 | SECONDARY_PROGRAM_KEY | DWST | TD_INSTRUCTIONAL_PROGRAM | INSTRUCTIONAL_PROGRAM_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00523756 | CONCENTRATION_KEY | DWST | TD_CONCENTRATION | CONCENTRATION_KEY | NO ACTION | ENABLED | No | No |
| Name | Type | Condition | Status | Columns |
|---|---|---|---|---|
| SYS_C00511902 | Primary Key | ENABLED | STUDENT_KEY, SECTION_KEY, DATE_KEY, TEACHING_SCHOOL_KEY, HOME_SCHOOL_KEY, INSTRUCTOR_KEY |
| 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 |
| Object Owner | Object Name | Object Type |
|---|---|---|
| DWST | TD_SECTION_TITLE | Table |
| DWST | TD_TERM_SESSION | Table |
| DWST | TD_NON_TAXABLE | Table |
| DWST | TD_DUAL_DEGREE | Table |
| DWST | TD_INSTRUCTOR | Table |
| DWST | TD_JOINT_DEGREE | Table |
| DWST | TD_COURSE_SECTION | Table |
| DWST | TD_STUDENT | Table |
| DWST | TD_TIME_DIMENSION | Table |
| DWST | TD_INSTRUCTOR_APPOINTMENT | Table |
| DWST | TD_INSTRUCTIONAL_PROGRAM | Table |
| DWST | TD_CONCENTRATION | Table |
--------- No objects reference TD_DISTRIBUTION_FACT ---------