tReinsuranceProgram Table

Description

Stores information about reinsurance programs.

Properties

Creation Date	4/11/2022 6:17 PM
File Group	PRIMARY
Text File Group	PRIMARY
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
ReinsuranceProgramSID	Unique system-generated sequential identifier for the reinsurance program.	int	4
ProjectSID	Not used by Touchstone Re.	int	4
CompanySID	Unique system-generated sequential identifier for the company associated with the program. For a complete list of records, see tCompany Table.	int	4
ProgramID	User-specified identifier of the reinsurance program.	varchar	100
BusinessUnitSID	Unique system-generated identifier for the business unit associated with the reinsurance program.	int	4
Description	User-specified description of the reinsurance program.	varchar	4000
StatusCode	Code that represents the system-provided status for the reinsurance program. For a complete list of codes, see tStatus Table.	varchar	10
EnteredDate	Date and time the reinsurance program was created.	datetime	4
EditedDate	Date and time the reinsurance program was last edited.	datetime	4
InceptionDate	Inception date of the reinsurance program, which is also referred to as the Effective From date.	date	8
ExpirationDate	Expiration date of the reinsurance program, which is also referred to as the Effective To date.	date	8
CurrencyCode	ISO 3-character code for the currency associated with the reinsurance program. For a complete list of codes, see tCurrency Table.	char	3
LossModificationFactor	User-specified factor used to modify losses in the reinsurance program.	float	9
IsAssessmentProgram	Indicates whether the reinsurance program is an assessment program. You can use an assessment program during a loss analysis. Touchstone Re passes the program’s aggregated losses through the contract structure of the program. 1 = Yes (assessment program) 0 = No (not assessment program)	bit	1
IsProgramLossAdjustmentOn	Indicates whether the program loss adjustment is used. 1 = Yes (used) 0 = No (not used)	bit	1
IsLossMarketShare	Indicates whether the loss market share is used. 1 = Yes (used) 0 = No (not used)	bit	1
IsCustomLOBOn	Indicates whether a custom line of business is used. 1 = Yes (used) 0 = No (not used)	bit	1
CoversAgriculture	Indicates whether the reinsurance program covers agricultural losses. 1 = Yes (covered) 0 = No (not covered)	float	9	((100.00))
CoversWC	Indicates whether the reinsurance program covers workers' compensation. 1 = Yes (covered) 0 = No (not covered)	float	9	((100.00))
CoversOffshorePD	Indicates whether the reinsurance program covers offshore physical damage (PD) loss. 1 = Yes (covered) 0 = No (not covered)	float	9	((0))
CoversOffshoreRod	Indicates whether the reinsurance program covers offshore removal of debris (ROD) loss. 1 = Yes (covered) 0 = No (not covered)	float	9	((0))
CoversOffshoreOee	Indicates whether the reinsurance program covers operator's extra expenses (OEE) loss. 1 = Yes (covered) 0 = No (not covered)	float	9	((0))
CoversOffshoreBI	Indicates whether the reinsurance program covers offshore business interruption (BI) loss. 1 = Yes (covered) 0 = No (not covered)	float	9	((0))
CoversForestry	Indicates whether the reinsurance program covers forestry losses. 1 = Yes (covered) 0 = No (not covered)	float	9	((100.00))
CoversCustomLOB	Indicates whether the reinsurance program covers user-defined, custom lines of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((0.0))
CoversResidential	Indicates whether the reinsurance program covers residential losses. 1 = Yes (covered) 0 = No (not covered)	float	9	((100.00))
CoversCommercial	Indicates whether the reinsurance program covers commercial losses. 1 = Yes (covered) 0 = No (not covered)	float	9	((100.00))
CoversAuto	Indicates whether the reinsurance program covers auto losses. 1 = Yes (covered) 0 = No (not covered)	float	9	((100.00))
PreferredExposureTypeCode	Code that indicates the preferred exposure type for the reinsurance. For a complete list of codes, see tExposureType Table.	varchar	10
IsDemandSurgeOn	Indicates whether demand surge is applied for the reinsurance program. 1 = Yes (applied) 0 = No (not applied)	bit	1
IsInuringProgramAttached	Indicates whether an inuring program is applied. 1 = Yes (applied) 0 = No (not applied)	bit	1
IsContractGainOn	Indicates whether the contract hedges portfolio losses from reinsurance treaty and catastrophe bond contracts against contracts that have been flagged as resulting in gain to the portfolio. 1 = Yes (applied) 0 = No (not applied)	bit	1
CurrencyExchangeRateSetSID	Unique system-generated sequential identifier for the exchange rate set associated with the reinsurance program. For a complete list of records, see tCurrencyExchangeRateSet Table.	int	4
ReinsuranceTypeCode	Code that indicates the type of reinsurance. For a complete list of codes, see tReinsuranceType Table.	varchar	10
Author	User that created the reinsurance program.	varchar	255
DisplayCurrencyCode	ISO 3-character code for the currency used to display information for the reinsurance program. For a complete list of codes, see tCurrency Table.	varchar	3
UnitCode	Code for the unit used to express monetary amounts in the reinsurance program. For a complete list of codes, see tUnit Table.	varchar	10
EPAdjustmentComment	Comment about the EP adjustments specified for the program.	varchar	8000
CoversChinaMPCICorn	Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Corn line of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((1))
CoversChinaMPCICotton	Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Cotton line of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((1))
CoversChinaMPCIRapeSeed	Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Rapeseed line of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((1))
CoversChinaMPCIRice	Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Rice line of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((1))
CoversChinaMPCISoybeen	Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Soybean line of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((1))
CoversChinaMPCIWheat	Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Wheat line of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((1))
CoversChinaMPCICropCombined	Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Crop Combined line of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((1))
CoversChinaMPCIForestry	Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Forestry line of business. 1 = Yes (covered) 0 = No (not covered)	float	9	((1))
CREPSLayout	XML expression that defines the layout of the reinsurance program. Used internally by Touchstone Re.	xml	0

Objects that depend on tReinsuranceProgram

Database Object	Object Type	Description	Dep Level
tAppliesToEventFilter	Table	Stores information about event filters. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas.	1
tAppliesToEventFilterGeoXRef	Table	Stores information about event filters that include geographic areas. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas.	2
tAppliesToEventFilterLatLong	Table	Stores information about event filters that include latitude and longitude pairs. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas.	2
tAppliesToEventFilterRule	Table	Stores information about event filters that include event parameters, such as earthquake depth or hurricane central pressure. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas.	2
tCatBondAttributeValue	Table	Stores information about catastrophe bond reinsurance programs, for example, the sponsor and covered perils.	1
tReinsuranceProgramSourceInure	Table	Stores information about the sourcing and inuring relationships between reinsurance programs.	1
tReinsuranceProgramTargetXRef	Table	Stores the company loss file (CLF) set or CLF set and exposure set combination specified as the target of each reinsurance program.	1
tReinsuranceTreaty	Table	Stores information about reinsurance treaties included in reinsurance programs.	1
tReinsuranceTreatyReinstatement	Table	Stores information about reinstatement treaties included in reinsurance programs.	1
tReinsuranceTreatyTerrorismOption	Table	Stores information about the terrorism coverage for each reinsurance treaty.	1
tReinsuranceTreatyUDCClassification_Xref	Table	Stores relationships between user-defined categories (UDCs) and reinsurance treaties.	1

Objects that tReinsuranceProgram depends on

	Database Object	Object Type	Description	Dep Level
	tCompany	Table	Stores information about companies.	3

Related Objects

AIRExposureRe Database