Merge Data Sources can be added to support any data in the Equus Platform. The Communications Merge Data Sources screen is found at the system level. A stored procedure must be written in order to support new system data sources.
The list of Merge Data Sources on the Communications Merge Data Sources screen appears on in the Data Source drop down list on:
Email Template
Merge Document
Click on the links to view the data fields available for each merge data source name. Alternatively to find the names in the system, these can be found on the Email Templates screen in the sections: Email Content Merge Source and Email Content
Merge Data Source Name | Stored Procedure Name | Description |
EQ_STANDARD_MERGE_DOCUMENT_ASSIGNMENT_DEPENDENT | Data for Assignment Dependent Service Order | |
EQ_STANDARD_MERGE_DOCUMENT_COMP_ACCUMULATION_PROCESS | Data for Comp Accumulation Instructions | |
Destination Buyer Service Order | EQ_STANDARD_MERGE_DOCUMENT_DESTINATION_BUYER |
Returns selected fields regarding Company, Employee, Assignment, Service Order, and Mailing Address, Employee Contact, Dependent, and Destination Buyer data for a specified ServiceOrderID.
|
Employee | EQ_STANDARD_MERGE_EMPLOYEE |
Returns selected fields regarding Employee and Assignment data for a specified AssignmentID.
|
EQ_STANDARD_MERGE_DOCUMENT_EMPLOYEE_EXPANDED |
An Expanded Set of General Employee and Assignment Information for a specified AssignmentID.
| |
EQ_STANDARD_MERGE_DOCUMENT_EMPLOYEE_LISTING
| Returns selected fields regarding Company, Employee, Assignment, Service Order, and Mailing Address, Employee Contact, Dependent, and Employee Listing data for a specified ServiceOrderID. | |
EQ_STANDARD_MERGE_DOCUMENT_SERVICE_ORDER | Returns selected fields regarding Company, Employee, Assignment, Service Order, and Mailing Address, Employee Contact and Dependent data for a specified ServiceOrderID. | |
EQ_STANDARD_MERGE_DOCUMENT_INVOICE | Data for Invoices for a specified InvoiceID | |
EQ_STANDARD_MERGE_DOCUMENT_HHG |
Returns selected fields regarding Company, Employee, Assignment, Service Order, and Address(es), Employee Contact, Dependent, and Move Management data for a specified ServiceOrderID.
When this is used from the Move Management Needs Assessment screen, the data source will return data from each Detail record associated with the specified ServiceOrderID.
| |
EQ_STANDARD_MERGE_DOCUMENT_TEMP_LIVING |
Returns selected fields regarding Company, Employee, Assignment, Service Order, and Mailing Address, Employee Contact, Dependent, and Temp Living data for a specified ServiceOrderID.
| |
Training Service Order | EQ_STANDARD_MERGE_DOCUMENT_TRAINING | Data for Training Service Order for a specified ServiceOrderID |


