EIA Summary

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > EIA (EQuIS Information Agent) Reports >

EIA Summary

Report Name: EIA Summary Report

 

Report Type: Standard

 

Description: The EIA Summary Report generates the information of one or more selected USER_ID(s) such as agent name, trigger parameters, and push report parameters. In version 6.3, the Created Date range selection is added to the report parameters, which filters ST_TASK.CREATE_DATE with task_type='ReportGenerate'.

 

Report Dependencies: There are no dependencies for this report.

 

File Name: EarthSoft.Reports.Library.49303.dll

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

USER_ID


Agent Types


Created Date



Start Date


End Date

30029-input.param.scrnsht

REPORT_EVENT_ID

USER_REPORT_ID

AgentName

Locations

LocationGroups

ActionLevels

TriggerParameters

PushReportParameters

PushReportParameterValues

AgentType

OutputFormat

LimitReportToNewData

AgentDescription

Remark

SentTo

Creator

PickReportName

LastNoticeDate

LastRunDate

NextRunDate

CreatedDate

 

Tables:        ST_REPORT_EVENT_ID, ST_USER_REPORT_ID, ST_USER_REPORT_PARAMETER, DT_LOCATION, RT_GROUP, RT_GROUP_MEMBER, RT_METHOD_ANALYTE_GROUP, RT_METHOD_ANALYTE_GROUP_MEMBER, DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, ST_REPORT_EVENT, ST_USER, ST_REPORT_EVENT_JOB

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 5.5+

 

Data Requirements: N/A

 

Report Requirements: The User(s) parameter of this report will only show the current user, unless you are an ALS Administrator. If you are an ALS Administrator, you will see all active users.

 

Output Type: Igrid for Professional, Excel file for Enterprise

 

Note: In Microsoft Excel the default format for date columns such as CreatedDate does not include time. To display the time from the EQuIS output, change the cell format to a date type that shows time.

 

Example Output: View the following example or download the EIA Summary Report.xlsx