Maturities Table

Table

DDF_MATURITIES

Description

Maturity Information

#

Column Name

Type

Description

C 1

#*REVENUE_KEY

C  20

Revenue source or obligor unique identifier

C 2

#*POLICY_NUM

C  20

Primary company's policy number assigned to a cession

C 3

#*CUSIP9

C  9

9 digit number assigned to specific issues of a debt obligation

C 4

FINAL_MATURITY_DATE

Date

Final maturity date associated with each cusip9

C 5

MATURITY_TYPE

Alpha

Fixed or variable rate coupon

C 6

PRIN_FREQ

Alpha

Frequency of principal payments

C 7

INT_FREQ

Alpha

Frequency of interest payments (daily, monthly, weekly)

C 8

INT_FREQ_IND

C 3

Identifies the number of days/months/weeks in the interest period

C 9

FIRST_INT_PAYMENT_DA TE

Date

First interest payment date of an individual policy

C 10

INT_ACCRUAL_START_DA TE

Date

First interest accrual date of an individual policy

C 11

CONVERSION_DATE

Date

Date when variable debt obligation converts to a fixed rate obligation

C 12

REFUND_IND

Alpha

Indicator of a refunding (i.e. full, partial, none)

C 13

REFUND_DATE

Date

Date on which a refunding occurs

C 14

ORIGINAL_BOND_AMT

N  14,2

The original total Par Payment amount, expressed in US dollars, that this cusip represents in this policy.

C 15

ACTUAL_OS_PAR

N  14,2

The current outstanding Par Payment amount remaining.

C 16

ACTUAL_OS_EXPO

N  14,2

The current outstanding Exposure amount remaining.

C 17

ISSUED_PCT

N  10,6

Percent of this maturity insured by primary (1.00 default).

C 18

PAYMENTS_INCLUDED

C1

Indicator that ddf_maturity_payments records have been included for this maturity. Y = Yes, N = No.

C 19

PO_IO_IND

C1

P = Principal Only; I = Interest Only. Default to null.

C 20

BLANK_01

C15

Blank Field (Reserved)

C 21

BLANK_02

C15

Blank Field (Reserved)

C 22

BLANK_03

C15

Blank Field (Reserved)

NOTES: DDF_MATURITIES

Removed fields : various prior version of this table had information relating to the reinsurance on the cusip – this information has been moved to the new Table G: DDF_CEDED_EXCEPTIONS

NEW FIELDS

C14, C15 and C16 : Represent summary of the underlying payment schedule amounts. See also notes under table F.

C14 : Represents the Original Par amount, in US dollars, insured by the primary for the cusip in this maturity in this policy. This amount should be the same as the sum of the underlying Par Payment amounts (actual par amount (F8) + delta par amount (F10)) multiplied by the issued_pct (C17) multiplied by the original FX rate (B5). (note: F10 is normally 0, C17 is normally 1.0, and B5 is normally 1.0)

C15: Represents the Current Par amounts, in US dollars, insured by the primary for the Cusip in this maturity in this policy. This amount should be the same as the sum of the underlying Current Par Payment (F8) multiplied by the issued_pct (C17) multiplied by the original FX rate (B5).

C16 : Represents the Current Exposure amounts, in US dollars, insured by the primary for the Cusip in this maturity in this policy.  This amount should be the calculated remaining exposure amount that the primary is insuring using the current par amount and other details of the maturity.

Commercial Paper and other Structured Finance transactions:

C14 represents the original pool balance, or the maximum amount for a Commercial Paper facility.

C15 and C16 represent the current pool balance (or the Commercial Paper Utilization) as of the date of the DDF feed.

C17: NEW FIELD – To be used if applicable to your data, otherwise default to 1.00.

If the payment schedule included in Table F – DDF_MATURITY_PAYMENT is only partially guaranteed, use this field to indicate the percent insured. It represents the PRIMARY'S insured portion of the underlying payments. The default value is 1.00 (100%).

C19: NEW FIELD : Indicator to be used if  Principal only is insured, or Interest only is insured. Leave empty if not applicable.

[FG-DDF Home] [DDF Tables] [ER Diagram] [Contact List] [Credits] [Downloads] [DDF Development]