Premium Details Table

Table

DDF_PREMIUM_DETAILS

Description

Premium Details by Date

#

Column Name

Type

Description

D 1

#*REVENUE_KEY

C  20

Revenue source or obligor unique identifier

D 2

#*POLICY_NUM

C  20

Primary company's policy number assigned to a cession

D 3

#*CESSION_CODE

C  10

Primary company's treaty or facultative number assigned to a cession

D 4

#*REIN_COMPANY

Alpha

Company receiving cession (ex: CapRe; ENRE; AGI)

D 5

#*ATTACH_DATE

Date

Effective date of reinsured cession

D 6

#*CEDING_COMPANY

Alpha

Primary company ceding a policy for reinsurance

D 7

#*PREM_TRANS_TYPE

Alpha

Premium transaction (ex: Upfront; Initial; Subsequent; Refunding)

This field is provided to make the key unique where otherwise it would not be. Use your discretion to provide values in this field.

D 8

#*PREM_START_DATE

Date

Start date of a premium earnings period

D 9

PREM_END_DATE

Date

End date of a premium earnings period

D 10

PREM_AMT

N  14,2

Written premium dollar amount ceded to a reinsurer

This should always be in US DOLLARS. NON OPTIONAL.

D 11

PREM_TYPE

Alpha

Upfront or Installment premium

Refunded Upfront premiums should be coded as Upfront.

Also see field E20 (prem type).

D 12

BLANK_01

C 15

Blank Field (Reserved)

D 13

BLANK_02

C 15

Blank Field (Reserved)

D 14

BLANK_03

C 15

Blank Field (Reserved)

NOTES: DDF_PREMIUM_DETAILS

Removed fields:

Former fields D11, D13 through D18 – These fields have been moved to Table E – DDF_REINSURED_DETAILS

All Policies:

New key, D8, to accommodate multiple installment premiums.

Each DDF_REINSURED_DETAILS row should have at least one corresponding DDF_PREMIUM_DETAILS row.

* The sum of Prem Amt (D10) , for prem start dates (D8) in the past, should EQUAL the amount in Ceded Prem Amt ITD (E10) *

Installment Policies:
Each installment payment should be provided for payments that occur in the past.

 Installment payments predicted for the future should be included.

BlackBookLine