Connection Setting

The Connection Setting table lists information about the B-book trades. The fields for the Connection Setting table are:

Table Name: ConnectionSetting

Column Name	Data Type	Valid Values	Allow Nulls	Description
PK_ConnSettingID	int identity		No
FK_ConnID	int		No
BrokerCalculationTime	varchar	('23:59')	No
DateOfSnapShot	int		Yes
TimeOfSnapShot	varchar		Yes
MgmtFeeDateOfSnapShot	int		Yes
MgmtFeeTimeOfSnapShot	varchar		Yes
FixedFeeDateOfSnapShot	int		Yes
PerformanceFeeDateOfSnapShot	int		Yes
SubscriptionFeeDateOfSnapShot	int		Yes
IsEquityForManagement	int	((0))	No
IsEquityForPerformance	int	((0))	No
IsFeeDeducted	int	((1))	No
LastUpdatedTime	datetime	(getutcdate())	Yes	The time when the last update took place.
BrokerTimeZone	varchar	('00:00')	Yes
MinimumAcceptableReturn	decimal	((3))	Yes