tISValue Table

Description

Stores codes that represent measurements of the total seismic performance of a building. The measurements account for all characteristics that affect the response of a building to an earthquake.

The codes are used in the tLocFeature Table.

Properties

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	10
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

Column Name	Description	Datatype	Length
ISValueCode	Code that represents the measurement value. 0 Unknown/default 1 = Less than 0.3 2 = 0.3 - 0.45 3 = 0.45 - 0.55 4 = 0.55 - 0.65 5 = 0.65 - 0.75 6 = 0.75 - 0.85 7 = 0.85 - 1.0 8 = 1.0 - 1.25 9 = Greater than 1.2	tinyint	1
ISValue	Value of the code. Corresponds to the code in ISValueCode.	varchar	40
Description	Description of the code.	varchar	1024

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ISValueCode

Code that represents the measurement value.

0 Unknown/default
1 = Less than 0.3
2 = 0.3 - 0.45
3 = 0.45 - 0.55
4 = 0.55 - 0.65
5 = 0.65 - 0.75
6 = 0.75 - 0.85
7 = 0.85 - 1.0
8 = 1.0 - 1.25
9 = Greater than 1.2

tinyint

ISValue

Value of the code.

Corresponds to the code in ISValueCode.

varchar

Description

Description of the code.

varchar

1024

Related Objects

AIRReference Database

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.