REPGEN
From Wiki
| ||||||||
See the NOVUS Walkthrough Guide for general information about the system.
Table of Contents
Universal Report Generator
The universal report generator program is used to produce reports not available from elsewhere in the system. There are two screens for this program. The initial screen shows a list of reports to select the report. The second screen enables criteria specific to the report can be entered.
Using REPGEN
After launching the REPGEN program navigate to one of the report lines and click the go to report button. The reports are displayed in browser tabs, an Excel spreadsheet or go directly to the default printer. These reports are configured in the REPSETUP program, and the tabs are set up in the CODES, and REPGEN tab groups.
The first tab displays all reports which will show reports that are available on all other tabs.
The user will then need to enter the parameters for the report. Many of the parameters will be via drop-down lists, but some will need to be entered manually.
Please note that if the Excel icon is greyed-out, this indicates that this report is print/view only and was not built for use in Excel.
| Parameter | Example Value |
|---|---|
| Report Name | This is the internal name of the report. |
| Description | A description of what each report does. |
| On Tab Name | Reports can be allocated to different tabs in order to make them easier to find. |
| Last Ran | This shows when each report was last run. |
| Last Ran By | The database logon of the user who last ran the report. |
Searching for a report
Customisation of the output is available in the grid and includes the ability to filter the output using the yellow line in order to search for reports.
Reports available
Accounts
- ACC OS CLI - Outstanding balances by account
- ACC OS CLIENT - Amounts due to pay from client
- ADDRESS LIST - Active accounts (securities) between a specified period
- AGENTS - List of partners flagged as agencies
- BASE TB - Trial Balance by period in base
- CASH ALLOCATION - Cash allocation
- CLIENT DUES - Client policy due dates by inst. date
- DUE UW PNL - Payment due to third party
- FCA CLIENT MNY - list of transactions by client account
- FEES DD KAY - Client fees detail by department
- FEES DEPT KAY - Client fees by department
- FRS5 - Solvency Report (FRS5)
- FSA NST - FSA Insurance bank reconciliation by period and currency
- FSA REC - FSA Insurance client money reconciliation by division and currency
- FSA REC EIS - FSA Insurance client money reconciliation by report date and division
- FSA REC KIB - FSA Insurance client money reconciliation by date and division
- FSA REC MRS - FSA Insurance client money reconciliation by report date
- FSA RES PNL - FSA Insurance client money reconciliation by report date
- FUNDING - List of funded items at the current date
- FUNDING MRS - funded transactions
- FUNDING PNL - PNL funded items
- HIST C FL PNL - Historical cash flow
- IBA TURN SAM - Turnover by partner
- LEAVEBAL A1 - Leavebal section A1
- LEAVEBAL A10 - Leavebal section A10
- MATCH REP - Matching report
- MATCH REP RANGE - Matching report by range
- NL ACC PNL - Nominal ledger accounts list
- NL CL IBA REC – NL/IBA client reconciliation
- PAY PERF - Client Payment performance
- REVENUE SAM - Revenue report for SAM
- TAKABLE PNL - Outstanding analysis
- TB FRS5 PNL - Trial balance vs FRS5 reconciliation (PNL)
- UNREL GL - Unrealised gains/losses for a specified year
Brokerage
- BKD BROKD PNL - Booked brokerage (det) by incept period
- BKD BROKT PNL - Booked brokerage (tot) by incept period
- BOOK BROKDET - Booked brokerage total (by trannum)
- BOOKED BROKCTY - Booked country
- BOOKED BROKCUR - Booked brokerage by original currency
- BOOKED BROKD - Booked brokerage (detail) by period
- BOOKED BROKT - Booked brokerage (totals) by period
- BOOKED BROKPRF - Booked brok (det) by acc per + ince
- BOOKED BROKPRFX - Booked brok (det) extended
- BROK DD MRS - Brokerage by dept detailed (third party)
- BROK BKDXS PNL - Brokerage booked > equiv GBP of
- BROK COB CGS - Brokerage by class of business
- BROK DD KAY- Brokerage by dept detailed
- BROK DEPT KAY - Brokerage by department (for ONS return)
- BROK INST MRS - Brokerage by inst date
- BROK INST2 MRS - Brokerage by inst date
- BROK LIST KIB - Brokerage listing by transaction entry date
- BROK MONTH AIS- Brokerage and premium by month
- BROKD PER PNL - Brokerage (expanded) by period
- BROKBYINS - List of brokerage by (re)insurer
- BROKERAGE2 APG - Brokerage FRS5G/deferred/cash basis
- BROKFRS5 - NL Brokerage query for AIS
- BROKINS - List of Brokerage by insurer
- BROKSPLIT - Producer Income split (by sections)
- BROKSPLIT EIS - Brokerage by producer EIS (by sections)
- BROKSPLIT ESR - Brokerage income by producer, and date
- BROKSPLIT KIB - Brokerage by producer KIB
- BROKS PER PNL - Brokerage (summary) by period
- BROKSUM - Brokerage summary (AIS)
- BROK PERF - Brokerage performance
- BROK REIN - Brokerage by cedant (12 months)
- COMMDUMP KAY - Commission (brokerage) data dump by entry date
- COMMDUMP2 KAY - Commission data dump by entry date
- COMMNET KAY - Commission by transaction date
- COMMNET2 KAY - Commission (brokerage) by inception date
- PROD COM FER - Producer commission report
- REAL BROK KIB - Realised brokerage statement
- REAL BROK MRS - Realised brokerage statement
- TOW BRK PAYAWAY – TOW brokerage payaways
- TOW FULL RLD – Full RLD report
- UNPBROK - Unpaid brokerage
- UNREAL BROK KIB - Unrealised brokerage
- UNREAL BROK EIS - Unrealised brokerage
- UNREAL BROK MRS - Unrealised brokerage
- UNREAL BROK PNL - Unrealised brokerage
Business
- AGGREGATE ALL - Facility risk details aggregation
- AGGREGATE REP - Facility risk details aggregation
- AGGREGATE REP2 - Facility risk details aggregation
- ALL BUS PNL – All businesses report - PNL
- BORD LIST CGS - Bordereau listing
- BORD LIST KAY - Bordereau ID list
- BDR RISK - Risk bordereau
- BUS COUNTRY - List of business per country
- BUS PLACED - Business placed by account code
- BUS PLACED ALL - Business placed all accounts
- CED FAC KRE - Cedant facultative statements
- CLI LIST - Client listing with addresses
- DECL LIST - List of declarations
- E2I ALL ENOVUS - Earned to incurred
- ELTO LIST - EL Risks added by risk entry date
- ELTO RISKS - EL risks for insurer by entry date
- INS BDR EIS - Insert core risk detail for inward bdr
- LOSS INS NIC - Loss ratio analysis by partner
- LOST BUS - Failed renewals report (generic)
- NEW BUS - New business report (generic)
- NEW BUS PNL - New business report
- NTUSTAT - Risks by NTU status
- OFF POLS WTB - Binder off policies
- POLCOUNTD - Policy count detail report
- POLCOUNTO - Oyster policy count report
- POLISTI - Insurer market participation
- POOL BUS PNL - Premium payment warranties
- PROD PERF – Producer (policy performance)
- QUOTATIONS PNL - List of quotations
- RISKCAN - Risk cancellation for a specified period
- RISKENT KAY - Risks entered
- TSI MARTREF KAY - Total sums by cresta zone & market ref
- UND PART - Underwriter participation - PNL
- UND PART AIS - Underwriter participation
- UND PART YEAR - Underwriter participation by year
Claims
- CLAIM FILE EIS - Claim file location
- CLAIMS IN YEAR - Claims in year
- CLAIMS REG - Claims register
- CLAIMS REP - Claims report by policy
- CLM HISTORY AIS - Claim history by reinsured AIS
- CLM IP BDR KAY - Int property claims status
- CLM MON NIC - Claims paid by month
- CLM OUT - Outstanding Claims list
- CLM OUT NIC - Outstanding claims
- CLM OUT PNL - Outstanding claims (PNL)
- CLM PRELOSS AIS - Preliminary loss report
- CLM REG AIS - Claims register (AIS)
- CLM REINS AIS - Claims by reinsurer
- CLM REINS KAY - Claims by broker/reinsurer
- CLM REP LLOYDS - Lloyd's claim reporting tool
- CLM STAT KAY - Claims by status
- CLM UNM LEM - Outstanding claims + cash
- CLM YEAR NIC - Claims paid by underwriting year
- DIRECT SETT - Direct settlement
Compliance
Premium
- CLIENT PREM - Client wise premium
- GWP MON NIC - Gross written premium by month
- GWP YEAR NIC - Gross written premium by year
- GWPTYPE – GWP by type (Towergate)
- OS PREMTRAN KAY - Outstanding initial premiums
- PPW CLIENT KAY - Client premium payment warranty
- PREM EXP EIS - Premium exploded to syndicate level
- PREM UW - Underwriter premium report AIS
- PREM WAR – Premium warranty
- PREM WAR MRS – Premium warranty trans due
- PREMRITEM – Premium breakdown by risk item
- PROD PREM NSS - Premium by producer
Premium & Brokerage
- GWP CLASS KIB - Gross written premium and brokerage by class
- GWP MONTH KIB - Gross written premium and brokerage by Month
- PREM BROK CGS - Premium and brokerage by producer (by sections)
- PREM BROK KIB - Premium and brokerage by producer (by month)
- PREM CL – Client premium, brokerage and fees AIS
- PREM CY – Country premium brokerage and fees AIS
- PREM T – Transaction type premium brokerage AIS
Transaction
- AUDIT1_AIS - All transactions NO CASH
- STOPPED TRANS - List of trans with stopped securities
- TRANFACT KAY - Transaction summary factsheet
- TRANLIST - Transaction listing
- TRANS M D PNL - No of transactions per month & division
- TRANSTATE - Transaction statement by active account
Treaty
PLEASE NOTE
It is important to note that the REPGEN program contains a library of reports either written by or specifically written for individual clients. Unless specifically written for you, tested and agreed, Morning Data cannot guarantee that the data produced will be an exact match for your requirements.
Version History
v 6.0.0 – Updated to latest version
v 5.0.0 – Updated to latest version