Table DDF_REINSURED_DETAILS Description Reinsurers Transaction / Detail Information # Column Name Type Description E 1 #*REVENUE_KEY C 20 Revenue source or obligor unique identifier E 2 #*POLICY_NUM C 20 Primary company's policy number assigned to a cession E 3 #*CESSION_CODE C 10 Primary company's treaty or facultative number assigned to a cession
E 4 #*REIN_COMPANY Alpha Company receiving cession (ex: CapRe; ENRE; AGI) E 5 #*ATTACH_DATE Date Effective date of reinsured cession E 6 #*CEDING_COMPANY Alpha Primary company ceding a policy for reinsurance E 7 CESSION_TYPE Alpha Treaty or other cession identifier (ex: Fac; Quota Share; Excess of Loss; First Loss) E 8 CEDED_PAR_AMT N 14,2 Par amount ceded to a reinsurer in US Dollars Original Ceded Par on Attach Date E 9 CEDED_EXP_AMT N 14,2 Exposure amount ceded to a reinsurer in US Dollars Original ceded Exposure on Attach Date E 10 CEDED_PREM_AMT_ITD N 14,2 Total premium amount, in US dollars, ceded to a reinsurer.
This amount should be the inception-to-date dollar amount of premiums actually paid to the
reinsurer. E 11 CEDED_PREM_PCT N 10,6 Premium ceded to a reinsurer, as a percentage of the policy premium
E 12 CEDED_PAR_PCT N 10,6 Par ceded to a reinsurer, as a percentage of the policy par E 13 CEDED_EXP_PCT N 10,6 Exposure ceded to reinsurer, as a percentage of the policy exposure
E 14 CEDED_FINAL_MAT_DAT E Date Final maturity date of an individual reinsurance cession E 15 COMPLETE_POLICY_IND C 1 Does the reinsurance cession cover all inforce maturity dates? Y or N
E 16 CEDING_COMM_PCT N 10,6 Percentage of ceding commission paid to cover administrative costs
E 17 GAAP_PREM_UPR N 10,6 Gaap Basis: portion of E10 that is unearned at time of data feed E 18 STAT_PREM_UPR N 10,6 Statutory Basis: portion of E10 that is unearned at time of data feed E 19 PREM_RATE N 10,6 Premium rate collected on a policy annually for installment premiums (current effective date) This should be expressed in such a way that this rate multiplied against the amount indicated by E23 results in the Premium Amount for the year
. (Multiplied by the Prem_fx_rate, if applicable). E 20 PREM_TYPE Alpha Upfront or Installment or Bifurcated premium. Upfront if all D11 fields are Upfront. Installment if all D11 fields are Installment. Bifurcated if D11 fields are both Upfront and Installment E 21 PREM_FREQ Alpha Frequency of premium payments E 22 PREM_FX_RATE N 14,7 Premium exchange rate on foreign transactions at time of Premium Calculation.
This exchange rate , where applicable, should be expressed as US Dollars over Foreign currency
: E.g. 1.60 for British Pounds, .164 for French Francs. Where not applicable, should default to 1.0 E 23 PREM_BASIS_TYPE Alpha Premium Calculation Basis (ex: Orig DS; OS DS; OS Par) E 24 PREM_BASIS_PCT N 10,6 Premium basis percentage on Orig DS; OS DS; OS Par Nominal rate E 25 PREM_RATE_USAGE N 10,6 Premium rate collected on commercial paper facility usage E 26 PREM_CURRENCY_ISO Alpha Premium currency ISO code 'USD' if US dollars. E 27 BLANK_01 C15 Blank Field (Reserved) E 28 BLANK_02 C 15 Blank Field (Reserved) E 29 BLANK_03 C 15 Blank Field (Reserved)
TABLE E - NOTES on DDF_REINSURED_DETAILS:
Removed Fields: Former specification place-holders have been removed.
Field E10 : This, expressed in US Dollars, is the total gross premium amount that has been calculated as due to the reinsurer , before ceding commission is calculated, as of the date of the DDF feed. This is an inception-to-date field, and is not optional. The sum of these amounts should "tie" to the Bordereau reports.
Fields E17 and E18: New.
Fields E19 through E26: New.
These fields, containing a description of the premium associated with each reinsurance agreement, were moved from table D.
The descriptions of each field are taken from Table D.
(The descriptive changes with italics show how the description changed from earlier versions of this specification, when the fields were in Table D).
NOTE FOR REINSURERS ONLY:
Retrocessions should be represented as negative percents ceded.
The field E4 will contain the reinsurer; field E6 will contain the company accepting the retrocession.
GENERAL NOTE: Handling changes to Reinsurance Agreements
There should be one reinsurance detail record per "real" agreement with a reinsurer.
In cases were subsequent adjustments to premiums occur, those adjustments should be reflected in Table D,
but never in Table E. For instance:
Quarter one: Table E – Reins Agreement A – contains:
Total Inception-to-date premium amt: $1000
Ceded Par Percent: 12%
Type of Premium: Upfront
Table D – (Reinsurance Keys) plus: Date: 3/1/99, Trans type: "I", Premium Type: "U", Amount: $1000
After the initial data feed, it is discovered that the initial amount was incorrect, and a premium adjustment is made. This should be reflected in the following way: adjust the details in Table E, but do not provide a new record. Show the adjustment as a separate row in Table D.
Quarter three: Table E – Reins agreement A - contains
Total Inception-to-date premium amt: $800
Ceded Par Percent 10%
Type of Premium: Upfront
Table D – (Reinsurance Keys) plus: Date: 3/1/99, Trans type: "I", Premium Type: "U", Amount: $1000
Date: 7/1/99, Trans type: "I", Premium Type: "U", Amount: ($200)