Ecco Reports - Synar Merchants

Information and Screen Capture at a Glance

Report Name	Ecco Location	Report Purpose
Synar Merchants	Implementation Planning (IP) Dashboard/Reports	Compiles a full listing of Synar Merchants, location and visit history.

The Synar Merchants Report can be filtered prior to viewing.  Filters impact the presentation of data for the User Interface Screen via the Ecco System and the downloadable .CSV file.

Filter Name	Filter Options	Filter Purpose
LME	Select LME/MCO Region Note: Multiple Selections are Permitted	Search Program Provider based on LME/MCO Catchment Area.
Agency	Select Prevention Provider Agency  Note: Multiple Selections are Permitted	Search Respective Data for Program Providers.
Strategy Type	Search Staff Hours Based on Strategy  ·        All (All Strategies) ·        Prevention Education ·        Alternative Drug-Free Activities ·        Community-Based Process ·        Environmental ·        Problem Identification and Referral ·        Information Dissemination	Search Data by all or Individual Strategy.
Merchant State	Search by State of Store Location NOTE: Leave this filter option set to ALL.	Search Data by Store State Location.
Funding Source	Choose the Funding Source of the Strategy: ·  All ·  SAPBG · SPF-Rx (Currently Unused) · CURES/STR (Funded Ended) · PFS (Funded Ended, this option is not for PFS 2018) ·  PUDI (Currently Unused)  NOTE: At this time all users should select either ALL or SAPBG.	Search Data by all or Individual Funding Source
Report From AND Report To	Calendar Entry Selection	The Report From and Report To filters should be selected for all reports.  Make sure to choose the correct dates and fiscal years for your reports.

Data Type Formatting/Availability

ECCO User Interface Screen	.CSV Report File Details
Synar Merchants Report	Summary Merchants Report (.CSV)
	(Summary) Detail .CSV

The Synar Merchants Report Provides the Following Data to the User

Reports produced within the Synar Merchants produce the following data sets:

ROUTINE VISIT

• Agency
• Strategy Type
• Merchant State
• LME
• Funding Source
• Reporting Period
• LME/MCO
• Provider
• County
• Merchant Visited (N)
• State Sign Visible (N)
• Speak with Manager (N)
• Re-Check State Sign (N)
• Follow-Up Needs
• Tobacco Survey (N)
• Refer to Law Enforcement (N)
• Refer to FDA (N)

MANAGER FOLLOW UP

• Agency
• Strategy Type
• Merchant State
• LME
• Funding Source
• Reporting Period
• LME/MCO
• Provider
• County
• Merchant Contacted (N)
• Spoke with Manager (N)

STATE SIGN NON-COMPLIANCE

• Agency
• Strategy Type
• Merchant State
• LME
• Funding Source
• Reporting Period
• LME/MCO
• Provider
• County
• Merchant Visited (N)
• Spoke with Manager (N)
• State Sign Visible (N)
• Follow Up Needs
• FDA Referral
• Tobacco Survey
• Refer to Law Enforcement (N)

NON COMPLIANCE

• Agency
• Strategy Type
• Merchant State
• LME
• Funding Source
• Reporting Period
• LME/MCO
• Provider
• County
• Merchant Visited (N)
• Spoke with Manager (N)
• State Sign Visible (N)
• Follow Up Needs
• FDA Referral
• Tobacco Survey
• Refer to Law Enforcement (N)

Tobacco Survey

• Agency
• Strategy Type
• Merchant State
• LME
• Funding Source
• Reporting Period
• LME/MCO
• Provider
• County
• Merchants Visited (N)
• Asked for ID (N)
• Follow Ups
• FDA Referral
• Refer to Law Enforcement (N)