Home

Viewing Package User Manual

Contents

1. 49 50 V2 Valuation Record eccuci u qana Sar bid eats ved as aquqa eg 51 52 V3 Valuation Record 53 56 V9 Val ation ReCOEG paros sata sassa ag pee s E EUR en 57 GSE eee ee a us EE ee 58 70 Appendix A Status Codes 1 ed P aee et ea o e a xc e s 71 72 Appendix B Transaction Codes 73 76 Last Updated July 8 2008 Page 2 of 78 Viewing Package Manual R The Reinsurance Resolution The Viewing Package and Electronic Files Last Updated July 8 2008 Page 3 of 78 Viewing Package Manual Description of the Viewing Package Quasar Systems is proud to provide a Viewing Package to display and generate reports from a standardized reinsurance file This system will operate on any files conforming to the standards set by the 1991 Guidelines for Electronic Reporting issued by the Reinsurance Section of the Reinsurance Committee of the Society of Actuaries even if they are produced on systems other than R The Reinsurance Resolution The R2 Viewing Package operates on Windows NT 2000 and XP operating systems as well as Windows 2000 and 2003 servers The R Viewing Package can display any record in either Transaction or Inforce Valuation files and it can produce reports on classes of policies selected according to user specified criteria Searching functions also allow alpha policy number searches Last Updated July 8 2008 Page 4 of 78
2. ZE ZE e 00 0 D0 Ob c8 911 v9 00 0 2 FU ok Tot TY 0 000 001 92 000 001 92 000 00 0y N 1 p4epuejs Jexous 941 LESA ALUN c S8toL og 40 J qunN S e30 SS TSS IN Lesuaatun 90 6nv ST 00 6 t 9vl 0070 DD Op SL E S O 00 0 z S 898 281 TY 0 000 SZ8 T 000 S 8 I 000 00S XN 1 9940JUI T N3 O 000 000 V 9 h S WZS 4dv 00 bny sT HU II 381234dS 099808H 099 0dS esuarlun 0 AeW 9T 00 S p IT 00 0 0070 SL 898 2 000 SLeve bl T 0 000 SZ2 T 000 SZ2 T 000 00 I WN 1 993409jUu T 000 mp DI V 4 6 S NTItr q84 61 00 APW 9T Mi uJequequ49 NYTV LLOOS 8EZ2EOUH BELCEYNdS esuartun Z0 AeW T Ob rekt 00 0 00 0 09 98 000 00 81 t T 0 000 007 1 000 002 1 000 008 2 WN 1 9940Ju T N30 000 001 V S 0 S 4 eG sdy 12 20 AeW T UU 4LBMeH VYIJHS SYJANNYS OOVZEOYH 00pZEYdS Lesu atun 0 4dy 61 09 ZSZ S 00 0 00 0 Ov VIE I 000 00 2 99 TW 0 000 Dee TI 000 0SS T 000 002 2 WN 1 9240JUu T H80 mp OOT Y S OS S NzS unc 6t Z0 4dy 61 m HLWOUVS T6EZEOYH LISER Les4artun 0 unr SZ Ot 6 00 0 00 0 Ol r 00 0 O0s SICI TW 0 00S 8g8 I 00S 8 T 000 0SU YN 7 9240jU T YO 00 0 001 V S S N6Z Q94 92 v0 un Gz HU uo4ojueunH ANNHOC WYOLS EBEZEOYH RAIER lesuaatun 90 bnv gZ Dt S98e r 00 0 00 0 82 960 T 00 0 8t ISp S TW 0 00S 29 1 008 29 1 000 0S0 mW 9940jU T dV 0 000 0001 Vv 6 Ov S W 9S 980 2 6 5ny ez m OU HAD 3143 U3NAVH E9EZEONH E9EZEYdS UR Ld x xld 3Ux xxxJ N A 9u30x lt MO11V QS oL Lv
3. seg W33d Q1iSS W3ud 3SVg lt 31l 3G DU Le IN 02x xuvv SUL Yx x3924 sutey e2eJ 12941g 40 x1do 1 544 x38 L3 6ut383 3 v uag 86v N S D X3S Fees Oe ce LOC ooo IB axa Lass seess IIoc yes ON 9110d Jemouay uod y prejaq Korpod 3d 5140 lt x lt ON 5140 GSN punoj 30N Aduan uoud Je Sue SLOT 39e83uo2 Auedwo Buipa AL yuo paeuedaug sj4odey ON ALJLSU isoJequ enuuy 9pow uniue4g e2ueJnsulsy IMA edK Aeau 900Z unr 0 SO0T BNY 1 Tn Aoi e ueunsu pJOM 34 Aes gt OL popa Daun sozsysedns WO popa Package Manual iewing V Page 26 of 78 Last Updated July 8 2008 Transaction Report DEI O8T1 6308 0000 0000 V000 0208 6VZ3 LODE AVTA AQ ue LEI We 900c In pn uny Ange fwa gogysb lt gt im zement 102 Chr we ox swasis sesen lt gt MS nSmpon NVHIOO 0 o TIOTT 01 269 69t 00 0 00 9vI y 99 41v S8 00 0tZ ly 9 S80 8ly 000 S2L I 000 S 1 v4 000 S I PZ 000 0S9 ITI 3N 1 64 86 00 0 00 0 26 t69 000 T S6 0 00S 299 T 005 299 1 000 059 2 3N 1 9g seioL od jo Jequny S1301 pueuy SI PZT IL 0070 90 802 S yz 2 8 22 UL 000 S2T T 000 0S2 2 000 0S2 2 000 000 UN 1 nam 000 gp ETOT 94 018 Wl 0 0 0 0 OI SaLILLOg JO Jaquny S e303qns pueJ5 82 918 98 00 0 00 OvI y 2L SSl l6 00 0f2 lv mier net TN 0 000 S2p 9 000 S2v 9 000 0S9 TI UN 1 28 S L LLOd Jo jequny S P303qns pueJ9 Iert 000 000 vS 61S 00
4. Transaction reports normally begin with a cover page On the cover page you will find information pertaining to the treaty code currency report date and contact information for both the ceding and reinsuring companies Following the cover page several pages of transactions will be reported Transactions are grouped by processing type per treaty You will find policy changes listed first followed by new business first year other renewals and terminations There are three report lines that will be displayed for a transaction in any of these groupings The first line will contain conversion information if the policy is a conversion The second line contains information about the insured The third line contains information about the coverage If there are multiple coverages for the policy you will usually find multiple third line entries The fields found on each of these lines are described below Line 1 Orig No Original Policy Number for a converted policy Orig Dt Original Policy Date for a converted policy Line 2 Policy NO Policy Number NAME Last name first name may be preceded by the reinsurer s cession number if coded in the Input Extract Plan Plan code DOI Date of Issue policy date DOB Date of Birth SEX Sex of the policy holder M Male F Female U Unisex S N Smoker Code S Smoker N Nonsmoker A Aggregate not distinguished Age Issue Age Drn Duration A F Cession type A Automatic F Facultative L Facultative Lead Rein
5. R prints various levels of subtotals These reports can be sorted by Plan Group Transaction Smoke Class and Band Subtotal boxes are printed when there is a change in any of these fields Class Totals When there is a change in Plan Group Plan Totals are printed When there is a change in Transaction Category Category Totals are printed Grand Subtotals appear at the end of the report after all five sections and their subtotals have been reported and summarize the report by each transaction category type of insurance Life Waiver ADB etc by First Year and Renewal Grand Totals appear after Grand Subtotals and summarize all transaction by type of insurance First Year and Renewal Last Updated July 8 2008 Page 24 of 78 Viewing Package Manual Transaction Report At the very end of all the transactions reported for a treaty R2 will print an Accounting Summary and Policy Exhibit page The Accounting Summary accumulates all premiums and allowances broken down into First Year and Renewal which are then separated into Life Accidental Death Benefit Waiver of Premium Other Benefits and Premium Tax The last row contains the sum for each column The last column contains the premiums due to the reinsurer minus the allowances Therefore the bottom right corner represents the Net amount due to the reinsurer All values in this section are stored in the Policy Exhibit File and may be recalled at any time The client has the option
6. provided the client company set up reserve information on R Substandard Method Valuation method used sub standard table rated reserve calculations System Process Date Process The date on which the transaction was processed as the output file was created System Processing Time Used with the System Processing Date to determine the order of multiple transactions processed on a coverage Expressed through a 24 hour clock Termination Indicator TerminationF lag Clients do have the option to load terminated policies into the valuation listing This field indicates if the policy is inforce or terminated at the time of the report Times ReEntered Reentry Option available to policyholder at the end of the initial rate guarantee period obtain a newer lower level rate for a specified period Transaction Code Trans The two character code that R uses to identify the type of transaction that has been processed such as a renewal termination or policy change Please see the appendix for a listing of these transaction codes and their definitions Transaction Effective Date Effective The date that the transaction took effect on A new business policy will often report the issue date A renewal will show the policy anniversary A change if not done on anniversary will report the date entered for specific change Last Updated July 8 2008 Page 68 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Transaction Pro
7. 0 9 SIy 8N 008 299 1 005 299 1 000 059 2 3N 1 S LILLOd JO Jequny S e303qns pueg SOQ UPld x ld Zanen Ilan lee 9 030 MOL LV Q1ISS MOllV gel ANM Q1SS W39d Zeg Ia La Bue Les AU 5u uvv sutey xo2e3 sutey a2e4 32e4tq 05 x400 1S SA x42 L4 Bu tae 4 4 uid 86v N S X38 LO e oe 100 eU dace ooo Ze eens eee ON ADLLOd 3Q 5140 xwxw ON 5140 seo L woday peq Korod en puno4 30N K2uaJJn euoud 1e euP SLO 32e3u0 Kueduo 6utp 2 K U3U0y pauedaug squoday ON A11l11SU S JSeuaquT penuuy epoy uniueug eoxueunsuLlay EIN edA zeas 900c unf 0 90z 8nv T Tn Aa eoueinsu DUOM I4 HLS OL papag pexup sojeujedng ulo14 popa Package Manual lewing V Page 27 of 78 Last Updated July 8 2008 Transaction Report SI EL 0811 63108 0000 0000 V000 OTOR 6VZ3 100 AT AQ ure ZSI e at uny Sref Agz Ewa HAYS lt gt A amnem 00 tr wy Sup SUNS S r Burl lt gt AS lt nsuomnoo NVHAIOO D ortogi AYLELGEL JO aJeus s Jaunsutay 21412dS x q 2 y D oOooooooo 00 DE 0 0 0 0 0 0 00 0S0 c e2uPJnsulgy S LILLOd xx10 quy 39 ON A13831 n2ejJ eo o potaad JO puj e240jU g ZT TT 01 6 8 9 Saseaudaq 810 q S sp 429 49u10 sunjde2ay Katdx3 Suapuaduns sasde 440 S1uaua2e day suotsJ8Auo 43230 G p 2 T I S SP 49u P10 P 0 Suaxe JON 0 S Sp 43u 000 0S0 I6 000 0S2 2 0 0 0 DOS
8. 8t 005 9 0 000 GT eo e 000 0S0 000 0S0 16 000 0S2 2 005 8v 008 Z 9 0 000 SZT I A 0 0 0 0 0 0 0 0 0 0 0 0 0 0 DG E EE EE EH coOooooooc c Oe duooodo 00S 299 I 0082991 uQ Squaweoe day SuoLsuaAuo Sseuisng M N 00S 299 I 005 9 T6 I 0 0 0 0 I 005 299 T S6 00 050 009 2 9 T6 6 potd d 40 6utuulb g 9240jU BOUPUNSULAY S LILLOd aoueunsuiay S 1l2L 0d pueunsul y SALILLOg x40 Wy 40 ON xx40 Wy JO ON xxJO WY 40 ON 2t3euo3ny 9 1301 MI 213euo3ny 3jeg 0 Je9A Poluag queJunj ER 06L 69E 00 0 DOT Aoroq II uonoog Dp D 00 0 00 0 00 0 00 0 SEI uniusid 00 0 00 0 00 0 13470 00 0 00 0 00 0 00 0 000 00 0 00 0 00 0 68 06L 69t Teo 00 0 99 t79 68 t6 t6b 9L Stt 6Sb 3139ueg qemau y 1984 ASAT yemauey pat 38114 13430 squnoosta seoueMoT Ty sumru za Sununooov uono s CASN punoj 30N luquom penuuy K3ugJJn uoud Je eue SiO 32e3uoj Kueduo Buipa pauedaeug s340dey ON A131Su S 1saJequ epoy uniueug BOUPUNSULSY IYA d qe 41 900c unr o 00Z 8nv I TA Mes eoueinsu pOM I4 ILS OL p3p3O paxup soij uiji dns HOI popa Package Manual lewing V Page 28 of 78 Last Updated July 8 2008 Valuation Report The Inforce Valuation Reports contain a list of all Inforce policies ceded between ceding and reinsura
9. Status Sub Code 00 01 02 03 04 05 06 07 08 09 10 11 12 17 19 29 41 51 61 66 71 Last Updated July 8 2008 Appendix A Status Codes Definition of Status Pending Inforce Lapsed Surrendered Expired Matured Died Converted Out Not Taken RPU Reduced Paid Up zero premium on renewal billings ETI Extended Term Recapture still counted as retained inforce Recaptured counted as termination Partial Conversion Off Paid Up Reinsurance paid to date set to maturity expiry date On Disability Premium being waived ReRentry Plan Change with Treaty reassignment Joint Policy insured coverage does not bill Death on a status 61 Joint Coverage Original Age Conversion Use Original Policy Date for TY Premiums Page 71 of 78 Viewing Package Manual Status Code 72 81 82 83 86 87 88 89 9x Status Sub Code 29 or WP 5 or ME 6 or SV 7 or DA 8 or LC 9 or LI 10 or WC 20 or R 08 or AJ 20 or R Last Updated July 8 2008 Appendix A Status Codes Definition of Status Original Age Conversion Use New Policy Date for TY Premiums Original Age Conversion policy that is currently on disability with premium being waived Preliminary Term Preliminary Term as of the Policy Date Preliminary Term for Original Age Conversion Use New Policy Date for TY Premiums Preliminary Term for Original Age Conversion Use Original Policy Date for TY Premiums Financial
10. Updated July 8 2008 Valuation Report H ANT Kq uie LOLS TT w opoc Inre rr wy ucc Kg Ou TOTASD lt gt A aynen ie Ch mam du staisfs zem 8 lt gt 3a nswenon WVH109 loost WAND WANI WANI WAND WANI WAXD WAXD WAND WAXD WAXD WAY syseg BE 8 S 00 0 m p 6vy 9 cS 868 2ST SL 062 9 T 000 SZU I 0070 0070 00 000 z 000 001 BIO Pld uejd Ag 8 8 S 000 0070 v 6vv 9 S 868 SI SL 06 8E1 000 SZT I 0 0t BIO puteis 00 0 00 0 0t v96 z WAND 95 876 S OS Lvl tL 000 0SL 000 00S t 90 5nv st SSW 00 5nv st an II SWLOSdS 000 t099tNdS 00 0 0070 EE DE WAXD 99 09 00 61 000 08 000 001r Z 90 Sny t 97 SN I0 nv t n gave LLOOS 000 9t8ztHdS 00 0 00 0 vO CIL TI WAND 60 vZv t 00 910 T 000 00 000 008 Z L AeN t 0S Ssa 20 AeH T In I4I5x eH VHISHS SusqNnVS 000 oovzeuds 00 0 0070 SS zB8 WAND 60 S9T DS Ca 000 SZT ooo osc z L0 unp vi 8Z SN TO UNC PT un YAANI SNadNnvs 000 86tZtudSs 00 0 00 0 t0 SL9 WAND LO OSE T 00 vZ 000 001 000 oo0 z L0 ady 6t OS SSW 0 idv 6t n HIVasvs 000 T6tztH ds 00 0 00 0 Pt 0t8 WAND 89 099 T 00 968 000 0SE 000 00L 2 LO unp T Sb SN 66 UNL T n WIS auIHddVS 000 68tZt HdS 00 0 0070 BZ ZIS IT WAND SS vZO tZ O00 0Lv OT 000 0SL 000 00s t LO UNC LT 9 SNW 00 UNL LT n XNVHi HON 000 g8tztuds 00 0 00 0 EC o WAND 99 09 00 61 000 0S ooo oot 90 TOD T 9 SN 3 TO TNC T 1n KTIOH NOSN
11. Viewing Package Manual Entering the Viewing Package After installing the Viewing Package you will need to create an icon on your desktop to gain access to the system This can be done by browsing to the newly created directory and selecting the Osre05p exe file or by right clicking Qsre05p exe and dragging it to the desktop with the option to Create Shortcuts Here Once this has been done you can double click on the icon to enter the program You will be met by the main menu screen containing four choices File The File menu will allow you to exit the program View The View menu will allow to change the font displays if desired R Menu The R Menu is the main processing menu From here you will be able to convert view and print the files you receive Instructions for each of these options follows Help The Help menu will display information about the programs in use Last Updated July 8 2008 Page 5 of 78 Viewing Package Manual R2 Output Available for Use in the Viewing Package These are the types of output files produced by R2 that may be converted viewed or printed in the Viewing Package When you receive these files they should be placed in the Out directory of the package for use QSRE date cc or QSRE date rr This report contains monthly transactions for the specific ceding company or reinsurer The transaction reports contain all of the billing information which is required by ceding and reinsurance companies The r
12. amounts through in a COBOL format instead of having a sign in the Transaction file If the COBOL format is being used a character will appear in the last column of the field overwriting the final digit For example 123 45 would be displayed as 1234N Allowable values are Last Digit COBOL Character 0 j 1 J 2 K 3 L EE 5 EE NE EE o This is an option controlled in the Configuration File If it does not work for your system upon upload try switching this flag and re converting the qsi file to the soa file You can do this by choosing R Menu gt Edit Configuration File gt SOA gt Screen 10 There is a field entitled Negatives Format If this field is set to C the COBOL format will be used A N in this field will use leading negative signs to distinguish negative numbers Last Updated July 8 2008 Page 35 of 78 Viewing Package Manual Electronic Transaction File File Name R2TX Ceding Company Code Reinsurer Code date soa Example Ceding Company ABC Life AL is sending files for December 2006 to Reinsurer Universe Reinsurance UR The file name would be R2TXALUR1206 soa or R2TXALUR200612 s0a Each record in the Transaction file is 500 bytes The Transaction file contains four types of records each with a unique layout Please see the following documentation to define the fields on each record The Transaction file contains only policies that have had a transaction during
13. as 01 for the first plan for an insured on a policy and incremented by 1 for additional plans Example A single life policy with waiver and ADB would only show a 01 in each reported line A single life policy with an additional policy sequence each under a different plan would be reported as 01 for the base policy and 02 for the policy sequence Last Updated July 8 2008 Page 59 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Currency Identifier The currency that defines all values within the reported treaty Codes may be defined by user Currency Scaling Factor Currency Scale The number of decimal places all currency amounts must be shifted If the currency scale Is being reported as 0 all amounts are shown as real values If the currency scale is being reported as 1 all values must be multiplied by 10 etc Date of Birth The insured s date of birth Direct Face Amount Direct The face amount of the policy as issued by the ceding company Directory Code Processing Region The directory within the client s R2 system that this output can be found in Disability Benefit Period 1 DI Benefit Periods Benefit The amount of time benefits will be paid if the disability is caused by Sickness Disability Benefit Period 2 The amount of time benefits will be paid if the disability is caused by Accident Disability Elimination Period Elimination Elim The amount of time at the beginning of a disability d
14. m Xu Illness D Disability O Ordindary T Term U Universal Life W Waiver Page 45 of 78 Viewing Package Manual R2 Electronic Files Layout T3 Transaction Record T3 500 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes I Individual 442 l X 1 F Joine Fist To Die L Joint Last To Die T Contingent Insurance Sub Type Times ReEntered Filler Sequence Written Reinsurer Defined Filler 460 39 X 39 31 X 31 i9 xO End of Line Last Updated July 8 2008 Page 46 of 78 Viewing Package Manual T9 500 Bytes Field Name Record ID Filler Run Date Reinsuring Company FEIN Number U S Federal Employers Identification Number Ceding Company FEIN Number U S Federal Employers Identification Number Treaty or Contract Code Beginning Date Ending Date Currency Identifier Currency Scaling Factor Record Count Reinsurance Premium Total Due Other Total Amounts 1 Other Total Amounts 2 Other Total Amounts 3 Reinsurance Total Amount Due Last Updated July 8 2008 R2 Electronic Files Layout T9 Transaction Record Non Expanded Location 1 3 51 59 68 77 87 95 103 106 107 114 131 148 165 182 Expanded Location 68 77 87 95 103 106 107 114 131 148 165 182 Page 47 of 78 Size bytes N i N P No ch ND LA gt LA 89 1
15. of coding the amount paid each period for the current processing period R2 will then calculate the difference between the total accumulated amount due and the total accumulated amount paid The resulting value will be shown as the net due in the lower right corner R tracks all ins and outs in its own inforce files these are reported in the Policy Exhibit section New Business Reinstatements and Increases will increase the inforce totals Deaths Lapses Surrenders Expiries Recaptures and Decreases will decrease the inforce The Policy Exhibit is displayed for Automatic and Facultative cessions and is shown by current Period and Year To Date All values in this section are stored in the Policy Exhibit File and may be recalled at any time The next three pages show an example of pages from a Transaction Report Last Updated July 8 2008 Page 25 of 78 Viewing Package Manual Transaction Report m ju 311 m DM 311 se 11 affe 0811 6308 0000 0000 V000 0208 6VZ3 LODE MTX AG We LEI TE 9o0c Intp uny rege eus Deh lt gt AV PAMELA auer 4 15b wv DU sursis eseng prf lt gt MS e nswmpon NVHAOO I orori 00 9pl v cL SBU l6 00082 Ty 00 816 Ort Tu 82 918 98 00 0 28 8c 918 98 00 0 00 9pU p Zeg te 00 0 82 Ie 00 8T6 Dt W 0 2g SPLILLOd 40 Jequnw 000 SZp 9 000 Sc OI 000 0S9 PTT UN 1 S L31 O0d JO Jequny S P30 Iem u l 000 Sch OI 000 S2v 97 000 0S9 vTI UN 1 S1301 Ueld zl
16. the period T1 record first line per treaty grouping and first line in the file Contains information related to the treaty the policies have been allocated to and whether or not the file layout is Non expanded or Expanded T2 record information regarding the insured May be multiple records if the policy is joint T3 record information regarding the coverage and premiums for the policy May be multiple records if the policy has additional coverages a k a riders or benefits T9 record last line per treaty grouping and last line in the file Duplicates some information about the treaty as well as contains a record count and total amount of reinsurance premium due Example TI T2 T3 T2 T3 T3 T2 T3 T2 T3 T2 T3 T9 Treaty 123456789 ab98764 ab98764 ab65432 ab65432 ab65432 j125976 j125976 j125976 j125976 j125976 j125976 Treaty 123456789 Last Updated July 8 2008 x fe tt e Smith Life Doe Life ADB Wicket Second to die Wicket Second to die Wicket Second to die Page 36 of 78 EE RETTEN EE ER sate eel geek wa eee E Joint Policy s sid b EVER Zeg dae u 4 000 000 viv perpe ERROR CRM YS MG MO nione ex etos EE 4 000 000 cc 8 ach phe a yat ei eed RP bande tabs Ted u susya ae d Viewing Package Manual Electronic Valuation File File Name R2VL Ceding Company Code Reinsurer Code date soa Example Ceding Company ABC Life AL is sending files for December 2006 to R
17. 0 0 00 0 El ZO 97 WAND vVl 9v0 ZS OO0 szL TC 000 0SZ I WAND 00 0 00 0 P Ee WAND 88 S8T 00 89 000 002 WAYD 00 0 00 0 PZ LII I WAND ap PETZ 00 v9L 000 00z WAND 00 O 00 0 sg 9ta z WANO IL L9 S 0S 8IL I 000 SLT WAND 00 0 00 0 oz zo8 WAND tv 09 1 0o0 ozL 000 000 t WAND 00 0 00 0 F Sgs WAND 90 OLT T 00 v99 000 00 WAND 00 0 00 0 bested WAND 6 Ltv 8 SL 890 t 000 s25 WAND 00 0 00 0 v L 6 lZ 6 WAND SP 6tv 8l O0 SPt 9 000 szz WAND 00 0 00 0 Ee port WAND spent DS ett 000 0ST WAND 00 0 00 0 vo Tez WAND er Cer 00 09z 000 sze WAND 00 0 00 0 LO 8LT WAND LL aer SC IR 000 SZE WAND 00 0 00 0 SL LST WAXD IS SIt DS Eer 000 0sz WAYD 00 0 00 0 EMA WAND 08 Z0 I 00 18 000 0S9 WAND 00 0 00 0 Osta WAXD 8S t 6 DS ter 000 0ST WAND opp 00 0 8z 961 WAND Ss Cer SL 6vz 000 SL WAND opp 00 0 IS 698 I WAND 66 869 t SL 8E9 T 000 SLT WAND opp 00 0 89 66 WAMO vt 666 os vt9 0o00 szz WAND opp 00 0 B9 tS t Mag 9t L06 9 SL SL8 000 szz WAND 00 0 00 0 Ste WAND LE 98T D p EL 000 0ST WAND 00 0 00 0 SL tt WAND OS L9 oo z 000 SL WAND 00 0 00 0 St rer WAND S 88L DS bE 000 SZE WAND opp 00 0 t0 vv WAXD S0 88 SL tt 000 SL WAND opp 00 0 v2 999 WAND ap Err 00 080 1 000 00 LA 00 0 00 0 00 0 Lak 00 0 00 000 2 000 001 WAYD opp 00 0 69 18 WAND Sr Cat 00 z8L 000 001 WAND opp 00 0 ps Tse WAND 80 E9L 00 88 000 007 WAYO 00 0 00 0 BL LS WAND 9S PT I DS ges 000 0ST WAND 00 0 00 0 ENZ WANS 6T SSS 00 0St 000 Ss21 3tSeg unrueid unr ueid seAisseu SrISeH unr
18. 0 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes Processing Office 10 X 10 ES Directory Code xo A Assumed D Direct R Retro Configuration File Key 12 X 12 Filler 205 X 205 Reinsurer Defined Filler 351 351 48 X 48 Processing Type Last Updated July 8 2008 Page 50 of 78 Viewing Package Manual R2 Electronic Files Layout V2 Valuation Record V2 400 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes Record ID 1 2 X 2 Policy Number 13 X 13 15 X 15 xo amp 2 o 2 X 31 20 X 28 Policy Sequence Wil Joint Sequence Insured Sequence Number Filler Policy Sequence 48 Joint Sequence 50 Reinsurance Status Code 51 R Status Code Please see appendix for defined values o s s o 110 9 8 YYYYMMDD 118 XQ fine plus user defined Residence X 6 Canadian Indicator 1 X 1 vu Basis 126 126 Le X Age Next Joint Indicator Insured s Last Name Insured s First Name Insured s Middle Name Insured s Name Descriptor Date of Birth Last Updated July 8 2008 Page 51 of 78 Viewing Package Manual R2 Electronic Files Layout V2 Valuation Record V2 400 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes A Automatic Cession Type X 1 F Facultativ
19. 141 1 9 1 27191 s04 Guidelines Nonexpanded 1 1991 SOA Guidelines Expanded Filler 142 309 X 309 Reinsurer Defined Filler 451 451 X 48 m mu oe m Last Updated July 8 2008 Page 39 of 78 Viewing Package Manual T2 500 Bytes Field Name Record ID Policy Number Policy Sequence Joint Sequence Insured Sequence Number Filler Policy Sequence Joint Sequence Joint Indicator Insured s Last Name Insured s First Name Insured s Middle Name Insured s Name Descriptor Date of Birth Se R2 Electronic Files Layout T2 Transaction Record Non Expanded Location Expanded Location 103 108 116 Size bytes mE NN X 15 al al EE Nn 2 13 1 1 oc X 28 S _ aal aal X 10 9 8 YYYYMMDD 1 X 1 F Female 2 31 28 2 1 1 N 15 10 5 M Male plus user defined x Birth Place 117 117 6 X 6 Residence 123 123 6 X 6 Canadian Indicator 129 129 1 Social Security Number 130 130 139 139 Ceding Company Control Number Last Updated July 8 2008 Page 40 of 78 N No X 1 Y Yes 9 9 9 5 uomo Viewing Package Manual R2 Electronic Files Layout T2 Transaction Record T2 500 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes Production Bonus Eligibility Age Basis X 1 N Age Nearest L Age Last X Age Next Prefe
20. 5 V99 89 15 V99 89 15 V99 89 15 V99 89 15 V99 1 7 17 17 17 17 7 1 Viewing Package Manual R2 Electronic Files Layout T9 Transaction Record T9 500 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes Reinsurer Defined Filler 451 X 48 End of Line 499 X 2 SF Filler 199 252 X 252 Ll Last Updated July 8 2008 Page 48 of 78 Viewing Package Manual V1 400 Bytes Field Name Record ID Statutory or Tax Indicator Filler Run Date Reinsuring Company FEIN Number U S Federal Employers Identification Number Ceding Company FEIN Number U S Federal Employers Identification Number Treaty or Contract Code Valuation Date Currency Identifier Currency Scaling Factor Ceding Company Code Reinsuring Company Code SOA File Version Filler Valuation Program Version Valuation Report Program Version Administrator Initials Last Updated July 8 2008 R2 Electronic Files Layout V1 Valuation Record Non Expanded Location 68 77 87 95 98 99 101 103 Expanded Location 68 77 87 95 98 99 101 103 104 108 112 Page 49 of 78 Size Data Type Values bytes N aN N Oo 0 1989 Pre Guidelines 1 1991 SOA Guidelines Nonexpanded 2 1991 SOA Guidelines Expanded 247 X 247 NEN xo L _ pz o XG Viewing Package Manual R2 Electronic Files Layout V1 Valuation Record V1 40
21. Adjustment Cash Value Recovery Financial Adjustment Dividends Financial Adjustment on all active reinsurers Partial Surrender refund from Cash Value Financial Adjustment for Medical Expense Financial Adjustment for Cash Value Recovery Dividend Adjustment Financial Adjustment for Life Claims Financial Adjustment for Life Interest Financial Adjustment for Waiver Claims Financial Adjustment for Rider portion of policy Financial Adjustment to active and recaptured reinsurers Financial adjustment to terminated reinsurer Appears on billings and electronic files but not inforce files Financial Adjustment for Rider portion of policy Suspended Do not process Where x may be any numerical character Page 72 of 78 Viewing Package Manual Transaction Code AC AF AR BA BD BT CA CC CN CO CV DA DC DH DI EA ET EX Last Updated July 8 2008 Appendix B Transaction Codes Definition of Transaction Code Age Change Auto Fac Change Amount at Risk Adjustment Benefit Added Birth Date Benefit Terminated Conversion On Ceded Amount Change Change in Cession Number Conversion Off Cash Value Adjustment Dividend Adjustment Face Decrease Death Claim Disability Change Error Active Policy Error Terminated Policy Expiry Page 73 of 78 Type of Transaction Change Change Change New Business Change Termination New Business Change Change Termination Change Change Chan
22. ISOH 000 Ss8tztudS 00 0 00 0 DAC WAND I8 8Sl I 00 16t 000 SLS 000 0SI E L0 unp S2 St SSW v0 unp Sz n WoxoptueunH ANNHOC WNOLS 000 t8tzctHdSs 00 0 00 0 IL 61 WAND 6t 6t8 D Eer 000 0SS 000 001 t Lo unp L1 Zt SN ZO UND LT IN UWOMTASAUI Meng STHVHOIN 000 tLtZt dS 00 0 00 0 Sr Cor WAND 96 tot 00 TZI 000 0S 000 00t Z 90 TNL T Sb SNW 0 InP I1 0 Srase3quea dH3H SQNVHOIN 000 89tZtNdS 00 0 00 0 TO SLO Z WAND 00 0SIl t SL Seat oo0 szs 000 0S0 t 90 5ny tz Or SSW L6 Bnv tz an SUIQUIUIDH S AX HHNAVH 000 t 9tZtu dS Uunru eig unruezd seAisseg SISeg unru za unru za qunoury qunowy OL pred d aby Dux zea Spo asata asey s asqunw p use un p z3i gs q Azoqnjeis 4 38N sso15 peped EECH Ssuzsur s W SSI JSS Zortod UeId a eueN Aarttod GSN punoj 30N K3ugJ4nj uouq ye aue S101 32e3u0 Kueduo Butpej LUJUON pauedeig sj4oday ON ALJLSU JSauaqU penuuy pop uniuesJd e2uP4nsutay IMA d l Jeau 900Z unr 0 TA ALAL lq yiAqui uomnys q OL popo5 Daun soiji uiji dn WOLJ popo Package Manual lewing V Page 32 of 78 Last Updated July 8 2008 R The Reinsurance Resolution Electronic File Layouts Last Updated July 8 2008 Page 33 of 78 Viewing Package Manual R2 Electronic Files Quasar Systems maintains the integrity of the Guidelines for Electronic Reporting published in 1991 by the Reinsurance Section of the Reinsurance Committee of the Society of Actuar
23. R The Reinsurance Resolution Viewing Package User Manual Last Updated July 8 2008 Viewing Package Manual Table of Contents Viewing Package and Electronic Files Pages Description of Viewing Package 4 Entering the Viewing Package 5 R Output Available for Use in the Viewing Package 6 Converting Files to SOA Format f Viewing SOA Files uu ouem SNE Poa oat Bete Ona pea UR OR 8 16 Performs SALON ave ee Ee USES C h is Puya Toad ded 17 Ad Hoc Report Pretersnces 3 45 bit eed etd qe ev ede RI RA UD bu eens 18 Running an Ad Hoc Report 19 20 Viewing and Printing Printer Ready Files 21 22 Transaction Rep rt ssas ei aa a a a a come ti a a gn Ca 23 28 Valuation Report 4 oc eU Ie es re Qs e RUN o nae ea 29 32 Electronic File Layouts Pages R Electronic PIOS douce Eua UU EP SI d nd dx uin Ves 34 35 Electronic ITansactionEHe ck ab xe ete OI x UE GS ee Spes 36 Electronic Valuation File 37 R2 Electronic File Layout T1 Transaction Record 38 39 T2 Transaction Record EE 40 41 T3 Transaction Record as Gone puas eti beni EE 42 46 T9 Transaction Record 47 48 V1 Valuation Record
24. ackage Manual R2 Electronic Files Layout V3 Valuation Record V3 400 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes Standard X 8 Mortality Morbidity Table Standard Interest Rate 9 2 V99 amm e 0 N A Standard Function 1 Curtate 2 Semi Continuous 3 Immediate Payment of Claims 4 Fully Discounted Standard Method s S 03 FPT 04 NJSTD 05 CRVM GR 5NL 06 CRVM GR ONL 07 Unearned remium 08 Other Substandard Method me em remium 02 Same as Life Standard 03 Percent of remium 04 Other Filler Valuation Standard Reserve Valuation Substandard Reserve Valuation Deficiency Reserve Valuation Life Deferred Net Premium Filler Coverage ID Last Updated July 8 2008 Page 55 of 78 Viewing Package Manual R2 Electronic Files Layout V3 Valuation Record V3 400 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes Insurance Type See Ilness D disability O ordinary Term U Universal Insurance Sub Type 272 Individual To Die L Joint Last Reinsurance Status Code 273 2 E Ee appendix for defined values Reinsurance Status Sub 275 2 EE appendix for cogs defined values Maturity Expiry Method 277 1 X 1 cen Maturity Expiry Value X 1 Reinsurance Paid To Date 9 8 ai e Termination Indicator X 1 mo eg Disability Occupation Class D
25. al by Field Name Reinsurance Premium Total Due Final Reins Prem Total The grand total of all premiums allowances and premium adjustments processed for this treaty during the transaction period Reinsurance Premium Type Type The category of reinsurance premium paid Allowable values are first year renewal and single premium Reinsurance Status Code Reinsurance Status Status The two character code that R uses to indicate if the policy is inforce or terminated This field in the original 1991 SOA specifications had only four types of status Quasar Systems has chosen to populate the R2 status code as it provides more information about the type of status obtained Please see the appendix for a listing of these status codes and their definitions Reinsurance Status Sub code V3 SOA Sub An additional two character code that R2 may use to indicate if the policy is inforce or terminated Reinsurance Total Amount Due Final Reins Total Amt Due The net of all total amounts A positive amount represents the amount that the ceding company owes to the reinsurer a negative amount represents the amount owed by the reinsurer to the ceding company Reinsurance Valuation Net Premium Net Premium Annual Statutory or Tax valuation premium If the method is Unearned Premium Reserve this field should be set equal to the Annual Total Gross Premium Reinsurer Defined Filler Each client has the ability to send through specific information that
26. all available options At this point you may choose one of the listed default options If you choose one of the existing default options the program will bring up the Field Selection screen with your pre selected field layout You may either continue by choosing Report or amending the previous layout Last Updated July 8 2008 Page 20 of 78 Viewing Package Manual Viewing and Printing Printer Ready Files The Viewing Package is capable of allowing the user to view and print the printer ready files Transaction and Inforce Valuation statements created by the R system that would otherwise be mailed to you To view these files choose R Menu gt View Printer Ready Files You will be asked to choose which file you would like to view from the Out directory The file extension will be the two character code representing your company If you are having difficulty viewing the printer ready file because the fonts do not display properly on your screen use the View menu to choose a new font and or size The icons on the lower right side of the screen will help you maneuver through the printer ready file The page number is also displayed here Print This button will allow you to print individual pages or a certain range of pages from the report It does this by copying only the pages requested to another file Qsxx06 out As long as you do not close out of the Viewing function of the package this file will continue to add any pages you wish to pr
27. ansaction output position 103 in the Valuation output to see if the code listed 1s for Non expanded or Expanded system output There are two distinct electronic output files produced by a client during a processing run the Transaction file and the Valuation file The first two bytes of each record identifies the record type There are four record types for each type of file with the first and last containing information on the treaty to which the policies are allocated The guidelines state that there will be one set of these record types per file This is generally true However when there is more than one treaty for a reinsurer we have opted to combine the files by placing a subsequent record types after the first treaty It is possible therefore to have any number of treaties reported consecutively by simply placing each set of first and last record types after another In addition the guidelines allow for the ceding company and reinsurer to agree on the meaning of data in the Reinsurer Defined fields These fields are found at the end of each record The intent is to allow each installation to specify the meaning of these fields However you should verify this with the originating company since R can be tailored and we may not be aware of configurations used in all instances Last Updated July 8 2008 Page 34 of 78 Viewing Package Manual R2 Electronic Files Lastly some clients may choose to send negative values such as reversal
28. asis CRVM Commissioners Reserve Valuation Method FPT Full Preliminary Term NLP Net Level Premium OTH Other Valuation Method Last Updated July 8 2008 Page 29 of 78 Viewing Package Manual Statutory Reserves Deferred Premium Unearned Premium Tax Basis CRVM FP T NLP OTH Tax Reserves Valuation Report Statutory Reserves Deferred Premium on Reinsurance Unearned Premium on Reinsurance Tax Reserve Basis Commissioners Reserve Valuation Method Full Preliminary Term Net Level Premium Other Valuation Method Tax Reserve At the end of each treaty s inforce listing R prints a Grand Totals and Subtotals page These totals include the number of policies ceded the total amount ceded gross premium net premium and reverse values if the client has opted to code reserve methods in R Subtotal categories are optional and can be chosen by the client These values may include Valuation Basis Quinquennial Age Duration Plan Code and Quinquennial Age Tax Reserve Basis Residence Plan Code The next two pages show an example of pages from a Valuation Report Last Updated July 8 2008 Page 30 of 78 Viewing Package Manual Valuation Report AT AQ use Lete tI Y 9007 Inf una VET CART Wa ZOTAR lt gt L 99m rA Wor gsh man a surats s sesen lt gt 3d lt nSwumpooy WyH10O5 5 0971037 WAXD 00 0 0070 KEN WAND CL tor 00 stz 000 0sz WAND 00 0 00 0 L LEI WAND vt SS7 0s s8 000 Szz WAND 0
29. ast Updated July 8 2008 Page 62 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Medical or Non Medical The type of medical examination required by the ceding company Modal Flat Extra Allowance or Discount 73 Cash Flows Flat Extra The reinsurance gross modal Flat Extra allowance or discount paid by the reinsurer This amount will match the corresponding billing statement for the period Modal Gross Flat Extra Premium 73 Cash Flows Flat Extra The reinsurance gross Flat Extra modal premium being paid by the ceding company for this transaction This amount will match the corresponding billing statement for the period Modal Gross Standard Premium 73 Cash Flows Standard The reinsurance gross standard modal premium being paid by the ceding company for this transaction This amount will match the corresponding billing statement for the period Modal Gross Substandard Premium 73 Cash Flows SubStandard The reinsurance gross substandard modal premium being paid by the ceding company for this transaction This amount will match the corresponding billing statement for the period Modal Standard Allowance or Discount 73 Cash Flows Standard The reinsurance gross modal standard allowance or discount paid by the reinsurer This amount will match the corresponding billing statement for the period Modal Substandard Allowance or Discount 73 Cash Flows SubStandard The reinsurance gross modal substandard allowance
30. ay button The same screen will reappear If you wish to enter additional locations repeat the step just mentioned If you have no more locations to enter press the Cance button to move on Last Updated July 8 2008 Page 17 of 78 Viewing Package Manual Ad Hoc Reports Preferences Under the Run gt Preferences menu you may set default options which will determine the layout of your reports While there are numerous options not all of them are designed to work with this output The options of greatest use to the Viewing Packing are detailed below Spreadsheet If checked the output will appear in a CSV spreadsheet format If unchecked the output will appear in a TXT format No Policy Subtotals If checked no subtotal line will appear for the policies If unchecked a subtotal line will be produced after each policy for all coverages Plans from Menu If checked the file will be read and a menu of all existing plan codes will be created If unchecked you will be prompted to enter any or all plan codes that you wish to report on Blank Duplicates If checked the selected T2 or V2 insured data will be printed only once for each policy If unchecked the policy number will not appear on the second or consecutive lines for the same policy If the report is to be printed and read Blank Duplicates provides easier reading If the report is to be manipulated and sorted Blank Duplicates should be left unmarked Multiple Tab Lines If check
31. e bytes Data Type 2 X 2 13 15 X 13 X 15 X 1 X 1 9 2 0 X 10 CA X 5 9 2 01 L ER 02 L NR 03 WP 04 DIR 05 ADB 06 CC 07 PYR 9 2 08 PDO 09 GIR 10 COL 11 BIO 12 LTC 13 ACC plus user defined gel A LA No w 12 X 12 X 2 l X 1 9 8 YYYYMMDD 3 9 3 w Ww 9 3 Viewing Package Manual R2 Electronic Files Layout V3 Valuation Record V3 400 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes Agerega Smoker NonSmoker Rate XO e Indicator S Smoker plus user defined C Coinsurance Reinsurance Method M Modified Coinsurance SE E ee Rate Band 9 1 Rating Percentage or Ratio 9 4 V9 01000 standard 00010 standard ADB WP Direct Face Amount 78 78 9 S9 9 Reinsurance Face Amount 87 87 9 S9 9 Reinsurance Net Amount At 96 96 9 S9 9 Risk Reinsurance Premium Mode 105 105 1 X 1 A Monthly s ru ac Valuation Annual Total 106 106 9 S9 7 V99 Gross Premium Valuation Annual Total 115 115 9 S9 7 V99 Gross Substandard Premium Valuation Annual Total S9 7 V99 Gross Flat Extra Premium Life Flat Extra 1 Rate s ov Life Flat Extra 1 Number of 9 2 Years Life Flat Extra 2 Rate 9 3 V99 Life Flat Extra 2 Number of 9 2 Years Reinsurance Valuation Net 147 147 S9 7 V99 Premium Last Updated July 8 2008 Page 54 of 78 Viewing P
32. e O Facultative Obligatory S Shopped Filler 223 X 233 Assumed Treaty Number 10 X 10 Life Index Number 20 X 20 Alias ID 158 20 X 20 Ceding Company Control 178 15 X 10 Number Reinsurance Paid To Date 193 8 9 8 YYYYMMDD Smoker Nonsmoker Rate X 1 Indicator C Coinsurance 202 X 1 M Modified Coinsurance N NonTraditional YRT Y YRT Reinsurance Method SE S i ae a cl Company Code 352 X 5 E Reinsurance Paid To Date 357 9 8 YYYYMMDD Ceding Company Control 365 10 X 10 Number Reinsurer Defined Filler 384 15 X 15 352 47 X 47 ET un 33 Company Code is a company specific request and will only be available if the files originate from one particular company Otherwise this field will be blank Last Updated July 8 2008 Page 52 of 78 Viewing Package Manual V3 400 Bytes Field Name Record ID Policy Number Policy Sequence Joint Sequence Insured Sequence Number Plan Code Filler Coverage Sequence Number Coverage Risk Type Filler Policy Sequence Joint Sequence Valuation Issue Date Issue Age Joint Issue Age Valuation Issue Age Valuation Duration Last Updated July 8 2008 R2 Electronic Files Layout V3 Valuation Record Non Expanded Expanded Location Location 1 1 3 3 16 17 18 18 20 20 30 30 35 35 37 37 39 39 48 50 51 5 59 59 62 62 65 65 68 68 Page 53 of 78 Values Siz
33. ed the screen tabs for a policy when viewed not reported on may appear on more than one line if there are enough tabs to justify more than one line If unchecked the screen tabs will appear on one line If more tabs are available than can be viewed in one line the user may click on a left or right arrow at the top to see the rest of the tabs Last Updated July 8 2008 Page 18 of 78 Viewing Package Manual Running an Ad Hoc Report An Ad Hoc report Is used to generate an informative report as specified by the user The Viewing Package is capable of producing Ad Hoc reports from either the soa or qsi files 1 After the Display Disk Output box has appeared go to the Run menu Then choose Run gt Reports gt Report 2 A window entitled Criteria will appear The criteria can be used in the following ways The program will report on all policies if no criterion is selected You may choose one or more criteria for the search Check the appropriate box for each additional criterion For the criteria Automatic and Facultative only the check box needs to be filled for its selection However the rest of the criteria need at least one other question answered before selection is complete The criteria that you have selected if any will be displayed in the box on the right side of the screen The Plan and Status Code fields will compile a list of the existing choices within the database from which your selection may be chosen The ent
34. ed July 8 2008 Page 19 of 78 Viewing Package Manual Running an Ad Hoc Report 8 Then enter the Output File Name Note A default name with its entire path will appear as a choice You may modify this but remember to include the entire path name when doing so If you have chosen the spreadsheet format in Preferences the file will be produced as a CSV file When the report procedure has been completed the output file will be opened by Windows using the default for the specified extension If it is a TXT file it may appear in WordPad NotePad or your default text editor If it is a CSV file it may appear in Excel or your default CSV editor You will also return to the Viewing screen for the original data file At this point you may choose to exit the program or look at another electronic file If you want to look at another electronic file without exiting from the program choose Run gt Open File Default Layout Reporting Options If you choose to name the layout of this report you may be able to recall the same field selection at a later date Name these Layouts in a way that they will be useful to you later To use this option follow the basic database reporting instructions above However after you have chosen Criteria the procedure will deviate from the norm If you have one default layout option the program will automatically bring up that layout If there is more than one option then the program will bring up a screen listing
35. ee Policy Loan Interest Premium Tax Reimbursement Filler Last Updated July 8 2008 R2 Electronic Files Layout T3 Transaction Record Non Expanded Location 131 132 141 150 159 168 177 186 195 222 229 236 245 254 263 272 281 290 Expanded Location 131 132 141 150 159 168 177 186 195 222 229 236 245 254 263 272 281 290 Page 44 of 78 Size Data Type Values bytes 1 9 1 A Annual M Monthly Q Quarterly S Semi Annual BE Esc NT Bs MN Le rre BUE BN Ew BEL MN axe ams aas o s o s o s o sev ml xa9 Viewing Package Manual T3 500 Bytes Field Name Reinsurance Paid To Date Original Policy Date Previous Policy Number 1 Previous Policy Number 2 Previous Policy Number 3 System Processing Time Filler Coverage ID Disability Occupation Class Disability Benefit Period 1 Disability Benefit Period 2 Disability Elimination Period Maturity Expiry Method Maturity Expiry Value Filler Insurance Type Last Updated July 8 2008 R2 Electronic Files Layout T3 Transaction Record Non Expanded Expanded Size Data Type Values Location Location bytes 308 308 9 8 YYYYMMDD 316 316 9 8 YYYYMMDD 369 369 9 6 HHMMSS 425 2 X 2 451 427 3 X 3 a ie 4 5 3 L Lifetime 7 430 3 X 3 GE A 5 6 L Lifetime 3 433 4 X 4 459 438 3 X 3 463
36. einsurer Universe Reinsurance UR The file name would be RAVLALUR1206 soa or R2VLALUR200612 soa Each record in the Valuation file is 400 bytes The Valuation file contains four types of records each with a unique layout Please see the following documentation to define the fields on each record The Valuation file contains all inforce policies as of the valuation date V1 record first line per treaty grouping and first line in the file Contains information related to the treaty the policies have been allocated to and whether or not the file layout is Non expanded or Expanded V2 record information regarding the insured V3 record information regarding the coverage and reserves for the policy V9 record last line per treaty grouping and last line in the file Duplicates some information about the treaty and contains a record count Example VI Treaty 123430789 Li ua d arc oes sot duces pues ee decidido liege EY V2 ab98764 Smith Dieve Vus Eb aw eL S XE APRENDE MUERE RA X V3 ab98764 Life 5400 000 sa eder a e arid us De CR n oe Re V2 ab65432 Doe JANE uu curet Vou ru vare Moa as eae ohn a kas V3 ab65432 Life 300 000 s hie eed ole hala a uy awqa ous a V2 j125976 Wicket Joint Policy iui iud idee be eh V3 j125976 Second to die 4 000 000 2 ose E Reg VES YI Ti V9 Treaty 1234360789 sa uyu usq haqa was Render ALERTA wapu ow wS dios If you have any questions regarding this layout or wish to discuss these specifications with
37. eld on the individual records is shown in the layout as well as defined and standard values shown in the glossary at the end of the document Last Updated July 8 2008 Page 8 of 78 Viewing Package Manual Viewing SOA Files Transaction T1 Record Inm r2soa out R2TXUUGR soa I M SYSTEMS Miwa nsin USA Last Updated July 8 2008 Page 9 of 78 Viewing Package Manual Viewing SOA Files Transaction T2 Record R2TXUUGR soa al UASAR SYSTEMS Milwaukee Wisconsin USA Last Updated July 8 2008 Page 10 of 78 Viewing Package Manual Viewing SOA Files Transaction T3 Record F r2soa out R2ZTXUUGR soa Ins Seq Annual Total CovSeq Standard 0 00 0 00 Cov Risk SubStandard 0 00 0 00 Insurance Type Flat Extra 0 00 0 00 Policy Fee 0 00 0 00 Adrninistrative 0 00 Duration Dividend 0 00 Reentry Chargeback 0 00 Type Recapture Fee hey umo E GXR32302 2 250 000 10 Aug 05 TERM20 2 000 000 8 May 04 2 000 000 8 May 02 0 00 8 May 05 0 00 QUASAR SYSTEMS Milwaukee Wisconsin USA 2to3 of 56 Last Updated July 8 2008 Page 11 of 78 Viewing Package Manual Viewing SOA Files Transaction T9 Record Wisconsin USA Last Updated July 8 2008 Page 12 of 78 Viewing Package Manual Viewing SOA Files Valuation V1 Record 22 F r2so0a out R2 LUUGR soa EE IUASAR SYSTEMS Milwaukee Wisconsin USA E EFE Last Updated July 8 2008 Pa
38. eport is printer ready QSVL date cc or QSRE date rr This report is the inforce valuation information for the specific ceding company or reinsurer The report contains a list of all inforce policies between ceding and reinsurance companies The report is printer ready R2TXccrr date qsi This report contains monthly transactions for the specific reinsurer This output report is a compressed format of the recommended format of the Society of Actuaries These files can only be viewed with the Quasar Systems Electronic Viewing Package The package will allow you to convert the compressed files into the standardized SOA format R2TXccrr date soa This report contains the monthly transaction for the specific reinsurer This output report is In the recommended format of the Society of Actuaries These files can be viewed with the Quasar Systems Electronic Viewing Package or a flat ASCII text editor R2VLccrr date ost This report contains valuation information for the specific reinsurer This output report is a compressed format of the recommended format of the Society of Actuaries These files can only be viewed with the Quasar Systems Electronic Viewing Package The package does allow you to convert the compressed files into the standardized SOA format R2VLccrr date soa This report contains the valuation information for the specific reinsurer This output report is in the recommended format of the Society of Actuaries These files can be v
39. field to the issue age Joint Sequence An indicator of a joint policy All joint policies on R2 begin with 0 for the first joint or insured record followed by a J for the second record Additional joint records are incremented by one letter e g K L M etc This can vary by clients although many have adopted a 0 J K format for second to die policies and a 0 J format for first to die policies However this is not a standard between the companies Life Cash Value CV The amount of cash value that the policy has accumulated as of policy anniversary Life Dividends Dividend amount paid by the reinsurer on renewal Life Flat Extra Number of Years FE FE2 The number of years the flat extra amount is applicable for Permanent flat extra amounts may be coded as 99 Life Flat Extra Rate GEI FE2 The amount of flat extra premium per 1000 or per unit of annual coverage Please note that R has room for two such listings Life Index Number An optional ceding company defined insured identifier Life Lapse Chargeback Payment by the ceding company on allowances previously taken due to premature lapse as defined by the treaty Life Recapture Fee Payment by the ceding company for the privilege of early recapture as defined by the treaty Maturity Expiry Method Indicates the basis for when the policy expires if applicable Maturity Expiry Value Indicates the age or duration after which a policy expires if applicable L
40. ge Termination Change Change Change Termination Viewing Package Manual Transaction Code FA FC FN FO IC JD JO LC LI LP ME MF Z Z Z Z H 8 Ga amp Z Last Updated July 8 2008 Appendix B Transaction Codes Definition of Transaction Code Financial Adjustment Face Change Reversal of Non Forfeiture First Year Other Face Increase Joint Death Joint Order Financial Adjustment for Life Claims Financial Adjustment for Life Interest Lapse Marketing Expense Male Female Change Miscellaneous Change New Business Name Change Non Forfeiture NonSmoker Smoker Change Not Taken Page 74 of 78 Type of Transaction Change Change Change First Year Change Termination Change Change Change Termination Change Change Change New Business Change Change Change Termination Viewing Package Manual Transaction Code OF ON PA PC PD PM PO PS PT RS RT RV SP SR SV Last Updated July 8 2008 Appendix B Transaction Codes Definition of Transaction Code Other Transactions Off Other Transactions ON Premium Adjustment Plan Code Change Policy Date Change Premium Mode Change Partial Conversion Off Partial Surrender Preliminary Term Replacements On Recapture ReEntry Renewal Replacements Off Reinstatements Recapture Terminated Reverse a Change Preferred Standard Change S
41. ge 13 of 78 Viewing Package Manual Viewing SOA Files Valuation V2 Record QUASAR SYSTEMS Milwaukee Wisconsin USA o o s Last Updated July 8 2008 Page 14 of 78 Viewing Package Manual Viewing SOA Files Valuation V3 Record F r2soa out R2 LUUGR soa GXR30578 Standard i 1 000 000 Plan Jr wL Substandard 750 000 Date 10 Dec 2000 Flat Extra 750 000 Reinsurance PTD 10 Dec 2005 Flag I U Sub V3 Amounts Mat Expiry Type A Value Insurance Type Table C5080A Standard 29 759 00 Ins Seq 1 Smoke N Interest Rate 4 50 Substandard 0 00 Cov Seq 01 Duration 5 Function Continous Deficiency 0 00 Cov Risk 02 Mode A Standard Method CRVM Net Premium 6 831 76 Band 1 Substandard Meth Mult qx Deferred Net 0 00 Sub V3 Reserves Table Rating FE1 0 00 TerminationFlag I FE2 0 00 d CoverageID DI Occ Class TreatyKey Jyw00GR00 DI Benefit Periods ReinsurerFiller 2to 3 of 296 rr Last Updated July 8 2008 Page 15 of 78 Viewing Package Manual Viewing SOA Files Valuation V9 Record 22 F r2soa out R2 LUUGR soa SYSTEMS Milwaukee Wisconsin USA n TC EE Last Updated July 8 2008 Page 16 of 78 Viewing Package Manual Performing a Search If you would like to perform a search choose your method from the Run Reports menu and enter any needed information Then choose the Okay button to find the record that matches If the information being
42. gram Version The transaction and valuation modules periodically are updated for the clients use This Indicator determines which version of the program was used to report the calculations Transaction Report Program Version The transaction and valuation modules periodically are updated for the clients use This indicator determines which version of the program was used to create the output report Treaty Key The key name defined by the client indicating which treaty agreement the policy s allocation belongs to Treaty or Contract Code The treaty agreement that the policy is allocated to This is also the code by which the Policy Exhibits are maintained on the billing statements UL Death Benefit Option UL An indicator for Universal Life plans which shows the Death Benefit option elected by the insured Valuation Annual Total Gross Flat Extra Premium V3 Annual Premiums Flat Extra The annualized Flat Extra substandard reinsurance premium Valuation Annual Total Gross Premium V3 Annual Premiums Standard The annualized reinsurance standard premiums Valuation Annual Total Gross Substandard Premium V3 Annual Premiums Substandard The annualized reinsurance substandard premiums Valuation Date The date reserves are calculated for and inforce status is determined Valuation Deficiency Reserve Deficiency The reserve that must be maintained by life insurers when the gross premium charged on a class of policies is less than t
43. he lower left corner of your monitor The program will display the percentage of the file that has been converted After reaching one hundred percent the program will disappear and you will return to the main menu screen 3 The file has now been converted Into a soa file This file can be viewed by following the directions on the next page or in a text file editor This newly converted file can also be found in the Out directory Last Updated July 8 2008 Page 7 of 78 Viewing Package Manual Viewing SOA Files To view files that have been converted to the SOA format choose View Electronic Files from the R Menu 1 When the Windows box appears select the Out directory Choose the SOA file that you wish to view and click on the Open button If your file does not immediately appear try changing the Files of Type option You may also wish to display the file extensions by setting the view menu the right most icon in the Windows dialogue box to view details 2 A Display Disk Output box will display the file chosen for viewing The file should always open ona T1 or V1 record To display additional records within the file use the right and left arrows located on the bottom of the screen To change the attributes of the font use the View menu 3 If you wish to view a different file you can choose from any other file located in the Out directory by clicking on Run gt Open File 4 Also available under the Run menu are options
44. he net level premium reserve or modified reserve Not calculated on R Valuation Duration V3 SOA Duration This field 1s the duration used for calculating reserves This number should correspond with the number of years since the policy was issued Report Date minus Policy Date with the exception of conversion policies in which case the duration may be different depending upon client controlled settings Last Updated July 8 2008 Page 69 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Valuation Issue Age Val Age used for valuation calculations including any age setbacks Valuation Issue Date Date Policy date used to determine valuation duration Valuation Life Deferred Net Premium Deferred Net Deferred valuation net premium Valuation Program Version VL01 Version The transaction and valuation modules periodically are updated for the clients use This indicator determines which version of the program was used to report the calculations Valuation Report Program Version VL02Version The transaction and valuation modules periodically are updated for the clients use This indicator determines which version of the program was used to create the output report Valuation Standard Reserve V3 Reserves Standard Standard reserve Valuation Substandard Reserve V3 Reserves Substandard Substandard table rating reserve Last Updated July 8 2008 Page 70 of 78 Viewing Package Manual Status Code
45. his file including the first and last record per treaty e g T1 T9 or V1 V9 Reinsurance Duration Duration Dur Duration used to determine reinsurance rates or allowances beginning with 1 for the first duration instead of 0 Reinsurance Face Amount Ceded The portion of the direct face amount ceded to a particular reinsurer When used for non life coverages this field should show the reinsured risk associated with the specific coverage such as Waiver of Premium the premium to be waived Accidental Death Benefit the face amount the benefit coverage Disability Income the amount of the monthly income Reinsurance Method Yrt Co Method This field indicates if the reinsurance plan is part of a coinsurance modified coinsurance non traditional yearly renewable term or yearly renewable term agreement Reinsurance Net Amount at Risk Ced NAR The current ceded Amount at Risk as of the valuation date Reinsurance Paid to Date Reins PTD The date to which the reinsurance on the policy is paid through Reinsurance Policy Fee Policy Fee Policy fees paid by the ceding company to the reinsurer Reinsurance Premium Mode Mode Indicates how frequently the policy s reinsurance premium payments are due during the policy year If the policy is paid more frequently than annually this will factor into modal and annual premium calculations Last Updated July 8 2008 Page 65 of 78 Viewing Package Manual Glossary Alphabetic
46. ies for our electronic output Wherever possible we defer to the original guidelines Where we have found the guidelines to be ambiguous or unclear we have used discretion in our interpretation of them For example we place a Carriage Return and Line Feed ASCII 013 010 respectively as the last two bytes of each record The original specifications are not clear on this point but do not prohibit this use We do this so the data appears orderly in most ASCII text editors There are some fields that are not applicable to R but we carry these fields as recommended This document is intended to aid anyone who wishes to use the output produced in the SOA format It defines each field size and location Please be aware that Quasar Systems has two types of files listed in this layout Non expanded and Expanded The Non expanded layout is what all R systems have produced prior to the summer of 2006 This type of file layout corresponds to Quasar Systems use of a ten character policy number and single character policy sequence The Expanded layout is currently optional not all clients are using Expanded output atthis time If they do this layout corresponds to Quasar Systems use of a fifteen character policy number two character policy sequence and numerous enhancements to the storage of policy information To determine which type of output you are receiving from the companies please look at the very first record of each file position 141 in the Tr
47. iewed with the Quasar Systems Electronic Viewing Package or a flat ASCII text editor Key date report date cc 2 character code designating the ceding company rr 2 character code designating the reinsuring company Last Updated July 8 2008 Page 6 of 78 Viewing Package Manual Converting Files to SOA Format The files generated by R are not produced in the format recommended by the Society of Actuaries Instead the files are stored in a compressed format With this software package Quasar Systems is providing a conversion program to convert from the qsi extension compressed format to the standardized SOA format Once the compressed files R2txccerr date ost or R2vlcerr date qsi have been received from the originating company they need to be placed into the Out directory located one level beneath your newly created directory After loading these files through Windows Explorer or My Computer enter into the R program as discussed on page 3 From the R Menu choose Convert Files to SOA Format l When the Windows box appears select the Out directory Under Files of Type choose All File Types To display the file extensions change the view menu the right most icon in the Windows dialogue box to view details Choose the qsi file that you wish to convert and click on the Open button to begin converting the file to the SOA format 2 After clicking on the Open button a small minimized program will appear in t
48. ing Company Code The two character abbreviation chosen to distinguish the ceding company on R Ceding Company Control Number Ceding Co Control Cession Number This field is a unique identification number for each insured It links together all policies on any one life Not all companies may use this technique Also known as Cession Number Cession Type Auto Facultative Obligatory What type of reinsurance agreement is this policy reinsured under automatic facultative fac obligatory or shopped Class Code Class Indicator of better than standard underwriting class It is not to be used as an indicator of smoking habit Commonly reported as standard preferred etc Configuration File Key CFKey The name of the configuration file key used in R to produce this run The configuration file contains various options customized for client production Coverage ID An optional ceding company defined insured identifier Coverage Risk Type Cov Risk Each coverage record represents information for one type of risk on each plan reinsured If a policy reinsures Life WP and ADB there will be three coverage records with the same Coverage Sequence Number but with different Coverage Risk Types Coverage Sequence Number CovSeq A unique number common to one plan and any benefits associated with it This code allows all risks on that plan to be linked together and will work in connection with Coverage Risk Type This field will be reported
49. ingle policy The first record on the policy will be reported as 01 additional individuals will be incremented by 1 Please note there will be differences seen in client output depending upon their use of joint records Example A joint policy reported with an individual s information on the joint sequence 0 line will show 01 for the first insured s record and 02 for the second insured es record A joint policy reported with joint information but not an individual s on the joint sequence 0 line will show 01 for the joint record 02 for the first individual s record and 03 for the second individual s record Issue Age Issue The individual age of the insured at the time the policy is issued taking age basis into consideration Issue age should not reflect any setbacks used for premium calculations Issue Type The level of underwriting that is associated with the issuing of the policy if known This may be reported as fully underwritten guaranteed issue simplified issue or mass marketing Joint Indicator This field indicates if the insured record is part of a joint policy Last Updated July 8 2008 Page 61 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Joint Issue Age Joint The joint issue age of the insureds at the time the policy is issued if applicable and if the policy is indeed a joint policy Age basis should be taken into consideration On the non expanded layout non joint policies will default this
50. int for example pages 1 2 9 10 15 16 etc This remains true for any new printer ready file opened within the same viewing function do not use File Exit before opening a new output file from File Open otherwise the file will be overwritten and you will lose your previously selected pages After you will are done choosing all pages you wish to print you will be allowed to print only the pages you have selected see next page Zoom This button will allow you to zoom in and zoom out of the page that you are viewing on the screen You can view a full page a quarter of a page or a ninth of a page The scroll bars will assist you with seeing different sections of the page at the specified magnification Find Use this feature to search for specific occurrences of data such as a policy number or name As long as you are not zoomed in on a page a gray marker will appear in the left margin of your screen to indicate which row the data was found in Next This button is used in conjunction with the Find option Press it to find the next occurrence of the data you are searching for on a different page Go To This button will allow you to view a specific page without paging through the entire report Last Updated July 8 2008 Page 21 of 78 Viewing Package Manual Viewing and Printing Printer Ready Files Arrows These four buttons will also allow you to view additional pages The blue double arrows will take you to either end of the rep
51. ire list of these choices can be modified by two buttons on the lower right of the choice screen Invert changes all of the check box settings to the opposite e g it would blank out all of the boxes you have check marked and would put checkmarks in all of the blank boxes Negate indicates to select all records except the ones marked in the Selection Criteria 3 Choose the Okay button when you are ready to move on 4 A screen will appear that is divided into four sections Each section represents a type of record from the file Each record contains various fields that you may report on e g Insured s first and last name policy number face amount etc Choose the field s you want included in your report by clicking on the check boxes under each record type Note The large buttons on top e g T1 T2 etc will invert the choice of fields 5 When finished selecting the field click on the Report button 6 You will be asked to confirm the layout of the report Choose Yes or No If you save the layout of this report you will be able to recall it from a listing of defaults at a future date It is probably in your best interest to save all layouts which you might use in the future with descriptive names Please see the note below on Default Layout Reporting Options for more detail 7 Next enter up to a ten character key to describe the default layout followed by an eighty character or less description of your option Last Updat
52. isability Benefit Period 1 292 scr D Duration L Lifetime Disability Benefit Period 2 X 3 She D Duration L Lifetime Disability Elimination X 4 Period emer ee EE s da ss ReinsurerDefinedFiner s1 e al al doi 39 39 Last Updated July 8 2008 Page 56 of 78 Viewing Package Manual V9 400 Bytes Field Name Record ID Statutory or Tax Indicator Filler Run Date Reinsuring Company FEIN Number U S Federal Employers Identification Number Ceding Company FEIN Number U S Federal Employers Identification Number Treaty or Contract Code Valuation Date Currency Identifier Currency Scaling Factor Record Count Filler Reinsurer Defined Filler End of Line Last Updated July 8 2008 R2 Electronic Files Layout V9 Valuation Record Non Expanded Expanded Size Location Location bytes free 9 8 YYYYMMDD NE IU KE See ET NH 68 YYYYMMDD 99 106 245 X 245 351 X 48 39 77 87 95 98 Nn No Page 57 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Phrases listed in order are the field names from the layout If a term exists in parenthesis after the original phrase it is the wording used when an electronic file is viewed through the Viewing Package If the wording is the same for both only one phrase is shown The differences are due to space limitations upon viewing Administrative Fee Fees paid by the ceding company t
53. iueig unrusid 3unouy p uze un peiisjed io3n3eiS 3 N sSsoi5 pepe OSN punoj 30N K3uauan Atyquop peJedaeug S14od u pen uy DON uniueJd eoueunsulay ITM ATT Hien ZZNVN xaieds VIN VVNVH oxivyuzs YAATIO NJANO QUOW IGNWD 2NVdS l S1NOdAd SaLSUNwad aaaaTy HLHOMANNSd uewzeptds walad syuvd YANIT uva uewenby NINO TrAsperzed LLYW 320 3nW oubew 2910 Ze 3loMiequrL NINS OGNOT ueuow1e VNITSS SI AoH2TUSOS YAON NNING B ueuxej3s SIN4Vd LHOINX 9 ueuze3S Org LHOINX aq uo rexea NaanO vuobsH Tearewided WYITTIM NOSLYa d d NOSLVE PTX S3e2ey TVA gas Tatouinjes WaWI Ns3dquv NOWWVS Nagquy ouiejUI AGNVS NOSHSINV NVILdV2O VOINSWV ueuaeraeT WIS NOTTV 1n ueqaerAe T WIS NOTIV n SINI NaTIV Kid n BBBBBEBBBBBBBEBBBBBBBBBBBS I HSYIJ MSWOTOHLNVH N3TIV MOVIE OSHL Wvdv spon asatrd gg LA E AR K CURR D 000 000 000 000 000 000 000 000 000 000 000 000 000 000 oot ooz 000 000 000 000 000 000 000 000 000 000 000 000 000 000 6veceuds 6ttzt uds Sttztuds ZEEZENdJS 6ztctHdS 6TEZENAS sTezeuds eteceuds yoezeuds 9691tHdS 9591t3udS Ov9itudS Lt91 NdS LO9IENdS vO09TtHdS posttuds Sopledds LevlIENdS vz6tONdS vt6z0NdS Tt tz0NdS 06tzoNdas 68t 0NdS 88tZO0NdS 6LEZTONdS 6vezouds 6bezouds 6ttzoNdS 61 Z0NdS 60 z0NdS aequnw Aortoa euoud 3e aue S10 39e3u0 Auedwo 6uipa 9 i3tsuas 3sa4eq
54. me UL Death Benefit Option Rating Percentage or Ratio Life Flat Extra 1 Rate Life Flat Extra 1 Number of Years Life Flat Extra 2 Rate Life Flat Extra 2 Number of Years Smoker NonSmoker Rate Indicator Issue Age Joint Issue Age Policy Issue Date Attained Age Reinsurance Duration Direct Face Amount Reinsurance Face Amount Reinsurance Net Amount At Risk Retention Indicator Reinsurance Premium Type Last Updated July 8 2008 R2 Electronic Files Layout T3 Transaction Record Non Expanded Location 62 63 68 73 75 80 82 83 86 89 97 100 102 111 120 129 130 Expanded Data Type Values Location 1 UL Level DB 2 UL Increasing DB Blank Non UL 100 0 Standard 9 4 V9 WP ADB 10 Standard sao sao A Aggregate N NonSmoker S Smoker plus user defined 9 8 YYYYMMDD F Full Retention N No Retention P Partial Retention 1 First Year 2 Renewal 3 Single Premium Page 43 of 78 Viewing Package Manual T3 500 Bytes Field Name Reinsurance Premium Mode Annual Total Gross Premium Modal Gross Standard Premium Modal Gross Substandard Premium Modal Gross Flat Extra Premium Modal Standard Allowance or Discount Modal Substandard Allowance or Discount Modal Flat Extra Allowance or Discount Filler Reinsurance Policy Fee Administrative Fee Life Cash Value Life Dividends Life Lapse Chargeback Life Recapture F
55. nce companies Each report will contain only policies ceded under a specific treaty and if applicable using a particular currency code The report format is designed to comply with guidelines from the Reinsurance Administration Committee of the Reinsurance Section of The Society of Actuaries Valuation reports normally begin with a cover page On the cover page you will find information pertaining to the treaty code currency report date and contact information for both the ceding and reinsuring companies Following the cover page pages containing an inforce listing for the specified treaty will be reported There is one report line that will be displayed for each policy unless the policy is table rated in which case two lines will appear The fields found on this line are described below Policy Number Policy Number will be blank on the second and later coverages under the same policy number unless a line appears as the first typed line on a page Name Last name first name Plan Code Plan Code Policy Date Date of issue SX Sex M Male F Female U Unisex SM Smoker Code S Smoker N Nonsmoker A Aggregate CC Class Code Iss Age Issue Age MD Policy Mode Paid To Date Reinsurance Paid To Date Face Amount Direct Policy Face Amount Ceded Amount Amount ceded to the reinsurer under the report treaty Gross Premium Ceded portion of the gross premium Net Premium Statutory reserve net premium Statutory Basis Statutory Reserve B
56. o the reinsurer as defined in the treaty Administrator Initials User The initials of the administrator responsible for processing the report period Age Basis Calculation method used to determine issue age This may be age last age nearest or age next birthday Alias ID An optional ceding company defined insured identifier Annual Total Gross Premium Annual Total The annualized gross reinsurance premium for this coverage record Includes standard substandard extra and flat extra This is not the total premium paid for the policy throughout the year and it may not match the premiums found on the billing statements due to the annualized calculation Assumed Treaty Number On retro policies the assumed treaty ID if known Attained Age Attnd The insured s attained age as of the policy anniversary Beginning Date The beginning date for the period being reported in this output file Birth Place A postal abbreviation for the birth place of the insured if known Canadian Indicator An indicator acknowledging whether the policy is included in the ceding company s Canadian statement Last Updated July 8 2008 Page 58 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Ceding Company FEIN Number Company FEIN If the ceding company is domiciled in the United States of America this number is the Federal Employer ID Number For non United States companies additional codes may appear in this space Ced
57. or discount paid by the reinsurer This amount will match the corresponding billing statement for the period Original Policy Date Original If the policy is a conversion policy this is the policy issue date that the original policy was converted from If the policy s reinsurance status code is a 71 this date is used to select the treaty allocation Other Total Amounts Other Tot Amts Non policy level items and other financial transactions which are included in the accompanying check or statement Examples include premium taxes and special one time recapture payments Plan Code Plan The ceding company s unique and assigned plan grouping Last Updated July 8 2008 Page 63 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Policy Issue Date Policy T3 Date The date from which policy anniversaries are calculated Policy Number Policy The policy number assigned to the policy at the company where the output originated Policy Loan Interest Loan Payment of interest by the ceding company on the reinsured portion of the cash value loan Policy Sequence A sequence indicator that may be used within R to indicate additional coverages under the policy It may be used for increases additional insureds or additional benefits riders Preferred Risk Indicator Preferred Code Indicator of better than standard underwriting class It is not to be used as an indicator of smoking habit Commonly reported as standard
58. ort The pink single arrows allow you to view pages on at a time in the given direction To print a printer ready file in its entirety choose R Menu gt Print Printer Ready Files You will be asked to choose which file you would like to print from the Out directory Again the file extension will be the two character code representing your company Once selected you will not be able to view the report it will go automatically to your default printer If you have more than one printer available to you you will be asked to select which printer you would like the report to print from If you choose to print while viewing one of the reports thus selecting only the pages you wanted to print choose R Menu gt Print Printer Ready Files You will be asked to choose which file you would like to print from the Out directory Choose the QOsxx06 out file Once selected you will not be able to view the report it will go automatically to your default printer If you have more than one printer available to you you will be asked to select which printer you would like the report to print from Last Updated July 8 2008 Page 22 of 78 Viewing Package Manual Transaction Report The Transaction Reports contain all of the billing information which is required between ceding and reinsurance companies The report format is designed to comply with guidelines from the Reinsurance Administration Committee of the Reinsurance Section of The Society Of Actuaries
59. preferred etc Premium Tax Reimbursement Expense reimbursement from reinsurer to ceding company for state provincial premium taxes Previous Policy Number Prev 1 Prev 2 Prev 3 The policy number from which this policy was converted replaced exchanged or combined This field will only be populated if the client sends the information through Processing Office For companies with more than one processing location this field will define where the output files originated from Processing Type Defines whether the business report is from a direct writer an assuming company or is being retroceded Production Bonus Eligibility This field indicates if a life coverage is eligible for a reinsurance production bonus Rate Band Band This field indicates which band the reinsurance premium calculations have been obtained from beginning at 1 for the band with the lowest face amount parameters Last Updated July 8 2008 Page 64 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Rating Percentage or Ratio Table Rating The life mortality rating for the policy listed as a percentage For life coverages 1000 or 01000 is standard An uninsurable life coverage would appear as 9990 or 09990 For ADB or Waiver coverages 10 or 00010 is standard Record ID Identifies the type of transaction or valuation information line e g T2 T3 V2 or V3 Record Count A count representing the number of records contained on t
60. r Code An indicator of the type of rate used to calculate premium Allowable values are smoker nonsmoker and aggregate Smoking Habit Indicator If the client so chooses information regarding the insured s use of any type of nicotine can be shown here and in what form User defined smoking habits may be reported in this field as well as common forms such as smoker nonsmoker tobacco etc SOA File Version This field indicates if the output being viewed is in the non expanded 1991 SOA guidelines or expanded 2006 Quasar Systems additions to the 1991 SOA guidelines layout Social Security Number Social Security If the insured is a citizen of the United States and the ceding company has provided the insured s government issued ID number to the system it will be reported here Standard Function Not applicable 0 curtate 1 continuous 2 immediate payment of claims 3 fully discounted 4 Not applicable is the default Last Updated July 8 2008 Page 67 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Standard Interest Rate Interest Rate For split interest rates this field shows the current rate being used Standard Method Valuation method used for standard reserve calculations e g CRVM YRT NLP etc Standard Mortality Morbidity Table Table The table used to calculate reserves Statutory or Tax Indicator An indicator defining whether the valuation file contains statutory or tax reserves
61. rred Risk Indicator X 1 EE Smoking Habit Indicator NOR AI U Unknown plus user defined Medical or Non Medical 1 Cession Type 161 161 X 1 A7 Atomatic F Facultative O Facultative Obligatory S Shopped Filler 162 289 X 289 Assumed Treaty Number 162 10 X 10 Life Index Number 172 20 X 20 Alias ID 192 20 X 20 Filler 212 239 X 239 Reinsurer Defined Filler 451 451 48 X 50 Last Updated July 8 2008 Page 41 of 78 Viewing Package Manual T3 500 Bytes Field Name Record ID Policy Number Policy Sequence Joint Sequence Insured Sequence Number Plan Code Filler Coverage Sequence Number Coverage Risk Type System Process Date Filler Policy Sequence Joint Sequence Transaction Code Transaction Effective Date Reinsurance Method Last Updated July 8 2008 R2 Electronic Files Layout T3 Transaction Record Non Expanded Expanded Location Location 1 1 3 3 16 17 18 18 20 20 30 30 35 35 37 37 39 39 47 47 48 50 51 5 53 53 61 61 Page 42 of 78 Size bytes Data Type N X 2 13 15 X 13 X 15 X 1 X 1 N wa 9 2 0 X 10 CA X 5 9 2 9 2 9 8 X 4 2 X 2 X 1 2 X 2 9 8 YYYYMMDD C Coinsurance M Modified Coinsurance X 1 NonTraditional Viewing Package Manual T3 500 Bytes Field Na
62. sought is found the first record containing the data will automatically appear If the information was not found the screen previous to the one the search was performed on will appear Searches supported by this system include Policy Number Search for the next record which has a policy number containing the key you have supplied Last Name Search for the next record containing the name you have supplied Criteria Search for the next record meeting all of the criteria that you have selected You may select any or all of the criteria choices shown in the box that will appear Each option you select will further restrict the policies that are being searched For each selection you will be directed on how to proceed with that option As you choose the criteria it will be shown in the criteria box on the right side of the screen For example you can search for a specific group of policies which all have a ceded amount equal to 100 000 issued in Hawaii Illinois New York Wisconsin or Wyoming and were issued on or after 04 Dec 1980 Please note that Criteria searches often ask additional questions For example if you choose Ceded Face Amounts you will not only have to enter the value but whether or not you want the value to be equal to greater than or lesser than Other criteria such as Issue Location allow you to enter more than one value This is done by typing the first postal abbreviation you are searching for and choosing the Ok
63. surer Last Updated July 8 2008 Page 23 of 78 Viewing Package Manual Line 3 Rating Flat Yrs ST Opt 0 1 2 Cov ADB L WP Direct Face Reins Face Reins AAR Chg Amount Chg Dt TR BASE PREM SSTD PREM Base Allow SSTD Allow Other Net Transaction Report Substandard table rating 100 standard Flat extra premium per 1000 Inforce face Number of years flat extra is effective Two character postal code of the insured s place of residence For universal life plans Not Applicable Level Death Benefit Level Amount at Risk Coverage Type Accidental Death Benefit Life Waiver of Premium Total insurance coverage on the rider or base policy Coverage ceded to reinsurer under current treaty Amount at Risk ceded to reinsurer under current treaty Amount by which the ceded amount has changed Effective date of change if applicable On New Business First Year Other and Renewal Transactions the change date represents the Reinsurance Paid To Date Transaction code Please see the Appendix Section located at the rear of the binder for a complete listing of the Transaction Codes Ceded Gross Premium Ceded Substandard Premium Allowance on ceded premium Allowance on ceded Substandard Premium May be used for extraordinary transactions outside the scope of general processing which do not fit properly under any other heading Net amount due to reinsurer per coverage At the end of each these five sections
64. the ceding and reinsuring companies wish to see in these fields We expect that it is the responsibility of the reader of this document to follow through with the originating company to verify the use of these fields It is important to realize that the data in these fields may be subject to change from time to time The client has the ability to define or redefine these fields Reinsuring Company FEIN Number Reins FEIN If the reinsuring company is domiciled in the United States of America this number is the Federal Employer ID Number For non United States companies additional codes may appear in this space Reinsuring Company Code Reinsurer Code The two character abbreviation chosen to distinguish the reinsuring company on R Last Updated July 8 2008 Page 66 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Residence Depending on what the client has sent through this field will contain the insured s postal abbreviation for residence at the time of the policy s issue or the insured s current residence Retention Indicator Retention Indicates what portion of this risk is retained by the ceding company includes prior policies if those policies are known to R Run Date The date the output file was created Sequence Written The order in which this transaction if part of a multi transaction process per policy was processed Sex The insured s gender Smoker Nonsmoker Rate Indicator Smoke Smoke
65. to search by policy number last name or criteria and the ability to generate a report an extract file or to set preferences to assist in your reporting Please note that the menu bar is only visible when the second window is normalized Each of the following eight pages contains an image of screen that will appear if an electronic file is viewed through the Viewing Package There are four types of records images per type of file These four types of records make a sandwich of policy information under a specific treaty When viewing a Transaction file the program will always open on a T1 record containing treaty information Following this will be multiple T2 and T3 records containing information on the insured and policy The file will always close with a T9 record containing additional treaty information There may be multiple T1 and T9 records per file with each pair representing a new treaty grouping When viewing a Inforce Valuation file the program will always open on a V1 record containing treaty information Following this will be multiple V2 and V3 records containing information on the insured and policy The file will always close with a V9 record containing additional treaty information There may be multiple V1 and V9 records per file with each pair representing a new treaty grouping Additional information on the types of records their layouts and definitions can be found starting later on in this document Each fi
66. u ON IO 000 00S Z L0 eW ZZ 81 SNW Z0 AeW cc 000 0st Z L0O eW Ll 9T Sea Z0 AeW LTI 000 00S 90 Inc L 69 SNW Z0 InP L 000 00 Z LO ABW OT rt SNA ZO PEW 0T 000 00v z L0 idv 0t 8b SSW 70 2dy oT ooo ose z L0 AewW 3 09 SSW 0 AeW 9 000 000 t 930 InP 6z TZ SNW v0 Inc 6c 000 008 Z L0 Unp El LE SNA 86 Unp tr 000 0SZ t L0 Unp sz 9b SSW 86 unp sz 000 0S Z 90 29d Vl TL SSW I0 2eq I 000 00 Z 90 29d Ll ET SNW 0 2eq Lt 000 0S9 Z 90 Invc ZI OZ SNM 0 TNC ZT 000 0s9 z 90 des 82 9 ena s0 des sz 000 00S Z 90 2ed l ZT SNW Z0 2 Q T 000 00t t Lo unp t ZE SNW v0 unp tc ooo ooe z L0 unp 8Z 0S SNW 0 unp ez 000 OST Z Lo unp IZ 9 SNW TO uUNnp IZ 000 0S6 Z O unp 9Z S SN I0 unc 9z ooo osp z Lo unp z yy sm to unp z 000 0sv Z 3o Tnp z 9 SNW lO Tnp Z 000 o00t Z L0 Aew z 91 end I16 AeN Z 000 0st Z 90 Inf 0Z rt SNA zoO Tnp OZ 000 0s9 Z LO eW r OZ SSW Zz6 eW l 000 0st Z L0 AeW 02 SI SNA Zz6 AewW 07 000 009 Z7 L0 Aew z E SNW I6 AEW Z 000 0Sbt Z sxeek 103 OOOTS Aad por ert Si APTA 000 0Ssv Z L0 AeW z 81 SNW 0 eW Z 000 00v Z L0 AeW Zz vt SN I6 AeW Z 000 00 Z 30 2ed z IS SNW I0 2eq z ooo ose 2 L0 4ew z E SNW l6 AeW z Qunowy OL pred a y aux eyed s2ed eouisureH W SSI JSS orlod 900c unf 0 Tn Away lqeyiAqui uon on3ns q parun soi ui dn d K3e94 OL papa 101 P p3O Package Manual lewing V Page 31 of 78 Last
67. uring which benefits are not payable Normally denoted by the number of days Disability Occupation Class DI Occ Class Occ Classification of an individual s occupation for the purpose of determining a risk of disablement and determination of premiums End of Line Final positions of each line in the ASCII file at which point a Carriage Return Line Feed has been added to maintain the proper line length for each entry Ending Date The ending date for the period being reported in this output file Filler Area defined in the layout of each file to be populated with necessary fields in the future if needed Last Updated July 8 2008 Page 60 of 78 Viewing Package Manual Glossary Alphabetical by Field Name Insurance Sub type This field further defines the product type for transactions and valuation processing Allowable values are individual first to die or last to die Insurance Type This field is used by R2 to identify the type of plan such as whole life term waiver etc Insured s First Name First The insured s forename or given name Insured s Last Name Last The insured s surname Insured s Middle Name Middle The insured s middle name or initial if applicable Insured s Name Descriptor Descriptor Additional information about an insured s name such as the title Jr Sr II etc Insured Sequence Number ns Seq An indicator for the number of individuals covered under a s
68. urrender Financial Adjustment for Cash Value Recovery Page 75 of 78 Type of Transaction Termination New Business Change Change Change Change Termination Change New Business New Business Termination Change Renewal Termination New Business Termination Termination Change Termination Change Viewing Package Manual Transaction Code TB TC TR WC WP Last Updated July 8 2008 Appendix B Transaction Codes Definition of Transaction Code Table Change Trailer Change Termination Financial Adjustment for Waiver Claims Premium Waived Page 76 of 78 Type of Transaction Change Change Termination Change Renewal Viewing Package Manual 1987 2008 Quasar Systems Inc Milwaukee Wisconsin WWW qsi r2 com email ElectronicFiles qsi 12 com
69. us please contract our office We would be happy to assist you Quasar Systems Inc 8989 N Port Washington Rd Sutte 227 Milwaukee WI 53217 Email ElectronicFiles qsi r2 com Phone 414 540 2423 Last Updated July 8 2008 Page 37 of 78 Viewing Package Manual T1 500 Bytes Field Name Record ID Filler Run Date Reinsuring Company FEIN Number U S Federal Employers Identification Number Ceding Company FEIN Number U S Federal Employers Identification Number Treaty or Contract Code Beginning Date Ending Date Currency Identifier Currency Scaling Factor Ceding Company Code Reinsuring Company Code Filler Transaction Program Version Last Updated July 8 2008 R2 Electronic Files Layout TI Transaction Record Size Data Type Values bytes I 5 see i p 5 9 8 YYYYMMDD CIE ft L5 x E 9I 9 8 YYYYMMDD 9 8 YYYYMMDD D 13b 9 Non Expanded Location Expanded Location 106 9 1 2 x 100 107 107 2 X 2 109 109 2 X 2 111 30 X 30 111 4 X 4 Transaction Report Program 115 4 X 4 Version Page 38 of 78 Viewing Package Manual R2 Electronic Files Layout TI Transaction Record T1 500 Bytes Field Name Non Expanded Expanded Size Data Type Values Location Location bytes Administrator Initials X 3 Ha Processing Office BE X 10 um Directory Code an As d Processing Type D Divo R Retro SOA File Version 141

Download Pdf Manuals

Related Search

Related Contents

George Foreman GR0072P Use & Care Manual  美容健康機器  8 Port Rackmount USB VGA KVM Switch w/ Audio  Bon souper!!! Charlo Avec Charlo, qu`est  Fleck 3150 Service Manual  A SIP User Manual - Pages Persos Chez.com  MVW 220-560 4 de DE  Manuale d`istruzioni  AS-interface-Sicherheitsmonitor Handbuch  「SC07」接点信号入出力カード 取扱説明書  

Copyright © All rights reserved. Failed to retrieve file