Dict-Physical

Table MF_KeyedComputerSoftwareUsage

Card of table MF_KeyedComputerSoftwareUsage

Name	MF_KeyedComputerSoftwareUsage
Dimensional Type	<None>
Comment	Instance of software being used in a given ten-minute period. To be useful, needs a coverage table that has all ten-minute increments available. The fundamental query on which the data here is based runs as follows: SELECT usageID, usageWhen, usageEnum, usageServerID, usageServerType, usageProgramID, programName, usageLicenseID, usageComputerID, usageExpansion, usageUser, usageAddress, usageGroup, usageEvent, KSTermEvent.termAbbreviation AS eventName, usageReason, usageTime, usageOtherTime, usageGMTOffset, usageCount FROM KSUsage LEFT OUTER JOIN KSPrograms ON KSUsage.usageProgramID = KSPrograms.programID LEFT OUTER JOIN KSTermEvent ON KSUsage.usageEvent = KSTermEvent.termID WHERE termAbbreviation IN ('up', 'down', 'logon', 'logoff', 'launch', 'quit') Possible event names include: eventName NULL audited block deny dequeue down issued launch launch offline license issued license revoked license start license stop logged launch logged launch offline logged quit logged quit offline logoff logon obtain queue quit quit offline return revoked shadow down shadow up up

Check constraint name of the table MF_KeyedComputerSoftwareUsage

CKT_MF_KEYEDCOMPUTERSOFTWAREUS

List of outgoing references of the table MF_KeyedComputerSoftwareUsage

Relationship_246

MD_ProgramOrApp

MD_Program_SurrogateKey

Relationship_247

MD_Time (Shortcut)

MD_Time_TimeInteger

Relationship_248

MD_Date (Shortcut)

MD_Date_DateInteger

Relationship_249

MD_KeyedComputer

MD_KeyedComp_SurrogateKey

Relationship_250

MD_IssueTrackingAsset (Shortcut)

MD_ITAsset_SurrogateKey

Relationship_252

MD_IssueTrackingUser (Shortcut)

MD_ITUser_SurrogateKey

Relationship_254

MD_CarletonDepartment (Shortcut)

MD_CarlDept_SurrogateKey

Relationship_255

MD_Building (Shortcut)

MD_Building_SurrogateKey

Relationship_258

MD_Room (Shortcut)

MD_Room_SurrogateKey

Relationship_259

MD_Employee (Shortcut)

MD_CollPers_SurrogateKey

List of diagrams containing the table MF_KeyedComputerSoftwareUsage

LabUsageDiagram

List of columns of the table MF_KeyedComputerSoftwareUsage

MD_KeyedComp_SurrogateKey

<None>

int

MD_Program_SurrogateKey

<None>

int

MD_Date_DateInteger

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

DW_DateInteger

int

MD_Time_TimeInteger

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift. In T-SQL, this is (hour * POWER(2, 16)) + (minute * POWER(2, 8)) + second.

<None>

int

MD_ITAsset_SurrogateKey

<None>

int

MD_ITUser_SurrogateKey

<None>

int

MD_CarlDept_SurrogateKey

<None>

int

MD_Building_SurrogateKey