Touchstone 4.0 Database Documentation
tProgram Table
Description
Stores information regarding the collection of reinsurance contracts. A reinsurance program includes one or more related reinsurance contracts. The reinsurance applies to locations or layers, not to contracts.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows5
Data Space Used8.00 KB
Index Space Used72.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ProgramSIDUnique system-generated sequential identifier for the program record.Integer4   
 ProgramIDUser-defined identifier for the reinsurance program.VarChar100   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4 
((1))
 
 ProjectSID

Unique system-generated sequential identifier for the project record.

For a complete list of records, see tProject Table.

Integer4   
 DescriptionUser-provided description of the reinsurance program.VarChar4000  
 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 reinsurance program was created.DBTimeStamp4 
(getutcdate())
 
 EditedDateDate and time when the reinsurance program was last modified.DBTimeStamp4 
(getutcdate())
 
Objects that depend on tProgram
 Database ObjectObject TypeDescriptionDep Level
tProgramExposureViewXref tabletProgramExposureViewXrefTableSystem reference table used to identify the relationship between the program and exposure views.1
tReinsAppliesToGeo tabletReinsAppliesToGeoTableStores information regarding the geographic/area filter applied for the reinsurance treaty. Using reinsurance treaty geographic filter is optional.1
tReinsurance tabletReinsuranceTable

Stores information regarding the reinsurance treaty.

1
See Also

Related Objects

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