{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["HOW TO READ","Yearly Release Schedule","EIG+","EIG+ Updates since SR2015 V1.2","Definition of EIG+ terms","Complex Events","Redemption Matrix","Return of Capital Matrix","Distribution With options","Record Date tracking","InterestPeriod","Change Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HOW TO READ","index":0,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,0,5,2],[6,0,6,2],[4,0,4,1]]}
[]
[]
[]
[]
["Disclaimer",null,"“The Securities Market Practice Group is a group of experts who devote their time on a voluntary basis to define global and local market practices for the benefit of the securities industry. The market practice documentation and recommendations produced by this organization are intended to solve common problems across the securities industry, from which financial institutions can derive clear benefits, to harmonize business processes and to facilitate the usage of message protocols ISO 15022 and ISO 20022. While the Securities Market Practice Group encourages the implementation of the market practices it develops, it is up to the financial institutions within each market to implement the market practices according to their needs and agreements with their business counterparts to support their businesses as efficient as possible.\nAlthough the SMPG has used all reasonable efforts to ensure accuracy of the contents of this document, the SMPG assumes no liability whatsoever for any inadvertent errors or omissions that may appear thereon.\nMoreover, the information is provided on an \"as is\" basis. The SMPG disclaims all warranties and conditions, either express or implied, including but not limited to implied warranties of merchantability, title, non-infringement and fitness for a particular purpose.\nNeither the SMPG, nor any of its members and/or contributors shall be liable for any direct, indirect, special or consequential damages arising out of the use of the information published in this document, even if the SMPG or any of its members have been advised of the possibility of such damages.\""]
[" HOW TO READ"]
["Remark:\nThe former \"EIG DvE\" file has been renamed \"SMPG CA Global Market Practice Part 2\" after a decision of the CA SMPG at the Luxembourg meeting in April 2010.\nThe following table explains in details how to read the table information contained in the various worksheets present in this document."]
["Worksheet Name","Column name","Description"]
["Yearly Release Schedule",null,"This worksheet provides information on the publication schedule of the Corporate Action Global Market Practice part 2 document. It explains how the document is versioned and when it is published during the year."]
[]
["EIG+","Column","The purpose of the EIG+ grid is to cover the most commonly known combinations of events (CAEV) and Mandatory/Voluntary Indicator (CAMV) and to provide for those, the recommended allowed combination of Corporate Action Option Code (CAOP) as well as the recommended allowed set of dates, periods, rates and prices (DPRP) that can be present in the ISO 15022 MT564 message. The table provides a \"global grid\" that forms the SMPG recommendations and also provides country specifics deviations (domestic market practices) that may exist  in specific cases."]
[null," A","ISO 15022 Corporate action event name"]
[null," B","ISO 15022 Corporate action event definition+ any SMPG comments"]
[null," C","ISO 15022 corporate action event indicator code (CAEV qualifier)"]
[null," D","ISO 15022 mandatory/voluntary indicator code (CAMV qualifier)"]
[null,null,"EIG+ Global Grid"]
[null,null,"In the EIG+ 'global grid', there is a row for each CAEV + CAMV combination that may occur in any market.\nThe 'global grid' illustrates the SMPG global market practice.\nThe columns E, F,G,H,I,J,K give the global market practice for the CAEV + CAMV combination.  The 'global grid' provides for each combination, the recommended ISO 15022 Corporate action Option Code indicator (CAOP), and recommended ISO15022 Dates, Periods, Rates and Prices qualifiers.\n\nIf there is no entry in the 'global grid' for CAEV + CAMV combination from columns C and D, this is indicated by the 'n/a' notation, and that combination is therefore only valid for one or more domestic market practice shown in further country columns."]
[null,"E","ISO 15022 mandatory/voluntary indicator code (CAMV).\nThere are two possible entries for the CAMV cell for the 'global grid':\na) a valid CAMV value if a global market practice exists;\nb) 'n/a' indication: if no global market practice exists. In this case, however, there must be a specific usage of the CAEV + CAMV combination in one or more domestic markets.\nNotation Convention\n1. MAND cannot be present more than once in the CAMV column, even if there are more than one possible CAOP value. MAND with two or more options in this CAMV column does not mean that there can be two or more options in a MAND event, but just that some MAND events have a different option than others."]
[null,"F","ISO 15022 Corporate action Option Code indicator (CAOP).\nThere are three possible entries for the CAOP cell for the 'global grid':\na) the list of agreed CAOP codes as global market practice for the CAEV + CAMV combination. \nb)  'no options' indication': when no options are required for some CAEV + CAMV combinations.\nc) a blank cell:  when the global grid CAMV value is 'n/a', \nNotation conventions:\nIn order to make the distinction between options announced by the issuer and those offered additionally by the account servicer, the Account Servicer options are shown in red e.g. BUYA, SLLE"]
[null,null,"DPRP columns - notation conventions\nAllowed support levels on DPRP qualifiers are [M] or [O]\n[M] : The presence of the qualifier is mandatory for this combination (note that Mandatory qualifiers will always be classified as mandatory in the SMPG templates).\n[O] : The presence of the qualifier is optional (note that Optional qualifiers may be classified as either optional or recommended in the SMPG templates).\nThe logical operator \"or\" may also be present between 2 mandatory qualifiers. In this case only one of both qualifiers must be present. "]
[null,"G","The list of SMPG agreed ISO 15022 Date qualifiers"]
[null,"H","The list of SMPG agreed ISO 15022 Period qualifiers"]
[null,"I","The list of SMPG agreed ISO 15022 Rate qualifiers"]
[null,"J","The list of SMPG agreed ISO 15022 Price qualifiers"]
[null,"K","Additional comments about the DPRP qualifiers or about the CAEV + CAMV combination"]
[null,null,"EIG+ Country Specific Grid"]
[null,null,"The domestic market practice for a CAEV + CAMV combination is given in seven columns, their use  is similar to the 'global grid'. Markets are identified by their ISO 4217 country code, their respective name is also provided in English. Specific notation conventions are indicated in the rows below."]
[null,"L","ISO 15022 mandatory/voluntary indicator code (CAMV).\nThere are three possible entries for the CAMV cell for a specific market:\na) 'n/a' indication: the CAEV + CAMV combination does not occur in that market.\nb) a blank cell:  indicates that the 'global grid' CAOP values are applicable in the country.\nc) a CAMV code:  indicates that the market specific option codes (CAOP) applies.\nNotation conventions:\n1. if the global grid for CAMV is 'n/a', a blank cell in the country column indicates that the global grid applies and that it is also not applicable in the country. Therefore, 'n/a' will not be present in a country column if the global grid states 'n/a' already."]
[null,null,"CAOP and DPRP columns - notation conventions\nIf a country has a valid CAEV/CAMV combination but differs somewhat from the global grid, all the valid CAOP and DPRP qualifiers in the country must be fully listed in the country columns (i.e. it is NOT the differences with the 'global grid' that are listed)."]
[null,"M","ISO 15022 Corporate action Option Code indicator (CAOP).\nThere are 2 possible entries for the CAOP cell for a specific market:\na) the list of agreed country specific CAOP codes for the CAEV + CAMV combination when there is a country specific CAMV value indicated in the CAMV column. These always override the 'global grid' CAOP entries.\nb) A blank cell in all other cases.\nNotation conventions:\nIn order to make the distinction between options announced by the issuer and those offered additionally by the account servicer, the Account Servicer options are shown in red e.g. BUYA, SLLE"]
[null,"N","The country specific list of agreed ISO 15022 Date qualifiers"]
[null,"O","The country specific list of agreed ISO 15022 Period qualifiers"]
[null,"P","The country specific list of agreed ISO 15022 Rate qualifiers"]
[null,"Q","The country specific list of agreed ISO 15022 Price qualifiers"]
[null,"R","Additional country specific comments about the DPRP qualifiers or about the CAEV + CAMV combination"]
[null,"S and following","The rest of the country specific grid."]
[null,null,"EIG+ further details"]
[null,"ISO 15022 fields","Three main ISO 15022 fields are used to structure the EIG+ table:\n1. the event indicator, 22F::CAEV//code  \n  The short description is in column A, the definition in column B the code values in column C\n2. the mandatory/voluntary indicator, 22F::CAMV//code  \n  The definitions of the three code values may be found in the SWIFT Standards UHB, the code values and short descriptions are:\n        MAND   Mandatory CA Event; No Instruction Required\n        CHOS   Mandatory CA Event; Instruction Required\n        VOLU    Voluntary CA Event; Instruction Required to Participate\n3. the corporate action option code indicator, 22F::CAOP//code  \n  The definitions of the code values may be found in the SWIFT Standards UHB, the code values and short descriptions are:\n        CASH    Cash\n        SECU    Securities Option\n        CASE    Cash and Securities\n        BUYA    Buy Up\n        SLLE     Sell Entitlement\n        EXER     Exercise\n        LAPS     Lapse\n        NOAC    No Action\n        MPUT    Retain\n        OVER    Oversubscribe\n        ABST     Abstain\n        CONN    Consent Denied\n        CONY    Consent Granted\n        QINV     Qualified Investor\n        NOQU    Non Qualified Investor\n        OTHR     Other"]
[null,null,"Color convention in the EIG+ worksheet"]
[]
[null,null,"In 'plum' color are events considered 'complex', see the 'complex events' worksheet for additional information."]
[null,null,"In 'gold' color are events considered 'redemptions', see the 'redemption matrix' worksheet for additional information"]
[null,null,"Deleted Row"]
[]
[]
["EIG+ Updates since  v SR20YY V1.x",null,"This table outlines the EIG+ differences with the previous published version."]
[]
["Definition of EIG+ Terms",null,"This table lists the ISO20022 elements and definitions matching the EIG+ ISO 15022 DPRP terms."]
[]
["Data Element Placement Guidelines",null,"This table illustrates the allowed position(s) of the Date, Period, Rate, Price data elements as well as recommended placement of other data elements in the ISO 15022 MT564 and MT 566 messages."]
[]
["Complex Events",null,"This table is used to ease the selection of the appropriate CAEV code for complex events.  The events are indicated by 'plum' shading in column A of the EIG+ worksheet."]
[]
["Redemption Matrix",null,"This table is used to ease the selection of the appropriate redemption event type by providing the key differences between the various redemptions events."]
[]
["Return Of Capital Matrix",null,"This table is used to ease the selection of the appropriate return of capital event type by providing the key differences between the various return of capital events."]
[]
["Distribution With Options",null,"This table gives the market practice for a rights event: either in one event using CAEV//RHTS or in two or more events using CAEV//RHDI and a second event CAEV//EXRI."]
[]
["Record Date Tracking",null,"This table tracks the market practice for the usage of the record date."]
[]
["Change Log",null,"This work sheets records the changes made to each version of the CA SMPG Global Market Practice Part 2 document."]

{"sheet":"Yearly Release Schedule","index":1,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["SMPG CA Global Market Practice - Part 2 : Yearly Release Schedule"]
["New yearly release schedule to be applied as of November 2011"]
[]
["The SMPG CA Global Market Practice Part 2 yearly release schedule is managed as follows:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Release schedule:"]
["The SMPG CA Global Market Practice Part 2 spreadsheet will have two official releases. The objective of these releases is to allow users and implementers to synchronise the implementation of the Global Market Practice Part 2 with the yearly SWIFT Standard Releases."]
["The Global Market Practice Part 2 released in February will be in a final state. It is the version that should be taken into account for the November standard release. "]
[]
["Example:"]
["The version of the Global Market Practice Part 2 published in November 2008 is “Global Market Practice - Part 2 SR2009 v0.1”. This version will evolve until Febraury 2009, when it will become “Global Market Practice - Part 2 SR2009 v1.0”. In November 2009, a new version will be released named “Global Market Practice - Part 2 SR2010 v0.1”, etc..."]
[]
["Interim versions:"]
["Of course there could be interim versions of the Global Market Practice Part 2. These would be named Global Market Practice - Part 2 SR200X v0.2, v0.3... However, this should remain exceptional. The objective of this release schedule is to keep the number of versions in circulation to a minimum."]
[]
["Tracking of changes between two releases:"]
["Changes in the Global Market Practice Part 2 between the February release and the November release will be highlighted in blue."]
[]
["Changes in the Global Market Practice Part 2 between the November release and the February release will be highlighted in pink."]
[]
["This will cater for the needs of the practitioners (regular users of the EIG spreadsheet) and of the implementers (yearly users of the spreadsheet for development in their institution). "]
["For practitioners, the changes in blue or pink will simply be the changes from one version to another."]
["For implementers, the addition of the blue changes and the pink changes will be their delta between two February releases and will give them the indication of the changes they need to analyse."]

{"sheet":"EIG+","index":2,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":false,"merged":[[67,1,68,1],[9,0,10,0],[9,1,10,1],[18,0,19,0],[22,0,24,0],[27,0,28,0],[61,0,62,0],[67,0,68,0],[57,0,58,0],[44,0,48,0],[49,0,50,0],[52,0,53,0],[29,0,30,0],[29,1,30,1],[34,0,35,0],[34,1,35,1],[32,0,33,0],[36,0,37,0],[38,0,39,0],[52,1,53,1],[15,0,16,0],[0,6,0,7],[3,0,4,0],[5,0,6,0],[7,0,8,0]]}
["Corporate Action Event ",null,null,null,"GLOBAL GRID",null,"QINS",null,"Comment"]
["Short Description","Definition / comments","CAEV","CAMV","CAMV","CAOP","Underlying","New securities"]
["Attachment","Definition \"Combination of different security types to create a unit. Units are usually comprised of warrants and bond or warrants and equity. Securities may be combined at the request of the security holder or based on market convention.\"","ATTI","VOLU","n/a",null,"X"]
["Repurchase Offer/ Issuer Bid/ Reverse Rights\n\n","Definition \"Offer to existing holders by the issuing company to repurchase its own securities. The objective of the offer is to reduce the number of outstanding  securities.\"\n\nAlways initiated by the issuer.\nAlways VOLU\n\n","BIDS","VOLU","VOLU","CASH\nNOAC","X"]
[null,null,"BIDS","CHOS","n/a",null,"X"]
["BONU - Bonus Issue/Capitalisation Issue","Used for bonus rights events, distributed by CAEV//RHDI with RHDI indicator of BONU - 2-event scenario","BONU","CHOS","CHOS","SECU\nLAPS\nBUYA\nSLLE","X"]
[null,"Used for bonus rights events - 1-event scenario (with intermediate securities)","BONU","CHOS","n/a",null,"X"]
["BPUT - Put Redemption\n","Definition \"Early redemption of a security at the election of the holder subject to the terms and condition of the issue with no reduction in nominal value.\"\n\nSR2009 definition: \"Early redemption of a security at the election of the holder subject to the terms and condition of the issue.\"","BPUT","VOLU","VOLU","CASH\nNOAC","X"]
[null,null,null,"CHOS","n/a",null,"X"]
["Bankruptcy\n","Agreed as a mandatory 'For Your Information' (FYI) with no options and no outturn.\n\nDefinition \"Legal status of a company unable to pay creditors. Bankruptcy usually involves a formal court ruling. Securities may become valueless.\"","BRUP","CHOS","n/a",null,"X"]
[null,null,"BRUP","VOLU","n/a",null,"X"]
["Capital Distribution","Definition: The Corporate event pays shareolders an amount in cash issued from the Capital account. There is no reduction to the face value of a single share (or the share has no par value). The number of circulating shares remains unchanged.","CAPD","CHOS","CHOS","CASH","X"]
["Capital Gains Distribution\n","Definition \"Distribution of profits resulting from the sale of company assets eg, Shareholders of Mutual Funds, Unit Trusts, or Sicavs are recipients of capital gains distributions which are often reinvested in additional shares of the fund.\"\n\nAgreed this is a separate event for tax reasons","CAPG","CHOS","n/a",null,"X"]
["Non-US TEFRA D Certification","Definition \"Non-US beneficial owner certification requirement for exchange of temporary to permanent notes.\"","CERT","CHOS","CHOS","QINV\nNOQU","X"]
["Change\n\n","Maybe VOLU when initiated by the investor","CHAN","VOLU","n/a",null,"X"]
["Class Action/Proposed Settlement","Definition \"Situation where interested parties seek restitution for financial loss. Security holder may be offered the opportunity to join a class action proceeding and would need to respond with an instruction.\"\n\nAbstain is the default.  It is not always mandatory to respond to the account servicer, the account owner may reply directly to the (US) legal representatives.","CLSA","VOLU","VOLU","ABST\nCONY\nNOAC","X"]
[null,null,null,"CHOS","n/a",null,"X"]
["Consent","Definition: Procedure that aims to obtainconsent of holder to a proposal by the issuer or a third party without convening a meeting. For example, consent to change the terms of a bond..\n\nSR2009 definition \"Procedure that aims to obtain the consent of holders, without a formal general meeting, to a proposal by the issuer or a third party.\"","CONS","VOLU","VOLU","CONY\nCONN\nABST\nNOAC","X"]
["Conversion ","\nVOLU when initiated by the investor",null,"VOLU","VOLU","SECU\nNOAC","X",null,"do we have the case where it could be with the indication\n of the new securities to get?"]
[null,"Definition \"Conversion of securities (generally convertible bonds or preferred shares) into another form of securities (usually common shares) at a pre-stated price/ratio.\"",null,"CHOS","n/a",null,"X"]
["Detachment","Definition \"Separation of components that comprise a security, eg usually units comprised of warrants and bond or warrants and equity. Units may be broken up at the request of the security holder or based on market convention.\"\n\nComponent can be any instrument (not restricted)","DETI","VOLU","n/a",null,"X"]
["Drawing","Definition: \"Redemption in part before the scheduled final maturity date of a security. Drawing is distinct from partial call since drawn bonds are chosen by lottery and with no reduction in nominal value.\"\n\nSR2009 definition: \"Redemption in part before the scheduled final maturity date of a security. Drawing is distinct from partial call since drawn bonds are chosen by lottery and results are confirmed to bondholder.\"","DRAW","CHOS","n/a",null,"X"]
["Dividend Reinvestment ","Definition \"Dividend payment where holders can keep cash or have the cash reinvested in the market by the issuer into additional shares in the issuing company. To be distinguished from DVOP as the company invests the dividend in the market rather than creating new share capital in exchange for the dividend.\"\n\nDistinguished from the SECU option of CAEV//DVOP because the company invests the dividend in the market rather than creating new share capital in exchange for the dividend.\n\nThe case where a holder signs-up for a standing reinvestment plan is not considered an event, it is a service offering.","DRIP","CHOS","CHOS","SECU\nCASH","X"]
[null,null,null,"CHOS","CHOS","SECU\nCASH","X"]
[null,null,null,"VOLU","n/a",null,"X"]
["Disclosure","Definition \"Requirement under some regulations for holders or beneficial owners to disclose to the issuer the name, location and holdings of any issue.\"","DSCL","VOLU","VOLU","CONN\nCONY\nNOAC","X"]
["Dutch Auction","Definition \"An action by a party wishing to acquire a security. Holders of the security are invited to make an offer to sell, within a specific price range. The acquiring party will buy from the holder with lowest offer.\"\n\nCASH option as stock given up","DTCH","VOLU","VOLU","CASH\nNOAC","X"]
["Cash Dividend","Where a currency choice is offered\nDefinition \"Distribution of cash to shareholders, in proportion to their equity holding. Ordinary dividends are recurring and regular.  Shareholder must take cash and may be offered a choice of currency\"","DVCA","CHOS","CHOS","CASH","X"]
[null,"Cash Dividend is eligible for Reinvestment",null,"CHOS","n/a",null,"X"]
["Dividend Option","Definition \"Distribution of a dividend to shareholders with a choice of benefit to receive.  Shareholders may choose to receive shares or cash. To be distinguished from DRIP as the company creates new share capital in exchange for the dividend rather than investing the dividend in the market.\"","DVOP","CHOS","CHOS","CASH\nSECU","X","X","DVOP to be discussed"]
[null,null,null,"CHOS","CHOS","CASH\nSECU","X","X"]
["Stock Dividend","Definition \"Dividend paid to shareholders in the form of equities of the issuing corporation.\"","DVSE","CHOS","n/a",null,"X"]
["Exchange ","Definition \"Exchange of holdings for other securities and/or cash. The exchange can be either mandatory or voluntary involving the exchange of outstanding securities for different securities and/or cash. For example \"exchange offer\", \"capital reorganisation\" or \"funds separation\".\"\n\nAlways intitated by the issuer as a capital restructing of  a single company which may result in further companies and/or involve subsiduaries","EXOF","VOLU","VOLU","SECU\nCASH\nCASE\nNOAC","X","X","could we have a round-up scenario? \nIn such a case, I would say that a client can instruct on the quantity of new securities to receive. "]
[null,null,null,"CHOS","CHOS","SECU\nCASH\nCASE","X","X","could we have a round-up scenario? \nIn such a case, I would say that a client can instruct on the quantity of new securities to receive. "]
["Call on Intermediate Securities","Definition \"Call or exercise on nil-paid securities or intermediate securities resulting from a intermediate securities distribution (RHDI). This code is used for the second event, when an intermediate securities' issue (rights/coupons) is composed of two events, the first event being the distribution of intermediate securities.\"\n\nNot all the options will apply - SLLE & BUYA only when rights are tradeable.\n\nSLLE may be included when the issuer offers to buy rights back from the holder, see CH, DE, NO, SE.","EXRI","CHOS","CHOS","EXER\nLAPS\nOVER\nSLLE\nBUYA","X","X","Difference between EXER = Underlying and OVER = New \nmeaning that we need to go at option level for more clarity"]
[null,null,null,"VOLU","n/a",null,"X","X","Difference between EXER = Underlying and OVER = New \nmeaning that we need to go at option level for more clarity"]
["Maturity Extension ","SECU if the holder accepts the extension, with or without exchange of securities\nMPUT if the holder has the option retain the original security without the maturity extension","EXTM","CHOS","CHOS","SECU\nMPUT","X"]
[null,null,null,"VOLU","n/a",null,"X"]
["Warrant Exercise","Definition: \"Option offered to holders to buy (call warrant) or to sell (put warrant) a specific amount of stock, cash, or commodity, at a predetermined price, during a predetermined period of time (which usually corresponds to the life of the issue)..\"\n\nTYPE: \"North American Style Warrant Voluntary\" - may be offered at specific points in time over a period.\n","EXWA","VOLU","VOLU","EXER\nNOAC\nBUYA\nSLLE","X"]
[null,"TYPE: \"Mixed (North American/European) Style Warrant Voluntary Ending in Mandatory\" - may be offered at specific points in time over a period and ending with a final opportunity offered before expiration.\nCan be found on the German market.\n",null,"CHOS","CHOS","EXER\n[LAPS or NOAC]","X"]
["Information","Definition: \"Information provided by the issuer having no accounting/financial impact on the holder.\"","INFO","VOLU","n/a"]
["Interest Payment","If currency options available\nDefinition \"Interest payment distributed to holders of an interest bearing asset.\"\n\nNote: This event type should not be used to report accrued interests being paid as part/result of another event.","INTR","CHOS","CHOS","CASH","X"]
["Liquidation Dividend / Liquidation Payment","Definition \"A distribution of cash, assets, or both.  Debt may be paid in order of priority based on preferred claims to assets specified by the security.\"\nIt is considered very rare for anything other than CASH to be available\n\nIf there is no distribution of any kind at all use CAEV//WRTH when underlying security is declared worthless","LIQU","CHOS","CHOS","CASH\nSECU\nCASE","X"]
["Full Call/Early Redemption  ","Definition \"The redemption of an entire issue outstanding of securities, eg, bonds, preferred equity, funds, by the issuer or its agent, eg, asset manager, before final maturity.\"","MCAL","CHOS","n/a",null,"X"]
["General Meeting\nCourt Meeting\nExtraordinary Meeting\nOrdinary General Meeting\nBond Holder Meeting","Definitions:\nMEET \"Annual general meeting.\"\n\nNote that dedicated candidate ISO 20022 messages covering proxy will be available from 4Q2007","MEET","VOLU","VOLU","CONN\nCONY\nABST\nNOAC\nPROX\nSPLI"]
[null,"BMET \"Physical meeting of bond holders.\"","BMET","VOLU","VOLU","CONN\nCONY\nABST\nNOAC\nPROX\nSPLI"]
[null,"CMET \"Announcement of a meeting at a Court.\"","CMET","VOLU","VOLU","CONN\nCONY\nABST\nNOAC\nPROX\nSPLI"]
[null,"XMET \"Extraordinary or special general meeting.\"","XMET","VOLU","VOLU","CONN\nCONY\nABST\nNOAC\nPROX\nSPLI"]
[null,"OMET \"Ordinary general meeting.\"","OMET","VOLU","VOLU","CONN\nCONY\nABST\nNOAC\nPROX\nSPLI"]
["Merger \n\n\n","Definition \"Exchange of outstanding securities, initiated by the issuer which may include options, as the result of two or more companies combining assets, ie an external third party company. Cash payments may accompany equity exchange.\"\n\nInitiated by the issuer.  Involves two or more companies (ie an external, third party company). ","MRGR","CHOS","CHOS","SECU\nCASE","X"]
[null,"Rarely VOLUntary  - NMPGs to consider",null,"VOLU","n/a",null,"X"]
["Non-Official Offer","Definition: \"Offers that are not supervised or regulated by an Official Entity and being offered by a party (eg. a broker) usually at a discount price (eg. broker offer, mini-tender , mini odd lot offer or third party offer).\"","NOOF","VOLU","n/a",null,"X"]
["Odd Lot Sale/Purchase","Definition \"Sale to or purchase of odd-lots to/from the issuing company, initiated either by the holder of the security or through an offer made by the issuer.\"","ODLT","VOLU","VOLU","CASH\nSECU\nNOAC\nBUYA\nSLLE","X"]
[null,null,null,"CHOS","n/a",null,"X"]
["Partial Redemption with\nreduction of nominal\nvalue","Definition \"Securities are redeemed in part before their scheduled final maturity date with reduction of the nominal value of the securities. The outstanding amount of securities will be reduced proportionally.\"","PCAL","CHOS","n/a",null,"X"]
["Place of Incorporation","Definition \"Changes in the state of incorporation for US companies and changes in the place of incorporation for foreign companies. Where shares need to be registered following the incorporation change, the holder(s) may have to elect the registrar.\"\n\nRetained in SR2006 maintenance on a second vote until an alternative is available for this reference data change","PLAC","CHOS","n/a",null,"X"]
["Installment Call ","Definition \"An instalment towards the purchase of equity capital, subject to an agreement between an issuer and a purchaser.\"\n\nSECU means that you will make the payment on the security.  LAPS means that you will not make the payment and will forfeit the security.   CAMV code should be CHOS - there is a choice and there will always be an action","PPMT","CHOS","n/a",null,"X"]
["Priority Issue","Definition \"Form of open or public offer where, due to a limited amount of securities available,\npriority is given to existing shareholders.\"","PRIO","VOLU","VOLU","SECU\nOVER\nNOAC",null,"X"]
[null,null,null,"CHOS","n/a",null,null,"X"]
["Final Maturity","CHOS when CCY choice\nDefinition \"The redemption of an entire issue outstanding of securities, eg, bonds, preferred equity, funds, by the issuer or its agent, eg, asset manager at final maturity.\"","REDM","CHOS","CHOS","CASH","X"]
["Remarketing Agreement","Definition \"Purchase and sale of remarketed preferred equities/bonds through the negotiation of interest rate between the issuers and the holders.\"\n\nCHOS recommended as there is a choice to redeem at original rate  or to submit a new bid on a interest rate(s) or maturity extension.  \nFor redemption, the CASH option would apply.  \nSECU (to be repeated as needed) for interest rate bids or maturity extensions as the intention here is to continue to hold the security. ","REMK","CHOS","CHOS","SECU\nCASH","X"]
["Rights Issue/Subscription Rights/Rights Offer","Definition: \"Offer to holders of a security to subscribe for additional securities via the distribution of an intermediate security. Both processes are included in the same event.\"\n\nNote that the confirmation of the rights distribution carried out with an MT 566 and a SECU option","RHTS","CHOS","CHOS","EXER\nLAPS\nOVER\nSLLE\nBUYA","X"]
[null,null,null,"VOLU","n/a",null,"X"]
["Shares Premium Dividend","Where a currency choice is offered\nDefinition \"This corporate event pays shareholders an amount in cash issued from the share premium reserve. It is similar to a dividend but has different tax implications.\"","SHPR","CHOS","CHOS","CASH","X"]
["Spin-Off","Definition \"A distribution of securities issued by another company. The distributed securities may either be of a newly created or of an existing company. For example, spin-off, demerger, unbundling, divestment. .\"","SOFF","CHOS","n/a",null,"X"]
["Stock Split/Change in Nominal Value/Subdivision","Definition \"Increase in a corporation's number of outstanding equities without any change in the shareholder's equity or the aggregate market value at the time of the split. Equity price and nominal value are reduced accordingly.\"","SPLF","CHOS","n/a",null,"X"]
["Reverse Stock Split/Change in Nominal Value","Definition \"Decrease in a company's number of outstanding equities without any change in the shareholder's equity or the aggregate market value at the time of the split. Equity price and nominal value are increased accordingly.\"","SPLR","CHOS","n/a",null,"X"]
["Tender/ Acquisition/ Takeover/ Purchase Offer\n\n","Definition \"An offer made to holders, by a third party, requesting them to sell (tender) or exchange their securities.\"\n\nInitiated by a third party.\nTypically VOLU, when the tender reaches the 'squeeze out' stage it will be MAND","TEND","VOLU","VOLU","SECU\nCASE\nCASH\nNOAC","X"]
[null,null,null,"CHOS","n/a",null,"X"]
["Withholding Tax Relief Certification","Definition \"Certification process for withholding tax reduction or exemption based on the tax status of the holder.\"\n\nHolder communication is paper based","WTRC","VOLU","VOLU","no option","X"]
["Worthless","Definition \"Booking out of valueless securities.\"\n\nNote that there is no outturn.  LAPS used in the MT 566 confirmation for the account movement\nIf there is any payment involved, another event type should be used (liquidation, exchange etc.).","WRTH","CHOS","n/a",null,"X"]

{"sheet":"EIG+ Updates since SR2015 V1.2","index":3,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,12],[10,2,10,5],[10,6,10,12],[1,0,1,1],[9,0,9,12]]}
["Global Grid Updates (Since SR2015 V1.1)"]
["Corporate Action",null,null,null,"GLOBAL GRID"]
["Short Description","Definition / comments","CAEV","CAMV","CAMV","CAOP","Date","Period","Rate","Price","Definition / comments","Comment regarding correction"]
["Final Maturity","Use for Reverse Convertibles & Equity Linked Notes when they expired without compensation","REDM","MAND",null,"LAPS","RDTE [M]\nPAYD [M]\nLTRD [O]"]
["Increase",null,"INCR","MAND","MAND","SECU","EARL [O]\nPAYD [M]\nXDTE [M]\nRDTE [M]\nLTRD [O]",null,"NEWO [M]"]
[]
[]
[]
[]
["Country Specific Updates (Since SR2015 V1.2)"]
[null,null,"GLOBAL GRID",null,null,null,"Country Specic Columns"]
["CA Name","Definition / comments","CAEV","CAMV","GG CAMV","GG CAOP","CAMV","CAOP","Date","Period","Rate","Price","Definition / comments"]
["Sweden"]
["Decrease In Value","Definition \"Reduction of face value of a single share or the value of fund assets. The number of circulating shares/units remains unchanged. This event may include a cash payout to holders.\"","DECR","MAND","MAND","CASH","n/a\nMAND","CASH","XDTE [M]\nVALU [O]\nPAYD [M]\nRDTE [M]",null,"GRSS [M]"]
["Stock Dividend","Definition \"Dividend paid to shareholders in the form of equities of the issuing corporation.\"","DVSE","CHOS","n/a",null,"CHOS","SECU\nCASH\nLAPS\n\nSLLE\nBUYA","VALU [O]\nMKDT [O]\nRDDT [O]\nPAYD [M]","PWAL [M]\nAREV [O]","RATE [M]","OFFR [M]","If rights have been distributed in a previous RHDI event.\nCASH is used when sale of rights is offered commission-free by issuer."]
["Shares Premium Dividend",null,"SHPR","CHOS","CHOS","CASH","n/a"]
[]
["SG"]
["Consent",null,"CONS","VOLU","VOLU","CONY\nCONN\nABST\nNOAC","CONY\nCONN\nABST\nNOAC","RDTE [O]\nEARL [O]\nVALU [O]\nMKDT [M]\nRDDT [M]\nPAYD [O]","PWAL [O]","INCE [O]\nSOFE [O]\nGRSS(O)\n\n",null,null,"PAYD is [M] only if there is a consent fee."]
[]
["FR"]
["Remove all comments about \"H2D/H2R Stream 5\" in the FR \"Definition/Comments\" column "]
[]
["FI"]
["Accumulation","Definition: \"Funds related event in which the income (for example accumulation units) that accrues during an accounting period is retained within the fund instead of being paid away to investors. The retained income is nonetheless deemed to have been distributed to investors for tax purposes.\"","ACCU","MAND","n/a",null,"n/a"]
["Decrease In Value","Definition \"Reduction of face value of a single share or the value of fund assets. The number of circulating shares/units remains unchanged. This event may include a cash payout to holders.\"","DECR","MAND","MAND","CASH","n/a"]

{"sheet":"Definition of EIG+ terms","index":4,"n_rows":143,"n_cols":4,"rows_kept":143,"cut":false,"hidden":false,"merged":[[3,0,3,3]]}
[]
["Legend",null,"Updated since last  release"]
[]
["Definitions of EIG+ DPRP Terms"]
["Date","ISO 15022","ISO 20022","ISO Definition"]
["ANOU","Announcement Date/Time","AnnouncementDate","Date/time at which the issuer announced that a corporate action event will occur."]
["AVAL","Available Date/Time For Trading","AvailableDate","Date/time at which securities become available for trading, for example first dealing date."]
["BORD","Stock Lending Deadline Date/Time","Stock Lending Deadline","Date/time that the account servicer has set as the deadline to respond, with instructions, to an outstanding event, for which the underlying security is out on loan. This time is dependent on the reference time zone of the account servicer as specified in an SLA."]
["CERT","Certification Deadline Date/Time","CertificationDeadline","Deadline by which the beneficial ownership of securities must be declared."]
["COAP","Court Approval Date/Time","CourtApprovalDate","Date/time upon which the Court provided approval."]
["CVPR","Cover Expiration Date/Time","CoverExpirationDate","Last day a holder can deliver the securities that it had elected on and/or previously protected."]
["DVCP","Depository Cover Expiration Date/Time ","DepositoryCoverExpirationDate","The last day that a participant of the depository can deliver securities that it had elected on and/or previously protected."]
["DIVR","Dividend Ranking Date/Time","DividendRankingDate","Date/time at which a security will be entitled to a dividend."]
["EARD","Early Response Deadline Date/Time","EarlyResponseDeadline","Date/time that the account servicer has set as the deadline to respond, with instructions, to an outstanding event, giving the holder eligibility to incentives. This time is dependent on the reference time zone of the account servicer as specified in an SLA."]
["EARL","Earliest Payment Date/Time","EarliestPaymentDate","Date/time at which a payment can be made, for example, if payment date is a non-business day or to indicate the first payment date of an offer."]
["ECDT","Early Closing Date/Time","EarlyClosingDate","First possible early closing date of an offer if different from the expiry date."]
["ECPD","Election to Counterparty Market Deadline","ElectionToCounterpartyMarketDeadline","Deadline by which an entitled holder needs to advise their counterparty to a transaction of their election for a corporate action event, also known as Buyer Protection Deadline."]
["ECRD","Election to Counterparty Response Deadline","ElectionToCounterpartyResponseDeadline","Date/time the account servicer has set as the deadline to respond, with instructions, prior to the election to counterparty market deadline "]
["EFFD","Effective Date/Time","EffectiveDate","Date/time at which an event is officially effective from the issuer's perspective."]
["EQUL","Equalization Date/Time\n","EqualisationDate","Date/time at which all or part of any holding bought in a unit trust is subject to being treated as capital rather than income. This is normally one day after the previous distribution's ex date."]
["ETPD","Early Third Party Deadline\n","EarlyThirdPartyDeadline","Date/Time set by the issuer agent as a first early deadline by which the account owner must instruct directly another party, possibly giving the holder eligibility to incentives. For example, to provide documentation to an issuer agent."]
["EXPI","Expiry Date/Time","ExpiryDate","Date/time at which an order expires or on which a privilege or offer terminates."]
["FDAT","Further Detailed Announcement Date/Time","FurtherDetailedAnnouncementDate","Date/time at which additional information on the event will be announced, for example, exchange ratio announcement date."]
["FILL","Filing Date","FilingDate","Date on which the action was filed at the applicable court. "]
["FXDT","FX Rate Fixing Date/Time","ForeignExchangeRateFixingDate","Date/time at which a foreign exchange rate will be determined."]
["GUPA","Guaranteed Participation Date/Time","GuaranteedParticipationDate","Last date/time by which a buying counterparty to a trade can be sure that it will have the right to participate in an event."]
["HEAR","Hearing Date","HearingDate","Date for the hearing between the plaintiff and defendant, as set by the court. "]
["IFIX","Fixing Date/Time","FixingDate","Date/time at which an index/rate/price/value will be determined."]
["LAPD","Lapsed Date/Time","LapsedDate","Date/time at which an event/offer is terminated or lapsed.\n"]
["LOTO","Lottery Date/Time","LotteryType","Date/time at which the lottery is run and applied to the holder's positions. This is also applicable to partial calls.\n"]
["LTRD","Last Trading Date/Time","LastTradingDate","Date/time at which the securities to be reorganised will cease to be tradeable."]
["MATU","New Maturity Date/Time","NewMaturityDate","Date/time to which the maturity date of an interest bearing security is extended."]
["MCTD","Market Claim Tracking End Date ","MarketClaimTrackingEndDate","Date by which the depository stops monitoring activities of the event, for instance, accounting and tracking activities for due bills end."]
["MEET","Meeting Date/Time","MeetingDate","Date/time at which the bondholders' or shareholders' meeting will take place."]
["MET2","Second Meeting Date/Time","n/a","Date/time at which the company's general meeting is scheduled, 2nd session if applicable (for example, Italy)."]
["MET3","Third Meeting Date/Time","n/a","Date/time at which the company's general meeting is scheduled, 3rd session if applicable (for example, Italy)."]
["MKDT","Market Deadline Date/Time","MarketDeadline","Issuer or issuer's agent deadline to respond, with an election instruction, to an outstanding offer or privilege."]
["MFIX","Margin Fixing Date/Time","MarginFixingDate","Date/time at which the margin rate will be determined."]
["OAPD","Official Announcement/Publication Date","OfficialAnnouncementPublicationDate","Date/time at which the corporate action is legally announced by an official body, for example, publication by a governmental administration."]
["PAYD","Payment Date/Time","PaymentDate","Date/time at which the movement is due to take place (cash and/or securities)."]
["PLDT","Lead Plaintiff Deadline","LeadPlaintiffDeadline","Last day an investor can become a lead plaintiff."]
["PODT","Protect Date/Time","ProtectDate","Last date/time a holder can request to defer delivery of securities pursuant to a notice of guaranteed delivery or other required documentation."]
["POST","Posting Date","PostingDate","Date of the posting (credit or debit) to the account."]
["PROD","Proration Date/Time","ProrationDate","Date/time at which the issuer will determine a proration amount/quantity of an offer."]
["PPDT","Pari Passu Date/Time","PariPassuDate","Date/time at which security will assimilate, become fungible, or have the same rights to dividends as the parent issue."]
["RDDT","Response Deadline Date/Time","ResponseDeadline","Date/time at which the account servicer has set as the deadline to respond, with instructions, to an outstanding event. This time is dependent on the reference time zone of the account servicer as specified in an SLA."]
["RDTE","Record Date/Time","RecordDate","Date/time at which positions are struck at the end of the day to note which parties will receive the relevant amount of entitlement, due to be distributed on payment date."]
["REGI","Deadline to Register","RegistrationDeadline","Date/time at which instructions to register or registration details will be accepted."]
["RESU","Results Publication Date/Time","ResultsPublicationDate","Date/time at which results are published, for example, results of an offer."]
["SPLT","Deadline to Split","DeadlineToSplit","Deadline by which instructions must be received to split securities, for example, of physical certificates."]
["SUBS","Subscription Cost Debit Date/Time","SubscriptionCostDebitDate","Date/time by which cash must be in place in order to take part in the event."]
["SXDT","Special Ex-Date/Time","SpecialExDate","Date/time as from which 'special processing' can start to be used by participants for that event. Special processing is a means of marking a transaction, that would normally be traded ex or cum, as being traded cum or ex respectively, for example, a transaction dealt 'special' after the ex date would result in the buyer being eligible for the entitlement. This is typically used in the UK and Irish markets."]
["TAXB","Deadline for Tax Breakdown Instructions","DeadlineForTaxBreakdownInstruction","Date/time until which tax breakdown instructions will be accepted."]
["TRAD","Trade Date/Time","TradingDate","Date/time at which the deal (rights) was agreed."]
["TSDT","Trading Suspended Date/Time","TradingSuspendedDate","Date/time at which trading of a security is suspended as the result of an event."]
["TPDT","Third Party Deadline ","ThirdPartyDeadline","Date/Time by which the account owner must instruct directly another party, for example to provide documentation to an issuer agent."]
["UNCO","Unconditional Date/Time","UnconditionalDate","Date/time upon which the terms of the take-over become unconditional as to acceptances."]
["WUCO","Wholly Unconditional Date/Time","WhollyUnconditionalDate","Date/time at which all conditions, including regulatory, legal etc. pertaining to the take-over, have been met"]
["VALU","Value Date/Time","ValueDate","Date/time when calculating economic benefit for a cash amount"]
["XDTE","Ex-Dividend or Distribution Date/Time","ExDividendDate","Date/time as from which trading (including exchange and OTC trading) occurs on the underlying security without the benefit."]
["Rate","ISO 15022","ISO 20022","ISO Definition"]
["ADEX","Additional for Existing Securities","AdditionalQuantityForExistingSecurities","Quantity of additional securities for a given quantity of underlying securities where underlying securities are not exchanged or debited, for example, 1 for 1: 1 new equity credited for every 1 underlying equity = 2 resulting equities."]
["ADSR","Additional for Subscribed Resultant Securities ","AdditionalQuantityForSubscribedResultantSecurities","Quantity of additional intermediate securities/new equities awarded for a given quantity of securities derived from subscription."]
["ATAX","Additional Tax","AdditionalTax","Rate used for additional tax that cannot be categorised."]
["BIDI","Bid Interval Rate","BidInterval","Acceptable price increment used for submitting a bid."]
["CHAR","Charges/Fees","ChargesFees","Rate used to calculate the amount of the charges/fees that cannot be categorised."]
["DEVI","Declared Rate","DeclaredRate","Dividend or interest rate declared by the issuer."]
["EQUL","Equalisation Rate","EqualisationRate","The portion of the fund distribution which represents the average accrued income included in the purchase price for units bought during the account period."]
["ESOF","Early Solicitation Fee Rate","EarlySolicitationFeeRate","Cash rate made available, as an incentive, in addition to the solicitation fee, in order to encourage early participation in an offer."]
["EXCH","Exchange Rate","ForeignExchangeDetails","Exchange rate between the amount and the resulting amount."]
["FDIV","Final Dividend Rate","FinalDividendRate","Dividend is final."]
["FISC","Fiscal Stamp","FiscalStamp","Percentage of fiscal tax to apply."]
["FLFR","Fully Franked Rate","FullyFrankedRate","Rate resulting from a fully franked dividend paid by a company; rate includes tax credit for companies that have made sufficient tax payments during fiscal period."]
["GRSS","Gross Dividend Rate","GrossDividendRate","Cash dividend amount per equity before deductions or allowances have been made."]
["IDFX","Issuer Declared Exchange Rate","IssuerDeclaredExchangeRate","Exchange rate (provided by the issuer) between the dividend or interest rate in the paid currency and the declared dividend or interest rate."]
["INCE ","Third Party Incentive Rate","ThirdPartyIncentiveRate","Cash rate made available in an event in order to encourage participation in the offer. As information, Payment is made to a third party who has solicited an entity to take part in the offer."]
["INDX","Index Factor","IndexFactor","Public index rate applied to the amount paid to adjust it to inflation."]
["INTP","Interest Rate Used for Payment","InterestRateUsedForPayment","The actual interest rate used for the payment of the interest for the specified interest period."]
["INTR","Interest Rate","InterestRate","Annual rate of a financial instrument."]
["NETT","Net Dividend Rate ","NetDividendRate","Cash dividend amount per equity after deductions or allowances have been made."]
["NEWO","New to Old","NewToOld","Quantity of new securities for a given quantity of underlying securities, where the underlying securities will be exchanged or debited, for example, 2 for 1: 2 new equities credited for every 1 underlying equity debited = 2 resulting equities."]
["NRES","Non-Resident Rate","NonResidentRate","Rate per share to which a non-resident is entitled."]
["NWFC","Next Factor","NextFactor","Factor used to calculate the value of the outstanding principal of the financial instrument (for factored securities) that will be applicable after the redemption (factor) date."]
["OVEP","Maximum Allowed Oversubscription Rate","MaximumAllowedOversubscriptionRate","A maximum percentage of shares available through the over subscription privilege, usually a percentage of the basic subscription shares, for example, an account owner subscribing to 100 shares may over subscribe to a maximum of 50 additional shares when the over subscription maximum is 50%."]
["PDIV","Provisional Dividend Rate","ProvisionalDividendRate","Dividend is provisional."]
["PRFC ","Previous Factor","PreviousFactor","Factor used to calculate the value of the outstanding principal of the financial instrument (for factored securities) until the next redemption (factor) date."]
["PROR","Pro-Ration Rate","ProrationRate","Proportionate allocation used for the offer."]
["PTSC","Percentage Sought","PercentageSought","Percentage of securities the offeror/issuer will purchase or redeem under the terms of the event."]
["RATE","Applicable Rate","ApplicableRate","Rate applicable to the event announced, for example, redemption rate for a redemption event."]
["RDIS","Reinvestment Discount Rate to Market","ReinvestmentDiscountRateToMarket","Rate of discount for securities purchased through a reinvestment scheme as compared to the current market price of security"]
["RINR","Related Index Rate","RelatedIndex","Index rate related to the interest rate of the forthcoming interest payment."]
["RLOS","Realised Loss","RealisedLoss","For structured security issues where there is a set schedule of principal and interest payments for the life of the issue, this is the difference between the actual rate of the interest payment and the expected or scheduled rate of the interest payment. "]
["RSPR","Spread Rate","Spread","Margin allowed over or under a given rate."]
["RTUN","Intermediate Securities to Underlying","IntermediateSecuritiesToUnderlyingRatio","Quantity of intermediate securities awarded for a given quantity of underlying security."]
["SHRT","Interest Shortfall","InterestShortfall","For structured security issues where there is a set schedule of principal and interest payments for the life of the issue, this is the difference between the actual rate of the interest payment and the expected or scheduled rate of the interest payment."]
["SOFE","Solicitation Fee Rate","SolicitationFeeRate","Rate of the cash premium made available if the securities holder consents or participates to an event, for example consent fees or solicitation fee."]
["TAXC","Tax Credit Rate","TaxCreditRate","Amount of money per equity allocated as the result of a tax credit."]
["TAXE","Tax Related Rate","TaxRelatedRate","Percentage of the gross dividend rate on which tax must be paid."]
["TAXR","Withholding Tax Rate","WithholdingTaxRate","Percentage of a cash distribution that will be withheld by the tax authorities of the jurisdiction of the issuer, for which a relief at source and/or reclaim may be possible."]
["TDMT","Taxable Income Per Dividend/Share","TaxableIncomePerDividendShare","Amount included in the dividend/NAV that is identified as gains directly or indirectly derived from interest payments, for example, the scope of the EU Savings directive."]
["TRAT","Transformation Rate","TransformationRate","Rate used to determine the cash consideration split across outturn settlement transactions that are the result of a transformation of the parent transaction."]
["TRAX","Financial Transaction Tax Rate","Financial Transaction Tax Rate","Rate of financial transaction tax."]
["TXIN","Tax on Income","TaxOnIncome","Overall tax withheld at source by fund managers prior to considering the tax obligation of each unit holder."]
["TXPR","Tax on Profits","TaxOnProfits","Taxation applied on an amount clearly identified as capital profits, capital gains."]
["TXRC","Reclaim of Taxes Rate","TaxReclaimRate","Percentage of cash that was paid in excess of actual tax obligation and was reclaimed."]
["WAPA","Warrant Parity","WarrantParity","Provides the ratio between the quantity of warrants and the quantity of underlying securities."]
["WITF","Withholding of Foreign Tax","WithholdingOfForeignTax","Rate at which the income will be withheld by the jurisdiction to which the income was originally paid, for which relief at source and/or reclaim may be possible."]
["WITL","Second Level Tax","SecondLevelTax","Rate at which the income will be withheld by a jurisdiction other than the jurisdiction of the issuer’s country of tax incorporation, for which a relief at source and/or reclaim may be possible. It is levied in complement or offset of the withholding tax rate (TAXR) levied by the jurisdiction of the issuer’s tax domicile."]
["Price","ISO 15022","ISO 20022","ISO Definition"]
["CAVA","Cash Value for Tax","CashValueForTax","Cash value of resulting securities proceeds for tax calculation and/or reporting. "]
["CINL","Cash in Lieu of Securities Price","CashInLieuOfSharePrice","Cash disbursement in lieu of equities; usually in lieu of fractional quantity."]
["INDC","Indicative Price","IndicativePrice","Estimated price, for example, for valuation purposes."]
["ISSU","Issue Price","IssuePrice","Initial issue/valuation price of a resulting security under a corporate action."]
["MAXP","Maximum Price","MaximumPrice","Maximum or cap price at which a holder can bid, for example on a Dutch auction offer."]
["MINP","Minimum Price","MinimumPrice","Minimum or floor price at which a holder can bid, for example on a Dutch auction offer."]
["MRKT","Market Price","MarketPrice","Last reported/known price of a financial instrument in a market."]
["OFFR","Cash Price Per Product Received","GenericCashPriceReceivedPerProduct","Generic cash price received per product by the underlying security holder either as a percentage or an amount, for example, redemption price."]
["OSUB","Oversubscription Deposit","OverSubscriptionDepositPrice","Amount of money required per over-subscribed equity as defined by the issuer."]
["PRPP","Cash Price Per Product Paid","GenericCashPricePaidPerProduct","Generic cash price paid per product by the underlying security holder either as a percentage or an amount or a number of points above an index, for example, reinvestment price, strike price and exercise price."]
["Period","ISO 15022","ISO 20022","ISO Definition"]
["AREV","Account Servicer Revocability Period ","AccountServicerRevocabilityPeriod","Period during which the participant of the account servicer can revoke change or withdraw its instructions."]
["BLOK","Blocking Period","BlockingPeriod","Period during which the security is blocked."]
["BOCL","Book Closure Period","BookClosurePeriod","Period defining the last date on which shareholder registration will be accepted by the issuer and the date on which shareholder registration will resume."]
["CLCP","Claim Period","ClaimPeriod","Period assigned by the court in a class action. It determines the client's eligible transactions that will be included in the class action and used to determine the resulting entitlement."]
["CODS","Co-Depositories Suspension Period","CoDepositoriesSuspensionPeriod","Period during which the settlement activities at the co-depositories are suspended in order to stabilise the holdings at the CSD. "]
["CSPD","Compulsory Purchase Period","CompulsoryPurchasePeriod","Period during a take-over where any outstanding equity must be purchased by the take-over company."]
["DSBT","Depository Suspension Period for Book Entry Transfer","DepositorySuspensionPeriodForBookEntryTransfer","Period defining the last date for which book entry transfers will be accepted and the date on which the suspension will be released and book entry transfer processing will resume."]
["DSDA","Depository Suspension Period for Deposit at Agent","DepositorySuspensionPeriodForDepositAtAgent","Period defining the last date for which deposits, into nominee name, at the agent will be accepted and the date on which the suspension will be released and deposits at agent will resume."]
["DSDE","Depository Suspension Period for Deposit","DepositorySuspensionPeriodForDeposit","Period defining the last date for which deposits will be accepted and the date on which the suspension will be released and deposits will resume."]
["DSPL","Depository Suspension Period for Pledge","DepositorySuspensionPeriodForPledge","Period defining the last date for which pledges will be accepted and the date on which the suspension will be released and pledge processing will resume."]
["DSSE","Depository Suspension Period for Segregation","DepositorySuspensionPeriodForSegregation","Period defining the last date for which intra-position balances can be segregated and the date on which the suspension will be released and the ability to segregate intra-position balances will resume."]
["DSWA","Depository Suspension Period for Withdrawal at Agent","DepositorySuspensionPeriodForWithdrawalAtAgent","Period defining the last date for which withdrawals, from nominee name at the agent will be accepted and the date on which the suspension will be released and withdrawals at agent processing will resume."]
["DSWN","Depository Suspension Period for Withdrawal in Nominee Name","DepositorySuspensionPeriodForWithdrawalInNomineeName","Period defining the last date for which physical withdrawals in the nominee's name will be accepted and the date on which the suspension will be released and physical withdrawals in the nominee's name will resume."]
["DSWO","Depository Suspension Period for Withdrawal in Street Name on Outturn Security","DepositorySuspensionPeriodForWithdrawal","Period defining the last date on which withdrawal in street name requests on the outturn security will be accepted and the date on which the suspension will be released and withdrawal by transfer processing on the outturn security will resume."]
["DSWS","Depository Suspension Period for Withdrawal in Street Name","DepositorySuspensionPeriodForWithdrawalInStreetName","Period defining the last date on which withdrawal requests in street name's will be accepted on the event security and the date on which the suspension will be released and withdrawal in street name's processing on the event security will resume."]
["INPE","Interest Period","InterestPeriod","Period during which the interest rate has been applied."]
["PARL","Parallel Trading Period","ParallelTradingPeriod","Period during which both old and new equity may be traded simultaneously, for example, consolidation of equity or splitting of equity."]
["PRIC","Price Calculation Period","PriceCalculationPeriod","Period during which the price of a security is determined."]
["PWAL","Period of Action","ActionPeriod","Period during which the specified option, or all options of the event, remains valid, for example, offer period."]
["REVO","Revocability Period","RevocabilityPeriod","Period during which the shareholder can revoke, change or withdraw its instruction."]
["SPLP","Split Period","SplitPeriod","Period during which a physical certificate can be split."]
["SUSP","Suspension of Privilege","PrivilegeSuspensionPeriod","Period during which the privilege is not available, for example, this can happen whenever a meeting takes place or whenever a coupon payment is due."]
["TRDP","Trading Period","TradingPeriod","Period during which intermediate or outturn securities are tradable in a secondary market."]

{"sheet":"Complex Events","index":5,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6],[0,0,0,6]]}
["Complex Events"]
["Initiation by:","Issuer of Underlying Security",null,null,"Third Party","Holder"]
[null,"1 company\n(Issuer of underlying security)","Two or more companies\n(Issuer of underlying security)","In the terms of the underlying security",null,"Same security type","Resulting in a different security type"]
["MAND","EXOF\nCHAN + sub codes","MRGR","REDM, MCAL, PCAL, DRAW or CONV","TEND (e.g.squeeze out)"]
["CHOS","EXOF","MRGR","REDM (either cash or stock i.e. exchange in new securities)"]
["VOLU","BIDS\nEXOF",null,null,"TEND (cash and/or stock)\nNOOF (e.g. mini tender, third party offer)","CHAN + sub codes\nBPUT","CONV"]

{"sheet":"Redemption Matrix","index":6,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,2,1,8],[0,0,0,8],[1,0,1,1]]}
["Redemption Matrix"]
[null,null,"Distinguishing Characteristics"]
["Event","Event Definition","Full or Partial Redemption","Issuer Initiated","Holder Initiated","Change in Nominal Value","Factors Applied","Results in Securities Debit Movement","Results in Cash Credit Movement"]
["BPUT","Early redemption of a security at the election of the holder subject to the terms and condition of the issue with no reduction in nominal value .","Partial in regard to entire issue outstanding; holder may choose to put all or part of holding",null,"X","No","No","Yes","Yes"]
["CAPI","Increase of the current principal of a debt instrument without increasing the nominal value. It normally arises from the incorporation of due but paid interest into the principal. This is commonly done by increasing the pool factor value, e.g., capitalisation, and negative amortisation.","Neither","X",null,"No","Yes; uses the difference between two factors to calculate the principal increase","No","No"]
["DRAW","Redemption in part before the scheduled final maturity date of a security. Drawing is distinct from partial call since drawn bonds are chosen by lottery and with no reduction in nominal value.","Partial","X",null,"No","No","Yes","Yes"]
["MCAL","The redemption of an entire issue outstanding of securities, e.g., bonds, preferred equity, funds, by the issuer or its agent, e.g., asset manager, before final maturity.","Full","X",null,"No","No","Yes","Yes"]
["PCAL","Securities are redeemed in part before their scheduled final maturity date with reduction of the nominal value of the securities. The outstanding amount of securities will be reduced proportionally.","Partial","X",null,"Yes","No","Yes","Yes"]
["PRED","Securities are redeemed in part before their scheduled final maturity date without reduction of the nominal value of the securities. This is commonly done by pool factor reduction.","Partial","X",null,"No","Yes; uses the difference between two factors to calculate the principal reduction","No","Yes"]
["PRII","An event which consists of two components, the decrease of the amortized value of a pool factor security and an interest payment.","Partial","X",null,"No","Yes; uses the difference between two factors to calculate the principal reduction","No","Yes"]
["REDM*","The redemption of an entire issue outstanding of securities, e.g., bonds, preferred equity, funds, by the issuer or its agent, e.g., asset manager at final maturity.\n\n* Note that REDM/MCAL should also be used when making the final payment for a fixed income security that has paid-down in part during it's term. \nE.g. even though a pool factor security would partially redeem capital using the event PRED, the final payment should nonetheless be sent using REDM/MCAL to demonstrate that it is the final paydown on the security.","Full","X",null,"No","No","Yes","Yes"]
[null,"\n"]
["Legend"]

{"sheet":"Return of Capital Matrix","index":7,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,2,1,5]]}
["Return of Capital Matrix"]
[null,null,"Distinguishing Characteristics"]
["Event","Event Definition","Source of Capital","Nominal Value Change","Results in Securities Movement","Results in Cash Movement"]
["CAPD      ","Capital Distribution: The Corporate event pays shareholders an amount in cash issued from the Capital account. There is no reduction to the face value of a single share (or the share has no par value). The number of circulating shares remains unchanged.","Capital account of some form, but not the shares premium account/reserve","No","No","Yes"]
["CAPG","Capital Gains Distribution: Distribution of profits resulting from the sale of company assets, for example, Shareholders of Mutual Funds, Unit Trusts, or Sicavs are recipients of capital gains distributions which are often reinvested in additional shares of the fund.","Sale of company assets","No","No","Yes"]
["DECR","Decrease in Value: Reduction of face value of a single share or the value of fund assets. The number of circulating shares/units remains unchanged. This event may include a cash payout to holders.","Unspecified","Yes","No","Yes"]
["SHPR","Shares Premium Dividend: This corporate event pays shareholders an amount in cash issued from the shares premium reserve. It is similar to a dividend but with different tax implications.\nNote: In case distribution of shares is announced, the event should be handled as a mandatory stock dividend (DVSE) instead.","Shares premium account/reserve","No","No","Yes"]

{"sheet":"Distribution With options","index":8,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,0,3,4],[1,0,1,4]]}
[]
["Distribution With Options Table"]
["Note to NMPGs: "]
["Should you need to add or update information in the below table, please contact the CA SMPG working group co-chairs, Christine Strandberg or Bernard Lenelle."]
[]
["Country","1 Evnt"," 2 Events","Events Types Processed as 2 Events","Events Processed as 1 Event","Comments","Update Date"]
["AU","P",null,null,null,"Will be considered during the relevant phase of  the ISO20022 project.","Nov. 2013"]
["BE",null,"P"]
["CA","P","P"]
["CH",null,"P"]
["DE",null,null,null,null,"Moving from 1 to 2"]
["DK","P","P",null,null,"CSD runs as 2; Custodians as 1"]
["ES","P"]
["FI",null,"P","Rights issue (RHDI + EXRI + PARI), reverse rights offer (RHDI + BIDS + EXOF), split redemption (RHDI + EXOF)"]
["FR",null,"P",null,null,"Euroclear harmonisation has mandated the move to 2 from 2008"]
["GR","P"]
["ICSD",null,null,null,null,"N/A for Eurobonds"]
["JP",null,"P",null,null,"Rare to see 1 event"]
["MX",null,null,null,null,"To be addressed"]
["NL",null,"P"]
["NO",null,"P","Rights issue (RHDI + EXRI)"]
["PL",null,null,null,null,"To be addressed"]
["SE",null,"P","Rights issue (RHDI + EXRI + PARI), reverse rights offer (RHDI + BIDS + EXOF), split redemption (RHDI + EXOF - in addition an SPLF event is also performed)",null,"In 3 events in certain event types.","Dec. 2013"]
["SG",null,"P"]
["UK&IE",null,"P"]
["US","P"]
["ZA",null,"P","Rights Offers (RHDI and EXRI)\nDRIP",null,"Due to the introduction of Dividend Withholding Tax (DWT) DRIP events are processed as 2 events with separate timelines:-\n1. DRIP event with options to elect either the cash dividend (CASH) or a combination of the cash dividend and Letters of Allocation (CASE)\n2. Compulsory Conversion event\nIn the DRIP event shareholders who elect for the cash dividend will be taxed accordingly and credited  with the net cash dividend. However shareholders who elect the reinvestment option will be credited with the cash dividend and an unlisted Non-renounceable Letter of Allocation (LA) (interim security). The cash for reinvestment will be debited from the client's account and passed onto the DRIP agent to purchase shares. The LA is alloted to the extent of the net cash dividend being reinvested. The LA will then be compulsorily converted to ordinary shares in the announced ratio which will only be available after the maximum number of shares has been purchased with the reinvested funds.","Dec. 2013"]

{"sheet":"Record Date tracking","index":9,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,4],[3,0,3,4]]}
[]
["Record Date Usage Tracking"]
["Note to NMPGs: "]
["Should you need to add or update information in the below table, please contact the CA SMPG working group co-chairs, Christine Strandberg or Bernard Lenelle."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Updated since last version"]
[]
["Country","Record Date Driven Market ?","Record Date Events Supported","Exceptions (events) in the GG","Comments","Ex-Date (XDTE)","Date Entry Submitted or Affirmed"]
["AU","Yes","For all entitlement events: BIDS, BONU, DRIP, DVCA, DVOP, INTR, MEET, PRII, PRIO, RHTS, SOFF, SPLF, SPLR",null,"AUSTRALIA is a record date market, whereby entitlements are paid on the transactions traded prior to Ex Date and settled by the close of business on record date.","RDTE - 4d \n(business days)","May 2013"]
["BE","Yes",null,null,null,"RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["CA","Yes (effective Feb 20th 2012) ","DVSE, SOFF, SPLF, RHDI ",null,null,null,"February 2012"]
["CH","Yes",null,null,null,"RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["CN","Yes","Majority of the events except CHAN, SUSP, ACTV","CHAN, SUSP, ACTV","China is a record date market, whereby entitlements are paid on the basis of settled holding at close of business day on record date.\nEx-date is also disclosed by issuer.","A-share: RDTE +1d\nB-share: RDTE - 2d","May 2013"]
["DE","No",null,null,null,"Same as pay date","April 2012"]
["DK","Yes",null,null,null,"RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["ES","No",null,null,null,"Same as pay date"]
["FI","Yes",null,"Name change (EFFD used)","Finland is a record date market, whereby entitlements are paid on the\nbasis of settled holding at close of business on record date.","RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["FR","Yes",null,null,null," RDTE - 2d (for cash distribution only)\n RDTE + 1d (for secu distribution)"]
["GR","Yes","In all corporate events in our market such as dividends, drips, rights issues, bonuses, general meetings etc.",null,null,"RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["HK","Yes","All","For the folloiwng events EFFD is used: Name Change, change Board lot size, Mandatory Exchange, Reverse Stock Split, Stock Split","In HK market all key dates are provided by the Company. The ex date must be 1 day before the record date. ","RDTE - 1","May 2013"]
["ID","Yes","Majotiry, eccept for some events eg. EXER, EXWA, TEND",null,"Ex date is only applied for stock. Settlement cycle T+3. Bonds only use \"book close date\" as basis for entillement.","RDTE - 2d \n(for stock only)","May 2013"]
["IL","Yes",null,null,"The Record date is determined by the issuer.\nThe Ex date is, in most cases, equal to the Record date (XDTE = RDTE + 0). \nThis means that if an investor purchases (Trade Date) the security today and today is also the Record date, then since the settlement in our market is on T+1, he will not be entitled to the income tomorrow (on the SD), because by then it is the ex date. \nHowever, if the trade settles on the record date, the investor is entitled to the income event.\nIn cases where the RD is on Friday, the Ex Date moves to the following Sunday.","See comments","August 2012"]
["IN","Yes","All Corporate Events like Dividend, Rights, Bonus, Conversion etc. For Postal Ballots (CONS Events) we have a concept of Reckoning date where client holding shares as on reckoning date are eligible to vote.","Few Meeting events where share holder as on meeting date are eligible to participate and vote. And Few Open Offers where clients can offer shares if they are holding shares at the time of bid submission","Ex Dates are declared by respective Stock Exchanges based on Record date declared by the company. In India where settlement cycle is T+2, generally ex date is Record date-1 Trading Day","RDTE-1d \n(Trading Day)","May 2013"]
[" IT","Yes",null,null,null,"RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["JP","Yes","BONU, DVCA, INTR, MEET,  XMET, MRGR, SPLF, SPLR, PRED, REDM, RHDI, OTHR,\n","BIDS, TEND, CHAN,SMAL, DLST,  ODLT, CLS ,CONV, EXWA","The RDTE is determined by the issuer. The XDTE is 2 business days prior the record date. However Japan is record date driven market, so client entitlement will determined their record date settled position on their account. ","RDTE - 2d \n(business day)","May 2013"]
["KR","Yes","Majority of the events except TEND, NCH and related event for Bond such as INTR, REDM",null,"The Ex date is, in most cases, one day before the Record date.\nFor Bond related event,not refering for the record date since in order to receive coupon interest and redemption payment, shareholder should have to hold the such bond one day before the payment date. ","RDTE - 1d","May 2013"]
["LU","Yes",null,null,null,"RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["MY","Yes","For all events with entitlement except TEND, EXWA, CHAN.\nFor Fixed Income/Bonds - Interest and Redemption events where eligibility is determine 1 day before payment date/maturity date.",null,"For meetings, the eligibility is determine on record of depositor dates,\nEx- date is used to determine entitlements by the market and is one clear day before the book close date.  Book close date is defined as the date that the company closes its register of members either as a legal requirement or to decide benefits due to a member as at a particular date. ","Book close date - 1d","May 2013"]
["NL","Yes",null,null,"In the Dutch market all key dates are provided by the Issuer/agent to the CSD. The sequence between ex and record date is based at the settlement cycle. ","RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["NO","Yes","Majority of the events except CHAN, DECR, INCR, BRUP, some of TEND ",null,null,"RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d","2014-09-01"]
["PH","Yes","DVCA, DVSE, EXRI, MEET (Annual Stockholders' Meeting)",null,"Entitlement calculation occurs on RDTE - 1d (end of day) in Philippines market","RDTE - 3d \n(working days)","May 2013"]
["PL","?"]
["RU","Yes","BIDS VOLU, BONU MAND, CAPG MAND, DECR MAND, DSCL MAND or VOLU, DVCA MAND, DVSE MAND, EXOF MAND, INCR MAND, INTR MAND, MEET VOLU, XMET VOLU, OMET VOLU, MRGR MAND, PARI PCAL (not always RDTE is present), PRED MAND, PRIO VOLU (not always RDTE is present), SOFF MAND, SPLF MAND, SPLR MAND, TEND (not always RDTE is present)",null,"In principle we support Record date (for meetings, dividends and interest payments etc.) but not always for some corporate events we may have a period of time that is why we mentionned that we will indicate UKWN (if Record date will be mandatory – BIDS VOLU, BONU MAND etc ).",null,"February 2012"]
["SE","Yes","All MAND events without options with movements, eg. income events, splits, bonus issues, rights distributions (except for lapse of worthless securities)",null,null,"RDTE - 1d","December 2015"]
["SG","Yes","BONU,DECR, CAPD, DVCA, DLST, DRIP, DVOP, INTR, LIQU, MRGR, RHDI, SPLR, DVSE, SOFF, ",null,"In Singapore, Ex date is not indicated in the company's announcement but is usually calculated two working days before record date.","RDTE - 2d \n(see comment)","May 2013"]
["TH","Yes","Dividend, Bonus Issue, Rights Issue, Proxy Voting, Interest, Redemption, Last exercise of warrant",null,null,"RDTE - 2d","May 2013"]
["TW","Yes","BONU, DECR, CAPD, DVCA, INTR, RHDI, DVSE, SOFF, DVCA, DRIP, DVOP, LIQU, SPLR, MRGR, OTHR, SPLF, EXWA, PCAL, REDM, CONS, MEET, XMET",null,null,"RDTE - 1d","May 2013"]
["UK&IE"," Yes","BIDS,  BONU, CAPD, CAPG, CONV, DECR, DRAW, DRIP, DTCH, DVCA, DVOP, DVSE, EXOF, INCR, INTR, LIQU, MCAL, MRGR, PCAL, PRIO, REDM, RHDI, SHPR, SOFF, SPLF, SPLR",null,null,"RDTE - 2d until October 2014.\nFrom October 6, 2014: RDTE - 1d (for cash only)","2014-09-01"]
["US","Yes",null,"For the folloiwng events EFFD is used: Name Change, Merger, Mandatory Conversion, Mandatory Exchange, Reverse Split, Final Maturity, Maturity Extension","For Lottery and Partial Redemption Events, Record Date represents Publication Date in the market","RDTE - 2d","January 2013"]
["VN","Yes","Dividend, Stock Dividend, Bonus, Conversion, Rights Distribution",null,"Some events have no RDTE such as: Interest payment, Redemption (as settlement cycle for BOND in Vietnam is T+1).\nXDTE will not be infomed in the Announcement received from Vietnam Securities Depository. It can be usually calculated base on trading date schedule from stock exchange.","RDTE - 2d","May 2013"]
["XS","Yes",null,"No Exceptions",null,"NO (Due to Bonds only) ","May 2012"]
["ZA"," Yes","All","For the folloiwng events EFFD is used: Name Change, Merger, Mandatory Conversion, Mandatory Exchange, Forward Stock Split, Reverse Split, Final Maturity","South Africa is a record date market, whereby entitlements are computed and paid on the\nsettled position as at close of business on record date. ","RDTE - 4d","February 2014"]

{"sheet":"InterestPeriod","index":10,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
["Interest Period INPE"]
["Country","End Date Inclusive/Exclusive\n(I/E)","Comments"]
["AU"]
["BE","E"]
["CA"]
["CH","I"]
["CN"]
["DE","I"]
["DK","To check"]
["FI","I or E","Can change according to terms and conditions set for the event."]
["FR","I"]
["GR"]
["HK","I"]
["ID"]
["IL"]
["IN"]
[" IT","E"]
["JP","I or E","It may be exclusive if it is stated in the issuing documentation (more rare cases). End day exclusive is applicable for deposits into accounts at banks."]
["KR"]
["LU","n/a"]
["MY","E"]
["NL","E"]
["NO","E"]
["PH"]
["PL","I"]
["RU","I"]
["SE","I"]
["SG","E"]
["SP","E"]
["TH"]
["TW"]
["UK&IE","E","Always from pay date to pay date in the UK"]
["US","E"]
["VN"]
["XS","E"]
["ZA","I"]

{"sheet":"Change Log","index":11,"n_rows":91,"n_cols":4,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["SMPG CA Global Market Practice Part 2 - Change Log"]
["Version","Publication Date","Updates description"]
["v0_9",200509,"In Complex:\nAdd FR comment regarding the decision to cancel the EXOP code used in France for the loyalty bonus share plans and further to a conversation I [J-PK] had with Bernard, it is agreed that the proposal made to the FR NMPG is to use CHAN//BERE for this type of event. I hope they will be not too angry !!!"]
[]
["v1_0",200510,"Reposition EIG Compiled, Complex and Change Log worksheets to the start of the spreadsheet for convenience"]
[]
[null,null,"Following the telco on 20050922 update events from DVSC to ODLT"]
[]
[null,null,"Ensure that where applicable the SR2006 definition is included in the description.  The default is the SR2005 definition"]
[]
["v1_1",200510,"Updates to Global Grid (EIG Compiled worksheet) discussed at SMPG CA WG telco 6th October 2005, events from OTHR to WTRC"]
[]
["v1_2",200511,"Comprehensive updates from global SMPG WG sessions 17th-19th October 2005.\n\nCompletion of global grid and harmonisation of country comments.\nReposition complex events, all events in alphabetic order.\nProposed 2007 changes extracted and in separate worksheet"]
["v1_2_1","unpublished review version","Inclusion of country specific review comments from  BE, DE, DK, FI, FR, SE, UK&IE.  \nDeletion of the  worksheets for BE, DE, DK, FR, SE, UK&IE\n\nAddition of CONV as a possible event type in complex worksheet for mandatory events initiated by the issuer which are in the terms of the underlying security"]
["v1_2_2","unpublished review version","Inclusion of country specific review comments from  LU.  \nDeletion of the  worksheets for LU"]
["v1_2_3","unpublished review version","Add additional row for ODLT and UK&IE comment on CAEV//ODLT CAMV//MAND\nAlso "]
["v1_2_4","unpublished review version","Inclusion of country specific review comments for Eurobonds Market (ICSD)\nInclusion of country specific review comments from  JP.  \nDeletion of the  worksheets for JP"]
["v1_2_5","unpublished review version","Inclusion of country specific review comments from  BE "]
["v1_2_6","unpublished review version","UK&IE comment on CAEV//ODLT CAMV//CHOS amended from MAND (as > 1 option)"]
["v1_2_7","unpublished review version","Intro updated.  Country columns in alphabetic order\nInclusion of county specifc review comments from:\nZA, AU, additional material from the US"]
["v1_3",200601,"v1_2_7 published as v1_3"]
["v1_3_1",200601,"Update redemption events with SR2006 definition alignment"]
["v4_0",200609,"SMPG version numbering - same as v1_3_1.  Renamed \n<Event Interpretation Grid SR2006 v4_0.xls> \nto indicate implementation for SR2006 as actioned at SMPG global meeting, April 2006, see minutes section CA06."]
["V4_1",200612,"1) Remove event types deleted in SR2006 - CAEV//CPNR INDE, NAME, ODLS, SCOP\n2) Updates to US specifics:\nN/A applied to ACTV, ATTI, BONU, CERT, COOP, DLST, DSCL, DVSC, INCR, PARI, REDO, SHPR, SUSP.\n3) PUTT replaced by CASH in ZA column for MRGR\n4) PUTT replaced by SECU in ZA column for DLST\n5) PUTT replaced by CASH for US DTCH where tender is at a specified price\n6) Clarification from AU of CAEV//DRIP and CAEV//DVOP, including removal of CAOP//DRIP from AU CAEV//DVOP, and CAOP//BSPL used with CAEV//DVOP not CAEV//DRIP\n7) CAEV//BIDS may also be CHOS in UK&IE column - clears agenda item CA85\n8) In BE column for CAEV//DVSE and SOFF CAMV//CHOS added with CAOP//SLLE, BUYA, EXER, SECU and LAPS 'used when rights available'\n9) Remove references to SR2005 definitions\n10) Maintenance of contents of 'SR2007 CRs' work sheet"]
["V4_2","unpublished review version","SR2007 Updates:\n1) Spurious CH and NO worksheets deleted.\n2) Definition amendments: BPUT, CAPG, CONS, DECR, DETI, DRAW, DRIP, DVCA, DVOP, EXWA, INCR, MRGR, OTHR, PARI, PCAL, SOFF, \n3) Event CAEV//EXOP deleted\n4) Option types CAOP//QINV and NOQU added\n5) Note added to the 'complex' work sheet regarding SMPG Agenda Item CA99 CASE Option Where CASH and SECU Ratio Not  Announced"]
["V4_3","unpublished review version","1) Inclusion of DvE Document in separate worksheets, rename spreadsheet to include DvE <DvE Analysis SR2007 20072803 v1.0.doc>"]
["V4_4","unpublished review version","1) AU comment on ACTV preceded by n/a\n2) Intro explanation on MAND SECU and MAND CASH reworded\n3) CAEV//PRED MAND - global and country specific entries copied from PCAL MAND - NMPGs to affirm, especially US on whether CHOS row required.\n4) BIDS row tidied up for FR and SE VOLU entries\n5) UK&IE entry for BIDS and CHOS has CASH added as option rather than no entry (clarification)\n6) All occurences of SLLE and BUYA in optional column now in red\n7) 22F::CAEV// event type moved to separate column\n8) Notes added to the introduction on the use of CAEV, CAMV and CAOP, and also the global grid and country columns\n"]
["v4_5","unpublished review version","1) Addition of worksheet holding market status on \"Rights - One Event or Two?\"\n2) Removal of worksheet 'SR2007-8 CRs'\n3) Publication information added to change log"]
["v4_6",200707,"1) Complex events referred to by description first and CAEV code second\nSundry 'Tidy Up' changes, some of which require NMPG input.\n2) FR entry for BONU - colour of CHOS changed from red to black; FR to affirm that SLLE and BUYA and LAPS are possible with the BIDS CHOS event\n3) In US entry for BRUP, MAND entered on every option row where it applies 9now explicit rather than implicit)\n4) CHAN - global grid default removed from AU, ICSD and ZA entries, where it is repeated\n5) SMPG to consider relocating the text in the definition cell to the global document\n6) AU to clarify if 'not defined' means n/a or rare\n7) CONV - 'maybe' removed from the definition commentary - now direct, ie \"MAND when initaited by the issuer\" not \"Maybe MAND when initaited by the issuer\"\n8) CONV - in FR CAMV column 'MAND' and 'VOLU' removed as it is a repition of the global grid\n9) DECR - DK, FI, NO, SE to clarify if MAND CASH is possible\n10) DECR - ES and UK&IE entries on MAND moved up one row to correspond with MAND on the global grid\n11) DECR - n/a added to FR comments\n12) DECR - only MAND possible, empty row deleted\n13) DFLT - global grid option entry of 'n/a' changed to 'no options'\n14) DLST - global grid option entry of pace changed to 'no options'\n15) DLST - ZA entry uses SECU, clarification required from ZA \nis a no option version of DLST possible in ZA?\n16) DRIP - second row added for VOLU (eg ES) as global default is CHOS"]
["v4_7","unpublished review version","1) reference to EDVO and IBBO option codes removed from the Intro paragraph beginning \"However, note the CAOP usage rule –\".  These two codes were deleted and the usage rule amended in SR2006\nFurther consistency amendments\n2) Main change is reformat of CAEV//REDM rows so that CAMV//MAND and CHOS are on separate rows, otherwise there was an inconsistency with all other events.  Markets with specifics to check their entry: AU (especially CHOS and SECU combination), CH, FR, Eurobond, JP, UK&IE\n3) EXCH - FR comment moved to comment box, global grid default removed from ZA entries, where it is repeated\n4) EXWA - FI MAND CASH moved to third row\n5) INCR - second redundant MAND row removed\n6) LIQU - MAND added for clarity in the AU occurrence of OTHR.  ZA to confirm if MAND CASH is only option type possible in ZA\n7) MCAL - global grid default removed from US entry where it is repeated\n8) MEET - VOLU removed from FI entry where it repeats global grid\n9) MRGR - global grid default removed from AU entry where it is repeated Clarification requested from AU - are CHOS and VOLU not possible for the MEET event?\n10) PPMT - MAND added for clarity for the AU event type occurrences.  Similar ffor CH\n11) RHTS - SE comment moved to comment cell and SLLE removed as repeats global grid.  ZA to clarify that VOLU never used, instead RHDI and EXRI are used\n12) TEND - US to clarify if CTEN and CONN are only option types allowed or are additional event types.\nAlso ZA to VOLU never occurs, and confirm that MAND  CASH and CASE are not allowed\n13) Amendment to EXTM, amendment to CHOS comment and addition of MAND SECU when securities are exchanged.  Clears SMPG agenda item CA96\n"]
["v4_8","200709\nin Boston folder\npublished review version","1) includes n/a updates and additional / restricted CAOP usage clarification for UK&IE column\n"]
["v4_9","200710\ndraft folder\npublished review version","1) UK&IE - corrected CASH usage clarification for CAEV//DECR CAMV//MAND\nand clarification of CAOPs for CAEV//MRGR CAMV//CHOS\n2) Global - CAEV//CPST confirmed deletion requested for SR2008\n3) Global - CAEV//EXTM CAMV//VOLU separate row added for this combination for clarification - it occurs in the Eurobond market and had been documented in the 'CHOS' row\n4) AT - columns added including n/a updates and additional / restricted CAOP usage clarification.  Note that additional row required for CAEV//DVOP CAMV//VOLU\n"]
["v4_10",null,"This version contains the same business information as version v4_9.\nThe consistency of the information has been improved with the aim that country market practice is explicit rather then inferred.\nThe principles of these improvments are as follows:\n1) addition of a CAMV column adjacent to the CAEV column.  This contains the CAMV code used for the row and allows distinction between the case where the CAMV code is used by the global grid and the case where the CAMV is not used by the global grid, but is used a market(s) as a national MP.  No entry for the CAMV in the global grid column has been replaced by 'n/a' indicating that the use of the CAEV + CAMV combination is not global market practice\nNoted that no market uses a CAMV code for CAEV//COOP (?!)"]
["v4_10","change details continued","2) The 'n/a' indication that a CAEV + CAMV does not take place in a market is moved to the CAMV column for the market from the comments column, this allows the table to be read without access to text for validation"]
["v4_10","change details continued","3) In previous versions of the EIG the non-applicability ('n/a') of an event in a market was shown in only the first CAMV for that event (CAEV).  If any other CAMV codes were possible, the national entry would still be blank.  This may be misinterpreted as defaulting to the global grid.  Thus 'n/a' has been applied to every row (CAEV + CAMV combination) where 'n/a' has already been entered for the first CAEV + CAMV combination.  In this working version any new entries derived by SWIFTStandards are shown with a pale yellow background until they have been verified by the market concerned.  \nNote the marking for CAEV//OTHR - global grid (SMPG) recommendation is not to use - so queried whether 'n/a' should be the notation for markets.\nAny row where there is no global grid entry (that is, there is a national specific use somewhere) has been set to 'n/a' for markets with a previously blank entry.","a pale yellow background"]
["v4_10","change details continued","4) Where a market specific practice is used for a CAEV + CAMV combination, ALL the options (CAOP) possible are documented.  This removes the need to refer to the comment box to determine if the options are in addition to the global grid options or replace the global grid options."]
["v4_10","change details continued","5) Update to the Intro worksheet, now renamed 'READ ME'. "]
["V4_11","unpublished review version","1) ICSD columns deleted (email from Bernard Lenelle 20th Novemeber 2007)"]
["V4_11","unpublished review version","2) UK&IE column updates (NMPG meetings November and December 2007):\n* CAEV//CPST CAMV//MAND confirmed n/a correct \n* CAEV//DTCH comments added: record date is used; UK&IE market will harmonise with US with the exception of the format of the evnent from Euroclear UK & Ireland\n* CAEV//EXRI with CAOP//NOAC default to global grid, add comment that NOAC offered by account servicers only, and not by market data providers and issuers\n* CAEV//EXTM CAMV//VOLU confirmed n/a correct\n* CAEV//OTHR confirmed n/a correct\n* CAEV//RHTS confirmed n/a correct\n* CAEV//PRIO CAMV//VOLU use with CAOP//EXER OVER and BUYA now specifc to UK&IE market and removed from global grid (see SMPG telco 20071206 minutes), comment added on usage in UK&IE market."]
["V4_11","unpublished review version","3) US column updates (email from Sonda Pimental 27th November 2007):\n* CAEV//LIQU CAMV//MAND option types CASH and SECU added to US column as the additional global default of CASE does not occur in the US market\n* the following events confirmed as not applicable (n/a) in the US market: installmemt call CAEV//PPMT; CAEV//PRED; CAEV//SMAL"]
["V4_11","unpublished review version","4) Sundry consistency changes:\n* MAND added to AT column for CHAN\n* VOLU added to AT column for EXOF\n* VOLU added to AT column for EXWA\n* CHOS added to global grid for MCAL\n* CHOS added to AU column for REDM\n* VOLU added to AU column for EXOF\n* CHOS added to AU column for DRIP\n* CHOS added to BE column for DVCA\n* VOLU added to BE column for MEET\n* CHOS added to BE column for MRGR\n* CHOS added to CH column for REDM\n* VOLUadded to DE column for MEET\n* CHOS added to DE column for MRGR\n* VOLU added to DK column for MEET\n* MAND added to ES column (twice) for DECR\n*  VOLU added to ES column for EXOF\n* VOLU added to ES column for MEET\n* n/a added to FI column for MEET\n* MAND added to FR column (twice) for CONV \n* VOLU added to FR column for CONV\n* CHOS added to Eurobond Market column for REDM\n* CHOS added to JP column for REDM\n* n/a added to NO column for CONS\n* VOLU added to NO column for MEET\n* VOLU added to SE column for MEET\n* MAND added to UK&IE column (thrice) for DECR\n* MAND added to UK&IE column (twice) for MCAL\n* MAND added to US column (twice) for CONV\n* VOLU added to US column for CONV\n* VOLU added to US column for MEET"]
["v4_11","unpublished review version","5) Amendments to READ ME to explain the cells shaded yelllow"]
["v4_12",20080229,"1) UK&IE column, CAEV//CONV CAMV//VOLU, CAOP//CASH option possible when redemption also offered in the conversion event (UK&IE CA MPG meeting 13th December 2007)\n2) CAEV//WRTC corrected to CAEV//WTRC"]
["v4_13","unpublished review version","1) DvE Dates COAP available only in sequence D of MT 564\n2) DvE Dates EXCR removed from the MT 564 in SR2007\n3) DvE Dates MATU and EXPI availibility in sequences B1 and E1a removed - FIA sequence excluded from DvE tables\n4) DvE Rates INTR availibility in sequences B1 and E1a removed - FIA sequence excluded from DvE tables\n5) DvE Price MRKT, OFFR availability in E2 added, note no change to guideline placement\n6) DvE Date EXPI N/A removed from guideline placement for MT 566\n7) EIG Compiled US CAEV//MRGR  CAMV//CHOS should be 'global grid' of CAOP//CASE SECU plus CONN and NOAC\n8) DvE Date POST comments relating to MT 564 moved from guideline placement to comments column.  MT 566 comments removed as posting date applies to any posting, not just that of intermediate securities\n9) DvE Period PRIC guideline placement \"D or E\" amended to \"D, E\" as the period may be present for both underlying and outturn security\n10) DvE Period TRDP guideline placement for MT566 from 'N/A, N/A' to 'N/A'  as no intermediate securities sequence in MT 566\n11) CAEV//EXOF CAMV//VOLU for ES, typo corrected 'VOLU' substituted for 'EXOF'\n12) DvE Intro the equivalent sequences in the MT 566 are explicitly in scope (first paragraph)\n13) DvE Intro sequence C of MT 564 (intermediate securities) explicitly in scope and noted that there is no equivalent sequence in the MT 566 (first paragraph)\n14) DvE Intro FIA sequences B1, D1a and D2b in the MT 566 explicitly out of scope (last paragraph)\n15) DvE throughout, for clarity 'N/A' removed from MT 566 where field appears in seq C of MT 564 - there is no equivalent in MT 566 therefore 'N/A' is not logical (captain): Period SEAD, Rate RTUN"]
["v4_13","unpublished review version","16) BE comments and amendments in the EIG Compiled worksheet (email from Charles Boniver, national convenor, 25th February 2008).  No cells shaded light yellow remain.  Changes:\n* CAEV//ACTV n/a + comment added\n* CAEV//ATTI - comment added\n* CAEV//BONU CAMV//MAND add CAOP//CASH\n* CAEV//CAPG CAMV//MAND add CAOP//SECU\n* CAEV//CONV CAMV//MAND add CAOP//CASE \n* CAEV//CONV CAMV//VOLU add CAOP//CASE\n* CAEV//CONV CAMV//CHOS add CAOP//SECU CAOP//CASE\n* CAEV//DECR CAMV//MAND add CAOP//SECU\n* CAEV//DLST n/a + comment added\n* CAEV//DVCA CAMV//CHOS comment added\n* CAEV//DVOP CAMV//CHOS add CAOP//SLLE CAOP//BUYA + comment\n* CAEV//EXRI - comment added\n* CAEV//EXTM CAMV//MAND \"no options\" is the only option - CAOP//SECU not supported in BE market\n* CAEV//INTR CAMV//MAND add CAOP//SECU\n* CAEV//INTR CAMV//VOLU add CAOP//SECU CAOP//CASH\n* CAEV//MCAL CAMV//CHOS CAOP//CASH added for currency option\n* CAEV//MRGR CAMV//MAND CAOP//CASH added\n* CAMV//MRGR CAMV//CHOS CAOP//CASH and NOAC added\n* CAEV//OTHR possible in BE market\n* CAEV//REMK - comment added\n* CAEV//RHDI CAMV//MAND added using global values }  BE entry in Rights \n* CAEV//RHTS 'n/a' in BE market                                  }  worksheet updated\n* CAEV//SMAL  'n/a' in BE market\n* CAEV//SOFF CAMV//MAND CAOP//CASE added\n* CAEV//SPLR CAMV//CHOS CAOP//SECU added\n* CAEV//SUSP  'n/a' in BE market\n* CAEV//TEND CAMV//MAND only option is CAOP//CASH\n"]
["v4_13","unpublished review version","17) Headers now include country name"]
["v4_13","unpublished review version","18) UK&IE CAEV//TEND CAMV//MAND n/a and CAMV//CHOS used for squeeze out.  End date of period CSPD used to indicate Legal Expiry Date\n19) AU CAEV//EXOF CAMV//VOLU remove entry of EXWA in CAOP column"]
["v4_13","unpublished review version","20) ES comments and amendments in the EIG Compiled worksheet (email from Carlos del Barrio, national convenor, 8th April 2008)  No cells shaded light yellow remain.  Changes:\n* CAEV//CERT now n/a \n* CAEV//CHAN CAMV//VOLU now n/a \n* CAEV//COOP now n/a \n* CAEV//DECR comments removed \n* CAEV//DETI CAMV//MAND CAMV//VOLU now n/a \n* CAEV//DTCH now n/a \n* CAEV//DVSC now n/a  \n* CAEV//PDEF now n/a\n* CAEV//PINK now n/a\n* CAEV//PLAC CAMV//MAND now n/a\n* CAEV//PPMT CAMV//CHOS now n/a\n* CAEV//REMK now n/a\n* CAEV//SMAL now n/a"]
["V4_14",20080422,"Published as the last SR2007 version, further versions will be on SR2008"]
["SR2008\nv4_01","unpublished review version","First version for SR2008\n1) Further ES comment in the EIG Compiled worksheet (email from Carlos del Barrio, national convenor, 30th April 2008):  CAEV//DECR options removed, now defaults to global grid.\n2) SR2008 changes in the EIG Compiled worksheet:\n* CAEV//CPST event deleted \n* READ ME work sheet amended so that shading event light green indicates proposed deletion in SR2009 - no events so far and shading greu indicates new events for SR2008\n* CAEV//PRED no longer shaded light grey\n* CAEV//CAPI added and shaded light grey, initially n/a in all markets except LU who requested the event\n* CAEV//EXOF definition amended\n* CAEV//MCAL definition amended\n* CAEV//REDM definition amended\n* CAEV//REDO definition amended\n3) SR2008 changes in the EIG Compiled worksheet:\n* CAOP codes deleted - no impact on EIG: 144A, ATCH, BEAR, DETH, REGD, REGS, \n* CAOP code CONV deleted from US column for CAEV//DRAW CAMV//CHOS.  Substitute required, SECU used.  Is this correct? NMPG to confirm.\n* CAOP code CONV deleted from FR column for CAEV//MCAL CAMV//CHOS.  SECU substituted.  Is this correct? NMPG to confirm.\n* CAOP code CONV deleted from JP column for CAEV//MCAL CAMV//CHOS.  SECU substituted.  Is this correct? NMPG to confirm.\n* CAOP code CONV deleted from GB&IE column for CAEV//MCAL CAMV//MAND.  SECU substituted.  Is this correct? NMPG revision at meeting 15th May 2008 - CAMV//MAND defaults to global grid, CAMV//CHOS added with CASH and SECU.\n* CAOP code CONV deleted from US column for CAEV//MCAL CAMV//CHOS.  SECU substituted.  Is this correct? NMPG to confirm.\n* CAOP code CONV deleted from AT column for CAEV//MRGR CAMV//MAND.  SECU substituted.  Is this correct? NMPG to confirm.\n* CAOP code CONV deleted from US column for CAEV//PCAL CAMV//CHOS.  Any substitute required, eg SECU? NMPG to confirm.\n* CAOP code CONV deleted from AU column for CAEV//PPMT CAMV//MAND.  Any substitute required, eg SECU? NMPG to confirm.\n"]
["SR2008\nv4_01","unpublished review version","4) SR2008 changes in the DvE Dates worksheet:\n* Add ECPD, GUPA, LAPD, OAPD, SXDT\n* Amend description of CVPR\n* Placement of UNCO in E1 removed\n5) SR2008 changes in the DvE Periods worksheet: none required\n6) SR2008 changes in the DvE Rates worksheet: none required\n7) SR2008 changes in the DvE Prices worksheet: none required\n8) Redemption Matrix worksheet added\n9) Redemption matrix events colour coded gold in EIG compiled worksheet and colour notated in READ ME worksheet\n10) Lenghthy cross-reference from EIG Compiled CAEV cell to complex worksheet removed as worksheet tab is now coloured\n"]
["SR2008\nv4_02","published as first SR2008 version May 2008","1) Rate & Amount worksheet SR2009 added\n2) DvE worksheets amended to include SMPG change request details for SR2009\n3) DvE Dates worksheet updated to include review comments from SMPG meeting April 2008 (Paris)\nDvE Dates DIVR guideline placement E1 in MT 564 and D1 in MT 566\nDvE Dates EARL guideline placement E1, E2 in MT 564 and D1, D2 in MT 566\nDvE Dates FXDT guideline placement E2 in MT 564 and D2 in MT 566\nDvE Dates PAYD guideline placement E1, E2 in MT 564 and D1, D2 in MT 566\n4) DvE Periods worksheet updated to include review comments from SMPG meeting April 2008 (Paris)\nDVE Periods PWAL guideline placement E in MT 564 and D in MT 566\nDVE Periods TRDP guideline placement C, E1 in MT 564 and N/A in MT 566\n5) DvE Rates worksheet updated to include review comments from SMPG meeting April 2008 (Paris)\nDVE Rates ADEX guideline placement E1 in MT 564 and D1 in MT 566\nDVE Rates CHAR guideline placement E in MT 564 and D in MT 566\nDVE Rates EXCH guideline placement E2 in MT 564 and D2 in MT 566\nDVE Rates NEWO guideline placement E1 in MT 564 and D1 in MT 566\nDVE Rates NWRT guideline placement E1 in MT 564 and D1 in MT 566\nDVE Rates RDIS guideline placement D in MT 564 and C in MT 566\n6) DvE Prices worksheet updated to include review comments from SMPG meeting April 2008 (Paris)\nDVE Prices INDC guideline placement C and E1 in MT 564 and D1 in MT 566\nDVE Prices MRKT guideline placement E1 in MT 564 and D1 in MT 566\nDVE Prices OFFR guideline placement E, E2 in MT 564 and D, D2 in MT 566"]
["SR2008\nv4_03","Amendments to DvE sheets following SMPG telco on 20/05/2008","1) Amended CR for AVAL Date\n2) Provided more details for FDDT date CR\n3) Changed ADSR CR from \"Remove from Standards in SR2009\" to \"Remove from C, D and E\" for MT564 and \"Remove from C and D\" for MT566\n4) Changes ISSU CR from \"Remove from Standards in SR2009\" to \"Remove from D,E and E2\" for MT564 and \"Remove from C, D and D2\" for MT566 + Add definition amendment proposal.\n5) Sundry corrections (also made to SR2007 version)\n* EIG Complied US column CAEV//EXOF CAMV//VOLU add options CASH, CASE, SECU\n* EIG Complied US column CAEV//TEND CAMV//VOLU add options CASH, CASE, SECU, NOAC\n* EIG Complied JP column CAEV//TEND CAMV//VOLU add options CASH, CASE, SECU\n* EIG Complied ES column CAEV//MEET/CMET/XMET/OMET CAMV//VOLU add options CONN, CONY, ABST, NOAC, PROX, SPLI\n6) Rights worksheet - ES row amended - \"Almost always run as 1 event ...\""]
["SR2008\nv4_04","Slight reorganisation of the documents.\nPublished 200806","1) Reordering of the different tabs, additional material in READ ME including a note on versions\n2) Creation of an \"DvE SR 2009\" tab that includes all the amendments done to the DvE spreadsheet since the Paris meeting in April 2008 (including change of placement guidelines and change requests to be implemented in SR2009). \nFor details of the changes please see change log for v4_02, items 2 to 6 and change  for v4_03, items 1 to 4.\n3) The DvE tabs only include the placement guidelines and change requests to take into account for SR2008.\n4) EIG Compiled, ES market CAEV//EXOF  CAMV//VOLU  cell amended to default to global grid, and coloured for confirmation\n5) EIG Compiled, JP market CAEV//MRGR  CAMV//VOLU  options CAOP//SECU and CASE added to local cell, and coloured for confirmation"]
["SR2008\nv4_05","Slight amendments in DvE Dates tabs","1) Addition of E1 and E2 to placement guidelines of PAYD. Indeed PAYD is mandatory in field 98a in sequence E1 and E2. That means that when aother date qualifier is used in these sequences, it can only be done in addition to PAYD."]
["SR2008\nv4_06","Slight amendments in EIG compiled tabs","1) EXOF: Deleted CAMV/CAOP codes for AU as in line with global practice. Idem for ES."]
["SR2009 V0_1","Amendments following Vienna SMPG meeting and SR2009 MWG","1) 'Read Me' section updated - cells highlighted in blue\n2) Addition of a new tab presenting the newly agreed 'EIG release schedule'.\n3) Changes to the 'EIG Compiled' tab - cells highlighted in blue:\n* CAPI - Addition of NOAC as a CAOP.\n* DVOP - Deletion of VOLU line - Insertion of \"n/a\" for AT is CHOS line\n* EXRI - Deletion of VOLU line\n* RHTS - Deletion of VOLU line\n* PDEF - Addition of an example in US column (from an email received on 14 July 2008)\n4) Changes to the 'Rights' tab - cells highlighted in blue - Addition of a new line for ZA\n5) Changes to the 'DvE' spreadsheet to reflect the SR2009 MWG decision (pending confirmation by country vote)"]
["SR2009 V0_2","Amendments and corrections","1) Changes to the 'DvE' spreadsheet: Correct small errors in placement guidelines possibilities before and after SR2009/2010.\n2) EIG Compiled - Change GB/IE column for CONV, TEND and DTCH events, SE column updated."]
["SR2009 V0_3","Amendments and corrections","1) Change GB/IE column for PRIO"]
["2009 v1_0",null,"Final Version renamed from EIG DvE SR2009 to EIG DvE 2009, since there is no Standards Release (SR) for CA in 2009."]
["2009 v1_1",20090619,"correction - CASH option added in the EIG compiled table for the Merger event in the US"]
["2010 v0_1",null,"New working document for SR2010. As per Release Schedule description (see separate worksheet). "]
["2010 v0_2_withCAEP_CA06_9",20090921,"Add CAEP for each events"]
["2010 v0_3",20100121,"1. In the EIG Compiled for the DECR event, add a MAND No Options line in the Global Grid (MDPUG request)\n2. In the EIG Compiled for the MRGR event, for France, replace CASH by SECU for MAND and CHOS\n3. CAMV fotr Priority Issue event are VOLU and CHOS and not 2 times VOLU\n4. NOAC added as option for each VOLU event (as per the guidelines provided in README sheet)\n5. In DvE table, CEXD and CORD are removed in the SR2010. EXPI and RDTE will be used instead.\n6. Replace the \"EIG Compiled\" sheet by the \"EIG+ compiled\" sheet which includes dates, periods, prices and rates for each events and country specifics coming from the Consolidated matrix file."]
["2010 v0_4",null,"1. In the EIG+ Compiled for the DRIP VOLU event, remove the NL specificities as confirmed by Ben Vandervelpen. VOLU is now N/A for NL\n2. In the EIG+ Compiled for the DRIP and DVOP for Austria, these must be CHOS events. Remove AT specificities for VOLU and set as N/A as confirmed by Austria."]
["2010v0_4_1",null,"No information change just the reformatting of the EIG+ compiled Definition/comments column to avoid having comments numbering in the global and country specific grid columns.   "]
["2010v0_4_1_NEXT",null,"Version Used to get the feedback from countries on the EIG+ and DPRP and couuntry specific columns "]
["SR2010 v0_6.xls","2010-04-22","Includes comments from AT, UK, BE, FI, SW, FR, GR"]
["SR2010 v0_7.xls","2010-04-26","Latest comments from BE and draft comments from JP included."]
["SR2010 v0_8.xls","2010-05-17","Latest comments included after Luxembourg meeting"]
["SR2010 v0_9.xls","2010-05-18","3 corrections from UK - Mandatory elements becoming optional."]
["SR2010 v0_10.xls","2010-06-10","Various corrections all checked with countries"]
["SR2010_V1_0","2010-06-16","1. The EIG Compiled table has been renamed \"EIG+\" as the table now includes recommendations for the presence of the Dates, Periods, Rates and Prices elements in sequences D and E/E1/E2 of the MT564 message for each CA event in the global grid and in the country specific columns.\nThe table has been fully reviewed by the SMPG and by the various NMPG's during March, April May and June 2010. \nThe number of changes applied in the EIG+ is so high in this release that the changes have not been highlighted in the table. However, the change log has been filled so as to give an idea of the main changes that have been applied. But the log is not exaustive either.\n2. The DvE table has been cleaned up to reflect the final SR2010 status.\n3. The Rights table has ben updated too with teh Luxembourg meeting output.\n4. The README file has been updated to explain the new information added in the EIG+.\n5. The name of the Excel sheet has been changed to \"SMPG_CA_Global_Market_Practice_Part_2\" as per decision of the CA SMPG at the Luxembourg meeting in April 2010.\nThe layout of the various worksheets contained in teh spreadsheet has been hamonised."]
["SR2010_V1_01","2010-06-22","Add updates from Germany to the EIG+ table in the DE column.."]
["SR2010_V1_02","2010-09-07","1. Rename \"Rights Table\" as \"Distribution With Options\"\n2. In the DvE table, highlight elements removed in SR2010\n3. In the DvE table, update the Guideline column for EFFD date\n4. In thE DvE table, add comments on the OFFR price code as a result of SMPG Action item CA 159.\n5. In the DvE table, add all codes that are newly created in SR2010.\n6. In teh DvE table add a remark on PAYD in seq. D.\n7. In the Complex Events table, in the \"COMMENTARY on the CELLS from the SMPG TELCO of 1st July 2005\" section, the references to the cells have been corrected as a line has been added in front of the table."]
["SR2010_V1_1","2011-02-25","1. In the DvE sheet, add additional comments regarding the SR2011 change requests for PLDT, TDMT, EXER, NWRT.\n2. In the Redemption Matrix sheet, add a note for the REDM event.\n3. Add the new worksheet \"EIG+ Corrections 20110216\" describing all agreed changes to the EIG+ global grid at and after the Amsterdam Meeting in 2010.\n4. In the EIG+, in the UK Date column, add EFFD were appropriate by UK law and add some wording in the comments column in red.\n5. EIG+ CAPI event EFFD [M] replaces PAYD [M]\n6. EIG+ EXOF, PRIO, TEND - add comments on the usage of the rate PROR.\n5. Add a new \"Return Of Capital Matrix\" sheet\n6. Add a new \"Record Date Tracking\" sheet\n7. Update the EIG+ with Country Specific inputs from DE, JP, NW, DK, ZA\n8. In EIG+, in PINK event, change RATE [O] rate to ADEX [O] rate\n9. DvE Introduction text"]
["SR2011_V0_1","2011-02-21","1. Adapt the DvE table to SR2011 "]
["SR2011_V1_0","2011-05-25","1. \"DvE Introduction\" sheet removed.\n2. DvE table - remove remark on OFFR\n3. DvE table  - Add usage rule comments for rates located in both E/D and E2/D2\n4. DvE table - Add placement recommendations for non-DPRP qualifiers\n5. DvE Table sheet is renamed \"Data Element Placement\" Guidelines.\n6. Definitions of EIG+ Terms - New Updated Sheet \n7. Correction brought on the EIG+ - see specific \"EIG+ corrections\" sheet for details\n8. Yearly release schedule updated"]
["SR2012_V1_0","2012-02-21","1. Add comments on SHPR (coming from GMP Part 1) in EIG+ and Return of Capital Matrix.\n2; From Data Element Placement tab in table Non-DPRP, leave INCO in 564 seq. E as is and remove from seq F in 564 and totally from 566.\n3. Update EIG+ GG and country columns (see \"EIG+ Updates since SR2011 V0_1\" tab)\n4. Fill in \"Record Date Tracking\" table with countries inputs.\n5. Distribution with Options tab - restructure the information in the new columns."]
["SR2012_V1_1","2012-07-23","1. EIG + - see specific EIG+ Updates sheet for details\n2. Fill in \"Record Date Tracking\" table with countries inputs and add XDTE /RDTE principles text box and new settlement cycle column."]
["SR2012_V1_2","2012-10-22","1. EIG + - see specific EIG+ Updates since V1_1 sheet for details.\n2. Record Date Tracking Table - Add the new Ex date column."]
["SR2013_V1_0","2013-02-28","1. EIG + - see specific \"EIG+ Updates since V1_2\" sheet/tab for details.\n2. \"Definition of EIG+ terms\" and \"Data Element Placement\" sheets updated as per SR2013 changes - see colored cells.\n3. In \"Complex Events\" sheet, add the NOOF event "]
["SR2013_V1_1","2013-03-20","In \"HOW TO READ\" tab - add one Color convention in the EIG+ worksheet for deleted rows"]
["SR2013_V1_2","May 2013","1. EIG+ - see updates in \"EIG+ Updates since SR2013 V1.1\" tab\n2. Record Date Tracking Table - Add information for several countries - see changes in green colors "]
["SR2014 V0.1","2013-12-24","1. Distribution with Options table. Correct ICSD line, ZA and SE line.\n2. Record Date Tracking Tabl- see highlighted cells\n3. EIG+ and CC columns - See specific tab \"EIG+ Updates since SR2013 V1.2\"\n4. Updates in \"Data Element Placement tab\" (see track chnages)\n5. Updates in \"Definition of EIG+ terms\" tab (see track changes)"]
["SR2014 V1.0","2014-02-12","1. Further update of the EIG+ & country column (seee related Tab \"EIG+ Updates since SR2013 v1.2\"\n2. ZA update in Record Date Tracking"]
["SR2014 V1.1","2014-05-30","1. Further update of the EIG+ & country column (seee related Tab \"EIG+ Updates since SR2014 v1.0\"\n2. Create a new InterestPeriod tab (as a follow up to CA281)"]
["SR2015 V1.0","2015-03-01","1. Interest period table updated\n2. Record Date Table upated\n3. EIG+ and Country column of CH, FI, SE, UK&IE, ZA, IN, SG, NO\n4. Complex Events D5 cell\n5. Distribution with Options CH line"]
["SR2015 V1.1","2015-03-31","1. EIG+ Country column of SG UPDATED"]
["SR2015 V1.2","2015-09-30","1. Interest period table updated\n2. Update SMPG Disclaimer paragraph on first tab.\n3. EIG+ ZA & SG Column Updated (see in Updates tab)\n4. Disclaimer updated"]
["SR2016 V1.0","2016-02-29","1. EIG+ and CC columns - See specific tab \"EIG+ Updates since SR2015 V1.2\"\n2. \"Definition of EIG+terms\" and \"Date Element Placement\" Tabs updated as per changes in the SR2016"]