Package StarsLabUsage

Diagram LabUsageDiagram

List of outgoing references of the table MF_KeyedComputerEvent List of incoming references of the table MD_KeyedComputerEvent List of References in Diagram List of incoming references of the table MD_KeyedComputer List of incoming references of the table MD_ProgramOrApp Table MD_KeyedComputerEvent Table MD_CarletonDepartment Table MF_KeyedComputerInUse Table MD_IssueTrackingUser Table MD_ProgramOrApp Table MF_KeyedComputerSoftwareUsage Table MD_Time Table MF_KeyedComputerEvent Table MD_KeyedComputer Table MD_IssueTrackingAsset Table MD_Building Table MD_Room Table MD_Date Table MD_Employee
LabUsageDiagram

Card of Diagram LabUsageDiagram

Name

LabUsageDiagram

Comment

Dimensions and fact tables relating to lab and general shared-computer usage. Incorporates a considerable amount of data from tables also present in StarsIssueTracking.


List of Tables in Diagram

Name

Creation Date

Dimensional Type

Class Name

MD_Building

Wednesday, May 23, 2012 2:22:27 PM

Dimension

Shortcut of table

MD_CarletonDepartment

Wednesday, May 23, 2012 2:22:27 PM

Dimension

Shortcut of table

MD_Date

Wednesday, May 23, 2012 2:22:27 PM

Dimension

Shortcut of table

MD_Employee

Wednesday, May 23, 2012 2:22:27 PM

Dimension

Shortcut of table

MD_IssueTrackingAsset

Wednesday, May 23, 2012 2:22:27 PM

Dimension

Shortcut of table

MD_IssueTrackingUser

Wednesday, May 23, 2012 2:22:27 PM

Dimension

Shortcut of table

MD_KeyedComputer

Wednesday, May 23, 2012 2:22:27 PM

<None>

Table

MD_KeyedComputerEvent

Saturday, May 26, 2012 3:49:47 PM

<None>

Table

MD_ProgramOrApp

Wednesday, May 23, 2012 2:22:27 PM

<None>

Table

MD_Room

Wednesday, May 23, 2012 2:22:27 PM

Dimension

Shortcut of table

MD_Time

Wednesday, May 23, 2012 2:22:27 PM

Dimension

Shortcut of table

MF_KeyedComputerEvent

Friday, May 25, 2012 3:48:40 PM

<None>

Table

MF_KeyedComputerInUse

Wednesday, May 23, 2012 2:22:27 PM

<None>

Table

MF_KeyedComputerSoftwareUsage

Wednesday, May 23, 2012 2:22:27 PM

<None>

Table


List of References in Diagram

Name

Parent Table

Child Table

Foreign Key Columns

Relationship_238

MD_Time (Shortcut)

MF_KeyedComputerInUse

MD_Time_TimeInteger

Relationship_243

MD_Date (Shortcut)

MF_KeyedComputerInUse

MD_Date_DateInteger

Relationship_244

MD_IssueTrackingAsset (Shortcut)

MF_KeyedComputerInUse

MD_ITAsset_SurrogateKey

Relationship_245

MD_KeyedComputer

MF_KeyedComputerInUse

MD_KeyedComp_SurrogateKey

Relationship_246

MD_ProgramOrApp

MF_KeyedComputerSoftwareUsage

MD_Program_SurrogateKey

Relationship_247

MD_Time (Shortcut)

MF_KeyedComputerSoftwareUsage

MD_Time_TimeInteger

Relationship_248

MD_Date (Shortcut)

MF_KeyedComputerSoftwareUsage

MD_Date_DateInteger

Relationship_249

MD_KeyedComputer

MF_KeyedComputerSoftwareUsage

MD_KeyedComp_SurrogateKey

Relationship_250

MD_IssueTrackingAsset (Shortcut)

MF_KeyedComputerSoftwareUsage

MD_ITAsset_SurrogateKey

Relationship_251

MD_IssueTrackingUser (Shortcut)

MF_KeyedComputerInUse

MD_ITUser_SurrogateKey

Relationship_252

MD_IssueTrackingUser (Shortcut)

MF_KeyedComputerSoftwareUsage

MD_ITUser_SurrogateKey

Relationship_253

MD_CarletonDepartment (Shortcut)

MF_KeyedComputerInUse

MD_CarlDept_SurrogateKey

Relationship_254

MD_CarletonDepartment (Shortcut)

MF_KeyedComputerSoftwareUsage

MD_CarlDept_SurrogateKey

Relationship_255

MD_Building (Shortcut)

MF_KeyedComputerSoftwareUsage

MD_Building_SurrogateKey

Relationship_256

MD_Building (Shortcut)

MF_KeyedComputerInUse

MD_Building_SurrogateKey

Relationship_257

MD_Room (Shortcut)

MF_KeyedComputerInUse

MD_Room_SurrogateKey

Relationship_258

MD_Room (Shortcut)

MF_KeyedComputerSoftwareUsage

MD_Room_SurrogateKey

Relationship_259

MD_Employee (Shortcut)

MF_KeyedComputerSoftwareUsage

MD_CollPers_SurrogateKey

Relationship_260

MD_Employee (Shortcut)

MF_KeyedComputerInUse

MD_CollPers_SurrogateKey

Relationship_261

MD_IssueTrackingUser (Shortcut)

MF_KeyedComputerEvent

MD_ITUser_SurrogateKey

Relationship_262

MD_KeyedComputer

MF_KeyedComputerEvent

MD_KeyedComp_SurrogateKey

Relationship_263

MD_CarletonDepartment (Shortcut)

MF_KeyedComputerEvent

MD_CarlDept_SurrogateKey

Relationship_264

MD_Date (Shortcut)

MF_KeyedComputerEvent

MD_Date_DateInteger

Relationship_265

MD_Time (Shortcut)

MF_KeyedComputerEvent

MD_Time_TimeInteger

Relationship_266

MD_Employee (Shortcut)

MF_KeyedComputerEvent

MD_CollPers_SurrogateKey

Relationship_267

MD_Room (Shortcut)

MF_KeyedComputerEvent

MD_Room_SurrogateKey

Relationship_268

MD_Building (Shortcut)

MF_KeyedComputerEvent

MD_Building_SurrogateKey

Relationship_269

MD_IssueTrackingAsset (Shortcut)

MF_KeyedComputerEvent

MD_ITAsset_SurrogateKey

Relationship_270

MD_KeyedComputerEvent

MF_KeyedComputerEvent

MD_KCEvent_SurrogateKey

Relationship_271

MD_ProgramOrApp

MF_KeyedComputerEvent

MD_Program_SurrogateKey

Relationship_272

MD_Date (Shortcut)

MF_KeyedComputerEvent

MD_Date_DateIntegerOther

Relationship_273

MD_Time (Shortcut)

MF_KeyedComputerEvent

MD_Time_TimeIntegerOther