Consolidation Sample and Load Results

Report Name: Geotechnical Consolidation Sample and Load Results (example 1, example 2)

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

Dependencies: Licensed EQuIS Geotech and Geotech Schema

Software: EQuIS Professional and Enterprise

Source: EQuIS Geotech (EarthSoft Community Center > Products > EQuIS Geotech)

Language: English

Output Type: Report Grid1

Description: The Geotechnical Consolidation Sample and Load Results report returns geotechnical sample parameters and load test results related to a Consolidation test. Dependent on whether a user selects "Sample Properties" or "Load Test Results" from the Output Includes report parameter, only the relevant fields will be included in the report output. This report can be run in EQuIS Professional or published to EQuIS Enterprise.

Installation Instructions: This report requires an EQuIS Geotech license and the Geotech Schema applied to the database. The Geotechnical Consolidation and Load Results report (EarthSoft.Reports.Library.176839.dll) is available for download in the Products\EQuIS Geotech folder on the Downloads Dashboard on the EarthSoft Community Center. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Additional Information: The Consolidation Sample and Load Results report queries the Consolidation test results stored in the DT_GEO_RESULT and DT_GEO_TEST_PARAMETER tables, where DT_GEO_TEST.TEST_TYPE = 'Consolidation_Detail' and 'ConsolidationLoad'.

•The "Sample Properties" parameter outputs the sample results associated with the Consolidation test. This includes test notes, the initial and final moisture content, as well as overall test results, such as the Preconsolidation pressure (Pc).

•The "Load Test Results" parameter outputs results associated with each load reading applies to the sample. The report orders the Load Test Results based on SYS_LOC_CODE, SYS_SAMPLE_CODE, and then incrementally based on the load number.

The following table outlines the EQuIS source of the data included in the report output.

Report Field	EQuIS Source
Sample Properties Output
test_method	DT_GEO_TEST.TEST_TYPE = 'Consolidation_Detail'	DT_GEO_TEST.TEST_METHOD
consolidometer		DT_GEO_TEST_PARAMETER.PARAM_CODE = 'consolidometer'
Specimen_diameter		DT_GEO_TEST_PARAMETER.PARAM_CODE = 'specimen_diameter'
Initial_specimen_height		DT_GEO_TEST_PARAMETER.PARAM_CODE = 'init_specimen_height'
length_unit		DT_GEO_TEST_PARAMETER.PARAM_UNIT where DT_GEO_TEST_PARAMETER.PARAM_CODE = 'init_specimen_height'
specific_gravity		DT_GEO_RESULT.RESULT_CODE = 'specific_gravity'
initial_moisture		DT_GEO_RESULT.RESULT_CODE = 'initial_wc'
final_moisture		DT_GEO_RESULT.RESULT_CODE = 'final_water_content'
initial_dry_density		DT_GEO_RESULT.RESULT_CODE = 'initial_dry_density'
final_dry_density		DT_GEO_RESULT.RESULT_CODE = 'final_dry_density'
density_unit		DT_GEO_RESULT.RESULT_UNIT where DT_GEO_RESULT.GEO_RESULT_CODE = 'initial_dry_density'
initial_void_ratio		DT_GEO_RESULT.GEO_RESULT_CODE = 'initial_void_ratio'
final_void_ratio		DT_GEO_RESULT.GEO_RESULT_CODE = 'final_void_ratio'
initial_saturation		DT_GEO_RESULT.GEO_RESULT_CODE = 'initial_saturation'
final_saturation		DT_GEO_RESULT.GEO_RESULT_CODE = 'final_saturation'
overburden		DT_GEO_TEST_PARAMETER.PARAM_CODE = 'overburden' This value is rounded to a whole number.
overburden_unit		DT_GEO_TEST_PARAMETER.PARAM_UNIT where DT_GEO_TEST_PARAMETER.PARAM_CODE = 'overburden'
cc		DT_GEO_RESULT.GEO_RESULT_CODE = 'compression_index'
cr		DT_GEO_RESULT.GEO_RESULT_CODE = 'rebound_index'
cc_vr		DT_GEO_RESULT.GEO_RESULT_CODE = 'compres_index_vrplot'
cr_vr		DT_GEO_RESULT.GEO_RESULT_CODE = 'rebound_index_vrplot'
pc		DT_GEO_RESULT.GEO_RESULT_CODE = 'pc_calc'
pc_override		DT_GEO_RESULT.GEO_RESULT_CODE = 'pc_override'
test_notes		DT_GEO_TEST.REMARK
test_start_date		DT_GEO_TEST.TEST_DATE
Load Readings Output
test_method	DT_GEO_TEST.TEST_TYPE = 'ConsolidationLoad'	DT_GEO_TEST.TEST_METHOD
load_number		DT_GEO_RESULT.GEO_RESULT_CODE = 'load_number'
stress		DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_Stress'
stress_unit		DT_GEO_RESULT.RESULT_UNIT where DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_Stress'
cumulative_deflection		DT_GEO_RESULT.GEO_RESULT_CODE = 'Cumulative_Deflect'
deflection_unit		DT_GEO_RESULT.RESULT_UNIT where DT_GEO_RESULT.GEO_RESULT_CODE = 'Cumulative_Deflect'
strain		DT_GEO_RESULT.GEO_RESULT_CODE = 'cons_strain'
void_ratio		DT_GEO_RESULT.GEO_RESULT_CODE = 'void_ratio'
t50		DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_T50'
t90		DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_T90'
time_unit		DT_GEO_RESULT.GEO_RESULT_UNIT where DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_T90'
cv50		DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_Cv50'
cv90		DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_Cv90'
cv_unit		DT_GEO_RESULT.GEO_RESULT_UNIT where DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_Cv90'

Tables: DT_SAMPLE, DT_FACILITY, DT_GEO_TEST, DT_GEO_TEST_PARAMETER, DT_GEO_RESULT

Report Parameters

Task Code(s)	Parameter for selecting task code(s).
Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Output Includes	Required parameter for selecting report output. Defaults to Sample Properties.
Sample Properties	Parameter for including Sample Properties fields in report output.
Load Test Results	Parameter for including Load Test Results fields in report output.

1The Report Grid provides additional export options to Excel, PDF, Text, Access, XML, etc.