ESSENCE (Auto-Transfer)

On this page:

Introduction

The data for this extract is used to provide the Health Department with daily enrollment and attendance totals for the ESSENCE project (Electronic Surveillance System for the Early Notification of Community-based Epidemics. This version of the report allows the user to setup an automatic transfer to the Health Departments SFTP site.

Report Setup

There is some additional setup required to run the ESSENCE (Auto-Transfer) report.

The Remote Connection Manager needs to be enabled. Go to Start Page > System > System Settings > Plugin Management Configuration.
Click on Remote Connection Manager
Click on Remote Connect Manager again
Create a New Connection
- Name = the name you would like to give this remote connection (i.e. ESSENCE)
- Description = description of the connection
- Protocol = SFTP
- Host = essence.dhmh.maryland.gov
- Port = 22
- Username = Same username entered on the District Setup Page > FTP User Name for ESSENCE Attendance Upload
- Remote Path = the folder that the state has setup for your district on their SFTP server
- Allow Download = No checkmark (False)
- Allow Upload = Checkmark (true)
- Submit

Report Input – ESSENCE

For help with navigation and running the report, see How to Find and Generate a Report.

This report uses the State reporting Platform to generate results.

You will need to install and setup a night transfer via an FTP program to automatically transfer this file from your server to the specified server given by MSDE.

Field	Description
Report Parameters	Select Set All; this will store your selections for this report which is helpful when you need to submit a new file and you are unsure of how you created your last file.
Report Date	Leave blank for current date or enter the date you want to use.
Use Alternate School Numbers	If you require the use of the Alternate School number select Yes.
SFTP Connections	Choose the Remote Connection setup using the Remote Connection Manager.
Trace Log (Internal Option)	Check the enabled button of you would like Trace Enabled. Do not need to Enable.
Include Query Output in Trace (Internal Option)	If Trace is enabled you can enable the Query Output Row Number Limit. Do not need to set.
Query Output Row Number Limit (Internal Option)	If Trace is enabled you can enable the Query Output Row Number Limit. Do not need to set.
Sample Dataset Mode (Internal Option)	You do not need to check this box.
Scheduling – Please Select When to run	Click the Schedule button to schedule this report to run nightly. Check the weekdays only box
Please Select Schedule Settings	Enter the Start Date and Start time. Click the Repeat and Daily buttons.
Please select daily repeat cycle options.	Click the Weekdays only box.
Please select end date range option	Click the No End date or you may complete the Ends On field with the day after you last day of school.
Submit	Click the submit button. You will be taken to the Report Queue. Once your file is complete, click on the complete button and you will have a PDF file to assist you in compiling your spreadsheet for the State.

Back to Top

Report Output — ESSENCE

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item	Data Element	Description	[Table]FieldName	Field Type	Field Length	Begin / End Position
1	Run Date	This field contains run date for the report. Date is reported in YYYYMMDD format		Date	2	N/A
2	School Number	School number	[Schools]School_number	Alpha-numeric	4	N/A
3	School Name	School name	[Schools]School_name	Alpha-numeric	4	N/A
4	School Zip Code	School zip code	[Schools]zip	Numeric	5	N/A
5	Number of Students	Number of students enrolled in school for date or report	Calculated	Numeric		N/A
6	Number of Students Absent	Number of students absent in school for date of report.	Calculated	Numeric		N/A

Back to Top