|
Table : DDF_POLICIES |
Description: Policy Information |
||
|
# |
Column Name |
Type |
Description |
|
B 1 |
#*REVENUE_KEY |
C 20 |
Revenue source or obligor unique identifier (See UIT Note below) |
|
B 2 |
#*POLICY_NUM |
C 20 |
Primary company's policy number assigned to an insurance cession |
|
B 3 |
PRIMARY_INSURER |
C 10 |
Primary insurer ceding a policy for reinsurance |
|
B 4 |
CURRENCY_ISO |
Alpha |
Currency ISO code |
|
B 5 |
ORIG_FX_RATE |
N 10,6 |
Original foreign currency exchange rate on CLOSED_DATE (B 18) This exchange rate should be expressed as US Dollars over Foreign currency: e.g., 1.60 for British Pounds, .164 for French Francs. Default to 1.0. |
|
B 6 |
ISSUER_NAME |
C 50 |
Name of the municipal or corporate entity issuing the debt obligation |
|
B 7 |
ISSUE_NAME |
C 50 |
Additional descriptive information about a debt obligation |
|
B 8 |
SERIES_YEAR |
C 20 |
Series and year of the debt obligation |
|
B 9 |
DATED_DATE |
Date |
Original earliest Dated Date of the bond obligation |
|
B 10 |
MARKET_TYPE |
Alpha |
How the obligation was sold (ex: New Issue; Secondary Mkt; UIT) |
|
B 11 |
INSURANCE_TYPE |
Alpha |
Coverage issued (ex: Principal∬ Debt Service Reserve) If a particular underlying maturity is Principal only or Interest only, note that in table C. |
|
B 12 |
TAX_STATUS |
C1 |
Is the insurance policy taxable? Valid values "Y" or "N". Default to "N" if unknown. |
|
B 13 |
SALE_DATE |
Date |
Date the debt obligation is sold in the primary or the secondary market. |
|
B 14 |
ORIG_POLICY_PAR_AMT |
N 14,2 |
Original par amount of the policy in US Dollars Original amount when the Primary Insurer guaranteed it on the sale date. See also field E8. |
|
B 15 |
ORIG_POLICY_EXP_AMT |
N 14,2 |
Original exposure amount of the policy in US Dollars Original amount when the Primary Insurer guaranteed it on the sale date. See also field E9. |
|
B 16 |
LEGAL_NAME |
C 100 |
Legal name of debt obligation |
|
B 17 |
POOL_IND |
C 1 |
Is the insurance cession part of a bond pool? Valid values "Y" or "N". Default to "N". |
|
B 18 |
CLOSED_DATE |
Date |
Date on which the obligation is exchanged for payment of the bond For a secondary market transaction, this is the date that the secondary market transaction is completed. |
|
B 19 |
INTERNATIONAL_IND |
C 1 |
Is the insurance cession international or domestic? Valid values "Y" or "N". Default to "N". |
|
B 20 |
SP_CAP_CHARGE_PCT |
N 10,6 |
Default rate assigned during a "depression" stress test Expressed as a percentage. For example, .06 means 6%. |
|
|
|
|
|
|
B 21 |
SP_CAP_CHARGE_BASIS |
Alpha |
Basis of capital charge can be 'P'ar or 'A'ADS Depending on what the capital charge is applied against. |
|
B 22 |
NYS_CRC |
Alpha |
New York State Contingency Reserve Code This should indicate which class this policy falls into, for purposes of classifying its contingency reserve amount. See example table below. |
|
B 23 |
CRC_BASIS |
Alpha |
Contingency Reserve Basis (Par, Earnings, Premium) |
|
B 24 |
CRC_AMT |
N 14,2 |
Contingency Reserve Amount The amount that the primary reserves against the entire policy per QUARTER. |
|
B 25 |
LOSS_RESERVES |
N 14,2 |
Loss Reserves |
|
B 26 |
PAID_LOSSES |
N 14,2 |
Paid Losses |
|
B 27 |
LOSS_ADJ_EXP_RESERV E |
N 14,2 |
Loss Adjustment Expense Reserve |
|
B 28 |
LOSS_ADJ_EXP_PAID |
N 14,2 |
Loss Adjustment Paid Expenses |
|
B 29 |
SALVAGE_PAID |
N 14,2 |
Salvage Paid |
|
B 30 |
SALVAGE_RESERVE |
N 14,2 |
Salvage Reserve |
|
B 31 |
NON_SPECIFIC_RESERVE |
N 14,2 |
Non Specific Reserve |
|
B 32 |
CONT_PROFIT_COMM_PAI D |
N 14,2 |
Contingent Profit Commission Paid |
|
B 31 |
BLANK_01 |
C 15 |
Blank Field (Reserved) |
|
B 32 |
BLANK_02 |
C 15 |
Blank Field (Reserved) |
|
B 33 |
BLANK_03 |
C 15 |
Blank Field (Reserved) |
TABLE B - NOTES on DDF_POLICIES
Removed Fields:
Location Information: Country, State and County (former B9/10/11) Since this table contains information for the intersection of a policy with a revenue source, and since the Table A – DDF_REVENUE_SOURCES) contains this information, this information is redundant here and has been removed.
UPR_AMT (former B28)
This field has been dropped and moved to Table E - DDF_REINSURED_DETAILS, see fields E17 and E18.
Fields B1/B2
For "Unit Investment Trust" types of transactions, and any types of transactions where a Policy covers more than one revenue key, there will be multiple rows in this table per policy_num.
There should one row for each unique revenue_key/policy_num combination.
Fields B20 and B21
These fields are now the only representation of capital charge information. If the information is stored in
your data model with the revenue source, simply duplicate that information for each policy associated with that revenue source.
Field B22
New York State Contingency Reserve Classification - EXAMPLE
These classifications will have different values in your actual data. However, the codes used should conform in some way to the New York State Law describing Contingency Reserve amounts to be withheld.
|
New York State Contingency Reserve |
Description |
|
A1 |
MUNICIPAL OBLIGATION BONDS |
|
A2 |
SPECIAL REVENUE BONDS |
|
A2 |
INVESTMENT GRADE IDB'S (< 7YRS OR SECURED) |
|
A3 |
UTILITY 1ST MORTGAGE OBLIGATIONS |
|
A4 |
OTHER INVESTMENT GRADE IDB'S |
|
A5 |
ALL OTHER IDB |
|
|
|
|
B1 |
INVESTMENT GRADE (<7 YRS OR SECURED) |
|
B2 |
OTHER INVESTMENT GRADE |
|
B3 |
NON-INVESTMENT GRADE CONSUMER |
|
B4 |
NON-INVESTMENT GRADE ASSET BACKED |
|
B5 |
NON-INVESTMENT GRADE - OTHER |