| Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
| 1 | INSTRUCTIONAL_PROGRAM_KEY1 | INTEGER | Y | This is the Instructional Program surrogate key to the TD_INSTRUCTIONAL_PROGRAM table | |
| 2 | DATE_KEY2 | INTEGER | Y | This is the Date surrogate key to the TD_TIME_DIMENSION table | |
| 3 | BILLED_TUITION | NUMBER(11,2) | Billed Tuition is total billed tuition (Amount) in the DWST.BRS_DETAIL table for a specified term, aggregated by the primary instructional program of the students. There should be one row per instructional program per extract. | ||
| 4 | APPLIED_TUITION | NUMBER(11,2) | Billed Tuition is total applied tuition (Paid_App_Amount) in the DWST.BRS_DETAIL table for a specified term, aggregated by the primary instructional program of the students. There should be one row per instructional program per extract. | ||
| 5 | BILLED_EXPORT_RATE | NUMBER(9,4) | Y | 0 | The Billed Export Rate is the result of a set of four distinct calculations performed on the Tuition Distribution Billed Tuition data. For each of the four Instructional Program Types, a calculation divides the billed tuition by the registered credits for a specified population of students. The goal is to derive a tuition dollar amount per a course unit. The Export Rate is used to determine how much value to assign to a student's registration. The Export Rate Calculation is performed in the Fact Load, after TD_STUDENT_REGISTRATION_FACT and TD_INSTR_PROG_TUITION_FACT gross billed and applied tuitions are inserted. |
| 6 | APPLIED_EXPORT_RATE | NUMBER(9,4) | Y | 0 | The Applied Export Rate is the result of a set of four distinct calculations performed on the Tuition Distribution AppliedTuition data. For each of the four Instructional Program Types, a calculation divides the applied tuition by the registered credits for a specified population of students. The goal is to derive a tuition dollar amount per a course unit. The Export Rate is used to determine how much value to assign to a student's registration. The Export Rate Calculation is performed in the Fact Load, after TD_STUDENT_REGISTRATION_FACT and TD_INSTR_PROG_TUITION_FACT gross billed and applied tuitions are inserted. |
| 7 | NON_TAXABLE_KEY | INTEGER | Y | This field contains the NON_TAXABLE surrogate key to the TD_NON_TAXABLE table. The Instructional Programs marked as non-taxable are stored in a user specified table in the Online Collection System. This field is updated at the time of the extract. | |
| 8 | RESERVE_PERCENTAGE_RATE | NUMBER(4,2) | This field contains the division specific Reserve Percentage Rate, as entered by the SRFS Management Office. As these rates could change based on an extract period, the extract specific amount is entered. The number is not stored as a percentage. When this number is applied, it is divided by 100 to create the percentage. |
| Uniqueness | Index Name | Columns |
|---|---|---|
| NON-UNIQUE | XIF2TD_INSTR_PROGRAM_TUITION_F | DATE_KEY |
| NON-UNIQUE | XIF3TD_INSTR_PROGRAM_TUITION_F | NON_TAXABLE_KEY |
| NON-UNIQUE | XIF1TD_INSTR_PROGRAM_TUITION_F | INSTRUCTIONAL_PROGRAM_KEY |
| UNIQUE | SYS_C00511909 | INSTRUCTIONAL_PROGRAM_KEY, DATE_KEY |
--------- No Triggers on TD_INSTR_PROGRAM_TUITION_FACT ---------
| Name | Columns | Ref Table Owner | Ref Table Name | Ref Columns | Delete Rule | Status | Deferrable | Deferred |
|---|---|---|---|---|---|---|---|---|
| SYS_C00511951 | NON_TAXABLE_KEY | DWST | TD_NON_TAXABLE | NON_TAXABLE_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511952 | INSTRUCTIONAL_PROGRAM_KEY | DWST | TD_INSTRUCTIONAL_PROGRAM | INSTRUCTIONAL_PROGRAM_KEY | NO ACTION | ENABLED | No | No |
| SYS_C00511953 | DATE_KEY | DWST | TD_TIME_DIMENSION | DATE_KEY | NO ACTION | ENABLED | No | No |
| Name | Type | Condition | Status | Columns |
|---|---|---|---|---|
| SYS_C00511909 | Primary Key | ENABLED | INSTRUCTIONAL_PROGRAM_KEY, DATE_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_NON_TAXABLE | Table |
| DWST | TD_INSTRUCTIONAL_PROGRAM | Table |
| DWST | TD_TIME_DIMENSION | Table |
--------- No objects reference TD_INSTR_PROGRAM_TUITION_FACT ---------