Understanding the CEDE Format, Touchstone 4.0
tContract Table

Contains records for primary insurance policies.

Creation Date5/31/2016 9:46 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ContractSIDUnique system-generated sequential identifier for the contract record.int4   

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

For a complete list of records, see tExposureSet Table

 ContractIDUnique user-defined identifier for the contract.varchar100   

Code for the contract type.

For a complete list of codes, see tContractType Table.


Code for the submission status.

For a complete list of codes, see tSubmitStatus Table.


Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.


ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

 InceptionDateInception date of the contract.  Also referred to as the Effective FROM Date.date10   
 ExpirationDateContract expiration date. Also referred to as the Effective TO Date.date10   
 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  

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

For a complete list of codes, see tStatus Table.

 EnteredDateDate and time when the contract was created.datetime4 
 EditedDateDate and time when the contract was last modified.datetime4 
 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.timestamp8   
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.

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.

tLayerConditionLocationXref tabletLayerConditionLocationXrefTable

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

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.

tLocFeature tabletLocFeatureTable

Contains detailed building information, including secondary risk characteristics.

tLocOffshore tabletLocOffshoreTable

Contains risk characteristics for each offshore location.

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.

tLocWC tabletLocWCTable

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

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



© 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.