|
|
Name |
|
|
Comment |
Dimensions and fact tables relating to IT helpdesk/issue tracking, and also to asset tracking. |
|
Name |
Creation Date |
Dimensional Type |
Class Name |
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Shortcut of table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Shortcut of table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Shortcut of table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Shortcut of table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Shortcut of table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Table |
|
|
Wednesday, November 03, 2010 4:46:13 PM |
Dimension |
Table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Shortcut of table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Dimension |
Shortcut of table |
|
|
Monday, November 15, 2010 1:51:15 PM |
Fact |
Table |
|
|
Monday, November 01, 2010 10:30:44 AM |
Fact |
Table |
|
Name |
Parent Table |
Child Table |
Foreign Key Columns |
|
AssetValueToDate_Disposal |
MD_Date_DisposalDate |
||
|
AssetValueToDate_Purchase |
MD_Date_PurchaseDate |
||
|
AssetValueToDegreeStudent |
MD_CollPers_SurrogateKeyDStu |
||
|
AssetValueToEmployee |
MD_CollPers_SurrogateKeyEmp |
||
|
Relationship_115 |
MD_ITAsset_SurrogateKey |
||
|
Relationship_116 |
MD_CarlDept_SurrogateKey |
||
|
Relationship_117 |
MD_ITStatus_SurrogateKey |
||
|
Relationship_118 |
MD_ITTechGroup_SurrogateKey |
||
|
Relationship_119 |
MD_ITPriority_SurrogateKey |
||
|
Relationship_120 |
MD_Building_SurrogateKey |
||
|
Relationship_121 |
MD_Room_SurrogateKey |
||
|
Relationship_122 |
MD_CollPers_SurrogateKeyDStu |
||
|
Relationship_123 |
MD_CollPers_SurrogateKeyEmp |
||
|
Relationship_124 |
MD_ITProblemType_SurrogateKey |
||
|
Relationship_125 |
MD_Building_SurrogateKey |
||
|
Relationship_127 |
MD_ITAsset_SurrogateKey |
||
|
Relationship_128 |
MD_ITUser_SurrogateKey |
||
|
Relationship_129 |
MD_Room_SurrogateKey |
||
|
Relationship_130 |
MD_CarlDept_SurrogateKey |
||
|
Relationship_ClientToTicket |
MD_ITUser_SurrogateKeyClient |
||
|
Relationship_CloseDate |
MF_ITTicket_CloseDate |
||
|
Relationship_CloseTime |
MF_ITTicket_CloseTime |
||
|
Relationship_FirstResponseDate |
MF_ITTicket_FirstResponseDate |
||
|
Relationship_FirstResponseTime |
MF_ITTicket_FirstResponseTime |
||
|
Relationship_LoggedByToTicket |
MD_ITUser_SurrogateKeyLoggedBy |
||
|
Relationship_ReportDate |
MF_ITTicket_ReportDate |
||
|
Relationship_ReportTime |
MF_ITTicket_ReportTime |
||
|
Relationship_TechToTicket |
MD_ITTech_SurrogateKey |
||
|
Relationship_WorkEndDate |
MF_ITTicket_WorkEndDate |
||
|
Relationship_WorkEndTime |
MF_ITTicket_WorkEndTime |
||
|
Relationship_WorkStartDate |
MF_ITTicket_WorkStartDate |
||
|
Relationship_WorkStartTime |
MF_ITTicket_WorkStartTime |
|
|
|