Touchstone 4.0 Database Documentation
tContract Table
Description

Contains records for primary insurance policies.

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 ContractSIDUnique system-generated sequential identifier for the contract record.Integer4   
 ExposureSetSID

Unique system-generated sequential identifier for the exposure set record.

For a complete list of records, see tExposureSet Table

Integer4   
 ContractIDUnique user-defined identifier for the contract.VarChar100   
 ContractTypeCode

Code for the contract type.

For a complete list of codes, see tContractType Table.

VarChar10   
 SubmitStatusCode

Code for the submission status.

For a complete list of codes, see tSubmitStatus Table.

VarChar10   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3   
 InceptionDateInception date of the contract.  Also referred to as the Effective FROM Date.VarWChar10   
 ExpirationDateContract expiration date. Also referred to as the Effective TO Date.VarWChar10   
 UserLineOfBusinessName of the user line of business.VarChar60  
 PolicyFormUser-defined policy.VarChar60  
 InsuredNameClient's name.VarChar60  
 ProducerNameName of the producer of the contract.VarChar60  
 UnderwriterName of the underwriter of the contract.VarChar60  
 BranchName of the branch.VarChar60  
 ExpiringContractIDUnique user-defined identifier for the expiring contract.VarChar100  
 StatusCode

System-provided status code for the record in the table.

For a complete list of codes, see tStatus Table.

VarChar10 
('A')
 
 EnteredDateDate and time when the contract was created.DBTimeStamp4 
(getutcdate())
 
 EditedDateDate and time when the contract was last modified.DBTimeStamp4 
(getutcdate())
 
 UserDefined1User-defined field 1.VarChar60  
 UserDefined2User-defined field 2.VarChar60  
 UserDefined3User-defined field 3.VarChar60  
 UserDefined4User-defined field 4.VarChar60  
 UserDefined5User-defined field 5.VarChar60  
 EnteredByName of the person who entered the contract.VarChar255  
 EditedByName of the person who modified the contract.VarChar255  
 RowVersionUsed for version stamping.Binary8   
Objects that depend on tContract
 Database ObjectObject TypeDescriptionDep Level
tEngineLocPhysicalProperty tabletEngineLocPhysicalPropertyTableStore information about the location's physical properties that were calculated by the engine.1
tLayer tabletLayerTable

Contains primary contract layer information.

2
tLayerCondition tabletLayerConditionTable

Contains layer conditions, such as sublimit and policy restrictions.  Note that sublimit belongs to a layer and is usually associated with a filter criteria, such as specific group of locations or perils.

1
tLayerConditionLocationXref tabletLayerConditionLocationXrefTable

System reference table used to map the location to the layer condition.

1
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
tLocFeature tabletLocFeatureTable

Contains detailed building information, including secondary risk characteristics.

1
tLocOffshore tabletLocOffshoreTable

Contains risk characteristics for each offshore location.

1
tLocParsedAddress tabletLocParsedAddressTableContains street-level address details for each location.1
tLocStepFunctionXref tabletLocStepFunctionXrefTableSystem reference table used to determine the step functions that are associated with a location.1
tLocTerm tabletLocTermTable

Contains information about location terms.

1
tLocWC tabletLocWCTable

Contains information about the workers' compensation details for the location.

1
tStepFunction tabletStepFunctionTableContains general information for each step function SID, including the contract in which the step function is used.1
tStepFunctionDetail tabletStepFunctionDetailTableContains detailed information for each step function SID.1
Objects that tContract depends on
 Database ObjectObject TypeDescriptionDep Level
tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
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.