Alive – Survey Results (By Survey Type) II

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with Alive Module >

Alive – Survey Results (By Survey Type) II

Report Name: Survey Results (By Survey Type) II (example)

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

Dependencies: N/A

Software: EQuIS Professional, EQuIS Alive, EQuIS Enterprise

Source: EQuIS Professional install (Alive Module)

Language: English

Output Type: Report Grid1

 

Description: In EQuIS Professional, 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. The Survey Type is appended to the end with two dashes ([Report Name]--[Survey Type]) to enable use of the report in Enterprise with the correct naming convention.

LIB-Alive-Survey_Type_II

 

Installation Instructions: This report requires a licensed EQuIS Alive Module and the Alive Schema applied to the database. The report is included in the EQuIS Professional install when the Alive Module feature has been enabled during installation. For more information see: Alive Installation.

 

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*.

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

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

Update the default report name to show in the report menu as desired and select OK.

At this point, the report must be run for it to save to the database.

A report of the selected Type will be published to the ST_REPORT and ST_REPORT_PARAMETER tables. The ST_REPORT.REPORT_NAME column populates with the survey type value prefixed with "SurveyResultsByTypeII--”.

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

 

Overview:

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

 

Tables: DT_SUBFACILITY, RT_TAXONOMY, DT_PERMIT, DT_SURVEY, DT_SURVEY_OBSERV

 

Report Parameters

Survey


Subfacility

Section for selecting individual and group subfacilities as well as whether or not to include child subfacilities, reamp codes and permit number.

Permit Number

See DT_PERMIT and DT_PERSON Output Table fields below.

Individual(s)

Parameter for individual subfacility selection.

Group(s)

When a Permit Number is selected, the Survey/Subfacility/Group(s) GROUP_CODE in RT_GROUP must have the same value as RT_PERMIT.PERMIT_NUMBER as the permit selected in order to appear in the selection list.

Remap Code

Remap code selection. Defined in the RT_REMAP_DETAIL table, where associated RT_REMAP.remark =[SURVEY_TYPE].

Include child subfacilities?

Defaults as Yes

Ebatch

Parameter for selecting a specific EDD.

Date Range

Section for selecting the Season, Survey Start Date and Survey End Date. The season applies to the RT_REMAP and RT_REMAP_DETAIL tables, where REMAP_CODE='SEASON’ and INTERNAL_VALUE is month number.

Habitat(s)

Parameter for selecting habitat(s).

Include surveys without observations

TRUE (Checked) = All surveys will be shown, even those without associated observations in the DT_SURVEY_OBSERV table.

FALSE (Unchecked) = Only survey will be shown with associated observations in the DT_SURVEY_OBSERV table.

Observation


Subfacility

Section for selecting individual and group subfacilities as well as whether or not to include child subfacilities.

Taxonomy

Select taxonomy ranks to include (selecting a parent rank will also include all children).

Taxonomy Parameter Code
(Inclusive – All Data)

(Inclusive – All Data) Option appends the associated Taxonomy Parameter to the output table, even if no data exists for the observations shown. Cannot select both inclusive and exclusive at the same time.

Taxonomy Parameter Code
(Exclusive – Filter Data)

(Exclusive – Filter Data) Option appends the associated Taxonomy Parameter to the output table and only shows observation rows if Taxonomy Parameter data exists for the observations shown. Cannot select both inclusive and exclusive at the same time.

Categories

Select all or individual categories.

Condition(s)

Select all or individual conditions.

Gender(s)

Select all or individual genders.

Life Stage(s)

Select all or individual life stages.

Quantity Estimated

Select blank for all, Y for only estimated quantities, or N for exact quantities only.

Evidence Only

Select blank for all, Y for observations where only evidence was found, or N for only visual observations of the animal.

dt_survey>
[Survey Type]

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 the RT_GROUP table.

dt_survey_observ>
[Survey Type]

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 the RT_GROUP table.

Additional Fields

SURVEY:

DT_FACILITY, DT_FILE, DT_GEOGRAPHY, DT_SPATIAL_EXTENT, DT_SUBFACILITY, DT_SURVEY, DT_TASK, RT_HABITAT, RT_SURVEY_TYPE

OBSERV:

DT_FILE, DT_GEOGRAPHY, DT_SAMPLE, DT_SPATIAL_EXTENT, DT_SUBFACILITY, RT_GENDER, RT_LIFE_STAGE, RT_TAXONOMY, ST_EDD_BATCH

PERMIT:

DT_PERMIT, DT_PERSON, RT_COMPANY

 

Report Output

Output Column

Source

Notes

facility_id

DT_FACILITY


survey_id

DT_SURVEY


permit_number

DT_PERMIT

Only shown if a permit is selected.

permit_name

DT_PERMIT

Only shown if a permit is selected.

executive_name

DT_PERMIT

Only shown if a permit is selected. This name is used to populate the DT_PERSON fields below.

title

DT_PERSON

Only shown if a permit is selected.

phone_number

DT_PERSON

Only shown if a permit is selected.

permit_category

DT_PERMIT.CUSTOM_FIELD_3

Only shown if a permit is selected.

effective_date

DT_PERMIT

Only shown if a permit is selected. The report will use this as a date filter if more restrictive than the Survey Date.

expiration_date

DT_PERMIT

Only shown if a permit is selected. The report will use this as a date filter if more restrictive than the Survey Date.

permit_type

DT_PERMIT

Only shown if a permit is selected.

permit_company_code

DT_PERMIT

Only shown if a permit is selected. References RT_COMPANY.

issuing_agency

DT_PERMIT

Only shown if a permit is selected

subfacility_code

DT_SURVEY

References DT_SUBFACILITY.

subfacility_name

DT_SUBFACILITY


subfacility_type

DT_SUBFACILITY

References RT_SUBFACILITY_TYPE

task_code

DT_SUBFACILITY

References DT_TASK

county

DT_SUBFACILITY


state

DT_SUBFACILITY

References RT_STATE

ebatch

DT_SURVEY


edd_file

ST_EDD_BATCH


survey_coord_type_code

DT_SPATIAL_EXTENT

Joins based on SPATIAL_EXTENT_ID. References RT_COORD_TYPE.

survey_x_coord

DT_SPATIAL_EXTENT

Joins based on SPATIAL_EXTENT_ID.

survey_y_coord

DT_SPATIAL_EXTENT

Joins based on SPATIAL_EXTENT_ID.

survey_z_coord

DT_SPATIAL_EXTENT

Joins based on SPATIAL_EXTENT_ID.

survey_type

DT_SURVEY

References RT_SURVEY_TYPE

survey_date

DT_SURVEY


survey_end_date

DT_SURVEY


SEASON

RT_REMAP_DETAIL


habitat_code

DT_SURVEY

References RT_HABITAT

surveyor

DT_SURVEY


action_taken

DT_SURVEY


remark

DT_SURVEY


[Custom Survey Fields]

RT_GROUP_MEMBER

As defined in the survey definition, Survey group (ASPG).

survey_observ_id

DT_SURVEY_OBSERV


category

DT_SURVEY_OBSERV


observ_number

DT_SURVEY_OBSERV


taxonomy_code

DT_SURVEY_OBSERV

References RT.TAXONOMY. As defined in the survey definition, Taxonomy group (ASTG).

common_desc

RT_TAXONOMY


sci_desc

RT_TAXONOMY


gender_code

DT_SURVEY_OBSERV

References RT_GENDER.

life_stage_code

DT_SURVEY_OBSERV

References RT_LIFE_STAGE.

observ_time

DT_SURVEY_OBSERV

DateTime field.

quantity

DT_SURVEY_OBSERV


qty_estimated

DT_SURVEY_OBSERV


evidence_desc

DT_SURVEY_OBSERV


evidence_only

DT_SURVEY_OBSERV


condition

DT_SURVEY_OBSERV


observ_subfacility_code

DT_SURVEY_OBSERV


coord_type_code

DT_SPATIAL_EXTENT

Joins based on SPATIAL_EXTENT_ID. References RT_COORD_TYPE.

x_coord

DT_SPATIAL_EXTENT

Joins based on SPATIAL_EXTENT_ID.

y_coord

DT_SPATIAL_EXTENT

Joins based on SPATIAL_EXTENT_ID.

z_coord

DT_SPATIAL_EXTENT

Joins based on SPATIAL_EXTENT_ID.

observ_action_taken

DT_SURVEY_OBSERV


observ_remark

DT_SURVEY_OBSERV


observ_sample_code

DT_SAMPLE

Displays the sample’s associated SYS_SAMPLE_CODE based on the associations in either AT_SAMPLE_OBSERV or AT_SUBFACILITY_LOCATION.

[Custom Observation Fields]

RT_GROUP_MEMBER

As defined in the survey definition, Observation Group (AOPG).

[Taxonomy Parameters]

RT_TAXONOMY_PARAMETER


[Additional Fields]



 

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.