Table DDF_CEDED_EXCEPTIONS Description: Reinsured Payment Information # Column Name Type Description G 1 #*REVENUE_KEY C  20 Revenue source or obligor unique identifier G 2 #*POLICY_NUM C  20 Primary company's policy number assigned to a cession G 3 #*CUSIP9 C  9 9 digit number assigned to specific issues of a debt obligation G 4 #*CESSION_CODE C  10 Primary company's treaty or facultative number assigned to a cession G 5 #*REIN_COMPANY Alpha Company receiving cession (ex: CapRe; ENRE; AGI) G 6 #*ATTACH_DATE Date Effective date of reinsured cession G 7 #*CEDING_COMPANY Alpha Primary company ceding a policy for reinsurance G 8 ORIG_CEDED_PAR_AMOU NT N 14,2 Amount of the payment that has been originally ceded to the reinsurer Should equal Reinsured Percent times sum of all payments reinsured: E8 times sum of (F8 + F10) rows covered. G 9 CURR_CEDED_PAR_AMOU NT N 14,2 Amount of the payment remaining that is currently ceded to the reinsurer. Should equal reinsured percent times sum of all payments currently reinsured: E8 times sum of F8 for payment dates in the future. G 10 BLANK_01 C 15 Blank Field (Reserved) G 11 BLANK_02 C 15 Blank Field (Reserved) G 12 BLANK_03 C 15 Blank Field (Reserved)

This table has been created to express the explicit coverage of a reinsurance detail over the maturity rows in a specific policy. There are cases where:

 Multiple Reinsurance agreements exist for a certain policy  (i.e.,more than one DDF_REINSURED_DETAIL for a single DDF_POLICY) 

 The maturities covered by the multiple reinsurance agreements are different.

The first attempt to handle this condition in the data model (preliminary V3.2) was the addition of fields in the maturity row to indicate the reinsurance attached to the maturity. However, this resulted in expanding the DDF_MATURITIES table to include multiple rows where multiple reinsurance agreements exist. This mixed "reinsurance" information with "maturity" information.

This new table replaces those additional fields by simply combining the keys of the maturity rows covered with the keys of the reinsurance agreements covering the maturity.

OPTIONAL

There are three possible options for primaries to provide data in these tables:

(a) Those primaries that have no cases of the above may leave this table empty.

Those primaries where some of the above occur, there are two choices:

(b) Provide data for every reinsurance cession covered.

Provide data only for those cases where the above anomoly occurs. If this course is taken, the following rule will apply: If a single row is in this table for a policy, then this table must "govern" the entire policy.