|
|
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.
|