Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

You can create NAIC Schedules and vendor extracts in Eagle Insurance. 

To execute Insurance schedules:

  1. In Accounting Center, in the left navigation pane, click Insurance, and then click Annual Schedules or Quarterly Schedules. 
  2. Click the schedule category, and then click the name of the schedule you want to execute.
    You see the panel for the schedule you selected. 
  3. Complete the options on the panel.
    The panels for the schedules have three sections that drive the selection of data and the formatting of the results: Required Parameters, Advanced Reporting Formatting Options, and Result Format Type. An example of a schedule panel follows. 
    Schedule D Part 1 panel
  4. Click Submit. 

Insurance Schedule Panel Options

The following table describes key options on the Insurance schedule panels in the Required Parameters, Advanced Report Formatting Options, and Scheduler Format sections.

Option

Description

Required Parameters


Entity Type

Specifies the type of database qualification to use to control the intended processing for the panel. Options include:

  • Client. Default. Client is the NAIC filing requirement.
  • Entity.

Client ID

Specifies the client identifier of the third party client record, corresponding to the insurer. The client identifier can relate to a single client or a composite client (group of clients). The field appears when you set the Entity Type to Client.

Entity ID

Specifies the entity identifier of the portfolio. The field appears when you set the Entity Type to Entity.

Accounting Basis

Specifies the accounting basis used to produce the schedule. Options include:

  • STAT (Default)

Report Type

Specifies the type of Report Date associated with the Report Date field. This field only appears when appropriate for the specific report or schedule that the panel generates. Options include:

  • Accounting Date
  • Month End Date

Report Date

Specifies the date to use as criterion for the selection of records and information used in the generation of the report or schedule. For example:

  • Position reports. Specify the month end accounting period date.
  • Activity reporting. Specify the begin date and the month end accounting dates; the second date field appears when two date fields are required for data entry.

Level of Detail

Specifies the level of position data used in the generation of the report or schedule. Options include:

  • Position Summary. Default. Position Summary is the NAIC filing requirement.
  • Lot Detail.

Report Mode

This option is available on the D3, D4, D5, DA3 Supplement, DA4 Supplement, DA5 Supplement, E3 Supplement, E4 Supplement, and E5 Supplement schedules. For more information, see About the Report Mode Option. Options include:

  • Audit. Default. Produces a schedule based on the security attributes in place at the time the data was transferred to the Insurance warehouse.
  • Reporting. Produces a schedule based on the security attributes in place as of the report date.

Advanced Reporting Tags


Shading Interval

Specifies the shading for advanced report results rows. Options include:

  • 0. No shading.
  • 3. Default. Shade every 3 lines.
  • 99. Shade all lines light grey.

Suppress Zeros

Allows you to filter zero values. Options include:

  • Yes. Default. Suppress zero records. Yes is the NAIC filing requirement.
  • No. Do not suppress.

Data Rounding

Allows you to select actual decimal precision or rounding. Options include:

  • Yes. Default. Round values before displaying.
  • No. Display actual values.

Scheduler Format


Result Format Type

Options include:

  • Standard CSV. Default. Produces a schedule with all underlying tags that the grid report includes.
  • Vendor CSV. Produces a tab delimited report in the NAIC approved format – result should be submitted to Scheduler.

About the Report Mode Option – Activity Schedules

Due to the timing of data changes and the nature of the Insurance warehouse refresh process, certain changes to asset characteristics may possibly cause a disconnect in the disk-line placement of assets on Activity schedules versus the disk-line placement of assets on Position schedules. If an asset's Major Type [NAIC Market Code], or Issuer Country Code is changed within a reporting period, there is activity prior to the change, and the prior periods are not refreshed, the NAIC market code and Issuer at the time of the activity are used for placement on the activity schedules; however, a position schedule generated after changes are made, uses the changed attributes to determine the placement of the asset.

You can generate ISTAR Activity Schedules in either fashion, by setting the Report Mode option on the schedule panel. Options follow.

Audit Mode

Audit Mode produces a schedule based on the attributes in place at the time the data was transferred to the Insurance warehouse. There are several effects on processing:

  • NAIC Market Code (tag 5856) on the activity record determines the disk-line placement of assets.
  • Country of Incorporation (tag 1174) on the activity record determines the Country placement for the asset.
  • Foreign Code displayed on the Schedule is based on the activity level data in the warehouse.

Reporting Mode

Reporting Mode produces a schedule based on the attributes in place as of the month end date used to submit the report. There are several effects on processing:

  • NAIC Market Code (tag 5856) in effect on the report-date determines the disk-line placement of assets.
  • Country of Incorporation (tag 1174) in effect on the report-date determines the Country placement for the asset.
  • Foreign Code displayed on the Schedules is based on the report-date data in the warehouse.

These viewing options are available on the D3, D4, D5, DA3 Supplement, DA4 Supplement, DA5 Supplement, E3 Supplement, E4 Supplement, and E5 Supplement schedules.


  • No labels