ViewReference_84

VMF_SurveyCellData

ViewReference_107

VMF_IssueTrackingTicket

ViewReference_141

VMF_RoomUtilization

ViewReference_232

VMF_KeyedComputerEvent

VMD_Time

VMD_TIME

View

ViewsSurvey

VMD_Time

VMD_TIME

View

ViewsSurvey

ViewsIssueTrackingDiagram

SELECT,VIEW DEFINITION

CardAccessReader

SELECT,VIEW DEFINITION

EnergyReader

SELECT,VIEW DEFINITION

IssueTrackingReader

SELECT,VIEW DEFINITION

SpaceReader

SELECT,VIEW DEFINITION

SurveyReader

MD_Time_TimeInteger

int

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.

MD_Time_HH24:MM

char(5)

Time of day in military/24-hour format (e.g., 13:00 = 1 pm). No seconds (or milliseconds). Padded with spaces on the left to five characters to faciliate sorting.

5

MD_Time_HH12:MM_AMPM

char(8)

Time of day in 12-hour am/pm format. Does not include seconds (e.g., 1:00 pm = thirteen hundred hours). Padded with spaces on the left to eight characters, to facilitate sorting.

8

MD_Time_HourOfDay12

int

Hour of day, by twelve-hour clock (0-11).

MD_Time_Second

int

Second of hour, 0 - 59.

MD_Time_ampm

char(2)

Value will be "am" or "pm" depending on whether the time in question occurs before or after 12:00 noon.

2

MD_Time_HH24:MM:SS

char(8)

Full time of day, with seconds, in military/24-hour format (e.g., 13:00:00 = 1 pm). Padded with spaces on the left to eight characters to faciliate sorting.

8

MD_Time_HH12:MM:SS_AMPM

char(11)

Time of day in 12-hour am/pm format. Includes seconds (e.g., 1:00:00 pm = thirteen hundred hours). Padded with spaces on the left to eleven characters, to facilitate sorting.

11

MD_Time_HourOfDay24

int

Hour of day, 0-23.

MD_Time_Minute

int

Minute of hour, 0 - 59.

MD_Time_SecondsSinceMidnight

int

Number of seconds elapsed since midnight (0 - 86399).