Perform SVO Data Maintenance

In the Edit SVO Codes panel, you can change the SVO NAIC category information for a security for a specific effective date, and query a history of code changes for a specific date range. You can also change the RMBS Eligibility election for a security. You can use the List SVO Codes panel to display the historical SVO information for a security.

To post SVO category codes for a security, for a given effective date:

  1. In Accounting Center, in the left navigation pane, click Insurance > NAIC Data > SVO Codes > Edit SVO Codes.
    You see the Edit SVO Codes panel.

  2. Complete the options on the panel.

  3. Click Submit.
    The system updates the information in the SECURITYDBO.NAIC and NAIC_HIST tables and then pushes it to the ISTAR.ISTAR_XREFERENCE table via the Insurance Refresh process.

Edit SVO Codes Panel Options

The Edit SVO Codes panel has three sections:

  • Change By Issue Security. Specifies the lookup information for the security to update, and the effective date for the information posted.

  • Change SVO Codes. Specifies the SVO codes and RMBS information to use, as of the effective date.

  • Issue Identification. Displays information about the security, allowing you to verify that you are updating the correct record.

The following table describes each option on the panel.

Option

Description

Option

Description

Change By Issue Security



LOOKUP fields

Allows you to enter the information required to uniquely locate the SMF record for update. Options include:

  • Lookup Issue Name

  • Lookup Issue Description

  • Lookup Ticker

  • Lookup Xref Security ID (preferred)

Effective Date

Specifies the effective date of the SVO and RMBS information posted. Fields are maintained in the SECURITYDBO.NAIC_HIST table and used for statutory accounting and reporting purposes during the ISTAR Refresh/Valuation process, when the effective date is less than or equal to the ISTAR Refresh/Valuation Month End Date.

NOTE: When you change the RMBS Eligibility information for existing securities, you must set the Effective Date to a date less than or equal to the initial acquisition date of the security.

Change SVO Codes



Schedule BA

Indicates whether the Schedule BA Category and BA Type and Strategy may be assigned. Options include:

  • No. Default. The panel displays the Category field for data entry. It may display the Subcategory and RMBS Eligible fields based on the processing security type of the security you are editing.

  • Yes. The panel displays the Schedule BA Category and BA Type and Strategy fields for data entry.

Category

Specifies the Securities Valuation Office category for the security. To use this field, you must set the Schedule BA field to No. Options include:

  • US Governments – 10

  • Other Governments – 15

  • States – 20

  • Political Subs – 30

  • Special Revenue – 40

  • Industrial & Misc – 60

  • Hybrid Securities – 75

  • Parent Subs & Affiliates – 80

  • ETF Identified by SVO – 81

  • Bond MF Identified by SVO – 82

  • Exempt Money Mkts – 85

  • All Other Money Mkt MF – 90

  • Mutual Funds – 91

  • Money Mkt Mutual Funds – 92

  • Other Short-Term – 95

  • Sweep Accounts – 96

  • Other Cash Equivalents – 97

Subcategory

Specifies the Securities Valuation Office subcategory for the security. To use this field, you must set the Schedule BA field to No. Options include:

  • Issuer Obligations – G1

  • Residential Mortgage-Backed Securities –G2

  • Commercial Mortgage-Backed Securities – G3

  • Other Loan-Backed and Structured Securities – G4

  • Clear

RMBS Eligible

Identifies the Residential Mortgage-Backed Security eligibility flag. Securities identified as qualifying loan-backed securities must have the RMBS Eligible field set to RMBS/CMBS or Other loan-backed structured securities. When you change existing securities, the Effective Date must synchronize with the date when RMBS processing takes effect. Options include:

  • RMBS/CMBS. R.

  • Other Loan-Backed Structured Securities. L. 

  • No. N. Default. 

NOTE: During the ISTAR Refresh process, specific processing occurs to assign Statement Value and the NAIC Designation for RMBS eligible securities.

Schedule BA Category

Specifies the Securities Valuation Office category for the security. To use this field, you must set the Schedule BA field to Yes. Options include:

  • Oil and Gas Production - Unaffiliated (101)

  • Oil and Gas Production - Affiliated (102)

  • Transportation Equipment - Unaffiliated (103)

  • Transportation Equipment - Affiliated (104)

  • Mineral Rights - Unaffiliated (105)

  • Mineral Rights - Affiliated (106)

  • Fixed or Var Int Rates - Bonds - Unaffiliated (107)

  • Fixed or Var Int Rates - Bonds - Affiliated (108)

  • Fixed or Var Int Rates - Mortgage Loans - Unaffiliated (109)

  • Fixed or Var Int Rates- Mortgage Loans - Affiliated (110)

  • Fixed or Var Int Rates - Other Fixed Income Instruments - Unaffiliated (111)

  • Fixed or Var Int Rates - Other Fixed Income Instruments - Affiliated (112)

  • JV Partnership or LLC Interests - Fixed Income Instruments - Unaffiliated (113)

  • JV Partnership or LLC Interests - Fixed Income Instruments - Affiliated (114)

  • JV Partnership or LLC Interests - Common Stocks - Unaffiliated (115)

  • JV Partnership or LLC Interests - Common Stocks - Affiliated (116)

  • JV Partnership or LLC Interests - Real Estate - Unaffiliated (117)

  • JV Partnership or LLC Interests - Real Estate - Affiliated (118)

  • JV Partnership or LLC Interests -Mortgage Loans - Unaffiliated (119)

  • JV Partnership or LLC Interests -Mortgage Loans - Affiliated (120)

  • JV Partnership or LLC Interests - Other - Unaffiliated (121)

  • JV Partnership or LLC Interests - Other - Affiliated (122)

  • Surplus Debentures etc. - Unaffiliated (123)

  • Surplus Debentures etc. - Affiliated (124)

  • Collateral Loans - Unaffiliated (125)

  • Collateral Loans - Affiliated (126)

  • Non-collateral Loans - Unaffiliated (127)

  • Non-collateral Loans - Affiliated (128)

  • Capital Notes - Unaffiliated (129)

  • Capital Notes - Affiliated (130)

  • Guaranteed Federal Low Income housing Tax Credit - Unaffiliated (131)

  • Guaranteed Federal Low Income housing Tax Credit - Affiliated (132)

  • Non-Guaranteed Federal Low Income housing Tax Credit - Unaffiliated (133)

  • Non-Guaranteed Federal Low Income housing Tax Credit - Affiliated (134)

  • Guaranteed State Low Income Housing Tax Credit - Unaffiliated (135)

  • Guaranteed State Low Income Housing Tax Credit - Affiliated (136)

  • Non-Guaranteed State Low Income Housing Tax Credit - Unaffiliated (137)

  • Non-Guaranteed State Low Income Housing Tax Credit - Affiliated (138)

  • All Other Low Income housing Tax Credit - Unaffiliated (139)

  • All Other Low Income housing Tax Credit - Affiliated (140)

  • Working Capital Finance Investment- Unaffiliated (141)

  • Any Other Class of Assets - Unaffiliated (142)

  • Any Other Class of Assets - Affiliated (143)

BA Type and Strategy

Specifies the Type and strategy for the security. To use this field, you must set the Schedule BA field to Yes. Options include:

  • Private equity: Venture capital – 1

  • Private equity: Mezzanine financing – 2

  • Private Equity: LBOs – 3

  • Hedge Fund: Global macro – 4

  • Hedge Fund: Long/short equity – 5

  • Hedge Fund: Merger arbitrage – 6

  • Hedge Fund: Fixed income arbitrage – 7

  • Hedge Fund: Convertible arbitrage – 8

  • Hedge fund: Futures/Options/foreign exchange arbitrage – 9

  • Hedge fund: Sector investing – 10

  • Hedge fund: Distressed securities – 11

  • Hedge fund: Emerging markets – 12

  • Hedge fund: Multi-strategy – 13

BA Property Type

Specifies the Property Type that applies only to Schedule BA Codes 109, 110, 117, 118, 119, 120. Options Include:

  • Office

  • Retail

  • Apartment/Multi-Family

  • Industrial

  • Medical/Health Care

  • Mixed Use

  • Lodging

  • Other

Issue Identification



Identification fields

Displays several identification fields after a successful database retrieval using one or more of the LOOKUP fields above, allowing you to verify that the panel is updating the correct security. Options include:

  • Issue Name

  • Issue Description

  • Ticker

  • Primary Asset ID

  • Security Alias

  • Processing Security Type

Â