Create the NAIC Designation for a SVO Company Code and Security

In the Create NAIC Designation panel, you can enter the designations for an SVO Company Code and a security. You can change the Selection Type to Client, and the panel looks up the corresponding SVO Company Code which will be used to store within the ISTAR tables the NAIC security designation entered. Additional options are available to Edit, Delete, and List NAIC Designation information.

You can also load this information using batch uploaders and message center streams. The system stores the designation information by source (tag 1102). You can also use the eagle_default_in_fixed_naic message center stream to load designations.

To add an NAIC Designation for a SVO Company Code and security:

In Accounting Center, in the left navigation pane, click Insurance > NAIC Data > Designations > Create NAIC Designation.
You see the Create NAIC Designation panel.
In the NAIC Rating Type list, select Security, the default value.
See the following figure.
Complete the options on the panel.
Click Submit.
The NAIC designation information for the SVO company code/security is updated in the ISTAR.ISTAR_NAIC table.

Create NAIC Designation Panel Options (by Security)

The following table describes the key options on the Create NAIC Designation panel.

Option	Description

Option	Description
Add by SVO Company Code and Issue
Selection Type	Defaults to SVO Company Code. Option to select Client.
SVO Company Code	Enter SVO Company Code here. The system stores the SVO company code and designation in the database as entered.
LOOKUP fields	Allows you to enter the information required to uniquely locate the SVO Company record for update. Options include: Client ID. Remains hidden unless you change the Selection Type to Client. Client Name. Remains hidden unless you change the Selection Type to Client. Issue Name. Ticker. Xref Security ID. The processing security type (PST) of the asset controls the unhiding of the NAIC Designation Prefix and the NAIC Designation Suffix fields, for data entry.
NAIC Rating Type	Specifies the type of NAIC designation. Options include: Security Broker Issuer Sovereign Country Set to Security.
Source Name	Specifies the source (tag 1102) assigned to the NAIC information. Default value is EAGLE PACE. NAIC is the alternate, valid source for designations. NOTE: If two or more records are in effect for the same date, the information with Source Name that is equal to NAIC is preferred for use.
Effective Date	The Effective Date restricts the use of the NAIC designation, based on the type of trade and trade date: Opens (buys, and so forth). Use the designation as of the month end date for the month in which the transaction took place. If no designation is available for this date, then use the most recent designation for a date earlier than the transaction date (but not earlier than the previous calendar year end). Closes (sells, and so forth). Use the most recent designation for a date earlier than the trade date (but not earlier than the previous quarter end date). NOTE: If the transaction trade date is December 31st, the date logic looks backwards within the same calendar year (and does not consider the prior calendar year).
NAIC Review Date	Used for Informational Purposes only.
Client Lookup Identification
Identification fields	Displays several identification fields when you set the Selection Type to Client which otherwise remain hidden. When you set Selection Type to Client, enter one or more of the LOOKUP fields above, and the database retrieval was successful, the fields in this section auto-populate to allow you to verify that the panel is updating the correct SVO company code/client. Displayed fields include: Client ID Client Name Client Type SVO Company Code
Add NAIC Designation Data
NAIC Designation Prefix	Specifies the NAIC designation prefix. The field appears only when the security type is Preferred Stock (EQCSPF) or Preferred PIK (EQCSPK). Options include: Clear P RP
NAIC Designation	Specifies the NAIC designation. Options include: 1, 2, 3, 4, 5, and 6.
NAIC Designation Suffix	The NAIC designation suffix. Options include: Clear, ; , A, J, K, L, U, V, F, FA, FE, FEA, FEJ, FEK, FEL, FEU, FEV,FJ, FK, FL, FU, FV, GI, GIA, GIJ, GIK, GIL, GIU IV, IF, IFA, IFJ, IFK, IFL, IFU,IFV, PL, PLA, PLGI, PLGIA, PLGIJ, PPLGIK, PLGIL, PLGIU, PLGIV,PLJ, PLK, PLL, PLU, PLV, S, SA, SJ, SK, SL, SU, SV, YE, YEA, YEJ, YEK, YEL, YEU, YEV, Z, ZA, ZJ, ZK, ZL, ZU, ZV, AM, F, FE, FM, GI, IF, PL, PLGI, S, YE, Z The following section lists the valid combinations of NAIC prefix, designation, and suffix values for the affected Schedules. Schedule D1 and DA1:* NAIC Prefix. Not applicable NAIC Designation. 1,2,3,4,5,6 NAIC Suffix. Clear, , AM, F, FE, FM, GI, IF, PL, PLGI, S, YE, Z Schedule D21:* NAIC Prefix. Clear, P, RP NAIC Designation. 1,2,3,4,5,6 NAIC Suffix. Clear, ;, A, J, K, L, U, V, F, FA, FE, FEA, FEJ, FEK, FEL, FEU, FEV,FJ, FK, FL, FU, FV, GI, GIA, GIJ, GIK, GIL, GIU GIV, IF, IFA, IFJ, IFK, IFL, IFU,IFV, PL, PLA, PLGI, PLGIA, PLGIJ, PPLGIK, PLGIL, PLGIU, PLGIV, PLJ, PLK, PLL, PLU, PLV, S, SA, SJ, SK, SL, SU, SV, YE, YEA, YEJ, YEK, YEL, YEU, YEV, Z, ZA, ZJ, ZK, ZL, ZU, ZV Schedule D22:* NAIC Prefix. Not applicable NAIC Designation. Not applicable NAIC Suffix. Clear, A, J, K, L, U, V Schedule BA1: NAIC Prefix. Not applicable NAIC Designation. 1,2,3,4,5,6 NAIC Suffix. Clear, FE, PL, PLGI, S, YE, Z
Designation Indicator	Used for Informational Purposes Only. Options include: strong (+) average (=) weak (-)
Lookup Results
Security Alias	Displays the security alias (database key) for the security, after a successful lookup.