Field

Data Type

Description

Des_Cond_Key

Char(10)

Unique key for a management section

Date of Inspection

Date

Date of the inspection

Inspection Unit Number

Char(2)

Number of inspection units

No Distress

Char(1)

Identifies whether this inspection unit has no distresses. -1 = no distresses, 0 or blank = has distresses

Special, Area of Inspection

Char(1)

Identifies whether this inspection unit is a special. -1 = special, 0 or blank = not a special

Distress Type Key 1

Char(10)

Unique key for this distress (see table below)

Severity Key 1

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 1

Number

Distress area size or quantity of distress

Distress Type Key 2

Char(10)

Unique key for this distress (see table below)

Severity Key 2

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 2

Number

Distress area size or quantity of distress

Distress Type Key 3

Char(10)

Unique key for this distress (see table below)

Severity Key 3

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 3

Number

Distress area size or quantity of distress

Distress Type Key 4

Char(10)

Unique key for this distress (see table below)

Severity Key 4

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 4

Number

Distress area size or quantity of distress

Distress Type Key 5

Char(10)

Unique key for this distress (see table below)

Severity Key 5

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 5

Number

Distress area size or quantity of distress

Distress Type Key 6

Char(10)

Unique key for this distress (see table below)

Severity Key 6

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 6

Number

Distress area size or quantity of distress

Distress Type Key 7

Char(10)

Unique key for this distress (see table below)

Severity Key 7

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 7

Number

Distress area size or quantity of distress

Distress Type Key 8

Char(10)

Unique key for this distress (see table below)

Severity Key 8

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 8

Number

Distress area size or quantity of distress

Distress Type Key 9

Char(10)

Unique key for this distress (see table below)

Severity Key 9

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 9

Number

Distress area size or quantity of distress

Distress Type Key 10

Char(10)

Unique key for this distress (see table below)

Severity Key 10

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 10

Number

Distress area size or quantity of distress

Distress Type Key 11

Char(10)

Unique key for this distress (see table below)

Severity Key 11

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 11

Number

Distress area size or quantity of distress

Distress Type Key 12

Char(10)

Unique key for this distress (see table below)

Severity Key 12

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 12

Number

Distress area size or quantity of distress

Distress Type Key 13

Char(10)

Unique key for this distress (see table below)

Severity Key 13

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 13

Number

Distress area size or quantity of distress

Distress Type Key 14

Char(10)

Unique key for this distress (see table below)

Severity Key 14

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 14

Number

Distress area size or quantity of distress

Distress Type Key 15

Char(10)

Unique key for this distress (see table below)

Severity Key 15

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 15

Number

Distress area size or quantity of distress

Distress Type Key 16

Char(10)

Unique key for this distress (see table below)

Severity Key 16

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 16

Number

Distress area size or quantity of distress

Distress Type Key 17

Char(10)

Unique key for this distress (see table below)

Severity Key 17

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 17

Number

Distress area size or quantity of distress

Distress Type Key 18

Char(10)

Unique key for this distress (see table below)

Severity Key 18

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 18

Number

Distress area size or quantity of distress

Distress Type Key 19

Char(10)

Unique key for this distress (see table below)

Severity Key 19

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 19

Number

Distress area size or quantity of distress

Distress Type Key 20

Char(10)

Unique key for this distress (see table below)

Severity Key 20

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 20

Number

Distress area size or quantity of distress

Distress Type Key 21

Char(10)

Unique key for this distress (see table below)

Severity Key 21

Char(10)

Unique key for severity of this distress (see table below)

Distress Area 21

Number

Distress area size or quantity of distress

Distress Type Key

Description

SYS0000001

Alligator Cracking

SYS0000002

Block Cracking

SYS0000003

Distortions

SYS0000004

Long. &  Trans. Cracking

SYS0000005

Patch & Util. Cut Patch

SYS0000006

Rutting/Depression

SYS0000007

Weathering & Ravelling

SYS0000008

Corner Break

SYS0000009

Divided Slab

SYS0000010

Faulting

SYS0000011

Linear Cracking

SYS0000012

Patching & Utility Cuts

SYS0000013

Scaling/Map Cracking/Crazing

SYS0000014

Spalling

Severity Key

Description

SYS0000001

High

SYS0000002

Medium

SYS0000003

Low