Touchstone 4.0 Database Documentation
tLocStepFunctionXref Table
Description
System reference table used to determine the step functions that are associated with a location.
Properties
Creation Date5/31/2016 9:46 AM
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 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
Primary Key StepFunctionSID

Unique system-generated sequential identifier for the step function record.

For a complete list of records, see tStepFunction Table.

Integer4   
 RowVersionUsed for version stamping.Binary8   
Objects that tLocStepFunctionXref depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tLocation tabletLocationTable

Contains geographical attributes and primary risk characteristics for each location. It serves as a reference point between Location and Contract entities.  All locations entities are tied together by the same Location SID.

1
tStepFunction tabletStepFunctionTableContains general information for each step function SID, including the contract in which the step function is used.1
See Also

Related Objects

AIRExposure Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

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