2016-02-26 | DOF 5427387Added
This circular modifies the Single Insurance and Surety Circular. It extends the deadline for surety institutions that have reached the accumulation limit of the surety contingency reserve and applied for comprehensive statutory reform to convert into insurance institutions in the surety branch. Such institutions may now maintain these remnants for transfer to the catastrophic risk reserve of surety insurance if their application was submitted before February 29, 2016, provided they also present a technical justification. Additionally, the circular modifies Annex 38.1.4., which specifies the information and documentation requirements for the Regulatory Report on Technical Reserves (RR-3), to provide greater clarity to the regulations without altering their scope.
Official Gazette: 02/26/2016
AMENDING CIRCULAR 4/16 OF THE SINGLE INSURANCE AND SURETY CIRCULAR
On the margin a seal with the National Shield, which reads: United Mexican States.- Ministry of Finance and Public Credit.- National Insurance and Surety Commission.
AMENDING CIRCULAR 4/16 OF THE SINGLE INSURANCE AND SURETY CIRCULAR (Eighteenth Transitory Provision and Annex 38.1.4.)
The National Insurance and Surety Commission, based on the provisions of articles 366, section II, and 372, section VI, of the Law on Insurance and Surety Institutions, and
WHEREAS
On April 4, 2013, the "Decree by which the Law on Insurance and Surety Institutions is issued and various provisions of the Law on Insurance Contracts are reformed and added" was published in the Official Gazette of the Federation, through which, in terms of its Article First, the Law on Insurance and Surety Institutions is issued.
On December 19, 2014, the Single Insurance and Surety Circular was published in the Official Gazette of the Federation, through which the general provisions emanating from the Law on Insurance and Surety Institutions are made known, in order to provide legal certainty regarding the regulatory framework to which insurance institutions and mutual societies, surety institutions and other persons and entities subject to the inspection and surveillance of the National Insurance and Surety Commission must adhere in the development of their operations.
In terms of the provisions of the Eighteenth Transitory Provision of the Single Insurance and Surety Circular, Surety Institutions that had reached the accumulation limit of the surety contingency reserve established in Provision 5.16.2, and had submitted the application for comprehensive statutory reform for their conversion into an insurance institution in the surety branch, had until December 15, 2015, to maintain said remnants in order to be transferred to the catastrophic risk reserve of surety insurance.
Given that the period referred to in the preceding paragraph concluded, the National Insurance and Surety Commission has deemed it necessary to extend the term provided for in the Eighteenth Transitory Provision of the Single Insurance and Surety Circular for the submission of the authorization application referred to, and to contribute to the implementation and adaptation of the operational processes of surety institutions so that they are in a position to carry out the procedures for their conversion into insurance institutions authorized to operate the surety branch.
In accordance with the provisions of article 218 of the Law on Insurance and Surety Institutions, insurance institutions shall constitute and value the technical reserves referred to in articles 216, 217 and 223 of the same Law, in accordance with the general provisions issued by the National Insurance and Surety Commission, considering the principles set forth in article 218 itself.
In terms of the provisions of article 224 of the Law on Insurance and Surety Institutions, the aforementioned Commission shall determine, by means of general provisions, the form and terms in which insurance institutions and surety institutions must inform and prove to it everything related to their technical reserves.
In accordance with Provision 38.1.4. of the Single Insurance and Surety Circular, the Regulatory Report on Technical Reserves (RR-3) shall be submitted in accordance with Annex 38.1.4., and its delivery shall adhere to the procedure indicated in Chapters 39.1. and 39.3. of the aforementioned Circular.
From the application that the National Insurance and Surety Commission has carried out of the provisions of the aforementioned Annex 38.1.4., said Commission has deemed it necessary, in order to provide legal certainty to regulated entities, to make adjustments to the aforementioned Annex, in order to provide greater clarity to the regulations without such adjustments modifying their scope.
For the foregoing, the National Insurance and Surety Commission has resolved to issue the following modification to the Single Insurance and Surety Circular in the following terms:
AMENDING CIRCULAR 4/16 OF THE SINGLE INSURANCE AND SURETY CIRCULAR (Eighteenth Transitory Provision and Annex 38.1.4.)
FIRST.- The Eighteenth Transitory Provision of the Single Insurance and Surety Circular is modified to read as follows:
"EIGHTEENTH TRANSITORY PROVISION.- Surety Institutions that have reached the accumulation limit of the surety contingency reserve established in Provision 5.16.2, and had submitted the application for comprehensive statutory reform for their conversion into an Insurance Institution in the surety branch before February 29, 2016, may maintain said remnants to be transferred to the catastrophic risk reserve of surety insurance. In this case, Surety Institutions must submit to the Commission a technical justification for the amount of the surety contingency reserve intended to be transferred, considering the accumulation limit of said reserve provided for in Provision 5.16.2 and the activity plan that served as the basis for requesting the operation of the surety branch."
SECOND.- Annex 38.1.4. of the Single Insurance and Surety Circular is modified.
TRANSITORY
SOLE.- This Amending Circular shall enter into force on the day following its publication in the Official Gazette of the Federation.
The foregoing is made known to you, based on articles 366, section II, and 372, section VI, of the Law on Insurance and Surety Institutions.
Sincerely Effective Suffrage. No Reelection.
Mexico City, February 15, 2016. - The President of the National Insurance and Surety Commission, Norma Alicia Rosas Rodríguez .- Signature.
ANNEX 38.1.4 INFORMATION AND DOCUMENTATION RELATED TO THE REGULATORY REPORT ON TECHNICAL RESERVES (RR-3)
For the purposes of the provisions of Provision 38.1.4., Institutions and Mutual Societies must submit, as indicated, the information and documentation related to the regulatory report on technical reserves (RR-3), as indicated below:
Institutions and Mutual Societies shall submit the Regulatory Report on Technical Reserves (RR-3), within 20 business days after the close of December and within 15 business days after the close of each quarter or each month, in case they have the authorization referred to in Provision 5.8.13 of this Single Circular.
In the case of Insurance Institutions and Mutual Societies, with the exception of Insurance Institutions authorized to practice pension insurance derived from social security laws.
Information delivery control report for Insurance Institutions and Mutual Societies
Quarterly, the RR3CERTS product must be sent, which must contain the Excel format file corresponding to the information delivery control report, in accordance with what is indicated below:
a) For its submission, the product must be encrypted in a single file in .ZIP.PGP format, whose name must consist of 21 alphanumeric characters, ordered as follows:
b) The first eight positions shall correspond to the specific product identifier: "RR3CERTS".
c) In the ninth position, the company type code must be written:
| Code | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the tenth to the thirteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. Said number must be preceded by zeros until it occupies the four positions.
e) From the fourteenth to the seventeenth positions, the year must be written.
f) In the eighteenth and nineteenth positions, the month being reported must be written.
g) In the twentieth and twenty-first positions, the last day of the month being reported must be indicated.
Example: Company code: "S" Company number: "0009" Day: ("30") Month: June ("06") Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | C | E | R | T | S | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .ZIP |
| .PGP |
The Excel format file corresponding to the information delivery control
The Excel format file corresponding to the information delivery control report, as well as its respective user manual, will be available on the Commission's Website (www.cnsf.gob.mx) with the name "RR3CERTS.xls". For its submission, said file must be renamed as follows:
The name must consist of 24 alphanumeric characters that must be ordered as follows:
a) In the first eleven positions, the specific file identifier must be written: "RR3CERTSFMT".
b) In the twelfth position, the company type code must be written.
| Code | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
c) From the thirteenth to the sixteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. Said number must be preceded by zeros until it occupies the four positions.
d) From the seventeenth to the twentieth positions, the year must be written.
e) In the twenty-first and twenty-second positions, the month being reported must be written.
f) In the twenty-third and twenty-fourth positions, the last day of the month being reported must be written.
Example: Company code: "S" Company number: "0009" Day: "30" Month: June ("06") Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | C | E | R | T | S | F | M | T | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .XLS |
The Excel format corresponding to the information delivery control report must be filled in as follows:
i) The information contained in the cells of the column named "Report" shall be that related to the names of all reports indicated in this Regulatory Report, which may be submitted by Insurance Institutions and Mutual Societies.
ii) For each row, each cell of the column named "Submitted" must be filled with the text "YES", in case the report whose name is indicated in the same row in the "Report" column is sent by the Insurance Institution or Mutual Society in the quarter or close of the fiscal year in question; otherwise, the cell of the column named "Submitted" must be filled with the text "NO".
I. Unearned premium reserve
Information with quarterly delivery frequency
The report of the results of the valuation of the unearned premium reserve for each branch or type of insurance, with quarterly delivery frequency, shall consist of the following:
1.- The RR3RRCCV product, which must contain the text files of the valuation of the unearned premium reserve, the Excel format file corresponding to the summary of the valuation of the unearned premium reserve, and the certification document or documents, in PDF format, corresponding to the valuation of the unearned premium reserve, signed by the actuaries responsible for it, as referred to in the immediate following subsections 1, 2 and 3, in accordance with what is indicated below:
a) For its submission, the product must be encrypted in a single file in .ZIP.PGP format, whose name must consist of 21 alphanumeric characters, ordered as follows:
b) The first eight positions shall correspond to the specific product identifier: "RR3RRCCV".
c) In the ninth position, the company type code must be written:
| Code | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the tenth to the thirteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. Said number must be preceded by zeros until it occupies the four positions.
e) From the fourteenth to the seventeenth positions, the year must be written.
f) In the eighteenth and nineteenth positions, the month being reported must be written.
g) In the twentieth and twenty-first positions, the last day of the month being reported must be indicated.
Example: Company code: "S" Company number: "0009" Day: ("30") Month: June ("06") Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | R | R | C | C | V | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .ZIP |
| .PGP |
1.1.- The valuation of the unearned premium reserve
From 2 to 23 reports in text file format, of the results of the valuation of each branch or type of insurance, whose names must consist of 26 alphanumeric characters, which must be ordered as follows:
a) In the first eleven positions, the specific file identifier must be written: "RR3RRCCVRES".
b) In the twelfth and thirteenth positions, the report code must be written.
| Report Code | Description |
|---|---|
| 01 | Unearned premium reserve for short-term life insurance |
| 02 | Unearned premium reserve for long-term life insurance |
| 03 | Unearned premium reserve for reinsurance assumed from life insurance |
| 04 | Unearned premium reserve for life insurance by currency |
| 05 | Unearned premium reserve for accidents and illnesses |
| 06 | Unearned premium reserve for accidents and illnesses from reinsurance assumed |
| 07 | Unearned premium reserve for accidents and illnesses by currency |
| 08 | Unearned premium reserve for damages |
| 09 | Unearned premium reserve for damages from reinsurance assumed |
| 10 | Unearned premium reserve for damages by currency |
| 11 | Unearned premium reserve for reinsurance assumed |
| 12 | Large products |
| 13 | Large risks |
| 14 | Microinsurance |
| 15 | Agricultural and animal |
| 16 | Insurance with a savings component |
| 17 | Credit-linked insurance |
| 18 | Standardized basic products |
| 19 | Mandatory civil liability vehicle insurance |
| 20 | Earthquake insurance |
| 21 | Hurricane and other hydrometeorological risks insurance |
| 22 | Mass insurance |
| 23 | Responsible parties |
c) In the fourteenth position, the company type code must be written.
| Code | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. Said number must be preceded by zeros until it occupies the four positions.
e) From the nineteenth to the twenty-second positions, the year must be written.
f) In the twenty-third and twenty-fourth positions, the month being reported must be written.
g) In the twenty-fifth and twenty-sixth positions, the last day of the month being reported must be written.
Example: Report: 01 Company code: "S" Company number: "0009" Day: ("30") Month: June ("06") Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | R | R | C | C | V | R | E | S | 0 | 1 | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .TXT |
Each of the reports of results of the valuation of the unearned premium reserve shall contain the fields described below for each of them, which must be reported in a matrix arrangement in which each listed field must be delimited by the character known as pipe ("|") to the left and right of each field, except for the first and last of these, in which case they must only be delimited by pipes to the right and left, respectively. Each record shall correspond to the detail of the information by branch or type of insurance, according to each operation.
The number of fields and records shall be fixed and shall depend on each report, so that, when a field or a record is not applicable in a given report, it must be left empty.
Figures must be reported in national currency at the exchange rate corresponding to the currency or monetary unit in question, on the valuation date. For these purposes, the value of the exchange rate of the index or currency in question, published in the Official Gazette of the Federation on the valuation date, must be used.
a) Reports of "Unearned premium reserve for short-term life insurance", "Unearned premium reserve for accidents and illnesses" and "Unearned premium reserve for damages", Report Code 01, 05 and 08, respectively.
For these reports, short-term insurance shall be understood as those whose duration is less than or equal to one year, or damage and accident and illness insurance that operates in the multi-year or poly-annual modality.
These reports must contain the following information regarding the unearned premium reserve for short-term life insurance, accidents and illnesses, and damages, originating from the total operation (direct and assumed), ceded, and recoverable amounts, which is defined below and disaggregated according to the types of insurance corresponding to each operation.
Field 1: Branch or type of insurance.- Must report, in each record, the name of the branch or type of insurance that corresponds, as indicated in the definition of records that follows this definition of fields.
Example for short-term life insurance. Field 1, in record 1, must contain the text: Individual life insurance
Example for accident and illness insurance. Field 1, in record 6, must contain the text: Collective personal accidents
Example for damage insurance. Field 1, in record 5, must contain the text: Agricultural and animal
Field 2: Unearned risk premium.- Must correspond to the amount of the unearned risk premium of policies in force or in advance issuance, integrated by the sum of the unearned risk premium of each of the policies, certificates, or endorsements in force or in advance issuance, for short-term and multi-year insurance.
Field 3: BEL-future obligations for the covered risk.- Must report the best estimate of the future cash flows of obligations of the Insurance Institution or Mutual Society.
Field 4: Future premiums not considered in the premium debtor.- Must report future premiums that, where applicable, have not been registered as premium debtor and have been directly deducted in the calculation of the unearned premium reserve.
Field 5: BEL-administration expenses.- Must report the best estimate of administration expenses in accordance with what is registered in the valuation method of the unearned premium reserve.
Field 6: Other future costs.- Must report other future costs that, where applicable, have been considered in the calculation of the unearned premium reserve and that do not correspond to the amount of the BEL for risk and the BEL for expenses. These may be costs such as future dividends or surrenders that have not formed part of the BEL for risk or the BEL for expenses. There is no obligation to report anything in this item when there is nothing to report.
Field 7: Risk margin.- Must report the amount of the risk margin corresponding to the policy in question.
Field 8: Amount of the unearned premium reserve.- Refers to the amount of the unearned premium reserve, which incorporates the part corresponding to the BEL for future obligations for the covered risk, BEL for administration expenses, other future costs and the risk margin, deducting, where applicable, future premiums not considered in the premium debtor.
Field 9: Amount of ceded premiums for policies in force.- The amount of the premium issued ceded in proportional reinsurance shall be indicated.
Field 10: Reinsurance recoverable amounts.- Must report the amount of reinsurance recoverable amounts that have been calculated as part of the valuation of the unearned premium reserve, considering the probability of default.
In each record, the information reported in fields 2 to 8 must correspond to the branch or type of insurance reported in field 1, as defined below:
In the case of reports containing information on life insurance types of operation.
31 records must be reported, as follows.
Record 1: Individual life insurance.- The totals of the information corresponding to the basic benefits and additional benefits of individual life insurance plans shall be reported.
Record 2: Basic benefits.- The totals of the information corresponding to the basic benefits of individual life insurance plans shall be reported.
Record 3: Term life insurance.- Information corresponding to the basic benefits of individual life insurance plans that cover only the risk of death for a temporary term of n years shall be reported.
Record 4: Endowment insurance.- Information corresponding to the basic benefits of individual life insurance plans that cover the risk of death and provide for survival payments shall be reported.
Record 5: Pure endowment insurance.- Information corresponding to the basic benefits of individual life insurance plans in which the benefit consists of the payment of an amount in case of survival of the insured shall be reported.
Record 6: Other insurance.- Information corresponding to the basic benefits of individual life insurance plans that cannot be classified in the previous categories may be reported.
Record 7:
Additional benefits.- The totals of the information corresponding to additional benefits of individual life insurance plans shall be reported.
Record 8:
Accidental death.- The information corresponding to additional benefits of individual life insurance in which the granting of benefits in case of accidental death is provided shall be reported.
Record 9:
Disability.- The information corresponding to additional benefits of individual life insurance in which the granting of benefits in case of insured's disability is provided shall be reported.
Record 10:
Other additional benefits.- Information corresponding to additional benefits of individual life insurance that cannot be classified in the above categories shall be reported.
Record 11:
Group life with employment relationship.- The totals of the information corresponding to the basic and additional benefits of group life insurance plans with an employment relationship between the insured and the policyholder shall be reported.
Record 12:
Basic benefits.- The totals of the information corresponding to the basic benefits of group life insurance plans with an employment relationship shall be reported.
Record 13:
Term life insurance.- The information corresponding to the basic benefits of group life insurance plans with an employment relationship that cover only the risk of death temporarily shall be reported.
Record 14:
Endowment insurance.- The information corresponding to the basic benefits of group life insurance plans with an employment relationship that cover the risk of death and provide payments for survival shall be reported.
Record 15:
Pure endowment insurance.- The information corresponding to the basic benefits of group life insurance plans with an employment relationship in which the benefit consists of the payment of an amount in case of the insured's survival shall be reported.
Record 16:
Other insurance.- Information corresponding to the basic benefits of group life insurance plans with an employment relationship that cannot be classified in the above categories may be reported.
Record 17:
Additional benefits.- The totals of the information corresponding to the additional benefits of group life insurance plans with an employment relationship shall be reported.
Record 18:
Accidental death.- The information corresponding to additional benefits of group life insurance with an employment relationship, in which the granting of benefits in case of accidental death is provided, shall be reported.
Record 19:
Disability.- The information corresponding to additional benefits of group life insurance with an employment relationship, in which the granting of benefits in case of insured's disability is provided, shall be reported.
Record 20:
Other additional benefits.- Information corresponding to additional benefits of group life insurance with an employment relationship that cannot be classified in the above categories shall be reported.
Record 21:
Group life without employment relationship.- The totals of the information corresponding to the basic and additional benefits of group life insurance plans in which there is no employment relationship between the insured and the policyholder shall be reported.
Record 22:
Basic benefits.- The totals of the information corresponding to the basic benefits of group life insurance plans without an employment relationship shall be reported.
Record 23:
Term life insurance.- The information corresponding to the basic benefits of group life insurance plans without an employment relationship that cover only the risk of death temporarily shall be reported.
Record 24:
Endowment insurance.- The information corresponding to the basic benefits of group life insurance plans without an employment relationship that cover the risk of death and provide payments for survival shall be reported.
Record 25:
Pure endowment insurance.- The information corresponding to the basic benefits of group life insurance plans without an employment relationship in which the benefit consists of the payment of an amount in case of the insured's survival shall be reported.
Record 26:
Other insurance.- Information corresponding to the basic benefits of group life insurance plans without an employment relationship that cannot be classified in the above categories may be reported.
Record 27:
Additional benefits.- The totals of the information corresponding to the additional benefits of group life insurance plans without an employment relationship shall be reported.
Record 28:
Accidental death.- The information corresponding to additional benefits of group life insurance without an employment relationship, in which the granting of benefits in case of accidental death is provided, shall be reported.
Record 29:
Disability.- The information corresponding to additional benefits of group life insurance without an employment relationship, in which the granting of benefits in case of insured's disability is provided, shall be reported.
Record 30:
Other additional benefits.- Information corresponding to additional benefits of group life insurance without an employment relationship that cannot be classified in the above categories shall be reported.
Record 31:
Total short-term life: The result of the sum of the values corresponding to records 1, 11, and 21 shall be reported.
In the case of reports containing the information of the lines or types of insurance of the accidents and diseases operation:
10 records shall be reported, as follows:
Record 1:
Medical expenses.- The totals of the information corresponding to individual and collective medical expense insurance shall be reported.
Record 2:
Individual medical expenses: The information corresponding to individual medical expense insurance shall be reported.
Record 3:
Collective medical expenses: The information corresponding to collective medical expense insurance shall be reported.
Record 4:
Personal accidents: The totals of the information corresponding to individual and collective personal accident insurance shall be reported.
Record 5:
Individual personal accidents: The information corresponding to individual personal accident insurance shall be reported.
Record 6:
Collective personal accidents: The information corresponding to collective personal accident insurance shall be reported.
Record 7:
Health: The totals of the information corresponding to individual and collective health insurance shall be reported.
Record 8:
Individual health: The information corresponding to individual health insurance shall be reported.
Record 9:
Collective health: The information corresponding to collective health insurance shall be reported.
Record 10:
Total accidents and diseases: The result of the sum of the values corresponding to records 1, 4, and 7 shall be reported.
In the case of reports containing the information of the lines of the damage operation:
12 records shall be reported, as follows:
Record 1:
Civil liability and occupational risks.- The information corresponding to civil liability and occupational risk insurance shall be reported.
Record 2:
Marine and transport.- The information corresponding to marine and transport insurance shall be reported.
Record 3:
Fire.- The information corresponding to fire insurance shall be reported.
Record 4:
Earthquake and other catastrophic risks.- The information corresponding to earthquake and other catastrophic risk insurance shall be reported.
Record 5:
Agricultural and animal.- The information corresponding to agricultural and animal insurance shall be reported.
Record 6:
Automobiles.- The information corresponding to automobile insurance shall be reported.
Record 7:
Credit.- The information corresponding to credit insurance shall be reported.
Record 8:
Miscellaneous.- The information corresponding to miscellaneous insurance shall be reported.
Record 9:
Suretyship.- The information corresponding to suretyship insurance shall be reported.
Record 10:
Housing credit.- The information corresponding to housing credit insurance shall be reported.
Record 11:
Financial guarantee.- The information corresponding to financial guarantee insurance shall be reported.
Record 12:
Total damages: The sum of the values corresponding to the above records of the damage operation shall be reported.
b) Report of "Reserve for unearned premiums of long-term life insurance", Report Key 02.
For this report, long-term life insurance shall be understood as those life insurance policies whose term is greater than one year.
The report shall contain 31 records, with the following information regarding the reserve for unearned premiums of long-term life insurance, originating from the total operation (direct and assumed), ceded, and recoverable amounts, and disaggregated according to the types of insurance defined below.
Field 1:
Type of insurance.- The type of insurance corresponding shall be reported in each record, according to the definition presented below.
Field 2:
BEL-future obligations The best estimate of the future obligation flows associated with the reserve for unearned premiums shall be reported, which must include the risk portion covered, surrenders, acquisition costs, administrative expenses, and dividends.
Field 3:
Administrative expenses (Expense Provision).- The best estimate of future administrative expenses shall be reported.
Field 4:
Risk margin.- The amount of the corresponding risk margin shall be reported.
Field 5:
Amount of the reserve for unearned premiums.- This refers to the amount of the reserve for unearned premiums, which incorporates the portion corresponding to the BEL and the risk margin.
Field 6:
Amount of ceded premiums of in-force policies.- The amount of the ceded premium in proportional reinsurance shall be indicated.
Field 7:
Reinsurance recoverables.- The amount of recoverables from ceded reinsurance, obtained from the valuation, considering the probability of default, shall be reported.
In each record, the information reported in fields 2 to 7 shall correspond to the type of insurance reported in field 1, as defined below:
Record 1:
Individual life insurance.- The totals of the information corresponding to the basic and additional benefits of individual life insurance plans shall be reported.
Record 2:
Basic benefits.- The totals of the information corresponding to the basic benefits of individual life insurance plans shall be reported.
Record 3:
Traditional.- The information corresponding to traditional individual life insurance plans (term, endowment, whole life, etc.) that are not classified as flexible type plans, investment plans, or private pension plans shall be reported.
Record 4:
Flexible.- The information corresponding to individual life insurance plans classified as flexible or investment plans, based on the characteristics of premium payment and reserve formation, as recorded in the technical note corresponding to each product, shall be reported.
Record 5:
Pensions.- The information corresponding to private pension plans, as established in Article 27, fraction I, second paragraph of the LISF, shall be reported.
Record 6:
Other.- The information corresponding to individual life insurance plans whose characteristics are special and differ from or do not adjust to the characteristics described for the plans classified in the previous subsections shall be reported.
Record 7:
Additional benefits: The totals of the information corresponding to the additional benefits of individual life insurance plans shall be reported.
Record 8:
Accidental death: The information corresponding to additional benefits of individual life insurance, in which the granting of benefits in case of accidental death is provided, shall be reported.
Record 9:
Disability: The information corresponding to additional benefits of individual life insurance, in which the granting of benefits in case of insured's disability is provided, shall be reported.
Record 10:
Other additional benefits: Information corresponding to additional benefits of individual life insurance that cannot be classified in the above categories shall be reported.
Record 11:
Group life with employment relationship: The totals of the information corresponding to the basic and additional benefits of group life insurance plans with an employment relationship between the insured and the policyholder shall be reported.
Record 12:
Basic benefits.- The totals of the information corresponding to the basic benefits of group life insurance plans with an employment relationship shall be reported.
Record 13:
Traditional.- The information corresponding to basic benefits of group life insurance plans with an employment relationship (term, endowment, whole life, etc.), that are not classified as flexible type plans or private pension plans, shall be reported.
Record 14:
Flexible.- The information corresponding to basic benefits of group life insurance plans with an employment relationship, classified as flexible type plans, based on the characteristics of premium payment and reserve formation, as recorded in the technical note corresponding to each product, shall be reported.
Record 15:
Pensions.- The information corresponding to private pension plans, as established in Article 27, fraction I, second paragraph of the LISF, shall be reported.
Record 16:
Other.- The information corresponding to basic benefits of group life insurance plans with an employment relationship, whose characteristics are special and differ from or do not adjust to the characteristics described for the plans classified in the previous subsections, shall be reported.
Record 17:
Additional benefits: The totals of the information corresponding to the additional benefits of group life insurance plans with an employment relationship shall be reported.
Record 18:
Accidental death: The information corresponding to additional benefits of group life insurance with an employment relationship, in which the granting of benefits in case of accidental death is provided, shall be reported.
Record 19:
Disability: The information corresponding to additional benefits of group life insurance with an employment relationship, in which the granting of benefits in case of insured's disability is provided, shall be reported.
Record 20:
Other additional benefits: Information corresponding to additional benefits of group life insurance with an employment relationship that cannot be classified in the above categories shall be reported.
Record 21:
Group life without employment relationship: The totals of the information corresponding to the basic and additional benefits of long-term group life insurance plans without an employment relationship shall be reported.
Record 22:
Basic benefits.- The totals of the information corresponding to the basic benefits of group life insurance plans without an employment relationship shall be reported.
Record 23:
Traditional.- The information corresponding to basic benefits of group life insurance plans without an employment relationship (term, endowment, whole life, etc.), that are not classified as flexible type plans or private pension plans, shall be reported.
Record 24:
Flexible.- The information corresponding to basic benefits of group life insurance plans without an employment relationship, classified as flexible type plans based on the characteristics of premium payment and reserve formation, as recorded in the technical note corresponding to each product, shall be reported.
Record 25:
Pensions.- The information corresponding to private pension plans, as established in Article 27, fraction I, second paragraph of the LISF, shall be reported.
Record 26:
Other.- The information corresponding to basic benefits of group life insurance plans without an employment relationship, whose special characteristics differ from the characteristics described for the plans classified in the previous subsections, shall be reported.
Record 27:
Additional benefits: The totals of the information corresponding to the additional benefits of group life insurance plans without an employment relationship shall be reported.
Record 28:
Accidental death: The information corresponding to additional benefits of group life insurance without an employment relationship, in which the granting of benefits in case of accidental death is provided, shall be reported.
Record 29:
Disability: The information corresponding to additional benefits of group life insurance without an employment relationship, in which the granting of benefits in case of insured's disability is provided, shall be reported.
Record 30:
Other additional benefits: Information corresponding to additional benefits of group life insurance without an employment relationship that cannot be classified in the above categories shall be reported.
Record 31:
Total long-term life: The result of the sum of the values corresponding to records 1, 11, and 21 shall be reported.
c) Reports of "Reserve for unearned premiums of assumed reinsurance of life insurance", "Reserve for unearned premiums of assumed reinsurance of accidents and diseases" and "Reserve for unearned premiums of assumed reinsurance of damage", Report Keys 03, 06, and 09, respectively.
These reports shall contain, for the assumed operation, the information regarding the reserve for unearned premiums of life, accidents and diseases, and damage insurance, according to the fields defined in subsection a) for the direct operation, and disaggregated according to the types of insurance corresponding to each operation, as shown below.
In the case of life insurance:
The report shall contain 3 records.
Record 1:
Individual life.- The information corresponding to the basic and additional benefits of individual life insurance plans of the assumed reinsurance shall be reported.
Record 2:
Group life.- The information corresponding to the basic and additional benefits of group life insurance plans of the assumed reinsurance shall be reported.
Record 3:
Total life: The sum of each field, according to records 1 and 2, shall be reported.
In the case of insurance of the accidents and diseases operation:
The information shall be reported by each line and type of insurance, so it shall contain 10 records according to the list defined for report 05.
In the case of insurance of the damage operation:
The information shall be reported by each line, so it shall contain 12 records, according to the list defined for report 08.
d) Reports of "Reserve for unearned premiums of life insurance by currency", "Reserve for unearned premiums of accidents and diseases by currency" and "Reserve for unearned premiums of damage by currency", Report Keys 04, 07, and 10, respectively.
In these reports, the Insurance Institution or Mutual Society shall indicate the amount of the reserve for unearned premiums corresponding to direct insurance and assumed reinsurance policies that are in force or in advance issuance, classifying them by currency and disaggregated according to the types of insurance corresponding to each operation, as indicated below.
Field 1:
Type of insurance.- The line or type of insurance corresponding to each operation shall be reported in each record, as indicated for reports 03, 05, and 08 respectively.
Field 2:
Amount of the reserve for unearned premiums denominated in national currency.- This refers to the amount of the reserve for unearned premiums of policies in force or in advance issuance, denominated in national currency.
Field 3:
Amount of the reserve for unearned premiums denominated in dollars.- This refers to the amount of the reserve for unearned premiums of policies in force or in advance issuance, denominated in dollars.
Field 4:
Amount of the reserve for unearned premiums denominated in indexed units.- This refers to the amount of the reserve for unearned premiums of policies in force or in advance issuance, denominated in indexed units.
Field 5:
Total amount of the reserve for unearned premiums.- This corresponds to the sum of the reserve for unearned premiums of policies in force or in advance issuance.
Field 6:
Recoverables denominated in national currency.- The recoverables from ceded reinsurance of policies denominated in national currency shall be reported.
Field 7:
Recoverables denominated in dollars.- The recoverables from ceded reinsurance of policies denominated in dollars shall be reported.
Field 8:
Recoverables denominated in indexed units.- The recoverables from ceded reinsurance of policies denominated in indexed units shall be reported.
Field 9:
Total reinsurance recoverables.- This corresponds to the sum of the reinsurance recoverables.
In each record, the information reported in fields 2 to 9 shall correspond to the type of insurance reported in field 1, as defined below:
In the case of life insurance, the information shall be reported by each type of insurance according to the list defined for report 03.
In the case of insurance of the Accidents and Diseases operation, the information shall be reported by each line and type of insurance according to the list defined for report 05.
In the case of insurance of the damage operation, the information shall be reported by each line according to the list defined for report 08.
e)
Reserve for unearned premiums by assumed reinsurance.
This report shall contain 5 records, which shall be reported as follows:
1.- Records 1 to 4: The information of each of the suretyship lines shall be reported.
2.- Record 5: The result of the sum of each field, in fields 2 to 4, shall be reported.
Below, each of the fields to be reported is defined:
Field 1:
Line.- The corresponding line shall be reported in each record. To this effect, it shall adhere to the following catalog:
Record
Field 1
1
Fidelity suretyship
2
Judicial suretyship
3
Administrative suretyship
4
Credit suretyship
5
Total assumed reinsurance
Field 2:
Premium of the reserve of assumed reinsurance.- This shall correspond to the amount of the reserve premium of the in-force policies of the assumed reinsurance. In the case of policies of the fidelity line and the judicial sub-line that cover drivers of motor vehicles, the corresponding amount of the unearned reserve premium at the date of reporting shall be reported in this field.
Field 3:
Annual administrative expenses of assumed reinsurance.- The amount shall be reported
of annual administration expense of the policies in force of the reinsurance taken. In the case of fidelity and judicial sub-branch policies covering motor vehicle drivers, the amount corresponding to the unaccrued annual administration expense as of the reporting date must be reported in this field.
Field 4:
Reserve for surety bonds in force of the reinsurance taken.- Refers to the amount of the surety bond reserve in force of the reinsurance taken, which incorporates the sum corresponding to the reserve premium of the reinsurance taken and the annual administration expenses of the reinsurance taken.
In each record, the information reported in fields 2 to 4 must correspond to what is reported in field 1.
f) Report of large products
This report must contain 10 records, in each of which one of the ten most representative products in terms of volume of issued premium or risk reserve in force must be indicated. Large products are understood as follows:
i)
In the case of long-term life insurance, products whose issued premium as of the reporting date has represented for the Insurance Institution or Mutual Society an amount greater than 10% of the total issued premium of the life operation (as of the reporting date) and which in amount is greater than $50,000,000.00 (Fifty million pesos, N.M.), or whose risk reserve in force at the close of the reporting quarter is greater than $50,000,000.00 (Fifty million pesos, N.M.).
ii)
If it concerns insurance other than long-term life insurance, products whose issued premium as of the reporting date has represented for the Insurance Institution or Mutual Society an amount greater than 10% of the total issued premium of the corresponding operation (as of the reporting date) and which in amount is greater than $50,000,000.00 (Fifty million pesos, N.M.) must be reported.
iii)
If it concerns package products (as defined in Provision 4.1.12 of this Circular), those whose issued premium as of the reporting date is greater than 10% of the total issued premium of the Insurance Institution or Mutual Society (as of the reporting date) and in amount is greater than $50,000,000.00 (Fifty million pesos, N.M.) must be reported.
The information that will make up this report is defined below:
Field 1:
Product Name.- Indicate the name of the product. This field does not refer to the commercial name of the product, but to the generally recognized technical name, which corresponds to the technical characteristics of the product, such as "Temporary insurance for n years", "Endowment insurance for 10 years", "Flexible insurance", "Universal life insurance", "Unemployment insurance", "Machinery breakage insurance", "Hurricane insurance", "Total and partial disability income insurance", "Hospitalization income insurance".
Field 2:
Valid registration number(s).- List, for each of the reported products, the registration number(s) with the Commission.
Field 3:
Branch or type of insurance.- Indicate the branch or type of insurance corresponding to the product. Regarding package products, the branches or types of insurance to which each of the coverages that make up the product belong will be listed (Examples: Individual Life, Medical Expenses, Fire, Miscellaneous, Maritime and Transport, etc.).
Field 4:
Issued Premium.- The accumulated issued premium from January 1 until the close of the quarter in question will be reported.
Field 5:
Risk Reserve in Force.- The balance of the risk reserve in force at the close of the corresponding quarter will be reported.
Field 6:
Number of policies, certificates, or endorsements.- It is the number of policies, certificates, or endorsements in force at the close of the corresponding quarter.
In each record, the information reported in fields 2 to 6 must correspond to the product name reported in field 1.
g) Report of Large Risks
This report must contain 10 records, in each of which the following information must be reported for the ten active property insurance businesses at the close of the reported quarter, whose volume of sum insured, in a single insured risk unit, is greater than USD 50,000,000.00 (Fifty million United States dollars). The objective of this report is to identify those risks that could represent a significant loss for the company in the event of a claim. In this sense, the insured risk unit to be reported is understood to be only those insured assets that, corresponding to a single thing or building, have an insured value such that, in case of damage from the covered risk, the amount of the insurer's obligation or liability could be equal to or greater than the indicated amount. Businesses consisting of insuring sets of assets constituted by various properties or buildings whose insured value, in aggregate, is equal to or greater than the indicated amount will not be considered in this report, unless the Insurance Institution has information allowing it to know that a single unit constituting the set of insured units has a value that could cause it a loss equal to or greater than the indicated amount.
Field 1:
Description of the asset and covered risk.- The insured asset and the risk or risks against which coverage is being provided will be described.
Field 2:
Policyholder.- Name or corporate name of the policyholder.
Field 3:
Policy Number.- Indicate the policy number.
Field 4:
Start of Validity.- Corresponds to the start date of the policy's validity, in yyyymmdd format.
Field 5:
End of Validity.- Corresponds to the end date of the policy's validity, in yyyymmdd format.
Field 6:
Branch.- Indicate the branch corresponding to the policy. Regarding package products, the branches to which each of the coverages that make up the product belong will be listed (Examples: Fire, Miscellaneous, Maritime and Transport, etc.).
Field 7:
Issued Premium.- The issued premium for the year, corresponding to the policy, will be reported.
Field 8:
Risk Reserve in Force.- The balance of the risk reserve in force at the close of the corresponding quarter will be reported.
Field 9:
Sum Insured.- Total sum insured at risk of the insured asset.
Field 10:
Main Reinsurers.- List the names of the main reinsurers of the policy in question.
In each record, the information reported in fields 2 to 10 must correspond to the risk described in field 1.
h) Microinsurance Report
This report must contain 10 records, in each of which the information relative to life, accident and disease, or property insurance products that meet any of the following characteristics must be reported:
a)
Products that have been registered as microinsurance with the Commission.
b)
Products that, even if they have not been registered as microinsurance with the Commission, have been designed by the Insurance Institution or Mutual Society with special characteristics, such as sums insured of small amounts, simplified operational schemes, mass marketing channels, among others, and that have as their object offering insurance coverage exclusively to persons of low economic means.
Field 1:
Product registration number.- For products registered from July 16, 2002 onwards, the number assigned to the product in the module of the Commission's Website; for products whose technical note was registered prior to the aforementioned date, the registration number of the technical note or the number of the official letter issued by the Commission, through which the aforementioned technical note was authorized.
Field 2:
Covered Risk.- Contingency whose possible damage or economic loss is covered by the microinsurance. As part of the risk description, the damage or economic loss covered may be mentioned. (Examples: material damage from hurricane, indemnity for death by accident, medical expenses for serious illnesses, theft in home, daily indemnity for unemployment). For products covering more than one risk, whether covered as basic or additional benefits, or if the risks must be registered in different branches or sub-branches, a row or line must be used for each covered risk whenever possible.
Field 3:
Type of Coverage.- The key "B" must be assigned to basic coverages and the key "A" to additional coverages, using a row or line for each coverage.
Field 4:
Number of policies, certificates, or endorsements issued in the year.- The number of policies, certificates, or endorsements issued as of the close of the reported quarter must be reported, even if they are not in force at the end of the same. For additional benefits of the life operation, the number of policies or certificates that contracted the additional benefit must be reported whenever possible, even if the policy or certificate has already been accounted for in the basic coverage.
Field 5:
Sum Insured.- The amount of the sums insured contracted for policies, certificates, or endorsements issued during the year in question, up to the close of the reported quarter, must be reported, even if they are not in force at the end of the same.
Field 6:
Issued Premium.- The issued premium for policies, certificates, or endorsements issued during the year and up to the close of the reported quarter, corresponding to each basic or additional coverage, or covered risk, must be reported.
Field 7:
Acquisition Expense Amount.- The amount of acquisition expenses contained in the issued premiums as of the close of the reported quarter must be reported.
Field 8:
Administration Expense Amount.- The amount of administration expenses contained in the issued premiums as of the close of the reported quarter must be reported.
Field 9:
Profit Margin Amount.- The amount of the profit margin contained in the issued premiums as of the close of the reported quarter must be reported.
Field 10:
Number of policies, certificates, or endorsements in force.- The number of policies, certificates, or endorsements in force as of the close of the quarter in question must be reported (even if their validity did not start in that year, as may be the case for long-term life policies, or multi-year insurance).
Field 11:
Sums Insured in Force.- The amount of the sums insured contracted for policies, certificates, or endorsements in force as of the close of the quarter in question must be reported.
Field 12:
Issued Premiums in Force.- The issued premium for policies, certificates, or endorsements in force as of the close of the quarter in question must be reported (even if the premium was not issued in that year, as may be the case for long-term life policies, or multi-year insurance).
Field 13:
Number of Claims.- The number of claims received as of the close of the reported quarter must be reported, regardless of the status of the claim as of the reporting date.
Field 14:
Claim Amount.- The amount of claims received as of the close of the quarter in question must be reported, whether reporting the amount claimed by the insured/policyholder/beneficiary, or the amount estimated by the Insurance Institution or Mutual Society (including adjustments).
Field 15:
Number of Paid Claims.- The number of claims paid as of the close of the quarter in question must be reported, regardless of the date of registration of the claim, and not counting as a paid claim, the supplements to initial payments.
Field 16:
Amount of Paid Claims.- The amount of paid claims as of the close of the quarter in question must be reported, integrated by the sum of the concepts of initial and supplementary claims, regardless of the date of registration of the claim.
In each record, the information reported in fields 2 to 16 must correspond to the product reported in field 1.
i) Agricultural and Animal Insurance Report
This report must contain 34 records, which must be reported as follows:
1.-
Records 1 to 32: Information will be reported by federal entity, corresponding to both direct insurance and reinsurance taken, which must include information on agricultural and rural insurance funds.
2.-
Record 33: Information corresponding to direct insurance from abroad will be reported.
3.-
Record 34: The result of the sum of each field, in fields 2 to 11, will be reported, while in field 12, the total amount of excess loss coverages contracted by the Insurance Institution or Mutual Society to cover the risk of agricultural and animal insurance will be reported.
Below, each of the fields to be reported is defined:
Field 1:
Entity.- The federal entity must be reported, or it must be indicated if the information corresponds to abroad. Likewise, a record with the total sum of each concept must be added as part of the concepts of this field. To this effect, the following catalog must be followed:
Information of Field 1
Record
Entity
Record
Entity
1
Aguascalientes
18
Nayarit
2
Baja California
19
Nuevo León
3
Baja California Sur
20
Oaxaca
4
Campeche
21
Puebla
5
Chiapas
22
Querétaro
6
Chihuahua
23
Quintana Roo
7
Coahuila
24
San Luis Potosí
8
Colima
25
Sinaloa
9
Distrito Federal
26
Sonora
10
Durango
27
Tabasco
11
Guanajuato
28
Tamaulipas
12
Guerrero
29
Tlaxcala
13
Hidalgo
30
Veracruz
14
Jalisco
31
Yucatán
15
Estado de México
32
Zacatecas
16
Michoacán
33
Foreign
17
Morelos
34
Total
Field 2:
Issued Premium.- The issued premium as of the close of the reported quarter must be reported.
Field 3:
Retained Premium.- The retained premium as of the close of the reported quarter must be reported.
Field 4:
Sum Insured.- The amount of the sums insured of the policies issued as of the close of the reported quarter must be reported.
Field 5:
Claims Occurred.- The amount of claims received as of the close of the reported quarter must be reported.
Field 6:
Retained Claims.- The amount of claims received retained as of the close of the reported quarter must be reported.
Field 7:
Issued Premium of Reinsurance Taken.- The issued premium as of the close of the reported quarter must be reported.
Field 8:
Retained Premium of Reinsurance Taken.- The retained premium as of the close of the reported quarter must be reported.
Field 9.-
Sum Insured of Reinsurance Taken: The amount of the sums insured of the policies issued as of the close of the reported quarter must be reported.
Field 10:
Claims Occurred of Reinsurance Taken.- The amount of claims received as of the close of the reported quarter must be reported.
Field 11:
Retained Claims of Reinsurance Taken.- The amount of claims received retained as of the close of the reported quarter must be reported.
Field 12:
Amount of Excess Loss Reinsurance Coverages.- The amount of excess loss coverages contracted by the company to cover the risk of agricultural and animal insurance, which are in force as of the close of the reported quarter, must be reported. This amount must be captured in the record corresponding to the total information. This information is recorded exclusively for record 34.
In each record, the information reported in fields 2 to 11 must correspond to what is reported in field 1.
j) Insurance with Savings Component Report
This report must contain 2 records, in each of which the following information will be reported for life insurance with a savings or investment component, distinguishing between individual insurance and group insurance.
Insurance with pure savings or investment components are understood to be those that generate a savings fund through the formation of a reserve in which premiums, dividends, or interests are accumulated or capitalized and which, contractually, belong to the insured. Such insurance, regardless of the commercial name they receive, may include some of the following: pure endowment insurance, short-term endowment insurance, flexible insurance, investment life insurance, deferred annuities, retirement or separation insurance that are in the accumulation period, etc.
Field 1:
Type of Insurance.- The type of insurance to which the information refers must be reported according to the following:
Record
Type of Insurance
1
Individual
2
Group
Field 2:
Number of Insured in Force.- The number of insured persons, whose policy or certificate is in force as of the close of the quarter in question, must be reported.
Field 3:
Issued Premium.- The issued premium as of the close of the quarter in question will be reported.
Field 4:
Risk Reserve in Force.- The balance of the risk reserve in force at the close of the corresponding quarter.
In each record, the information reported in fields 2 to 4 must correspond to the type of insurance reported in field 1.
k) Credit-Linked Insurance Report
This report must contain 6 records, in each of which the following information will be reported for credit-linked insurance, understood as those whose object is to cover debtor balances for credits in the event of eventualities such as death, disability, or unemployment of the debtor, total loss of the asset, among others, and whose preferential beneficiary before the Insurance Institution or Mutual Society is the grantor of the credit or creditor.
Field 1:
Operation.- The insurance operation to which the information refers must be reported according to the following:
Operation
Life
Property
Field 2:
Type of Credit.- For each operation, in this field the type of credit to which the information refers must be reported according to the following:
Type of Credit
For automobiles
Mortgage
Others*
*Others: In this category, examples may include credits for the acquisition of durable consumer goods or revolving credits.
According to the definition, fields 1 and 2 must present the following content for each of the 6 records that make up this report:
Record
Field 1
Field 2
1
Life
For automobiles
2
Life
Mortgage
3
Life
Others*
4
Property
For automobiles
5
Property
Mortgage
6
Property
Others*
Field 3:
Number of Insured in Force.- The number of insured persons, whose policy or certificate is in force as of the close of the quarter in question, must be reported.
Field 4:
Issued Premium.- The issued premium as of the close of the quarter in question will be reported.
Field 5:
Risk Reserve in Force.- The balance of the risk reserve in force at the close of the corresponding quarter.
In each record, the information reported in fields 3 to 5 must correspond to what is reported in fields 1 and 2.
l)
Standardized Basic Products
This report must contain 6 records, in each of which the following information relative to standardized basic products will be reported:
Field 1:
Branch or Type of Insurance.- The branch or type of insurance to which the standardized basic product corresponds will be reported. To this effect, the following catalog must be followed:
Record
Field 1
1
Life
2
Personal Accident
3
Medical Expenses
4
Health
5
Dental Health
6
Civil Liability
Field 2:
Number of Insured in the Year.- The number of insured persons who have been insured since January 1, as of the close of the quarter in question, whether or not they are in force, will be reported.
Field 3:
Number of Insured in Force.- The number of insured persons who are in force, as of the close of the quarter in question, will be reported.
Field 4:
Issued Premium.- The issued premium as of the close of the quarter in question will be reported.
Field 5:
Risk Reserve in Force.- The balance of the risk reserve in force at the close of the corresponding quarter.
In each record, the information reported in fields 2 to 5 must correspond to what is reported in field 1.
m)
Mandatory Vehicular Civil Liability Insurance
The following information relative to mandatory vehicular civil liability insurance will be reported:
This report must consist of 34 records, which must contain information relative to mandatory vehicular civil liability insurance, and which must be reported as follows:
1.-
Records 1 to 32: Information will be reported according to the federal entity where the insured resides.
2.-
Record 33: Information whose federal entity of residence of the insured cannot be identified will be reported.
3.-
Record 34: The result of the sum of the previous 33 records will be reported, for fields 2 to 7.
Below, each of the fields to be reported is defined:
Field 1:
Entity.- The federal entity where the insured resides must be reported, or it must be indicated if the information corresponds to an unidentified federal entity. Likewise, a record with the total sum of each concept must be added as part of the concepts of this field. To this effect, the following catalog must be followed:
Information of Field 1
Record
Entity
Record
Entity
1
Aguascalientes
18
Nayarit
2
Baja California
19
Nuevo León
3
Baja California Sur
20
Oaxaca
4
Campeche
21
Puebla
5
Chiapas
22
Querétaro
6
Chihuahua
23
Quintana Roo
7
Coahuila
24
San Luis Potosí
8
Colima
25
Sinaloa
9
Distrito Federal
26
Sonora
10
Durango
27
Tabasco
11
Guanajuato
28
Tamaulipas
12
Guerrero
29
Tlaxcala
13
Hidalgo
30
Veracruz
14
Jalisco
31
Yucatán
15
Estado de México
32
Zacatecas
16
Michoacán
33
Undefined State
17
Morelos
34
Total
Field 2:
Number of Insured in the Year.- The number of insured persons who have been insured since January 1, as of the close of the quarter in question, whether or not the respective policies or endorsements are in force, will be reported.
Field 3:
Number of Insured in Force.- The number of insured persons who are in force, as of the close of the quarter in question, will be reported.
Field 4:
Issued Premium.- The issued premium for policies or endorsements issued as of the close of the reported quarter must be reported.
Field 5:
Retained Premium.- The retained premium as of the close of the reported quarter must be reported.
Field 6:
Sum Insured.- The amount of the sums insured of the policies in force as of the close of the reported quarter must be reported.
Field 7:
Amount of claims for the year.- The amount of claims received, from January 1, to the end of the quarter in question, must be reported.In each record, the information reported in fields 2 to 7 must correspond to what is reported in field 1.n) Earthquake insuranceThe following information related to earthquake insurance must be reported:This report must consist of 34 records, which must contain information related to earthquake insurance, and which must be reported as follows:Records 1 to 32: Information must be reported according to the federal entity where the insured object is located.Record 33: Information for which the federal entity cannot be identified must be reported.Record 34: The sum of the previous 33 records for fields 2 to 7 must be reported.Below, each of the fields that must be reported are defined:Field 1: Federal Entity.- The federal entity where the insured object is located must be reported, or it must be indicated if the information corresponds to an unidentified federal entity.Likewise, a record with the total sum of each concept must be added as part of the concepts in this field. For this purpose, the following catalog must be adhered to:Information for Field 1| Record | Federal Entity | Record | Federal Entity ||---|---|---|---|| 1 | Aguascalientes | 18 | Nayarit || 2 | Baja California | 19 | Nuevo León || 3 | Baja California Sur | 20 | Oaxaca || 4 | Campeche | 21 | Puebla || 5 | Chiapas | 22 | Querétaro || 6 | Chihuahua | 23 | Quintana Roo || 7 | Coahuila | 24 | San Luis Potosí || 8 | Colima | 25 | Sinaloa || 9 | Distrito Federal | 26 | Sonora || 10 | Durango | 27 | Tabasco || 11 | Guanajuato | 28 | Tamaulipas || 12 | Guerrero | 29 | Tlaxcala || 13 | Hidalgo | 30 | Veracruz || 14 | Jalisco | 31 | Yucatán || 15 | Estado de México | 32 | Zacatecas || 16 | Michoacán | 33 | Undefined State || 17 | Morelos | 34 | Total |Field 2: Number of policies, certificates, or endorsements for the year.- The number of policies, certificates, or endorsements that have been insured from January 1 to the end of the quarter in question must be reported, whether or not the respective policies or endorsements are in force.Field 3: Number of policies, certificates, or endorsements in force.- The number of policies, certificates, or endorsements that are in force at the end of the quarter in question must be reported.Field 4: Premium issued.- The premium issued for policies, certificates, or endorsements that have been issued at the end of the reported quarter must be reported.Field 5: Premium retained.- The premium retained at the end of the reported quarter must be reported.Field 6: Sum insured.- The amount of the sums insured for policies, certificates, or endorsements in force at the end of the reported quarter must be reported.Field 7: Amount of claims for the year.- The amount of claims received, from January 1, to the end of the quarter in question, must be reported.In each record, the information reported in fields 2 to 7 must correspond to what is reported in field 1.o) Hurricane and other hydrometeorological risks insuranceThe following information related to hurricane and other hydrometeorological risks insurance must be reported:This report must consist of 34 records, which must contain information related to hurricane and other hydrometeorological risks insurance, and which must be reported as follows:Records 1 to 32: Information must be reported according to the federal entity where the insured object is located.Record 33: Information for which the federal entity cannot be identified must be reported.Record 34: The sum of the previous 33 records for fields 2 to 7 must be reported.Below, each of the fields that must be reported are defined:Field 1: Federal Entity.- The federal entity where the insured object is located must be reported, or it must be indicated if the information corresponds to an unidentified federal entity.Likewise, a record with the total sum of each concept must be added as part of the concepts in this field. For this purpose, the following catalog must be adhered to:Information for Field 1| Record | Federal Entity | Record | Federal Entity ||---|---|---|---|| 1 | Aguascalientes | 18 | Nayarit || 2 | Baja California | 19 | Nuevo León || 3 | Baja California Sur | 20 | Oaxaca || 4 | Campeche | 21 | Puebla || 5 | Chiapas | 22 | Querétaro || 6 | Chihuahua | 23 | Quintana Roo || 7 | Coahuila | 24 | San Luis Potosí || 8 | Colima | 25 | Sinaloa || 9 | Distrito Federal | 26 | Sonora || 10 | Durango | 27 | Tabasco || 11 | Guanajuato | 28 | Tamaulipas || 12 | Guerrero | 29 | Tlaxcala || 13 | Hidalgo | 30 | Veracruz || 14 | Jalisco | 31 | Yucatán || 15 | Estado de México | 32 | Zacatecas || 16 | Michoacán | 33 | Undefined State || 17 | Morelos | 34 | Total |Field 2: Number of policies, certificates, or endorsements for the year.- The number of policies, certificates, or endorsements that have been insured from January 1 to the end of the quarter in question must be reported, whether or not the respective policies or endorsements are in force.Field 3: Number of policies, certificates, or endorsements in force.- The number of policies, certificates, or endorsements that are in force at the end of the quarter in question must be reported.Field 4: Premium issued.- The premium issued for policies, certificates, or endorsements that have been issued at the end of the reported quarter must be reported.Field 5: Premium retained.- The premium retained at the end of the reported quarter must be reported.Field 6: Sum insured.- The amount of the sums insured for policies, certificates, or endorsements in force at the end of the reported quarter must be reported.Field 7: Amount of claims for the year.- The amount of claims received, from January 1, to the end of the quarter in question, must be reported.In each record, the information reported in fields 2 to 7 must correspond to what is reported in field 1.p) Mass Insurance ReportThis report must contain 6 records, in each of which the following information for mass-market insurance must be reported, understood as those defined in Chapter 4.9 of this Circular.Field 1: Branch/type of insurance.- The branch or type of insurance to which the information refers must be reported according to the following:| Record | Field 1 ||---|---|| 1 | Individual Life || 2 | Personal Accidents || 3 | Medical Expenses || 4 | Automobiles || 5 | Diverse || 6 | Other |Field 2: Number of insured for the year.- The number of insured persons who have been insured from January 1 to the end of the quarter in question must be reported, whether or not the respective policies or endorsements are in force.Field 3: Number of insured in force.- The number of insured persons for policies that are in force at the end of the quarter in question must be reported.Field 4: Current registration number(s).- List, for each of the reported plans or products, the registration number(s) with the Commission.Field 5: Premium issued.- The premium issued at the end of the quarter in question must be reported.Field 6: Reserve for unearned premiums.- The balance of the reserve for unearned premiums at the end of the corresponding quarter.In each record, the information reported in fields 2 to 6 must correspond to what is reported in field 1.q) Responsible Persons ReportThis report must contain 6 records, in each of which the following information must be reported for the official of the Insurance Institution or Mutual Society responsible for the valuation of the reserve for unearned premiums, as well as for the actuaries who certify said valuations, for each of the operations. The submission of this report is mandatory.Field 1: Responsible Person.- For each record, it must be reported whether the requested information corresponds to the official responsible for the technical area or to the certifying actuary, according to the following:| Record | Field 1 ||---|---|| 1 | Official responsible for the technical area || 2 | Certifying actuary 1 || 3 | Certifying actuary 2 || 4 | Certifying actuary 3 || 5 | Certifying actuary 4 || 6 | Certifying actuary 5 |Field 2: Name.- The name of the official or certifying actuary must be reported.Field 3: Position.- The position of the official or certifying actuary must be reported.Field 4: Phone number(s).- The contact phone number(s) of the official or certifying actuary must be reported.Field 5: Email.- The email address of the official or certifying actuary must be reported.Field 6: Operation or branch of Insurance certified.- In the case of the certifying actuary(ies), the operation in which the reserve for unearned premiums is being certified must be indicated.In each record, the information reported in fields 2 to 6 must correspond to what is reported in field 1.1.2.- The Excel file corresponding to the summary of the valuation of the reserve for unearned premiumsThe text files for the valuation of the reserve for unearned premiums referred to in numeral 1 immediately above must be generated using the Excel file corresponding to the summary of the valuation of the reserve for unearned premiums, which will be available, along with its respective user manual, on the Commission's Website (www.cnsf.gob.mx) with the name "RR3RRCCVRES.xls".The Excel file corresponding to the summary of the valuation of the reserve for unearned premiums, containing the information reported in accordance with what is defined in numeral 1 immediately above, must be sent as part of the RR3RRCCV product, for which it must be renamed as follows:The name must consist of 24 alphanumeric characters that must be ordered as follows:a) The specific file identifier: "RR3RRCCVRES" must be written in the first eleven positions.b) The company type key must be written in the twelfth position.| Key | Definition ||---|---|| H | Insurance Institutions authorized to operate health insurance. || G | Insurance Institutions authorized to operate financial guarantee insurance. || V | Insurance Institutions authorized to operate housing credit insurance. || S | Other Insurance Institutions and Mutual Societies. |d) The number assigned to the Insurance Institution or Mutual Society in question must be written in positions thirteen to sixteen. This number must be preceded by zeros until it occupies all four positions.e) The year must be written in positions seventeen to twenty.f) The reported month must be written in positions twenty-one and twenty-two.g) The last day of the reported month must be written in positions twenty-three and twenty-four.Example:Company key: "S"Company number: "0009"Day: "30"Month: June ("06")Year: 2013| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | Extension ||---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|| R | R | 3 | R | R | C | C | V | R | E | S | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .XLS |1.3.- Certification document or documents corresponding to the valuation of the reserve for unearned premiums signed by the actuaries responsible for itFor each operation carried out by the Insurance Institution or Mutual Society (life, damages, and accidents and illnesses), a certification letter in PDF format, corresponding to the valuation of the reserve for unearned premiums, signed by the responsible actuary or actuaries.The PDF files for each operation must contain the name and electronic signature of the actuary or licensed actuary responsible for the valuation, professional license number, number of the current certification issued by the professional college of the specialty or the accreditation of the Commission required for the preparation and signing of the valuation of technical reserves, in compliance with the provisions of article 226 of the LISF.The name of each magnetic file in PDF format must consist of 26 alphanumeric characters that must be ordered as follows:a) The specific identifier of the file(s): "RR3RRCCVCER" must be written in the first eleven positions.b) The key corresponding to the operation being certified must be written in positions twelve and thirteen.| Operation Key | Description ||---|---|| 01 | Life || 02 | Accidents and illnesses || 03 | Damages |c) The company type key must be written in the fourteenth position.| Key | Definition ||---|---|| H | Insurance Institutions authorized to operate health insurance. || G | Insurance Institutions authorized to operate financial guarantee insurance. || V | Insurance Institutions authorized to operate housing credit insurance. || S | Other Insurance Institutions and Mutual Societies. |d) The number assigned to the Insurance Institution or Mutual Society in question must be written in positions fifteen to eighteen. This number must be preceded by zeros until it occupies all four positions.e) The year must be written in positions nineteen to twenty-two.f) The reported month must be written in positions twenty-three and twenty-four.g) The last day of the reported month must be written in positions twenty-five and twenty-six.Example:Certification document for the operation of: damages ("03").Company key: "S"Company number: "0009"Day: "30"Month: June ("06")Year: 2013| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | Extension ||---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|| R | R | 3 | R | R | C | C | V | C | E | R | 0 | 3 | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .PDF |2.- The RR3RRCVT product, which must contain the Excel file corresponding to the result of the valuation of the long-term reserve for unearned premiums due to interest rate variations, in accordance with what is indicated below:a) For its submission, the product must be encrypted in a single .ZIP.PGP file, whose name must consist of 21 alphanumeric characters, ordered as follows:b) The first eight positions will correspond to the specific product identifier: "RR3RRCVT".c) The company type key must be written in the ninth position:| Key | Definition ||---|---|| S | Other Insurance Institutions and Mutual Societies. |d) The number assigned to the Insurance Institution or Mutual Society in question must be written in positions ten to thirteen. This number must be preceded by zeros until it occupies all four positions.e) The year must be written in positions fourteen to seventeen.f) The reported month must be written in positions eighteen and nineteen.g) The last day of the reported month must be indicated in positions twenty and twenty-one.Example:Company key: "S"Company number: "0009"Day: ("30")Month: June ("06")Year: 2013| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | Extension ||---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|| R | R | 3 | R | R | C | V | T | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .ZIP.PGP |The Excel file corresponding to the result of the valuation of the long-term reserve for unearned premiums due to interest rate variationsThe Excel file corresponding to the result of the valuation of the long-term reserve for unearned premiums due to interest rate variations will be available on the Commission's Website (www.cnsf.gob.mx) with the name "RR3RRCVT.xls". For its submission, said file must be renamed as follows:The name must consist of 24 alphanumeric characters that must be ordered as follows:a) The specific file identifier: "RR3RRCVTFMT" must be written in the first eleven positions.b) The company type key must be written in the twelfth position.| Key | Definition ||---|---|| S | Other Insurance Institutions and Mutual Societies. |c) The number assigned to the Insurance Institution or Mutual Society in question must be written in positions thirteen to sixteen. This number must be preceded by zeros until it occupies all four positions.d) The year must be written in positions seventeen to twenty.e) The reported month must be written in positions twenty-one and twenty-two.f) The last day of the reported month must be written in positions twenty-three and twenty-four.Example:Company key: "S"Company number: "0009"Day: "30"Month: June ("06")Year: 2013| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | Extension ||---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|| R | R | 3 | R | R | C | V | T | F | M | T | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .XLS |The Excel format corresponding to the result of the valuation of the long-term reserve for unearned premiums due to interest rate variations must be filled considering the following:Direct and assumed operation.- Information on the result of the valuation of the long-term life insurance reserve for direct and assumed insurance, carried out with the corresponding interest rate, must be reported.Recoverable reinsurance amounts.- Information on the recoverable amounts corresponding to the result of the valuation of the long-term life insurance reserve for direct and assumed insurance, carried out with the corresponding interest rate, must be reported.Temporary life insurance.- Information corresponding to life insurance that covers only the risk of death on a temporary basis must be reported.Endowment insurance.- Information corresponding to life insurance plans that cover the risk of death and provide for survival payments must be reported.Ordinary life insurance.- Information on life insurance in which both the coverage of the risk of death and the payment of corresponding premiums are carried out on a lifelong basis must be reported.Limited payment life insurance.- Information corresponding to life insurance that covers the risk of death on a lifelong basis, but where premium payments are temporary, must be reported.Result of the reserve valuation with agreed technical rate.- Information corresponding to the result of the valuation of the long-term life insurance reserve, carried out with the technical rate used for the original calculation, must be reported.Result of the reserve valuation with market interest rate.- Information corresponding to the result of the valuation of the long-term life insurance reserve, carried out with the market interest rate, must be reported.National currency.- Information on the result of the valuation of the long-term life insurance reserve, carried out with the corresponding interest rate, for policies denominated in national currency, must be reported.Dollars.- Information on the result of the valuation of the long-term life insurance reserve, carried out with the corresponding interest rate, for policies denominated in dollars, must be reported.Indexed units.- Information on the result of the valuation of the long-term life insurance reserve, carried out with the corresponding interest rate, for policies denominated in indexed units, must be reported.Information with annual delivery frequencyIn addition to the information submitted quarterly, annually, the information on the results of the valuation of the reserve for unearned premiums for each branch or type of insurance must be submitted, which will consist of the following:1.- The RR3RRCBD product will contain the following:a) Text files of the databases with the policy-by-policy detail of the valuation of the reserve for unearned premiums.b) A Word file containing the catalog of special monetary unit codes reported in the text files of the valuation detail databases.c) A Word file containing the catalog indicating the keys and characteristics used to classify insurance plans, reported in the text files of the valuation detail databases.d) Text files of the databases with the detail of the information on recoverable reinsurance amounts.The information indicated in subsections a), b), c), and d) will be indicated in numerals 1.1, 1.2, 1.3, and 1.4, respectively, as follows:a) For its submission, the product must be encrypted in a single .ZIP.PGP file, whose name must consist of 21 alphanumeric characters, ordered as follows:b) The specific product identifier: "RR3RRCBD" must be written in the first eight positions.c) The company type key must be written in the ninth position:| Key | Definition ||---|---|| H | Insurance Institutions authorized to operate health insurance. || G | Insurance Institutions authorized to operate financial guarantee insurance. || V | Insurance Institutions authorized to operate housing credit insurance. || S | Other Insurance Institutions and Mutual Societies. |d) The number assigned to the Insurance Institution or Mutual Society in question must be written in positions ten to thirteen. This number must be preceded by zeros until it occupies all four positions.e) The year must be written in positions fourteen to seventeen.f) The reported month must be written in positions eighteen and nineteen.g) The day of the reported month must be indicated in positions twenty and twenty-one.Example:Company key: "S"Company number: "0009"Day: ("31")Month: December ("12")Year: 2013| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | Extension ||---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|| R | R | 3 | R | R | C | B | D | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 1 | 2 | 3 | 1 | .ZIP.PGP |1.1.- Text files of the databases with the policy-by-policy detail of the valuation of the reserve for unearned premiumsUp to 29 reports in text file format with the policy-by-policy detail of the valuation, whose names must consist of 23 alphanumeric characters, which must be ordered as follows:a) The specific identifier of the files: "RR3RRCBD" must be written in the first eight positions.b) The report key must be written in positions nine and ten.| Report Key | Description ||---|---|| 01 | Individual short-term life insurance || 02 | Individual long-term life insurance || 03 | Individual flexible life insurance || 04 | Individual pension life insurance || 05 | Group short-term life insurance || 06 | Group long-term life insurance || 07 | Group flexible life insurance || 08 | Group pension life insurance || 09 | Personal accident insurance || 10 |
Medical expense insurance
11
Health insurance
12
Fire insurance
13
Automobile insurance
14
Miscellaneous insurance
15
Agricultural and animal insurance
16
Marine and transport insurance
17
Civil liability insurance
18
Earthquake and/or volcanic eruption insurance
19
Hurricane and/or other hydrometeorological risks insurance
20
Credit insurance
21
Housing credit insurance
22
Financial guarantee insurance
23
Fidelity bonds
24
Judicial bonds
25
Administrative bonds
26
Credit bonds
27
Short-term group life insurance
28
Long-term group life insurance
29
Surety insurance
c)
In the eleventh position, the company type key must be written.
Key Definition
H Insurance Institutions authorized to operate health insurance.
G Insurance Institutions authorized to operate financial guarantee insurance.
V Insurance Institutions authorized to operate housing credit insurance.
S Other Insurance Institutions and Mutual Societies.
d)
From the twelfth to the fifteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.
e)
From the sixteenth to the nineteenth positions, the year must be written.
f)
In the twentieth and twenty-first positions, the reported month must be written.
g)
In the twenty-second and twenty-third positions, the last day of the reported month must be written.
Example:
Report ( " 01 " )
Company Key: " S "
Company Number: " 0009 "
Day: ( " 31 " )
Month: December ( " 12 " )
Year: 2015
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Extension
R R 3 R R C B D 0 1 S 0 0 0 9 2 0 1 5 1 2 3 1 .TXT
The structure, order, identifiers, field length, and other details of the databases shall be as follows:
a)
The databases must contain information ordered in matrix arrays, in which the columns correspond to the fields described below and the rows to the records of each of the policies, certificates, or endorsements that make up the reserve valuation. The fields will be delimited by the " | " sign, known as "pipe".
No. Name Type Size
1 Operation Alphanumeric 2
2 Branch, sub-branch or type of insurance/bond Alphanumeric 2
3 Policy number Alphanumeric 30
4 Certificate, clause or endorsement (movement) Alphanumeric 30
5 Start date of validity Numeric 8
6 End date of validity Numeric 8
7 Gross issued premium Numeric 15
8 Gross risk premium Numeric 15
9 Gross unearned risk premium Numeric 15
10 Acquisition cost Numeric 15
11 Administration expenses Numeric 15
12 Profit margin Numeric 15
13 Product registration number Alphanumeric 30
14 Currency or monetary unit Alphanumeric 15
15 Insurance plan identifier Alphanumeric 15
16 Retained issued premium Numeric 15
17 Reinsurance recoverable amounts Numeric 15
18 Multi-year policy identifier Alphanumeric 2
19 Basic or additional benefit identifier Alphanumeric 2
20 Insured's age at contracting Numeric 2
21 Gross insured sum Numeric 15
22 Premium payment term Numeric 5
23 Plan duration Numeric 5
24 Insured's sex Alphanumeric 1
25 Paid-up and extended identifier Alphanumeric 3
26 Traditional life insurance plan identifier Alphanumeric 3
27 BEL-Risk Numeric 15
28 Future premiums Numeric 15
29 BEL-Expenses Numeric 15
30 Risk margin Numeric 15
31 Other future costs Numeric 15
32 Original Currency Reserve Numeric 15
33 National Currency Reserve Numeric 15
b)
When a field is not applicable to a record, the column for that field must be left empty, while still maintaining the corresponding pipes.
c)
The amounts indicated in each of the fields that make up the databases must be expressed in the original currency or monetary unit in which the policy is subscribed, except for the field called National Currency Reserve, in which the amount must always be expressed in national currency, for which, if applicable, the exchange rate corresponding to the annual closing will be used.
d)
The database in question must not include additional information on policies, certificates, clauses, or endorsements that are expired or canceled at the time of valuation, regardless of whether such information is maintained within the respective Insurance Institution's or Mutual Society's own controls.
e)
The parameters of paid-up and extended insurance policies must be those that these Insurance Institutions and Mutual Societies have used for the valuation of their unearned premium reserve at the time of the report, omitting the value of the parameters of the original plan from which they originate.
f)
The quantities reported in the databases must be expressed without decimals, except, if applicable, for the plan duration and the premium payment term.
g)
The fields referred to in subsection a) above must be filled in accordance with the following definitions:
Field 1:
Operation.- Refers to whether the policy, certificate, clause, or endorsement corresponds to direct operation, assumed, or co-surety. In the first case, the text " DI " will be entered, in the second, " TO ", and in the third case " RF ".
Field 2:
Branch, sub-branch or type of insurance/bond.- In this field, the corresponding key must be indicated, according to the following table:
Branch, sub-branch or type of insurance/bond Key
Individual life VI
Group life* VG
Personal accidents AP
Medical expenses GM
Health SA
Civil liability and professional risks RC
Marine and transport MT
Fire IN
Agricultural and animal AA
Automobiles AU
Credit CR
Surety CA
Housing credit CV
Financial guarantee GF
Earthquake and volcanic eruption TE
Hurricane and other hydrometeorological risks HH
Miscellaneous DV
First-risk fidelity bonds** FP
Other fidelity bonds FO
Judicial bonds covering motor vehicle drivers JA
Other judicial bonds JO
Administrative bonds FA
Credit bonds FC
** These are bonds whose subscribed insured amount is determined as the expected amount of claims.
Field 3:
Policy number.- The assigned policy number must be indicated, according to the internal control criteria of the Insurance Institution or Mutual Society. In the case of assumed reinsurance or co-surety operations, this concept will correspond to the policy number or assumed reinsurance or co-surety contract.
Field 4:
Certificate, clause or endorsement (movement).- In cases where, in addition to the policy, there are certificates, clauses, or endorsements that consider different premiums, validities, and coverages than the main policy and for which a specific reserve valuation has been carried out, the respective Insurance Institution or Mutual Society must, according to its own criteria, establish a control number to identify the information related to said certificates, clauses, or endorsements.
Field 5:
Start date of validity.- The start date of validity of the policy, certificate, clause, or endorsement corresponding to each record must be indicated. In the case of assumed reinsurance or co-surety operations, this concept will correspond to the start date of validity of the assumed reinsurance or co-surety policy or contract. The date must be an 8-character string of numbers, indicating the day in the first two positions; the month in the third and fourth; and the year from the fifth to the eighth, completing with leading zeros in the case of months and days that do not occupy the two assigned positions.
Field 6:
End date of validity.- The date on which the validity of the policy, certificate, clause, or endorsement corresponding to each record will end must be indicated. In the case of assumed reinsurance or co-surety operations, this concept will correspond to the end date of validity of the assumed reinsurance or co-surety policy or contract. The date must be an 8-character string of numbers, indicating the day in the first two positions; the month in the third and fourth; and the year from the fifth to the eighth, completing with leading zeros in the case of months and days that do not occupy the two assigned positions.
Field 7:
Gross issued premium.- The gross amount of the issued premium used for the reserve valuation of the policy, certificate, clause, or endorsement in question must be indicated, without including taxes or policy fees.
Field 8:
Gross risk premium.- The amount of the risk premium of the policy, certificate, clause, or endorsement in question must be identified, without deducting the ceded reinsurance portion.
Field 9:
Gross unearned risk premium.- The amount of the gross unearned risk premium of the policy, certificate, clause, or endorsement in question must be identified, without deducting the ceded reinsurance portion. This value will correspond to the value of the gross risk premium multiplied by the accrual factor corresponding to the portion of the unexpired validity period.
Field 10:
Acquisition cost.- This will be the amount of the acquisition cost of the policy, certificate, clause, or endorsement in question. In the case of long-term life insurance, the acquisition cost must be the levelized acquisition cost.
Field 11:
Administration expenses.- The amount of administration expense that has been applied for the calculation of the reserve of the policy, certificate, clause, or endorsement in question must be identified. In the case of long-term life insurance, the administration expense must be the levelized annual expense used for the reserve valuation.
Field 12:
Profit margin.- The amount corresponding to the profit margin that has been applied for the calculation of the reserve of the policy, certificate, clause, or endorsement in question must be identified.
Field 13:
Product registration number.- The product registration number obtained before this Commission, corresponding to the policy, certificate, clause, or endorsement, must be indicated. In the case of insurance plans that, within the framework of the applicable regulations, do not require registration, " Exempt " must be indicated.
Field 14:
Currency or monetary unit.- The currency or monetary unit in which the value of the benefit or risk covered by the product corresponding to the policy, certificate, clause, or endorsement in question is defined or indexed must be indicated. The indication must be made with a 4-character text string, in accordance with what is indicated in the following table:
Currency or monetary unit Text string
National currency MNAC
Dollars DOLA
Indexed INDX
Special monetary unit *
*In the case of plans denominated in special monetary units such as USAG, UVAC, SMDF, etc., a key identifying the type of monetary unit in question must be indicated through a catalog in a Word file, which the Institution itself must prepare, indicating the keys used and the description of the monetary unit corresponding to each key. The Word file containing the aforementioned catalog must be sent as part of the RR3RRCBD package.
Field 15:
Insurance plan identifier.- For each policy, certificate, clause, or endorsement, a key that these Insurance Institutions and Mutual Societies will freely define must be indicated, by which they will specifically identify the type of plan in question, according to their control and classification criteria. For this purpose, these Insurance Institutions and Mutual Societies must design a catalog in which they indicate the keys used and the characteristics of the insurance plans corresponding to each key. The catalog must be sent in a Word file, as part of the RR3RRCBD package.
Field 16:
Retained issued premium.- The amount of the issued premium of the policy, certificate, clause, or endorsement in question must be indicated, without including taxes or policy fees, deducted from the portion of premium that has been ceded in proportional reinsurance.
Field 17:
Reinsurance recoverable amounts.- The amount of reinsurance recoverable amounts, determined in accordance with applicable regulations and with which the corresponding asset item has been integrated, must be identified.
Field 18:
Multi-year policy identifier.- It must be indicated whether the policy, certificate, clause, or endorsement corresponds to a multi-year policy. This indication must be made with the text string " MA ".
Field 19:
Basic or additional benefit identifier.- In the type of insurance plans that apply, it must be indicated whether it is a basic benefit or an additional benefit. In the case of basic benefits, the field must be denoted as " BB " and in the case of an additional benefit, the field must be denoted as " BA ", with the understanding that one benefit must be reported per record.
Field 20:
Insured's age at contracting.- In long-term life insurance, the age of the insured that was used for underwriting the policy or certificate must be indicated.
Field 21:
Gross insured sum.- In long-term life insurance, the gross insured sum with which the reserve has been valued must be indicated. In the case of plans that, due to their characteristics, have a variable insured sum, the insured sum reached at the time of valuation must be indicated. In the case of annuities or other types of periodic indemnities, the amount of the periodic indemnity reached at the time of valuation must be indicated as the insured sum.
Field 22:
Premium payment term.- When applicable, the premium payment term contracted with the insured must be indicated. In the case of long-term plans contracted with a single premium, the premium payment term must be indicated as " 1 ". In case of fractions of a year, it must be indicated with 2 decimals.
Field 23:
Plan duration.- For insurance with a duration greater than one year, the number of years that the validity period of the insurance plan in question will comprise must be indicated. In case of fractions of a year, it must be indicated with 2 decimals.
Field 24:
Insured's sex.- When applicable, the sex of the insured must be indicated in the policy or insurance certificate in question. The sex must be indicated in a 1-character text string, indicating " H " if male, or " M " if female.
Field 25:
Paid-up and extended identifier.- When applicable, it must be indicated whether it is a paid-up or extended insurance. The indication must be made with a 3-character text string, indicating " PRO " if the insurance is extended, or " SAL " if it is paid-up. Regardless of this identifier, paid-up or extended plans must be classified into some of the traditional life insurance plans indicated in the following section.
Field 26:
Traditional life insurance plan identifier.- In the case of basic life insurance benefits, it must be indicated whether it is one of the traditional life insurance plans listed below:
Plan type Text string
Whole life VIT
Term TEM
Endowment DOT
Other OTR
Field 27:
BEL-Risk.- In the case of short-term insurance, this will be the amount of the risk component of the best estimate of the unearned premium reserve. In the case of long-term insurance, it must correspond to the best estimate of all future flows of the Insurance Institution or Mutual Society.
Field 28:
Future premiums.- In the case of short-term insurance, future premiums not considered in the premium debtor registered by the Insurance Institution or Mutual Society must be reported.
Field 29:
BEL-Expenses.- In the case of short-term insurance, this will be the amount of the expense component of the best estimate of the unearned premium reserve.
Field 30:
Risk margin.- In the case of short-term insurance, this will be the amount of the risk margin corresponding to the unearned premium reserve. This concept is only mandatory to report at the policy level when the institution has registered that calculation method for the risk margin as part of its reserve methodology.
Field 31:
Other future costs.- In the case of short-term insurance, other future costs that must form part of the unearned premium reserve must be reported.
Field 32:
Original Currency Reserve.- In the case of short-term insurance, the gross amount of the unearned premium reserve of the policy, certificate, clause, or endorsement, determined in accordance with the valuation criteria provided in the applicable regulations, in units of its original currency or monetary unit in which the plan is contracted, must be indicated.
Field 33:
National Currency Reserve.- In the case of short-term insurance, the gross amount of the unearned premium reserve of the policy, certificate, clause, or endorsement, determined in accordance with the valuation criteria provided in the applicable regulations, translated to national currency, must be indicated.
1.2.- Word File containing the catalog of special monetary unit keys reported in the text files of the detailed valuation databases
A Word file, in free format, in which, for plans denominated in special monetary units such as USAG, UVAC, SMDF, etc., the keys used and the description of the corresponding monetary unit are indicated. The keys reported in this file must correspond to the keys used in Field 14: " Currency or monetary unit ", of the text files of the detailed valuation databases policy by policy of the unearned premium reserve.
The name of the Word file must consist of 26 alphanumeric characters that must be ordered as follows:
a)
In the first eight positions, the specific identifier of the files must be written: " RR3RRCBD "
b)
From the ninth to the thirteenth positions, the key corresponding to the Word file must be written: " MONED ".
c)
In the fourteenth position, the company type key must be written.
Key Definition
H Insurance Institutions authorized to operate health insurance.
G Insurance Institutions authorized to operate financial guarantee insurance.
V Insurance Institutions authorized to operate housing credit insurance.
S Other Insurance Institutions and Mutual Societies.
d)
From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.
e)
From the nineteenth to the twenty-second positions, the year must be written.
f)
In the twenty-third and twenty-fourth positions, the reported month must be written.
g)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
Company Key: " S "
Company Number: " 0009 "
Day: " 31 "
Month: December ( " 12 " )
Year: 2013
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Extension
R R 3 R R C B D M O N E D S 0 0 0 9 2 0 1 3 1 2 3 1 .DOC
1.3.- Word File containing the catalog of keys and characteristics used to classify insurance plans reported in the text files of the detailed valuation databases
A Word file, in free format, in which the keys used and the characteristics of the insurance plans corresponding to each key are indicated, by which they specifically identify the types of plans in question, according to their control and classification criteria. The keys reported in this file must correspond to the keys used in Field 15: " Insurance plan identifier ", of the text files of the detailed valuation databases policy by policy of the unearned premium reserve.
The name of the Word file must consist of 26 alphanumeric characters that must be ordered as follows:
a)
In the first eight positions, the specific identifier of the files must be written: " RR3RRCBD "
b)
From the ninth to the thirteenth positions, the key corresponding to the Word file must be written: " IPLAN ".
c)
In the fourteenth position, the company type key must be written.
Key Definition
H Insurance Institutions authorized to operate health insurance.
G Insurance Institutions authorized to operate financial guarantee insurance.
V Insurance Institutions authorized to operate housing credit insurance.
S Other Insurance Institutions and Mutual Societies.
d)
From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.
e)
From the nineteenth to the twenty-second positions, the year must be written.
f)
In the twenty-third and twenty-fourth positions, the reported month must be written.
g)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
Company Key: " S "
Company Number: " 0009 "
Day: " 31 "
Month: December ( " 12 " )
Year: 2013
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Extension
R R 3 R R C B D I P L A N S 0 0 0 9 2 0 1 3 1 2 3 1 .DOC
1.4.- Text files of the databases with detailed information on reinsurance recoverable amounts
Up to 29 reports in text file format with detailed information on reinsurance recoverable amounts, corresponding to the unearned premium reserve, whose names must consist of 25 alphanumeric characters, which must be ordered as follows:
a)
In the first ten positions, the specific identifier of the files must be written:
"RR3RRCBDIR"
b)
In the eleventh and twelfth positions, the report key must be written.
Report Key
Description
01
Individual life short-term insurance
02
Individual life long-term insurance
03
Individual life flexible insurance
04
Individual life pension insurance
05
Group life short-term insurance
06
Group life long-term insurance
07
Group life flexible insurance
08
Group life pension insurance
09
Personal accident insurance
10
Medical expenses insurance
11
Health insurance
12
Fire insurance
13
Automobile insurance
14
Miscellaneous insurance
15
Agricultural and animal insurance
16
Maritime and transport insurance
17
Civil liability insurance
18
Earthquake and/or volcanic eruption insurance
19
Hurricane and/or other hydrometeorological risk insurance
20
Credit insurance
21
Housing credit insurance
22
Financial guarantee insurance
23
Fidelity surety bonds
24
Judicial surety bonds
25
Administrative surety bonds
26
Credit surety bonds
27
Group life short-term insurance
28
Group life long-term insurance
29
Caution surety bonds
c)
In the thirteenth position, the company type key must be written.
Key
Definition
H
Insurance Institutions authorized to operate health insurance.
G
Insurance Institutions authorized to operate financial guarantee insurance.
V
Insurance Institutions authorized to operate housing credit insurance.
S
Other Insurance Institutions and Mutual Societies.
d)
From the fourteenth to the seventeenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros to occupy the four positions.
e)
From the eighteenth to the twenty-first positions, the year must be written.
f)
In the twenty-second and twenty-third positions, the month being reported must be written.
g)
In the twenty-fourth and twenty-fifth positions, the last day of the month being reported must be written.
Example:
Report ( " 01 " )
Company Key: " S "
Company Number: " 0009 "
Day: ( " 31 " )
Month: December ( " 12 " )
Year: 2015
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Extension
R
R
3
R
R
C
B
D
I
R
0
1
S
0
0
0
9
2
0
1
5
1
2
3
1
.TXT
The structure, order, identifiers, field lengths, and other details of the databases shall be as follows:
a)
The databases must contain information ordered in matrix arrays, in which the columns correspond to the fields described below and the rows to the records of each of the policies, certificates, or endorsements that make up the reserve valuation. The fields will be delimited from each other by the " | " sign, known as " pipe ".
No.
Name
Type
Size
1
Direct or assumed operation
Alphanumeric
2
2
Branch, sub-branch, or type of insurance/surety bond
Alphanumeric
2
3
Policy number
Alphanumeric
30
4
Certificate, clause, or endorsement (movement)
Alphanumeric
30
5
Multi-year policy identifier
Alphanumeric
2
6
Reinsurer number
Alphanumeric
15
7
Risk BEL participation
Numeric
15
8
Probability of default
Numeric
6 decimals
9
Recoverable amount O.C.
Numeric
15
10
Recoverable amount N.C.
Numeric
15
b)
When a field is not applicable to a record, the column for that field must be left empty, maintaining, notwithstanding the foregoing, the corresponding pipes.
c)
The amounts indicated in each of the fields that make up the databases must be expressed in the original currency or monetary unit in which the policy was subscribed, except with respect to the field named Recoverable amount N.C., in which the amount must always be expressed in national currency, for which, if applicable, the exchange rate corresponding to the annual close shall be used.
d)
The database in question must contain only information on policies in force and, if applicable, on policies issued in advance at the time of valuation, so it must not include information on policies, endorsements, or certificates that are expired or cancelled at the time of such valuation, regardless of whether such information is maintained within the controls of the respective Insurance Institution or Mutual Society.
e)
The quantities reported in the database in question, except for what corresponds to the Probability of default, must be expressed without decimals.
f)
The fields referred to in the preceding subsection a) must be filled in accordance with the following definitions:
Field 1:
Direct or assumed operation.- Refers to whether the policy, certificate, clause, or endorsement corresponds to a direct operation, assumed operation, or retrocession. In the first case, the text " DI " will be captured, in the second, " TO ", and in the third case " RF ".
Field 2:
Branch, sub-branch, or type of insurance/surety bond.- In this field, the corresponding key will be indicated, according to the following table:
Branch, sub-branch, or type of insurance/surety bond
Key
Individual life
VI
Group life*
VG
Personal accidents
AP
Medical expenses
GM
Health
SA
Civil liability and professional risks
RC
Maritime and transport
MT
Fire
IN
Agricultural and animals
AA
Automobiles
AU
Credit
CR
Caution
CA
Housing credit
CV
Financial guarantee
GF
Earthquake and volcanic eruption
TE
Hurricane and other hydrometeorological nature
HH
Miscellaneous
DV
First risk fidelity surety bonds**
FP
Other fidelity surety bonds
FO
Judicial surety bonds covering drivers of motor vehicles
JA
Other judicial surety bonds
JO
Administrative surety bonds
FA
Credit surety bonds
FC
** Those are surety bonds whose secured amount subscribed is determined as the expected amount of claims.
Field 3:
Policy number.- The policy number assigned in accordance with the internal control criteria of the Insurance Institution or Mutual Society must be indicated. In the case of assumed reinsurance or retrocession operations, this concept will correspond to the policy number or contract number of the assumed reinsurance or retrocession.
Field 4:
Certificate, clause, or endorsement (movement).- In cases where certificates, clauses, or endorsements exist in addition to the policy, which consider premiums, terms, and coverages different from the main policy and for which a specific valuation of their reserve has been carried out, the respective Insurance Institution or Mutual Society must, in accordance with its own criteria, establish a control number to serve to identify the information related to said certificates, clauses, or endorsements.
Field 5:
Multi-year policy identifier.- It will be indicated whether the policy, certificate, clause, or endorsement corresponds to a multi-year policy. This indication must be made with the text string " MA ".
Field 6:
Reinsurer number.- The reinsurer's key, assigned by the Ministry of Finance and Public Credit in the General Register of Authorized Foreign Reinsurers to Assume Reinsurance and Retrocession in the Country, must be indicated. In the case where the reinsurer covering the risk is not registered, " NO REGISTRADA " will be captured in this field.
Field 7:
Risk BEL participation.- In the case of short-term insurance, the quantity resulting from multiplying the proportion of risk ceded by the risk component of the best estimate of the corresponding policy, certificate, or endorsement will be recorded. In the case of long-term insurance, it must correspond to the amount of recoverable reinsurance amounts, relative to the best estimate of all future flows of the Insurance Institution or Mutual Society.
Field 8:
Probability of default.- The probability of default will be that corresponding to the Insurance Institution or foreign reinsurer entity, based on the rating that such entity has, in accordance with fractions V and VIII of Provision 8.20.2 of Chapter 8.20 of these provisions.
Field 9:
Recoverable amount O.C.- In the case of short-term insurance, the amount of recoverable reinsurance amounts in original currency will be identified, determined in accordance with applicable regulations and with which the corresponding asset item has been integrated.
Field 10:
Recoverable amount N.C.- In the case of short-term insurance, the amount of recoverable reinsurance amounts in national currency will be identified, determined in accordance with applicable regulations and with which the corresponding asset item has been integrated.
2.- The product RR3RRCDT will contain the following:
a)
Explanatory documents of the methodological detail of the valuation of the unearned risk reserve, in PDF format.
b)
Text files containing the premium and loss information of the unearned risk reserve.
c)
The Excel format file corresponding to the premium and loss information of the unearned risk reserve.
d)
Files with the explanatory documents of the procedure and results corresponding to the retrospective test (back-testing test) of the unearned risk reserve, in PDF format.
The information indicated in subsections a), b), c) and d) above will be indicated in items 2.1, 2.2, 2.3 and 2.4, respectively, as follows:
a)
For its sending, the product must be encrypted in a single file in .ZIP.PGP format, whose name must be integrated from 21 alphanumeric characters, ordered as follows:
b)
In the first eight positions, the specific identifier of the product must be written:
" RR3RRCDT "
c)
In the ninth position, the company type key must be written:
Key
Definition
H
Insurance Institutions authorized to operate health insurance.
G
Insurance Institutions authorized to operate financial guarantee insurance.
V
Insurance Institutions authorized to operate housing credit insurance.
S
Other Insurance Institutions and Mutual Societies.
d)
From the tenth to the thirteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros to occupy the four positions.
e)
From the fourteenth to the seventeenth positions, the year must be written.
f)
In the eighteenth and nineteenth positions, the month being reported must be written.
g)
In the twentieth and twenty-first positions, the day of the month being reported must be indicated.
Example:
Company Key: " S "
Company Number: " 0009 "
Day: ( " 31 " )
Month: December ( " 12 " )
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Extension
R
R
3
R
R
C
D
T
S
0
0
0
9
2
0
1
3
1
2
3
1
.ZIP
.PGP
2.1.- Explanatory documents of the methodological detail of the valuation of the unearned risk reserve
For each operation carried out by the respective Insurance Institution or Mutual Society, an explanatory document, in free text, of the development, hypotheses, and results of the application of the valuation methods, by which the unearned risk reserve of each branch or type of insurance was determined.
The explanatory document referred to in the preceding paragraph will be sent in PDF format and its name must be integrated from 26 alphanumeric characters, ordered as follows:
a)
In the first eleven positions, the specific identifier of the file in PDF format must be written: " RR3RRCDTDES "
b)
In the twelfth and thirteenth positions, the operation key must be written.
Operation Key
Description
01
Life
02
Accidents and diseases
03
Damages
c)
In the fourteenth position, the company type key must be written.
Key
Definition
H
Insurance Institutions authorized to operate health insurance.
G
Insurance Institutions authorized to operate financial guarantee insurance.
V
Insurance Institutions authorized to operate housing credit insurance.
S
Other Insurance Institutions and Mutual Societies.
d)
From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros to occupy the four positions.
e)
From the nineteenth to the twenty-second positions, the year must be written.
f)
From the twenty-third to the twenty-fourth positions, the month being reported must be written.
g)
From the twenty-fifth to the twenty-sixth positions, the last day of the month being reported must be written.
Example:
Detail corresponding to the damages operation ( " 03 " ).
Company Key: " S "
Company Number: " 0009 "
Day: ( " 31 " )
Month: December ( " 12 " )
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Extension
R
R
3
R
R
C
D
T
D
E
S
0
3
S
0
0
0
9
2
0
1
3
1
2
3
1
2.2.- Text files containing the premium and loss information of the unearned risk reserve
A report in text file format, of the premium and loss information of each branch or type of insurance, whose name must be integrated from 24 alphanumeric characters, which must be ordered as follows:
a)
In the first eleven positions, the specific identifier of the file must be written:
" RR3RRCDTTPS " .
b)
In the twelfth position, the company type key must be written.
Key
Definition
H
Insurance Institutions authorized to operate health insurance.
G
Insurance Institutions authorized to operate financial guarantee insurance.
V
Insurance Institutions authorized to operate housing credit insurance.
S
Other Insurance Institutions and Mutual Societies.
d)
From the thirteenth to the sixteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros to occupy the four positions.
e)
From the seventeenth to the twentieth positions, the year must be written.
f)
In the twenty-first and twenty-second positions, the month being reported must be written.
g)
In the twenty-third and twenty-fourth positions, the last day of the month being reported must be written.
Example:
Company Key: " S "
Company Number: " 0009 "
Day: ( " 31 " )
Month: December ( " 12 " )
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Extension
R
R
3
R
R
C
D
T
T
P
S
S
0
0
0
9
2
0
1
3
1
2
3
1
.TXT
The description of the report fields is as follows:
Field 1:
Branch or type of insurance.- The branch or type of insurance to which the premium and loss information refers must be reported according to the following:
Branch or type of insurance
Non-endowment long-term life insurance
Endowment long-term life insurance
Flexible life insurance
Short-term life insurance
Personal accident insurance
Medical expenses insurance
Health insurance
Civil liability branch insurance
Maritime and transport branch insurance
Fire branch insurance
Agricultural and animal branch insurance
Automobile branch insurance
Credit branch insurance
Caution branch insurance
Earthquake and volcanic eruption insurance
Hydrometeorological risk insurance
Housing credit branch insurance
Financial guarantee branch insurance
Miscellaneous branch insurance
Field 2:
Origin year.- The premium and loss information will correspond to the last 8 calendar years; in this sense, for each branch or type of insurance, in this Field, the following values must be captured in consecutive rows:
Content
n-7
n-6
n-5
n-4
n-3
n-2
n-1
n
Where the value of n corresponds to the value of the most recent year being reported.
Example:
for Agricultural and Animal, and Automobile coverages, the content of fields 1 and 2 that must be reported at the close of the 2015 exercise must be:
Field 1
Field 2
...
...
Agricultural and animal branch insurance
2008
Agricultural and animal branch insurance
2009
Agricultural and animal branch insurance
2010
Agricultural and animal branch insurance
2011
Agricultural and animal branch insurance
2012
Agricultural and animal branch insurance
2013
Agricultural and animal branch insurance
2014
Agricultural and animal branch insurance
2015
Automobile branch insurance
2008
Automobile branch insurance
2009
Automobile branch insurance
2010
Automobile branch insurance
2011
Automobile branch insurance
2012
Automobile branch insurance
2013
Automobile branch insurance
2014
Automobile branch insurance
2015
...
...
Field 3:
Issued premium.- The issued premium corresponding to the branch or type of insurance, and origin year reported in fields 1 and 2 of said record must be captured in each record; understood by issued premium and origin year what is established in Annex 5.3.2 of this Circular.
Fields 4 to 11:
Development periods of 0 to 7 of the gross amount of losses, dividends, surrenders, adjustments, adjustment expenses, salvages, and third-party recoveries.-
In fields 4 to 11 of each record, the gross amount of losses, dividends, surrenders, adjustments, adjustment expenses, salvages, and third-party recoveries (except reinsurance) of the respective branch or type of insurance must be reported, classified by origin year and development year, using for this purpose the classification criteria established in fraction I of Annex 5.3.2 of this Circular and considering that, the branch or type of insurance corresponds to the value reported in field 1 and the origin year corresponds to the value reported in field 2 of each record. Likewise, to report the referred information, it must be considered that each field corresponds to a development year as follows:
Field
4
5
6
7
8
9
10
11
Development Year
0
1
2
3
4
5
6
7
Field 12:
Retained premium.- The retained premium corresponding to the branch or type of insurance, and origin year reported in fields 1 and 2 of said record must be captured in each record.
Fields 13 to 20:
Development periods of 0 to 7 of the retained amount of losses, dividends, surrenders, adjustments, adjustment expenses, salvages, and third-party recoveries.-
In fields 13 to 20 of each record, the retained amount of losses, dividends, surrenders, adjustments, adjustment expenses, salvages, and third-party recoveries (except reinsurance) of the respective branch or type of insurance must be reported, classified by origin year and development year, using for this purpose the classification criteria established in fraction I of Annex 5.3.2 of this Circular and considering that, the branch or type of insurance corresponds to the value reported in field 1 and the origin year corresponds to the value reported in field 2 of each record. Likewise, to report the referred information, it must be considered that each field corresponds to a development year as follows:
Field
13
14
15
16
17
18
19
20
Development Year
0
1
2
3
4
5
6
7
2.3.- The Excel format file corresponding to the premium and loss information of the unearned risk reserve
The text files containing the premium and loss information of the unearned risk reserve referred to in the immediate preceding item 2.2 must be generated using the Excel format file corresponding to the premium and loss information of the unearned risk reserve, which will be available, as well as its respective user manual, on the Commission's Website ( www.cnsf.gob.mx ) with the name " RR3RRCDTTPS.xls ".
The Excel format file corresponding to the premium and loss information of the unearned risk reserve, containing the information reported in accordance with what is defined in the immediate preceding item 2.2, must be sent as part of the product RR3RRCDT, for which, it must be renamed as follows:
The name must be integrated from 24 alphanumeric characters that must be ordered as follows:
a)
In the first eleven positions, the specific identifier of the file must be written:
" RR3RRCDTTPS " .
b)
In the twelfth position, the company type key must be written.
Key
Definition
H
Insurance Institutions authorized to operate health insurance.
G
Insurance Institutions authorized to operate financial guarantee insurance.
V
Insurance Institutions authorized to operate housing credit insurance.
S
Other Insurance Institutions and Mutual Societies.
d)
From the thirteenth to the sixteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros to occupy the four positions.
e)
From the seventeenth to the twentieth positions, the year must be written.
f)
In the twenty-first and twenty-second positions, the month being reported must be written.
g)
In the twenty-third and twenty-fourth positions, the last day of the month being reported must be written.
Example:
Company Key: " S "
Company Number: " 0009 "
Day: " 31 "
Month: December ( " 12 " )
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Extension
R
R
3
R
R
C
D
T
T
P
S
S
0
0
0
9
2
0
1
3
1
2
3
1
.XLS
2.4- Files with the explanatory documents of the procedure and results corresponding to the retrospective test (back-testing test) of the unearned risk reserve
For each operation carried out by the respective Insurance Institution or Mutual Society, an explanatory document of the procedure and results corresponding to the retrospective test (back-testing test) must be presented, by which the adequate functioning of the actuarial methods with which the valuation of the unearned risk reserve was determined was verified.
The document referred to in the preceding paragraph will be sent in PDF format and its name must
to be composed of 26 alphanumeric characters, ordered as follows: a) In the first eleven positions, the specific file identifier must be written: "RR3RRCDTPRE" b) In the twelfth and thirteenth positions, the operation key must be written. Key operation Description 01 Life 02 Accidents and illnesses 03 Damages c) In the fourteenth position, the company type key must be written. Key Definition H Insurance Institutions authorized to operate health insurance. G Insurance Institutions authorized to operate financial guarantee insurance. V Insurance Institutions authorized to operate housing credit insurance. S Other Insurance Institutions and Mutual Societies. d) From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions. e) From the nineteenth to the twenty-second positions, the year must be written. f) In the twenty-third and twenty-fourth positions, the reporting month must be written. g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written. Example: Retrospective test report for the reserve for unearned premiums of the damages operation ("03") Company key: "S" Company number: "0009" Day: ("31") Month: December ("12") Year: 2013 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Extension R R 3 R R C D T P R E 0 3 S 0 0 0 9 2 0 1 3 1 2 3 1 .PDF II.- Reserve for outstanding obligations Information with quarterly delivery frequency The valuation of the reserve for outstanding obligations for life, damages, and accidents and illnesses insurance, with quarterly delivery frequency, shall consist of the following: The product RR3OPCCV, which will contain the text files of the valuation of the reserve for outstanding obligations, the Excel format file corresponding to the summary of the valuation of the reserve for outstanding obligations, and the certification document or documents corresponding to the valuation of the reserve for outstanding obligations signed by the actuaries responsible for it, as referred to in the immediately following subsections 1, 2, and 3, in accordance with what is indicated below: a) For its submission, the product must be encrypted in a single file in .ZIP.PGP format, whose name must be composed of 21 alphanumeric characters, ordered as follows: b) In the first eight positions, the specific product identifier must be written: "RR3OPCCV". c) In the ninth position, the company type key must be written: Key Definition H Insurance Institutions authorized to operate health insurance. G Insurance Institutions authorized to operate financial guarantee insurance. V Insurance Institutions authorized to operate housing credit insurance. S Other Insurance Institutions and Mutual Societies. d) From the tenth to the thirteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions. e) From the fourteenth to the seventeenth positions, the year must be written. f) In the eighteenth and nineteenth positions, the reporting month must be written. g) In the twentieth and twenty-first positions, the last day of the reporting month must be indicated. Example: Company key: "S" Company number: "0009" Day: ("30") Month: June ("06") Year: 2013 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Extension R R 3 O P C C V S 0 0 0 9 2 0 1 3 0 6 3 0 .ZIP .PGP 1.- Valuation of the reserve for outstanding obligations From 2 to 13 reports in text file format, of the results of the valuation of each branch or type of insurance, whose name must be composed of 26 alphanumeric characters that must be ordered as follows: a) In the first eleven positions, the specific file identifier must be written: "RR3OPCCVRES". b) In the twelfth and thirteenth positions, the report key must be written. Report key Description 01 Reserve for outstanding obligations of the life operation 02 Recoverable reinsurance amounts of the life operation 03 Reserve for outstanding obligations of reinsurance taken from the life operation 04 Recoverable reinsurance amounts corresponding to reinsurance taken from the life operation (Retrocession) 05 Reserve for outstanding obligations of the accidents and illnesses operation 06 Recoverable reinsurance amounts of the accidents and illnesses operation 07 Reserve for outstanding obligations of reinsurance taken from the accidents and illnesses operation 08 Recoverable reinsurance amounts corresponding to reinsurance taken from the accidents and illnesses operation (Retrocession) 09 Reserve for outstanding obligations of the damages operation 10 Recoverable reinsurance amounts of the damages operation 11 Reserve for outstanding obligations of reinsurance taken from the damages operation 12 Recoverable reinsurance amounts corresponding to reinsurance taken from the damages operation (Retrocession) 13 Responsible Parties c) In the fourteenth position, the company type key must be written. Key Definition H Insurance Institutions authorized to operate health insurance. G Insurance Institutions authorized to operate financial guarantee insurance. V Insurance Institutions authorized to operate housing credit insurance. S Other Insurance Institutions and Mutual Societies. d) From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions. e) From the nineteenth to the twenty-second positions, the year must be written. f) In the twenty-third and twenty-fourth positions, the reporting month must be written. g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written. Example: Report: "01" Company key: "S" Company number: "0009" Day: ("30") Month: June ("06") Year: 2013 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Extension R R 3 O P C C V R E S 0 1 S 0 0 0 9 2 0 1 3 0 6 3 0 .TXT Each of the valuation results reports for the reserve for outstanding obligations will contain the fields described below for each of them, which must be reported in a matrix arrangement where each listed field must be delimited by the character known as a pipe ("|") to the left and right of each field, except for the first and last of these, in which case, they must only be delimited by pipes to the right and left, respectively, and each record will correspond to the detail of the information by branch or type of insurance, according to each operation. The number of fields and records will be fixed and will depend on each report, so, when a field is not applicable in a given report, it must be left empty. The figures in all reports must be reported in national currency at the exchange rate corresponding to the currency or monetary unit in question, as of the valuation date. For these purposes, the exchange rate value of the index or currency in question, published in the Official Gazette of the Federation as of the valuation date, must be used. a) Reports of "Reserve for outstanding obligations of the life operation", "Reserve for outstanding obligations of reinsurance taken from the life operation", "Reserve for outstanding obligations of the accidents and illnesses operation", "Reserve for outstanding obligations of reinsurance taken from the accidents and illnesses operation", "Reserve for outstanding obligations of the damages operation" and "Reserve for outstanding obligations of reinsurance taken from the damages operation". These reports must contain information regarding the reserve for outstanding obligations of life, accidents and illnesses, and damages operations, originating from direct and taken operations, which is defined below and disaggregated according to the branches or types of insurance corresponding to each operation. In the case of reports "Reserve for outstanding obligations of the life operation", "Reserve for outstanding obligations of the accidents and illnesses operation" and "Reserve for outstanding obligations of the damages operation", the information to be reported in fields 2 to 13 must be total (direct and taken). Field 1: Branch or type of insurance.- Must report, in each record, the name of the corresponding branch or type of insurance, as indicated in the definition of records that follows this definition of fields. Example for the format corresponding to the Reserve for outstanding obligations of the life operation. Field 1, in record 1, must contain the text: Individual Life Example for the format corresponding to the Reserve for outstanding obligations of the accidents and illnesses operation. Field 1, in record 6, must contain the text: Collective Example for the format corresponding to the Reserve for outstanding obligations of the damages operation. Field 1, in record 5, must contain the text: Automobiles Field 2: For reported claims of known amount.- Refers to the reserve constituted for outstanding obligations for reported claims whose amount of the obligation is known at the time of valuation and its balance is not required to be determined by an actuarial valuation. Field 3: Other obligations of known amount, except dividends.- Refers to the reserve constituted for other obligations of known amount, except for dividends, whose amount of the obligation is known at the time of valuation and its balance is not required to be determined by an actuarial valuation. Field 4: Future obligations payable in installments: Refers to the reserve constituted for future obligations payable in installments which will correspond to the estimated amount of the present value of future payment flows, discounted using market risk-free interest rate curves for each currency or monetary unit. Field 5: Total outstanding obligations for claims and other known amount obligations, except dividends.- Refers to the total outstanding obligations for claims and other known amount obligations, except dividends, (sum of fields 2, 3 and 4). Field 6: BEL- SONR and GAAS.- Refers to the best estimate of future obligations for outstanding obligations for claims that, having already occurred on the valuation date, have not yet been reported or have not been completely reported, as well as their adjustment expenses, salvages, and recoveries. Field 7: Risk margin for SONR and GAAS.- Must report the amount of risk margin obtained from the valuation of the SONR reserve. Field 8: SONR and GAAS Reserve.- Refers to the amount of the reserve, which incorporates the part corresponding to the BEL of future obligations for claims incurred but not reported, for adjustment expenses assigned to claims and the risk margin (sum of fields 6 and 7). Field 9: Dividends of known amounts.- Refers to the reserve constituted for outstanding obligations for dividends that constitute certain or due obligations. Field 10: Contingent dividends.- Refers to the reserve constituted for outstanding obligations for dividends that do not yet constitute certain or due obligations, but are estimated to be paid in the future for the obligations to distribute profits provided for in insurance contracts, derived from the favorable behavior of the risks, returns or expenses of the Insurance Institution or Mutual Society during the accrued period of validity of the policies in force. Field 11: Total dividends.- Corresponds to the sum of the reserves for dividends of known amounts and contingent dividends (sum of fields 9 and 10). Field 12: Outstanding obligations for administration of expired payments and benefits.- Refers to the reserve for outstanding obligations corresponding to the administration of sums that, by way of dividends, endowments, annuities or other indemnities, are entrusted by policyholders or their beneficiaries to Insurance Institutions or Mutual Societies. Field 13: Amount of the OPC reserve.- Refers to the sum of the amounts of the reserves for outstanding obligations, indicated in fields 5, 8, 11 and 12. In each record, the information reported in fields 2 to 13 must correspond to the branch or type of insurance reported in field 1. Such information must be reported by branch or type of insurance, as defined below: In the case of reports containing information on the types of insurance for the life operation. 15 records must be reported, as follows. Record 1: Individual Life: The totals of the information corresponding to the basic and additional benefits of individual life insurance plans, reported in record 2: Basic benefits and 7: Additional benefits, will be reported. Record 2: Basic benefits: The totals of the information corresponding to the basic benefits of individual life insurance plans will be reported. Record 3: Traditional: Information corresponding to the basic benefits of individual life insurance plans (term, endowment, whole life, etc.) that are not classified as flexible plans or private pension plans will be reported. Record 4: Flexible: Information corresponding to the basic benefits of individual life insurance plans, which are classified as flexible plans based on the characteristics of premium payment, of the constitution of the reserve, in accordance with what is registered in the technical note corresponding to each product, will be reported. Record 5: Pensions: Information corresponding to the basic benefits of individual private pension plans, in accordance with the provisions of article 27, section I, second paragraph of the LISF, will be reported. Record 6: Others: Information corresponding to basic benefits of individual life insurance plans, whose special characteristics differ from the characteristics described for the plans classified in the preceding subsections, will be reported. Record 7: Additional benefits: The totals of the information corresponding to the additional benefits of individual life insurance plans will be reported. Record 8: Group Life: The totals of the information corresponding to the basic and additional benefits of group life insurance plans will be reported. Record 9: Basic benefits: The totals of the information corresponding to the basic benefits of group life insurance plans will be reported. Record 10: Traditional: Information corresponding to basic benefits of group life insurance plans (term, endowment, whole life, etc.) that are not classified as flexible plans or private pension plans will be reported. Record 11: Flexible: Information corresponding to basic benefits of group life insurance plans, which are classified as flexible plans based on the characteristics of premium payment, of the constitution of the reserve, in accordance with what is registered in the technical note corresponding to each product, will be reported. Record 12: Pensions: Information corresponding to basic benefits of group life private pension plans, in accordance with the provisions of article 27, section I, second paragraph of the LISF, will be reported. Record 13: Others: Information corresponding to basic benefits of group life insurance plans, whose special characteristics differ from the characteristics described for the plans classified in the preceding subsections, will be reported. Record 14: Additional benefits: The totals of the information corresponding to the additional benefits of group life insurance plans will be reported. Record 15: Total life: For fields 2 to 13, the result of the sum of the values corresponding to records 1 and 8 will be reported. In the case of reports containing information on the branches of the accidents and illnesses operation: 10 records must be reported, as follows: Record 1: Personal accidents: The totals of the information corresponding to individual and collective personal accident insurance will be reported. Record 2: Individual: Information corresponding to individual personal accident insurance will be reported. Record 3: Collective: Information corresponding to collective personal accident insurance will be reported. Record 4: Medical expenses: The totals of the information corresponding to individual and collective medical expense insurance will be reported. Record 5: Individual: Information corresponding to individual medical expense insurance will be reported. Record 6: Collective: Information corresponding to collective medical expense insurance will be reported. Record 7: Health: The totals of the information corresponding to individual and collective health insurance will be reported. Record 8: Individual: Information corresponding to individual health insurance will be reported. Record 9: Collective: Information corresponding to collective health insurance will be reported. Record 10: Total accidents and illnesses: For fields 2 to 13, the result of the sum of the values corresponding to records 1, 4 and 7 will be reported. In the case of reports containing information on the branches of the damages operation: 13 records must be reported, as follows. Record 1: Civil liability and professional risks: Information corresponding to civil liability and professional risks insurance will be reported. Record 2: Marine and transport: Information corresponding to marine and transport insurance will be reported. Record 3: Fire: Information corresponding to fire insurance will be reported. Record 4: Agricultural and animal: Information corresponding to agricultural and animal insurance will be reported. Record 5: Automobiles: Information corresponding to automobile insurance will be reported. Record 6: Credit: Information corresponding to credit insurance will be reported. Record 7: Surety: Information corresponding to surety insurance will be reported. Record 8: Housing credit: Information corresponding to housing credit insurance will be reported. Record 9: Financial guarantee: Information corresponding to financial guarantee insurance will be reported. Record 10: Earthquake and/or volcanic eruption: Information corresponding to earthquake and/or volcanic eruption insurance will be reported. Record 11: Hurricane and other hydrometeorological: Information corresponding to hurricane and other hydrometeorological insurance will be reported. Record 12: Miscellaneous: Information corresponding to miscellaneous insurance will be reported. Record 13: Total damages: For fields 2 to 13, the result of the sum of the values corresponding to records 1 to 12 will be reported. b) Reports of "Recoverable reinsurance amounts from the life operation", "Recoverable reinsurance amounts corresponding to reinsurance taken from the life operation", "Recoverable reinsurance amounts from the accidents and illnesses operation", "Recoverable reinsurance amounts corresponding to reinsurance taken from the accidents and illnesses operation", "Recoverable reinsurance amounts from the damages operation" and "Recoverable reinsurance amounts corresponding to reinsurance taken from the damages operation". These reports must contain information regarding the recoverable reinsurance amounts corresponding to the outstanding obligations of life, accidents and illnesses, and damages operations, which is defined below and disaggregated according to the branches or types of insurance corresponding to each operation. Field 1: Branch or type of insurance.- Must report, in each record, the name of the corresponding branch or type of insurance, as indicated in the definition of records that follows this definition of fields. Example for the format corresponding to the Recoverable reinsurance amounts from the life operation. Field 1, in record 1, must contain the text: Individual Life Example for the format corresponding to the Recoverable reinsurance amounts from the accidents and illnesses operation. Field 1, in record 6, must contain the text: Collective Example for the format corresponding to the Recoverable reinsurance amounts from the damages operation. Field 1, in record 5, must contain the text: Automobiles Field 2: For reported claims of known amount.- Refers to the reserve constituted for outstanding obligations for reported claims whose amount of the obligation is known at the time of valuation and its balance is not required to be determined by an actuarial valuation. Field 3: Other obligations of known amount, except dividends.- Refers to the reserve constituted for other obligations of known amount, except for dividends, whose amount of the obligation is known at the time of valuation and its balance is not required to be determined by an actuarial valuation. Field 4.- Future obligations payable in installments: Refers to the reserve constituted for future obligations payable in installments which will correspond to the estimated amount of the present value of future payment flows, discounted using interest rate curves
free of market risk for each currency or monetary unit.
Field 5:
Total outstanding obligations for claims and other known amount obligations, except dividends.- Refers to the total outstanding obligations for claims and other known amount obligations, except dividends, (sum of fields 2, 3 and 4).
Field 6:
BEL- SONR and GAAS.- Refers to the best estimate of future obligations for outstanding obligations for claims that, having already occurred by the valuation date, have not yet been reported or have not been fully reported, as well as their adjustment expenses, salvages, and recoveries.
Field 7:
Outstanding obligations for administration of expired payments and benefits.- Refers to the reserve for outstanding obligations corresponding to the administration of sums that, by concept of dividends, endowments, annuities or other indemnities, are entrusted by policyholders or their beneficiaries to Insurance Institutions or Mutual Societies.
Field 8:
Amount of the OPC reserve.- Refers to the sum of the amounts of the reserves for outstanding obligations, indicated in fields 5, 6 and 7.
Regarding the number and description of records for each report, these will correspond to the records indicated in each of the operations previously reported for direct operation, that is:
i) Life operation: 15 records.
ii) Accident and health operation: 10 records.
iii) Property and casualty operation: 13 records.
c) Report of Responsible Parties
This report must contain 6 records, in each of which the following information must be reported for the official of the Insurance Institution or Mutual Society responsible for the valuation of the reserve for outstanding obligations, as well as for the actuaries who certify said valuations, for each of the operations. The submission of this report is mandatory.
Field 1:
Responsible Party.- For each record, it must be reported whether the requested information corresponds to the official responsible for the technical area or to the certifying actuary, according to the following:
| Record | Field 1 |
|---|---|
| 1 | Official responsible for the technical area |
| 2 | Certifying actuary 1 |
| 3 | Certifying actuary 2 |
| 4 | Certifying actuary 3 |
| 5 | Certifying actuary 4 |
| 6 | Certifying actuary 5 |
Field 2:
Name.- The name of the official or certifying actuary must be reported.
Field 3:
Position.- The position of the official or certifying actuary must be reported.
Field 4:
Telephone(s).- The contact telephone number(s) of the official or certifying actuary must be reported.
Field 5:
Email.- The email of the official or certifying actuary must be reported.
Field 6:
Operation or Insurance Line certified.- In the case of the certifying actuary(ies), the operation for which the reserve for outstanding obligations is being certified must be indicated.
In each record, the information reported in fields 2 to 6 must correspond to what is reported in field 1.
2.- The Excel file corresponding to the summary of the valuation of the reserve for outstanding obligations
The text files for the valuation of the reserve for outstanding obligations referred to in the immediately preceding numeral 1, must be generated using the Excel file corresponding to the summary of the valuation of the reserve for outstanding obligations, which will be available, along with its respective user manual, on the Commission's Website ( www.cnsf.gob.mx ) under the name " RR3OPCCVRES.xls ".
The Excel file corresponding to the summary of the valuation of the reserve for outstanding obligations, containing the information reported as defined in the immediately preceding numeral 1, must be sent as part of the RR3OPCCV product, for which it must be renamed as follows:
The name must consist of 24 alphanumeric characters that must be ordered as follows:
a) In the first eleven positions, the specific file identifier must be written: " RR3OPCCVRES ".
b) In the twelfth position, the company type code must be written.
| Code | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the thirteenth to the sixteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.
e) From the seventeenth to the twentieth positions, the year must be written.
f) In the twenty-first and twenty-second positions, the reported month must be written.
g) In the twenty-third and twenty-fourth positions, the last day of the reported month must be written.
Example:
Company code: " S "
Company number: " 0009 "
Day: " 30 "
Month: June ( " 06 " )
Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | O | P | C | C | V | R | E | S | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .XLS |
3.- Certification document(s) corresponding to the valuation of the reserve for outstanding obligations signed by the actuaries responsible for it
For each operation carried out by the Insurance Institution or Mutual Society (life, property and casualty, and accident and health), a certification letter in PDF format must be sent, corresponding to the valuation of the reserve for outstanding obligations, signed by the actuary or actuaries responsible for said valuation.
The PDF files for each operation must contain the name and electronic signature of the actuary or actuarial graduate responsible for the valuation, professional license number, number of the current certification issued by the professional college of the specialty or the accreditation of the Commission required for the preparation and signing of the valuation of technical reserves, in compliance with the provisions of article 226 of the LISF.
The name of the magnetic file in PDF format must consist of 26 alphanumeric characters that must be ordered as follows:
a) In the first eleven positions, the specific identifier of the file(s) must be written: " RR3OPCCVCER "
b) In the twelfth and thirteenth positions, the operation code must be written.
| Operation Code | Description |
|---|---|
| 01 | Life |
| 02 | Accident and health |
| 03 | Property and casualty |
c) In the fourteenth position, the company type code must be written.
| Code | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.
e) From the nineteenth to the twenty-second positions, the year must be written.
f) In the twenty-third and twenty-fourth positions, the reported month must be written.
g) In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
Certification document for property and casualty operation ( " 03 " ).
Company code: " S "
Company number: " 0009 "
Day: ( " 30 " )
Month: June ( " 06 " )
Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | Extension |
|---|
Company Number: " 0009 "
Day: " 31 "
Month: December ( " 12 " )
Year: 2013
Extension
R R 3 O P C D T T P S S 0 0 0 9 2 0 1 3 1 2 3 1 .XLS
4.- Explanatory documents of the procedure and results corresponding to the retrospective test (back-testing) of the reserve for outstanding obligations for incurred but not reported claims and adjustment expenses assigned to the claim
For each operation carried out by the Insurance Institution or Mutual Society in question, an explanatory document of the procedure and results corresponding to the retrospective test (back-testing) by which the adequate functioning of the actuarial methods used to determine the valuation of the reserve for outstanding obligations for incurred but not reported claims and adjustment expenses assigned to the claim was verified.
The document referred to in the previous paragraph shall be sent in PDF format and its name must consist of 26 alphanumeric characters, ordered as follows:
a) In the first eleven positions, the specific file identifier must be written: " RR3OPCDTPRE " .
b) In the twelfth and thirteenth positions, the operation code must be written.
| Operation Code | Description |
|---|---|
| 01 | Life |
| 02 | Accidents and illnesses |
| 03 | Damages |
c) In the fourteenth position, the company type code must be written.
| Code | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions.
d) From the nineteenth to the twenty-second positions, the year must be written.
e) In the twenty-third and twenty-fourth positions, the reported month must be written.
f) In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
Retrospective test report of the reserve for incurred and not reported claims for damages operation ( " 03 " )
Company Code: " S "
Company Number: " 0009 "
Day: ( " 31 " )
Month: December ( " 12 " )
Year: 2013
Extension
R R 3 O P C D T P R E 0 3 S 0 0 0 9 2 0 1 3 1 2 3 1 .PDF
III. Catastrophic risk reserve
Information with quarterly delivery frequency
The report of the valuation results of the catastrophic risk reserve for each branch or type of insurance, with quarterly delivery frequency, shall consist of the following:
The product RR3CATCV, which will contain the text file with the summary of the catastrophic risk reserve valuation, the Excel format file corresponding to the summary of the catastrophic risk reserve valuation, and the corresponding certification document signed by the actuaries responsible for it, referred to in the immediately following numerals 1.1, 1.2 and 1.3.
a) For its submission, the product must be encrypted in a single .ZIP.PGP format file, whose name must consist of 21 alphanumeric characters, ordered as follows:
b) In the first eight positions, the specific product identifier must be written: " RR3CATCV " .
c) In the ninth position, the company type code must be written:
| Code | Definition |
|---|---|
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the tenth to the thirteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions.
e) From the fourteenth to the seventeenth positions, the year must be written.
f) In the eighteenth and nineteenth positions, the reported month must be written. This number must be preceded by zeros until it occupies both positions.
g) In the twentieth and twenty-first positions, the last day of the reported month must be indicated.
Example:
Company Code: " S "
Company Number: " 0009 "
Day: ( " 30 " )
Month: June ( " 06 " )
Year: 2013
Extension
R R 3 C A T C V S 0 0 0 9 2 0 1 3 0 6 3 0 .ZIP
.PGP
1.1.- Summary of the catastrophic risk reserve valuation
From 2 to 14 reports in text file format, of the valuation results for each branch or type of insurance, whose name must consist of 26 alphanumeric characters, which must be ordered as follows:
a) In the first eleven positions, the specific file identifier must be written: " RR3CATCVRES " .
b) In the twelfth and thirteenth positions, the report code must be written.
| Report Code | Description |
|---|---|
| 01 | Catastrophic risk reserve for earthquake insurance |
| 02 | Maximum accumulation limit of the catastrophic risk reserve for earthquake insurance |
| 03 | Catastrophic risk reserve for hurricane and other hydrometeorological risks insurance |
| 04 | Maximum accumulation limit of the catastrophic risk reserve for hurricane and other hydrometeorological risks insurance |
| 05 | Catastrophic risk reserve for agricultural and animal insurance |
| 06 | Maximum accumulation limit of the catastrophic risk reserve for agricultural and animal insurance |
| 07 | Catastrophic risk reserve for housing credit insurance |
| 08 | Catastrophic risk reserve for financial guarantee insurance |
| 09 | Maximum accumulation limit of the catastrophic risk reserve for financial guarantee insurance |
| 10 | Catastrophic risk reserve for credit insurance |
| 11 | Maximum accumulation limit of the catastrophic risk reserve for credit insurance |
| 12 | Catastrophic risk reserve for surety insurance |
| 13 | Maximum accumulation limit of the catastrophic risk reserve for surety insurance |
| 14 | Responsible parties |
c) In the fourteenth position, the company type code must be written.
| Code | Definition |
|---|---|
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions.
e) From the nineteenth to the twenty-second positions, the year must be written.
f) In the twenty-third and twenty-fourth positions, the reported month must be written.
g) In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
Report: 01
Company Code: " S "
Company Number: " 0009 "
Day: ( " 30 " )
Month: June ( " 06 " )
Year: 2015
Ext.
R R 3 C A T C V R E S 0 1 S 0 0 0 9 2 0 1 5 0 6 3 0 TXT
Each of the catastrophic risk reserve valuation results reports shall contain the fields described below for each of them, which must be reported in a matrix array where each listed field must be delimited by the character known as pipe ( " | " ) to the left and right of each field, except for the first and last of these, in which case they must only be delimited by pipes to the right and left, respectively. Each record shall correspond to the detailed information by branch or type of insurance, according to each operation.
The number of fields and records will be fixed and will depend on each report, so, when a field is not applicable in a given report, it must be left empty.
Figures must be reported in national currency at the exchange rate corresponding to the currency or monetary unit in question, on the valuation date. For these purposes, the exchange rate value of the index or currency in question, published in the Official Gazette of the Federation on the valuation date, must be used.
a) Report on " Catastrophic risk reserve for earthquake insurance "
The report must contain 13 records, filled in according to the following:
Field 1: Year.- The first record must contain the number of the year corresponding to the immediate previous closing to the reported year; from record 2 to 13, they must contain the number of the reported year.
Field 2: Month.- Each record must contain the corresponding text according to the following relationship:
| Record | Content |
|---|---|
| 1 | Dec |
| 2 | Jan |
| 3 | Feb |
| 4 | Mar |
| 5 | Apr |
| 6 | May |
| 7 | Jun |
| 8 | Jul |
| 9 | Aug |
| 10 | Sep |
| 11 | Oct |
| 12 | Nov |
| 13 | Dec |
Field 3: Retained risk premium for the month.- This field must be filled only for records 2 to 13, and refers to the total amount determined as the sum of the retained risk premiums of the policies, certificates or endorsements that were in force during the month in question for earthquake insurance. It shall be understood that the retained risk premium is that corresponding to each policy, certificate or endorsement, according to the calculation made with the computer system used to determine the risk premium for the constitution of the in-force risk reserve, as well as the Probable Maximum Loss.
Field 4: Accrued retained risk premium for the month.- This field must be filled only for records 2 to 13, and refers to the total amount of the accrued portion of the retained risk premium of the policies, certificates or endorsements that were in force during the month in question for earthquake insurance.
Field 5: Financial products for the month.- This field must be filled only for records 2 to 13, and refers to the amount of financial products of this reserve, determined based on the average monthly effective rate of the issues for the month in question, of the 28-day Federal Treasury Certificates.
Field 6: Impact on the catastrophic earthquake risk reserve.- This field must be filled only for records 2 to 13, and corresponds to the total amount by which the catastrophic earthquake risk reserve has been affected during the month, in case the assumptions considered in Section V of Provision 5.6.6. of the CUSF were met.
Field 7: Reserve balance at month-end.- Refers to the amount of the catastrophic earthquake risk reserve, at the end of the month in question.
In each record, the information reported in fields 3 to 7 must correspond to the year and month reported in fields 1 and 2 respectively.
b) Report on " Maximum accumulation limit of the catastrophic risk reserve for earthquake insurance "
The report must contain 7 records, filled in according to the following:
Field 1: Year.- Records 1 to 5 of this field must contain the number of the year to which the amount of the probable maximum loss of retention (PML) reported in each of these records corresponds. It should be noted that, in each report, the records must present information corresponding to the last 5 years. Record 6 of this field must contain the legend " Average " , while record 7 of this field must contain the legend " Maximum accumulation limit " .
Example. For the close of fiscal year 2015
| Record | Content |
|---|---|
| 1 | 2011 |
| 2 | 2012 |
| 3 | 2013 |
| 4 | 2014 |
| 5 | 2015 |
| 6 | Average |
| 7 | Maximum accumulation limit |
Field 2.- : Total insured sum (TOTAL SA):.- Must be filled only in records 1 to 5, and refers to the total amount of insured sums of earthquake insurance policies that, having been issued at some point, were in force on December 31 of the year to which the record in question corresponds.
Field 3.- : Retained insured sum (RETAINED SA):.- Must be filled only in records 1 to 5, and refers to the retained amount of insured sums of earthquake insurance policies that, having been issued at some point, were in force on December 31 of the year to which the record in question corresponds.
Field 4: Gross probable maximum loss (Gross PML) .- In records 1 to 5, it must be filled with the amount of the gross probable maximum loss, calculated, for the year to which the record in question corresponds, in accordance with the corresponding technical bases.
Field 5: Probable maximum loss of retention (Retention PML) .- In records 1 to 5, it must be filled with the amount of the probable maximum loss of retention, calculated, for the year to which the record in question corresponds, in accordance with the corresponding technical bases. For record 6, with the average value of the amounts reported in records 1 to 5 of this field. For record 7, with the result of multiplying by 0.9, the amount reported in record 6 of this field.
In each record, the information reported in fields 2 to 5 must correspond to what is reported in field 1.
c) Report on " Catastrophic risk reserve for hurricane and other hydrometeorological risks insurance "
The report must contain 13 records, filled in according to the following:
Field 1: Year.- The first record must contain the number of the year corresponding to the immediate previous closing to the reported year; from record 2 to 13, they must contain the number of the reported year.
Field 2: Month.- Each record must contain the corresponding text according to the following relationship:
| Record | Content |
|---|---|
| 1 | Dec |
| 2 | Jan |
| 3 | Feb |
| 4 | Mar |
| 5 | Apr |
| 6 | May |
| 7 | Jun |
| 8 | Jul |
| 9 | Aug |
| 10 | Sep |
| 11 | Oct |
| 12 | Nov |
| 13 | Dec |
Field 3: Retained risk premium for the month.- This field must be filled only for records 2 to 13, and refers to the total amount determined as the sum of the retained risk premiums of the policies, certificates or endorsements that were in force during the month in question for hurricane and other hydrometeorological risks insurance. It shall be understood that the retained risk premium is that corresponding to each policy, certificate or endorsement, according to the calculation made with the computer system used to determine the risk premium for the constitution of the in-force risk reserve, as well as the Probable Maximum Loss.
Field 4: Accrued retained risk premium for the month.- This field must be filled only for records 2 to 13, and refers to the total amount of the accrued portion of the retained risk premium of the policies, certificates or endorsements that were in force during the month in question for hurricane and other hydrometeorological risks insurance.
Field 5: Financial products for the month:.- This field must be filled only for records 2 to 13, and refers to the amount of financial products of this reserve, determined based on the average monthly effective rate of the issues for the month in question, of the 28-day Federal Treasury Certificates.
Field 6: Impact on the catastrophic hurricane and other hydrometeorological risks reserve.- This
in force as of December 31 of the year to which the record in question corresponds.
Field 4:
Gross probable maximum loss (Gross PML) .- Must be filled only in records 1 to 5, and refers to the amount of the gross probable maximum loss, calculated, for the year to which the record in question corresponds, in accordance with the corresponding technical bases.
Field 5.-
Retained probable maximum loss (Retained PML): Must be filled, for each record from 1 to 5, with the amount of the retained probable maximum loss, calculated, for the year to which the record in question corresponds, in accordance with the corresponding technical bases. Record 6 must contain the average of the values reported in records 1 to 5 of this same field (field 5).
g) Report on "Catastrophic risk reserve for housing credit insurance"
The report must contain 13 records, filled in according to the following:
Field 1:
Year.- The first record must contain the number of the year corresponding to the immediate previous closing to the reported year; from record 2 to 13, they must contain the number of the reported year.
Field 2:
Month.- Each record must contain the corresponding text according to the following relationship:
| Record | Content |
|---|---|
| 1 | Dec |
| 2 | Jan |
| 3 | Feb |
| 4 | Mar |
| 5 | Apr |
| 6 | May |
| 7 | Jun |
| 8 | Jul |
| 9 | Aug |
| 10 | Sep |
| 11 | Oct |
| 12 | Nov |
| 13 | Dec |
Field 3:
Release of in-force retained risk reserve.- This field must be filled only for records 2 to 13, and refers to the amount released from the in-force retained risk reserve of policies, certificates or endorsements that were in force during the month in question for housing credit insurance.
Field 4:
50% of the release of in-force retained risk reserve.- Must be filled, for each record from 2 to 13, with the product of the release of the in-force retained risk reserve, indicated in field 3, multiplied by 0.5.
Field 5:
Monthly financial products.- This field must be filled only for records 2 to 13, and refers to the amount of financial products of this reserve, determined based on the average monthly effective rate of the emissions of the month in question, of the 28-day Federal Treasury Certificates.
Field 6:
Impact on the catastrophic risk reserve for housing credit insurance.- This field must be filled only for records 2 to 13, and corresponds to the total amount by which the catastrophic risk reserve for housing credit insurance has been affected during the month, in case the assumptions considered in Section III of Disposition 5.6.3. of the CUSF occurred.
Field 7:
Amount of contribution release.- This field must be filled only for records 2 to 13, and corresponds to the amount released from contributions to the catastrophic risk reserve for housing credit insurance, in case the assumptions considered in Section IV of Disposition 5.6.3. of the CUSF occurred.
Field 8:
PML.- Refers to the amount of the Probable Maximum Loss that has been calculated for housing credit insurance, at the close of the month in question.
Field 9:
Reserve balance at month-end.- Refers to the amount of the catastrophic risk reserve for housing credit insurance, at the close of the month in question.
In each record, the information reported in fields 3 to 9 must correspond to the year and month reported in fields 1 and 2 respectively.
h) Report on "Catastrophic risk reserve for financial guarantee insurance"
The report must contain 25 records, filled in according to the following:
Field 1:
Concept.- Each record must contain the corresponding text according to the following relationship:
Field 2:
Quarter.- Each record must contain the corresponding text according to the following relationship:
Field 3:
Required reserve amount.- This field must be filled only for records in which the value of the "Quarter" field is different from "4th Qtr previous year", and must correspond to the resulting limit of the Catastrophic Risk Reserve for financial guarantee insurance, for each type of insurable issuance (Government Bonds, Asset-Backed Securities, Guaranteed Securities with Collateral backing or with a maturity period of 7 years or less, and Guaranteed Securities without Collateral backing and with a maturity period greater than 7 years), at the close of the quarter in question.
Field 4:
Contribution.- This field must be filled only for records in which the value of the "Quarter" field is different from "4th Qtr previous year", and must correspond to the amount resulting from applying to the required reserve amount for each type of insurable issuance, the corresponding percentage, according to each of the types of insurable issuances, which, in accordance with Section II of Disposition 5.6.4. of the CUSF, will be 1.25% for Government Bonds, and 1.67% for Asset-Backed Securities, Guaranteed Securities with Collateral backing or with a maturity period of 7 years or less, and for Guaranteed Securities without Collateral backing and with a maturity period greater than 7 years.
Field 5:
Financial products.- This field must be filled only for records in which the value of the "Quarter" field is different from "4th Qtr previous year", and must correspond to the amount of the financial product for each type of insurable issuance (Government Bonds, Asset-Backed Securities, Guaranteed Securities with Collateral backing or with a maturity period of 7 years or less, and Guaranteed Securities without Collateral backing and with a maturity period greater than 7 years), calculated based on the average monthly effective rate of the emissions of the month in question, of the 28-day Federal Treasury Certificates.
Field 6:
Impact on the catastrophic risk reserve for financial guarantee insurance.- This field must be filled only for records in which the value of the "Quarter" field is different from "4th Qtr previous year", and must correspond to the amount of impact for each type of insurable issuance (Government Bonds, Asset-Backed Securities, Guaranteed Securities with Collateral backing or with a maturity period of 7 years or less, and Guaranteed Securities without Collateral backing and with a maturity period greater than 7 years), in case the assumptions considered in Section IV of Disposition 5.6.4. of the CUSF occurred.
Field 7:
Reserve balance at quarter-end.- Refers to the amount of the catastrophic risk reserve for financial guarantee insurance, at the close of the quarter in question.
In each record, the information reported in fields 3 to 7 must correspond to the year and quarter reported in fields 1 and 2 respectively.
i) Report on "Maximum accumulation limit of the catastrophic risk reserve for financial guarantee insurance"
The report must contain 4 records, filled in according to the following:
Field 1:
Categories.- Each record must contain the corresponding text according to the following relationship:
Field 2:
Premiums issued for in-force policies.- Refers to the amount of premiums for policies that, having been issued at some point, are in force at the close of the quarter in question, for insurance backing each type of insurable issuance of Government Bonds, Asset-Backed Securities, Guaranteed Securities with Collateral backing or with a maturity period of 7 years or less, and for Guaranteed Securities without Collateral backing and with a maturity period greater than 7 years, as corresponds to the category indicated in the reported record.
Field 3:
Company retention percentage.- The retention percentage that must be included during the four quarters of the reported year must be that resulting from dividing the retained premium of the five immediate previous fiscal years to the reporting year, by the premium issued in those fiscal years, for each type of insurable issuance, as corresponds to the category indicated in the reported record.
Field 4:
Sum insured for in-force policies.- Is the total amount of the sums insured for policies that, having been issued at some point, are in force at the close of the quarter in question.
Field 5:
Retained sum insured for in-force policies.- Is the retained amount of the sums insured for policies that, having been issued at some point, are in force at the close of the quarter in question, for each type of insurable issuance, as corresponds to the category indicated in the reported record.
Field 6:
Amount of collaterals.- Refers to the amount of collaterals for policies that, having been issued at some point, are in force at the close of the quarter in question, for each type of insurable issuance, as corresponds to the category indicated in the reported record.
Field 7:
Market retention percentage.- Is the retention percentage resulting from dividing the market retained premium of the five immediate previous fiscal years to the reporting year, by the market issued premium in those fiscal years, for each type of insurable issuance, as corresponds to the category indicated in the reported record. This factor is determined annually and published by the National Commission of Insurance and Bonds.
Field 8:
Maximum limit of the Catastrophic Risk Reserve.- Is the limit that the catastrophic risk reserve for financial guarantee insurance must have, at the close of the quarter in question, for each type of insurable issuance, as corresponds to the category indicated in the reported record, determined in accordance with the provisions of Section I of Disposition 5.6.4. of the CUSF.
In each record, the information reported in fields 2 to 8 must correspond to the category reported in field 1.
j) Report on "Catastrophic risk reserve for credit insurance"
The report must contain 13 records, filled in according to the following:
Field 1: Year.-
The first record must contain the number of the year corresponding to the immediate previous closing to the reported year; while records 2 to 13 must contain the number of the reported year.
Field 2: Month.-
Each record must contain the corresponding text according to the following relationship:
| Record | Content |
|---|---|
| 1 | Dec |
| 2 | Jan |
| 3 | Feb |
| 4 | Mar |
| 5 | Apr |
| 6 | May |
| 7 | Jun |
| 8 | Jul |
| 9 | Aug |
| 10 | Sep |
| 11 | Oct |
| 12 | Nov |
| 13 | Dec |
Field 3:
Earned retained risk premium at year-end.- This field must be filled only for record 13, and its value must correspond to the amount of the earned retained risk premium of policies issued during the fiscal year, integrated by the sum of the earned retained risk premium of each of the policies, certificates, or endorsements issued.
Field 4:
by the professional college of the specialty or the accreditation of the Commission required for the preparation and signing of the technical reserve valuation, in compliance with the provisions of Article 216 of the LISF.The name of the magnetic file in PDF format must consist of 24 alphanumeric characters that must be ordered as follows:a) In the first eleven positions, the specific identifier of the file(s) must be written: " RR3CATCVCER "b) In the twelfth position, the company type code must be written.| Code | Definition ||---|---|| G | Insurance Institutions authorized to operate financial guarantee insurance. || V | Insurance Institutions authorized to operate housing loan insurance. || S | Other Insurance Institutions and Mutual Societies. |c) From the thirteenth to the sixteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.d) From the seventeenth to the twentieth positions, the year must be written.e) In the twenty-first and twenty-second positions, the reporting month must be written. This number must be preceded by zeros until it occupies both positions.f) In the twenty-third and twenty-fourth positions, the last day of the reporting month must be written.Example:Company Code: " S "Company Number: " 0009 "Day: ( " 30 " )Month: June ( " 06 " )Year: 20131 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 ExtensionR R 3 C A T C V C E R S 0 0 0 9 2 0 1 3 0 6 3 0 .PDF2. The RR3CATDT product, which will contain the Excel files corresponding to the results of catastrophic risk insurance, the databases for the valuation of the catastrophic risk reserve for earthquake and/or volcanic eruption insurance, and the databases for the valuation of the catastrophic risk reserve for hurricane and other hydrometeorological risk insurance in Access format, referred to in the immediately following numerals 2.1, 2.2, and 2.3. This product must be sent and encrypted in a single file in .ZIP.PGP format, whose name must consist of 21 alphanumeric characters, ordered as follows:a) In the first eight positions, the specific product identifier must be written: " RR3CATDT " .b) In the ninth position, the company type code must be written:| Code | Definition ||---|---|| G | Insurance Institutions authorized to operate financial guarantee insurance. || V | Insurance Institutions authorized to operate housing loan insurance. || S | Other Insurance Institutions and Mutual Societies. |c) From the tenth to the thirteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.d) From the fourteenth to the seventeenth positions, the year must be written.e) In the eighteenth and nineteenth positions, the reporting month must be written.f) In the twentieth and twenty-first positions, the day of the reporting month must be indicated.Example:Company Code: " S "Company Number: " 0009 "Day: ( " 30 " )Month: June ( " 06 " )Year: 20131 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 ExtensionR R 3 C A T D T S 0 0 0 9 2 0 1 3 0 6 3 0 .ZIP .PGP2.1 Excel files corresponding to catastrophic risk insurance resultsUp to 7 Excel files containing the results of catastrophic risk insurance by line or type of insurance.In the case of Excel file(s) containing the results of catastrophic risk insurance corresponding to earthquake and/or volcanic eruption insurance; and hurricane and other hydrometeorological risk insurance, the files generated by the computer systems " Sistema R " and " Sistema RH-MEX " , respectively, must be sent as such; for other cases, until general application computer systems are made known, the files generated by the Insurance Institution or Mutual Society itself must be sent.The name of the Excel file(s) containing the results of catastrophic risk insurance, depending on the line or type of insurance, consists of 24 alphanumeric characters structured as follows:a) In the first eight positions, the specific identifier of the file in Excel format must be written: " RR3CATDT " .b) From the ninth to the eleventh positions, the code for the operation, line, or type of insurance must be written according to the following catalog:| Code | Definition ||---|---|| TER | Earthquake and/or volcanic eruption insurance. || HID | Hurricane and other hydrometeorological risk insurance. || AYA | Agricultural and animal insurance. || CRE | Credit line insurance. || CAU | Surety line insurance. || CRV | Housing loan insurance line || GRF | Financial guarantee insurance line |c) In the twelfth position, the company type code must be written:| Code | Definition ||---|---|| G | Insurance Institutions authorized to operate financial guarantee insurance. || V | Insurance Institutions authorized to operate housing loan insurance. || S | Other Insurance Institutions and Mutual Societies. |d) From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.e) From the nineteenth to the twenty-second positions, the year must be written.f) In the twenty-third and twenty-fourth positions, the reporting month must be written. This number must be preceded by zeros until it occupies both positions.g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written.Example:Results of the valuation of the catastrophic risk reserve for earthquake and/or volcanic eruption insurance ( " TER " ).Company Code: " S "Company Number: " 0009 "Day: ( " 30 " )Month: June ( " 06 " )Year: 20131 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 ExtensionR R 3 C A T D T T E R S 0 0 0 9 2 0 1 3 0 6 3 0 .XLS2.2- Databases for the valuation of the catastrophic risk reserve for earthquake and/or volcanic eruption insurance.Up to 3 database files for determining the risk premium and the Probable Maximum Loss for earthquake insurance.The Access file containing the databases for the valuation of the catastrophic risk reserve for earthquake and/or volcanic eruption insurance, whose name consists of 26 alphanumeric characters structured as follows:a) In the first eleven positions, the specific identifier of the file in Access format must be written: " RR3CATDTTER " .b) In the twelfth and thirteenth positions, the database code must be written.| Database Code | Description ||---|---|| 01 | Independent || 02 | Collective || 03 | Non-valuable |c) In the fourteenth position, the company type code must be written:| Code | Definition ||---|---|| S | Other Insurance Institutions and Mutual Societies. |d) From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.e) From the nineteenth to the twenty-second positions, the year must be written.f) In the twenty-third and twenty-fourth positions, the reporting month must be written.g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written.Example:Databases for the valuation of the catastrophic risk reserve for earthquake and/or volcanic eruption insurance ( " TER " ); non-valuable ( " 03 " ).Company Code: " S "Company Number: " 0009 "Day: ( " 30 " )Month: June ( " 06 " )Year: 20131 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 ExtensionR R 3 C A T D T T E R 0 3 S 0 0 0 9 2 0 1 3 0 6 3 0 .MDB2.3- Databases for the valuation of the catastrophic risk reserve for hurricane and other hydrometeorological risk insuranceUp to 3 database files for determining the risk premium and the Probable Maximum Loss for hurricane and other hydrometeorological risk insurance.The Access file containing the databases for the valuation of the catastrophic risk reserve for hurricane and other hydrometeorological risk insurance, whose name consists of 26 alphanumeric characters structured as follows:a) In the first eleven positions, the specific identifier of the file in Access format must be written: " RR3CATDTHID " .b) In the twelfth and thirteenth positions, the database code must be written.| Database Code | Description ||---|---|| 01 | Independent || 02 | Collective || 03 | Non-valuable |c) In the fourteenth position, the company type code must be written:| Code | Definition ||---|---|| S | Other Insurance Institutions and Mutual Societies. |d) From the fifteenth to the eighteenth positions, the number assigned to the respective Insurance Institution or Mutual Society must be written. This number must be preceded by zeros until it occupies all four positions.e) From the nineteenth to the twenty-second positions, the year must be written.f) In the twenty-third and twenty-fourth positions, the reporting month must be written.g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written.Example:Databases for the valuation of the catastrophic risk reserve for hurricane and other hydrometeorological risk insurance ( " HID " ); non-valuable ( " 03 " ).Company Code: " S "Company Number: " 0009 "Day: ( " 30 " )Month: June ( "
in force issued by the professional college of the specialty or the accreditation of the Commission required for the preparation and signing of the valuation of technical reserves, in compliance with the provisions of article 216 of the LISF. The name of the magnetic file in PDF format must consist of 26 alphanumeric characters that must be ordered as follows: a) In the first eleven positions, the specific identifier of the file(s) must be written: " RR3CNTCVCER " b) In the twelfth and thirteenth positions, the certification key must be written.
| Certification Key | Description |
|---|---|
| 01 | Life |
| 02 | Accidents and illnesses |
| 03 | Damages |
c) In the fourteenth position, the company type key must be written.
| Key | Definition |
|---|---|
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions. e) From the nineteenth to the twenty-second positions, the year must be written. f) In the twenty-third and twenty-fourth positions, the reporting month must be written. g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written.
Example: Company Key: " S " Company Number: " 0056 " Day: ( " 30 " ) Month: June ( " 06 " ) Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | C | N | T | C | V | C | E | R | 0 | 3 | S | 0 | 0 | 5 | 6 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 |
INFORMATION WITH ANNUAL DELIVERY PERIODICITY The information on the valuation of the contingency reserve for each branch or type of insurance, with annual delivery periodicity, will consist of the following: The RR3CNTDT product, which will contain the files with the explanatory documents of the methodological detail of the contingency reserve valuation, in PDF format, as well as the Excel files corresponding to the aforementioned methodological detail, referred to in the immediately following numerals 1 and 2. Said product must be sent and encrypted in a .ZIP.PGP format file, whose name must consist of 21 alphanumeric characters, ordered as follows: a) In the first eight positions, the specific product identifier must be written: " RR3CNTDT " b) In the ninth position, the company type key must be written:
| Key | Definition |
|---|---|
| S | Other Insurance Institutions and Mutual Societies. |
c) From the tenth to the thirteenth positions, the number assigned to the Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions. d) From the fourteenth to the seventeenth positions, the year must be written. e) In the eighteenth and nineteenth positions, the reporting month must be written. f) In the twentieth and twenty-first positions, the reporting day of the month must be indicated.
Example: Company Key: " S " Company Number: " 0056 " Day: ( " 31 " ) Month: December ( " 12 " ) Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | C | N | T | D | T | S | 0 | 0 | 5 | 6 | 2 | 0 | 1 | 3 | 1 | 2 | 3 | 1 | .ZIP.PGP |
1 Files with explanatory documents of the methodological detail of the contingency reserve valuation Explanatory document of the development, hypotheses, and results of the application of the methods to obtain the PML for each branch or type of insurance will be sent in PDF format and its name must consist of 26 alphanumeric characters, ordered as follows: a) In the first eleven positions, the specific file identifier must be written: " RR3CNTDTPML " b) In the twelfth and thirteenth positions, the report key must be written.
| Report Key | Branch |
|---|---|
| 01 | Life |
| 02 | Personal accidents |
| 03 | Medical expenses |
| 04 | Marine and transport |
| 05 | Fire |
| 06 | Automobiles |
| 07 | Miscellaneous |
c) In the fourteenth position, the company type key must be written.
| Key | Definition |
|---|---|
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions. e) From the nineteenth to the twenty-second positions, the year must be written. f) In the twenty-third and twenty-fourth positions, the reporting month must be written. g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written.
Example: Report: 06 (Automobiles) Company Key: " S " Company Number: " 0056 " Day: ( " 31 " ) Month: December ( " 12 " ) Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | C | N | T | D | T | P | M | L | 0 | 6 | S | 0 | 0 | 5 | 6 | 2 | 0 | 1 | 3 | 1 | 2 | 3 | 1 |
2.- Excel files corresponding to the methodological detail of the contingency reserve valuation Summary of the determination of the probable maximum loss for mutual societies in Excel format, whose names must consist of 26 alphanumeric characters, which must be ordered as follows: a) In the first eleven positions, the specific file identifier must be written: " RR3CNTDTPML " b) In the twelfth and thirteenth positions, the report key must be written.
| Report Key | Branch |
|---|---|
| 01 | Life |
| 02 | Personal accidents |
| 03 | Medical expenses |
| 04 | Marine and transport |
| 05 | Fire |
| 06 | Automobiles |
| 07 | Miscellaneous |
c) In the fourteenth position, the company type key must be written.
| Key | Definition |
|---|---|
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions. e) From the nineteenth to the twenty-second positions, the year must be written. f) In the twenty-third and twenty-fourth positions, the reporting month must be written. g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written.
Example: Report: 06 (Automobiles) Company Key: " S " Company Number: " 0056 " Day: ( " 31 " ) Month: December ( " 12 " ) Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | C | N | T | D | T | P | M | L | 0 | 6 | S | 0 | 0 | 5 | 6 | 2 | 0 | 1 | 3 | 1 | 2 | 3 | 1 | .XLS |
V.- Special technical reserve for the use of experimental rates Information with quarterly delivery periodicity The valuation of the special technical reserve for the use of experimental rates for each branch or type of insurance, with quarterly delivery periodicity, will consist of the following: The RR3ESPCV product, which will contain the text files of the valuation of the special technical reserve for the use of experimental rates, the Excel format file corresponding to the summary of the valuation of the special technical reserve for the use of experimental rates, and the corresponding certification document signed by the responsible actuary, referred to in the immediately following numerals 1, 2 and 3. Said product must be sent and encrypted as follows: a) For its submission, the product must be encrypted in a single file in .ZIP.PGP format, whose name must consist of 21 alphanumeric characters, ordered as follows: b) In the first eight positions, the specific product identifier must be written: " RR3ESPCV " . c) In the ninth position, the company type key must be written:
| Key | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the tenth to the thirteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions. e) From the fourteenth to the seventeenth positions, the year must be written. f) In the eighteenth and nineteenth positions, the reporting month must be written. g) In the twentieth and twenty-first positions, the last day of the reporting month must be indicated.
Example: Company Key: " S " Company Number: " 0009 " Day: ( " 30 " ) Month: June ( " 06 " ) Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | E | S | P | C | V | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 1 | 2 | 3 | 1 | .ZIP.PGP |
1.- Valuation of the special technical reserve for the use of experimental rates 2 reports in text file format, of the results of the valuation of each branch or type of insurance, whose names must consist of 26 alphanumeric characters that must be ordered as follows: a) In the first eleven positions, the specific file identifier must be written: " RR3ESPCVRES " . b) In the twelfth and thirteenth positions, the report key must be written.
| Report Key | Description |
|---|---|
| 01 | Special reserve for the use of experimental rates |
| 02 | Responsible parties |
c) In the fourteenth position, the company type key must be written.
| Key | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the society in question must be written. This number must be preceded by zeros until it occupies all four positions. e) From the nineteenth to the twenty-second positions, the year must be written. f) In the twenty-third and twenty-fourth positions, the reporting month must be written. g) In the twenty-fifth and twenty-sixth positions, the last day of the month being reported must be written.
Example: Report: 1 Company Key: " S " Company Number: " 0001 " Day: ( " 30 " ) Month: June ( " 06 " ) Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | E | S | P | C | V | R | E | S | 0 | 1 | S | 0 | 0 | 0 | 1 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .TXT |
The reports of results of the valuation of the special technical reserve for the use of experimental rates will contain the fields described below, which must be reported in a matrix arrangement where each listed field must be delimited by the character known as a pipe ( " | " ) to the left and right of each field, except for the first and last of these, in which case they must only be delimited by pipes to the right and left, respectively. The number of fields and records will be fixed, so when a field is not applicable in a given report, it must be left empty. Figures must be reported in national currency at the exchange rate corresponding to the currency or monetary unit in question, on the valuation date. For these purposes, the exchange rate value of the index or currency in question, published in the Official Gazette of the Federation on the valuation date, must be used. a) Reports of " Special technical reserve for the use of experimental rates " This report must contain 169 records with the following information regarding the special technical reserve for the use of experimental rates.
Field 1: Branch.- Must report in each record the corresponding branch or type of insurance according to each operation, as indicated below.
| Records | Field 1 |
|---|---|
| 1 to 13 | Life |
| 14 to 26 | Personal accidents |
| 27 to 39 | Medical expenses |
| 40 to 52 | Civil liability and professional risks |
| 53 to 65 | Marine and transport |
| 66 to 78 | Fire |
| 79 to 91 | Agricultural and animal |
| 92 to 104 | Automobiles |
| 105 to 117 | Credit |
| 118 to 130 | Surety |
| 131 to 143 | Housing credit |
| 144 to 156 | Financial guarantee |
| 157 to 169 | Miscellaneous |
Field 2: Year.- Must report: For records 1, 14, 27, 40, 53, 66, 79, 92, 105, 118, 131, 144 and 157, the year immediately prior to the reporting period; For records other than 1, 14, 27, 40, 53, 66, 79, 92, 105, 118, 131, 144 and 157, the year of the reporting period must be entered.
Field 3: Month.- Consecutively, for records 1 to 13, 14 to 26, 27 to 39, 40 to 52, 53 to 65, 66 to 78, 79 to 91, 92 to 104, 105 to 117, 118 to 130, 131 to 143, 144 to 156 and 157 to 169, the month to which the reported information corresponds must be reported, as shown below:
| Range Record | Field 3 |
|---|---|
| 1 | Dec |
| 2 | Jan |
| 3 | Feb |
| 4 | Mar |
| 5 | Apr |
| 6 | May |
| 7 | Jun |
| 8 | Jul |
| 9 | Aug |
| 10 | Sep |
| 11 | Oct |
| 12 | Nov |
| 13 | Dec |
In this sense, as an example, for the close of the 2015 fiscal year, fields 1, 2 and 3, for records 92 to 117 must present the following content.
| Rec. | Field 1 | Field 2 | Field 3 |
|---|---|---|---|
| ... | ... | ... | ... |
| 92 | Automobiles | 2014 | Dec |
| 93 | Automobiles | 2015 | Jan |
| 94 | Automobiles | 2015 | Feb |
| 95 | Automobiles | 2015 | Mar |
| 96 | Automobiles | 2015 | Apr |
| 97 | Automobiles | 2015 | May |
| 98 | Automobiles | 2015 | Jun |
| 99 | Automobiles | 2015 | Jul |
| 100 | Automobiles | 2015 | Aug |
| 101 | Automobiles | 2015 | Sep |
| 102 | Automobiles | 2015 | Oct |
| 103 | Automobiles | 2015 | Nov |
| 104 | Automobiles | 2015 | Dec |
| 105 | Credit | 2014 | Dec |
| 106 | Credit | 2015 | Jan |
| 107 | Credit | 2015 | Feb |
| 108 | Credit | 2015 | Mar |
| 109 | Credit | 2015 | Apr |
| 110 | Credit | 2015 | May |
| 111 | Credit | 2015 | Jun |
| 112 | Credit | 2015 | Jul |
| 113 | Credit | 2015 | Aug |
| 114 | Credit | 2015 | Sep |
| 115 | Credit | 2015 | Oct |
| 116 | Credit | 2015 | Nov |
| 117 | Credit | 2015 | Dec |
| ... | ... | ... | ... |
Field 4: Accrued retained risk premiums.- Must correspond to the amount of the accrued retained risk premium from policies issued, comprising the sum of the accrued retained risk premium from each of the policies, certificates, or endorsements issued.
Field 5: Retained claims at year-end.- The amount of retained claims recorded at the close of the respective fiscal year (including adjustments) must be reported.
Field 6: Financial products for the month.- This is the amount of financial products generated during the month by the investment of the reserve.
Field 7: Impact on the reserve.- This is the total amount by which the special technical reserve for the use of experimental rates has been impacted at the close of the fiscal year for the month at the close of the month.
Field 7: Reserve balance at month-end.- This is the amount of the special technical reserve for the use of experimental rates, at the close of the respective month, after the corresponding impacts.
It should be noted that in the record corresponding to the month of December of the year immediately prior to the reporting period, only fields 1, 2, 3 and 8 must be reported. Likewise, in the records corresponding from January to November, only fields 1, 2, 3, 4, 6 and 8 must be reported. Whereas, in the record corresponding to the month of December of the reporting fiscal year, all fields (1 to 8) described in this subsection must be reported. In each record, the information reported in fields 4 to 8, as applicable, must correspond to what is reported in fields 1, 2 and 3 .
a) Report of " Responsible Parties " This report must contain 6 records, in each of which the following information must be reported for the official of the Insurance Institution or Mutual Society responsible for the valuation of the special technical reserve for the use of experimental rates, as well as for the actuaries who certify said valuations, for each of the operations.
Field 1: Responsible Party.- Must report, for each record, the requested information of the official responsible for the technical area or the certifying actuary, as appropriate, according to the following:
| Record | Field 1 |
|---|---|
| 1 | Official responsible for the technical area |
| 2 | Certifying actuary 1 |
| 3 | Certifying actuary 2 |
| 4 | Certifying actuary 3 |
| 5 | Certifying actuary 4 |
| 6 | Certifying actuary 5 |
Field 2: Name.- The name of the official or certifying actuary must be reported.
Field 3: Position.- The position of the official or certifying actuary must be reported.
Field 4: Telephone.- The contact telephone number of the official or certifying actuary must be reported.
Field 5: Email.- The email address of the official or certifying actuary must be reported.
Field 6: Reserve(s) to certify.- In the case of the certifying actuary(ies), the operation in which the reserve in question is being certified must be indicated.
In each record, the information reported in fields 2 to 6 must correspond to what is reported in field 1 .
2.- The Excel format file corresponding to the summary of the valuation of the special technical reserve for the use of experimental rates The text files of the valuation of the special technical reserve for the use of experimental rates referred to in the immediately preceding numeral 1, must be generated using the Excel format file corresponding to the summary of the valuation of the special technical reserve for the use of experimental rates, which will be available, along with its respective user manual, on the Commission's Website ( www.cnsf.gob.mx ) with the name " RR3ESPCVRES.xls " . The Excel format file corresponding to the summary of the valuation of the special technical reserve for the use of experimental rates, containing the information reported as defined in the immediately preceding numeral 1, must be sent as part of the RR3ESPCV product, for which it must be renamed as follows: The name must consist of 24 alphanumeric characters that must be ordered as follows: a) In the first eleven positions, the specific file identifier must be written: " RR3ESPCVRES " . b) In the twelfth position, the company type key must be written.
| Key | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
c) From the thirteenth to the sixteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions. d) From the seventeenth to the twentieth positions, the year must be written. e) In the twenty-first and twenty-second positions, the reporting month must be written. f) In the twenty-third and twenty-fourth positions, the last day of the reporting month must be written.
Example: Company Key: " S " Company Number: " 0009 " Day: " 30 " Month: June ( " 06 " ) Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | E | S | P | C | V | R | E | S | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 | .XLS |
3.- Corresponding certification document signed by the actuary responsible for the valuation of the special technical reserve for the use of experimental rates Certification letter corresponding to the special technical reserve for the use of experimental rates, signed by the responsible actuary. The PDF format file for each operation must contain the name and electronic signature of the actuary or licensed actuary responsible for the valuation, professional license number, number of the current certification issued by the professional college of the specialty or the accreditation of the Commission required for the preparation and signing of the valuation of technical reserves, in compliance with the provisions of article 216 of the LISF. The name of the magnetic file in PDF format must consist of 26 alphanumeric characters that must be ordered as follows: a) In the first eleven positions, the specific file identifier must be written: " RR3ESPCVCER " b) In the twelfth and thirteenth positions, the certification key must be written.
| Detail Key | Description |
|---|---|
| 01 | Life |
| 02 | Accidents and illnesses |
| 03 | Damages |
c) In the fourteenth position, the company type key must be written.
| Key | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
| S | Other Insurance Institutions and Mutual Societies. |
d) From the fifteenth to the eighteenth positions, the number assigned to the Insurance Institution or Mutual Society in question must be written. This number must be preceded by zeros until it occupies all four positions. e) From the nineteenth to the twenty-second positions, the year must be written. f) In the twenty-third and twenty-fourth positions, the reporting month must be written. g) In the twenty-fifth and twenty-sixth positions, the last day of the reporting month must be written.
Example: Certification document for the damages operation. Company Key: " S " Company Number: " 0009 " Day: ( " 30 " ) Month: June ( " 06 " ) Year: 2013
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | Extension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R | R | 3 | E | S | P | C | V | C | E | R | 0 | 3 | S | 0 | 0 | 0 | 9 | 2 | 0 | 1 | 3 | 0 | 6 | 3 | 0 |
VI.- Specific technical reserves Information with quarterly delivery periodicity Insurance Institutions and Mutual Societies, except those authorized to practice pension insurance derived from social security laws as well as those authorized to exclusively practice reinsurance, will deliver the report referred to in this section through the RR3RTESP product, which must be identified according to the following nomenclature of 21 alphanumeric characters that must be ordered as follows: a) In the first eight positions, the following must be placed: RR3RTESP. b) In the ninth position, the company type key must be placed.
| Key | Definition |
|---|---|
| H | Insurance Institutions authorized to operate health insurance. |
| G | Insurance Institutions authorized to operate financial guarantee insurance. |
| V | Insurance Institutions authorized to operate housing credit insurance. |
Insurance Institutions authorized to operate housing credit insurance.
Other Insurance Institutions and Mutual Societies.
c) From the tenth to the thirteenth positions, the number assigned to the Institution or Mutual Society in question must be placed. This number must be preceded by zeros until it occupies all four positions.
d) From the fourteenth to the twenty-first positions, the date to which the report referred to in this section corresponds must be indicated, specifying the year, month, and day.
Example:
In the case of the Insurance Institution with company code 0001, product RR3RTESP, with report date December 31, 2013, the product name must be constructed as follows:
Position 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Character R R 3 R T E S P S 0 0 0 1 2 0 1 3 1 2 3 1 .ZIP .PGP
The information contained in the product must be reported in an Excel file, with the quarterly information of the registration, of the specific technical reserve for outstanding obligations derived from a claim, ordered by CONDUSEF, as well as the cancellation of said reserves or, where applicable, the report that no official letters were received ordering the constitution of any specific technical reserve.
The indicated file will be identified with a nomenclature of 21 alphanumeric characters according to the following:
a) In the first eight positions, the following must be placed: RR3RTESP.
b) In the ninth position, the company type code must be placed.
Code Definition H Insurance Institutions authorized to operate health insurance. G Insurance Institutions authorized to operate financial guarantee insurance. V Insurance Institutions authorized to operate housing credit insurance. S Other Insurance Institutions and Mutual Societies.
c) From the tenth to the thirteenth positions, the number assigned to the Institution or Mutual Society in question must be placed. This number must be preceded by zeros until it occupies all four positions.
d) From the fourteenth to the twenty-first positions, the date on which the notice is made must be indicated, specifying the year, month, and day.
Example:
In the case of the Insurance Institution with company code 0001, to send the file for product RR3RTESP with date December 31, 2013, the product name must be constructed as follows:
Position 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Character R R 3 R T E S P S 0 0 0 1 2 0 1 3 1 2 3 1 . XLSX
General Considerations
The minimum data that the Excel file must contain will be presented in columns, with the information detailed below:
I. Name of the insured;
II. Official letter number issued by CONDUSEF for its constitution;
III. Amount of the specific technical reserve ordered;
IV. Date of the official letter of constitution order;
V. Date of receipt of the official letter of constitution order;
VI. Journal policy number for reserve registration;
VII. Date of the journal policy for reserve registration;
VIII. Amount constituted;
IX. Journal policy number for reserve cancellation;
X. Date of the journal policy for reserve cancellation;
XI. Amount cancelled;
XII. Reason for cancellation, and
XIII. Observations.
In the case of in-force and contingency bond reserves of Bond Institutions
Information Delivery Control Report for Bond Institutions
Quarterly, product RR3CERTF must be sent, which must contain the Excel file corresponding to the information delivery control report, in accordance with what is indicated below:
a) For its submission, the product must be encrypted in a single file in .ZIP.PGP format, whose name must consist of 21 alphanumeric characters, ordered as follows:
b) The first eight positions will correspond to the specific product identifier: "RR3CERTF".
c) In the ninth position, the company type code must be written:
Code Definition F Bond Institutions S Insurance Institutions authorized to operate bonds
d) From the tenth to the thirteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
e) From the fourteenth to the seventeenth positions, the year must be written.
f) In the eighteenth and nineteenth positions, the reported month must be written.
g) In the twentieth and twenty-first positions, the last day of the reported month must be indicated.
Example:
Company Code: "F"
Company Number: "0001"
Day: ("30")
Month: June ("06")
Year: 2013
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Extension R R 3 C E R T F F 0 0 0 1 2 0 1 3 0 6 3 0 .ZIP .PGP
The Excel file corresponding to the information delivery control
The Excel file corresponding to the information delivery control report will be available, along with its respective user manual, on the Commission's Website (www.cnsf.gob.mx) with the name "RR3CERTF.xls". For its submission, said file must be renamed as follows:
The name must consist of 24 alphanumeric characters that must be ordered as follows:
a) In the first eleven positions, the specific file identifier must be written: "RR3CERTFFMT".
b) In the twelfth position, the company type code must be written.
Code Definition F Bond Institutions S Insurance Institutions authorized to operate bonds
c) From the thirteenth to the sixteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
d) From the seventeenth to the twentieth positions, the year must be written.
e) In the twenty-first and twenty-second positions, the reported month must be written.
f) In the twenty-third and twenty-fourth positions, the last day of the reported month must be written.
Example:
Company Code: "F"
Company Number: "0001"
Day: "30"
Month: June ("06")
Year: 2013
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Extension R R 3 C E R T F F M T F 0 0 0 1 2 0 1 3 0 6 3 0 .XLS
The Excel format corresponding to the information delivery control report must be filled out as follows:
i) The information that the cells in the column named "Report" will contain will be related to the names of all reports indicated in this Regulatory Report, which can be submitted by Bond Institutions.
ii) For each row, each cell in the column named "Submitted" must be filled with the text "YES", if the report whose name is indicated in the same row in the "Report" column is submitted by the Institution in the quarter or close of the fiscal year in question; otherwise, the cell in the column named "Submitted" must be filled with the text "NO".
Information with Quarterly Submission Frequency
The valuation of in-force and contingency bond reserves for each bond branch with quarterly submission frequency will consist of the following:
Product RR3RTFCV, which must contain the text files for the valuation of in-force and contingency bond reserves, the Excel file corresponding to the summary of the valuation of in-force and contingency bond reserves, as well as the corresponding certification document, signed by the actuary responsible for them, referred to in the immediately following numerals 1, 2 and 3.
Said product must be sent in accordance with the following:
a) For its submission, the product must be encrypted in a single file in .ZIP.PGP format, whose name must consist of 21 alphanumeric characters, ordered as follows:
b) In the first eight positions, the specific product identifier must be written: "RR3RTFCV".
c) In the ninth position, the company type code must be written:
Code Definition F Bond Institutions S Insurance Institutions authorized to operate bonds
d) From the tenth to the thirteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
e) From the fourteenth to the seventeenth positions, the year must be written.
f) In the eighteenth and nineteenth positions, the reported month must be written.
g) In the twentieth and twenty-first positions, the last day of the reported month must be indicated.
Example:
Company Code: "F"
Company Number: "0001"
Day: ("30")
Month: June ("06")
Year: 2013
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Extension R R 3 R T F C V F 0 0 0 1 2 0 1 3 0 6 3 0 .ZIP .PGP
1.- Text files for the valuation of in-force and contingency bond reserves
5 reports in text file format, of the results of the valuation of in-force and contingency technical bond reserves for each bond branch, whose names must consist of 26 alphanumeric characters that must be ordered as follows:
a) In the first eleven positions, the specific file identifier must be written: "RR3RTFCVRES".
b) In the twelfth and thirteenth positions, the report code must be written.
Report Code Description 01 In-force bond reserves from direct operation and reinsurance assumed 02 In-force bond reserves from direct operation and reinsurance assumed, by currency 03 Contingency reserve 04 Paid claims triangles 05 Guarantee recovery triangles
c) In the fourteenth position, the company type code must be written.
Code Definition F Bond Institutions S Insurance Institutions authorized to operate bonds
d) From the fifteenth to the eighteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
e) From the nineteenth to the twenty-second position, the year must be written.
f) In the twenty-third and twenty-fourth positions, the reported month must be written.
g) In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
Report: 1
Company Code: "F"
Company Number: "0001"
Day: ("30")
Month: June ("06")
Year: 2013
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Extension R R 3 R T F C V R E S 0 1 F 0 0 0 1 2 0 1 3 0 6 3 0 .TXT
Each of the aforementioned results reports will contain the fields described below for each of them, which must be reported in a matrix arrangement where each listed field must be delimited by the character known as pipe ("|") to the left and right of each field, except for the first and last of these, in which case they must only be delimited by pipes to the right and left, respectively. Each record will correspond to the detailed information by branch or type of insurance, according to each operation.
The number of fields and records will be fixed and will depend on each report, so, when a field is not applicable in a given report, it must be left empty.
Figures must be reported in national currency at the exchange rate corresponding to the currency or monetary unit in question, as of the valuation date. For these purposes, the exchange rate value of the index or currency in question, published in the Official Gazette of the Federation on the valuation date, must be used.
a) Report on "In-force bond reserves from direct operation and reinsurance assumed"
This report must contain 18 records with the following information regarding the in-force bond reserve, originating from direct operation, assumed, and recoverable amounts, which is defined below and disaggregated according to the types of bonds corresponding to each operation.
Field 1: Branch or sub-branch.- Each record must report the corresponding branch or sub-branch, as indicated in the definition of records that follows this field definition.
Example.
Field 1, in record 6, must contain the text:
Non-criminal judicial bonds
Field 2: Reserve premium.- Must correspond to the amount of the reserve premium for in-force policies from direct operation, integrated by the sum of the reserve premium for each of the policies and their in-force movements. In the case of policies from the fidelity branch and the judicial sub-branch covering automobile drivers, the unearned reserve premium as of the report date must be reported in this field.
Field 3: Administration expenses.- Must report the amount of administration expenses for in-force policies from direct operation, integrated by the sum of the administration expenses for each of the policies and their in-force movements. In the case of policies from the fidelity branch and the judicial sub-branch covering automobile drivers, the unearned administration expense as of the report date must be reported in this field.
Field 4: In-force bond reserve.- Refers to the amount of the in-force bond reserve from direct operation, which incorporates the sum corresponding to the reserve premium and administration expenses.
Field 5: Recoverable reinsurance amounts.- Must report the recoverable amounts from ceded reinsurance considering the probability of default.
Field 6: Reserve premium for reinsurance assumed.- Must correspond to the amount of the reserve premium for in-force policies from reinsurance assumed, integrated by the sum of the reserve premium for each of the policies and their in-force movements. In the case of policies from the fidelity branch and the judicial sub-branch covering automobile drivers, the unearned reserve premium as of the report date must be reported in this field.
Field 7: Administration expenses for reinsurance assumed.- Must report the amount of administration expenses for in-force policies from reinsurance assumed, integrated by the sum of the administration expenses for each of the policies and their in-force movements. In the case of policies from the fidelity branch and the judicial sub-branch covering automobile drivers, the unearned annual administration expense as of the report date must be reported in this field.
Field 8: In-force bond reserve for reinsurance assumed.- Refers to the amount of the in-force bond reserve from reinsurance assumed, which incorporates the sum corresponding to the reserve premium and annual administration expenses.
Field 9: Recoverable reinsurance amounts corresponding to reinsurance assumed.- Must report the recoverable amounts from reinsurance considering the probability of default, corresponding to the reinsurance assumed operation.
In each record, the information reported in fields 2 to 9 must correspond to the branch or sub-branch reported in field 1, as defined below:
Record 1: Total fidelity bond reserves: The totals of the information corresponding to individual and collective fidelity bonds will be reported.
Record 2: Individual fidelity bonds: Information corresponding to individual fidelity bond policies will be reported.
Record 3: Collective fidelity bonds: Information corresponding to collective fidelity bond policies will be reported.
Record 4: Total judicial bond reserves: The totals of the information corresponding to the judicial bond branch will be reported.
Record 5: Criminal judicial bonds: Information corresponding to criminal judicial bond policies will be reported.
Record 6: Non-criminal judicial bonds: Information corresponding to non-criminal judicial bond policies will be reported.
Record 7: Judicial bonds covering auto drivers: Information corresponding to judicial bond policies covering motor vehicle drivers will be reported.
Record 8: Total administrative bonds: The totals of the information corresponding to administrative bond policies will be reported.
Record 9: Construction bonds: Information corresponding to administrative construction bond policies will be reported.
Record 10: Supply bonds: Information corresponding to administrative supply bond policies will be reported.
Record 11: Tax bonds: Information corresponding to administrative tax bond policies will be reported.
Record 12: Lease bonds: Information corresponding to administrative lease bond policies will be reported.
Record 13: Other administrative bonds: Information corresponding to other administrative bond policies will be reported.
Record 14: Total credit bonds: The totals of the information corresponding to credit bond policies will be reported.
Record 15: Supply bonds: Information corresponding to supply bond policies from the credit branch will be reported.
Record 16: Sales bonds: Information corresponding to sales bond policies from the credit branch will be reported.
Record 17: Financial bonds: Information corresponding to financial bond policies from the credit branch will be reported.
Record 18: Other credit bonds: Information corresponding to other bond policies from the credit
during the month for the investment of the reserve.
Field 9:
Contingency reserve impairment: This is the total amount by which the contingency reserve has been impaired during the month.
Field 10:
Reserve balance at month-end: This is the amount of the contingency reserve at the end of the month in question, after the corresponding impairments.
Field 11:
Contingency reserve limit: The maximum amount of the contingency reserve, calculated in accordance with current regulations, must be reported.
It should be noted that for the record corresponding to December of the year immediately preceding the reporting year, only fields 1, 2, 10, and 11 must be reported.
d) Report of "Paid Claims Triangles"
This report must contain, for each type of surety, information related to the Institution's paid claims, classifying them in a matrix arrangement, by origin year and development year, as indicated below:
Field 1:
Branch.- The corresponding branch must be reported in each record, according to the following
catalog.
Branch
Fidelity
Judicial
Administrative
Credit
It should be noted that information for the same branch must be presented in consecutive records, additionally preserving the order of the branches as established in the previous catalog.
Field 2:
Sub-branch.- The corresponding sub-branch must be reported in each record according to the following catalog.
Branch Sub-branch
Fidelity Collective
Fidelity Individual
Fidelity Special
Judicial Judicial sureties covering motor vehicle drivers
Judicial Non-criminal
Judicial Criminal
Judicial Special
Administrative Lease
Administrative Tax
Administrative Construction
Administrative Other administrative sureties
Administrative Supply
Administrative Special
Credit Purchase-sale
Credit Financial
Credit Other credit sureties
Credit Supply
Credit Special
It should be noted that information for the same branch and sub-branch must be presented in consecutive records, additionally preserving the order of the branches and sub-branches as established in the previous catalog.
Field 3:
Type.- The corresponding type of surety must be reported in each record, according to the following catalog.
Branch Sub-branch Types of surety Concept
Fidelity Individual Administrative staff These are sureties that guarantee the payment of compensation for damages that an employee with an employment relationship (contractual or derived from law) with another may incur, derived from the commission of any crime of a patrimonial nature on goods or rights, property of the latter or, on goods or rights that have been entrusted to them and for which they are legally or contractually responsible.
Fidelity Individual Salespeople These are sureties that guarantee the payment of compensation for damages that a salesperson with a specific sales employment relationship (contractual or derived from law) with another may incur, derived from the commission of any crime of a patrimonial nature on goods or rights, property of the latter or, on goods or rights that have been entrusted to them and for which they are legally or contractually responsible.
Fidelity Individual Insurance and/or surety agents Guarantees the fulfillment of responsibilities that they may incur before the public user, in the performance of their intermediation activities.
Fidelity Collective Certificate These are sureties based on the issuance of a single policy that includes a single group of employees, who may hold different positions and have different individual amounts. The positions covered by this product are the following: Administrative Staff, Salespeople, and Insurance and Surety Agents.
Fidelity Collective Traditional global These are sureties based on the issuance of a single policy with a single amount for all bonded employees, excluding commission agents and sales agents.
Fidelity Collective Comprehensive global These are sureties based on the issuance of a single policy with a single amount for all bonded employees, including salespeople and employees.
Fidelity Collective Single amount for salespeople These are sureties based on the issuance of a single policy that covers the responsibilities of salespeople, commission agents, or persons who perform similar activities, with a single amount for each and every one of them.
Fidelity Collective Combined coverage These are sureties based on a policy in which each employee has an individual amount and a maximum payment limit according to the number of bonded personnel.
Fidelity Special NA These will indicate those sureties that due to their characteristics cannot be considered in the previous definitions.
Judicial Criminal Provisional release Guarantees freedom and the fulfillment of obligations decreed by the Judge during the process.
Judicial Criminal Preparatory release Guarantees freedom and the fulfillment of the obligation to appear before the authority during the time remaining for the full fulfillment of their sentence.
Judicial Criminal Conditional sentence Guarantees freedom and the fulfillment of obligations decreed by the Judge when granting freedom, through a conditional sentence.
Judicial Criminal Reparation of damages Guarantees the payment of compensation for damages supposedly caused by the principal while their legal situation is determined before the Public Prosecutor's Office or before the competent Judicial Authority that gives rise to a criminal process.
Judicial Criminal Pecuniary sanctions Guarantees the payment of imposed fines subject to litigation or fines that may be incurred in the future, in case of non-compliance with the obligations contracted by the principal due to judicial procedures, processes, or resolutions.
Judicial Non-criminal NA Guarantees damages derived from the Law of Trials and procedures in civil, commercial, family, labor, amparo matters, etc.
Judicial Judicial sureties covering automobile drivers NA Guarantees the provisional release of principals derived from imprudent crimes caused by vehicle traffic.
Judicial Special v These will indicate those sureties that due to their characteristics cannot be considered in the previous definitions.
Administrative Construction Bids or tenders Guarantees the maintenance of the offer presented by the principal, in case they are the winner and the contract is awarded to them.
Administrative Construction Performance Guarantees the total or partial fulfillment of the obligations stipulated in a contract, the correct execution, and timely delivery.
Administrative Construction Advance payment Guarantees the proper use and correct application of the advance payment or, failing that, its total or partial return that the beneficiary delivers to the principal, to carry out the execution of the obligations stipulated in a contract.
Administrative Construction Good quality Guarantees the repair of defects or hidden vices in the works executed by the principal.
Administrative Construction Indemnities and/or conventional penalties Guarantees the payment of indemnities and/or conventional penalties arising from the non-fulfillment of obligations stipulated in a contract.
Administrative Supply Bids or tenders Guarantees the maintenance of the offer presented by the principal, in case they are the winner and the order or service contract is awarded to them.
Administrative Supply Performance Guarantees the total or partial fulfillment of the obligations stipulated in an order or service contract, the correct execution, and timely delivery.
Administrative Supply Advance payment Guarantees the proper use and correct application of the advance payment or, failing that, its total or partial return that the beneficiary delivers to the principal, to carry out the execution of the obligations stipulated in an order or service contract.
Administrative Supply Good quality Guarantees the repair of defects or hidden vices in the works executed by the principal.
Administrative Supply Indemnities and/or conventional penalties Guarantees the payment of indemnities and/or conventional penalties arising from the non-fulfillment of obligations stipulated in an order or service contract.
Administrative Tax Temporary import Guarantees before the SHCP, the tax obligations that result for the principal, due to the violation of customs provisions regarding the temporary import of movable goods.
Administrative Tax Definitive import Guarantees before the SHCP, the tax obligations that result for the principal, due to the violation of customs provisions regarding the definitive import of movable goods.
Administrative Tax Temporary import of vehicles Guarantees before the SHCP, the tax obligations that result for the principal, due to the violation of customs provisions regarding the temporary import of the vehicle in their possession.
Administrative Tax Tax disagreements (taxes, duties, fines, tariff disputes, etc.) Guarantees before the IMSS, SHCP or INFONAVIT, possible taxes, duties, tariff disputes, fines, employer-employee contributions, contributions, etc. that may result for the principal, while the administrative procedure presented against the payment requirement is resolved.
Administrative Tax Payment agreements in installments before the IMSS Guarantees before the IMSS the payment of employer-employee contributions, derived from the agreement that has been celebrated with our principal for this purpose.
Administrative Tax Payment agreements in installments before INFONAVIT Guarantees before INFONAVIT payment of contributions derived from the agreement that has been celebrated with our principal for this purpose.
Administrative Tax Other payment agreements in installments Guarantees before the beneficiary, the payment of debts derived from the agreement that has been celebrated with our principal for this purpose.
Administrative Tax Other tax (business closure, VAT refund, etc.) Guarantees before the SHCP various tax obligations that may result for the principal.
Administrative Lease Real estate lease Guarantees the timely payment of rents for the period determined in the lease contract or in the respective surety policy.
Administrative Lease Other lease sureties Guarantees the timely payment of rents for the period determined in the lease contract or in the respective surety policy, related to movable goods.
Administrative Other administrative sureties Customs agents, public brokers, public notaries Guarantees possible administrative responsibilities that may arise in the performance of their function.
Administrative Other administrative sureties Lotteries and raffles Guarantees that prizes are awarded according to the rules established in the lottery or raffle.
Administrative Other administrative sureties Land use Guarantees the principal's obligation to destine the property as established by the authority.
Administrative Other administrative sureties Sanitary licenses Guarantees the fulfillment of responsibilities established for the principal by the corresponding authority.
Administrative Other administrative sureties Various permits and concessions Guarantees the fulfillment of obligations arising from concessions, permits, and authorizations granted to our principal.
Administrative Other administrative sureties Other administrative These are sureties issued in favor of companies such as: Deposit, Mandate, Transport, Lodging, Association, Commercial Consignment, Intermediation or Brokerage, Joint Venture, Commercial Concession, Commercial Agency, and Franchises among others, and that guarantee the fulfillment of obligations of natural or legal persons, derived from civil and commercial contracts.
Administrative Other administrative sureties Commercial commission Guarantees the total or partial fulfillment of obligations contracted in a Commercial Commission contract.
Administrative Other administrative sureties Ticket handling Guarantees the total or partial fulfillment of obligations contracted in the Commercial Commission contract celebrated by Travel Agencies with companies dedicated to land, air, sea, rail transport, etc.
Administrative Special NA These will indicate those sureties that due to their characteristics cannot be considered in the previous definitions.
Credit Supply Lubricants Guarantees the payment for products (lubricants, oils, greases, etc.) supplied by the beneficiary up to the amount equivalent to the individual credit line set by the beneficiary for each principal as expressed in the contract celebrated between them.
Credit Supply Gas Guarantees the payment for products (natural gas, L.P., etc.) supplied by the beneficiary up to the amount equivalent to the individual credit line set by the beneficiary for each principal as expressed in the contract celebrated between them.
Credit Supply Service stations Guarantees the payment for products (produced by Pemex Refinación and habitually commercialized by the Service Station, e.g., gasoline, etc.) supplied by Pemex to service stations up to the amount equivalent to the individual credit line set by the beneficiary for each principal as expressed in the contract celebrated between them.
Credit Supply Refining Guarantees the payment for products (diesel, asphalt, heavy fuel oil, etc.) supplied by the beneficiary up to the amount equivalent to the individual credit line set by the beneficiary for each principal as expressed in the contract celebrated between them.
Credit Supply ASA supply Guarantees before Aeropuertos y Servicios Auxiliares, the timely payment for goods or services supplied to national and foreign airlines.
Credit Supply Petrochemicals Guarantees the payment for products derived from Petrochemicals supplied by the beneficiary up to the amount equivalent to the individual credit line set by the beneficiary for each principal as expressed in the contract celebrated between them.
Credit Supply Other supplies Guarantees before the Beneficiary the credit granted for the supply of their products (in this case the beneficiary will not be Pemex).
Credit Purchase-sale Purchase-sale Guarantees before the creditor of the purchase-sale contract, the timely payment for goods or services acquired in accordance with what was agreed between the seller and the buyer.
Credit Purchase-sale Commercial distribution Guarantees the payment for goods acquired in accordance with what is established in the commercial distribution contract celebrated between the buyer and the seller.
Credit Purchase-sale Credit for the acquisition of fixed assets or durable consumer goods Guarantees before the institution granting the financing, the timely payment of the credit granted for the acquisition of fixed assets or durable consumer goods as agreed by the principal with said institution.
Credit Purchase-sale Credit for the acquisition of real estate financed by entities of the financial group to which the surety company belongs Guarantees before the institution granting the financing, the timely payment of the credit granted for the acquisition of real estate.
Credit Financial NA Guarantees the payment for products (financial leasing; discounting of credit instruments or financial factoring contracts; credits for the export and import of goods and services; credits documented in securities registered in the National Registry of Securities and Intermediaries) supplied by the beneficiary up to the amount equivalent to the individual credit line set by the beneficiary for each principal as expressed in the contract celebrated between them.
Credit Other credit sureties NA Guarantees the payment for products (credits derived from special support programs for micro and small businesses executed by national credit institutions) supplied by the beneficiary up to the amount equivalent to the individual credit line set by the beneficiary for each principal as expressed in the contract celebrated between them.
Credit Special NA These will indicate those sureties that due to their characteristics cannot be considered in the previous definitions.
It should be noted that information for the same branch, sub-branch, and type must be presented in consecutive records, additionally preserving the order of the branches, sub-branches, and types as established in the previous catalog.
Field 4:
Origin Year.- The year in which the surety policies issued by the Institution began their validity must be reported as the origin year. The information will correspond to the last 10 calendar years; in this sense, for each branch, sub-branch, and type of surety, reported in fields 1, 2, and 3, the following values must be captured in consecutive records in this field:
Content
n-9
n-8
n-7
n-6
n-5
n-4
n-3
n-2
n-1
n
Where the value of n will correspond to the value of the most recent year being reported.
Field 5:
Underwritten surety amount.- Refers to the sum of surety amounts of policies that were underwritten during each fiscal year, from direct operation, for each origin year. It is important to clarify that these are not the liabilities for sureties in force at the end of the fiscal year, but all those that were underwritten during each fiscal year, that is, it refers to the accumulation of surety amounts for which the surety company was responsible at some point during the year.
Fields 6 to 15:
Development periods from 0 to 9.- The amount of paid claims from direct operation, corresponding to the branch, sub-branch, type of surety, and origin year reported in fields 1, 2, 3, and 4 of said record, must be reported in each record, in fields 6 to 15. Thus, in field 6, whose development year to report is year 0, paid claims that were recorded in the same year the surety was underwritten must be reported; in field 7, whose development year is year 1, paid claims that were accounted for in the fiscal year following the fiscal year in which the surety was underwritten must be reported. Likewise, fields 8 to 15 will be filled under the same criterion indicated for fields 6 and 7.
e) Report of "Guarantee Recovery Triangles"
This report must contain, for each type of surety, information related to the Institution's guarantee recoveries, classifying them in a matrix arrangement, by payment year and development year, as indicated below:
Field 1:
Branch.- The corresponding branch must be reported in each record, according to the catalog defined for such purposes in section d).
Field 2:
Sub-branch.- The corresponding sub-branch must be reported in each record according to the catalog defined for such purposes in section d).
Field 3:
Type.- The corresponding type of surety must be reported in each record according to the catalog defined for such purposes in section d).
Field 4:
Payment Year: The payment year of claims corresponding to the last 10 calendar years must be reported; in this sense, for each branch, sub-branch, and type of surety, reported in fields 1, 2, and 3, the following values must be captured in consecutive records in this field:
Content
n-9
n-8
n-7
n-6
n-5
n-4
n-3
n-2
n-1
n
Where the value of n will correspond to the value of the most recent year being reported.
Field 5:
Amount paid: Refers to the sum of paid claim amounts from direct operation, for each payment year.
Fields 6 to 15:
Development periods from 0 to 9.- Development periods from 0 to 9.- The amount of guarantee recoveries from direct operation, corresponding to the branch, sub-branch, type of surety, and payment year, reported in fields 1, 2, 3, and 4 of said record, must be reported in each record, in fields 6 to 15. Thus, in field 6, whose development year to report is year 0, guarantee recoveries corresponding to the same payment year of the claim that originated them must be reported; in field 7, whose development year is year 1, guarantee recoveries that were accounted for in the fiscal year following the fiscal year in which the claim was paid must be reported. Likewise, fields 8 to 15 will be filled under the same criterion indicated for fields 6 and 7.
2.- The Excel file corresponding to the summary of the valuation of in-force and contingency surety reserves
The text files for the valuation of in-force and ongoing contingency surety reserves referred to in the immediately preceding numeral 1, must be generated using the Excel file corresponding to the summary of the valuation of in-force and contingency surety reserves, which will be available, along with its respective user manual, on the Commission's Website ( www.cnsf.gob.mx ) under the name " RR3RTFCVRES.xls " .
The Excel file corresponding to the summary of the valuation of in-force and contingency surety reserves, containing the information reported in accordance with what is defined in the immediately preceding numeral 1, must be sent as part of the RR3RTFCV product, for which purpose, it must be renamed as follows:
The name must consist of 24 alphanumeric characters that must be ordered as follows:
a) In the first eleven positions, the specific file identifier must be written: " RR3RTFCVRES " .
b) In the twelfth position, the company type key must be written.
Key Definition
F Surety Institutions
S Insurance Institutions authorized to operate sureties
c) From the thirteenth to the sixteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
d) From the seventeenth to the twentieth positions, the year must be written.
e) In the twenty-first and twenty-second positions, the month being reported must be written.
f)
In the twenty-third and twenty-fourth positions, the last day of the reporting month must be written.
Example:
Company Key: "F"
Company Number: "0001"
Day: "30"
Month: June ("06")
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Extension
R
R
3
R
T
F
C
V
R
E
S
F
0
0
0
1
2
0
1
3
0
6
3
0
.XLS
3.- Certification document corresponding to the valuation of in-force and contingency surety bond reserves signed by the responsible actuary
Certification letter corresponding to the in-force and contingency surety bond reserves, signed by the responsible actuary.
The file in PDF format must contain the name and electronic signature of the actuary or licensed actuary responsible for the valuation, professional license number, number of the current certification issued by the professional college of the specialty or the accreditation of the Commission required for the preparation and signing of the valuation of technical surety bond reserves, in compliance with the provisions of article 226 of the LISF.
The name of the magnetic file in PDF format must consist of 24 alphanumeric characters that must be ordered as follows:
a)
In the first eleven positions, the specific file identifier must be written:
"RR3RTFCVCER"
b)
In the twelfth position, the company type key must be written.
Key
Definition
F
Surety Institutions
S
Insurance Institutions authorized to operate surety bonds
c)
From the thirteenth to the sixteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
d)
From the seventeenth to the twentieth positions, the year must be written.
e)
In the twenty-first and twenty-second positions, the reporting month must be written.
f)
In the twenty-third and twenty-fourth positions, the last day of the reporting month must be written.
Example:
Company Key: "F"
Company Number: "0001"
Day: ("30")
Month: June ("06")
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Extension
R
R
3
R
T
F
C
V
C
E
R
F
0
0
0
1
2
0
1
3
0
6
3
0
Information with annual delivery periodicity
In addition to the information delivered quarterly, annually the information on the results of the valuation of the In-Force Surety Bond Reserve must be delivered, which will consist of the following:
The product RR3RTFBD, which will contain the database text file with the detail of the policy-by-policy valuation of the In-Force Surety Bond Reserve, the database text file with the detail of the information on recoverable reinsurance amounts of the in-force surety bond reserve, referred to in the immediately following numerals 1 and 2. Said product must be sent in accordance with the following:
a)
For its submission, the product must be encrypted in a single file in .ZIP.PGP format, whose name must consist of 21 alphanumeric characters, ordered as follows:
b)
In the first eight positions, the specific product identifier must be written:
"RR3RTFBD"
c)
In the ninth position, the company type key must be written:
Key
Definition
F
Surety Institutions
S
Insurance Institutions authorized to operate surety bonds
d)
From the tenth to the thirteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
e)
From the fourteenth to the seventeenth positions, the year must be written.
f)
From the eighteenth to the nineteenth positions, the reporting month must be written.
g)
From the twentieth to the twenty-first positions, the day of the reporting month must be indicated.
Example:
Company Key: "F"
Company Number: "0001"
Day: ("31")
Month: December ("12")
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Extension
R
R
3
R
T
F
B
D
F
0
0
0
1
2
0
1
3
1
2
3
1
.ZIP
.PGP
1.- Text file of the databases with the detail of the policy-by-policy valuation of the in-force surety bond reserve
A report in text file format with the detail of the policy-by-policy valuation, whose name must consist of 21 alphanumeric characters, which must be ordered as follows:
a)
In the first eight positions, the specific identifier of the files must be written:
"RR3RTFBD".
b)
In the ninth position, the company type key must be written.
Key
Definition
F
Surety Institutions
S
Insurance Institutions authorized to operate surety bonds
c)
From the tenth to the thirteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
d)
From the fourteenth to the seventeenth positions, the year must be written.
e)
From the eighteenth to the nineteenth positions, the reporting month must be written.
f)
From the twentieth to the twenty-first positions, the last day of the reporting month must be written.
Example:
Company Key: "F"
Company Number: "0001"
Day: ("31")
Month: December ("12")
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Extension
R
R
3
R
T
F
B
D
F
0
0
0
1
2
0
1
3
1
2
3
1
.TXT
The structure, order, identifiers, field length, and other details, in accordance with the following:
a)
The database must contain the information ordered in a matrix arrangement, in which the columns correspond to the fields described below and the rows to the records of each in-force surety policy or movement that make up the reserve valuation. The fields will be delimited by the "|" sign known as "pipe".
No.
Name
Type
Size
1
Direct or taken operation
Alphanumeric
2
2
Branch or type of surety
Alphanumeric
2
3
Policy number
Alphanumeric
30
4
Movement
Alphanumeric
20
5
Start date of validity
Numeric
8
6
End date of validity
Numeric
8
7
Administration expenses
Numeric
15
8
Technical note registration number
Alphanumeric
15
9
Currency or monetary unit
Alphanumeric
15
10
Recoverable reinsurance amounts
Numeric
15
11
Multi-year policy identifier
Alphanumeric
2
12
Gross guaranteed amount
Numeric
15
13
Retained guaranteed amount
Numeric
15
14
Risk component
Numeric
15
15
Expense component
Numeric
15
16
In-force surety bond reserve O.C.
Numeric
15
17
In-force surety bond reserve N.C.
Numeric
15
b)
When a field is not applicable to a record, the column for said field must be left empty, while maintaining the corresponding pipes.
c)
The amounts indicated in each of the fields that make up the database must be expressed in the original currency or monetary unit in which the policy is subscribed, except for the field called In-force surety bond reserve N.C., in which the amount must always be expressed in national currency, for which, if applicable, the exchange rate corresponding to the annual closing will be used.
d)
The database must contain only information on surety policies in force at the time of valuation, so it must not include additional information on policies or movements that are expired or canceled at the time of said valuation, regardless of whether said information is maintained within the Institution's own controls.
e)
The quantities reported in the database must be expressed without decimals.
f)
The fields referred to in subsection a) above must be filled in according to the following definitions:
Field 1:
Direct or taken operation.- Refers to whether the policy or movement corresponds to direct or taken operation. In the first case, the text "DI" will be captured, while in the second, "TO".
Field 2:
Branch or type of surety.- In this field, the corresponding key will be indicated, according to the following table:
Branch or type of surety
Key
First-risk fidelity bonds
FP
Other fidelity bonds
FO
Judicial bonds covering motor vehicle drivers
JA
Other judicial bonds
JO
Administrative bonds
FA
Credit bonds
FC
Field 3:
Policy number.- The assigned policy number must be indicated, according to the Institution's internal control criteria. In the case of taken reinsurance operations, this concept will correspond to the policy number or taken reinsurance contract.
Field 4:
Movement.- In cases where, in addition to the policy, there are movements that consider different validities than the main policy and for which a specific valuation of their reserve has been carried out, the Institution in question must, according to its own criteria, establish a control indicator to identify the information related to said movements.
Field 5:
Start date of validity.- The start date of validity of the corresponding policy or movements, reported in each record, will be indicated. In the case of taken reinsurance operations, this concept will correspond to the start date of validity of the policy. The date must be in an 8-character numeric string, indicating the day in the first two positions, the month in the third and fourth, and the year from the fifth to the eighth, completing with leading zeros in the case of months and days that do not occupy the two assigned positions.
Field 6:
End date of validity.- The date on which the validity of the corresponding policy or movement reported in each record will end will be indicated. In the case of judicial and administrative bonds in which, due to their nature, there is no specific end date of validity, the field must be left empty. The date must be in an 8-character numeric string, indicating the day in the first two positions, the month in the third and fourth, and the year from the fifth to the eighth, completing with leading zeros in the case of months and days that do not occupy the two assigned positions.
Field 7:
Administration expenses.- The amount of administration expense that has been applied for the calculation of the policy or movement reserve in question will be identified.
Field 8:
Technical note registration number.- The registration number of the technical note obtained from this Commission, corresponding to the policy or movement, will be indicated.
Field 9:
Currency or monetary unit.- The currency or monetary unit in which the value of the benefit or risk covered by the product corresponding to the policy or movement in question is defined will be indicated. The indication must be made with a 4-character text string, according to the keys indicated in the following catalog:
Currency or monetary unit
Text Key
National Currency
MNAC
Dollars
DOLA
Other
OTRA
Field 10:
Recoverable reinsurance amounts.- The amount of recoverable reinsurance amounts, determined according to applicable regulations and with which the corresponding asset item has been integrated, will be identified.
Field 11:
Multi-year policy identifier.- It will be indicated if the policy or movement corresponds to a multi-year policy. This indication must be made with a text string "MA".
Field 12:
Gross guaranteed amount.- The gross guaranteed amount with which the reserve has been valued must be indicated.
Field 13:
Retained guaranteed amount.- The guaranteed amount discounted from the portion that has been ceded in proportional reinsurance must be indicated.
Field 14:
Risk component.- The amount of the risk component of the in-force surety bond reserve will be identified.
Field 15:
Expense component.- The amount of the unearned annual administration expense used for the valuation of the reserve in each policy or movement in question will be identified.
Field 16:
In-force surety bond reserve O.C.- The amount of the in-force surety bond reserve of the policy or movement, determined according to the valuation criteria provided in the applicable regulations, in units of its original currency or monetary unit in which the policy is contracted, will be indicated.
Field 17:
In-force surety bond reserve N.C.- The amount of the in-force surety bond reserve of the policy or movement, determined according to the valuation criteria provided in the applicable regulations, translated into national currency, will be indicated.
2.-
Text files of the databases with the detail of the information on recoverable reinsurance amounts of the in-force surety bond reserve
A report in text file format with the detail of the information on Recoverable Reinsurance Amounts corresponding to the In-Force Surety Bond Reserve, whose name must consist of 23 alphanumeric characters, which must be ordered as follows:
a)
In the first ten positions, the specific identifier of the files must be written:
"RR3RTFBDIR".
b)
In the eleventh position, the company type key must be written.
Key
Definition
F
Surety Institutions
S
Insurance Institutions authorized to operate surety bonds
c)
From the twelfth to the fifteenth positions, the number assigned to the Institution in question must be written. This number must be preceded by zeros until it occupies all four positions.
d)
From the sixteenth to the nineteenth positions, the year must be written.
e)
From the twentieth to the twenty-first positions, the reporting month must be written.
f)
From the twenty-second to the twenty-third positions, the last day of the reporting month must be written.
Example:
Company Key: "F"
Company Number: "0001"
Day: ("31")
Month: December ("12")
Year: 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Extension
R
R
3
R
T
F
B
D
I
R
F
0
0
0
1
2
0
1
3
1
2
3
1
.TXT
The structure, order, identifiers, field length, and other details, in accordance with the following:
a)
The database must contain the information ordered in a matrix arrangement, in which the columns correspond to the fields described below and the rows to the records of each policy or certificate. The fields will be delimited by the "|" sign, known as "pipe".
No.
Name
Type
Size
1
Direct or taken operation
Alphanumeric
2
2
Branch, sub-branch or type of surety
Alphanumeric
2
3
Policy number
Alphanumeric
30
4
Reinsurer or re-surety provider number
Alphanumeric
15
5
Participation in the reserve
Numeric
15
6
Probability of default
Numeric
6 decimals
7
Recoverable amount O.C.
Numeric
15
8
Recoverable amount N.C.
Numeric
15
b)
When a field is not applicable to a record, the column for said field must be left empty, while maintaining the corresponding pipes.
c)
The amounts indicated in each of the fields that make up the database must be expressed in the original currency or monetary unit in which the policy is subscribed, except for the field called Recoverable amount N.C., in which the amount must always be expressed in national currency, for which, if applicable, the exchange rate corresponding to the annual closing will be used.
d)
The fields referred to in subsection a) above must be filled in according to the following definitions and catalogs:
Field 1:
Direct or taken operation.- Refers to whether the policy, certificate or clause corresponds to direct or taken operation. In the first case, the text "DI" will be captured, while in the second, "TO".
Field 2:
Branch, sub-branch or type of surety.- In this field, the corresponding key will be indicated, according to the following table:
Branch, sub-branch or type of surety
reserve for pending obligations by concept and type of pension.
RR3PCVAPMATE: Minimum creditable yield to the mathematical reserve for pensions.- The variables involved in the calculation of the minimum creditable yield to the mathematical reserve for pensions shall be reported.
RR3PCVAPCONT: Contingency reserve.- The balances of the contingency reserve for Basic Pension Benefits and Additional Benefits shall be reported, and for the latter, the minimum creditable yield to said reserve, by concept and type of pension.
RR3PCVAPRMACA: Minimum creditable yield to the contingency reserve for Additional Benefits.- The minimum creditable yields to the contingency reserve for Additional Benefits shall be reported.
RR3PCVAPRTFLJ: Technical result and monthly release flow.- It shall contain the necessary data for the determination of the technical result and monthly release flow of the contingency reserve for Basic Pension Benefits.
RR3PCVAPRFIFD: Reserve for investment fluctuation and contribution to the Special Pension Fund in question.- The necessary variables for the determination of the balance of the reserve for investment fluctuation, as well as those related to the contribution to the Special Pension Fund in question, shall be reported.
RR3PCVAPINFC: Complementary information on Pension Insurance related to the statistics of all policies in force as of the report date.
The RR3PCVAPOPC text file shall be identified with a 24-alphanumeric character nomenclature as follows:
a)
The first eleven positions shall correspond to the specific file identifier: "RR3PCVAPOPC".
b)
The twelfth position shall correspond to the key of the type of Insurance Institution:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the thirteenth to the sixteenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the seventeenth to the twentieth position, the report year must be indicated.
e)
In the twenty-first and twenty-second positions, the report month must be written. Said number, if applicable, must be preceded by a zero until it occupies both positions.
f)
In the twenty-third and twenty-fourth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the RR3PCVAPOPC text file must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|--- Character|R|R|3|P|C|V|A|P|O|P|C|P|0|0|0|1|2|0|1|5|0|6|3|0|.txt
The RR3PCVAPMATE, RR3PCVAPCONT, and RR3PCVAPINFC text files shall be identified with a 25-alphanumeric character nomenclature as follows:
a)
The first twelve positions shall correspond to the specific file identifier: "RR3PCVAPMATE", "RR3PCVAPCONT" or "RR3PCVAPINFC", as the case may be.
b)
The thirteenth position shall correspond to the key of the type of Insurance Institution:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the fourteenth to the seventeenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the eighteenth to the twenty-first position, the report year must be indicated.
e)
In the twenty-second and twenty-third positions, the report month must be written. Said number, if applicable, must be preceded by a zero until it occupies both positions.
f)
In the twenty-fourth and twenty-fifth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the RR3PCVAPMATE text file must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|C|V|A|P|M|A|T|E|P|0|0|0|1|2|0|1|5|0|6|3|0|.txt
The RR3PCVAPMATRC, RR3PCVAPRRCRC, RR3PCVAPRMACA, RR3PCVAPRTFLJ, and RR3PCVAPRFIFD text files shall be identified with a 26-alphanumeric character nomenclature as follows:
a)
The first thirteen positions shall correspond to the specific file identifier: "RR3PCVAPMATRC", "RR3PCVAPRTFLJ" or "RR3PCVAPRFIFD", as the case may be.
b)
The fourteenth position shall correspond to the key of the type of Insurance Institution:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the fifteenth to the eighteenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the nineteenth to the twenty-second position, the report year must be indicated.
e)
In the twenty-third and twenty-fourth positions, the report month must be written. Said number, if applicable, must be preceded by a zero until it occupies both positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the RR3PCVAPMATRC text file must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|C|V|A|P|M|A|T|R|C|P|0|0|0|1|2|0|1|5|0|6|3|0|.txt
The instructions, text descriptors, and specific criteria for the files that make up the RR3PCVAP product will be made known through the user manual for the preparation of the files corresponding to Annex 38.1.4 regulatory report on technical reserves (RR-3) for Insurance Institutions authorized to operate Pension Insurance, through the Commission's Website, in accordance with the provisions of Disposition 39.1.10 of this Circular.
Additionally, for Insurance Institutions authorized to operate Pension Insurance that operate Reinsurance, these must deliver, with the same frequency as the described RR3PCVAP product, the RR3PREAP product, which must be identified according to the following 21-alphanumeric character nomenclature:
a)
In the first eight positions, the specific product identifier must be placed: RR3PREAP.
b)
In the ninth position, the key of the type of Insurance Institution must be placed:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the tenth to the thirteenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the fourteenth to the seventeenth position, the report year must be indicated.
e)
In the eighteenth and nineteenth positions, the report month must be written. Said number must be preceded by zeros until it occupies both positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the RR3PREAP product must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|R|E|A|P|P|0|0|0|1|2|0|1|5|0|6|3|0|.ZIP
.PGP
The information that the RR3PREAP product will contain shall consist of:
I.
A certification document in PDF format, which must contain the name and electronic signature of the actuary or licensed actuary certified for the preparation and signing of the valuation of the technical reserves of the Insurance Institution in question, professional license number, certificate number to perform the valuation of the technical reserves that Institutions and Mutual Societies must constitute in accordance with the provisions of the LISF.
The name of this file must consist of 26 alphanumeric characters ordered as follows:
a)
In the first thirteen positions, the specific file identifier must be placed: "RR3PREAPRTCER".
b)
In the fourteenth position, the key of the type of Insurance Institution must be placed:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the fifteenth to the eighteenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the nineteenth to the twenty-second position, the report year must be indicated.
e)
In the twenty-third and twenty-fourth positions, the report month must be written. Said number must be preceded by zeros until it occupies both positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the certification document must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|R|E|A|P|R|T|C|E|R|P|0|0|0|1|2|0|1|5|0|6|3|0|.PDF
II.
The following three files in text format and with ".TXT" extension:
RR3PREAPRMRIV: Mathematical reserve for pensions and in-force risks of Additional Benefits for disability and life insurance.- Ceded, retained balances and Reinsurance Recoverable Amounts of the mathematical reserve for pensions and in-force risks of Additional Benefits shall be reported, as well as the balances of these liabilities corresponding to direct insurance and Reinsurance taken for pensions of disability and life insurance, by concept and type of pension.
RR3PREAPRMRRT: Mathematical reserve for pensions and in-force risks of Additional Benefits for occupational risk insurance.- Ceded, retained balances and Reinsurance Recoverable Amounts of the mathematical reserve for pensions and in-force risks of Additional Benefits shall be reported, as well as the balances of these liabilities corresponding to direct insurance and Reinsurance taken for pensions of occupational risk insurance, by concept and type of pension.
RR3PREAPRMRCV: Mathematical reserve for pensions and in-force risks of Additional Benefits for retirement, advanced age unemployment, and old age insurance.- Ceded, retained balances and Reinsurance Recoverable Amounts of the mathematical reserve for pensions and in-force risks of Additional Benefits shall be reported, as well as the balances of these liabilities corresponding to direct insurance and Reinsurance taken for pensions of retirement, advanced age unemployment, and old age insurance, by concept and type of pension.
The RR3PREAPRMRIV, RR3PREAPRMRRT, and RR3PREAPRMRCV text files shall be identified with a 26-alphanumeric character nomenclature as follows:
a)
The first thirteen positions shall correspond to the specific file identifier: "RR3PREAPRMRIV", "RR3PREAPRMRRT" or "RR3PREAPRMRCV", as the case may be.
b)
The fourteenth position shall correspond to the key of the type of Insurance Institution:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the fifteenth to the eighteenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the nineteenth to the twenty-second position, the report year must be indicated.
e)
In the twenty-third and twenty-fourth positions, the report month must be written. Said number, if applicable, must be preceded by a zero until it occupies both positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the RR3PREAPRMRIV text file must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|R|E|A|P|R|M|R|I|V|P|0|0|0|1|2|0|1|5|0|6|3|0|.txt
The instructions, text descriptors, and specific criteria for the files that make up the RR3PREAP product will be made known through the user manual for the preparation of the files corresponding to Annex 38.1.4 regulatory report on technical reserves (RR-3) for Insurance Institutions authorized to operate Pension Insurance derived from social security laws, through the Commission's Website, in accordance with the provisions of Disposition 39.1.10 of this circular.
Insurance Institutions that have the authorization referred to in Disposition 5.8.13 of this Circular shall deliver the RR3PRTFP product in addition to the RR3PCVAP product, with the same frequency as the latter, which must be identified according to the following 21-alphanumeric character nomenclature:
a)
In the first eight positions, the specific product identifier must be placed: RR3PRTFP.
b)
In the ninth position, the key of the type of Insurance Institution must be placed:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the tenth to the thirteenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the fourteenth to the seventeenth position, the report year must be indicated.
e)
In the eighteenth and nineteenth positions, the report month must be written. Said number must be preceded by zeros until it occupies both positions.
f)
In the twentieth and twenty-first positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the RR3PRTFP product must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|R|T|F|P|P|0|0|0|1|2|0|1|5|0|6|3|0|.ZIP
.PGP
PDF files must be legible, maintaining a minimum resolution of 200 dots per inch (dpi).
The information contained in the RR3PRTFP product must be presented quarterly with figures at the close of each of the months that make up said period. For this purpose, said information must be presented in independent magnetic files for each of the referred dates, according to the unstructured information descriptors indicated below:
RR3PRTFPINVER: Certification document signed by the official at the hierarchical level immediately below that of the general director, in charge of the financial function of the Insurance Institution.- A certification document in PDF format, with the name and electronic signature of the official at the hierarchical level immediately below that of the general director, in charge of the financial function of the Insurance Institution in question, in which it is stated that the assets used as a basis to verify the matching between asset flows and liability flows comply with the following:
a)
That they are susceptible to being used in the coverage of the Investment Base and that they guarantee a real rate, and
b)
The interest rates, terms, and valuation criteria of said instruments correspond to their registration in the accounting of the Insurance Institution;
The name of the magnetic file in PDF format referred to must consist of 26 alphanumeric characters that must be ordered as follows:
a)
In the first thirteen positions, the specific file identifier must be placed: RR3PRTFPINVER.
b)
In the fourteenth position, the key of the type of Insurance Institution must be placed:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the fifteenth to the eighteenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the nineteenth to the twenty-second position, the report year must be indicated.
e)
In the twenty-third and twenty-fourth positions, the report month must be written. Said number must be preceded by zeros until it occupies both positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the certification document signed by the official at the hierarchical level immediately below that of the general director, in charge of the financial function of the Insurance Institution, must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|R|T|F|P|I|N|V|E|R|P|0|0|0|1|2|0|1|5|0|6|3|0|.PDF
RR3PRTFPDACT: A certification document in PDF format, which must contain the name and electronic signature of the actuary or licensed actuary certified for the preparation and signing of the valuation of the technical reserves of the Insurance Institution in question, professional license number, certificate number to perform the valuation of the technical reserves that Institutions and Mutual Societies must constitute in accordance with the provisions of the LISF, in which it is stated that the respective valuation, as well as the estimation of the asset flows and liability flows considered, comply with the requirements established in the applicable provisions for the constitution, increase, and valuation of the mathematical reserve for pensions, in accordance with the aforementioned Disposition 5.8.13 of this Circular.
The name of the magnetic file in PDF format of the referred certification document must consist of 25 alphanumeric characters that must be ordered as follows:
a)
In the first twelve positions, the specific file identifier must be placed: RR3PRTFPDACT.
b)
In the thirteenth position, the key of the type of Insurance Institution must be placed:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the fourteenth to the seventeenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the eighteenth to the twenty-first position, the report year must be indicated.
e)
In the twenty-second and twenty-third positions, the report month must be written. Said number must be preceded by zeros until it occupies both positions.
f)
In the twenty-fourth and twenty-fifth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the referred certification document of the actuary or licensed actuary must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|R|T|F|P|D|A|C|T|P|0|0|0|1|2|0|1|5|0|6|3|0|.PDF
RR3PRTFPAIMSS: IMSS Insureds.- Insured bases in magnetic text file format to determine the mathematical reserve for pensions and the in-force risk reserve for Additional Benefits, for pensions of the IMSS pension regime.
The name of the IMSS insured database in magnetic text file format must consist of 26 alphanumeric characters that must be ordered as follows:
a)
In the first thirteen positions, the specific file identifier must be placed: RR3PRTFPAIMSS.
b)
In the fourteenth position, the key of the type of Insurance Institution must be placed:
| Key | Definition |
|---|---|
| P | Insurance Institutions authorized to operate Pension Insurance. |
c)
From the fifteenth to the eighteenth position, the number assigned to the Insurance Institution in question must be placed. Said number must be preceded by zeros until it occupies all four positions.
d)
From the nineteenth to the twenty-second position, the report year must be indicated.
e)
In the twenty-third and twenty-fourth positions, the report month must be written. Said number must be preceded by zeros until it occupies both positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the IMSS insured database must be constructed as follows:
Position|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|Extension ---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|- Character|R|R|3|P|R|T|F|P|A|I|M|S|S|P|0|0|0|1|2|0|1|5|0|6|3|0|.txt
RR3PRTFPAISSS: ISSSTE Insureds.- Insured bases in magnetic text file format to determine the mathematical reserve for pensions and the in-force risk reserve for Additional Benefits, for pensions of the ISSSTE pension regime.
The name of the ISSSTE insured database in magnetic text file format must consist of 26 alphanumeric characters that must be ordered as follows:
a)
In the first thirteen positions, the specific file identifier must be placed:
RR3PRTFPAISSS.
b)
In the fourteenth position, the key for the type of Insurance Institution must be placed:
Key
Definition
P
Insurance Institutions authorized to operate Pension Insurance.
c)
From the fifteenth to the eighteenth position, the number assigned to the Insurance Institution in question must be placed. This number must be preceded by zeros until it occupies the four positions.
d)
From the nineteenth to the twenty-second position, the report year must be indicated.
e)
In the twenty-third and twenty-fourth positions, the report month must be written. This number must be preceded by zeros until it occupies the two positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the ISSSTE insured database must be constructed as follows:
Position
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Extension
Character
R
R
3
P
R
T
F
P
A
I
S
S
S
P
0
0
0
1
2
0
1
5
0
6
3
0
.txt
RR3PRTFPBIMSS: IMSS Pension Beneficiaries.- Pension Beneficiary databases in magnetic text file format to determine the mathematical reserve for pensions and the reserve for risks in force for additional benefits, for the pensions of the IMSS pension regime.
The name of the IMSS Pension Beneficiary database in magnetic text file format must be integrated from 26 alphanumeric characters that must be ordered as follows:
a)
In the first thirteen positions, the specific file identifier must be placed:
RR3PRTFPBIMSS.
b)
In the fourteenth position, the key for the type of Insurance Institution must be placed:
Key
Definition
P
Insurance Institutions authorized to operate Pension Insurance.
c)
From the fifteenth to the eighteenth position, the number assigned to the Insurance Institution in question must be placed. This number must be preceded by zeros until it occupies the four positions.
d)
From the nineteenth to the twenty-second position, the report year must be indicated.
e)
In the twenty-third and twenty-fourth positions, the report month must be written. This number must be preceded by zeros until it occupies the two positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the IMSS Pension Beneficiary database must be constructed as follows:
Position
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Extension
Character
R
R
3
P
R
T
F
P
B
I
M
S
S
P
0
0
0
1
2
0
1
5
0
6
3
0
.txt
RR3PRTFPBISSS: ISSSTE Pension Beneficiaries.- Pension Beneficiary databases in magnetic text file format to determine the mathematical reserve for pensions and the reserve for risks in force for additional benefits, for the pensions of the ISSSTE pension regime.
The name of the ISSSTE Pension Beneficiary database in magnetic text file format must be integrated from 26 alphanumeric characters that must be ordered as follows:
a)
In the first thirteen positions, the specific file identifier must be placed:
RR3PRTFPBISSS.
b)
In the fourteenth position, the key for the type of Insurance Institution must be placed:
Key
Definition
P
Insurance Institutions authorized to operate Pension Insurance.
c)
From the fifteenth to the eighteenth position, the number assigned to the Insurance Institution in question must be placed. This number must be preceded by zeros until it occupies the four positions.
d)
From the nineteenth to the twenty-second position, the report year must be indicated.
e)
In the twenty-third and twenty-fourth positions, the report month must be written. This number must be preceded by zeros until it occupies the two positions.
f)
In the twenty-fifth and twenty-sixth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the ISSSTE Pension Beneficiary database must be constructed as follows:
Position
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Extension
Character
R
R
3
P
R
T
F
P
B
I
S
S
S
P
0
0
0
1
2
0
1
5
0
6
3
0
.txt
RR3PRTFPPAS: Liability Flow.- Total amount of claim flows in each annual measurement interval t, in accordance with item I of Provision 5.8.14, in a magnetic text file, whose name must be integrated from 24 alphanumeric characters that must be ordered as follows:
a)
In the first eleven positions, the specific file identifier must be placed:
RR3PRTFPPAS.
b)
In the twelfth position, the key for the type of Insurance Institution must be placed:
Key
Definition
P
Insurance Institutions authorized to operate Pension Insurance.
c)
From the thirteenth to the sixteenth position, the number assigned to the Insurance Institution in question must be placed. This number must be preceded by zeros until it occupies the four positions.
d)
From the seventeenth to the twentieth position, the report year must be indicated.
e)
In the twenty-first and twenty-second positions, the report month must be written. This number must be preceded by zeros until it occupies the two positions.
f)
In the twenty-third and twenty-fourth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the magnetic text file with the total amount of claim flows in each annual measurement interval t must be constructed as follows:
Position
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Extension
Character
R
R
3
P
R
T
F
P
P
A
S
P
0
0
0
1
2
0
1
5
0
6
3
0
.txt
RR3PRTFPACT: Asset Flow.- Total amount of asset flows obtained in the annual measurement interval t, in accordance with item II of Provision 5.8.14, in a magnetic text file, whose name must be integrated from 24 alphanumeric characters that must be ordered as follows:
a)
In the first eleven positions, the specific file identifier must be placed:
RR3PRTFPACT.
b)
In the twelfth position, the key for the type of Insurance Institution must be placed:
Key
Definition
P
Insurance Institutions authorized to operate Pension Insurance.
c)
From the thirteenth to the sixteenth position, the number assigned to the Insurance Institution in question must be placed. This number must be preceded by zeros until it occupies the four positions.
d)
From the seventeenth to the twentieth position, the report year must be indicated.
e)
In the twenty-first and twenty-second positions, the report month must be written. This number must be preceded by zeros until it occupies the two positions.
f)
In the twenty-third and twenty-fourth positions, the last day of the reported month must be written.
Example:
In the case of an Insurance Institution authorized to operate Pension Insurance with key "0001" and report date June 30, 2015, the name of the magnetic text file with the total amount of asset flows obtained in the annual measurement interval t must be constructed as follows:
Position
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Extension
Character
R
R
3
P
R
T
F
P
A
C
T
P
0
0
0
1
2
0
1
5
0
6
3
0
.txt
The information contained in each of the fields of the RR3PRTFPAIMSS, RR3PRTFPAISSS, RR3PRTFPBIMSS, RR3PRTFPBISSS, RR3PRTFPPAS, and RR3PRTFPACT databases above must be adjusted to the text descriptors and specific criteria that integrate the RR3PRTFP product, which will be made known through the Commission's Website, in accordance with what is established in Chapters 39.1 and 39.3 of these provisions.
In the document you are viewing, there may be text, characters, or objects that do not display correctly due to conversion to HTML format, so we recommend always taking the digitized image of the DOF or the PDF file of the edition as a reference. The content, form, and scope of published documents are the strict responsibility of their issuer.
CONSULT
BY DATE
Su
Mo
Tu
We
Th
Fr
Sa
INDICATORS
Exchange Rate and Rates as of 08/31/2026
DOLLAR
17.0427 UDIS
8.810483% TIIE 28 DAYS
6.7659% TIIE 91 DAYS
6.8033% TIIE 182 DAYS
6.8577% TIIE OVERNIGHT
6.51%
See more
SURVEYS
Did you like the new look of the Official Federal Gazette website?
No
Yes
Official Federal Gazette
Río Amazonas No. 62, Col. Cuauhtémoc, C.P. 06500, Mexico City Tel. (55) 5093-3200, where you can access our services menu
Electronic address: dof.gob.mx
111
LEGAL NOTICE | SOME RIGHTS RESERVED © 2026