Guidelines for Data Consistency with Property-Specific Database

The following tables describe how Data Quality Augment defines consistency of data with data in the AIR Property-specific database (PSD). Augment does not generate consistency statistics for all fields, such as for latitude, longitude, building replacement value, and gross area; if the data is inconsistent, Augment updates it.

Table 1. General
PSD Attribute	How Augment Defines Consistency
Construction	Is in the same general category, as specified in the construction categories listed in the Benchmark diagnostic
Occupancy	Is in the same general category, as specified in the occupancy categories listed in the Benchmark diagnostic.
Year Built	Exactly matches year built in the PSD.
Stories	Exactly matches stories in the PSD.

Table 2. Roof Geometry
Client Value	Client Description	Consistent PSD Values
1	Flat	1
2	Gable end without bracing	2 or 8
3	Hip	3
4	Complex	4
5	Stepped	5
6	Shed	6
7	Mansard	7
8	Gable end with bracing	2 or 8
9	Pyramid	9
10	Gambrel	10

Table 3. Roof Cover
Client Value	Client Description	Consistent PSD Values
1	Asphalt shingles	1
2	Wooden shingles	2
3	Clay or concrete tiles	3
4	Light metal panels	4
5	Slate	5
6	Built-up roof with gravel	6 or 9
7	Single-ply membrane	7 or 10
8	Standing-seam metal roof	8
9	Built-up roof without gravel	6 or 9
10	Single-ply membrane ballasted	7 or 10
11	Hurricane wind rated roof coverings	Not applicable. Since Augment never replaces roof covering 11, it excludes them from augmentation. There are no "11" values in the PSD.

Table 4. Wall Siding
Client Value	Client Description	Consistent PSD Values
1	Veneer brick/masonry	1
2	Wood shingles	2
3	Clapboard	3
4	Aluminum or vinyl siding	4
5	Stone panels	5
6	Exterior insulation finishing system	6
7	Stucco	7

Table 5. Foundation
Client Value	Client Description	Consistent PSD Values
1	Masonry basement	1 or 2
2	Concrete basement	1 or 2
4	Crawlspace - cripple wall (wood)	4, 5, or 12
5	Crawlspace - masonry (wood)	4, 5, or 12
6	Post & pier	6
7	Footing	7
8	Mat or slab	8
9	Pile	9
10	No basement	10
11	Engineering foundation	11
12	Crawlspace - raised (wood)	4, 5, or 12