Argos reporting view column reference

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 × Quantity

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

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.