Touchstone 2022 Database Reference
tEXPS_ByTimeElementBand Table
AIRExposureSummary Database : tEXPS_ByTimeElementBand Table
Description

Stores the data displayed on the Exposure Summary Dashboard when "Per Diem- Distribution of Replacement Values by Per Diem Time Element" is selected from the View Options.

Properties
Creation Date4/11/2022 6:15 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

int4   
Primary Key Value that represents the per diem monetary value.smallint2   
 Description of the band.varchar255   
 

Total number of locations within the designated band.

bigint8  
 

Number of locations within the designated band, expressed as a percent of all the locations.

real4  
 

Accumulated replacement value for all locations.

float9  
 

Total combined replacement value for all locations within the designated band, expressed as a percent of the total replacement value.

real4  
 

Average replacement value of all locations within the designated band.

float9  
 

Highest replacement value of all locations within the designated band.

float9  
 

Lowest replacement value of all locations within the designated band.

float9  
 Accumulated  Coverage A replacement value for all locations within the designated band.float9  
 Accumulated  Coverage B replacement value for all locations within the designated band.float9  
 Accumulated  Coverage C replacement value for all locations within the designated band.float9  
 Accumulated  Coverage D replacement value for all locations within the designated band.float9  
 

Combined premiums for all locations within the designated band.

float9  
 

Total number of risks within the designated band. May differ from the Location Count value if any of your location records represent aggregate data.

bigint8  
 Accumulated Coverage A limit for all locations within the designated band.float9  
 Accumulated Coverage B limit for all locations within the designated band.float9  
 Accumulated Coverage C limit for all locations within the designated band.float9  
 Accumulated Coverage D limit for all locations within the designated band.float9  
 Accumulated Coverage A deductible amount for all locations within the designated band.float9  
 Accumulated Coverage B deductible amount for all locations within the designated band.float9  
 Accumulated Coverage C deductible amount for all locations within the designated band.float9  
 Accumulated Coverage D deductible amount for all locations within the designated band.float9  
See Also

Related Objects

AIRExposureSummary Database