| Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
| 1 | TD_EXTRACT_DATE | DATE | The date upon which the snapshot has been / should be taken. | ||
| 2 | TERM_START_DATE | DATE | The start date of the term in which the snapshot occurred. | ||
| 3 | TERM_END_DATE | DATE | The end date of the term in which the snapshot occurred. | ||
| 4 | FINAL_SNAP_FOR_TERM_INDICATOR | CHAR(1 BYTE) | Whether this snapshot is the final in the group for the term. | ||
| 5 | SRS_TERM | CHAR(5 BYTE) | The string name of the term, ie 2006A. | ||
| 6 | GAAP_PERCENTAGE | NUMBER(5,2) | The percentage of the term which has passed when this snapshot is taken. | ||
| 7 | FISCAL_YEAR | VARCHAR2(4 BYTE) | The fiscal year in which the snapshot occurred. | ||
| 8 | FISCAL_MONTH_SEQ | VARCHAR2(2 BYTE) | The fiscal month in which the snapshot occurred. | ||
| 9 | MONTH | VARCHAR2(2 BYTE) | The calendar month in which the snapshot occurred. | ||
| 10 | CALENDAR_YEAR | VARCHAR2(4 BYTE) | The calendar year in which the snapshot occurred. | ||
| 11 | BRS_TERM | VARCHAR2(3 BYTE) | The BRS term in which the snapshot occurred. | ||
| 12 | ACCOUNTING_PERIOD | VARCHAR2(6 BYTE) | The accounting period in which the snapshot occurred. | ||
| 13 | QUARTER_SEQ | VARCHAR2(1 BYTE) | The accounting quarter in which the snapshot occurred. | ||
| 14 | SNAP_PERIOD | INTEGER | The integer which indicates which position this snapshot holds in the list of snapshotd for this term. | ||
| 15 | ENTERED_BY | VARCHAR2(8 BYTE) | Y | The user who entered the row. | |
| 16 | ENTERED_ON | DATE | Y | The date upon which the row was entered. | |
| 17 | LAST_EDITED_BY | VARCHAR2(8 BYTE) | The last user to edit this row. | ||
| 18 | LAST_EDITED_ON | DATE | The date upon which the row was last edited. | ||
| 19 | DIMENSION_COMPLETED | VARCHAR2(1 BYTE) | Y | 'F' | Whether the dimension load has been completed for this snapshot yet. |
| 20 | DIMENSION_COMPLETED_ON | DATE | The date upon which the dimension load was completed. | ||
| 21 | DATE_KEY | INTEGER | Y | The primary key for this table. | |
| 22 | FACT_COMPLETED_ON | DATE | Whether the fact load has been completed for this snapshot yet. | ||
| 23 | FACT_COMPLETED | VARCHAR2(1 BYTE) | Y | 'F' | Whether the fact load has been created for this snapshot. |
| 24 | CREATE_FEEDERS | VARCHAR2(1 BYTE) | 'F' | Whether feeders should be created for this snapshot. | |
| 25 | FEEDERS_CREATED_ON | DATE | Whether the feeders have been created for this snapshot yet. | ||
| 26 | FEEDERS_SENT_ON | DATE | The date upon which the feeders were sent via ftp to the bursar system. | ||
| 27 | BAD_DEBT_PERCENTAGE | NUMBER(5,2) | The percentage for modifying the reserve rate journal. This is independent of the GAAP percentage, as Summer is booked at a different schedule for the two rates. |
| Uniqueness | Index Name | Columns |
|---|---|---|
| UNIQUE | TD_TIME_DIMENSION_U01 | DATE_KEY |
--------- No Triggers on TD_TIME_DIMENSION ---------
| Name | Type | Condition | Status | Columns |
|---|---|---|---|---|
| TD_TIME_DIMENSION_U01 | Unique | ENABLED | 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 |
--------- TD_TIME_DIMENSION does not reference any objects ---------
| Object Owner | Object Name | Object Type |
|---|---|---|
| DWST | TD_DEFERRED_INCOME_FACT | Table (FK) |
| DWST | TD_DISTRIBUTION_FACT | Table (FK) |
| DWST | TD_FEEDER | Table (FK) |
| DWST | TD_INSTRUCTOR_SECTION_FACT | Table (FK) |
| DWST | TD_INSTR_PROGRAM_TUITION_FACT | Table (FK) |
| DWST | TD_RESERVE_RATE_FACT | Table (FK) |
| DWST | TD_STUDENT_REGISTRATION_FACT | Table (FK) |