Touchstone 4.0 Database Documentation
tFinancialPerspective Table
Description

Stores the possible financial perspectives.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows24
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key FinancialPerspectiveCode

Code that represents the financial perspectives.

  • CC = Claims Count
  • EMP = Employees
  •  EMPD = DayShiftEmployees
  • EMPE = EveningShiftEmployees
  • EMPN = NightShiftEmployees
  • GR = Gross
  • GU = Ground-up
  • IC = Injury Count
  • IRER = Individual Reinsurance Recovery
  • LOC = Locations
  • NT = Net of Pre-CAT
  • PG = Pre-layer gross
  • POST = Post-CAT Net
  • REI = TotalPerRiskReRecovery
  • RSK = Risks
  • RT = Retained
  • RVA = Replacement Value A
  • RVB = Replacement Value B
  • RVC = Replacement Value C
  • RVD = Replacement Value D
  • TCRER = Total CAT Reinsurance Recovery
  • TRER = Total Reinsurance Recovery
  • TRRER = Total Risk Reinsurance Recovery
  • TRV = Total Replacement Value
VarChar10   
 FinancialPerspective

Name of the financial perspectives.

Corresponds to the code in FinancialPerspectiveCode.

VarChar40  
 Description

Description of the financial perspectives.

VarChar1024  
 IsDetailedLoss

Indicates whether the financial perspective is considered in a Loss analysis.

  • 1 = Yes (considered)
  • 0 = No (not considered)
Boolean1dbo.D_0 
 IsEPEnabled

Indicates whether the financial perspective can be displayed as an exceedance probability curve.

  • 1 = Yes (displayable)
  • 0 = No (not displayable)
Boolean1dbo.D_0 
 FinancialPerspectiveLoss

Name of the loss type for the specific financial perspective.

VarWChar128  
 FinancialPerspectiveMax

Name of the max loss for the specific financial perspective. Max loss is not available if the column is null.

VarWChar128  
 FinancialPerspectiveSD

Name of the standard deviation for the specific financial perspective. Standard deviation is not available if the column is null.

VarWChar128  
 IsExposedLimit

Indicates whether the financial perspective is available for a Geospatial analysis.

  • 1 = Yes (available
  • 0 = No (not available)
Boolean1dbo.D_0 
Check Constraints
NameDescriptionExpression
CKC_ISDETAILEDLOSS_TFINANCI 
([IsDetailedLoss] IS NULL OR [IsDetailedLoss]>=(0) AND [IsDetailedLoss]<=(1))
CKC_ISEPENABLED_TFINANCI 
([IsEPEnabled] IS NULL OR [IsEPEnabled]>=(0) AND [IsEPEnabled]<=(1))
CKC_ISEXPOSEDLIMIT_TFINANCI 
([IsExposedLimit] IS NULL OR [IsExposedLimit]>=(0) AND [IsExposedLimit]<=(1))
See Also

Related Objects

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