Stores the possible financial perspectives.
Stores the possible financial perspectives.
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 |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
![]() | FinancialPerspectiveCode | Code that represents the financial perspectives.
| 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.
| bit | 1 | ![]() | dbo.D_0 | ||
IsEPEnabled | Indicates whether the financial perspective can be displayed as an exceedance probability curve.
| 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.
| bit | 1 | ![]() | dbo.D_0 |
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)) |