Skip to main content
Skip table of contents

Database Views description

There are two groups of views; dimensions and facts . The fact views contain measures, numeric data which can be used in calculations for reports. The dimension views contain descriptive information used for the measures in the facts. Dimension views have the dim_ prefix and fact views have the fact_ prefix.

The IDs in the views are internal MyQ IDs and can be used to establish relationships between views.

Site Dimension (dim_ Site) - Information about the site where the sessions were registered.

Field Name

Description

ID

Site ID

Name

Site name

Address

Site URL

Printer Dimension (dim_Printer) - Information about the printer

Field Name

Description

ID

Printer ID

Name

Printer name

IPAddress

Printer IP address

MAC

Printer MAC address

Brand

Printer brand

Model

Printer model

Location

Printer location

Serial_Number

Printer serial number

User Dimension (dim_User) - Information about the user

Field Name

Description

ID

User ID

Username

MyQ username

Fullname

User's name and surname

Email

User's email

Phone

User's phone number

Personal_number

User's MyQ personal number

Accounting Group Dimension (dim_ Accounting_ Group) - Information about user groups

Field Name

Description

ID

Group ID

Name

Group name

Parent_ID

The parent group ID. Null if the group has no parent group.

Path

The path of the group, formed by the ID of the ancestor groups separated by the character "|". This can be used to build the hierarchy of user groups.

Project Dimension (dim_Project) - Information about projects

Field Name

Description

ID

Project ID

Name

Project name

Code

Project code

Group_ID

ID of the project group containing the project

Project Group Dimension (dim_Project_Group) - Information about project groups

Field Name

Description

ID

Project group ID

Name

Project group name

Parent_ID

The parent group ID. Null if the group has no parent group.

Path

The path of the group, formed by the ID of the ancestor groups separated by the character "|". This can be used to build the hierarchy of project groups.

Job Fact (fact_job) - Information about print jobs

Field Name

Description

ID

Job ID

Session_ID

Session ID

Name

Job name

Owner_ID

Job owner ID

Printer_ID

Printer ID where the job was printed. Null if not printed

Computer

Computer name or address where the job was sent from

Size_in_bytes

Job size in bytes

Pages_mono

Number of pages in black and white

Pages_color

Number of pages in color

Copies

Number of copies

State

Job state

Printed_date

Date when the job was printed

Printed_time

Time when the job was printed

Creation_date

Date when the job was created

Creation_time

Time when the job was created

Session Counter Fact (fact_Session_Counters) - Information about user sessions

Field Name

Description

ID

Job ID

Finish_date

Date when the session was closed

Finish_time

Time when the session was closed

Finish_year

Year when the session was closed

Finish_month

Month when the session was closed

Finish_day

Day when the session was closed

Finish_hour

Hour when the session was closed

User_ID

ID of the user who created the session

Printer_ID

Printer ID

Site_ID

Site ID

Project_ID

Project ID

User_group_ID

Accounting group ID

Total_price_user

Total price of the session for regular users

Total_price_admin

Total price of the session for users with admin rights

Total_pages

Total pages of the session

Print_mono

Number of pages printed in black and white

Print_color

Number of pages printed in color

Copy_mono

Number of pages copied in black and white

Copy_color

Number of pages copied in color

Copies

Number of copies

Fax

Number of pages printed due to fax, in black and white

Scan

Number of scanned pages

PaperA4

Number of A4 sheets used

PaperA3

Number of A3 sheets used

PaperA5

Number of A5 sheets used

PaperB4

Number of B4 sheets used

PaperB5

Number of B5 sheets used

PaperFolio

Number of Folio sheets used

PaperLedger

Number of Ledger sheets used

PaperLegal

Number of Legal sheets used

PaperLetter

Number of Letter sheets used

PaperStatement

Number of Statement sheets used

PaperOther

Number of sheets with other paper formats used

Printer job counters (fact_PRINTERJOB_COUNTERS_V2) - Information about printer job counters

Field Name

Description

ID

Session ID

Finish_date

Date when the session was closed

Finish_time

Time when the session was closed

Finish_year

Year when the session was closed

Finish_month

Month when the session was closed

Finish_day

Day when the session was closed

Finish_hour

Hour of the day when the session was closed

User_ID

ID of the user who created the session

Printer_ID

ID of the printer

Site_ID

ID of the site

Project_ID

ID of the project used for the session

User_group_ID

ID of the accounting group

Type

Type of the operation (print, copy, scan, fax)

Paper_format

Paper format

Price

Price for the job

Duplex

Yes if the job was printed in duplex mode

No if the job was not printed in duplex mode

Mono

Number of pages printed in black and white

Color

Number of pages printed in color

Single_color

Number of pages printed in single color

Click_mono

Number of printed mono images

Click_color

Number of printed color images

Sheets

Number of used papers

Alert Fact (fact_Alert) - Information about printer alerts

Field Name

Description

Printer_ID

Printer ID where the alert was generated from

Severity

Alert severity

Training

Level of training required to handle the alert

Code

Alert code

Creation_Date

Date when the alert was generated

Creation_Time

Time when the alert was generated

Resolved_Date

Date when the alert was resolved

Resolved_Time

Time when the alert was resolved

There is a limitation that even if you are using a Job Privacy license, the data in the database are not changed by this feature and are still readable.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.