tLossCustomFrequency Table

Description

This table stores information about the custom, user-defined custom event frequency during the loss analysis.

Custom Frequency template file allow the user to customize events that direct the Loss analysis engine to apply a specified events, AIR model, product, catalog, and event years directly to calculate the Ground-Up losses.

The loss engine scales the entire Ground-up distribution, not just the mean loss, and applies all policy conditions to the modified losses. It does not cap the modified losses at the total insurable value (TIV). Any custom event frequency modification that is applied to losses from a peril applies also to losses generated by the respective sub-perils.

Properties

Creation Date	4/4/2022 3:02 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Description	Datatype	Length	Default
LossCustomFrequencySID	Unique system-generated sequential identifier for the loss custom frequency template record.	int	4
BusinessUnitSID	Unique system-generated sequential identifier for the business unit record.	int	4
LossCustomFrequencyName	Name of the loss custom frequency.	varchar	255
FileName	User-provided input file name of the loss custom frequency.	varchar	255
YearMax	Maximum number of years in the catalog.	int	4
YearCount	Total number of simulated years in the catalog. Note that "year" in this context represent simulation years only and do not represent an actual date.	int	4
EventMax	Maximum number of simulated events in the catalog.	int	4
EventCount	Total number of simulated events in the catalog.	int	4
BaseName	Formatted name of the catalog.	varchar	100
CustomFrequencyFileTypeCode	Code that represents the custom frequency file type.	varchar	10
ModelCode	Code that represents the model in Touchstone. For a complete list of codes, see tModel table.	smallint	2
StatusCode	System-provided status code for the record in the table. For a complete list of codes, see tStatus Table.	varchar	10	('A')
ModelVersion	Version number of the model.	varchar	50
ProductVersion	Version number of the product.	varchar	50
IsBinaryImport	Indicates whether the imported custom frequency file is in the binary format. 1 = Yes 0 = No	bit	1	((0))
SortOrder	Order of appearance of the unit in any drop-down lists in the application.	int	4	((0))
Author	User that initiated the activity.	varchar	255
EnteredDate	Date and time when the activity was created.	datetime	4	(getutcdate())
EditedDate	Date and time when the activity was edited.	datetime	4	(getutcdate())
RowTimeStamp	Used for time stamping.	timestamp	8

Related Objects

AIRUserSetting Database