Clearwater Analytics Data Requirements Bank Loans
Clearwater Data Requirements – Bank Loans Please contact your Clearwater representative to answer any questions regarding these guidelines.
File Transmission Requirements Please download the Clearwater Data Transmission Requirements for details on transmission options
Data Requirements for Bank Loans Clearwater’s third party pricing providers do not support bank loans (“bank loans” are frequently referred to as “syndicated loans” or “leveraged loans.”) For this reason, clients must supply pricing either through their custodial feed, a feed with their asset manager, or obtain a contract with WSO (“Wall Street Office” or “Markit”) which Clearwater can pull data from on behalf of the client. Similarly, Clearwater does not calculate accrued for bank loans. Clients may supply Clearwater with an accrued file (by position or contract). Otherwise, Clearwater will recognize income as it is received in the custodial account. The following table contains the full range of data fields used by Clearwater. The fields listed are critical to reconciliation and must be supplied before the data can be processed. All fields are requested and required field are notated. Please provide as much data as available to ensure accurate reporting. The left two tables comprise of the data needed on a daily basis, while the right table is data only needed at the time of implementation (Initial Load). Transactions Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Cancel/Rebook Indicator Contract Description
Holdings Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Accrual Day Count †‡ Accrued Balance (dollars) †‡
Initial Load Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Accrual Day Count †‡ Accrued Balance (dollars) as of Load Date ‡
Contract Identifier Counterparty ‡ Currency †‡ CUSIP †‡ Description of Activity †‡ Entry/Trade Date †‡ Facility Identifier †‡ Funded/ Unfunded Number of Units (Settled) †‡ Number of Units (Traded) †‡ Position ID
Amount Outstanding as of Date Contract Description Contract Identifier Convexity Coupon Frequency †‡ Coupon Rate †‡ Currency †‡ CUSIP †‡ DBRS Rating Description †‡ Duration
Amount Outstanding as of Load Date Book Value as of Load Date †‡ Contract Description Contract Identifier Counterparty ‡ Coupon Frequency †‡ Coupon Rate †‡ Currency †‡ CUSIP †‡ DBRS Rating Description †‡
1
Transactions Proceeds †‡ Reversed or Canceled Transaction ID Settle/Post Date †‡ Trade Price †‡ Transaction ID Transaction Type †‡ Type of Facility
Holdings Facility Identifier †‡ Fitch Rating
Initial Load Facility Identifier †‡ Fitch Rating
Funded/ Unfunded Issue Date †‡ Issuer †‡ Market Price †‡ Market Value †‡ Market Yield Maturity Date †‡ Moody’s Rating Next Coupon Reset Date Number of Units (Settled) †‡ Number of Units (Traded) †‡ Position ID S&P Rating Type of Facility
Funded/ Unfunded Issue Date †‡ Issuer †‡ Market Price as of Load Date †‡ Market Value as of Load Date †‡ Maturity Date †‡ Moody’s Rating Next Coupon Reset Date Number of Units (Settled) †‡ Number of Units (Traded) †‡ Original Entry/Trade Date †‡ Original Proceeds on Trade †‡ Original Settle/Post Date †‡ Original Trade Price †‡ Position ID S&P Rating Type of Facility
* Required for all files and should match between all files † Required for reporting ‡ Required for NAIC statements
Definitions/ Explanations of Terms
Accrued (in Dollars): Amount of Accrued earned for the day. If accrued cannot be provided, income will be accounted for on a cash basis. Amount Outstanding as of date: The amount of the loan outstanding CUSIP: 3rd party facility cusip which connects to 3rd party (typically Bloomberg, Reuters, etc.) We use this to set information like Financial Sector, etc. Commission: Any commission on the trade. Contract Description: Description of the Bank Loan Contract Identifier: The identifier associated with this contract. Coupon Frequency: Expected frequency of interest payments. Expected Values include: Quarterly, SemiAnnually, etc. Facility Identifier: The identifier associated with the facility of the bank loan Transaction Types: Buy, Sell, Cost of Carry, Delayed Compensation, Interest Income, Economic Benefit. Type of Facility: Type of facility. Expected types include Term Loan A, Term Loan B, …, Revolver, Delayed Draw, etc.
2
File Transmission Requirements Please download the Clearwater Data Transmission Requirements for details on transmission options
Data Requirements for Bank Loans Clearwater’s third party pricing providers do not support bank loans (“bank loans” are frequently referred to as “syndicated loans” or “leveraged loans.”) For this reason, clients must supply pricing either through their custodial feed, a feed with their asset manager, or obtain a contract with WSO (“Wall Street Office” or “Markit”) which Clearwater can pull data from on behalf of the client. Similarly, Clearwater does not calculate accrued for bank loans. Clients may supply Clearwater with an accrued file (by position or contract). Otherwise, Clearwater will recognize income as it is received in the custodial account. The following table contains the full range of data fields used by Clearwater. The fields listed are critical to reconciliation and must be supplied before the data can be processed. All fields are requested and required field are notated. Please provide as much data as available to ensure accurate reporting. The left two tables comprise of the data needed on a daily basis, while the right table is data only needed at the time of implementation (Initial Load). Transactions Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Cancel/Rebook Indicator Contract Description
Holdings Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Accrual Day Count †‡ Accrued Balance (dollars) †‡
Initial Load Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Accrual Day Count †‡ Accrued Balance (dollars) as of Load Date ‡
Contract Identifier Counterparty ‡ Currency †‡ CUSIP †‡ Description of Activity †‡ Entry/Trade Date †‡ Facility Identifier †‡ Funded/ Unfunded Number of Units (Settled) †‡ Number of Units (Traded) †‡ Position ID
Amount Outstanding as of Date Contract Description Contract Identifier Convexity Coupon Frequency †‡ Coupon Rate †‡ Currency †‡ CUSIP †‡ DBRS Rating Description †‡ Duration
Amount Outstanding as of Load Date Book Value as of Load Date †‡ Contract Description Contract Identifier Counterparty ‡ Coupon Frequency †‡ Coupon Rate †‡ Currency †‡ CUSIP †‡ DBRS Rating Description †‡
1
Transactions Proceeds †‡ Reversed or Canceled Transaction ID Settle/Post Date †‡ Trade Price †‡ Transaction ID Transaction Type †‡ Type of Facility
Holdings Facility Identifier †‡ Fitch Rating
Initial Load Facility Identifier †‡ Fitch Rating
Funded/ Unfunded Issue Date †‡ Issuer †‡ Market Price †‡ Market Value †‡ Market Yield Maturity Date †‡ Moody’s Rating Next Coupon Reset Date Number of Units (Settled) †‡ Number of Units (Traded) †‡ Position ID S&P Rating Type of Facility
Funded/ Unfunded Issue Date †‡ Issuer †‡ Market Price as of Load Date †‡ Market Value as of Load Date †‡ Maturity Date †‡ Moody’s Rating Next Coupon Reset Date Number of Units (Settled) †‡ Number of Units (Traded) †‡ Original Entry/Trade Date †‡ Original Proceeds on Trade †‡ Original Settle/Post Date †‡ Original Trade Price †‡ Position ID S&P Rating Type of Facility
* Required for all files and should match between all files † Required for reporting ‡ Required for NAIC statements
Definitions/ Explanations of Terms
Accrued (in Dollars): Amount of Accrued earned for the day. If accrued cannot be provided, income will be accounted for on a cash basis. Amount Outstanding as of date: The amount of the loan outstanding CUSIP: 3rd party facility cusip which connects to 3rd party (typically Bloomberg, Reuters, etc.) We use this to set information like Financial Sector, etc. Commission: Any commission on the trade. Contract Description: Description of the Bank Loan Contract Identifier: The identifier associated with this contract. Coupon Frequency: Expected frequency of interest payments. Expected Values include: Quarterly, SemiAnnually, etc. Facility Identifier: The identifier associated with the facility of the bank loan Transaction Types: Buy, Sell, Cost of Carry, Delayed Compensation, Interest Income, Economic Benefit. Type of Facility: Type of facility. Expected types include Term Loan A, Term Loan B, …, Revolver, Delayed Draw, etc.
2
