tFinancialPerspective Table

Description

Stores the possible financial perspectives.

Properties

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	57
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

Column Name	Description	Datatype	Length	Default
FinancialPerspectiveCode	Code that represents the financial perspectives. CC = Claims Count CGU = Company Pre-Catastrophe CNT = Company Net Retained COMP = Company CON = Contract EMP = Employees EMPD = DayShiftEmployees EMPE = EveningShiftEmployees EMPN = NightShiftEmployees FC1 = Final Net Participation 3 FC2 = Final Net Participation 4 FGR = Final Net Gross FGU = Final Net 100 Percent Participation FNET = Final Net FNT = Final Net Net Participation GR = Gross GU = Ground-up IC = Injury Count IRER = Individual Reinsurance Recovery LOC = Locations NETR = Net Retained NT = Net of Pre-CAT PG = Pre-layer gross POST = Post-CAT Net REI = TotalPerRiskReRecovery RIC1 = Reinsurance Contract Participation 3 RIC2 = Reinsurance Contract Participation 4 RIGR = Reinsurance Contract Gross Participation RIGU = Reinsurance Contract 100 Percent Participation RINT = Reinsurance Contract Net Participation 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	varchar	10
FinancialPerspective	Name of the financial perspectives. Corresponds to the code in FinancialPerspectiveCode.	varchar	40
Description	Description of the financial perspectives.	varchar	1024
IsDetailedLoss	Indicates whether the financial perspective is considered in a Loss analysis. 1 = Yes (considered) 0 = No (not considered)	bit	1	dbo.D_0
IsEPEnabled	Indicates whether the financial perspective can be displayed as an exceedance probability curve. 1 = Yes (displayable) 0 = No (not displayable)	bit	1	dbo.D_0
FinancialPerspectiveLoss	Name of the loss type for the specific financial perspective.	sysname	128
FinancialPerspectiveMax	Name of the max loss for the specific financial perspective. Max loss is not available if the column is null.	sysname	128
FinancialPerspectiveSD	Name of the standard deviation for the specific financial perspective. Standard deviation is not available if the column is null.	sysname	128
IsExposedLimit	Indicates whether the financial perspective is available for a Geospatial analysis. 1 = Yes (available 0 = No (not available)	bit	1	dbo.D_0

Check Constraints

Name	Description	Expression
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))

Name

Description

Expression

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))

Related Objects

AIRReference Database