Survey Results (by Survey Type)

<< Click to Display Table of Contents >>

Survey Results (by Survey Type)

Report Name: Survey Results (By Survey Type)

 

Report Type: Standard EQuIS Alive Report

 

Description: This report prompts the user to select the survey type of interest prior to opening, and uses this selection to determine the available parameters that display.

 

30099-pubSurvey

 
The parameters are based on the custom fields that were selected for the survey type. These fields come from RT_PARAMETER and are associated with the table as a group in RT_GROUP and RT_GROUP_MEMBER. The output is raw survey results with the custom field values also being returned.

 

Notes for Enterprise Use:

Due to the custom nature of this report, publishing it to the database involves the special steps explained below. This is required for use of the report in Enterprise*.

oOpen the Survey Results (by Survey Type) Report in EQuIS Professional.

oIn the popup window that opens, select the desired Survey Type and check the option to "Publish Report As".

oUpdate the default report name as desired. A report of the selected Type will be published to ST_REPORT and ST_REPORT_PARAMETER. The ST_REPORT.REPORT_NAME column populates with the survey type value prefixed with "FB77486--" in reference to the report .dll assembly file.

The EarthSoft.Reports.Library.77486.dll file must* be in the Enterprise bin folder for this report to run in EQuIS Enterprise.

 

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

 

Language: English

 

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

 

Input Parameters

Subfacility



Individual(s)


Group(s)

Date Range



Start Date


End Date

Survey



Habitat(s)


[Additional parameters based on Alive Survey Group defined in RT_SURVEY_TYPE.SURVEY_PARAM_GROUP_CODE which links to a group of the parameters in RT_GROUP]

Observation



Taxonomy [This will hold all taxonomy_code including its own groups as defined by using parent_code.]


Categories


Condition(s)


Gender(s)


Life Stage(s)


Quantity Estimated


Evidence Only


[Additional parameters based on Alive Observation Parameter Group defined in RT_SURVEY_TYPE.OBSERV_PARAM_GROUP_CODE which links to a group of the parameters in RT_GROUP

                                               

Note: * refers to hidden parameters.

 

Tables: DT_SUBFACILITY, RT_TAXONOMY, DT_SURVEY, DT_SURVEY_OBSERV

 

Database Type: SQL

 

Database Schema: Standard and Alive schemas required

 

Database Version: EQuIS 5.6.1 for Alive 5.6.1; EQuIS 6.1 for Alive 6.1

 

Data Requirements: Contact support@earthsoft.com for more information if no information is available.

 

Report Requirements: N/A

 

Output Type: Report grid with options for Excel and Crosstab

 

Example Output: View the following example.

 

30099-surveytypesurvey_zoom44