Argos reporting view column reference – Argos support

Argos data can be accessed through a SQL view for export to CSV or through other reporting tools. Custom export/reporting is available as a professional service from Sepialine Support, but if you'd like to create your own exports, use the following information table as a guide.

Available data columns

The following columns are defined in the argReports view:

#	Column name	Data type	Description
1	ID	int	Unique identifier for each activity record
2	SetGUID	uniqueidentifier	A GUID that gangs multiple documents together (a batch print job, for example)
3	Label	nvarchar	The filename for print jobs, or a sensible descriptor for other job types
4	UserAccountID	int	Unique identifier for each user account
5	UserID	int	The foreign key identifier for the argUsers table
6	StatusID	int	The foreign key identifier for the argStatusCodes table
7	UserFullMachineName	nvarchar	The name of the computer on which a print job originated
8	JobTrackedDateUtc	datetime	The date and time at which a job was tracked, in Greenwich Mean Time (GMT)
9	JobTrackedDateLocal	datetime	The date and time at which a job was tracked in local server time
10	BilledDateUtc	datetime	The date and time at which a job was billed, in Greenwich Mean Time (GMT)
11	BilledDateLocal	datetime	The date and time at which a job was billed in local server time
12	Comments	nvarchar	The comment as supplied by the user in the Desktop Client
13	LastModifiedUtc	nvarchar	The GMT date and time at which the record was last modified. This value is updated whenever a record is edited in Argos Manager.
14	Pages	int	The number of original pages in a paper-based job
15	Copies	int	The number of copies made of a paper-based job
16	Quantity	int	The total number of pages in a paper-based job. Equals Pages × Copies
17	GlobalID	uniqueidentifier	A GUID that identifies the record
18	Color	int	A flag indicating a color paper-based job. 0 = black and white, 1 = color.
19	IsAllocated	int	A boolean flag indicating whether a record is Recycled. 0 (zero) if Recycled, 1 if not
20	JobBatchID	int	An identifier that groups jobs together. See SetGUID.
21	IsPosted	int	A boolean flag indicating that a job was exported to an external accounting destination
22	DatePosted	datetime	A timestamp indicating when the record was exported to an external accounting destination
23	ActualWidthMM	numeric	The tracked width of a paper-based job, expressed in millimeters
24	ActualHeightMM	numeric	The tracked height of a paper-based job, expressed in millimeters
25	ActualWidthInches	numeric	The tracked width of a paper-based job, expressed in inches
26	ActualHeightInches	numeric	The tracked height of a paper-based job, expressed in inches
27	ActualAreaSqM	numeric	The tracked area of a single page in a paper-based job, expressed in square meters
28	ActualAreaSqFt	numeric	The tracked area of a single page in a paper-based job, expressed in square feet
29	AdjustedHeightMM	numeric	The nominal height of a paper-based based on defined paper sizes, expressed in millimeters
30	AdjustedWidthMM	numeric	The nominal width of a paper-based based on defined paper sizes, expressed in millimeters
31	AdjustedHeightInches	numeric	The nominal height of a paper-based based on defined paper sizes, expressed in inches
32	AdjustedWidthInches	numeric	The nominal width of a paper-based based on defined paper sizes, expressed in inches
33	AdjustedAreaSqM	numeric	The nominal area of a single page in a paper-based job, expressed in square meters
34	AdjustedAreaSqFt	numeric	The nominal area of a single page in a paper-based job, expressed in square feet
35	TotalAdjustedAreaSqM	numeric	The total nominal area in a paper-based job, expressed in square meters
36	TotalAdjustedAreaSqFt	numeric	The total nominal area in a paper-based job, expressed in square feet
37	PhoneCallDuration	bigint	The length of a phone-based job, in minutes
38	PhoneTalkedWithNumber	nvarchar	The phone number of the other party
39	UnitName	nvarchar	The paper size (e.g. "Letter," "A4," etc.) for paper-based jobs
40	DisplayUserAccountID	numeric	Unique identifier for the user account that is set as the display name when merged with another user account
41	UserName	nvarchar	The resolved alias network username of the person who originated the job. If A is an alias for B, this field contains B.
42	UserDomainName	nvarchar	The domain name of the person who originated the job
43	UserOfficeName	nvarchar	The location of the person who originated the job
44	UserFirstName	nvarchar	The first name of the person who originated the job
45	UserLastName	nvarchar	The last name of the person who originated the job
46	UserGroupName	nvarchar	The name of the Argos user group of which the job originator is a member
47	DeviceGUID	uniqueidentifier	A GUID assigned to the device in Argos
48	DeviceGUIDAsString	nvarchar	The DeviceGUID value, described above, cast as a string value
49	DeviceName	nvarchar	The name of the device. For print devices, this will typically assume the UNC form, \\servername\printername
50	DeviceAsset	nvarchar	Alphanumeric string identifying the asset tag of the device
51	DeviceOfficeName	nvarchar	The name of the location to which the device is assigned
52	DeviceGroupName	nvarchar	The name of the Argos device group of which the device is a member
53	MediaID	int	The foreign key identifier for the argMedia table
54	MediaName	nvarchar	The name of the media type (e.g. "Bond Paper")
55	PricingBasisID	int	As numeric value indicating the basis on which the job price was based. Values are: 1 = Paper size, 2 = ?????
56	PricingBasisName	nvarchar	A string representation of the job's pricing basis (e.g. "Paper size," "Square feet," etc.)
57	StatusName	nvarchar	A string representation of the job's billing status
58	BillingCodeID	int	The foreign key identifier for the argBillingCodes table
59	Level0ID	int	The foreign key identifier for the top level [billing code assigned to the job by a user via the DtC
60	Level0Number	nvarchar	The top tier billing code number
61	Level0Name	nvarchar	The top tier billing code name
62	Level1Number	nvarchar	The second tier billing code number
63	Level1Name	nvarchar	The second tier billing code name
64	Level2Number	nvarchar	The third tier billing code number
65	Level2Name	nvarchar	The third tier billing code name
66	Level3Number	nvarchar	The fourth tier billing code number
67	Level3Name	nvarchar	The fourth tier billing code name
68	Level4Number	nvarchar	The fifth tier billing code number
69	Level4Name	nvarchar	The fifth tier billing code name
70	PricingScheduleID	int	The foreign key identifier for the argPricingSchedules table
71	PricingScheduleName	nvarchar	The name of the job's [pricing schedule
72	BillingCodeTypeName	nvarchar	The name of the top tier billing code type
73	BillingCodeOfficeName	nvarchar	The name of the location to which the billing code has been assigned
74	ProjectManager	nvarchar	The name of the project manager associated with the top tier billing code
75	ProjectManagerFirstName	nvarchar	The first name of the project manager associated with the top tier billing code
76	ProjectManagerLastName	nvarchar	The last name of the project manager associated with the top tier billing code
77	PSName	nvarchar	The name of the job's pricing schedule
78	ActivityType	int	0 paper, 1 for phone
79	JobTypeName	nvarchar	A string representation of the job type (e.g. "Print," "Copy," "Scan," etc.)
80	OriginalUnits	float	Number of original pages * units factor. Units factor depends on the type of pricing unit. For example if the pricing unit is 'Square foot' and the job was 18 by 34 inches the unit factor will be 3. (18 * 32) = 3 sq. feet
81	CopyUnits	float	Number of duplicate (copy) pages * units factor
82	TotalUnits	float	OriginalUnits + CopyUnits
83	TaxRate	float	The tax rate for the job, as determined by the job's media type
84	Cost	float	Based on the job's media type, the defined cost for one unit
85	Charge	float	Based on the job's media type, the defined charge for one unit
86	CopyCost	float	Based on the job's media type, the defined copy cost for one unit
87	CopyCharge	float	Based on the job's media type, the defined copy charge for one unit
88	ColorCost	float	Based on the job's media type, the defined cost for one color unit
89	ColorCharge	float	Based on the job's media type, the defined charge for one color unit
90	ColorCopyCost	float	Based on the job's media type, the defined copy cost for one color unit
91	ColorCopyCharge	float	Based on the job's media type, the defined copy charge for one color unit
92	CostSum	float	Originals cost without tax
93	ChargeSum	float	Originals charge without tax
94	CopyChargeSum	float	Duplicates (copies) charge without tax
95	CopyCostSum	float	Duplicates (copies) cost without tax
96	CostSumWithTax	float	Originals cost with tax
97	ChargeSumWithTax	float	Originals charge with tax
98	CopyChargeSumWithTax	float	Duplicates (copies) charge with tax
99	CopyCostSumWithTax	float	Duplicates (copies) cost with tax
100	FinalChargeTaxAmount	float	The tax component of the job's total charge
101	FinalCostTaxAmount	float	The tax component of the job's total cost
102	FinalCharge	float	The complete charge for the job
103	FinalCost	float	The complete cost of the job
104	FinalChargeWithTax	float	The complete charge of the job, including tax
105	FinalCostWithTax	float	The complete cost of the job, including tax
106	UserEmail	nvarchar	The email address of the user account
107	OriginalSku	nvarchar	The stock keeping unit assigned to the original job
108	CopySku	nvarchar	The stock keeping unit assigned to additional copies of an original job

Available data columns

0 Comments