gINT 2012 Documentation

This documentation covers the gINT template ACE MVD with Rapid CPT 01 September 2012. Several tables are covered, with additional information pertaining to traditional CEMVN undisturbed and general type borings. This allows the user to create boring log submissions equivalent to the historic CEMVN txt file format.

The tables contained in this documentation are listed below, followed by a short description.

Table Name	Description
Main Group	A gINT high level tab
Project
Bore Hole
Water Levels
Sample
MVN Lab Soil Descriptions	A gINT high level tab
Lab Lithology
MVN Final (white Line) Data
Lab Testing	A gINT high level tab
Lab Specimen
WC Density
Sieve
Atterberg
Unconf Compr
Organic Test
Triaxial
Consolidation
Console Readings
CPT	A gINT high level tab
CPT	Data in this table in not enterable.
CPT Data	Data in this table in not enterable.

A detailed review of a selection of pertinent tables. This includes all fields for the table, the data type of each field, and a description of each field.

*The fields in green record the traditional information for CEMVN undisturbed and general type borings. Populating these fields will create a boring log submission that is equivalent to the historic CEMVN txt file format.

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
Purpose	Text
Contract Number	Text
Division	Text
Installation	Text
Name	Text
Name Line 2	Text
Number	Text	Project Number
Job Number	Text	CEMVN assigned Boring Job Number for a set of boring logs.
Client	Text
Client Number	Text
Site Name	Text
Address	Text
Site Name	Text
Address	Text
Site Number	Text
City	Text
State	Text
Zip	Single
Country	Text
Watershed	Text
Project Manager	Text
Project Engineer	Text
Township	Text
Location	Memo	General Project Location Description
Coordinate System	Text	Mandatory field; defined when gINT database is created (Choose State Plane for CEMVN data) #9: Lookup is called "Coordinate System" and is located in Data Design:Library Data.
Coordinate System Zones	Text	Mandatory field; defined when gINT database is created (Choose 1702 for CEMVN data)
Datum Horizontal	Text	Mandatory field; defined when gINT database is created (Choose NAD83 for CEMVN data) Lookup is called "Datum Horizontal" and is located in Data Design:Library Data.
Elevation Datum	Text	Mandatory field; defined when gINT database is created (Choose NAVD88 for CEMVN data) Lookup is called "Datum Vertical" and is located in Data Design:Library Data.
Notes	Memo	Data entered here is for documentation purposes only. It is not printed on any report.
Water_Unit_Wt	Single	Unit weight of water. Needed for density calculations in lab testing.
Coeff_of_Consol_Factor	Single	Equivalent of Cv = 1 meter^2/year. For example, ft^2/year would be 10.76391. Only needed in Consolidation test if calculating Cv50 and Cv90 from T50 and T90.
Input Units	Text	Mandatory field; defined when gINT database is created (Choose E for CEMVN data) English (Imperial) or Metric. The default is English.
Output Units	Text	Mandatory field; defined when gINT database is created (Choose E for CEMVN data) English (Imperial) or Metric. The default is English.
Depth Log Page	Single	Depth on first page of log in Output Units. Default is 20ft or 6m for the legal size version and 14ft or 5m for the 8.5x11" version. Can be overridden for specific boreholes with the Depth_Log_Page field in the BOREHOLE (POINT) table. Feet or Meters
Show Lab Material Descriptions	Boolean	If checked, the lab material descriptions will appear on the broing log. If unchecked (the default), then field descriptions appear in the log.
Drained Threshold Zone	Text	This field is used to determine the threshhold for specifying whether the soil exhibits drained or undrained behavior. This affects OCR, Su Phi', Dr, M, St, FC calculations. Specify the minimum zone number that drained behavior will be evaluated i.e. if 4 is selected, zones 4-9 have drained behavior.
Max Drained Threshold Zone	Integer	This field is used to determine the maximum threshold for specifying whether the soil exhibits drained or undrained behavior. This affects OCR, Su Phi', Dr, M, St, FC calculations. Specify the maximum zone number that drained behavior will be evaluated i.e. if 7 is selected, zones 4-7 have drained behavior. This drained threshold is only used by the normalized soil behavior types.
Drained Threshold Soil Behavior Type	Text	This determines which soil behavior type value is used to determine whether calculations for drained or undrained behavior are performed.
Phi in K0 Calc	Text	Use this field to assign which phi' value is used in the calculation of K0 = (1-sin(phi')) * OCR^sin(phi') - this determines the K0 (1) calculation
OCR in K0 Calc	Text	Use this field to assign which OCR value is used in the calculation of K0 = (1-sin(phi')) * OCR^sin(phi') - this determines the K0 (1) calculation
Dr in M Calc	Text	Use this field to assign which Dr value is used in the calculation of M = qc * 10^(1.09-0.0075*Dr) - this is used to calculate M2 in sands
Nu	Text	This is used in determining Su (1)
NkT	Text	This is used in determining Su (2)
Nk	Single	This is used in Su (4)
Nc	Integer	This is used in Su (5)
Use Estimated Total Density Values	Boolean	Use this field to specify that the total stress calculations should be based on the estimated total density values. If selected as true, it will use the estimated total density values.
CPT Stress Units	Text	This is used to tell RAPID CPT to convert from tsf, which RAPID CPT uses as its base unit,s to whatever units are specified here (tsf, psi, kPa, MPa).
CPT Density Units	Text	Default Value is ‘pcf’
CPT Import Correspondence File	Text	Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Logo	Text
Location Type	Text
K in OCR (1) Calc	Single
Use qc in Correlations	Boolean	Specify this in order to use qc instead of qt in the appropriate correlations
Reference Elevation	Double
Ic Drained Threshold Zone	Single	Used for determining drained behavior when using Ic - anything less than this value is drained, anything greater than this value is undrained
Schneider SBT – Trans Soils Drained	Boolean

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID		Boring Number identifier for the boring log. Boring Number must be unique within a Boring Job Number and unique within a gINT database
Total Depth (ft)		Mandatory field in gINT;
Boring Type		Boring Type designation (U= Undisturbed, G = General Type, I = In Situ)
Ground Surface Elevation (ft)		Ground Elevation for the boring log
Location		Water Table comment.
Source of Location Coordinate Data
Angle from Horizontal (deg)
Bearing
Station (ft or m)		Station description for location along a baseline.
Offset (ft or m)		Offset description for location along a baseline.
Northing (ft) and Easting (ft)		Y and X coordinates in feet in the projected coordinate system defined for the gINT database (as defined in its Project table).
Latitude (Deg) and Longitude (Deg)		Longitude and Latitude location for the boring log, recorded as decimal degrees.
Drilling Method
Date Drilled
Date Completed		Finish Date of boring log data acquisition.
Date Analyzed
Date Checked
Version

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Borehole ID Index Field.
ItemKey	Text	Reading Event Index Field. Description of the timing event during which the Water Levels reading was taken.
Date/Time	Date/Time	Index Field. Actual time of the Water Levels reading.
Hours After	Double	Index Field.
Water Depth	Double	Depth Below Monitoring Point (ft or m) Depth of the water table in the borehole.
Monitoring Point Stickup	Single	Positive value for above ground and negative value for below ground.
Notes	Text
Casing Depth	Single	(ft or m)
Hole Depth	Single	(ft or m)
Bore Hole Collapsed	Boolean

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	Depth Top Index Field. Top depth for a sample within a boring log.
Length	Single	Length of a sample within a boring log. (ft or m)
Recovery	Single	Report calculates %. (ft or m)
Box or Sample No	Text
Sample Type	Text	Sample type is optional for a gINT Sample record.
Blows 1^st	Integer	Integers only. Refusal intervals are handled by the report. Text entries such as WOH and WOR should be recorded as 0.
Blows 2^nd	Integer	Integers only. Refusal intervals are handled by the report. Text entries such as WOH and WOR should be recorded as 0.
Blows 3^rd	Integer	Integers only. Refusal intervals are handled by the report. Text entries such as WOH and WOR should be recorded as 0.
Blows 4^th	Integer	Integers only. Refusal intervals are handled by the report. Text entries such as WOH and WOR should be recorded as 0.
N	Text	SPT N Value Blow count for a sample. Overrides the N Value calculated by the reported using the Blows 1^st, 2^nd, and 3^rd values.
N60	Text
N160	Single
Hammer Energy	Single
Sample Time	Integer	(seconds)
Mud Weight 1	Single	(lbs/gal)
Mud Weight 2	Text	(lbs/ft3)
Inside Diameter	Single	(in or mm)
Outside Diameter	Single	(in or mm)
Type of Material	Text
Type of Coating or Liner	Text
Container	Text
Notes	Memo	Data entered here is for documentation purposes only. It is not printed on any report.

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

PointID	Text	Index Field.
Depth	Double	Index Field. Top depth for a lithology record.
Bottom	Double	(ft) Bottom depth for the lithology record.
Graphic	Text	Standard graphic symbol chosen to represent the MVN Soil Codes.
MVN Soil Codes	Text	MVN soil classification. Only USCS single classifications are supported (no USCS dual classifications). Lookup is called “MVN Soil Codes” and is located in Data Design:Lookup Lists.
USCS	Text	Lookup list is called “USCS Codes MVN” and is located in Data Design:Library Data.
Line Type	Text	Default is Solid.

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text
Depth	Double	Top depth for a lab soil description record. This Depth must match a depth value in the Lab Lithology table. There is a one to one relationship between a MVN Lab Soil Descriptions record and a Lab Lithology record.
MVN SOIL CODES	Text	MVN soil classification. Only USCS single classifications are supported (no USCS dual classifications). MVN SOIL CODES in the MVN Lab Soil Descriptions table should match the MVN Soil Codes value for the same lithology zone in the Lab Lithology table.
USCS	Text	Lookup is called "USCS Codes MVN" and is located in Data Design:Library Data.
Depositional Environments MVN	Text
Consistency MVN	Text	Soil consistency - populated from a domain of values supported in the CEMVN data model.
Primary Major Constituent MVN	Text	Major soil modification – populated from a domain of values supported in the CEMVN data model.
Color 1 MVN	Text	First soil color – populated from a domain of values supported in the CEMVN data model.
Color Joiner 1 MVN	Text
Color 2 MVN	Text	Second soil color – populated from a domain of values supported in the CEMVN data model
Color Joiner 2 MVN	Text
Color 3 MVN	Text	Third soil color – populated from a domain of values supported in the CEMVN data model.
Minor Constituent 1 MVN	Text	First minor soil modification - populated from a domain of values supported in the CEMVN data model.
Minor Constituent 2 MVN	Text	Second minor soil modification - populated from a domain of values supported in the CEMVN data model.
Minor Constituent 3 MVN	Text	Third minor soil modification - populated from a domain of values supported in the CEMVN data model.
Minor Constituent 4 MVN	Text	Fourth minor soil modification - populated from a domain of values supported in the CEMVN data model.

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	(ft or m) Index Field Depth is the depth for a lab test record which was run for a boring log.
Depth Bottom	Text	(ft or m)
Number	Text	Sample Number Used only on the grain size form (ACE 2087)
USCS	Text	Lookup list is called “USCS Codes” and is located in Data Design:Library Data.
Consistency	Text	Consistency Lab
Specific_Gravity	Single	Not necessarily the same as Fine Specific Gravity result. Needed in Reports to determine void ratios and degrees of saturation. System Field.
Description	Text	Overrides the automatic classification
Other Tests	Text
Unconf Compr	Text
Torvane	Double	(psf)
Pocket Penetrometer	Double	(tsf)

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	Depth for the WC Density record must match a depth record in the Lab Specimen table and should be the average depth of a sample for the boring log. (ft or m)
WC_Wt_Wed	Single	Water content Wet Wt+Tare Water Content Determination: Weght Wet Soil + Tare, any consistent units. System Field.
WC_Wt_Dry	Single	Water Content Dry Wt+Tare Water Content Determination: Weight Dry Soil + Tare, any consistent units. System Field.
WC_Wt_Tare	Single	Water Content Wt Tare Water Content Determination: Weight Tare, any consistent units. System Field.
Water_Content	Single	Water content of a soil sample. Will be calculated if the data exists.
Diameter	Single	(mm) System Field.
Height	Single	(mm) System Field.
Wt_Spec_Tare	Single	Wt Specimen + Tare Weight of total specimen + tare (g) System Field.
Wt_Tare	Single	(g) System Field.
Wet_Density	Single	Wed Density (or Bulk Density) of the soil sample. In units determined by the PROJECT.Water_Unit_Wt field. Will be calculated if the data exists. (pcf) System Field.
Dry_Density	System	In units determined by the PROJECT.Water_Unit_Wt field. Will be calculated if the data exists. (pcf) System Field.
In Tube Density	Boolean	Check if yes.

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	(ft or m) Depth for the soil sieve analysis record must match a depth record in the Lab Specimen table and should be the average depth of a sample for the boring log. Index Field.
Wt_Total_Spec	Single	System Field.
Wt_Passing_Split_Sieve	Single	System Field.
Wt_Fines_Tested	Single	System Field.
Size_Split_Sieve	Single	(mm) System Field.
Weighing_Method	Text	Default Value: C System Field.
Wt_Sieving_Tare_Coarse	Single	System Field.
Wt_Sieving_Tare_Fine	Single	System Field.
WC_Wt_Wet_Coarse	Single	Water Content Coarse Wet Wt+Tare Water Content Determination: Weight Wet Soil + Tare, any consistent units. System Field.
WC_Wt_Dry_Coarse	Single	Water Content Coarse Dry Wt+Tare Water Content Detrmintation: Weight Dry Soil + Tare, any consistent units. System Field.
WC_Wt_Tare_Coarse	Single	Water Content Coarse Wt Tare Water Content Determination: Weight Tare, any consistent units. System Field.
Water_Content_Coarse	Single	(%) Will be calculated if the data exists. System Field.
WC_Wt_Wet_Fine	Single	Water Content Fine Wet Wt+Tare Water Content Determination: Weight Wet Soil + Tare, any consistent units. System Field.
WC_Wt_Dry_Fine	Single	Water Content Fine Dry Wt+Tare Water Content Determination: Weight Dry Soil + Tare, any consistent units. System Field.
WC_Wt_Tare_Fine	Single	Water Content Fine Wt+Tare Water Content Determination: Weight Tare, any consistent units. System Field.
Water_Content_Fine	Single	(%) Will be calculated if the data exists. System Field.
Coarse_Sieved_Wet	Boolean	Only used with split specimens. Unsplit specimens, and the fine portion of split specimens, are always assumed to be sieved dry. System Field.
D10_Size ???	??	??

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	(ft or m) Depth for the Atterberg test record must match a depth record in the Lab Specimen table and should be the average depth for a sample in the boring log. Index Field.
Liquid_Limit	Single	(%) Liquid limit result from the Atterberg test for a soil sample. Will be calculated from the readings data, if the data exist. System Field.
Plastic_Limit	Single	(%) Plastic limit result from the Atterberg test for a soil sample. Will be calculated from the readings data, if the data exist. System Field.
Organic	Boolean	Affects ASTM classification. System Field.
USCS Cal	Text
USCS	Text

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	(ft or m) Depth for the UCT test record must match a depth record in the Lab Specimen table.
Sample Number	Text	Default Value: A
Strength	Single	Compressive Strength (psf) Compressive Strength = 2 * cohesion. System Field.
Cohesion	Double	(psf) UCT Strength of a soil sample.
Strain_At_Failure	Single	(%) System Field.
Load_Ring	Text	Default Value: Load Cell. System Field.
Slope_Initial	Single	Van be input manually or program will read it from the LOAD RINGS table using the Load_Ring field. New rings can be input in Data Design:Library Data. System Field.
Slope_Break	Single	Can be input manually or program will read it from the LOAD RINGS table using the Load_Ring field. New rings can be input in Data Design:Library Data. System Field.
Slope_2ndary	Single	Can be input manually or program will read it from the LOAD RINGS table using the Load_Ring field. New rings can be input in Data Design:Library Data. System Field.
Deflection_Units	Text	Default Value: I. System Field
Stress_Area	Text	Default Value: Ft. Area units taken as the square of that selected, i.e., square feet, square meters, etc. System Field.
Seating_Correction	Single	(%) This shifts the curve to the left to account for initial seating deflections. System Field.
Diameter	Single	(mm or in) System Field.
Height	Single	(mm or in) System Field.
Wet_Density	Single	(pcf) In units determined by the PROJECT.Water_Unit_Wt field. Will be calculated if the data exists. System Field.
Dry_Density	Single	(pcf) In units determined by the PROJECT.Water_Unit_Wt field. Will be calculated if the data exists. System Field.
Water_Content	Single	(%) Water content percentage as tested for the UCT test sample. Will be calculated if the data exists. System Field.
Wt_Spec_Tare	Single	Wt Specimen + Tare (g) Weight of total specimen + tare. System Field.
Wt_Tare	Single	(g) System Field.
WC_Wt_Wet	Single	Water Content Wet Wt+Tare Water Content Determination: Weight Wet + Tare, any consistent units. System Field.
WC_Wt_Dry	Single	Water Content Dry Wt+Tare Water Content Determination: Weight Dry + Tare, any consistent units. System Field.
WC_Wt_Tare	Single	Water Content Wt Tare Water Content Determination: Weight Tare, any consistent units. System Field.
Rate of Leading	Single
Deformation Dial Constant	Single

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	(ft or m) Depth for the Organic test record must match a depth record in the Lab Specimen table. Index Field.
Organic Sample Wt+Tare	Single	Organic Determination: Weight Soil + Tare, any consistent units
Sample Wt+Tare	Single	Organic Content Determination: Weight Processed Soil + Tare, any consistent units
Tare Wt	Single	Weight of Tare and consistent unit.
Organic Content	Single	(%) Organic Content – Calculated. Organic content of the soil sample.
Test Method	Text

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Index Field.
Depth	Double	(ft or m) Depth for the Triaxial test record must match a depth record in the Lab Specimen table. Must be in decimal format. Two decimals displayed.
Sample Number	Text	Sample Type uniquely designates one of several triaxial tests taken at the same depth. Valid values include A, B, C, D, and Design Value. When multiple samples are tested as part of the triaxial test, the test results for each individual sample can be reported as Sample Number A – D. If the individual sample results are summarized using engineering judgment to produce a final summary set of results for the triaxial test, then that summary result should be recorded as Sample Number = Design Value. Index Field.
Test Type	Text	Test type for the trixial test. Valid values include Q, q, R, and S, where: Q = 3 or 4 point unconsolidated undrained triaxial shear test q = 1 point unconsolidated undrained triaxial shear test R = consolidated undrained triaxial shear test S = consolidated drained direct shear test
Test_Date	Date/Time
Sample Type	Text	Default Value: Cohesive
Strain_Rate	Single
Diameter	Single	(mm or in)
Height	Single	(mm or in)
Water_Content	Single	(%) Water content for the triaxial test sample. Will be calculated if the data exists.
WC_Wt_Wet	Single	Water Content Wet Wt+Tare Water Content Determination: Weight Wet + Tare, any consistent units.
WC_Wt_Dry	Single	Water Content Dry Wt+Tare Water Content Determination: Weight Dry + Tare, any consistent units.
WC_Wt_Tare	Single	Water Content Tare Water Content Determination: Weight Tare, any consistent units.
Strength	Single	Shear Strength (psf)
Cohesion	Single	Total Stress Cohesion (psf)
Effective Stress Cohesion	Single	(psi)
Failure_Criterion	Text
Chamber Pressure	Single	(psi)
Specific_Gravity	Single
Dry_Density	Single	(pcf) Dry density for the triaxial test sample. In units determined by the PROJECT.Water_Unit_Wt field. Will be calculated if the data exists.
Saturation	Single	(%) Saturation percentage for the triaxial test sample.
Void_Ratio	Single
Friction Angle	Single	Total Stress Friction Angle (deg) Friction angle for the triaxial test sample.
Strain_Rate_Percent	Single	(%)
Strain_Failure	Single	Deviator Stress at Defined Failure (psi)
Max_Dev_Stress	Single	(psi)
Ult_Dev_Stress	Single
Rapture_Envelope_At_Failure	Single
Stress_Area	Text	Area units taken as the square of that selected, i.e., square feet, square meters, etc.
Load_Ring	Text	Default Value: Load Cell
Seating_Correction	Single	(%) This shifts the curve to the left to account for initial seating deflections.
Slope_Initial	Single	Can be input manually or program will read it from the LOAD RIGNS table using the Load_Rings field. New rings can be input in Data Design:Library Data.
Slope_Break	Single	Can be input manually or program will read it from the LOAD RIGNS table using the Load_Rings field. New rings can be input in Data Design:Library Data.
Slope_2ndary	Single	Can be input manually or program will read it from the LOAD RIGNS table using the Load_Rings field. New rings can be input in Data Design:Library Data.
Deflection_Units	Text	Default Value: I
Wet_Density	Single	(pcf) In units determined by the PROJECT.Water_Unit_Wt field. Will be calculated if the data exists.
Wt_Spec_Tare	Single	Wt Specimen + Tare (g) Weight of total specimen + tare.
Wt_Tare	Single	(g)
Back_Pressure	Single
Diameter_After	Single
Height_After	Single
Water_Content_After	Single
Dry_Density_After	Single
Void_Ratio_After	Single
Max_Pore_Pressure	Single
Effective Stress Angle Internal	Single	(deg)
MVN SOIL CODES	Text	Soil classification that accompanies a triaxial test result. Lookup is called “MVN Soil Codes” and is located in Data Design:Lookup Lists.
Primary Major Constituent MVN	Text	Major soil modifier that accompanies a triaxial test result.

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	Depth for the Consolidation test record must match a depth record in the Lab Specimen table. Index Field.
Deflection_Units	Text	Default Value: I. System Field.
Diameter	Single	(mm) System Field.
Height	Single	(mm) System Field.
Wet_Density	Single	(pcf) In units determined by the PROJECT.Water_Unit_Wt field. Will be calculated if the data exists. System Field.
Water_Content	Single	(%) Water content for the consolidation test sample. Will be calculated if the data exists. System Field.
Dry_Density	Single	(pcf) Dry density for the consolidation test sample. In units determined by the PROJECT.Water_Unit_Wt field. Will be calculated if the data exists. System Field.
Wt_Spec_Tare	Single	Wt Specimen + Tare (g) Wight of total specimen + tare. System Field.
Wt_Tare	Single	(g) System Field.
WC_Wt_Wet	Single	Water Content Wet Wt+Tare Water Content Determination: Weight Wet Soil + Tare, any consistent units. System Field.
WC_Wt_Dry	Single	Water Content Dry Wt+Tare Water Content Determination: Weight Dry Soil + Tare, any consistent units. System Field.
WC_Wt_Tare	Single	Water Content Tare Water Content Determination: Weight Tare, any consistent units. System Field.
Water_Content_After	Single	(%) After Test. System Field.
Dry_Density_After	Single	(pcf) After Test. System Field.
Saturation	Single	Saturation After (%) Saturation percentage for the consolidation test sample.
Friction Angle	Single	Friction angle for the triaxial test sample.
Preconsolidation Pressure	Single	(psf)
Normal Void Ratio	Single	Initial void Ratio Initial Void Ration of the consolidation test sample.
Test_Date	Date/Time
Diameter_After	Single
Height_After	Single
MVN SOIL CODES	Text	Soil classification that accompanies a triaxial test result. Looup is called “MVN Soil Codes” and is located in Data Design:Lookup Lists.
Primary Major Constituent MVN	Text	Major soil modifier that accompanies a triaxial test result.

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Boring Number Index Field.
Depth	Double	Index Field.
Reading	Double	Arbitrary counter. System Field.
Stress	Single	Stress (Pressure) (psf) The Consol Readings table in gINT will store the pressure applied and the void ratio reached for each pressure increment from a consolidation test. A Consolidation test record should have multiple Consol Readings records. The pressure values should increase, and then also include the rebound pressure at the end of the test series. System Field.
Cummulative_Deflection	Single	In units specified in the parent record. System Field.
Strain	Single	(%)
Void_Ratio	Single	(%) Void Ratio for the consolidation test sample at a specific pressure reading.
T50	Single	(min) Used to calculate Cv90. System Field.
T90	Single	(min) Used to calculate Cv90. System Field.
Cv50	Single	In units specified by the Coeff of Consol Factor field in the PROJECT table. System Field.
Cv90	Single	In units specified by the Coeff of Consol Factor field in the PROJECT table. System Field.

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Index Field.
Probe ID	Text
Software	Text
Assumed Water Depth	Double	(ft)
Assumed Total Density	Single	(pcf)
Assumed Total Density pcf	Double	(pcf)
Assumed Water Depth ft	Double	(ft)
File Name	Text
Shear Wave Source Offset	Double
Shear Wave Geophone Offset	Double
SBT FR Normalized MAI	Integer	SBT FR Normalized Moving Average Interval This field is used to set the moving average interval on the CPT Reports once the user has decided upon the moving average interval by using the Add-Ins menu for calculating the moving average.
SBT BQ Normalized MAI	Integer	SBT Bq Normalized Moving Average Interval This field is used to set the moving average interval on the CPT Reports once the user has decided upon the moving average interval by using the Add-Ins menu for calculating the moving average.
SBT FR MAI	Integer	SBT FR Moving Average Interval
SBT BQ MAI	Integer	SBT BQ Moving Average Interval
SBT FR Normalized MAI 1	Integer	SBT FR Normalized Moving Average Interval 1 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT FR Normalized MAI 2	Integer	SBT FR Normalized Moving Average Interval 2 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT FR Normalized MAI 3	Integer	SBT FR Normalized Moving Average Interval 3 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT FR MAI 1	Integer	SBT FR Moving Average Interval 1 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT FR MAI 2	Integer	SBT FR Moving Average Interval 2 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT FR MAI 3	Integer	SBT FR Moving Average Interval 3 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Bq Normalized MAI 1	Integer	SBT BQ Normalized Moving Average Interval 1 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Bq Normalized MAI 2	Integer	SBT BQ Normalized Moving Average Interval 2 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Bq Normalized MAI 3	Integer	SBT BQ Normalized Moving Average Interval 3 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Bq MAI 1	Integer	SBT BQ Moving Average Interval 1 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Bq MAI 2	Integer	SBT BQ Moving Average Interval 2 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Bq MAI 3	Integer	SBT BQ Moving Average Interval 3 Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Net Area Ratio	Single

Information about this table. Put a description here and make it kind of long. It looks better when there is more than one line of text in this area because it seperates things out nicely.

Field	Data Type	Description
PointID	Text	Index Field.
Depth	Double	(ft) Index Field.
Imported Depth	Double	(ft) Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
fs	Double	(tsf)
qc	Double	(tsf)
qt	Double	(tsf)
u2	Double	(tsf)
fs User Units	Double	(tsf) fs
qc User Units	Double	(tsf) qc
qt User Units	Double	(tsf) qt
u2 User Units	Double	(tsf) u2
u0	Double	(tsf) Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Total Stress	Double	(tsf) Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Effective Stress	Double	(tsf) Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
FR	Double	(%) Friction Ratio Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
FR Normalized	Double	(%) Friction Ratio Normalized Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Bq	Double	Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Qt Normalized	Double	Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Bq Normalized	Integer	Normalized Soil Behavior Type Bq Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Fr Normalized	Integer	Normalized Soil Behavior Type Bq Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Bq	Text	Soil Behavior Type Bq Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
SBT Fr	Text	Soil Behavior Type Fr Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Estimated Total Density	Double	(pcf)This value is estimated based on the Soil Behavior Type Zone specified in the project table. It uses the values stored in the CPT Total Density table to determine what this value should be.
Ic	Double	Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
ED	Double	(tsf) Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
ID	Double	Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
KD	Double	Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
OCR (1)	Double	Mayne (1995) - Reference #8. Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
OCR (2)	Double	Chen & Mayne (1996) - Reference #9.Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
OCR (3)	Double	Chen & Mayne (1996) - Reference #9. Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Ko (1)	Double	Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Ko (2)	Double	Chen & Mayne (1996) - Reference #9. Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Equivalent N60	Double	Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Equivalent N160	Double	Equivalent N Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Phi (1)	Single	Phi’ (1) Kulhawy & Mayne (1990) - Reference #1. Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Phi (2)	Single	Phi' (2) Robertson & Campanella (1983) - Reference #13. Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Phi (3)	Single	Phi' (3) Masood & Mitchell (1993) - Reference #14. Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Su (1)	Single	(tsf) Mayne & Holtz (1988) - Reference #10. Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Su (2)	Single	(tsf) Aas, Lacasse, Lunne, & Hoeg (1986) - Reference #11. Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Su (3)	Double	(tsf) Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Su (4)	Double	(tsf) Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.
Su (5)	Double	(tsf) Calculated fields are Read-only in Input. Data can only be inserted by import or a gINT Rules procedure.

gINT Documents

gINT 2012 Documentation