W912P520R0004 TSpecs App A - RTA.pdf

US Army Corps of Engineers

Nashville District

Solicitation No. W912P520R0004

DOWNSTREAM LOCK MONOLITHS

Kentucky Lock Addition Tennessee River Livingston County, Kentucky

Technical Specifications Appendix A - FORMS AND ATTACHMENTS

Ready to Advertise (RTA) – Certified Final

April 2021

THIS PAGE INTENTIONALLY LEFT BLANK

FOR DUPLEX PRINTING

USACE Construction Project Sign and Use of the Army Star

Example Graphic of Signage with Dimensions for Civil Works Project

SAFETY PERFORMANCE SIGN

LEGEND GROUP 1: STANDARD TWO-LINE TITLE “SAFETY IS A JOB REQUIREMENT” WITH (8” OD.)

SAFETY GREEN FIRST AID LOGO. TYPEFACE: 3” HELVETICA BOLD COLOR: BLACK.

LEGEND GROUP 2: ONE- TO TWO-LINE PROJECT TITLE LEGEND DESCRIBES THE WORK BEING DONE

UNDER THIS CONTRACT AND NAME OF HOST PROJECT. COLOR: BLACK. TYPE FACE: 1.5”

HELVETICA REGULAR MAXIMUM LINE LENGTH: 42”.

LEGEND GROUP 3: ONE- TO TWO-LINE IDENTIFICATION: NAME OF PRIME CONTRACTOR AND CITY, STATE ADDRESS. COLOR: BLACK. TYPEFACE: 1.5" HELVETICA REGULAR MAXIMUM LINE LENGTH:

42'".

LEGEND GROUP 4: STANDARD SAFETY RECORD CAPTIONS AS SHOWN. COLOR: BLACK. TYPEFACE:

1.25" HELVETICA REGULAR.

REPLACEABLE NUMBERS ARE TO BE MOUNTED ON WHITE .060 ALUMINUM PLATES AND SCREW-

MOUNTED TO BACKGROUND. COLOR: BLACK. TYPEFACE: 3” HELVETICA REGULAR. PLATE SIZE:

2.5” X 5.0”.

ALL TYPOGRAPHY IS FLUSH LEFT AND RAG RIGHT, UPPER AND LOWER CASE WITH INITIAL

CAPITALS ONLY AS SHOWN.

PANEL SIZE 4' X 4', POST SIZE 4" X 4". MOUNTING HEIGHT 48". COLOR BKG/LGD WH/BK-GR.

Kentuck Lock-Tailwater Duration Based on historical data 1948-1964 and 1976-2016

Overall Data Percent Elevation Elevation Percent

10 324.09 300 99.66 20 316.97 305 47.4 30 311.83 310 34.1 40 307.63 315 23 50 304.52 320 15.5 60 303.6 325 9 70 303.01 330 4 80 302.52 335 1.5 90 302.01 340 0.4

100 298.18

January Percent Elevation Elevation Percent

10 327.84 300 99.9 20 322.41 305 70 30 318.07 310 55.8 40 314.41 315 38.3 50 311.91 320 25.5 60 308.52 325 15.1 70 305.08 330 6.2 80 303.76 335 2.2 90 302.53 340 0.9

100 299.91

February Percent Elevation Elevation Percent

10 331.1 300 99.9 20 325.59 305 80 30 321.34 310 61.1 40 317.44 315 46.5 50 313.86 320 33.2 60 310.31 325 21.2 70 307.66 330 12 80 305.07 335 4.8 90 303.55 340 1.9

100 299.9 345 0.1

Kentuck Lock-Tailwater Duration Based on historical data 1948-1964 and 1976-2016

March Percent Elevation Elevation Percent

10 331.97 300 99.9 20 327.44 305 89.5 30 324.21 310 75.5 40 320.85 315 58 50 317.58 320 42.9 60 314.3 325 27.1 70 311.54 330 15 80 308.67 335 5.1 90 304.73 340 0.8

100 299.93

April Percent Elevation Elevation Percent

10 328.17 300 98 20 324.21 305 82.5 30 320.45 310 63.5 40 316.98 315 46 50 313.4 320 31 60 310.76 325 18 70 308.63 330 6 80 305.89 335 0.8 90 302.46

100 299.43

May Percent Elevation Elevation Percent

10 328.25 300 96.3 20 320.21 305 63.5 30 314.51 310 43.5 40 311.21 315 29 50 307.78 320 20.2 60 305.55 325 14 70 303.94 330 7.1 80 302.71 335 2.4 90 301.77 340 0.7

100 298.99

June

10 316.01 300 99 20 311.24 305 42.5 30 307.87 310 23.5 40 305.38 315 12 50 303.98 320 4.8 60 303.45 325 0.6 70 302.94 330 0.2 80 302.42 90 301.78

100 298.75

July Percent Elevation Elevation Percent

10 310.55 300 99.5 20 305.7 305 22.7 30 304.25 310 11.1 40 303.66 315 4.7 50 303.22 320 2.5 60 302.91 325 0.5 70 302.62 80 302.26 90 301.83

100 299.27

August Percent Elevation Elevation Percent

10 304.97 300 99.6 20 304.01 305 10 30 303.52 310 3 40 303.26 315 1.9 50 303.02 320 0.2 60 302.8 70 302.56 80 302.32 90 301.93

100 299.72

September

10 304.76 300 99.1 20 303.84 305 9 30 303.45 310 4 40 303.1 315 1 50 302.83 320 0.1 60 302.58 70 302.38 80 302.21 90 301.88

100 300.17

October Percent Elevation Elevation Percent

10 305.47 300 99.5 20 304 305 13 30 303.53 310 4.5 40 303.15 315 0.9 50 302.84 320 0.2 60 302.54 70 302.3 80 302.06 90 301.7

100 298.18

November Percent Elevation Elevation Percent

10 313.54 300 99.7 20 308.33 305 29.1 30 304.83 310 17 40 303.94 315 6.5 50 303.43 320 1.9 60 303 325 1 70 302.65 330 0.6 80 302.38 90 301.97

100 299.36

December

10 324.58 300 99.9 20 320.64 305 60 30 317.17 310 48.3 40 312.89 315 35.5 50 309.26 320 22 60 305.04 325 9 70 303.76 330 2 80 302.99 335 0.8 90 302.2 340 0.2

100 299.87

THIS PAGE INTENTIONALLY LEFT BLANK

FOR DUPLEX PRINTING

Kentuck Lock-Tailwater Frequency Based on historical data 1948-1964 and 1976-2016

OVERALL DATA

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 349.41 1 100-year 346.67 2 50-year 344.83 5 20-year 342.28 10 10-year 340.86 20 5-year 338.30 50 2-year 332.83

JANUARY

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 345.14 1 100-year 343.72 2 50-year 342.83 5 20-year 336.07 10 10-year 333.67 20 5-year 329.61 50 2-year 324.81

FEBRUARY

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 351.45 1 100-year 347.31 2 50-year 344.55 5 20-year 339.44 10 10-year 337.28 20 5-year 332.87 50 2-year 324.97

Kentuck Lock-Tailwater Frequency Based on historical data 1948-1964 and 1976-2016

MARCH

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 341.99 1 100-year 341.53 2 50-year 341.24 5 20-year 340.54 10 10-year 337.91 20 5-year 334.28 50 2-year 326.80

APRIL

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 338.11 1 100-year 337.88 2 50-year 337.74 5 20-year 335.54 10 10-year 333.29 20 5-year 330.55 50 2-year 323.36

MAY

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 346.05 1 100-year 343.49 2 50-year 341.82 5 20-year 338.27 10 10-year 333.86 20 5-year 330.60 50 2-year 317.93

JUNE

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 339.88 1 100-year 335.66 2 50-year 332.88 5 20-year 325.70 10 10-year 324.30 20 5-year 318.05 50 2-year 310.30

JULY

0.2 500-year 324.57 1 100-year 324.28 2 50-year 324.10 5 20-year 322.24 10 10-year 317.36 20 5-year 312.31 50 2-year 306.12

AUGUST

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 322.83 1 100-year 320.57 2 50-year 319.09 5 20-year 313.84 10 10-year 309.08 20 5-year 307.71 50 2-year 304.53

SEPTEMBER

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 319.94 1 100-year 319.29 2 50-year 318.86 5 20-year 314.96 10 10-year 313.23 20 5-year 306.09 50 2-year 304.10

OCTOBER

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 326.26 1 100-year 322.23 2 50-year 319.64 5 20-year 315.27 10 10-year 312.98 20 5-year 307.38 50 2-year 304.38

NOVEMBER

0.2 500-year 337.34 1 100-year 333.05 2 50-year 330.35 5 20-year 325.60 10 10-year 323.73 20 5-year 318.85 50 2-year 307.83

DECEMBER

Percent chance exceedance Return Interval (in years) Elevation

0.2 500-year 351.82 1 100-year 345.44 2 50-year 341.42 5 20-year 335.02 10 10-year 330.43 20 5-year 327.88 50 2-year 320.79

1-Jan-10 31-Jan-10 2-Mar-10 2-Apr-10 2-May-10 2-Jun-10 2-Jul-10 1-Aug-10 1-Sep-10 1-Oct-10 1-Nov-10 1-Dec-10 1-Jan-11

El ev at io n, fe et N

G

VD

Date

Kentucky Lock Tailwater Elevation

1-Jan-11 31-Jan-11 2-Mar-11 2-Apr-11 2-May-11 2-Jun-11 2-Jul-11 1-Aug-11 1-Sep-11 1-Oct-11 1-Nov-11 1-Dec-11 1-Jan-12

El ev at io n, fe et N

G

VD

1-Jan-12 31-Jan-12 1-Mar-12 1-Apr-12 1-May-12 1-Jun-12 1-Jul-12 31-Jul-12 31-Aug-12 30-Sep-12 31-Oct-12 30-Nov-12 31-Dec-12

El ev at io n, fe et N

G

VD

1-Jan-13 31-Jan-13 2-Mar-13 2-Apr-13 2-May-13 2-Jun-13 2-Jul-13 1-Aug-13 1-Sep-13 1-Oct-13 1-Nov-13 1-Dec-13 1-Jan-14

El ev at io n, fe et N

G

VD

1-Jan-14 31-Jan-14 2-Mar-14 2-Apr-14 2-May-14 2-Jun-14 2-Jul-14 1-Aug-14 1-Sep-14 1-Oct-14 1-Nov-14 1-Dec-14 1-Jan-15

El ev at io n, fe et N

G

VD

1-Jan-15 31-Jan-15 2-Mar-15 2-Apr-15 2-May-15 2-Jun-15 2-Jul-15 1-Aug-15 1-Sep-15 1-Oct-15 1-Nov-15 1-Dec-15 1-Jan-16

El ev at io n, fe et N

G

VD

Definition:

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

mediaId int Foreign key to the MEDIA_REPORTS table.

fcId int The features being constructed during the project.

usaceContact int The USACE contact for the construction.

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

district int 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‐M

1‐M

1‐1

1‐1 (Domain)

1‐1 (Domain)

This data dictionary is a draft. Th final dictionary will be added as an ammendment to the solicitation prior to award.

Table: CONSTRUCTION_INFO Table Information

CONSTRUCTION_INFO USACE_PERSONNEL

Attribute Information

Table containing general information about the construction project.

Relationship Information Primary Table Foreign Table

CONSTRUCTION_INFO MEDIA_REPORTS

CONSTRUCTION_INFO FEATURE_CONSTRUCTION

CONSTRUCTION_INFO DISTRICT

CONSTRUCTION_INFO DIVISION

recordIdpk int yes The primary key of the table.

mediaId int Foreign key to the MEDIA_REPORTS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

description varchar(2000) A description of feature.

type int FC_TYPE The feature type being constructed.

constMaterials int 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)

Table: FEATURE_CONSTRUCTION Table Information

The type of feature(s) that is being constructed. E.g. Cutoff wall.

Attribute Information

Relationship Information Primary Table Foreign Table

FEATURE_CONSTRUCTION MEDIA_REPORTS

FEATURE_CONSTRUCTION FC_TYPE

FEATURE_CONSTRUCTION CONSTRUCTION_MATERIAL_TYPE

recordIdpk int yes The primary key of the table.

sampleType varchar(50) Determination of whether the sample was taken at a single location or within a larger area.

sampleLocation varchar(255) A brief description of the sample location.

station numeric(38,16) The station in which the sample was taken.

offset numeric(38,16) The station offset in which the sample was taken.

liftNumber varchar(20) The lift number from which the sample was taken.

elevation numeric(38,16) The elevation (in feet) the sample was taken.

depth numeric(38,16) The depth (in feet) the sample was taken.

sampleDate datetime2(2) The date and time in which the sample was taken.

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

Cardinality

Table: SAMPLE_LOCATION Table Information

The location in which a sample for testing was taken.

Attribute Information

Relationship Information Primary Table Foreign Table recordIdpk int yes The primary key of the table.

retestGrpId int yes The group id of the re‐tests.

retestId int yes Foreign key to the RE_TEST table.

Table: RE_TEST_GROUP Table Information

Grouping table for the re‐testing tables to the base test table.

Attribute Information recordIdpk int yes The primary key of the table.

retestId int yes The retest id.

originalId int yes The original id the retest is associated with.

Table: RE_TEST Table Information

Table associating the re‐test id with the original id.

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

pressFilKpf numeric(38,16) pressFilCt numeric(38,16) pressFilVol numeric(38,16) comments varchar(2000) Any additional comments about the table.

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: API_RP_13B_1 Table Information

Attribute Information

Relationship Information Primary Table Foreign Table

GRT_PLANT_TICKETS API_RP_13B_1

API_RP_13B_1 MEDIA_REPORTS

API_RP_13B_1 QAQC

API_RP_13B_1 RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

avgMeasureDiam numeric(38,16) The average measured diameter of the specimens.

avgCompStrength numeric(38,16) The average compressive strength of the specimens.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Primary Table Foreign Table

CONC_BATCH_TICKETS C39_COMP_STR_CYLINDER

C39_COMP_STR_CYLINDER RE_TEST_GROUP

C39_COMP_STR_CYLINDER MEDIA_REPORTS

C39_COMP_STR_CYLINDER QAQC

Relationship Information

Table: C39_COMP_STR_CYLINDER Table Information

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

recordIdpk int yes The primary key of the table.

c39Id int yes Foreign key to the C39_COMP_STR_CYLINDER table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

fractType int C39_FRACT_TYPE The specimen fracture type.

specAge int The age of the specimen.

csArea numeric(38,16) The cross sectional area of the specimen.

maxLoad numeric(38,16) The maximum load of the specimen.

diameter numeric(38,16) The diameter of the specimen.

length numeric(38,16) The length of the specimen.

compStrength numeric(38,16) The compressive strength of the sample in PSI.

density numeric(38,16) The density of the specimen.

castDate date The date in which the specimen was cast.

dateReceived date The date in which the specimen was received.

dateTested date The date in which the specimen was tested.

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

Cardinality 1‐M

1‐M

1‐1

1‐1 (Domain)C39_SPECIMEN C39_FRACT_TYPE

C39_COMP_STR_CYLINDER C39_SPECIMEN

C39_SPECIMEN MEDIA_REPORTS

C39_SPECIMEN QAQC

Primary Table Foreign Table Relationship Information

Table: C39_SPECIMEN Table Information

Specimen specific information for the C39 test.

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

flow numeric(38,16) The increase in average base diameter of the mortar mass.

Generally in a percentage.

waterUsed numeric(38,16) The amount of water used in the test.

avgCompStrength numeric(38,16) The average comp strength in PSI.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: C109_COMP_STR_CUBE Table Information

Report table for ASTM C109: Standard test method for compressive strength of hydraulic cement mortars (using 2‐in.

or [50 mm] cube specimens.

Attribute Information

Relationship Information Primary Table Foreign Table

CONC_BATCH_TICKETS C109_COMP_STR_CUBE

C109_COMP_STR_CUBE MEDIA_REPORTS

C109_COMP_STR_CUBE QAQC

C109_COMP_STR_CUBE RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

c109Id int yes Foreign key to the C109_COMP_STR_CUBE table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

compStrength numeric(38,16) The compressive strength of the sample in PSI.

castDateTime datetime2(2) The date in which the specimen was cast.

dateTimeTest datetime2(2) The date of the test.

age int The age, in days, of the specimen.

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

Cardinality 1‐M

1‐M

1‐1

Table: C109_SPECIMEN Table Information

Specimen specific information for the C109 test.

Attribute Information

C109_COMP_STR_CUBE C109_SPECIMEN

Relationship Information Primary Table Foreign Table

C109_SPECIMEN MEDIA_REPORTS

C109_SPECIMEN QAQC

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

testProcedure int C117_TEST_PROC The washing procedure employed during the test.

finer200 numeric(38,16) The percentage of finer than 200 sieve passing to the nearest 0.1 %.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

1‐1 (Domain)

Table: C117_FINER_200_WASH Table Information

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

Attribute Information

Relationship Information Primary Table Foreign Table

C117_FINER_200_WASH C117_TEST_PROC

CONC_BATCH_TICKETS C117_FINER_200_WASH

C117_FINER_200_WASH MEDIA_REPORTS

C117_FINER_200_WASH QAQC

C117_FINER_200_WASH RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

aggSampId int Foreign key to the AGGREGATE_SAMPLE retestGrpId int Foreign key to the RE_TEST_GROUP table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

sieve3_8inch_pass numeric(38,16) The percent passing of the 3/8 inch sieve.

sieve3_8inch_ret numeric(38,16) The percent retainage of the 3/8 inch sieve.

sieve1_2inch_pass numeric(38,16) The percent passing of the 1/2 inch sieve.

sieve1_2inch_ret numeric(38,16) The percent retainage of the 1/2 inch sieve.

sieve3_4inch_pass numeric(38,16) The percent passing of the 3/4 inch sieve.

sieve3_4inch_ret numeric(38,16) The percent retainage of the 3/4 inch sieve.

sieve1inch_pass numeric(38,16) The percent passing of the 1 inch sieve.

sieve1inch_ret numeric(38,16) The percent retainage of the 1 inch sieve.

sieve1_12inch_pass numeric(38,16) The percent passing of the 1 1/2 inch sieve.

sieve1_12inch_ret numeric(38,16) The percent retainage of the 1 1/2 inch sieve.

sieve2inch_pass numeric(38,16) The percent passing of the 2 inch sieve.

sieve2inch_ret numeric(38,16) The percent retainage of the 2 inch sieve.

sieve3inch_pass numeric(38,16) The percent passing of the 3 inch sieve.

sieve3inch_ret numeric(38,16) The percent retainage of the 3 inch sieve.

sieve4inch_pass numeric(38,16) The percent passing of the 4 inch sieve.

sieve4inch_ret numeric(38,16) The percent retainage of the 4 inch sieve.

sieveNo4_pass numeric(38,16) The percent passing of the No. 4 sieve.

sieveNo4_ret numeric(38,16) The percent retainage of the No. 4 sieve.

sieveNo8_pass numeric(38,16) The percent passing of the No. 8 sieve.

sieveNo8_ret numeric(38,16) The percent retainage of the No. 8 sieve.

sieveNo16_pass numeric(38,16) The percent passing of the No. 16 sieve.

sieveNo16_ret numeric(38,16) The percent retainage of the No. 16 sieve.

sieveNo30_pass numeric(38,16) The percent passing of the No. 30 sieve.

sieveNo30_ret numeric(38,16) The percent retainage of the No. 30 sieve.

sieveNo50_pass numeric(38,16) The percent passing of the No. 50 sieve.

sieveNo50_ret numeric(38,16) The percent retainage of the No. 50 sieve.

sieveNo100_pass numeric(38,16) The percent passing of the No. 100 sieve.

sieveNo100_ret numeric(38,16) The percent retainage of the No. 100 sieve.

sieveNo200_pass numeric(38,16) The percent passing of the No. 200 sieve.

sieveNo200_ret numeric(38,16) The percent retainage of the No. 200 sieve.

finenessModulus numeric(38,16) The fineness modulus of the analysis.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality

1‐M

1‐1

Table: C136_SIEVE_ANALYSIS Table Information

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

Attribute Information

Relationship Information Primary Table Foreign Table

C136_SIEVE_ANALYSIS MEDIA_REPORTS

C136_SIEVE_ANALYSIS QAQC

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

volDensity numeric(38,16) The volume of density measure of the sample.

density numeric(38,16) The density (unit weight) of the sample.

theoDensity numeric(38,16) The theoretical density of the sample (When requested).

yield numeric(38,16) The yield of the sample (when requested).

relativeYield numeric(38,16) The relative yield of the sample (when requested).

cementContent numeric(38,16) The cement content of the sample (when requested).

airContent numeric(38,16) The air content of the concrete (when requested).

dateTested date The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: C138_DEN_YIELD_AC_CONCRETE Table Information

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

Attribute Information

Relationship Information Primary Table Foreign Table

CONC_BATCH_TICKETS C138_DEN_YIELD_AC_CONCRETE

C138_DEN_YIELD_AC_CONCRETE MEDIA_REPORTS

C138_DEN_YIELD_AC_CONCRETE QAQC

C138_DEN_YIELD_AC_CONCRETE RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

slump numeric(38,16) The concrete slump to the nearest 0.25 inch.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: C143_SLUMP_HCC Table Information

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

Attribute Information

Relationship Information Primary Table Foreign Table

CONC_BATCH_TICKETS C143_SLUMP_HCC

C143_SLUMP_HCC MEDIA_REPORTS

C143_SLUMP_HCC QAQC

C143_SLUMP_HCC RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

method int C191_METHOD The method for the vicat apparatus.

initialTime int The vicat initial time of setting in minutes.

finalSet int The vicat final time of setting in minutes.

totalTime int The total elapsed time in minutes.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

1‐1 (Domain)

Table: C191_SET_TIME_VICAT Table Information

Report table for ASTM C191: Standard test method for time of setting of hydraulic cement by vicat needle.

Attribute Information

Relationship Information Primary Table Foreign Table

C191_SET_TIME_VICAT C191_METHOD

GRT_PLANT_TICKETS C191_SET_TIME_VICAT

C191_SET_TIME_VICAT MEDIA_REPORTS

C191_SET_TIME_VICAT QAQC

C191_SET_TIME_VICAT RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

airContent numeric(38,16) The air content of the concrete to the nearest 0.1%.

mortarFraction numeric(38,16) The mortar fraction of the concrete to the nearest 0.25%.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Relationship Information Primary Table Foreign Table

Table: C231_AIR_CONT_FRESHCON_PRESSURE Table Information

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

Attribute Information

CONC_BATCH_TICKETS C231_AIR_CONT_FRESHCON_PRESSURE

C231_AIR_CONT_FRESHCON_PRESSURE MEDIA_REPORTS

C231_AIR_CONT_FRESHCON_PRESSURE QAQC

C231_AIR_CONT_FRESHCON_PRESSURE RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

volumeBleed numeric(38,16) The volume of bleed water per unit area of surface in mL.

accBleed numeric(38,16) The accumulated bleed water in %.

bleedTimeMin int The elapsed minutes required for the cessation of bleeding.

bleedTimeSec int The elapsed seconds required for the cessation of bleeding.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: C232_CONCRETE_BLEED Table Information

Report table for ASTM C232: Standard test method for bleeding of concrete.

Attribute Information

Relationship Information Primary Table Foreign Table

CONC_BATCH_TICKETS C232_CONCRETE_BLEED

C232_CONCRETE_BLEED MEDIA_REPORTS

C232_CONCRETE_BLEED QAQC

C232_CONCRETE_BLEED RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

c143Id int Foreign key to the C143 table.

c231Id int Foreign key to the c231 table.

mortarTemp numeric(38,16) The mortar temperature after sieving.

ambientTemp numeric(38,16) Ambient temperature during the test period.

iniSetHr int The hour of the initial setting.

iniSetMin int The minute of the initial setting.

finSetHr int The hour of the final setting.

finSetMin int The minute of the final setting.

dateTest date The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

1‐1 (Domain)

1‐1 (Domain)

Table: C403_SET_TIME_CONC_PENE_RESIST Table Information

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

Attribute Information

Relationship Information Primary Table Foreign Table

CONC_BATCH_TICKETS C403_SET_TIME_CONC_PENE_RESIST

C403_SET_TIME_CONC_PENE_RESIST MEDIA_REPORTS

C403_SET_TIME_CONC_PENE_RESIST QAQC

C403_SET_TIME_CONC_PENE_RESIST RE_TEST_GROUP

C403_SET_TIME_CONC_PENE_RESIST C143_SLUMP_HCC

C403_SET_TIME_CONC_PENE_RESIST C231_AIR_CONT_FRESHCON_PRESSURE

recordIdpk int yes The primary key of the table.

aggSampId int Foreign key to the AGGREGATE_SAMPLE retestGrpId int Foreign key to the RE_TEST_GROUP table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

avgTotalEvap numeric(38,16) The average total evaporation of the specimen.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: C566_TOTEVAP_MOISTURE_AGG_DRYING Table Information

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

Attribute Information

Relationship Information Primary Table Foreign Table

CONC_BATCH_TICKETS C566_TOTEVAP_MOISTURE_AGG_DRYING

C566_TOTEVAP_MOISTURE_AGG_DRYING MEDIA_REPORTS

C566_TOTEVAP_MOISTURE_AGG_DRYING QAQC

C566_TOTEVAP_MOISTURE_AGG_DRYING RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

c566Id int yes Foreign key to the C566_TOTEVAP_MOISTURE_AGG_DRYING table.

specId int The specimen number / name.

totalEvap numeric(38,16) The total evaporation of the specimen. % dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

Primary Table Foreign Table

C566_TOTEVAP_MOISTURE_AGG_DRYING C566_SPECIMEN

Relationship Information

Table: C566_SPECIMENS Table Information

Specimen specific information for the C566 test.

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

mixerUsed varchar(50) The type of mixer used for the test.

ambientTemp numeric(38,16) The ambient temperature in farhenheit.

testTemp numeric(38,16) The temperature at the time of the test in farhenheit.

viscosity numeric(38,16) The viscosity of the sample to nearest 0.2 seconds.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: C939_VISCOSITY_FLOWCONE Table Information

Report table for ASTM C939: Standard test method for flow of grout for preplaced‐aggregate concrete (flow cone method).

Attribute Information

Relationship Information Primary Table Foreign Table

GRT_PLANT_TICKETS C939_VISCOSITY_FLOWCONE

C939_VISCOSITY_FLOWCONE MEDIA_REPORTS

C939_VISCOSITY_FLOWCONE QAQC

C939_VISCOSITY_FLOWCONE RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

finalBleed numeric(38,16) The final bleeding to the nearest 0.2%.

tempStartTest numeric(38,16) Grout specimen temperature at the start of the test.

ambientTempInitial numeric(38,16) Lab temperature at the beginning of the test.

ambientTempFinal numeric(38,16) Lab temperature at the end of the test.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: C940_BLEED_EXPANSION Table Information

Report table for ASTM C940: Standard test method for expansion and bleeding of freshly mixed grouts for preplaced‐ agregate concrete in the laboratory.

Attribute Information

Relationship Information Primary Table Foreign Table

GRT_PLANT_TICKETS C940_BLEED_EXPANSION

C940_BLEED_EXPANSION MEDIA_REPORTS

C940_BLEED_EXPANSION QAQC

C940_BLEED_EXPANSION RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

c940Id int yes Foreign key to the C940_BLEED_EXPANSION table.

interval int The test interval.

expansion numeric(38,16) The interval expansion of grout to the nearest 0.2%. (+ = Expansion, ‐ = Reduction) bleed numeric(38,16) The bleeding of grout to the nearest 0.2% for the interval.

combBleedingExp numeric(38,16) The combined expansion of grout plus bleed water to the nearest 0.2% for the interval.

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

Cardinality 1‐M

Table: C940_INTERVALS Table Information

Specimen interval information for the C940 test.

Attribute Information

Relationship Information

C940_BLEED_EXPANSION C940_INTERVAL

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

weatherId int Foreign key to the WEATHER table.

labOrField tinyint Was the test conducted within the lab or field.

cureProcDesc varchar(2000) A description of the curing process.

avgCompStr7 numeric(38,16) The average compressive strength at 7 days.

avgCompStr28 numeric(38,16) The average compressive strength at 28 days.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

1‐1

C942_COMPSTR_GRT_PREAGG_CONC_LAB MEDIA_REPORTS

C942_COMPSTR_GRT_PREAGG_CONC_LAB QAQC

C942_COMPSTR_GRT_PREAGG_CONC_LAB WEATHER

Primary Table Foreign Table

GRT_PLANT_TICKETS C942_COMPSTR_GRT_PREAGG_CONC_LAB

C942_COMPSTR_GRT_PREAGG_CONC_LAB RE_TEST_GROUP

Relationship Information

Table: C942_COMPSTR_GRT_PREAGG_CONC_LAB Table Information

Report table for ASTM C942: Standard test method for compressive strength of grouts for preplaced‐aggregate concrete in the laboratory.

recordIdpk int yes The primary key of the table.

c942Id int yes Foreign key to the C942_COMPSTR_GRT_PREAGG_CONC_LAB table.

specId int The Id of the specimen.

compStr7 numeric(38,16) The compressive strength at 7 days.

compStr28 numeric(38,16) The compressive strength at 28 days.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

Primary Table Foreign Table

C942_COMPSTR_GRT_PREAGG_CONC_LAB C940_INTERVAL

Relationship Information

Table: C942_INTERVALS Table Information

Specimen interval information for the C942 test.

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

temperature numeric(38,16) The concrete temperature to the nearest 0.1 degree fahrenheit.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐M

1‐1

1‐M

1‐1

Table: C1064_TEMP_FRESH_HC_CONC Table Information

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

Attribute Information

Relationship Information Primary Table Foreign Table

CONC_BATCH_TICKETS C1064_TEMP_FRESH_HC_CONC

C1064_TEMP_FRESH_HC_CONC MEDIA_REPORTS

C1064_TEMP_FRESH_HC_CONC QAQC

GRT_PLANT_TICKETS C1064_TEMP_FRESH_HC_CONC

C1064_TEMP_FRESH_HC_CONC RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

flow numeric(38,16) The flow the hydraulic cement mortar.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1C1437_FLOW_HYD_CEM_MORTAR QAQC

GRT_PLANT_TICKETS C1437_FLOW_HYD_CEM_MORTAR

C1437_FLOW_HYD_CEM_MORTAR RE_TEST_GROUP

C1437_FLOW_HYD_CEM_MORTAR MEDIA_REPORTS

Primary Table Foreign Table

Table: C1437_FLOW_HYD_CEM_MORTAR Table Information

Report table for ASTM C1064: Standard test method for flow of hydraulic cement mortar.

Relationship Information recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

batchId int Foreign key to the CONC_BATCH_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

moistureRange numeric(38,16) The range of the moisture values.

unitWgtRange numeric(38,16) The range of the unit weight values.

coarseAggRange numeric(38,16) The range of the coarse aggregate values.

airContRange numeric(38,16) The range of the air content values.

slumpRange numeric(38,16) The range of the slump values.

compStrRange numeric(38,16) The range of the compressive strenght values.

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

Cardinality 1‐M

1‐1

1‐M

1‐1COE_CRD_C_55_UNIFORMITY QAQC

Primary Table Foreign Table

COE_CRD_C_55_UNIFORMITY CONC_BATCH_TICKETS

COE_CRD_C_55_UNIFORMITY RE_TEST_GROUP

COE_CRD_C_55_UNIFORMITY MEDIA_REPORTS

Relationship Information

Table: COE_CRD_C_55_UNIFORMITY Table Information

Test method for Within‐Batch Uniformity of Freshly Mixed Concrete.

recordIdpk int yes The primary key of the table.

coe55Id int Foreign key to the COE_CRD_C_55_UNIFORMITY table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

c39Id int Foreign key to the C39_COMP_STR_CYLINDER table.

c138Id int Foreign key to the C138_DEN_YIELD_AC_CONCRETE table.

c143Id int Foreign key to the C143_SLUMP_HCC table.

c231Id int Foreign key to the C231_AIR_CONT_FRESHCON_PRESSURE table.

c566Id int Foreign key to the C566_TOTEVAP_MOISTURE_AGG_DRYING table.

coe61Id int Foreign key to the COE_CRD_C_61_WASHOUT table.

sieveNo4Ret numeric(38,16) The percentage of max aggregate retained.

specId varchar(50) The id or naming of the specimen.

specType int CRD_C55_SPEC_TYPE The uniformity specimen type (1st, 2nd and last third of the batch).

mass numeric(38,16) The total mass of the specimen.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐M

1‐1

1‐1

1‐1

1‐1

1‐1

1‐1

1‐1

1‐1 (Domain)

COE_CRD_C_55_SPEIMENS QAQC

COE_CRD_C_55_SPEIMENS C39_COMP_STR_CYLINDER

COE_CRD_C_55_SPEIMENS C138_DEN_YIELD_AC_CONCRETE

COE_CRD_C_55_SPEIMENS C143_SLUMP_HCC

COE_CRD_C_55_SPEIMENS CRD_C55_SPEC_TYPE

COE_CRD_C_55_SPEIMENS C231_AIR_CONT_FRESHCON_PRESSURE

COE_CRD_C_55_SPEIMENS C566_TOTEVAP_MOISTURE_AGG_DRYING

COE_CRD_C_55_SPEIMENS COE_CRD_C_61_WASHOUT

Primary Table Foreign Table

COE_CRD_C_55_UNIFORMITY COE_CRD_C_55_SPEIMENS

COE_CRD_C_55_SPEIMENS MEDIA_REPORTS

Relationship Information

Table: COE_CRD_C_55_SPEIMENS Table Information

Specimen specific information for the COE CRD‐C 55 test.

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

d1Washout numeric(38,16) Drop one washout.

d2Washout numeric(38,16) Drop two washout.

d3Washout numeric(38,16) Drop three washout.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐1

1‐M

1‐1

Relationship Information Primary Table Foreign Table

COE_CRD_C_61 MEDIA_REPORTS

COE_CRD_C_61 QAQC

COE_CRD_C_61 RE_TEST_GRP

Table: COE_CRD_C_61_WASHOUT Table Information

Test method for determining the resistence of freshly mixed concrete to washing out in water.

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

drillOrSecant tinyint Is the test for a drilled shaft or secant pile. Boolean (0 = Drilled Shaft [Default], 1 = Secant Pile) tubeSpacing numeric(38,16) The spacing between the transmitter tube and receiver tube in inches.

testLength numeric(38,16) The length of the test in feet.

gain numeric(38,16) The amplification factor.

measurementDepth numeric(38,16) The depth at which the measurement was taken.

arrivalTime numeric(38,16) The time required for the leading edge of the ultrasonic pulse to travel from the transmitter to the receiver.

energy numeric(38,16) The energy measured in dB.

spikeInterval numeric(38,16) The depth interval where a spike in dB occurs.

peakFeet numeric(38,16) This is calling out the dB peak in a reported interval.

energyDecrease numeric(38,16) The decrease in energy in dB.

fatDelay numeric(38,16) First Arrival Time delay. The time required for the leading edge of the ultrasonic pulse to travel from the transmitter to the receiver.

Decrease in velocity = FAT delay.

dateTimeStart datetime2(2) The date and time the test started.

dateTimeEnd datetime2(2) The date and time the test was completed.

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

Cardinality 1‐1

1‐M

1‐1

Table: CSL Table Information

Attribute Information

Relationship Information Primary Table Foreign Table

CSL RE_TEST_GRP

CSL MEDIA_REPORTS

CSL QAQC

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

slurrySource varchar(255) The source of the slurry being tested.

specimenAge int The age of the specimen.

slurryTemp numeric(38,16) The temperature of the slurry in fahrenheit.

slurryDensity numeric(38,16) The density of the slurry to the nearest 0.01 g/cm^3.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Relationship Information Primary Table Foreign Table

Table: D4380_DENSITY_SLURRIES Table Information

Report table for ASTM D4980: Standard test method for determining density of construction slurries.

Attribute Information

GRT_PLANT_TICKETS D4380_DENSITY_SLURRIES

D4380_DENSITY_SLURRIES MEDIA_REPORTS

D4380_DENSITY_SLURRIES QAQC

D4380_DENSITY_SLURRIES RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

aggSampId int Foreign key to the AGGREGATE_SAMPLE table.

c136Id int Foreign key to the C136_SIEVE_ANALYSIS table.

retestGrpId int Foreign key to the RE_TEST_GROUP table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

aNumPart int The number of particles in the sample. (Method A) aFlatNum int The number of flat particles in the sample. (Method A) aFlatMass numeric(38,16) The mass of the flat particles in the sample. (Method A) aElongNum int The number of elongated particles in the sample. (Method A) aElongMass numeric(38,16) The mass of the elongated particles in the sample. (Method A) aBothNum int The number of particles that are both flat or elongated. (Method A) aBothMass numeric(38,16) The mass of particles that are both flat or elongated. (Method A) aNeitherNum int The number of particles that are neither flat or elongated.

(Method A) aNeitherMass numeric(38,16) The mass of particles that are neither flat or elongated. (Method A) aDimRation varchar(20) The dimensional ratios used in the test. (Method A) bNumPart int The number of particles tested.

bFlatNum numeric(38,16) The number of flat particles in the sample. (Method B) bFlatMass numeric(38,16) The mass of the flat particles in the sample. (Method B) bElongNum numeric(38,16) The number of elongated particles in the sample. (Method B) bElongMass numeric(38,16) The mass of elongated particles in the sample. (Method B) bDimRatio varchar(20) The dimensional ratios used in the test. (Method B) wgtAvgAct numeric(38,16) The weighted average percentage based on the actual proportions of the sieves.

wgtAvgAssumed numeric(38,16) The weighted average percentage based on the assumed proportions of the sieves.

dateTimeTest datetime2(2) The date of the test.

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

Cardinality 1‐M

1‐1

1‐1

1‐M

1‐1

D4791_FLAT_ELONG_COARSE_AGG C136_SIEVE_ANALYSIS

D4791_FLAT_ELONG_COARSE_AGG QAQC

D4791_FLAT_ELONG_COARSE_AGG MEDIA_REPORTS

Primary Table Foreign Table

AGGREGATE_SAMPLE D4791_FLAT_ELONG_COARSE_AGG

D4791_FLAT_ELONG_COARSE_AGG RE_TEST_GROUP

Relationship Information

Table: D4791_FLAT_ELONG_COARSE_AGG Table Information

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

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

ticketId int Foreign key to the GRT_PLANT_TICKETS table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

sampleSource varchar(50) The source of the sample.

testingTime time(2) Testing time, from initial mixing, of the slurry sample. This may need to changed to an integer / numeric.

slurryVolume numeric(38,16) The volume of the slurry collected during the test.

slurryTemp numeric(38,16) The temperature of the slurry in fahrenheit.

viscosity int The elapsed time to the nearest second of the slurry to flow into the graduated cup.

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

Cardinality 1‐M

1‐1

1‐M

1‐1

Table: D6910_VISCOSITY_MARSHFUNNEL Table Information

Report table for ASTM D6910: Standard test method for marsh funnel viscosity of construction slurries.

Attribute Information

Relationship Information Primary Table Foreign Table

GRT_PLANT_TICKETS D6910_VISCOSITY_MARSHFUNNEL

D6910_VISCOSITY_MARSHFUNNEL MEDIA_REPORTS

D6910_VISCOSITY_MARSHFUNNEL QAQC

D6910_VISCOSITY_MARSHFUNNEL RE_TEST_GROUP

recordIdpk int yes The primary key of the table.

testId varchar(50) yes The test or sample id/name retestGrpId int Foreign key to the RE_TEST_GROUP table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

holeId int Foreign key to the BLAST_HOLE table.

testStart datetime2(2) The initial date and time of the test.

testEnd datetime2(2) The final date and time of the test.

maxPressAch numeric(38,16) The maximum pressure induced during grout injection.

maxPressAll numeric(38,16) The maximum pressure allowed.

lugeon numeric(38,16) The calculated lugeons of the stage.

gaugePress numeric(38,16) The gauge pressure required to induce the effective pressure.

effectivePress numeric(38,16) The effective pressure based on rule of thumb criteria (1 psi per foot of rock).

waterVolume numeric(38,16) The total volume (take) injected into the hole.

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

Cardinality 1‐1

1‐M

1‐1

1‐M

GRT_WATER_PRESSURE RE_TEST_GROUP

Table: GRT_WATER_PRESSURE Table Information

Water pressure test for the grout.

Attribute Information

Relationship Information Primary Table Foreign Table

BLAST_HOLE GRT_WATER_PRESSURE

GRT_WATER_PRESSURE MEDIA_REPORTS

GRT_WATER_PRESSURE QAQC

recordIdpk int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

sampLocId varchar(50) The sample location id.

mediaId int Foreign key to the MEDIA_REPORTS table.

stockpile varchar(50) The name / type of stockpile.

mass numeric(38,16) The total mass of the aggregate sample.

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

Cardinality 1‐M

1‐MAGGREGATE_SAMPLE MEDIA_REPORTS

Primary Table Foreign Table

CONSTRUCTION_INFO AGGREGATE_SAMPLE

Relationship Information

Table: AGGREGATE_SAMPLE Table Information recordIdpk int yes The primary key of the table.

constId int yes Foreign key to the CONSTRUCTION_INFO table.

mediaId int Foreign key to the MEDIA_REPORTS table.

qaqcId int Foreign key to the QAQC table.

mixId int Foreign Key to the CONC_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.

timeBatched datetime2(2) 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.

placementLocation varchar(50) The planned placement location for the batch: monolith‐lift (M23‐ 1), drilled shaft (R14‐1), etc ydsBatched numeric(38,16) The total cubic yards of the batch.

lbsBatched numeric(38,16) The total lbs of the batch materials.

wcRequired numeric(38,16) The required (target) water/cement ratio for the batch, based on the mix design and cubic yards.

wcBatched numeric(38,16) The actual (batched) water/cement ratio of the batch.

waterTrim numeric(38,16) Water that is held back in case of slump adjustment.

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

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

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

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

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

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

iceRequired numeric(38,16) The required (target) lbs of ice, based on the mix design and cubic yards.

iceBatched numeric(38,16) The actual (batched) lbs of ice added to the batch.

iceVariance numeric(38,16) The percent variance from the required lbs of ice.

sandDesign numeric(38,16) The design lbs/cy of sand for the mix.

sandRequired numeric(38,16) The required (target) lbs of sand, based on the mix design and cubic yards.

sandBatched numeric(38,16) The actual (batched) lbs of sand in the batch.

sandVariance numeric(38,16) The percent variance from the required lbs of sand.

sandMoisture numeric(38,16) The percent moisture of the sand.

sandActWater numeric(38,16) The gallons of actual water of the sand.

no8Required numeric(38,16) The required (target) lbs of #8 (3/8 inch) aggregate, based on the mix design and cubic yards.

no8Batched numeric(38,16) The actual (batched) lbs of #8 (3/8 inch) aggreagate in the batch.

no8Variance numeric(38,16) The percent variance from the required lbs of #8 (3/8 inch) aggregate.

no8Moisture numeric(38,16) The percent moisture of the #8 (3/8 inch) aggregate.

no8ActWater numeric(38,16) The gallons of actual water of the #8 (3/8 inch) aggregate.

no67Required numeric(38,16) The required (target) lbs of #67 (3/4 inch) aggregate, based on the mix design and cubic yards.

no67Batched numeric(38,16) The actual (batched) lbs of #67 (3/4 inch) aggreagate in the batch.

no67Variance numeric(38,16) The percent variance from the required lbs of #67 (3/4 inch) aggregate.

no67Moisture numeric(38,16) The percent moisture of the #67 (3/4 inch) aggregate.

no67ActWater numeric(38,16) The gallons of actual water of the #67 (3/4 inch) aggregate.

no4Required numeric(38,16) The required (target) lbs of #4 (1.5 inch), based on the mix design and cubic yards.

no4Batched numeric(38,16) The actual (batched) lbs of #4 (1.5 inch)aggreagate in the batch.

no4Variance numeric(38,16) The percent variance from the required lbs of #4 (1.5 inch) aggregate.

no4Moisture numeric(38,16) The percent moisture of the #4 (1.5 inch) aggregate.

no4ActWater numeric(38,16) The gallons of actual water of the #4 (1.5 inch) aggregate.

s3InRequired numeric(38,16) The required (target) lbs of 3 inch aggregate, based on the mix design and cubic yards.

s3InBatched numeric(38,16) The actual (batched) lbs of 3 inch aggreagate in the batch.

s3InVariance numeric(38,16) The percent variance from the required lbs of 3 inch aggregate.

s3InMoisture numeric(38,16) The percent moisture of the 3 inch aggregate.

s3InActWater numeric(38,16) The gallons of actual water of the 3 inch aggregate.

cmtRequired numeric(38,16) The required (target) lbs of Type II cement, based on the mix design and cubic yards.

cmtBatched numeric(38,16) The actual (batched) lbs of Type II cement in the batch.

cmtVariance numeric(38,16) The percent variance from the required lbs of Type II cement.

flyAshRequired numeric(38,16) The required (target) lbs of fly…