Standard AQ - Staffing Action

Overview

Updated 04/26/2022

• Click here for information on the Staffing Action Archive AQ
• Click here for information on Advanced Queries.

Report Logic
Report Description
Parameters
Report Fields

Report Logic

There are three Date types which are: Date Entered, Start Date, and End Date.

1. Original Start Date if parameter Date Type =EnteredDate
   1. The Original Start Date is the time and date when the message was first posted.
2. StartDate if parameter Date Type =StartDate
3. Endate if parameter Date Type =EndDate

The Start Date can be manually specified before, after, or even at the same time as the original message posting date and time.

Report Description

This AQ displays staffing messages. 

Parameters

Parameter Name	Options	Description
Branch	All available branches	User Branch
Date Type	EnteredDate, StartDate, EndDate	Click here to go to the Report Logic section above
Start Date
End Date
Entered By	All available message entered by a user	Filters result by User Description who entered message.
Is Complete	All, Complete, Non Complete	Filter by the complete or non complete message.
Action Type	All available action type
Customer Name		Filters result by customer name.

Report Fields

Field Name	Description
Staffing Company	Supplier company from supplier
Branch Name	Supplier branch
Action Type	Message action type from message (e.g. Cold Call, Email, FollowUp, Meeting etc.)
Message Type	Message type from message (e.g. Task, Appointment etc.)
Subject	Message subject from message.
Message	Message
Date	Pull Orginal Start Date if parameter Date Type =’EnteredDate’, StartDate if parameter Date Type =’StartDate’ and Endate if parameter Date Type =’EndDate’ from message. The date is between parameter StartDate and EndDate.
Entered By User	User Description from the message
Employee Name	Name of employee message send. For Message Action origin=’Employee’
Customer Name	Name of customer message send. For Message Action origin =Customer’
Contact Name	Name of contact message send. For Message Action origin=’Contact’
Link Users	Users name who are linked with the particular message.
Is Complete	Check for IsComplete =1 for complete message and uncheck for IsComplete=0 for not complete message.
Order ID	OrderId for message send to Order, Pull order ID having Message Action origin=’Order_Dh’ , having Message Action origin=’Order_Temp.’
Assignment ID	Assignment ID for message send to Assignment. Pull Assignment ID having Message Action origin=’Assignment’
Agency Name	Name of Agency for message send to Agency. Pull Agency Name having Message Action origin=Agency
WC Claim ID	WcClaim  ID for message send to WcClaim. Pull WcClaim ID having Message Action origin= WcClaim’.
Unemployment ID	Unemployment  ID for message send to Unemployment  . Pull Unemployment  ID having Message Action origin= Unemployment  .
BoldJobID	Identifier for job record in AviontéBOLD (Front Office)
EnteredByUserName	The Username from the message
EnteredByUserDescription	The User description from the message