| Table Name | # of Cols | # of Indexes | Comment |
|---|---|---|---|
| TD_CONCENTRATION | 6 | 1 | This table stores valid Concentrations for majors in the student primary instructional program. |
| TD_COURSE_SECTION | 17 | 4 | This table should contain one record per course_section and begin_eff_date. The data is loaded primarily from DWNGSS_PS.CRSE_SECTION. |
| TD_COURSE_SECTION_GROUP | 6 | 1 | 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) |
| TD_DEFERRED_INCOME_FACT | 10 | 3 | This table stores the school deferred income, as identified in DWNGSS.STUDENT_ACCOUNT_GL with detail_code_category = 'TUI' for the Banner term. Deferred income is the amount of money that has been "paid" by a student and transferred through existing accounting feeds from Pennant Accounts to GL. The deferred income, grouped by COA, provides the detail needed to process the clearing journal at the beginning of the journal generation process. The total paid_amount for a single date_key should equal the total applied_tuition in the td_instr_program_tuition_fact for the same date_key. |
| TD_DISTRIBUTION_FACT | 24 | 17 | This table contains final aggregates of Tuition Distribution snapshots. |
| TD_DUAL_DEGREE | 3 | 1 | This table contains valid dual degrees used throughout the university. |
| TD_FEEDER | 44 | 1 | Feeder holds the data which is used to populate the feeder files which are sent to the bursar system for Tuition Distribution. |
| TD_INSTRUCTIONAL_PROGRAM | 18 | 6 | This table will hold the unique school, with either the division+degree+major or program+major combinations that represent the instructional programs. Where applicable, per Penn business rules, the instructional program also takes into account the student's campus, rate, site, attribute and/or cohort codes. If new combinations arrive, that record should be inserted complete with descriptions for each column. The description for school, division, degree, major, program, campus, site, attribute, and cohort codes can be found in the respective tables starting with v_ in the warehouse documentation page: https://www.isc.upenn.edu/pennant-student-records |
| TD_INSTRUCTOR | 7 | 3 | This table is used to store instructors for the Tuition Distribution program. |
| TD_INSTRUCTOR_APPOINTMENT | 11 | 2 | This table is used to store employment appointments for instructors. |
| TD_INSTRUCTOR_SECTION_FACT | 13 | 9 | This table contains data relating an instructor to a particular section, from DWNGSS_PS.CRSE_SECT_INSTRUCTOR. |
| TD_INSTR_PROGRAM_TUITION_FACT | 8 | 4 | This table contains billed and applied numbers for instructional programs. |
| TD_JOINT_DEGREE | 7 | 2 | This table contains a history of valid coordinated multiple degrees. |
| TD_JOINT_DEGREE_PERCENTAGE | 3 | 3 | Coordinated multiple degree percentages table, containing the specification of percentages which should be split between schools for particular coordinated degrees. A student in Pennant may have curricula in multiple schools, but every student has one primary home school. Occasionally a student may enroll in a program which has pre-arranged splits between schools; in Pennant, these are called coordinated degrees. In these cases, the partner schools agree to share the home school portion of the tuition. The student's record in Pennant is labeled with a cohort and a program code identifying their coordinated degree. The primary home school of that student is responsible for the coordinated degree cohort code. |
| TD_NON_TAXABLE | 2 | 1 | This table is used to contain taxable status. Rows which reference the non taxable row of this table represent courses which do not pay University Tax. Rows which reference the taxable row represent courses which do pay University Tax. |
| TD_PROGRAM_TYPE_LU | 5 | 1 | This table contains values which allow the splitting of tuition for courses depending on date object codes. |
| TD_RESERVE_RATE_FACT | 4 | 3 | Reserve is a financial concept, used to account for the amount of money which offsets unpaid receivables. In double entry accounting, reserve offsets bad debt. Student Financial Services is responsible for making the reserve and bad debt journal entries, based on their billing rates. They track the collection rates for each academic division at Penn. |
| TD_SCHOOL | 9 | 1 | This is the main listing for all possible home school and teaching school records. Thus, this is different from the DWNGSS.V_SCHOOL validation table. Every record in the TD_DISTRIBUTION_FACT will have at least one home school and one teaching school, relating back to this table. |
| TD_SCHOOL_CENTER | 11 | 2 | This data primarily comes from the TUDADMIN schema and, barring changes to schools, is unlikely to change often. The Chart of Account data will be entered by a member of the client group. There will be records for each teaching school (13) as well as distinct values for those schools with authorized section divisions (examples: 'AL','AS'). Each school/center may designate one 22-character account sequence, excluding the object code. |
| TD_SECTION_TITLE | 2 | 3 | Section Title contains the descriptive name of a particular course. |
| TD_SHARED_SECTION_PERCENTAGE | 12 | 1 | This table contains the percentage of income that goes to a particular school for a course, when multiple schools share the "home school" pool. As-of Summer 2022 and going forward, the percentages are maintained in a FAST app, as entered by an authorized person in the central Student Financial Services office. Schools work with the central office to determine the percentages that will be used. Only courses where the tuition income is being shared appear in this table. There is one row per section per term per school sharing a percentage of the income. See also TD_TEACHING_GROUP. |
| TD_STUDENT | 7 | 6 | This table is loaded from DWNGSS_PS.STUDENT where the student has registered for at least one course section during a term. There should a unique record for this student in this table. Uniqueness will be determined by student_penn_id and begin_eff_date. If a new value for student name or student_penn_id is extracted from Pennant, then the current record should be updated by posting the sysdate in the end_eff_date, the current flag set to 'H' and a new record inserted. |
| TD_STUDENT_REGISTRATION_FACT | 14 | 13 | 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). |
| TD_TEACHING_GROUP | 2 | 1 | Teaching Group holds groups of schools which collaborate on particular courses and thus split the income from the course. Multiple rows from the TD_SHARED_SECTION_PERCENTAGE table with the same teaching group key roll up to one row in TD_TEACHING_GROUP. |
| TD_TEACHING_SCHOOL_PERCENTAGE | 3 | 3 | This table contained the percentage of income that went to a particular school for a course, based on the data in the legacy SRS system. As-of Summer 2022, this table is no longer used. See TD_SHARED_SECTION_PERCENTAGE. |
| TD_TERM_SESSION | 3 | 1 | This table contains data indicating the part of term in which a course occurs. Part-of-term is used to identify summer sessions 1 and 2, as well as other subsets within a term. The full term is one type of a part-of-term, encompassing all of the weeks of that term. Other parts-of-term can be as short as one week, and can start or end on dates outside of the full term, but all parts-of-term must be associated with a term code. |
| TD_TIME_DIMENSION | 27 | 1 | Time dimension stores the dates in which snapshots of student and financial state should be taken. |