Pipestem_DM_Attachments_04May22_v1.pdf

The SQL EDB- data dictionary/schema

01 31 00 Schema - Data Dictionary

INDEX NAME

1 Index 2 CONSTRUCTION_INFO Table containing general information about the construction project.

3 FEATURE_CONSTRUCTION

The type of feature(s) that is being constructed. E.g. Terminal Chute Structure, Labyrinth Weir Crest Structure, Stilling Basin, etc..

4 MATERIALS_HAUL_PLACE Table containing information about excavation, haul, placement 5 FIELD_SURVEY Table containing general information about field surveys

6 SURVEY_FEATURE

Instrument that denotes a known elevation or location where a survey reading is taken

7 MONITORING_LOCATION

The location where some objective or subjective aspect is quantitatively or qualitatively monitored, typically in a continuous or nearly continuous (and possibly automated) manner, often with physical equipment fixed in place.

8 PIEZOMETER

Report Table for piezometer installation -- temp PZs installed by Contractor

9 INCLINOMETER Report Table for inclinometer installation 10 WELLPOINT Standard information regaurding the wellpoints.

11 WELLPOINT_PERFORMANCE Report Table for well point pump performance daily

12 DEWATERING

Report Table for water levels of various areas including pool, tailwater and features, updated daily

13 BORINGS Verification and production grout borings.

14 FLUME

15 CONCRETE_PINS

16 REB_SETTLE_GAUGE Rebound or Settlement Gauge 17 SOIL_SAMPLE Sample information for soil testing.

18 SC_BATCH_TICKETS

All information reported on the batch tickets generated by the concrete/ soil cement batch plant.

19 SC_MIX_DESIGN The final mix designs for soil cement used on the project

20 AGG_SC_JOIN

A join table for the AGGREGATE_SAMPLE and CONC_BATCH_TICKETS tables.

21 SC_BM_BATCH_TICKETS

All information reported on the batch tickets generated by the concrete/ soil cement batch plant.

22 SC_BM_MIX_DESIGN The final mix designs for soil cement used on the project

23 AGG_SCBM_JOIN

A join table for the AGGREGATE_SAMPLE and CONC_BATCH_TICKETS tables.

24 RCC_BATCH_TICKETS

All information reported on the batch tickets generated by the concrete/ soil cement batch plant.

25 RCC_MIX_DESIGN The final mix designs for each type of concrete used on the project.

26 AGG_RCC_JOIN

A join table for the AGGREGATE_SAMPLE and CONC_BATCH_TICKETS tables.

27 RCC_BM_BATCH_TICKETS

All information reported on the batch tickets generated by the concrete/ soil cement batch plant.

28 RCC_BM_MIX_DESIGN The final mix designs for each type of concrete used on the project.

29 AGG_RCCBM_JOIN

A join table for the AGGREGATE_SAMPLE and CONC_BATCH_TICKETS tables.

30 GEVR_RCC_BATCH_TICKETS

All information reported on the batch tickets generated by the concrete/ soil cement batch plant.

31 GEVR_RCC_MIX_DESIGN The final mix designs for soil cement used on the project

32 AGG_GEVR_JOIN

A join table for the AGGREGATE_SAMPLE and GEVR_RCC_BATCH_TICKETS tables.

33 CIP_CONC_BATCH_TICKETS

All information reported on the batch tickets generated by the concrete batch plant.

34 CIP_CONC_MIX_DESIGN The final mix designs for each type of concrete used on the project.

35 AGG_CIP_JOIN

A join table for the AGGREGATE_SAMPLE and CIP_CONC_BATCH_TICKETS tables.

36 AGGREGATE_SAMPLE Sample information for aggregate testing.

37 C29_AGG_BULK_DEN

Report table for ASTM C29. Bulk Density Determination of Voids in Aggregate

38 C39_COMP_STR_CYLINDER

Report table for ASTM C39: Standard test method for compressive strength of cylindrical concrete specimens.

39 C39_SPECIMEN Specimen specific information for the C39 test.

40 C40_ORG_IMP_FINE_AGG

Report table for ASTM C40: Standard test method for organic impurities in fine aggregates for concrete.

41 C42_DRILL_CORE_SAW_BEAMS

Report table for ASTM C42: Standard test method for obtaining and testing drilled cores and sawed beams of concrete.

42 C70_SURF_MOISTURE_FINE_AGG

Report table for ASTM C70: Standard test method for surface moisture in fine aggregate.

43 C78_FLEX_STR_CONC

Report table for ASTM C78: Standard test method for flexural strength of concrete (using simple beam with third-point loading).

44 C87_ORG_IMP_FIN_AGG_STR_MRT

Report table for ASTM C87: Standard test method for effect of organic impurities in fine aggregate on strength of mortar.

45 C87_SPECIMENS Table C87 specimens.

46 C88_SND_AGG_SOD_MAG_SULFATE

Report table for ASTM C88: Standard test method for soundness of aggregates by use of sodium sulfate or magnesium sulfate.

47 C109_COMP_STR_CUBE_SET

Information on cube sets for ASTM C109: Standard test method for compressive strength of hydraulic cement mortars (using 2-in. or [50 mm] cube specimens.

48 C109_SPECIMENS Specimen specific information for the C109 test.

49 C117_FINER_200_WASH

Report table for ASTM C117: Standard test method for materials finer than 75-µm (No. 200) sieve in mineral aggregates by washing.

50 C123_LW_PART_AGG

Report table for ASTM C123: Standard test method for lightweight particles in aggregate.

51 C127_SPEC_GRAV_COARSE_AGG

Report table for ASTM C127: Standard test method for relative density (specific gravity) and absorption of coarse aggregate.

52 C128_SPEC_GRAV_FINE_AGG

Report table for ASTM C127: Standard test method for relative density (specific gravity) and absorption of fine aggregate.

53 C131_SM_CRSAGG_ABIMP_LOSS

Report table for ASTM C131: Standard Test Method for Resistance to Degradation of Small-Size Coarse Aggregate by Abrasion and Impact in the Los Angeles Machine

54 C136_SIEVE_ANALYSIS

Report table for ASTM C136: Standard test method for sieve analysis of fine or coarse aggregates.

55 C138_DEN_YIELD_AC_CONCRETE

Report table for ASTM C138: Standard test method for density (unit weight), yield, and air content (gravimetric) of concrete.

56 C142_CLAY_FRIABLE_AGG

Report table for ASTM C142: Standard test method for clay lumps and friable particles in aggregates.

57 C143_SLUMP_HCC

Report table for ASTM C143: Standard test method for slump and hydraulic-cement concrete.

58 C173_AIR_CONT_FRESHCON_VOL

Report table for ASTM C173: Standard Test Method for Air Content of Freshly Mixed Concrete by the Volumtric Method

59 C231_AIR_CONT_FRESHCON_PRESSURE

Report table for ASTM C231: Standard test method for air content of freshly mixed concrete by the pressure method.

60 C295_PETRO_CONC_AGG Report table for ASTM C295:

61 C295_CONSTITUENT Report table for ASTM C295:

62 C403_SET_TIME_CONC_PENE_RESIST

Report table for ASTM C403: Standard test method for time of setting of concrete mixtures by penetration resistence.

63 C535_LG_CRSAGG_ABIMP_LOSS

Report table for ASTM C535: Standard Test Method for Resistance to Degradation of Large-Size Coarse Aggregate by Abrasion and Impact in the Los Angeles Machine

64 C566_TOTEVAP_MOISTURE_AGG_DRYIN

Report table for ASTM C566: Standard test method for total evaporable moisture content of aggregate by drying.

65 C803_PENT_RES_HARD_CONC

Report table for ASTM C803: Standard test method for Penetration Resistance of Hardened Concrete

66 C803_PROBES_PINS

Report table for ASTM C803: Standard test method for Penetration Resistance of Hardened Concrete

67 C873_COMP_STR_MOLDS

Report table for ASTM C873: Standard test method for compressive strength of concrete cylinders cast in place in cylindrical molds.

68 C873_SPECIMENS Specimen specific information for the C873 test.

69 C900_PULL_RES_HARD_CONC

Report table for ASTM C900: Standard test method for Pullout Strength of Hardened Concrete

70 C900Tests Report table for ASTM C900: Standard test method for Pullout Strength of Hardened Concrete

71 C1040_INPLACE_NUC_DEN_CONC

Table to record information from in-place density of concrete by nuclear methods

72 C1064_TEMP_FRESH_HC_CONC

Report table for ASTM C1064: Standard test method for temperature of freshly mixed hydraulic-cement concrete.

73 C1074_RCC_IPS_MATURITY_MTH

Report table for ASTM C1074: Standard practice for Estimating Concrete Strength by the Maturity Method.

74 C1074_TEMP_MEAS_EST_IPS Temperature Sensors secured or embedded into fresh concrete

75 C1074_MATURE_REL

Report table for ASTM C1074: Standard practice for Estimating Concrete Strength by the Maturity Method

76 C1074_CYL_SPECIMEN

Specimen specific information for determination of the C1074 maturity relationship.

77 C1170_CONCRETE_VEBE Vebe test of RCC concrete

78 C1260_ALKALI_REACT_AGG

Report table for ASTM C1064: Standard test method for potential alkali reactivity of aggregates (mortar-bar method).

79 C1260_SPECIMENS The table C1260 specimens.

80 C1293_CONC_LGN_CHNG_ALK_SILICA

Report table for ASTM C1293. Standard Test Method for Determination of Length Change of Concrete Due to Alkali-Silica Reaction.

Determination of the susceptibility of an aggregate or aggregate with pozzolan or slag for participation in expansive alkali-silica reaction

81 C1293_SPECIMENS The table C1293 specimens.

82 C1567_ALK_SILICA_CEMT_MAT_AGG

Report table for ASTM C1567: Standard Test Method for Determining the Potential Alkali-Silica Reactivity of Combinations of Cementitious Materials and Aggregate (Accelerated Mortar-Bar Method)

83 C1567_SPECIMENS The table C1567 specimens.

84 COE_CRD_C_55_UNIFORMITY Summary of concrete batch results from mixer uniformity tests.

85 COE_CRD_C_55_SAMPLES Specimen specific information for the COE CRD-C 55 test.

86 COE_CRD_C_104_FINE_MOD Method of calculation of the fineness modulus of aggregate.

87 COE_CRD_C_521_VIBRATOR_CALIB Concrete plant vibrator equipment testing and calibration 88 PROCTOR_COMPACTION_TESTS Report table for either ASTM D698 or ASTM D1557.

89 D422_SOIL_SIEVE

Report table for ASTM D422: Standard test method for particle size analysis of soils.

90 D558_SOIL_CMT_MOIST_DEN

The determination between water content and the density of soil-cment mixtures when compacted before cement hydration

91 D1556_IPD_SAND_CONE

Report table for ASTM D1556: Standard Test Method for Density and Unit Weight of Soil in Place by Sand-Cone Method.

92 D1663_COMP_STR_SC_CYL

Report table for ASTM C1633: Standard test method for compressive strength of molded soil-cement cylinders.

93 D1663_SPECIMENS Specimen specific information for the C1633 test.

94 D2216_SOIL_WATER_CONTENT

These test methods cover the laboratory determination of the water (moisture) content by mass of soil, rock, and similar material where the reduction in mass by drying is due to loss of water

95 D2419_SE_AGG

Report table for ASTM D2419. Table to report the sand equivalent value of soils and fine aggregate

96 D2974_ORG_SOILS_WATER_ASH_OM Organic content, Ash content, and Water content of soil samples

97 D4253_SOILS_MAX_DEN_VIB_TBLE

These test methods cover the determination of the maximum-index dry density/unit weight of cohesionless, free-draining soils using the vertically vibrating table

98 D4254_MIN_REL_DENSITY

These test methods cover the determination of the minimum-index dry density/unit weight of cohesionless, free-draining soils.

99 D4318_ATTERBERG_LIMITS

Report table for ASTM D4318: Standard Test Methods for Liquid Limit, Plastic Limit, and Plasticity Index of Soils (Atterberg Limits)

100 D4791_FLAT_ELONG_COARSE_AGG

Report table for ASTM D4791: Standard test method for flat particles, elongated particles, or flat and elongated particles in coarse aggregate.

101 D5821_PCT_FRAC_CAGG

Report table for ASTM C131: Standard Test Method for Resistance to Degradation of Small-Size Coarse Aggregate by Abrasion and Impact in the Los Angeles Machine

102 D6938_SOIL_DENSITY_NUCLEAR

This test method describes the procedures for measuring in-place density and moisture of soil and soil-aggregate by use of nucelar equipment

103 RCC_STEP_LIFT Details on the RCC steps planned and as-built elevations.

104 LIFT_BATCH_PLACEMENT Details on the placement of each concrete batch within the RCC Steps 105 PHOTO_VID Feature class containing links to pertinent photographs.

106 TEST_METHOD The base metadata for the test methods employed for the project.

107 UOM

Informational table listing the units of measurement for relavent table columns.

108 WEATHER The daily weather conditions on site.

INDEX OF DOMAINS

Table Name Table Description d_AGG_TYPE The types of aggregate, as specified by ASTM C1260.

d_C29_METHOD d_C40_STD_COLOR The color comparrison of the solution, as specified in ASTM C40.

d_COE_C55_SAMP_ZONE* The sample locations within the mixer, as specified in COE CRD-C55 d_COMP_RAMMER The color comparrison of the solution, as specified in ASTM C40.

d_COMP_RAMMER The color shade for USCS.

d_CONSTRUCTION_MATERIAL_TYPE* Materials that may be used in construction.

d_D4253_METHOD d_D4254_METHOD d_DISTRICT* The USACE districts.

d_DIVISION* The USACE divisions.

d_FC_TYPE* Types of construction features.

d_FEATURE_LOC d_C39_FRACT_TYPE* The types of fractures, as specified in ASTM C39.

d_HEAVY_LIQUID d_HYD_CEM d_MAT_TYPE d_MONIT_ASP d_MONIT_INST d_PART_HARD d_PART_SHAPE d_PORTLAND_TYPES d_PRIM_COLOR d_PROCTOR_METHOD d_PROCTOR_TEST d_SEC_COLOR d_SIEVE_SIZE d_SOIL_SYMBOL d_SPEC_GRAV_BASIS d_STATUS instrument status.

d_STOCKPILE_SIZE The primary stone sizes in the aggregate stockpiles.

d_SUB_FEAT_LOC d_SUB_FEAT_LOC d_SURV_TYPE d_SURV_TYPE d_WEATHER_DELAY_TYPE* The causes for a weather delay.

Definition:

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

contractNumber varchar(50) The contract solicitation number.

projectName varchar (100) The name of the contracted project.

usaceContact varchar(50) The USACE point of contact for the project.

division int d_DIVISION The division in which the construction is taking place.

district int d_DISTRICT The district in which the construction is taking place.

constStartDate date The start date of the construction project.

constEndDate date The end date of the constrcution project.

comments varchar(2000) Any additional comments about the table.

Cardinality

1-1 (DOMAIN)

1-1 (DOMAIN)d_DIVISION CONSTRUCTION_INFO

Relationship Information Primary Table Foreign Table d_DISTRICT CONSTRUCTION_INFO

Table: CONSTRUCTION_INFO Table Information

Table containing general information about the construction project.

Attribute Information

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

description varchar(2000) A description of feature.

fcType int d_FC_TYPE The type of feature being constructed fcName int d_FC_NAME The feature being constructed.

constMaterials int d_CONSTRUCTION_MATERIAL_TYPE The materials used in the construction of the feature.

comments varchar(2000) Any additional comments about the table.

Cardinality 1-M

1-1 (DOMAIN)

1-1 (DOMAIN)

1-1 (DOMAIN)d_CONSTRUCTION_MATERIAL_TYPE FEATURE_CONSTRUCTION

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO FEATURE_CONSTRUCTION

d_FC_TYPE FEATURE_CONSTRUCTION d_FC_NAME FEATURE_CONSTRUCTION

Table: FEATURE_CONSTRUCTION Table Information

The type of feature(s) that is being constructed. E.g. Terminal Chute Structure, Labyrinth Weir Crest Structure, Stilling Basin, etc..

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to CONSTRUCTION_INFO table.

matDescp varchar(100) Location Description of materials excavated and/or placed matMove tinyint Materials excavated or placed. (0=excavated, 1=placed) matType int d_MAT_TYPE Classification of materials matVol int Volume of material (cubic yards) matDate date The date materials are excavated, hauled, placed.

matInfo varchar(100) Material informaiton source, QA estimate, Construction measure comments varchar(2000) Any additional comments about the table.

Cardinality

1-1 (DOMAIN)

Primary Table Foreign Table d_MAT_TYPE MATERIALS_HAUL_PLACE

Relationship Information

Table: MATERIALS_HAUL_PLACE Table Information

Table containing informaiton about excavation, haul, and placement

Model Name Type Domain Required Attribute Definition id int yes Primary Key. A unique, user defined identifier for each record or instance of an entity.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

surveyName varchar(50) yes The common name of the survey.

featureLoc int d_FEAT_LOCATIONS The feature location primary feature.

subFeatLoc int d_SUB_FEAT_LOC The feature location sub feature.

surveyType int d_SURV_TYPE The specific type of survey performed. SURVEYREQ instType int d_SURV_INST The type of instrumentation used at the monitoring location.

elevation numeric(38,5) The elevation in which the survey took place.

dateSurveyed date The date the instrument was installed.

comments varchar(2000) Any additional info about the feature.

link varchar(2000) A link to documentation.

comments varchar(2000) Any comments about the work for the record dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

1-1 (DOMAIN)

1-1 (DOMAIN)

1-1 (DOMAIN)

1-1 (DOMAIN)

Primary Table Foreign Table

Table: FIELD_SURVEY

FEATURE CLASS INFORMATION

Table containing general information about field surveys Attribute Information

Relationship Information

CONSTRUCTION_INFO FIELD_SURVEY

d_FEAT_LOCATIONS FIELD_SURVEY

FIELD_SURVEY

FIELD_SURVEY

FIELD_SURVEY

d_SUB_FEAT_LOC d_SURV_TYPE d_INST_TYPE

Model Name Type Domain Required Attribute Definition id int yes Primary Key. A unique, user defined identifier for each record or instance of an entity.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

surveyName varchar(50) yes The common name of the feature. A narrative describing the feature.

featureDescription varchar(2000) A narrative describing the feature.

survMonType int d_SURV_TYPE The type of survey feature.

easting numeric(38,5) The easting of the feature centroid.

northing numeric(38,5) The northing of the feature centroid.

baseElevationFt numeric(38,5) The base elevation of the feature.

instStatus int d_STATUS The status of the instrument.

monitoringFrequency varchar(25) How often the instrument is monitored.

dateInstalled date The date the instrument was installed.

comments varchar(2000) Any additional info about the feature.

link varchar(2000) A link to documentation.

comments varchar(2000) Any comments about the work for the record dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

1-1 (DOMAIN)

1-1 (DOMAIN)

Table: SURVEY_FEATURE Table Information

Instrument that denotes a known elevation or location where a survey reading is taken Attribute Information

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO SURVEY_FEATURE

d_STATUS SURVEY_FEATURE d_SURV_TYPE SURVEY_FEATURE

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

mlId varchar(50) yes The name or id of the monitoring location.

featureDescription varchar(2000) A narrative describing the feature.

monitoredAspect int d_MONIT_ASP The phenomena being monitored or type of monitoring beingperformed.

instType int d_MONIT_INST The type of instrumentation used at the monitoring location.

instSpecType varchar(50) The specfic type of instrumentation selected in the Instrumentation Typefield.

easting number(38,5) The easting of the feature centroid.

northing number(38,5) The northing of the feature centroid.

station varchar(20) The distance along the stationing line in feet.

offset number(38,5) The perpendicular distance from the stationing line in feet.

baseElevationFt number(38,5) The base elevation of the feature.

instStatus int d_STATUS The status of the instrument.

monitoringFrequency varchar(25) How often the instument is monitored.

automatedManual tinyint Is the instrument automated or manual? (Check added) dateInstalled date The date the instrument was installed.

comments varchar(2000) Any additional info about the feature.

link varchar(2000) Used for GIS data hyperlink implementation.

comments varchar(2000) Any comments about the work for the record dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

1-1 (DOMAIN)

1-1 (DOMAIN)

1-1 (DOMAIN)

MONITORING_LOCATION

MONITORING_LOCATION

Table: MONITORING LOCATION Table Information

The location where some objective or subjective aspect is quantitatively or qualitatively monitored, typically in a continuous or nearly continuous (and possibly automated) manner, often with physical equipment fixed in place.

Attribute Information

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO MONITORING_LOCATION

d_STATUS MONITORING_LOCATION d_MONIT_ASP d_INST_TYPE

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to the CONSTUCTION_INFO table.

piezId varchar(50) yes The instrument ID associated with the piezometer installation log and real world instrument piezType varchar(50) The type of piezometer employed.

station varchar(20) The station of the piezometer.

offset numeric(38,5) The offset of the piezometer.

easting numeric(38,5) The easting of the piezometer.

northing numeric(38,5) The northing of the pizeometer.

soilSymbol int d_SOIL_SYMBOL The material classification of formation.

topRiserElev numeric(38,5) The top of riser elevation.

tipElev numeric(38,5) The tip elevation of the of the piezometer.

tipDepth numeric(38,5) The tip depth.

filterElev numeric(38,5) The filter elevation range.

extElevation numeric(38,5) The extreme elevation.

elevationGround numeric(38,5) elevation in decimal feet of the ground surface where the piezometer was installed elevationPZCasingTop numeric(38,5) Top of casing elevation in decimal feet casingStickUp numeric(38,5) stick up of protective casing above ground in decimal feet sealDepth numeric(38,5) depth to the base of the surface seal/protective casing in decimal feet staticWaterLevel numeric(38,5) depth to static water level in decimal feet screenIntTop numeric(38,5) depth to top of screen interval screenIntBot numeric(38,5) depth to bottom of screen interval / top of sand pack pzScreen numeric(38,5) depth to top of screen casingLength numeric(38,5) total length of the blank casing in decimal feet pzScreenBot numeric(38,5) depth to bottom of screen / cap sandPackBase numeric(38,5) depth to base of sand pack / top of bottom hole seal sealDepthBottom numeric(38,5) depth to base of bottom hole seal baseHoleDepth numeric(38,5) depth to base of drill hole in decimal feet protectiveCasing tinyint is there a protective casing no (0), yes (1) concretePad tinyint is there a concrete pad no (0), yes (1) lockingCap tinyint is there a locking cap no (0), yes (1) annularSealType varchar(240) the type of annular seal used annularBackfillType varchar(240) the type of annular backfill used annularBackfillDepthTop numeric(38,5) the top depth of the annular backfill annularBackfillDepthBot numeric(38,5) the bottom depth of the annular backfill pzCasingType varchar(240) type of casing used pzCasingDiam numeric(38,5) diameter of casing in inches screenIntSealType varchar(240) type of screen interval seal used sandPackType varchar(240) type of sand filter pack used sandPackDiam numeric(38,5) diameter of sand filter pack in inchess screenMaterial varchar(240) type of screen material used screenSlotSize numeric(38,5) slot size in inches bottomSealType varchar(240) type of bottom hole seal used backfillType varchar(240) type of backfill material used backfillThickness numeric(38,5) backfill material thickness/depth in the hole in decimal feet installDate date The date installation was completed bottomCap varchar(240) type of bottom cap used bottomCapDiam numeric(38,5) diameter of bottom cap in inches orientationCasing numeric(38,5) orientation of the casing grooves comments varchar(2000) Any comments about the work for the record dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

1-1 (DOMAIN)

Table: PIEZOMETER Table Information

Report Table for piezometer installation -- temp PZs installed by Contractor

Attribute Information d_SOIL_SYMBOL PIEZOMETER

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO PIEZOMETER

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

incID varchar(50) yes The instrument ID associated with the inclinometer installation log and real world instrument incType varchar(50) The type of inclinometer installed including brand and model if automated easting numeric(38,5) The easting coordinate of the feature centroid.

northing numeric(38,5) The northing coordinate of the feature centroid.

station varchar(20) The station location from the site baseline.

offset numeric(38,5) The offset from the site baseline.

elevationGround numeric(38,5) elevation in decimal feet of the ground surface where the inclinometer was installed elevationInclCasing numeric(38,5) Top of inclinometer casing elevation in decimal feet casingStickUp numeric(38,5) stick up of protective casing above ground in decimal feet sealDepth numeric(38,5) depth to the base of the surface seal/protective casing in decimlar feet casingLength numeric(38,5) total length of the inclinometer casing in decimal feet stableGroundDepth numeric(38,5) depth to stable ground level in decimal feet embedDepth numeric(38,5) embedment depth into stable ground in decimal feet baseHoleDepth numeric(38,5) depth to base of drill hole in decimal feet protectiveCasing tinyint is there a protective casing no (0), yes (1) concretePad tinyint is there a concrete pad no (0), yes (1) lockingCap tinyint is there a locking cap no (0), yes (1) sealType varchar(240) type of surface seal annularBackfillType varchar(240) the type of annular backfill used annularBackfillDepthTop numeric(38,5) the top depth of the annular backfill annularBackfillDepthBot numeric(38,5) the bottom depth of the annular backfill installDate date The date installation of the inclinometer was completed inclCasingType varchar(240) type of inclinometer casing used inclCasingDiam numeric(38,5) diameter of inclinometer casing in inches bottomCap varchar(240) type of bottom cap used bottomCapDiam numeric(38,5) diameter of bottom cap in inches orientationCasing numeric(38,5) orientation of the casing grooves comments varchar(2000) Any comments about the work for the record dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

Table: INCLINOMETER Table Information

Report Table for inclinometer installation

Attribute Information

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO INCLINOMETER

Model Name Type Domain Required Attribute Definition id int yes primary key of the table constId int yes Foreign key to the CONSTUCTION_INFO table.

pumpId varchar(50) yes the ID of the pump in the outlet works dewatering system station varchar(20) The station of the wp piezometer.

offset numeric(38,5) The offset of the wp piezometer.

easting numeric(38,5) The easting of the piezometer.

northing numeric(38,5) The northing of the pizeometer.

installDate date The date of wellpoint installation.

screenIntTop numeric(38,5) Depth to top of screen interval screenIntBot numeric(38,5) Depth to bottom of screen interval / top of sand pack casTopElev numeric(38,5) The casing top elevation.

casBotElev numeric(38,5) The casing bottom elevation.

comments varchar(2000) comments about the pump outage or any servicing dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

Table: WELLPOINT Table Information

Standard information regaurding the wellpoints.

Attribute Information

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO WELLPOINT

Model Name Type Domain Required Attribute Definition id int yes primary key of the table wpId int FK to the WELLPOINT table.

dwId int FK to the DEWATERING table obsDate date The observation date.

pumpRun tinyint Did the pump run this date? Boolean no (0) , yes (1) continuousInt tinyint Did the pump run intermittently (0), or continuously (1) totalgallons numeric (38, 5) total gallons the pump pumped today cumulativeGallons numeric (38, 5) total gallons this pump has pumped to date over the lifetime of the project outage tinyint was there a pump outage for this pump no (0), yes (1) comments varchar(2000) comments about the pump outage or any servicing dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

1-M

Table: WELLPOINT_PERFORMANCE Table Information

Report Table for well point pump performance daily

Attribute Information

DEWATERING WELLPOINT_PERFORMANCE

Relationship Information Primary Table Foreign Table

WELLPOINT WELLPOINT_PERFORMANCE

Model Name Type Domain Required Attribute Definition id int yes primary key of the table constId int yes Foreign key to the CONSTUCTION_INFO table.

obsDate date yes Date of recorded observations poolElev numeric(38,5) pool elevation for this date tailElev numeric(38,5) tailwater elevation for this date cd1GallonsPumped numeric(38,5) gallons pumped on this date from feature 1 cd1WaterLevel numeric(38,5) feature 1 water elevation cd2GallonsPumped numeric(38,5) gallons pumped on this date from feature 2 cd2WaterLevel numeric(38,5) feature 2 water elevation comments varchar(2000) comments about the pump outage or any servicing dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

Table: DEWATERING Table Information

Report Table for water levels of various areas including pool, tailwater and features, updated daily

Attribute Information

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO DEWATERING

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

boreId varchar(25) yes The unique hole Id.

pstSeries varchar(1) Primary, Secondary, or Tertiary hole (P, S, T). Also called hole order.

verifProd tinyint Is the boring a verification or production borehole.

drillerName varchar(50) The name of the driller.

drillInspector varchar(50) The name of the drilling inspector, typically the contractor's geologist that logs the hole.

drillRig varchar(50) The name of the drill rig utilized.

drillStartTime dateTime The drilling start date and time.

drillEndTime dateTime The drilling end date and time.

drillMethod varchar(50) The drilling method used: auger, diamond core bit, sonic, duplex, etc.

easting numeric(38,5) The asbuilt X coordinate of the feature centroid.

northing numeric(38,5) The asbuilt Y coordinate of the feature centroid.

station varchar(20) The station location from the site baseline.

offset numeric(38,5) The offset from the site baseline.

elevTOR numeric(38,5) The elevation at the top of the rock (ft).

holeTopElev numeric(38,5) The elevation at the top of the hole (ft).

holeBotElev numeric(38,5) The elevation at the bottom of the hole (ft).

designHoleDepth numeric(38,5) The design (planned) depth of the hole (ft).

finalHoleDepth numeric(38,5) The final depth of the hole (TD) in ft.

topDepthInterval numeric(38,5) The top depth of the drilling interval if downstaging is performed.

botDepthInterval numeric(38,5) The bottom depth of the drilling interval if downstaging is performed.

angle numeric(38,5) The angle of the hole from vertical.

orientation numeric(38,5) The azimuth direction that the hole is angled.

holeDiam numeric(38,5) The hole diameter in inches.

sectionLine varchar(20) The cross section line that this hole has been assigned to.

comments varchar(2000) Any additional comments about the table.

dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO BORINGS

Table: BORINGS Table Information

Verification and production grout borings.

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

flumeId varchar(50) yes The flume id.

flowMeterId varchar(50) The id of the flow meter.

flumeSize int The size of the flume.

fieldReadFt numeric(38,5) The field reading in feet.

dateTimeRead datetime The date and time of reading.

reader varchar(50) The name of the reader / tester.

resElevation numeric(38,5) The reservoir elevation.

twElevation numeric(38,5) The tailwater elevation.

flowCfs numeric(38,5) The flow in cubic feet per second.

flowGpm numeric(38,5) The flow in gallons per minute.

totalFlowGpm numeric(38,5) The total flow in gallons per minute.

comments varchar(2000) Any additional comments about the table.

dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality

1-MCONSTRUCTION_INFO FLUME

Primary Table Foreign Table

Table: FLUME Table Information

Attribute Information

Relationship Information

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

fcId int Foreign key to FEATURE_CONSTRUCTION table.

cipBatchId int yes Foreign key to CIP_CONC_BATCH_TABLE table.

pinId varchar(25) The unique hole Id.

liftID int The concrete lift identifier. (Note: Will likely be linked to a different table) comments varchar(2000) Any additional comments about the table.

dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M 1-M

FEATURE_CONSTRUCTION CONCRETE_PINS

CIP_CONC_BATCH_TICKETS CONCRETE_PINS

Primary Table Foreign Table

Table: CONCRETE_PINS Table Information

Concrete Pins installed in Cast-in-Place Concrete to determine Penetration or Pullout Resistance Attribute Information

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

gaugeId varchar(50) yes The instrument ID associated with the piezometer installation log and real world instrument gaugeType tinyint The type of gauge employed. (0=Settlement, 1=Rebound) station varchar(20) The station of the gauge.

offset numeric(38,5) The offset of the gauge.

easting numeric(38,5) The easting of the gauge.

northing numeric(38,5) The northing of the gauge.

soilSymbol int d_SOIL_SYMBOL The material classification of formation.

topGaugeElev numeric(38,5) The top of gauge elevation.

elevationGround numeric(38,5) elevation in decimal feet of the ground surface where the gauge was installed comments varchar(2000) Any additional comments about the table.

dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

1-1 (DOMAIN)

CONSTRUCTION_INFO REB_SETTLE_GAUGE

d_SOIL_SYMBOL REB_SETTLE_GAUGE

Primary Table Foreign Table

Table: REB_SETTLE_GAUGE Table Information

Rebound or Settlement Gauge Attribute Information

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

soilId varchar(50) yes The name or id of the test sample.

srcSoil varchar(50) The source of soil or location it was obtained or measured easting numeric(38,5) The easting coordinate of the sample.

northing numeric(38,5) The northing coordinate of the sample.

sampDepth numeric(38,5) The depth in which the sample was taken.

elevation numeric(38,5) The elevation in which the sample was taken.

soilColor int d_COLOR_SHADE USCS soil color shade.

primaryColor int d_PRIM_COLOR USCS soil primary color.

secondaryColor int d_SEC_COLOR USCS soil secondary color.

uscs tinyint d_SOIL_SYMBOL USCS soil classification.

sampleDateTime datetime The date and time that the sample was taken.

comments varchar(2000) Any additional comments about the table.

dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

1-1 (DOMAINS)

1-1 (DOMAINS)

1-1 (DOMAINS)

1-1 (DOMAINS)

d_SEC_COLOR SOIL_SAMPLE d_SOIL_SYMBOL SOIL_SAMPLE

Relationship Information

Table: SOIL_SAMPLE Table Information

Sample information for soil testing.

Attribute Information d_PRIM_COLOR SOIL_SAMPLE

Primary Table Foreign Table

CONSTRUCTION_INFO SOIL_SAMPLE

d_COLOR_SHADE SOIL_SAMPLE

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

mixId int yes Foreign Key to the SC_MIX_DESIGN table.

plantId varchar(50) The plant ID where the batch was created.

mixerId varchar(50) The mixer used to create the batch if plant has more than one mixer.

batchNum int The unique batch number assigned by the batch plant. May also be called the Load ID.

ticketNum int The ticket number assigned by the batch plant.

truckId int The ID for the truck that transported the batch, if used.

timeBatchedStart datetime The date and time the batch was created at the batch plant.

batchUse varchar(50) The intended use for the batch: monoliths, drilled shafts, secant piles, uniformity testing, trial batch testing, etc.

ydsBatched numeric(38,5) The total cubic yards of the batch.

tonsBatched numeric(38,5) The total tons of the batch materials.

caRequired numeric(38,5) The required (target) cement / dry aggregate ratio for the batch, based on the mix design and cubic yards.

caBatched numeric(38,5) The actual (batched) cement/dry aggregate ratio of the batch.

cementType varchar(50) Type of cement used.

waterTrim numeric(38,5) Water that is held back for field moisture content adjustment.

waterAdded numeric(38,5) Water that is actually used to adjust the slump.

totalWater numeric(38,5) The total water added to the batch.

maxWater numeric(38,5) The maximum water allowed to not exceed the water-to-cement ratio.

addableWater numeric(38,5) waterRequired numeric(38,5) The required (target) gallons of water to be added to the mixer, based on the mix design and cubic yards.

waterBatched numeric(38,5) The actual (batched) gallons of water added to the mixer.

waterVariance numeric(38,5) The percent variance from the required gallons of water.

gfsRequired numeric(38,5) The required amount of glacial fluvial sands added to the mixer.

gfsBatched numeric(38,5) The actual (batched) amount of glacial fluvial sands added to the mixer.

gfsVariance numeric(38,5) The percent variance from the required glacial fluvial sands added to the mixer gfsMoisture numeric(38,5) gfsActWater numeric(38,5) pcRequired numeric(38,5) The required amount of portland cement added to the mixer.

pcBatched numeric(38,5) The actual (batched) amount of portland cement added to the mixer.

pcVariance numeric(38,5) The percent variance from the required portland cement added to the mixer pcMoisture numeric(38,5) pcActWater numeric(38,5) adm1PHRequired numeric(38,5) The required amount of place holder for admix 1 added to the mixer.

adm1PHBatched numeric(38,5) The actual (batched) amount o fplace holder for admix 1 added to the mixer.

adm1PHVariance numeric(38,5) The percent variance from the required place holder for admix 1 added to the mixer adm2PHRequired numeric(38,5) The required amount of place holder for admix 2 added to the mixer.

adm2PHBatched numeric(38,5) The actual (batched) amount o fplace holder for admix 2 added to the mixer.

adm2PHVariance numeric(38,5) The percent variance from the required place holder for admix 2 added to the mixer comments varchar(2000) Any additional comments about the table.

dateAppended date Utility field indicating the date that the row was appended to the table.

Table: SC_BATCH_TICKETS Table Information

All information reported on the batch tickets generated by the concrete/ soil cement batch plant.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Cardinality 1-M

1-MSC_MIX_DESIGN SC_BATCH_TICKETS

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO SC_BATCH_TICKETS

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

trialFinal tinyint Is the mix design a trial of final design.

Boolean (0 = Trial, 1 = Final) mixId varchar(50) yes The soil cement mix ID of the batch.

mixDescription varchar(2000) A description of the mix. structural, tremie, etc wcRatio numeric(38,5) The water cement ratio water numeric(38,5) The gal/cy of water in the mix.

gfs numeric(38,5) The lbs/cy of sand in the mix (site glacial fluival).

portCem numeric(38,5) The amount of portland cement in the mix.

admix1PH numeric(38,5) Placeholder: the type of admixture to be established by the contractor. The ounces of admixture in the mix.

admix2PH numeric(38,5) Placeholder: the type of admixture to be established by the contractor. The ounces of admixture in the mix.

comments varchar(2000) Any additional comments about the table.

dateAppended date Utility field indicating the date that the row was appended to the table.

dateModified date Utility field indicating the date that the row was modified in the table.

author varchar(50) Utility field indicating the name of the the person that addeed or modified the row in the table.

qcVerifier varchar(50) Utility field indicating the name of the person who QC'd the data in the row.

qcDate date Utility field indicating the date that the data in the row was reviewed by the QC person.

qaVerifier varchar(50) Utility field indicating the name of the person who QA'd the data in the row.

qaDate date Utility field indicating the date that the data in the row was reviewed by the QA person.

Table: SC_MIX_DESIGN Table Information

The final mix designs for soil cement used on the project

Model Name Type Domain Required Attribute Definition aggSampId int Foreign key to the AGGREGATE_SAMPLE table.

scBatchId int Foreign key to the SC_BATCH_TICKETS table.

Cardinality M-M

M-M

Relationship Information

Table: AGG_SC_JOIN Table Information

A join table for the AGGREGATE_SAMPLE and CONC_BATCH_TICKETS tables.

Attribute Information

Primary Table Foreign Table

AGGREGATE_SAMPLE AGG_SC_JOIN

SC_BATCH_TICKETS AGG_SC_JOIN

Model Name Type Domain Required Attribute Definition id int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

mixId int yes Foreign Key to the SOIL_CEMENT_MIX_DESIGN table.

plantId varchar(50) The plant ID where the batch was created.

mixerId…