Touchstone Re 2022 Database Reference
tAggregateDataType Table
AIRReference Database : tAggregateDataType Table
Description
Stores codes that represent the types of aggregate exposure data supported by the application.
Properties
Creation Date4/7/2017 3:39 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows12
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents a type of aggregate data.

  • CLF = Company Loss File
  • CUTSUMS = Custom Sums Insured
  • LMSSHARE = Loss Market Share
  • PAYROLL = Payroll
  • PGM = Program Specific
  • PREF = Preferred exposure
  • PREM = Premium
  • PREMALLOC = Premium Allocate
  • RATE = Rates
  • RISK = Number of Risks
  • SHARE = Market Shares
  • SUMS = Sums Insured
varchar10   
 

Name of the aggregate exposure data type.

varchar255  
 Description of the exposure data type.varchar1024  
 Enumeration that represents the aggregate exposure data type.int4  
See Also

Related Objects

AIRReference Database