Eagle STAR for Insurance Data Flow and Components

Eagle STAR's core accounting functionality and global processing components support the flow of data within Eagle STAR for Insurance. Reference and transaction data established for Eagle STAR is used by the Eagle Accounting solution and propagates to Eagle PACE and the insurance warehouse tables within the ISTAR database. See the following figure. 

Eagle STAR for Insurance Data Flow

There are several data components supporting Eagle STAR for Insurance:

• Master Files. The Securities Master (SMF) file, Transaction Data (TXN) file, and Reference Data file define the entity and client relationships and the code values required to control processing and maintain the data feeds, such as Statutory Accounting, and the data feed attributes, such as prices, NAIC designations, and SVO categories and subcategories. The Eagle STAR and Eagle PACE database tables are established manually using web panel data entry, or in bulk using Batch Uploader and Message Center facilities.
• Eagle STAR. Eagle STAR is Eagle's proprietary real-time, message based, accounting solution. Eagle STAR uses the ESTAR database and the STAR Cost Object for data repositories.
• Eagle PACE. Eagle PACE is the Eagle data warehouse. Eagle uses Oracle^™ as the database management system for Eagle STAR for Insurance.
• Insurance Data Warehouse (ISTAR). The Insurance data warehouse is the primary data source of all Statutory Accounting schedules. The ISTAR database stores transactions, positions, and the statutory detail and summary values, such as statement values, statutory market values, reporting schedule line placements, and prior period values. These values are required for proper record keeping, auditing, and reporting. The data is stored at the lot level position, transaction, and summary (rollup) levels.
• Statement Vendor Extracts. Statement Vendor Interfaces are generated using the ISTAR database tables, allowing you to file quarterly and annual schedules using any vendor that conforms with the NAIC Electronic Filing Submission Directive, for example: A.M. Best (BestESP), Booke (TCP), Wings, Financial Software Innovations (FSI), Freedom Group (AS2000), and SunGard (EFS).
• Statutory Accounting Schedules. Statutory Accounting schedules are available upon completion of the initial statutory valuation for the period, and reflect the data that is available for the specified statutory accounting period. You can:
  • Filter report results for a specified accounting period by client or entity.
  • Produce report views at the position summary level and the lot detail levels for internal accounting/analysis purposes. The NAIC filing requirement is the position summary level.
• Insurance Control Reports. Insurance Control reports are available to validate schedules and provide details for summary totals.

There are several processing components available to support Eagle STAR for Insurance:

• STAR to PACE Direct. The STAR to PACE Direct (S2P) process transfers data from Eagle STAR to Eagle PACE to support daily reconciliation through month-end reporting. You must schedule S2P to capture the cash on deposit and cash securities information to prepare the Schedule E – Part 1 (Cash) filing and pricing information for Schedule DL. S2P is required to use the Eagle PACE portfolio accounting reports.
• ISTAR Refresh/Valuation Process. The Refresh/Valuation process calculates the statutory values and determines schedule assignment and schedule line placement at the security, holding, and transaction levels. You can post unrealized statutory gains/losses to the General Ledger upon completion of ISTAR Refresh.
• Statutory Wash Sales Process. The Statutory Wash Sales process identifies wash sales at the client level based on the statutory wash sales rules and builds the statutory wash sales data in the ISTAR database. You can perform the process for either an annual or quarterly period, with the selected period type determining the timeframe used to evaluate transactions.