master file reports

8/7/2019 Master File Reports

http://slidepdf.com/reader/full/master-file-reports 1/579

HomePageLinks

HOME;ADMINISTRATION;CHANGE PASSWORD;LOGOUT



MenuName

HOME;PROFILE;REPORTS;ADMINISTRATION;HELP;LOGOUT



VersionDate UserName

Version 4.00 Built on October 14, 2008 Pras Venkatanarayna



TestCaseID TestRunFlag

TestCase1 Y

TestCase2 Y

TestCase3 Y

TestCase3 Y

TestCase4 Y

TestCase5 Y

TestCase6 Y

TestCase7 Y

TestCase8 Y

TestCase9 Y

TestCase10 Y

TestCase11 Y

TestCase12 Y

TestCase13 Y

TestCase14 Y

TestCase15 Y

TestCase16 Y

TestCase17 Y

TestCase18 Y

TestCase19 Y

TestCase20 Y

TestCase21 Y

TestCase22 Y

TestCase23 Y

TestCase24 Y



TestCase25 Y

TestCase26 Y



TestCaseDesc

Report generation for Enterprise Search (with search criteria)

Report generation for Enterprise Search (without search criteria)

Checking if search results appear as per the search criterion(for the first 3 records)


Checking if Enterprise tab has same field values in Profiles obtained by Reports->Enterprise search an

Checking if Address tab has same field values in Profiles obtained by Reports->Enterprise search and

Checkiing if Relationship tab has same field values in Profiles obtained by Reports->Enterprise search

Checking if Enterprise tab has same fields in Profiles obtained by Reports->Enterprise search and Prof

Checking if Address tab has same fields in Profiles obtained by Reports->Enterprise search and Profile

Checking if Relationship tab has same fields in Profiles obtained by Reports->Enterprise search and Pr



Blank report for generation for Enterprise Search

Verifying the link in Enterprise column in the generated report

Filter the generated report (Single filter functionality)

Filter the generated report (Multiple filter functionality with 'AND' option)

Filter the generated report (Multiple filter functionality with 'OR' option)

Checking the 'delete' button functionality in Filter option (For single row)

Checking the 'delete' button functionality in Filter option (For multiple row)

Checking the sort functionality of column headers.

Sorting the generated report in ascending order (For single sort functionality)

Sorting the generated report in descending order (For single sort functionality)

Checking the 'Add' button functionality in Sort option for Ascending order. (For multiple sort functionalit

Checking the 'Add' button functionality in Sort option for Descending order. (For multiple sort functiona

Checking the 'delete' button functionality in Sort option (For single row of sort functionality)



Checking the 'delete' button functionality in Sort option (For multiple row of sort functionality)

Save the Enterprise Report in Excel format



MenuPath ReportLinks EnterpriseName

Reports;Enterprise Search;Filter;Sort;Save as Excel abc

Reports;Enterprise Search;Filter;Sort;Save as Excel abc

Reports;Enterprise Search;Filter;Sort;Save as Excel Ab

Reports;Enterprise Search;Filter;Sort;Save as Excel

Reports;Enterprise Search;Filter;Sort;Save as Excel Ad






Reports;Enterprise Search;Filter;Sort;Save as Excel AES Corporatio


















Reports;Enterprise Search;Filter;Sort;Save as Excel AB



RegionCountry SearchValue SelectEnterpriseName

Country of Incorporation United Kingdom

Geographic Region Latin America

Country of Incorporation United Kingdom Admiral Group



Geographic Region Latin America AES Corporation



None AES Corporation

AES Corporation


AES Corporation

Geographic Region Asia

Country of Incorporation United States












FilterColValue FilterExpression

Enterpise equals

Enterpise;CID # equals;equals

Enterpise;Country of Incorporation equals;equals

Enterpise equals

Enterpise equals



FilterValue FilterCondition SortColumnVal

ATA Inc

ABN AMRO Securities Inc.;9187560001 OR;OR

ABANA;United States OR;OR

AEC Corporation OR

Alto Palermo S.A. OR

Enterpise

Enterpise

Enterpise;Last Updated Date

Enterpise;Last Updated Date

Enterpise



Enterpise



SortOrder O P Q R S T

ascending

descending

descending;ascending

descending;ascending

descending



ascending



U V W X Y Z AA AB



AC AD AE AF AG AH AI AJ



AK AL AM AN AO AP AQ AR



AS AT AU AV AW AX AY AZ



BA BB BC BD BE BF BG BH



BI BJ BK BL BM BN BO BP



BQ BR BS BT BU BV BW BX



BY BZ CA CB CC CD CE CF



CG CH CI CJ CK CL CM CN



CO CP CQ CR CS CT CU CV



CW CX CY CZ DA DB DC DD



DE DF DG DH DI DJ DK DL



DM DN DO DP DQ DR DS DT



DU DV DW DX DY DZ EA EB



EC ED EE EF EG EH EI EJ



EK EL EM EN EO EP EQ ER



ES ET EU EV EW EX EY EZ



FA FB FC FD FE FF FG FH



FI FJ FK FL FM FN FO FP



FQ FR FS FT FU FV FW FX



FY FZ GA GB GC GD GE GF



GG GH GI GJ GK GL GM GN



GO GP GQ GR GS GT GU GV



GW GX GY GZ HA HB HC HD



HE HF HG HH HI HJ HK HL



HM HN HO HP HQ HR HS HT



HU HV HW HX HY HZ IA IB



IC ID IE IF IG IH II IJ



IK IL IM IN IO IP IQ IR



TestRunFlag TestCaseID FunctionName

Y TestCase1 MFReportsCompany_TC1()


Y TestCase3_1 MFReportsCompany_TC3()

TestCase3_2

TestCase3_3

TestCase3_4TestCase3_5

TestCase3_6

TestCase3_7








Y TestCase11 MFReportsCompany_TC11()Y TestCase12 MFReportsCompany_TC12()




































TestCaseDesc

Report generation for Adviser Search Results (with search criteria)

Report generation for Adviser Search Results (without search criteria)



Verifying the link in 'Company' column in the generated Adviser Search Results report

Verifying the link in 'Enterprise' column in the generated Adviser Search Results report

Filter the generated Adviser Search Results report and Filter,Add Filter and Delete

Checking the Adviser Search with Sort, Add Sort and Delete

Save the Adviser Search Results Report in Excel format

Report generation for Broker Search Results (with search criteria)

Report generation for Broker Search Results (without search criteria)

Verifying the link in Company column in the generated Broker Search Results reportVerifying the link in Enterprise column in the generated Broker Search Results report

Filter the generated Broker Search Results report and Filter, Add and Delete

Checking the functionality of Broker Search Results with Sort,Add and Delete

Save the Broker Search Results Report in Excel format

Report generation for Custodian Search Results

Report generation for Custodian Search Results (without search criteria)

Filter the generated Custodian Search Results report, Filter,Add Filter and Delete

Checking the sort functionality with Sort, Add Sort and Delete.

Save the Custodian Search Results Report in Excel format

Report generation for Depositary Search Results (with search criteria)

Report generation for Depositary Search Results (without search criteria)

Filter the generated Depositary Search Results report with Filter, Add and Delete.Checking the functionality of column headers for Depositary Search with Sort, Add and Delete

Save the Depositary Search Results Report in Excel format

Report generation for Issuer Search Results (with search criteria)

Report generation for Issuer Search Results (without search criteria)

Filter the generated report for Issuer ,Filter ,Add Filter and Delete

Sorting the generated Issuer Search Results report in ascending/descending order Sort,Add Sort and

Save the Issuer Search Results Report in Excel format

Report generation for Sub company Search Results (with search criteria)

Report generation for Sub Company Search Results (without search criteria)

Filter the generated Sub company Search Results report with Filter, Add Filter and Delete.

Sorting the generated Sub company Search Results report in ascending/descending order with Sort ,

Save the Sub company Search Results Report in Excel formatReport generation for Vendor Search Results (with search criteria)

Report generation for Vendor Search Results (without search criteria)

Filter the generated Vendor Search Results report with Filter,Add Filter and Delete.

Sorting the generated Vendor Search Results report in ascending/descending order with Sort ,Add So

Save the Vendor Search Results Report in Excel format

Report generation for 'Issuer Products and Services

Filter the generated 'Issuer Products and Services' report with Filter,Add Filter and Delete

Sorting the generated 'Issuer Products and Services' report in ascending/descending order with Sort

Save the 'Issuer Products and Services' Report in Excel format

Issuer Products and Services Verification of issuer fields

Market Capitalization by Country by Custodian (Detail) Verification of issuer fields

Market Capitalization by Country by Custodian (Summary) Verification of issuer fields



Custodian Billing Verification of issuer fields

Custodian Position Report Verification of issuer fields

Custodian Pending Transactions Verification of issuer fields

Fee Schedule Report Search Verification of issuer fields

Preferred Custodian-Clean Up Report Verification of issuer fields

Custodian Inactive Mnemonic Report Verification of issuer fields

Report generation for Adviser Search Results (with search criteria)Report generation for Broker Search Results (with search criteria)

Report generation for Custodian Search Results (with search criteria)

Report generation for Depository Search Results (with search criteria)

Report generation for Issuer Search Results (with search criteria)

Report generation for SubCompany Search Results (with search criteria)

Report generation for Vendor Search Results (with search criteria)



MenuPath CheckMenu

Reports;Company;Search Reports;Company;Search:Pre-defined





Reports;Company;Search Reports;Company;Search:Pre-definedReports;Company;Search Reports;Company;Search:Pre-defined





































Reports;Company;Pre-defined Reports;Company;Search:Pre-defined









ReportLinks CompanyName

Search;Filter;Sort;Save as Excel Argentaria

Search;Filter;Sort;Save as Excel




Search;Filter;Sort;Save as ExcelSearch;Filter;Sort;Save as Excel








Search;Filter;Sort;Save as Excel Headwaters


Search;Filter;Sort;Save as Excel HeadwatersSearch;Filter;Sort;Save as Excel Headwaters




Search;Filter;Sort;Save as Excel United Bank for Africa plc





Search;Filter;Sort;Save as Excel Citibank NA




Search;Filter;Sort;Save as Excel ACESITA S.A.





Search;Filter;Sort;Save as Excel Ahold USA




Search;Filter;Sort;Save as ExcelSearch;Filter;Sort;Save as Excel ABANA




















Search;Filter;Sort;Save as Excel ArgentariaSearch;Filter;Sort;Save as Excel Headwaters

Search;Filter;Sort;Save as Excel United Bank for Africa plc

Search;Filter;Sort;Save as Excel Citibank NA

Search;Filter;Sort;Save as Excel ALSTOM

Search;Filter;Sort;Save as Excel Ahold USA

Search;Filter;Sort;Save as Excel ABANA



EnterpriseName Company CompanyStatus

BBVA Group Adviser Effective

Adviser

Adviser Effective

Broker Committed

Custodian

Depositary CommittedIssuer Committed

Subcompany Committed

Vendor

BBVA Group Adviser Effective

Adviser Effective

Adviser Committed

Adviser Committed

Adviser Terminated

Headwaters Broker Effective

Broker

Broker EffectiveBroker Effective

Broker Committed

Broker Committed

Broker Terminated

United Bank for Africa plc Custodian Effective

Custodian

Custodian Committed

Custodian Committed

Custodian Committed

Citibank Depositary Effective

Depositary

Depositary CommittedDepositary Committed

Depositary Terminated

ACESITA S.A. Issuer Terminated

Issuer

Issuer

Issuer

Issuer Effective

Koninklijke Ahold N.V. Subcompany Effective

Subcompany



Subcompany CommittedABANA Vendor Effective

Vendor

Vendor Committed

Vendor Committed

Vendor Terminated

Kazakhstan;ATF Bank;ATF Bank

Kazakhstan;ATF Bank;ATF Bank



BBVA Group

Gazprom OAO

BBVA Group Adviser EffectiveHeadwaters Broker Effective

United Bank for Africa plc Custodian Effective

Citibank Depositary Effective

ALSTOM Issuer Effective

Koninklijke Ahold N.V. Subcompany Effective

ABANA Vendor Effective



Region SearchValue GovtOwnership Adviser_Role

Country of Incorporation Spain



Country of Incorporation VenezuelaCountry of Incorporation China

Country of Incorporation Russia




Country of Incorporation United StatesCountry of Incorporation United States

Country of Incorporation Nigeria


Country of Incorporation Brazil





Country

Country

Country

Country of Incorporation SpainCountry of Incorporation United States

Country of Incorporation Nigeria


Country of Incorporation France





Adviser_Status Broker_Role Broker_Status Custodian_AgentType

Active

Registrar

Active

Active

Active

ActiveActive

Custodian



ActiveActive

Custodian



Custodian_OwnProgramOnly Depositary_Role Depositary_Status Issuer_EffBNYSp

Y

Active



Y

Active



General Industrials Miller, Lance



Issuer_S_U Issuer_DRWithMultipleDepositaries Issuer_InvestorRelationsFirm



Issuer_MultipleUnderlyingSecurityMarkets Vendor_Type FilterColumn

Outsourcing

Country of Incorporation






Subscription


Country of Management



Subscription



FilterExpression FilterValue SortColumn SortOrder

equals United Kingdom

Country of Incorporation ascending

Company ascending

equals United States


Company ascending



Company ascending

equals VenezuelaCountry of Incorporation ascending

Company ascending

equals United Kingdom


Company ascending

equals Russia


Company ascending



Company ascending

equals Sweden

Country of Management ascending

Issuer ascending



LinkCheck

Issuer Products and Services;Market Capitalization by Country by Custodian (Detail);Market Capitaliz









SelectRequiredLink

Issuer Products and Services





Market Capitalization by Country by Custodian \(Detail\)

Market Capitalization by Country by Custodian \(Summary\)



Custodian Billing

Custodian Position Report

Custodian Pending Transactions

Fee Schedule Report Search

Preferred Custodian-Clean Up Report

Custodian Inactive Mnemonic Report



Profile;Company;Custodian Custodian;All;All

Profile;Company;Issuer Issuer;All;All

Profile;Company;Custodian Custodian;All;All



Custodian CUSIP OperationFirstDate

15;Jul;2008

15;Jul;2008



AMRO;ABN AMRO BANK N.V.;AMRO 7;Jan;2008

AMRO;ABN AMRO BANK N.V.;AMRO 8;Jul;2008

AMRO;ABN AMRO BANK N.V.;AMRO

AMRO;ABN AMRO BANK N.V.;AMRO



OperationSecondDate



7;Jan;2008



TestRunFlag TestCaseID

Y TestCase1

Y TestCase2

Y TestCase2

Y TestCase2

Y TestCase2

Y TestCase2Y TestCase2

Y TestCase2

Y TestCase3

Y TestCase4

Y TestCase4

Y TestCase4

Y TestCase4

Y TestCase4

Y TestCase5

Y TestCase5

Y TestCase5


Y TestCase6

Y TestCase7

Y TestCase8

Y TestCase9

Y TestCase10

Y TestCase11

Y TestCase12

Y TestCase13

Y TestCase14

Y TestCase15


Y TestCase18

Y TestCase19

Y TestCase20

Y TestCase21

Y TestCase22



TestCaseDesc

Report generation for Contact Search Results (with search criteria)

Report generation for Contact Search Results (with 'Company Name' as the search criteria)




Report generation for Contact Search Results (with 'Company Name' as the search criteria)Report generation for Contact Search Results (with 'Company Name' as the search criteria)


Report generation for Contact Search Results (without search criteria)






Clicking on the link in the search results in Reports menu and verifying the results in Profile menu



Clicking on the link in the search results in Reports menu and verifying the results in Profile menuClicking on the link in the search results in Reports menu and verifying the results in Profile menu

Verifying the link in Last Name column in the generated Contact Search Results report

Verifying the link in Company column in the generated Contact Search Results report

Filter the generated Contact Search Results report (Single filter functionality)

Filter the generated Contact Search Results report (Multiple filter functionality with 'AND' option)

Filter the generated Contact Search Results report (Multiple filter functionality with 'OR' option)

Checking the 'delete' button functionality in Filter option (For single row) for Contact Search Results Re

Checking the 'delete' button functionality in Filter option (For multiple row) for Contact Search Results R

Checking the sort functionality of column headers for Contact Search Results Report

Sorting the generated Contact Search Results report in ascending order (For single sort functionality)

Sorting the generated Contact Search Results report in descending order (For single sort functionality)

Checking the 'Add' button functionality in Sort option for Ascending order (For multiple sort functionalitChecking the 'Add' button functionality in Sort option for Descending order (For multiple sort functiona

Checking the 'delete' button functionality in Sort option (For single row of sort functionality) for Contact

Checking the 'delete' button functionality in Sort option (For multiple row of sort functionality) for Conta

Save the Contact search Results Report in Excel format

Save the Company Contact Roles Report

Report generation for Company Contact Roles



MenuPath_Search MenuPath_PreDefined ContactReportLinks

Reports;Contact;Search Reports;Contact;Pre-defined Search;Filter;Sort;Save as Excel





Reports;Contact;Search Reports;Contact;Pre-defined Search;Filter;Sort;Save as ExcelReports;Contact;Search Reports;Contact;Pre-defined Search;Filter;Sort;Save as Excel






























CompanyName_Reports ContactFirstName_Reports ContactLastName_Reports

DAVID

GLAXO

DAVID

CHAN

DAVID

ALUMINA

DAVID

Nikolaev Alumina Plant

DAVID

DAVID

DAVID

DAVID

DAVID

DAVID

DAVID

DAVID

DAVID

DAVID

DAVIDDAVID

DAVID

DAVID

DAVID

DAVID



CreatedFrom CreatedTo CompanyRole

05;May;2008 10;Jun;2008Depositary

05;May;2008 10;Jun;2008

16;Feb;2008 26;Feb;2008

Depositary

Custodian

Depositary

IssuerVendor



CompanyStatus ContactCatego ContactLevel Region SearchValue

Primary

Belgium

Committed

Primary

Effective

Effective

Belgium

Primary

Primary

Primary

Primary

Primary

Primary

Primary

Primary

Primary

Primary

PrimaryPrimary

Primary

Primary

Primary

Primary

Primary



Expression Value Condition

equals CFO AND

equals;equals CFO;David AND;AND

equals;equals CFO;David OR;OR

equals CFO AND

equals;equals CFO;David AND;AND



SortColumn SortOrder ClickSaveasExcelLink

Job Title ascending

Job Title descending

Job Title;Last Name ascending;ascendingJob Title;Last Name descending;descending

Job Title ascending

Job Title;Last Name descending;ascending




Y Test Case 1

Y Test Case 2

Y Test Case 3

Y Test Case 4

Y Test Case 5

Y Test Case 5

Y Test Case 5

Y Test Case 6

Y Test Case 7

Y Test Case 8

Y Test Case 9

Y Test Case 10

Y Test Case 11

Y Test Case 12

Y Test Case 13

Y Test Case 14

Y Test Case 15

Y Test Case 16

Y Test Case 17

Y Test Case 18

Y Test Case 19



TestCaseDesc

Report generation for BNY Contact Search Results (with search criteria)

Report generation for BNY Contact Search Results (without search criteria)

Blank report for generation for BNY Contact Search Results

Verifying the link in Last Name column in the generated BNY Contact Search Results report




Comaprison of data with Profile menu and Reports menu

Filter the generated BNY Contact Search Results report (Single filter functionality)

Filter the generated BNY Contact Search Results report (Multiple filter functionality with 'AND' option)

Filter the generated BNY Contact Search Results report (Multiple filter functionality with 'OR' option)

Checking the 'delete' button functionality in Filter option (For single row) for BNY Contact Search Result

Checking the 'delete' button functionality in Filter option (For multiple row) for BNY Contact Search Res

Checking the sort functionality of column headers for BNY Contact Search Results Report

Sorting the generated report in ascending order (For single sort functionality) for BNY Contact Search R

Sorting the generated report in descending order (For single sort functionality) for BNY Contact Search

Checking the 'Add' button functionality in Sort option for Ascending order. (For multiple sort functionalit

Checking the 'Add' button functionality in Sort option for Descending order. (For multiple sort functiona

Checking the 'delete' button functionality in Sort option (For single row of sort functionality) for BNY Con

Checking the 'delete' button functionality in Sort option (For multiple row of sort functionality) for BNY C

Save the BNY Contact Search Results Report in Excel format



SearchType

General

Blank

Invalid

General with Contact ProfileLink

General

General

General

General

General with Filter

General with Multiple Filtering(AND)

General with Multiple Filtering(OR)

SingleFilter Delete

MultipleFilter Delete

General with Header Click

SingleSortAscending

SingleSortDescending

MultipleSortAscending

MultipleSortDescending

SingleSort Delete

MultipleSortDelete

Save As Excel



HomePageLinks
























VersionDate MenuPath

Version 4.00 Built on October 14, 2008 Reports;CUSIP;Search























ContactFirstName ContactLastName Department Location

Chan

SATISH DON HYD Relationship Management US

Relationship Management US

Administration US

Relationship Management

Company Desk

















Subdepartment Position SeniorManagement

Administrator

EEMEA Relationship Manager



BNYContactReportsLinks HeaderClickReq LastNameClick FilterRequired


Yes

Yes

AND;AND

OR;OR

SFDEL

MFDEL

Yes



SortRequired FilterColumn FilterExpression FilterValue

Last Name not equals Mr.

Salutation;Last Name not equals;not starts with Mr.;S

Salutation;Last Name not equals;not starts with Mr.;S

Last Name not equals Sat

Last Name not equals sat

SSASC

SSDSC

MSASC

MSDSC

SSDEL

MSDEL



SortColumn SortOrder ClickSaveasExcelLink

Last Name ascending

Last Name descending

Last Name;Job Title ascending;ascending

Last Name;Job Title descending;descending

Last Name ascending

Last Name ascending

Yes




TestCase1 Y

TestCase1 Y

TestCase1 Y

TestCase1 Y

TestCase1 Y

TestCase1 YTestCase1 Y

TestCase1 Y

TestCase1 Y

TestCase2 Y

TestCase3 Y

TestCase3 Y

TestCase3 Y

TestCase4 Y

TestCase5 Y

TestCase6 Y

TestCase7 Y

TestCase8 Y

TestCase9 Y

TestCase10 Y

TestCase11 Y

TestCase12 Y

TestCase13 Y

TestCase14 Y

TestCase15 Y

TestCase16 Y

TestCase17 Y

TestCase18 Y

TestCase19 Y

TestCase20 Y

TestCase21 Y

TestCase22 Y

TestCase23 Y

Testcase24 Y



TestCase25 Y

TestCase26 Y

TestCase27 Y

TestCase28 Y

TestCase29 Y

TestCase30 Y

TestCase31 Y

TestCase32 Y

TesrCase33 Y

TestCase34 Y

TestCase35 Y

TestCase36 Y

TestCase37 Y

TestCase38 Y

TestCase39 Y

TestCase40 Y

TestCase41 Y

TestCase41 Y

TestCase41 Y

TestCase41 Y

TestCase41 Y

TestCase42 Y

TestCase43 Y

TestCase44 Y

TestCase45 Y



TestCaseDesc

Report generation for DR Search Results (with search criteria)





Report generation for DR Search Results (with search criteria)Report generation for DR Search Results (with search criteria)



Report generation for DR Search Results (without search criteria)




Verifying the link in DR Name column in the generated DR Search Results report

Filter the generated DR Search Results report (Single filter functionality)

Filter the generated DR Search Results report (Multiple filter functionality with 'AND/OR' option)

Checking the 'delete' button functionality in Filter option for DR Search Results Report

Checking the sort functionality of column headers for DR Search Results report

Sorting the generated DR Search Results report in ascending/descending order (For single sort functio

Checking the 'Add' button functionality in Sort option for Ascending/descending order(For multiple sort

Checking the 'delete' button functionality in Sort option for DR Search Results report

Save the DR Search Results Report in Excel format

Filter the generated Asset Committee Termination report (Single filter functionality, Add and Delete)

Checking the sort functionality of Sort, Add and Delete for Asset Committee Termination report.

Save the Asset Committee Termination Report in Excel format

Filter the generated 'Initial Sale date Search' report (Single filter functionality, Add and Delete)

Checking the sort functionality of Sort, Add and Delete for 'Initial Sale date Search' report.

Save the 'Initial Sale date Search' Report in Excel format

Report generation for DRs and their Corresponding Specialist Firms

Filter the generated DRs and their corresponding Specialist Firms report ( Filter, Add and Delete functio

Sorting the generated DRs and their corresponding Specialist Firms report in ascending/descending ord

Save the DRs and their corresponding Specialist Firms Report in Excel format

Report generation for 'Asset Committee Termination'

Report generation for 'Initial Sale date Search'



Report generation for DRs with Pre-Release

Filter the generated DRs with Pre-Release report (Filter, Add and Delete functionality)

Sorting the generated DRs with Pre-Release report in ascending/descending order (Sort , Add and Delet

Save the DRs with Pre-Release Report in Excel format

Report generation for 'Effective BNY Sponsored DRs without GBD or DRIP'

Filter the generated Effective BNY Sponsored DRs without GBD or DRIP report (Filter, Add and Delete)

Sorting the generated Effective BNY Sponsored DRs without GBD or DRIP report in ascending/descendin

Save the Effective BNY Sponsored DRs without GBD or DRIP Report in Excel format

Report generation for Effective GBD or DRIP

Filter the generated Effective GBD or DRIP report ( Filter, Add and delete functionality)

Sorting the generated Effective GBD or DRIP report in ascending/descending order (Sort ,Add and Delet

Save the Effective GBD or DRIP Report in Excel format

Report generation for 'Threshold'

Filter the generated Threshold report (Filter , Add and Delete)

Sorting the generated Threshold report in ascending/descending order ( Sort , Add and Delete)

Save the Threshold Report in Excel format

Report generation for DSF Forecast Report - Maximum Fee





Report generation for DSF Forecast Report - Maximum Fee with DRs Never Charged DSF Ticked

Filter the generated DSF Forecast Report - Maximum Fee report (Filter ,Add and Delete functionality)

Sorting the generated DSF Forecast Report - Maximum Fee report in ascending/descending order (Sort

Save the DSF Forecast Report - Maximum Fee Report in Excel format



MenuPath SelectReportName

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;SearchReports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Search

Reports;DR;Pre-defined Asset Committee Termination Report




Reports;DR;Pre-defined Initial Sale Date Report




Reports;DR;Pre-defined DRs and their Corresponding Specialist Firms






ReportLinks




































ReportNames

Asset Committee Termination Report;Initial Sale Date Report;DRs and their Corresponding Specialist Fir





Asset Committee Termination Report;Initial Sale Date Report;DRs and their Corresponding Specialist FirAsset Committee Termination Report;Initial Sale Date Report;DRs and their Corresponding Specialist Fir






























DRName SU Successor ETDate From

Sample All All All

Aluminum Corporation of Chin Sponsored

Axfood Effective 25;Nov;2008

ab

ab

ab

ab

Aluminum Corporation of China

ab Sponsored Yes

ab

Effective 25;Nov;2008





Alumin

Alumina

Alumina

Alumina

10;Nov;2008

10;Nov;2008

25;Oct;2008

25;Oct;2008

10;Nov;2008

10;Nov;2008

25;Oct;2008

25;Oct;2008



To SecurityDescription DRExchange Depositary

American Stock Exchange

15;Dec;2008

ADR American Stock Exchange

Bank of New York Mellon

Bank of New York MellonADR American Stock Exchange

ADR


15;Dec;2008

15;Dec;2008

15;Dec;2008

15;Dec;2008

15;Dec;2008

12;Dec;2008

12;Dec;2008

16;Dec;2008

16;Dec;2008

12;Dec;2008

12;Dec;2008

16;Dec;2008

16;Dec;2008



Status CountryofManagement Region SubRegion Industry Type

Committed

Committed

Effective Level I

Banks



Origin RelationshipManagerNewyork RelationshipManager

Pagan, Violet

Audi, Celisa

New Program Drouin, Laurent



UnsponseredConversion SelectDRName SelectIssuerName


Axfood

Aluminum Corporation of China African Platinum plc

African Platinum

FalabellaAfrican Platinum African Platinum

All Tabcorp

No SABESP


British American Tobacco

British American Tobacco

APT Satellite

ABN AMRO ABB LTD



4imprint

GPC Biotech

Alumina

4imprint

4imprint



Name equals ASTI

Name equals Crucell

DR Name equals ARM

Name equals ADVFN

BANCO DAYCOVAL

ACCESS BANK - REG. S

BANCO DAYCOVAL

BANCO DAYCOVAL

BANCO DAYCOVAL

HOME RETAIL GROUP

CUSIP equals 00433P101



FilterCondition SortColumn SortOrder RecordDateFrom

AND

AND

AND

DR Name ascending

DR Name;CUSIP ascending;descending

DR Name ascending

AND

DR Name ascending

AND

DR Name ascending

AND

Name ascending



AND

Name ascending

AND

Name ascending

AND

DR Name ascending

AND

Name ascending

25;Dec;2006

25;Dec;2006

AND 25;Dec;2006

CUSIP ascending 25;Dec;2006

25;Dec;2006



RecordDateTo AndOr EffectiveDateFrom EffectiveDateTo



15;Dec;2008 Or 20;Jun;2005 17;Aug;2008

25;Aug;2005 10;Aug;2008

25;Aug;2005 10;Aug;2008

25;Aug;2005 10;Aug;2008

15;Dec;2008 Or 20;Jun;2005 17;Aug;2008

15;Dec;2008 Or 20;Jun;2005 17;Aug;2008

15;Dec;2008 Or 20;Jun;2005 17;Aug;2008

15;Dec;2008 Or 20;Jun;2005 17;Aug;2008



DepositeAgreement ChargeDSF Su DrsNeverCharged RegionNew



Yes Yes Sponsored Checked

Yes Yes Sponsored

Yes Yes Sponsored

Yes Yes Sponsored Checked

Yes Yes Sponsored

Unsponsored



RelationshipManagerNewYork CountryOfManagement SelectCUSIP AW



ATDRV77CZ

ATDRV77CZ

ATDRV77CZ

ATDRV77CZ

ATDRV77CZ

43731F102



AX AY AZ BA BB BC BD BE



BF BG BH BI BJ BK BL BM



BN BO BP BQ BR BS BT BU



BV BW BX BY BZ CA CB CC



CL CM CN CO CP CQ CR CS



CT CU CV CW CX CY CZ DA



DB DC DD DE DF DG DH DI



DJ DK DL DM DN DO DP DQ



DR DS DT DU DV DW DX DY



DZ EA EB EC ED EE EF EG



EH EI EJ EK EL EM EN EO



EP EQ ER ES ET EU EV EW



EX EY EZ FA FB FC FD FE



FF FG FH FI FJ FK FL FM



FN FO FP FQ FR FS FT FU



FV FW FX FY FZ GA GB GC



GL GM GN GO GP GQ GR GS



GT GU GV GW GX GY GZ HA



HB HC HD HE HF HG HH HI



HJ HK HL HM HN HO HP HQ



HR HS HT HU HV HW HX HY



HZ IA IB IC ID IE IF IG



IP IQ IR IS IT IU IV




Y Test Case 1

Y Test Case 2

Y Test Case 3

Y Test Case 4

Y Test Case 5

Y Test Case 6

Y Test Case 6

Y Test Case 7

Y Test Case 8

Y Test Case 9

Y Test Case 10

Y Test Case 11

Y Test Case 12

Y Test Case 13

Y Test Case 13

Y Test Case 14

Y Test Case 15

Y Test Case 16

Y Test Case 17

Y Test Case 18

Y Test Case 18

Y Test Case 19

Y Test Case 20

Y Test Case 21

Y Test Case 22

Y Test Case 22

Y Test Case 23

Y Test Case 24

Y Test Case 25



Look Up the Report of CUSIP with Pre-defined Link using List of Effective DRs With Inactive CUSIP Report, Filte

Look Up the Report of CUSIP with Pre-defined Link using List of Effective DRs With Inactive CUSIP Report, Filte

Look Up the Report of CUSIP with Pre-defined Link using List of Effective DRs With Inactive CUSIP Report, Sort

Look Up the Report of CUSIP with Pre-defined Link using List of Effective DRs With Inactive CUSIP Report and S

Look Up the Report of CUSIP with Pre-defined Link using CUSIP Pending Transaction Report

Look Up the Report of CUSIP with Pre-defined Link using CUSIP Pending Transaction Report

Look Up the Report of CUSIP with Pre-defined Link using CUSIP Pending Transaction Report, Filter, Add Filter a

Look Up the Report of CUSIP with Pre-defined Link using CUSIP Pending Transaction Report, Filter, Add Filter a

Look Up the Report of CUSIP with Pre-defined Link using CUSIP Pending Transaction Report Sort, Add Sort and

Look Up the Report of CUSIP with Pre-defined Link using CUSIP Pending Transaction Report and Save as Exce

Search the Reports of CUSIP specified search criteria

Search the Reports of CUSIP specified search criteria



Reports;CUSIP;Pre-defined Reports;CUSIP;Search:Pre-defined




Reports;CUSIP;Pre-defined Reports;CUSIP;Search:Pre-defined CUSIP

Reports;CUSIP;Pre-defined Reports;CUSIP;Search:Pre-defined CUSIP




Reports;CUSIP;Pre-defined Reports;CUSIP;Search:Pre-definedReports;CUSIP;Search Reports;CUSIP;Search:Pre-defined

Reports;CUSIP;Search Reports;CUSIP;Search:Pre-defined



SelectColumnValue1 CUSIPName CUSIPNumber CUSIPType CUSIPType1

ALUMINA

022205108

HOLDR

805174109 Primary

009277104

004845103

470081100

004436101

004436101

004436101

Y39226116

Y39226116

Primary

Primary

Primary



CUSIPActiveFlag ActiveFlagValue CUSIPEffectiveFlag EffectiveFlagValue CUSIPSU

Effective Y Sponsored

All

Inactive N

All

Sponsored

Active

Active

Active



Inactive N Not Effective N



CUSIPSUValue CUSIPHomeMarketCountry CUSIPDepositary

S United States Bank of New York Mellon

Japan

Spain


Australia

Australia

Australia



CUSIPDepositaryValue CUSIPCommonDepository CommonDepositoryValue

HSBC HSBC

BNY HSBC HSBC

HSBC HSBC







Y Search;Filter;Sort;Save as Excel





Y Search;Filter;Sort;Save as ExcelSearch;Filter;Sort;Save as Excel




FilterColumn FilterExpression FilterValue

Home Market Country;Ratio DRs equals;equals Australia;2

CUSIP;Name equals;equals 000376103;AAV LIMITED

DR Exchange;Underlying ISIN contains;contains None;RU000A0

CUSIP;Name contains;contains 037376;GRES

Depositary;Price(USD) contains;contains BNY;1

Name;CUSIP contains;contains Sa;02



FilterCondition SortColumn SortOrder

AND;AND

Home Market Country;CUSIP ascending;descending

AND;AND

DR Exchange;CUSIP ascending;ascending

Depositary;CUSIP ascending;ascending



PredefinedLinkCheck

Active Orphan CUSIPs;Duplicate Priced Issues Report;List of EffectiveDRs With Inactive CUSIP Report;CUSIP Pending Transaction Report


















Active Orphan CUSIPs;Duplicate Priced Issues Report;List of Effective

DRs With Inactive CUSIP Report;CUSIP Pending Transaction Report




Active Orphan CUSIPs;Duplicate Priced Issues Report;List of Effective

DRs With Inactive CUSIP Report;CUSIP Pending Transaction Report



SelectPredefinedLink

Active Orphan CUSIPs




Duplicate Priced Issues Report





List of Effective DRs With Inactive CUSIPReport




TestCase1 Y

TestCase1 Y

TestCase1 Y

TestCase2 Y

TestCase3 Y

TestCase4 Y

TestCase5 Y

TestCase6 Y

TestCase7 Y

TestCase8 Y

TestCase9 Y

TestCase10 Y

TestCase11 Y

TestCase12 Y

TestCase13 Y

TestCase14 Y

TestCase15 Y

TestCase16 Y



TestCaseDesc

Search the Reports of Underlying Security with Name.



Search the Reports of Underlying Security with status as committed

Search the Reports of Underlying Security with Underlying ISIN.

Search the Reports of Underlying Security with Underlying ISIN and Status

Search the Reports of Underlying Security with Underlying ISIN and Capital Structure

Search the Reports of Underlying Security with Underlying ISIN and Type

Search the Reports of Underlying Security with Underlying ISIN and Share Form

Search the Reports of Underlying Security with Underlying ISIN,Currency and Country Of Exchange

Search the Reports of Underlying Security with Underlying SEDOL .

Search the Reports of Underlying Security with Underlying SEDOL and Status

Search the Reports of Underlying Security with Underlying SEDOL and Capital Structure

Search the Reports of Underlying Security with Underlying SEDOL and Type

Search the Reports of Underlying Security with Underlying SEDOL and Share Form

Search the Reports of Underlying Security with Underlying ISIN and Underlying SEDOL

Search the Reports of Underlying Security with Any Combination and Filter

Search the Reports of Underlying Security with Underlying SEDOL,Currency and Country Of Exchange



UnderlyingSEDOL Status CapitalStructure Type ShareForm

Committed

Committed

Effective

Equity

Common

Registered

3364156

3364156Effective

3364156 Equity

3364156 Ordinary

3364156 Registered

3364156

3364156



Currency CountryofExchange SelectName FilterColValue

TABCORP Holdings

AUSTRALIAN DOLLAR Australia

UNITED KINGDOM POUND United Kingdom

UNITED KINGDOM POUND United Kingdom

Name



Name;Status

Name



equals;equals TABCORP Holdings; Committed AND;AND

equals TABCORP Holdings

Name

Underlying ISIN

Status

Name;Underlying ISIN

Name;Underlying ISIN



SortOrder



TestCaseDesc

Search the Reports of Offering with Offering CUSIP DR Name.





Search the Reports of Offering with Offering CUSIP DR Name.Search the Reports of Offering with Offering CUSIP DR Name.





Search the Reports of Offering with out feeding any Value..




Search the Reports of Offering with Offering CUSIP DR Name and S/U.

Search the Reports of Offering with Offering CUSIP DR Name with all other fields

Search the Reports of Offering with any combination and FilterSearch the Reports of Offering with Any Combination and Filter - ADD

Search the Reports of Offering with Any Combination and Filter - Delete

Search the Reports of Offering with Any Combination and Sort

Search the Reports of Offering with Any Combination and Sort - ADD

Search the Reports of Offering with Any Combination and Sort - Delete

Search the Reports of Offering with Any Combination and Save as Excel



HomePageLinks CurrentUser

HOME;ADMINISTRATION;CHANGE PASSWORD;LOGOUT Nishant Mahitcha





HOME;ADMINISTRATION;CHANGE PASSWORD;LOGOUT Nishant MahitchaHOME;ADMINISTRATION;CHANGE PASSWORD;LOGOUT Nishant Mahitcha











HOME;ADMINISTRATION;CHANGE PASSWORD;LOGOUT Nishant MahitchaHOME;ADMINISTRATION;CHANGE PASSWORD;LOGOUT Nishant Mahitcha








MenuName

HOME;PROFILE;REPORTS;ADMINISTRATION;CA DR EVENTS;HELP;LOGOUT





HOME;PROFILE;REPORTS;ADMINISTRATION;CA DR EVENTS;HELP;LOGOUTHOME;PROFILE;REPORTS;ADMINISTRATION;CA DR EVENTS;HELP;LOGOUT











HOME;PROFILE;REPORTS;ADMINISTRATION;CA DR EVENTS;HELP;LOGOUTHOME;PROFILE;REPORTS;ADMINISTRATION;CA DR EVENTS;HELP;LOGOUT








VersionDate MenuPath MenuPath_PreDefined

Version 4.01 Built on October 14, 2008 Reports; Offering Reports; Contact; Predefined





Version 4.01 Built on October 14, 2008 Reports; Offering Reports; Contact; PredefinedVersion 4.01 Built on October 14, 2008 Reports; Offering Reports; Contact; Predefined











Version 4.01 Built on October 14, 2016 Reports; Offering Reports; Contact; PredefinedVersion 4.01 Built on October 14, 2017 Reports; Offering Reports; Contact; Predefined








ReportLinks OfferingCUSIPDRName S/U

Search;Filter;Sort;Save as Excel ABN AMRO

Search;Filter;Sort;Save as Excel Unsponsored









Search;Filter;Sort;Save as Excel ABN AMRO




Search;Filter;Sort;Save as Excel ABN AMRO Sponsored

Search;Filter;Sort;Save as Excel ABN AMRO Sponsored









CountryofManagement Region SubRegion Industry

BelgiumOrphan Region

Australia & New Zealand

Aerospace & Defense

Asia-Pacific

Aerospace & Defense

Australia Banks

Australia Asia-Pacific Australia & New Zealand Aerospace & Defense




Y TestCase1

Y TestCase2

Y TestCase3

Y TestCase4

Y TestCase5


Y TestCase8

Y TestCase9

Y TestCase10

Y TestCase11



TestCaseDesc

Search the Reports of Performance Threshold Pricing with Name.

Search the Reports of Performance Threshold Pricing with out feeding any Value..

Search the Reports of Performance Threshold Pricing with Name and Pricing Type

Search the Reports of Performance Threshold Pricing with Name, Country of Management and Region

Search the Reports of Performance Threshold Pricing with any combination and Filter

Search the Reports of Performance Threshold Pricing with Any Combination and Filter - ADDSearch the Reports of Performance Threshold Pricing with Any Combination and Filter - Delete

Search the Reports of Performance Threshold Pricing with Any Combination and Sort

Search the Reports of Performance Threshold Pricing with Any Combination and Sort - ADD

Search the Reports of Offering with Any Performance Threshold Pricing and Sort - Delete

Search the Reports of Performance Threshold Pricing with Any Combination and Save as Excel



TestRunFlag TestCaseID FunctionName

Y TestCase 1 MFReportsDocum





Y TestCase 6 MFReportsDocumY TestCase 7 MFReportsDocum





TestCase 11

TestCase 11

TestCase 11


TestCase 12









TestCase 21


TestCase 22










TestCase 32









MenuPath SelectRequiredLink OperationFirstDate

Reports;Documentation

Reports;Documentation Document Aging Sum26;Feb;2008




Reports;Documentation Document Aging Sum26;Feb;2008Reports;Documentation Document Aging Sum26;Feb;2008



Reports;Documentation Documentation Tracking Report


Reports;Documentation Documentation Tracki26;Sep;2008

Reports;Documentation Letter Agreement Expiration Date Report

Reports;Documentation New DR Business Report

Reports;Documentation Documentation Tracki3;Feb;2009



Reports;Documentation Documentation Tracki26;Feb;2000Reports;Documentation Documentation Tracki26;Feb;2000







Reports;Documentation Letter Agreement Exp26;Feb;2000


Reports;Documentation Letter Agreement Exp25;Jul;2008


Reports;Documentation Letter Agreement Exp26;Feb;2000Reports;Documentation Letter Agreement Exp26;Feb;2000











Reports;Documentation New DR Business ReportReports;Documentation New DR Business Report






OperationSecDate CountryOf DRStatus DRSubStatus Region

India

India Effective Asia-Pacific

5;Jan;2009

Asia-Pacific

India Asia-Pacific

10;Feb;2009 Committed

China Committed

31;May;2012 India Effective Asia-Pacific

31;May;2012 India Effective Asia-Pacific31;May;2012 India Effective Asia-Pacific





India Asia-Pacific

31;May;2012

Austria Western Europe

5;Aug;2008 Brazil

31;May;2012 India Asia-Pacific

31;May;2012 India Asia-Pacific31;May;2012 India Asia-Pacific





Asia-Pacific

Active Asia-Pacific

United Kingdom Dead Western Europe

India Active Asia-Pacific


India Active Asia-PacificIndia Active Asia-Pacific






RM_NY DocumentationRFilterRequired SortRequired


Search;Filter;SorCondition

Search;Filter;SorAdd

Search;Filter;SorDelete

Search;Filter;Sort;Save as Excel ConditionSearch;Filter;Sort;Save as Excel Add

Search;Filter;Sort;Save as Excel Delete




Villareal, Arlene C. Search;Filter;Sort;Save as Excel




DiVivo, Thomas Search;Filter;Sort;Save as Excel

Villareal, Arlene C. Search;Filter;SorCondition

Villareal, Arlene C. Search;Filter;SorAddVillareal, Arlene C. Search;Filter;SorDelete

Villareal, Arlene C. Search;Filter;Sort;Save as Excel Condition

Villareal, Arlene C. Search;Filter;Sort;Save as Excel Add

Villareal, Arlene C. Search;Filter;Sort;Save as Excel Delete





Abbott, Thomas Search;Filter;Sort;Save as Excel



Villareal, Arlene C. Search;Filter;SorAddVillareal, Arlene C. Search;Filter;SorDelete

Villareal, Arlene C. Search;Filter;Sort;Save as Excel Condition









Villareal, Arlene C. Search;Filter;SorAdd

Villareal, Arlene C. Search;Filter;SorDeleteVillareal, Arlene C. Search;Filter;Sort;Save as Excel Condition






FilterColumn FilterExpressi FilterValue SortColumn SortOrder

90 Days equals 1

90 Days ascending

CID# equals 5238110019

CID# ascending

Region equals Asia-Pacific

DR Name ascending

Region equals Asia-Pacific

Region ascending



LinkCheck

Document Aging Summary Report;Documentation Tracking Report;Letter Agreement Expiration Date R





Document Aging Summary Report;Documentation Tracking Report;Letter Agreement Expiration Date RDocument Aging Summary Report;Documentation Tracking Report;Letter Agreement Expiration Date R







































SearchCriteriaField

As of Date;

As of Date;

As of Date;

As of Date;

As of Date;As of Date;

As of Date;

As of Date;

Country of Management;

From Date;To Date;DR Status;

DR Status;Relationship Manager New York;Country of Management;

From Date;To Date;DR Status;Region;Relationship Manager New York;Country of Management;

From Date;To Date;DR Status;Region;Relationship Manager New York;Country of Management;From Date;To Date;DR Status;Region;Relationship Manager New York;Country of Management;





Region;RM NY;Country of Management;

Country of Management;Letter Agreement Expiration Date From;Letter Agreement Expiration Date To;

Region;RM NY;Country of Management;Letter Agreement Expiration Date From;Letter Agreement Expir

Region;RM NY;Country of Management;Letter Agreement Expiration Date From;Letter Agreement ExpirRegion;RM NY;Country of Management;Letter Agreement Expiration Date From;Letter Agreement Expir





Org Region;RM NY;

Org Region;RM NY;Country of Management;DR Sub-Status;



Org Region;RM NY;Country of Management;DR Sub-Status;Org Region;RM NY;Country of Management;DR Sub-Status;






strPageName chkItemInReportHeader chkExcelPath

MasterFile

Reports - Pre-defined

Document AginAs of Date

Document Aging Summary Report


Document Aging Summary ReportDocument Aging Summary Report


Document Aging Summary Report DocumentationAgingSum


Documentation Tracking Report

DocumentationFrom Date;To Date;DR Status;Relationship Manager New York;Country

Documentation Tracking ReportDocumentation Tracking Report




Documentation Tracking Report DocumentationTrackingR


Letter Agreement Expiration Date Report

Letter Agreem RM NY;Country of Management;Letter Agreement Expiration Date From

Letter Agreement Expiration Date ReportLetter Agreement Expiration Date Report




Letter Agreement Expiration Date Report DocumentationLetterAgr


New DR Business Report

New DR BusineOrg Region;RM NY;DR Sub-Status;


New DR Business ReportNew DR Business Report



New DR Business Report DocumentationNewDRBu



DRName

maryReport

Wipro

of Management

port

Wipro

;Letter Agreement Expiration Date To

ementExpirationDateReport

Wipro

inessReport




TestCase1 Y

TestCase2 Y

TestCase3 Y

TestCase4 Y

TestCase5 Y

TestCase6 Y

TestCase7 Y

TestCase8 Y

TestCase9 Y

TestCase10 Y

TestCase11 Y

TestCase12 Y

TestCase13 Y

TestCase14 Y

TestCase15 Y

TestCase16 Y



TestCase17 Y

TestCase18 Y

TestCase19 Y

TestCase20 Y

TestCase21 Y

TestCase22 Y

TestCase23 Y

TestCase24 Y

TestCase25 Y

TestCase26 Y

TestCase27 Y

TestCase28 Y

TestCase29 Y

TestCase30 Y

TestCase31 Y

TestCase32 Y

TestCase33 Y



TestCase34 Y

TestCase35 Y

TestCase36

TestCase37

TestCase38

TestCase39

TestCase40

TestCase41

TestCase42

TestCase43

TestCase44

TestCase45

TestCase46

TestCase47

TestCase48

TestCase49

TestCase50



TestCase51

TestCase52

TestCase53

TestCase54

TestCase55

TestCase56 Y

TestCase57 Y

TestCase58 Y

TestCase59 Y

TestCase60 Y

TestCase61 Y

TestCase62 Y

TestCase63 Y

TestCase64 Y

TestCase65 Y

TestCase66 Y

TestCase67 Y



TestCase68 Y

TestCase69 Y

TestCase70 Y

TestCase71 Y

TestCase72 Y



View the Report of Trading Volume with CUSIP Trading Volume History Detail and search


View the Report of Trading Volume with CUSIP Trading Volume History Detail , search and Filter, Add F

View the Report of Trading Volume with CUSIP Trading Volume History Detail, search and Sort, Add So

View the Report of Trading Volume with CUSIP Trading Volume History Detail, search and Save as Exce

View the Report of Trading Volume with CUSIP Trading Volume History Summary and search


View the Report of Trading Volume with CUSIP Trading Volume History Summary , search and Filter, Ad

View the Report of Trading Volume with CUSIP Trading Volume History Summary search and Sort, Add

View the Report of Trading Volume with CUSIP Trading Volume History Summary, search and Save as E

View the Report of Trading Volume with Trading Volume by Depositary by Country of Management and

View the Report of Trading Volume with Trading Volume by Depositary by Country of Management , se

View the Report of Trading Volume with Trading Volume by Depositary by Country of Management , se

View the Report of Trading Volume with Trading Volume by Depositary by Country of Management, sea

View the Report of Trading Volume with Trading Volume by Month and search


View the Report of Trading Volume with Trading Volume by Month, search and Filter, Add Filter and De



View the Report of Trading Volume with Trading Volume by Month , search and Sort, Add Sort and Dele

View the Report of Trading Volume with Trading Volume by Month, search and Save as Excel

View the Report of Trading Volume with Trading Volume for All DR Programs and search


View the Report of Trading Volume with Trading Volume for All DR Programs, search and Filter, Add Fil

View the Report of Trading Volume with Trading Volume for All DR Programs , search and Sort, Add Sor

View the Report of Trading Volume with Trading Volume for All DR Programs, search and Save as Exce

View the Report of Trading Volume with Trading Volume for Exchange Listed (Level II, III) DR Programs





View the Report of Trading Volume with Trading Volume for OTC (Level I) DR Programs and search



View the Report of Trading Volume with Trading Volume for OTC (Level I) DR Programs, search and So

View the Report of Trading Volume with Trading Volume for OTC (Level I) DR Programs, search and Sav



View the Report of Trading Volume with Trading Volume for Non-US Exchanges and search

View the Report of Trading Volume with Trading Volume for Non-US Exchanges search and Filter, Add


View the Report of Trading Volume with Trading Volume for Non-US Exchanges, search and Sort, Add S

View the Report of Trading Volume with Trading Volume for Non-US Exchanges, search and Save as Ex



MenuPath ReportName

Reports;Trading Volume

Reports;Trading Volume CUSIP Profile Trading Volume Daily Report





Reports;Trading Volume CUSIP Profile Trading Volume Monthly Report





Reports;Trading Volume CUSIP Profile Trading Volume Yearly Report







Reports;Trading Volume CUSIP Trading Volume History Detail





Reports;Trading Volume CUSIP Trading Volume History Summary





Reports;Trading Volume Trading Volume by Depositary by Country of Management




Reports;Trading Volume Trading Volume by Month







Reports;Trading Volume Trading Volume for All DR Programs






















Reports;Trading Volume Trading Volume New vs Old




Reports;Trading Volume Trading Volume Search




Reports;Trading Volume Trading Volume Search HOLDRS






Reports;Trading Volume Trading Volume for Non-US Exchanges







From To CUSIP CUSIPDetails

11;Jun;2008 23;Jan;2009 022205108 ALUMINA;;ALUMINA LIMITED





12;Aug;2008 20;Jan;2009 022205108 ALUMINA;;ALUMINA LIMITED






















11;Aug;2008 23;Jan;2009

11;Aug;2008 23;Jan;2009

11;Aug;2008 23;Jan;2009

11;Aug;2008 23;Jan;2009

11;Aug;2008 23;Jan;2009

1;Aug;2008 23;Jan;2009

11;Aug;2007 23;Jan;2009



23;Jan;2009

23;Jan;2009

23;Jan;2009

23;Jan;2009

10;Jan;2009 11;Feb;2009

10;Jan;2009 11;Feb;2009

10;Jan;2009 11;Feb;2009

10;Jan;2009 11;Feb;2009

13;Feb;2008 23;Jan;2009

13;Feb;2008 23;Jan;2009

13;Feb;2008 23;Jan;2009

13;Feb;2008 23;Jan;2009



12;May;2008 28;Jan;2009

12;May;2008 28;Jan;2009

12;May;2008 28;Jan;2009

12;May;2008 28;Jan;2009

30;Oct;2008 23;Jan;2009



ReportLinks FilterColumn FilterExpression



Search;Filter;Sort;Save as Excel CUSIP;Name equals;equals

















Search;Filter;Sort;Save as Excel From CUSIP;Name equals;equals





Search;Filter;Sort;Save as Excel Name;From CUSIP equals;equals




Search;Filter;Sort;Save as Excel Depositary;Country of Management equals;equals





Search;Filter;Sort;Save as Excel Month;Month equals;equals









Search;Filter;Sort;Save as Excel Month;Month equals;equals




Search;Filter;Sort;Save as Excel Name;CUSIP equals;equals




Search;Filter;Sort;Save as Excel Name;CUSIP equals;equals





FilterValue FilterCondition

022205108;ALUMINA LIMITED AND;OR

022205108;ALUMINA LIMITED AND;AND

022205108;ALUMINA LIMITED AND;OR



New;Old OR;OR

ARM;042068106 AND;OR

Biotech HOLDRS;09067D201 OR;OR



Acer - Reg. S;London Stock Exchange OR;OR



From CUSIP;Name ascending;ascending

Name;Event Date ascending;ascending

Depositary;Country of Management ascending;descending



Month;Trading Volume ascending;ascending



Trading Volume;Trading Volume ascending;ascending

Name;CUSIP ascending;ascending




DR Name;Exchange ascending;ascending



ReportNamesString

CUSIP Profile Trading Volume Daily Report;CUSIP Profile Trading Volume Monthly Report;CUSIP Profile TDR Programs;Trading Volume for Exchange Listed (Level II, III) DR Programs;Trading Volume for OTC (L

CUSIP Profile Trading Volume Daily Report;CUSIP Profile Trading Volume Monthly Report;CUSIP Profile T

DR Programs;Trading Volume for Exchange Listed (Level II, III) DR Programs;Trading Volume for OTC (L





















Y TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1

TestCase 1Y TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2


TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2

TestCase 2



TestCase 2

TestCase 2

Y TestCase 3

TestCase 3

TestCase 3


TestCase 3

TestCase 3

TestCase 3

TestCase 3

TestCase 3

TestCase 3

TestCase 3

TestCase 3

TestCase 3

TestCase 3

TestCase 3

TestCase 3

Y TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4



TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

TestCase 4

Y TestCase 5

TestCase 5

TestCase 5

TestCase 5

TestCase 5

TestCase 5

TestCase 5

TestCase 5

TestCase 5

TestCase 5

TestCase 5

Y TestCase 6

TestCase 6

TestCase 6



TestCase 6

TestCase 6

TestCase 6

TestCase 6

TestCase 6

TestCase 6

TestCase 6

TestCase 6

TestCase 6

Y TestCase 7

TestCase 7

TestCase 7

TestCase 7

TestCase 7

TestCase 7

TestCase 7

TestCase 7

TestCase 7

Y TestCase 8

TestCase 8



TestCase 8

TestCase 8

TestCase 8

TestCase 8

TestCase 8

TestCase 8

TestCase 8

Y TestCase 9

TestCase 9

TestCase 9

TestCase 9

TestCase 9

TestCase 9

TestCase 9

TestCase 9

Y TestCase 10

TestCase 10

Y TestCase 11

TestCase 11

TestCase 11

TestCase 11

TestCase 11

TestCase 11

TestCase 11



TestCase 11

Y TestCase 12

TestCase 12

TestCase 12

TestCase 12

TestCase 12

TestCase 12

TestCase 12

TestCase 12

TestCase 12

Y TestCase 13

TestCase 13

TestCase 13

TestCase 13

TestCase 13

TestCase 13

TestCase 13

TestCase 13

TestCase 13

Y TestCase 14

TestCase 14

TestCase 14

TestCase 14

TestCase 14

TestCase 14



TestCase 14

TestCase 14

TestCase 14

Y TestCase 15

TestCase 15

TestCase 15

TestCase 15

TestCase 15

TestCase 15

TestCase 15

TestCase 15

TestCase 15



TestCaseDesc MenuPath

Report generation for Share of Total DR Programs Reports;Market Review





Report generation for Share of Total DR Programs Reports;Market ReviewReport generation for Share of Total DR Programs Reports;Market Review











Report generation for Share of Total DR Programs Reports;Market ReviewReport generation for Share of New DR Programs Reports;Market Review

Report generation for Share of New DR Programs Reports;Market Review










Report generation for Share of New DR Programs Reports;Market ReviewReport generation for Share of New DR Programs Reports;Market Review












Report generation for Total Number of DR ProgramsReports;Market Review

Report generation for Total Number of DR Programs Reports;Market Review


Report generation for Total Number of DR Programs Reports;Market ReviewReport generation for Total Number of DR Programs Reports;Market Review











Report generation for Total Number of DR Programs

Reports;Market Review


Report generation for Total Number of New DR ProgramsReports;Market Review







































Report generation for Percentage of DR Programs by Country of Management











Report generation for Percentage of New DR Programs by Country of Management





Report generation for Annual Volume of Total DR ProgramsReports;Market Review

Report generation for DR Share Trading Volume Country of ManagementReports;Market Review







Report generation for DR Share Trading Volume Country of Management

Reports;Market ReviewReport generation for DR Share Trading Volume Country of Management


Report generation for DR Trading Volume by DepositaryReports;Market Review




Report generation for DR Trading Volume by Depositary

Reports;Market ReviewReport generation for DR Trading Volume by Depositary





Report generation for DR Trading Volume by ExchangeReports;Market Review

Report generation for DR Trading Volume by Exchange

Reports;Market ReviewReport generation for DR Trading Volume by Exchange










Report generation for Top Most Actively Traded DRsReports;Market Review











PageName

Share of Total DR Programs





Share of Total DR ProgramsShare of Total DR Programs











Share of Total DR ProgramsShare of New DR Programs

Share of New DR Programs










Share of New DR ProgramsShare of New DR Programs












Total Number of DR Programs



Total Number of DR ProgramsTotal Number of DR Programs













Total Number of New DR Programs

























Percentage of DR Programs by Country of Management











Percentage of New DR Programs by Country of Management














BNY Share of Total DR Programs









BNY Share of New DR Programs











Share of New DR Programs (2 ranges)








All DR Programs Detail

All DR Programs Detail

Annual Volume of Total DR Programs










DR Share Trading Volume by Country of Management









DR Trading Volume by Depositary









DR Trading Volume by Exchange











Top Most Actively Traded DRs











ReportHeader AsOfDate A FromDate

MarketReviewSet1ReportHeader 5;Feb;1995 Step 6

MarketReviewSet1ReportHeader 31;Jan;1995 Step 11




MarketReviewSet1ReportHeader 9;Feb;1995 Step 23MarketReviewSet1ReportHeader 10;Feb;1995 Step 26











MarketReviewSet1ReportHeaderMarketReviewSet1ReportHeader Step 5 17;Aug;1984

MarketReviewSet1ReportHeader Step 8 01;Jan;2008










MarketReviewSet1ReportHeader Step 38 11;Jan;2008MarketReviewSet1ReportHeader Step 41 12;Jan;2008





MarketReviewSet1ReportHeader Step 56 01;Dec;2005





MarketReviewSet1ReportHeader 04;Feb;1999

MarketReviewSet1ReportHeader Step 79 04;Feb;2001

MarketReviewSet2ReportHeader Step 5-Extra 17;Aug;1985



MarketReviewSet2ReportHeader Step 16 03;Feb;1999MarketReviewSet2ReportHeader Step 19 04;Feb;1999











MarketReviewSet2ReportHeader 15;Feb;1975

MarketReviewSet2ReportHeader Last 16;Feb;1993

MarketReviewSet2ReportHeader Step 5 17;Aug;1993

MarketReviewSet2ReportHeader 01;Jan;1999













Step 52-Filter andSort

Step 10-Starts










MarketReviewSet2ReportHeader 21;Jan;1989

MarketReviewSet2ReportHeader GeneLink 22;Jan;2005

MarketReviewSet2ReportHeader 17;Aug;1987 Step 5-Link

MarketReviewSet2ReportHeader 01;Jun;2000 Step 10-Link

MarketReviewSet2ReportHeader 02;Jun;2000 Step 15







MarketReviewSet2ReportHeader 09;Jun;2000

MarketReviewSet2ReportHeader 10;Jun;2000 Last

MarketReviewSet2ReportHeader Step 5- Extra 17;Aug;1996



Step 70 -Filter Starts

Step 36-Filter










MarketReviewSet2ReportHeader 29;Aug;1988

MarketReviewSet2ReportHeader Last 30;Aug;2008












Step 37 -Filter Starts

Step 30 -

Filter startshere
















MarketReviewSet5ReportHeader Step 25-Filter 23;Dec;1999

MarketReviewSet5ReportHeader Last 24;Dec;1999

MarketReviewSet2ReportHeader 1st

MarketReviewSet2ReportHeader Last - Filter

MarketReviewSet3ReportHeader Step 5 -Era 02;Jun;2005






MarketReviewSet3ReportHeader Step 25 - Filte23;Aug;2006

Step 28-FilterStarts



MarketReviewSet3ReportHeader Last 24;Aug;2006

MarketReviewSet6ReportHeader Step 5: Extra 17;Aug;1999







MarketReviewSet6ReportHeader Step 28-Filter 11;Jan;2007

MarketReviewSet6ReportHeader Las 25;Aug;2007

MarketReviewSet4ReportHeader Step 5- Extra 17;Aug;2000

MarketReviewSet4ReportHeader Step 10 15;Oct;2004






MarketReviewSet4ReportHeader Step 28 - Filte21;Oct;2004

MarketReviewSet4ReportHeader Last 22;Oct;2004

MarketReviewSet3ReportHeader Step 5 -Extra 1;Jan;2009

MarketReviewSet3ReportHeader Step 10 17;Mar;2007








MarketReviewSet3ReportHeader Step 28 - Filte23;Mar;2007

MarketReviewSet3ReportHeader last 24;Mar;2007

MarketReviewSet6ReportHeader Step 5 - Extra17;Aug;2002







MarketReviewSet6ReportHeader 25;Dec;2007

MarketReviewSet6ReportHeader Last 25;Jun;2007

Step 28 -Filter



ToDate From_Date To_Date RadioGroupDetails

All;Public;Listed;Private All N

All;Public;Listed;Private Public Y

All;Public;Listed;Private Public N

All;Public;Listed;Private Listed N

All;Public;Listed;Private Private N

All;Public;Listed;Private All YAll;Public;Listed;Private All Y

All;Public;Listed;Private All Y




All;Public;Listed;Private Listed Y



All;Public;Listed;Private Private Y



All;Public;Listed;Private All N5;Jun;1993 All;Public;Listed;Private All Y

15;Aug;2008 All;Public;Listed;Private All N

16;Aug;2008 All;Public;Listed;Private Public N

17;Aug;2008 All;Public;Listed;Private Listed N

18;Aug;2008 All;Public;Listed;Private Private N

19;Aug;2008 All;Public;Listed;Private All Y

20;Aug;2008 All;Public;Listed;Private Public Y

21;Aug;2008 All;Public;Listed;Private Listed Y

22;Aug;2008 All;Public;Listed;Private Private Y



25;Aug;2008 All;Public;Listed;Private Listed Y26;Aug;2008 All;Public;Listed;Private Private Y



29;Aug;2008 All;Public;Listed;Private Listed Y

30;Aug;2008 All;Public;Listed;Private Private Y

01;Sep;2008 All;Public;Listed;Private All Y

02;Sep;2008 All;Public;Listed;Private Public Y

03;Sep;2008 All;Public;Listed;Private Listed Y

RadioGroupIndex

IncludeUnsponsoredDRs



04;Sep;2008 All;Public;Listed;Private Private Y

05;Sep;2008 All;Public;Listed;Private Private N

5;Jun;1994 All;Public;Listed;Private All N

01;Dec;2000 All;Public;Listed;Private Public N

02;Dec;2000 All;Public;Listed;Private Listed N

03;Dec;2000 All;Public;Listed;Private Private N04;Dec;2000 All;Public;Listed;Private All Y

05;Dec;2000 All;Public;Listed;Private Public Y

06;Dec;2000 All;Public;Listed;Private Listed Y

07;Dec;2000 All;Public;Listed;Private Private Y

08;Dec;2000 All;Public;Listed;Private All Y










01;Jan;2000 All;Public;Listed;Private Public N

02;Jan;2000 All;Public;Listed;Private Listed N

03;Jan;2000 All;Public;Listed;Private Private N

04;Jan;2000 All;Public;Listed;Private All Y

05;Jan;2000 All;Public;Listed;Private Public Y

06;Jan;2000 All;Public;Listed;Private Listed Y

07;Jan;2000 All;Public;Listed;Private Private Y















20;Jan;2000 All;Public;Listed;Private All N




















14;Jan;2008 All;Public;Listed;Private Listed N







21;Jan;2008 All;Public;Listed;Private Public


17;Jun;2008 All;Public;Listed;Private Private N

19;Jun;2008 All;Public;Listed;Private Listed N

20;Jun;2008 All;Public;Listed;Private All Y


22;Jun;2008 All;Public;Listed;Private Private Y

23;Jun;2008 All;Public;Listed;Private Public Y


25;Jun;2008 All;Public;Listed;Private Public







21;Jun;2008 All;Public;Listed;Private Public N










22;Jun;2000 All;Public;Listed;Private Listed Y



N

Y








5;Aug;2004

17;Dec;2005

19;Aug;20

04

16;Dec;20

0520;Aug;2004

15;Dec;2005

21;Aug;2004

14;Dec;2005

22;Aug;2004

13;Dec;2005

23;Aug;2004

12;Dec;2005

24;Aug;2004

11;Dec;2005

25;Aug;2004

10;Dec;2005



17;Jan;2008 All;Public;Listed;Private Listed








20;Feb;2008 All;Public;Listed;Private All N

21;Jan;2008 All;Public;Listed;Private Public


16;Jun;2005 All;Public;Listed;Private Listed Y









18;Nov;2007 All;Public;Listed;Private Listed Y

19;Nov;2007 All;Public;Listed;Private Public N

20;Nov;2007 All;Public;Listed;Private Public N

21;Nov;2007 All;Public;Listed;Private All Y

22;Nov;2007 All;Public;Listed;Private All Y



23;Nov;2007 All;Public;Listed;Private All N

24;Nov;2007 All;Public;Listed;Private All N

25;Nov;2007 All;Public;Listed;Private Private


15;Apr;2004 All;Public;Listed;Private Listed Y

16;Apr;2004 All;Public;Listed;Private Public N

17;Aug;2005 All;Public;Listed;Private Public N





21;Sep;2008 All;Public;Listed;Private All Y



Title SubTitle Footer

N N

Y Y

N N

N N

N N

N NN Y

Y Y

N N

N Y

Y Y

N N

N Y

Y Y

N N

N Y

Y Y

N NY Y

N N

N N

N N

N N

N N

N N

N N

N N

N Y

N Y

N YN Y

Y Y

Y Y

Y Y

Y Y

Y Y Y

Y Y Y

Y Y Y

SuccessorAppointment

OfferingData

CapitalRaised

TradingValue



Y Y Y

N N N

N N

N N

N N

N NN N

N N

N N

N N

Y N

Y N

Y N

Y N

Y Y

Y Y

Y Y

Y Y

Y Y

N N

N N

N N

N N

N N

N N

N N

N N

Y N

Y N

Y N

Y N

Y Y

Y Y



Y Y

Y Y

Y Y Y

Y Y Y

Y Y Y

Y Y Y

N Y

N Y

N N

N N

N N

N N

N N

N N

Y N

N Y

N N

Y Y

Y Y

N N

N N

N N

N N



Y N

N Y

N Y Y

Y Y

Y N

Y N

Y Y

Y Y Y

N N

N N

N Y

N N

Y N

Y N

N Y

Y Y

N N

N N



N N

N Y

Y N

Y Y

N Y

Y Y

N N

N N

Y N

N Y

N N

N Y

Y Y

N N

N

N Y

N N

Y N

N Y

Y N

Y Y



Y Y

N N

Y N

N Y

Y N

N Y

Y Y

N N

Y Y

N N

Y Y

N Y

Y N

N Y

Y Y

N N

Y Y

N N

Y N

N Y

Y N

N Y



Y Y

N N

Y Y

N N

Y N

N Y

Y N

N Y

Y Y

N N

N N



ClickSaveasExcelLink

Share of Total DR Programs - Microsoft Internet Explorer

Share of Total DR Programs - Microsoft Internet Explorer

Share of New DR Programs - Microsoft Internet Explorer



Share of New DR Programs - Microsoft Internet Explorer

Total Number of DR Programs - Microsoft Internet Explorer

Total Number of DR Programs - Microsoft Internet Explorer

Total Number of New DR Programs - Microsoft Internet Explorer



Total Number of New DR Programs - Microsoft Internet Explorer

Percentage of DR Programs by Country of Management - MicrosoftInternet Explorer

Percentage of DR Programs by Country of Management - MicrosoftInternet Explorer

Percentage of New DR Programs by Country of Management - Microsoft

Internet Explorer



BNY Share of Total DR Programs - Microsoft Internet Explorer

BNY Share of Total DR Programs - Microsoft Internet Explorer

BNY Share of New DR Programs - Microsoft Internet Explorer


Percentage of New DR Programs by Country of Management - MicrosoftInternet Explorer




Share of New DR Programs \(2 ranges\) - Microsoft Internet Explorer

Share of New DR Programs \(2 ranges\) - Microsoft Internet Explorer

All DR Programs Detail - Microsoft Internet Explorer

All DR Programs Detail - Microsoft Internet Explorer

Annual Volume of Total DR Programs - Microsoft Internet Explorer

Annual Volume of Total DR Programs - Microsoft Internet Explorer



DR Trading Volume by Depositary - Microsoft Internet Explorer

DR Trading Volume by Depositary - Microsoft Internet Explorer

DR Trading Volume by Exchange - Microsoft Internet Explorer

DR Share Trading Volume by Country of Management - MicrosoftInternet Explorer

DR Share Trading Volume by Country of Management - Microsoft

Internet Explorer



DR Trading Volume by Exchange - Microsoft Internet Explorer

Top Most Actively Traded DRs \(NYSE, NASDAQ,AMEX\) - MicrosoftInternet Explorer

Top Most Actively Traded DRs \(NYSE, NASDAQ,AMEX\) - MicrosoftInternet Explorer



MarketReviewReportsLinks FilterColumn


Search;Filter;Sort;Save as Excel Industry;CUSIP




Search;Filter;Sort;Save as Excel Industry;CUSIP


Search;Filter;Sort;Save as Excel Depositary(s);CUSIP




Search;Filter;Sort;Save as Excel Depositary(s);Exchange


Search;Filter;Sort;Save as Excel Type;Type


Search;Filter;Sort;Save as Excel S/U;Type





Search;Filter;Sort;Save as Excel Origin;Exchange

Search;Filter;Sort;Save as Excel Structure;Structure



Search;Filter;Sort;Save as Excel Origin;Ticker Symbol


Search;Filter;Sort;Save as Excel Industry;Origin


Search;Filter;Sort;Save as Excel Industry;Exchange


Search;Filter;Sort;Save as Excel Industry;Origin




Search;Filter;Sort;Save as Excel Industry;S/U




Country of Management;Exchange



Search;Filter;Sort;Save as Excel Trading Volume;Effective Date


Search;Filter;Sort;Save as Excel Origin;Country of Management



FilterExpression FilterValue FilterCondition

contains;equals Metals;038754107 AND;AND



contains;contains Real Estate;23282 AND;AND

equals;contains BNY;104 AND;AND



equals;contains JPM;New York AND;AND

contains;contains Level I;Level II AND;OR

equals;contains BNY;New York AND;AND

contains;contains King;Add OR;AND



equals;contains BNY;None AND;AND

equals;equals NEW;None AND;AND

equals;contains 144;Reg OR;AND



contains;equals Banks;S AND;AND

equals;contains India;Stock AND;OR



contains;contains 20;Mar AND;AND

contains;equals NEW;Brazil AND;AND



SortColumn SortOrder

Exchange;Industry ascending;ascending

SaveasExcelRequired

SummaryReportRequired



Exchange;Industry ascending;ascending

Name;Industry ascending;ascending




Name descending Y Y

Name;Ticker Symbol ascending;ascending

S/U descending Y Y



Name;Ticker Symbol ascending;ascending

ascending;ascending

CUSIP descending Y Y

Country of Management;Industry



ascending;ascending

ascending;ascending

Y N

ascending;ascending

Y Y


Country of Management;TickerSymbol

Country of Management;TickerSymbol

Country of Managemetn;TickerSymbol



Y Y

ascending;ascending

Y Y


Country of Management;Ticker

Symbol



SelectRequiredLink

R1. Share of Total DR Programs





R1. Share of Total DR ProgramsR1. Share of Total DR Programs











R1. Share of Total DR ProgramsR2. Share of New DR Programs

R2. Share of New DR Programs










R2. Share of New DR ProgramsR2. Share of New DR Programs












R3. Total Number of DR Programs



R3. Total Number of DR ProgramsR3. Total Number of DR Programs













R4. Total Number of New DR Programs

























R5. Percentage of DR Programs byCountry of Management











R6. Percentage of New DR Programs by


R6. Percentage of New DR Programs byCountry of Management




R7. BNY Share of Total DR Programs









R8. BNY Share of New DR Programs




















R10. All DR Programs - Detail

R10. All DR Programs - Detail

R9. BNY Share of New DR Programs \(2ranges\)

R9. BNY Share of New DR Programs \(2

ranges\)R9. BNY Share of New DR Programs \(2ranges\)






R11. Annual Volume of Total DRPrograms









R13. DR Trading Volume by Depositary









R14. DR Trading Volume by Exchange







R12. DR Trading Volume by Country of Management







R12. DR Trading Volume by Country of

ManagementR12. DR Trading Volume by Country of Management






R15. Top 100 Most Actively Traded DRs











RequiredLink

R1. Share of Total DR Programs;R2. Share of New DR Programs;R3.

Total Number of DR Programs;R4. Total Number of New DRPrograms;R5. Percentage of DR Programs by Country of Management;R6. Percentage of New DR Programs by Country of Management;R7. BNY Share of Total DR Programs;R8. BNY Share of New DR Programs;R9. BNY Share of New DR Programs (2ranges);R10. All DR Programs - Detail;R11. Annual Volume of Total DRPrograms;R12. DR Trading Volume by Country of Management;R13.DR Trading Volume by Depositary;R14. DR Trading Volume byExchange;R15. Top 100 Most Actively Traded DRs;




TestCase1 Y

TestCase2 Y

TestCase3 Y

TestCase4 Y

TestCase5 Y

TestCase5 Y

TestCase5 Y

TestCase6 Y

TestCase7 Y

TestCase8 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y

TestCase10 Y

TestCase11 Y

TestCase12 Y

TestCase13 Y

TestCase13 Y

TestCase13 Y

TestCase14 Y

TestCase15 Y

TestCase16 Y

TestCase17 Y

TestCase17 Y

TestCase17 Y



TestCase18 Y



TestCaseDesc

View the Reports of Books Closed

View the Report of Books Closed with Books Closed Flag Reason Report

View the Report of Books Closed with Books Closed for Cancellation and Apply Report

View the Report of Books Closed with Books Closed for Cancellation and Apply Report Search, Filter , A

View the Report of Books Closed with Books Closed for Cancellation and Apply Report Search, Sort, Ad



View the Report of Books Closed with Books Closed for Cancellation and Apply Report, search and Sav

View the Report of Books Closed with Books Closed Pending Report

View the Report of Books Closed with Books Closed Pending Report Search, Filter, Add Filter and Delet

View the Report of Books Closed with Books Closed Pending Report Search, Sort, Add Sort and Delete



View the Report of Books Closed with Books Closed Pending Report, search and Save as Excel

View the Report of Books Closed with Books Closed Report

View the Report of Books Closed with Books Closed Report Search, Filter, Add Filter and Delete

View the Report of Books Closed with Books Closed Report Search, Sort, Add Sort and Delete



View the Report of Books Closed with Books Closed Report, search and Save as Excel

View the Report of Books Closed with Orphan CUSIP Books Closed Report

View the Report of Books Closed with Orphan CUSIP Books Closed Report Search Filter, Add Filter and

View the Report of Books Closed with Orphan CUSIP Books Closed Report Search ,Sort, Add Sort and D





View the Report of Books Closed with Orphan CUSIP Books Closed Report, search and Save as Excel



MenuPath ReportName

Reports;Books Closed

Reports;Books Closed Books Closed for Cancellation and Apply Report







Reports;Books Closed Books Closed Pending Report






Reports;Books Closed Books Closed Report






Reports;Books Closed Orphan CUSIP Books Closed Report







ReportLinks



























ReportNamesString

Books Closed Flag Reason Report;Books Closed for Cancellation and Apply Report;Books Closed Pending



























DRName CUSIP

Alto Palermo 02151P107






TABCORP HOLDINGS LIMITED 144A 778200204





APT SATELLITE HOLDINGS 778200204

ABSA GROUP 00077C408






URALKALY OAO - REG S 67418N203







CUSIPName BooksClosedReason FilterColumn

ALTO PALERMO S.A. Company Request

ALTO PALERMO S.A. Company Request Name;CUSIP





ROSNEFTEGAZSTROY (JSC) Termination of program

ROSNEFTEGAZSTROY (JSC) Termination of program Transaction Type;CUSIP





ABSA GROUP Competitor DR

ABSA GROUP Competitor DR Transaction Type;CUSIP





URALKALY OAO - REG S Committed DR

URALKALY OAO - REG S Committed DR Transaction Type;CUSIP






FilterExpression FilterVal FilterCondition SortColumn

equals;equals Alto Palermo;02151P107 AND;AND

CUSIP

Name

DR Type;Name

equals;equals DR Apply;00203R105 AND;AND

Transaction Type

CUSIP

Name;CUSIP

equals;equals DR Apply;00077C408 AND;AND

Transaction Type

CUSIP

Name;CUSIP

equals;equals DR Apply;67418N203 AND;AND

Transaction Type

CUSIP

Name;CUSIP



SortOrder

ascending

ascending

ascending;ascending

ascending

ascending

ascending;ascending

ascending

ascending

ascending;ascending

ascending

ascending

ascending;ascending




TestCase1 Y

TestCase2 Y

TestCase3 Y

TestCase4 Y

TestCase4 Y


TestCase6 Y

TestCase7 Y

TestCase8 Y

TestCase8 Y

TestCase8 Y

TestCase8 Y

TestCase8 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y


TestCase9 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y

TestCase9 Y


TestCase11 Y

TestCase12 Y

TestCase13 Y

TestCase14 Y

TestCase15 Y

TestCase16 Y

TestCase17 Y

TestCase18 Y

TestCase19 Y

TestCase20 Y


TestCase23 Y

TestCase24 Y

TestCase25 Y

TestCase26 Y

TestCase27 Y

TestCase28 Y

TestCase29 Y



TestCase30 Y

TestCase31 Y

TestCase32 Y

TestCase33 Y

TestCase34 Y

TestCase35 Y


TestCase38 Y

TestCase39 Y

TestCase40 Y

TestCase41 Y

TestCase42 Y

TestCase43 Y



View the Reports Screen of HOLDR - Client Services with Monthly IssueCancel Activity, Searc

View the Reports Screen of HOLDR - Client Services with Monthly IssueCancel Activity, Searc

View the Reports Screen of HOLDR - Client Services with Daily IssueCancel Activity, Search.

View the Reports Screen of HOLDR - Client Services with Daily HOLDR Issue / Cancel Activity



View the Reports Screen of HOLDR - Client Services with Cross Border Activity ,Search.View the Reports Screen of HOLDR - Client Services with Cross Border Activity , Search with

View the Reports Screen of HOLDR - Client Services with Cross Border Activity , Search with

View the Reports Screen of HOLDR - Client Services with Cross Border Activity , Search with

View the Reports Screen of HOLDR - Client Services with Daily Broker Activity ,Search.

View the Reports Screen of HOLDR - Client Services with Daily Broker Activity , Search with v





MenuPath ReportName

Reports;HOLDR;Search

Reports;HOLDR;Search HOLDR Search



Reports;HOLDR;Search Constituent Search

Reports;HOLDR;Search HOLDR with Constituent SearchReports;HOLDR;Search HOLDR Search








Reports;HOLDR;Search HOLDR with Constituent Search



Reports;HOLDR;Search HOLDR with Constituent SearchReports;HOLDR;Search HOLDR with Constituent Search











Reports;HOLDR;Search HOLDR with Constituent SearchReports;HOLDR;Search HOLDR with Constituent Search



Reports;HOLDR;Operation HOLDR Master Spreadsheet



Reports;HOLDR;Operation HOLDR Reconciliation Spreadsheet

Reports;HOLDR;Operation HOLDR Reconciliation Spreadsheet

Reports;HOLDR;Operation HOLDR Issuance/Cancellation Instruction

Reports;HOLDR;Operation HOLDR Audit Log

Reports;HOLDR;Operation HOLDR Audit Log

Reports;HOLDR;Operation HOLDR Audit LogReports;HOLDR;Operation HOLDR Audit Log

Reports;HOLDR;Operation Cash Delivery Report




Reports;HOLDR;Client Services Cash Delivery Report

Reports;HOLDR;Client Services Monthly IssueCancel Activity






Reports;HOLDR;Client Services Daily IssueCancel Activity




Reports;HOLDR;Client Services Cross Border ActivityReports;HOLDR;Client Services Cross Border Activity

Reports;HOLDR;Client Services Cross Border Activity

Reports;HOLDR;Client Services Cross Border Activity

Reports;HOLDR;Client Services Daily Broker Activity






ReportLinks InitialDepositor HOLDRName


Search;Filter;Sort;Save as Excel Merrill Lynch-HOLDRS Biotech HOLDRS



Search;Filter;Sort;Save as ExcelSearch;Filter;Sort;Save as Excel Biotech HOLDRS

Search;Filter;Sort;Save as Excel Biotech HOLDRS

























Search;Filter;Sort;Save as Excel Brazilian Telecom HOLDRS







Search;Filter;Sort;Save as Excel Biotech HOLDRSSearch;Filter;Sort;Save as Excel Biotech HOLDRS
















Search;Filter;Sort;Save as Excel Biotech HOLDRSSearch;Filter;Sort;Save as Excel Biotech HOLDRS









Status Exchange HOLDRCusip ConstituentName

Effective New York Stock Exchange 09067D201

New York Stock Exchange

Effective

Effective

Effective

ALCATEL-LUCENT

056033103

71712A206

71712A206



ConstituentExchange ConstituentTicker ConstituentISIN ConstituentCUSIP


American Stock Exchange

ALU

US0420681068

New York Stock Exchange ALU US0139043055 013904305



ConstituentSecurityType ConHOLDRName ConStatus ConHOLDRExchange

Software HOLDRS New York Stock Exchange

DR Security

DR Security

US Security Biotech HOLDRS Effective


Biotech HOLDRS Effective

US Security Biotech HOLDRS

Pharmaceutical HOLDRS



Abbott LaboratoriesBiotech HOLDRS New York Stock Exchange

Biotech HOLDRS New York Stock Exchange

CP HOLDRS New York Stock Exchange



ConHOLDRTicker ConHOLDRCUSIP ConConstituentSecurityType ConShareCount

100



ConConstituentName ConConstituentCUSIP ConConstituentISIN ConConstituentTicker

ALCATEL-LUCENT

Agile Software Corp

00846X105

US92532L4041



ConConstituentExchange FromDate ToDate BrokerName ShareCount



25;Jan;2008

30;Oct;2008

31;Oct;2008

31;Oct;2008

100

15;May;2008 10;Jan;2009

15;May;2008 10;Jan;2009

15;May;2008 10;Jan;200915;May;2008 10;Jan;2009

15;May;2008 10;Jan;2009

15;May;2008 10;Jan;2009

15;May;2008 10;Jan;2009

15;May;2008 10;Jan;2009



TransactionType SelectHOLDRName SelectHOLDRCusip SelectConstituent

Biotech HOLDRS 09067D201

Issuance

Applied Biosystems Inc

Applied Biosystems Inc



SelectAffectedCUSIP SelectDeclaredConstituent SelectDeclaredCUSIP

038149100 Applied Biosystems Inc 038149100

038149100 Applied Biosystems Inc 038149100



ReportNamesString

HOLDR Search;Constituent Search;HOLDR with Constituent Search





HOLDR Search;Constituent Search;HOLDR with Constituent SearchHOLDR Search;Constituent Search;HOLDR with Constituent Search

























HOLDR Master Spreadsheet;HOLDR Reconciliation Spreadsheet;HOLDR Issuance/Cancellation Instructio








HOLDR Master Spreadsheet;HOLDR Reconciliation Spreadsheet;HOLDR Issuance/Cancellation InstructioHOLDR Master Spreadsheet;HOLDR Reconciliation Spreadsheet;HOLDR Issuance/Cancellation Instructio





Monthly IssueCancel Activity;Daily IssueCancel Activity;Cross Border Activity;Daily Broker Activity











Monthly IssueCancel Activity;Daily IssueCancel Activity;Cross Border Activity;Daily Broker ActivityMonthly IssueCancel Activity;Daily IssueCancel Activity;Cross Border Activity;Daily Broker Activity









FilterColumn FilterExpression FilterValue FilterCondition

HOLDR Name equals Biotech HOLDRS AND


Affected Constituent equals Applied Biosystems Inc AND

Effected Constituent Name equals Applied Biosystems Inc AND




SortColumn SortOrder

HOLDR Name ascending


Affected Constituent ascending

Effected Constituent Name ascending




Y TestCase1

Y TestCase2

Y TestCase3



TestCaseDesc

Generating the Administration - BNY Position Search results

Verifying the link in 'Position' column in the BNY Position Search results and checking the 'Related' butt

Checking the 'New' button functionality in Administration - BNY Position Search page



MenuName






VersionDate MenuPath Position PositionCode

Version 4.01 Built on October 14, 2008 ADMINISTRATION;Position Analyst





Position_New PositionCode_New

RECESQ REAJ




Y TestCase1

Y TestCase2

Y TestCase3



TestCaseDesc

Generating the Administration - Sub department Search results

Verifying the link in Subdepartment column in the Subdepartment Search Results and checking 'Related

Verifying the functionality of 'New' button in the Administration - Subdepartment Search page



MenuName






VersionDate MenuPath Subdepartment

Version 4.01 Built on October 14, 2008 ADMINISTRATION;Subdepartment ADR INDEX





SubdepartmentCode Subdepartment_New SubdepartmentCode_New

RECEST REAF




Y TestCase1

Y TestCase2

Y TestCase3



TestCaseDesc

Generating the Administration - Department Category Search results

Verifying the link in Department Name column in the Department Search Results and checking the 'Rel

Verifying the functionality of New Button in the Administration - Department Category Search page



MenuName






VersionDate MenuPath DepartmentName

Version 4.01 Built on October 14, 2008 ADMINISTRATION;Department Administration





DepartmentCode DepartmentName_New DepartmentCode_New

TORNADO TOND



DRDepartmentFlag_New Subdepartment Position Location Subdepartment1

Yes ADR Systems Administrator US Company Desk



Position1 Location1

Associate US



A B CUSIPReportSearchHeader CUSIPReportPredefinedActiveOrphanHeader

Item Item

Name CUSIP

CUSIP Name

S/U S/U

Type Underlying ISIN

Home Market Country Underlying SEDOL

Ratio DRs DR Exchange

Ratio Underlying Shares DRs Outstanding

DR Ticker Symbol DRs Issued

DR Exchange Entry Reason

DR ISIN Insert Date

DR SEDOL

Common Depository

Nominee Account #

ACTION Company #

Action Issue #

Pre-Release %Specialist Firm

Active Flag

Effective Flag

Multiple Underlying Flag

Underlying ISIN

Underlying SEDOL

Depositary

Books Closed

DR Status



CUSIPReportPredefinedDuplicateIssueHeader

Item

Name

CUSIP

Price Date

Price(USD)

Active Flag

S/U

Depositary



CUSIPReportEffectiveInActiveDRsHeader CUSIPReportPendingTransactionHeader

Item Item

DR Name Transaction Number

Status Transaction Type

Origin Status

Structure DR Balance

CUSIP ORD Balance

DR Exchange Fee

S/U Collateral

CUSIP Name CUSIP

Active Flag Name

Depositary CUSIP Type

Issuer Active Flag

Successor Eff Flag

Type DR Connected

Ratio DRs

Ratio Underlying Shares



MarketReviewSet1ReportHeader MarketReviewSet2ReportHeader

Item Item

Name Name

Status Status

Effective Date Effective Date

Termination Date Termination Date

S/U S/U

Depositary(s) Depositary(s)

Exchange Exchange

Country of Management Country of Management

Industry Industry

Origin Origin

Type Type

Ratio (DRs:Und.) Ratio (DRs:Und.)

CUSIP CUSIP

Ticker Symbol Ticker Symbol

Region Geo Region

Successor SuccessorUnsponsored Conversion Unsponsored Conversion

Structure Structure

Upgrade Successor Upgrade Successor




Item Item


Name Name

Status Status



Origin Origin

S/U S/U

Type Type

Ratio (DRs:Und.) Ratio (DRs:Und.)

CUSIP CUSIP

Exchange Exchange

Ticker Symbol Ticker Symbol


Industry Industry

Successor Successor

Unsponsored Conversion Unsponsored ConversionGeo Region Geo Region

Active Flag Structure

Year Bifurcate ref

Trading Volume Bifurcate type

Trading Value Active Flag

Link Trading Volume

Trading Value

Link




Item Item


Name Name

Status Status



S/U Origin

Exchange S/U

Country of Management Type

Industry Ratio (DRs:Und.)

Origin CUSIP

Type Exchange

Ratio (DRs:Und.) Ticker Symbol

CUSIP Country of Management

Ticker Symbol Industry

Region Successor

Successor Unsponsored ConversionUnsponsored Conversion Region

Structure Structure

Upgrade Successor Bifurcate ref

Bifurcate type

Active Flag

Trading Volume

Trading Value

Link



ReportsHOLDRSearch ReportsConstituentSearch

Item Item

HOLDR Name Constituent Name

HOLDR CUSIP Constituent CUSIP

Status Constituent Ticker

Ticker Constituent Exchange

Secondary Ticker Constituent ISIN

Effective Date Constituent Price

Termination Date Constituent GICS Code

Termination Reason Constituent Last Sync Date

Constituent Security Type

Exchange Corporate Action value

Secondary Exchange Connected to a HOLDR

Clearing House

Secondary Clearing House

Price

Minimum Share Lot

CID#ISIN

TAS Acct No

ACTION Company#

ACTION Issue#

SEC S1 File Number

SEC S1 File Date

Local Tax

Corporate Action

Cash Delivery

Agreement TerminationDate



ReportsHOLDRwithConstituentSearch ReportsMasterSpreadsheet

Item NAME OF COMPANY

HOLDR Name CUSIP

HOLDR CUSIP TICKER

HOLDR Status

HOLDR Ticker

HOLDR Secondary Ticker

HOLDR Effective Date

HOLDR Termination Date

HOLDR Termination Reason

HOLDR Agreement Termination Date

HOLDR Exchange

HOLDR Secondary Exchange

HOLDR Clearing House

HOLDR Secondary Clearing House

HOLDR Price

HOLDR Minimum Share Lot

HOLDR CID#HOLDR ISIN

HOLDR TAS Acct No

HOLDR ACTION Company#

HOLDR ACTION Issue#

HOLDR SEC S1 File Number

HOLDR SEC S1 File Date

HOLDR Local Tax

Constituent Name

Constituent CUSIP

Constituent Ticker

Constituent ISIN

Constituent ExchangeConstituent Security Type

Constituent Price

Constituent Inclusion Date

Constituent Removal Date

Constituent Share Count

Constituent GICS

SHARE

AMOUNTSPer 100

PRIMARYTRADING

MARKET

C-I-LRate forFraction



ReportsReconciliationSpreadsheet ReportsAuditLog ReportsCashDeliveryReport

NAME OF COMPANY Item Item

CUSIP Event Date Effected Constituent Name

RATIO Affected Constituent CUSIP

REQUIRED Affected CUSIP Ticker Symbol

HELD Affected Ticker

DIFFERENCE CA Date(Declared Constituent)

Market Price System Comments CA Type(Declared Constituent)

Market Value of Difference CA Date Comments (Declared Constituent)

CA Type

CUSIP(Declared Constituent)

Start Date

Declared CUSIP End Date

Declared Ticker Rate

Comments on the effectedConstituent

Affected ConstituentComments

Constituent Name(Declared

Constituent)

Declared ConstituentComments

Declared ConstituentName



ReportsMonthlyHOLDRIssueCancelActivity ReportsDailyHOLDRIssueCancelActivity

Item Item

HOLDR Name HOLDR Name

HOLDR CUSIP HOLDR CUSIP

Month Date

Issued Issued

Cancelled Cancelled

Net Issued/Cancelled Net Issued/Cancelled

Total Issued/Cancelled Total Issued/Cancelled

Outstanding Outstanding

Outstanding % Change Close Price

Month End Close Price

Market Cap

Registered Holders

PreRelease Balance



ReportsHOLDRCrossBorderActivity ReportsDailyBrokerActivity

HOLDR Name Item

HOLDR CUSIP HOLDR Name

Broker HOLDR CUSIP

Issued Date

# Of Trans DRs Issued

Cancelled # of Trans Issued

# Of Trans DRs Cancelled

Net Issued/Canceled # of Trans Cancelled

Total Cross-Border Trading Net Issued/Cancelled

Total Broker Activity

Broker Activity as a % of Total

Total Cross-Border TradingActivity



DocumentationAgingSummaryReport DocumentationTrackingReport

Item Item

Document Name Region

90 Days CID#

120 Days DR Name

180 Days DR Status

1 Year DR Effective Date

Total Primary CUSIP


BCP Approval Date

BCP Review Date

PAF Date

PAF Division

F-6 File Date

Law Governing Deposit Agreement

Deposit Agreement Date

Letter Agreement Date

Letter Agreement ExpirationLetter Agreement Expiration Date

Reimbursement Agreement Expiration

Reimbursement Agreement Expiration Date

Pre-Release Side Letter

Operational Checklist

CAP Date

Termination Period

Voting Type

Blocking Type

CCC Code

CIK Code

Relationship Manager New YorkRelationship Manager

DSF in Deposit Agreement

Charge DSF

Net DSF from Cash Dividend

Depositary Service Fee

MAL/FOL

# of DRs Allowed

Restriction Type



On Website

Last Date Amended

Reportable MAL/FOL Available

Reportable MAL/FOL Percent Used

20-F Filer

12g3-2(b) Filer

12g3-2(b) #



DocumentationLetterAgreementExpirationDateReport

Item

Region

DR Name


RM NY

Letter Agreement Expiration

Letter Agreement Expiration Date



DocumentationNewDRBusinessReport BNYContactReportHeader

Item Item

Region Salutation

DR Name Last Name

Country of Management First Name and Middle Initial

RM NY Job Title

Successor Location

DR Type Department

Sub-Status Subdepartment

Estimated First Year Revenue Position

Effective Date Senior Management

RACF ID

Employee ID

Status

Mailing Address Line 1



Mail StopCity

State/Province

Zip/Postal Code

Country

Work #

Ext.

Fax #

E-mail Address

ADR Insight ID

ADR INFORM ID

INFORM ID

Assistant NameAssistant Phone #

Last Updated Date



PerfThresholdPricingReport DRSearchResults

Item Item

Name DR Name

Pricing Type CUSIP

Target Date Current CUSIP

Target Status

Additional Reimbursement Sub-Status

Comments Effective Date

DRs Termination Date

Country of Management Origin

Region S/U

Issuer Name Type

Relationship Manager New York Depositary

Relationship Manager Ratio DRs


DR Exchange

Single Listed

DR Ticker SymbolCountry of Management


Industry

Relationship Manager New York

Relationship Manager

Region

Sub Region

# Offerings

Successor

Previous Depositary

Unsponsored Conversion

StructureUnderlying ISIN

Underlying SEDOL

Price

Security Desc.

Termination Reason

Issuer

Marketing Officer

Unsponsored Administrator



Industry Code



AssetCommitteeTerminationReport InitialSaleDateReport

Item Item

DR Name DR Name

DR Status CUSIP

DR Effective Date Ratio DRs

DR Termination Date Ratio Underlying Shares

Termination Reason S/U


Subregion RM-NY

Region RM-Local

Approval Status Single Listed

Termination Date

Initial Sale Date

Underlying ISIN



DRsandtheirCorrespondingSpecialistFirmsReport DRsWithPre-ReleaseReport

Item Item

Name Name

Specialist Firm Name CUSIP

DR Ticker Symbol CUSIP Type

CUSIP DR Exchange

Effective Date DR Status

DR Status Pre-Release Limit %

Ratio (DRs:UndShares) Effective Date

DR Exchange RM NY

Security Description Country of Management

Price(USD) Depositary

Issuer Name S/U

Depositary DR Type

DR Origin



EffectiveBNYSponsoredDRsWithoutGBDorDRIP EffectiveGBDorDRIPReport

Item Item

Name DR Name

CUSIP Country of Management

DR Exchange Co. #

Country of Management CUSIP

RM NY RM NY

Effective Date RM NY Tel #

Successor GBD Issue #

GBD Effective Date

DRIP Issue #

DRIP Effective Date

DRIP

GBD



ThresholdReport DSFForecastReport-MaximumFee ReportsAdviser

Item Item Item

Name CUSIP Company

CUSIP CUSIP Name Status

CUSIP Type CUSIP Type Effective Date

DR Exchange CUSIP Price Termination Date

DR Type DR Effective Date Country of Incorporation

Status S/U Inform ID

Effective Date DSF in Deposit Agreement CID#

Termination Date Charge DSF Group E-Mail Address

Country of Management Net DSF from Cash Dividend Enterprise

Organization Region Depositary Service Fee Last Updated Date

Total # F-6 ADSs Reportable DRs Outstanding

DRs Outstanding Projected Maximum DSF

Depositary DSF Notice Date

S/U DSF U.S. Record Date

DSF Rate

Prior Year Div Fee CollectedCommon Depository


Region

Relationship Manager-New York



ReportsBroker ReportsCustodian

Item Item

Company Company

Status Mnemonic

Effective Date Status

Termination Date Effective Date

Country of Incorporation Termination Date

Inform ID Country of Incorporation

CID# Agent Type

Group E-Mail Address Own Program Only

SWIFT(BIC) CID#

Relationship Manager General SWIFT(BIC)

Enterprise Group E-Mail Address

Last Updated Date Custodian Custody Administrator General

Reconcilier

Freq. of Reconciliation

Enterprise

Last Updated Date



ReportsDepositary ReportsIssuer ReportsSubcompany

Item Item Item

Company Company Company

Status Status Parent Company

Effective Date Effective Date Type

Termination Date Termination Date Status

Country of Incorporation Country of Incorporation Effective Date

Inform ID Country of Mgmt Termination Date

CID# ACTION Co # Country of Incorporation

Group E-Mail Address Industry Inform ID

SWIFT(BIC) CID# CID#

Enterprise Group E-Mail Address Group E-Mail Address

Last Updated Date Government Owned Enterprise

Web Address Last Updated Date

ADR INFORM ID

Dividend Currency

Home Market Country

Home Market StatusRelationship Manager - New York

Broker Mktg Mgr

Relationship Mgr

Enterprise

Eff.BNYSp.

Last Updated Date

MAL/FOL

# of DRs Allowed

Restriction Type

On Website

Last Date Amended

Reportable MAL/FOL AvailableReportable MAL/FOL Percent Used



ReportsVendor IssuerProductsAndServicesReport

Item Item

Company Issuer

Status Status


Termination Date ADR INFORM

Country of Incorporation ADR Insight

CID# DRIP

Group E-Mail Address ESPP

Type GBD

Contract Expiration Date Restricted Program

Budget Amount Country of Management

Alternate Vendor RM NY

Last Visit Date

Inform ID

ADR Relationship Manager

BNY Relationship Manager

EnterpriseLast Updated Date



ContactReportHeader OfferingReportHeader

Item Item

Sal. Offering CUSIP DR Name

Last Name Offering Secondary CUSIP DR Name

First Name and Middle Initial Offering #

Job Title Price Date

Contact Status Close Date

Company Offering CUSIP Type

Status Offering Secondary CUSIP Type

Company Type Offering CUSIP Exchange

Functional Title Offering Secondary CUSIP Exchange

Mailing Address Line 1 Structure

Mailing Address Line 2 Depositary

Mailing Address Line 3 S/U

Mail Stop Investment Bank

City Law Firm Investment Bank

State Underwriter Spread %

Zip Code DR US IssuedCountry DR US Capital Raised

E-mail Address DR US Gr Shoe Issued

Work # DR US Gr Shoe Capital Raised

Ext. DR US Total Issued

Fax DR US Total Capital Raised

ADR Insight ID DR Non US Issued

ADR INFORM ID DR Non US Capital Raised

Assistant Name DR Non US Gr Shoe Issued

Assistant Phone # DR Non US Gr Shoe Capital Raised

Eff.BNYSp. Contact DR Non US Total Issued

Created Date DR Non US Total Capital Raised

Last Updated Date DR Total IssuedDR Total Capital Raised

DR Total Gr Shoe Issued

DR Total Gr Shoe Capital Raised

DR Total - Total Issued

DR Total - Total Capital Raised

Privatization

DR Price (USD)

Offering CUSIP



Offering Secondary CUSIP


Region

Subregion

Industry

Status

DR Effective DateDR Termination Date

Green Shoe Close Date

Law Firm BNY

Law Firm Issuer



DepartmentReportHeader MFReportsEnterprise EnterpriseAddressList

Department Name Item Address Line1

Department Code Enterpise Address Line2

DR Department Flag CID # Address Line3

Country of Incorporation City

Last Updated Date State/Province

Zip/Postal Code

Country

Headquarters



PreferredCustodianCleanUpReport UnderlyingSecurity

Item Item

Issuer Name Name

Issuer Country Underlying ISIN

Custodian Company Name Underlying SEDOL

Custodian Country Status

Relationship Manager NY Capital Structure

Phone Share Class

DR Name Par Value

CUSIP Currency

Mnemonic Type

Custodian Position Underlying Exchange

DR Status Unlisted

Board Lot

Share Form

CINS

Yield %

Maturity DateCountry of Exchange

PSET



UnderlyingSecurityProfileRelated CUSIPProfileTradingVolumeDailyReport

Name Item

Type CUSIP

Underlying ISIN Name

Underlying SEDOL Date

Share Class Close Price

Primary Ratio High Price

Secondary Ratio Low Price

Trading Volume



CUSIPProfileTradingVolumeMonthlyReport CUSIPProfileTradingVolumeYearlyReport

Item Item

CUSIP CUSIP

Name Name

Month End Date Year End Date

Low Price Low Price

High Price High Price

Close Price Close Price

Average Price Average Price

Trading Volume Trading Volume

Trading Value Trading Value

# Registered Holders # Registered Holders

CEDE Position CEDE Position



CUSIPTradingVolumeHistoryDetail CUSIPTradingVolumeHistorySummary

Item Item

Name Name

Event Date Event Date

Event Type From CUSIP

From CUSIP To CUSIP

To CUSIP Trading Volume

Month End Date Trading Value

Trading Volume Event Type

Trading Value



TradingVolumebyDepositarybyCountryofManagement TradingVolumebyMonth

Item Item

Depositary Month

Country of Management Trading Volume

Trading Volume Trading Value

Trading Value



TradingVolumeforAllDRPrograms TradingVolumeforExchangeListedLevelDRPrograms

Item Item

CUSIP CUSIP

Name Name

Month End Date Month End Date

Close Price Close Price

Trading Volume Trading Volume

Trading Value Trading Value

DR Ticker Symbol DR Ticker Symbol


DR Exchange DR Exchange

Industry Industry

Type Type

Depositary Depositary

Status Status


Active Flag Active Flag

S/U S/U



TradingVolumeforOTCLevelDRPrograms

Item

CUSIP

Name

Month End Date

Close Price

Trading Volume

Trading Value

DR Ticker Symbol


DR Exchange

Industry

Type

Depositary

Status

Effective Date

Active Flag

S/U



TradingVolumeforPrivate144ARegSDRPrograms TradingVolumeNewvsOld

Item Item

CUSIP Month

Name Trading Volume

Month End Date Trading Value

Close Price

Trading Volume

Trading Value

DR Ticker Symbol


DR Exchange

Industry

Type

Depositary

Status

Effective Date

Active Flag

S/U



TradingVolumeSearch TradingVolumeSearchHOLDRS

Item Item

Name Name

CUSIP CUSIP

DR Ticker Symbol Ticker Symbol

Country of Management Status

Industry Effective Date

S/U Price

Status Trading Volume

Effective Date Trading Value

Origin Exchange

Depositary Region

Price (USD) Link Flag

Trading Volume

Trading Value

DR Exchange

Successor

Security DescriptionType

Region

Link Flag



TradingVolumeforNonUSExchanges HOLDRProfileConstituentTab

Item Name

DR Name CUSIP

Exchange Share Amount

(DR) Type Price(USD)

Month End Date Security Type

Close Price DVP Flag

Trading Volume

Trading Value

Ticker Symbol

SEDOL


Industry

(DR) Status

S/U



HOLDRProfileConstituentCashDeliveryTab ConstituentProfileCATab

Name CA Date

CUSIP CA Type

Start Date Comments

End Date

Rate/Share

Active Flag



ReportsHOLDRSearch ReportsConstituentSearch

Item Item

HOLDR Name Constituent Name

HOLDR CUSIP Constituent CUSIP

Status Constituent Ticker

Ticker Constituent Exchange

Secondary Ticker Constituent ISIN

Effective Date Constituent Price

Termination Date Constituent GICS Code

Termination Reason Constituent Last Sync Date

Agreement Termination Date Constituent Security Type

Exchange Corporate Action value

Secondary Exchange Connected to a HOLDR

Clearing House

Secondary Clearing House

Price

Minimum Share Lot

CID#ISIN

TAS Acct No

ACTION Company#

ACTION Issue#

SEC S1 File Number

SEC S1 File Date

Local Tax

Corporate Action

Cash Delivery



ReportsHOLDRwithConstituentSearch ReportsMasterSpreadsheet

Item NAME OF COMPANY

HOLDR Name CUSIP

HOLDR CUSIP TICKER

HOLDR Status

HOLDR Ticker

HOLDR Secondary Ticker

HOLDR Effective Date

HOLDR Termination Date

HOLDR Termination Reason

HOLDR Agreement Termination Date

HOLDR Exchange

HOLDR Secondary Exchange

HOLDR Clearing House

HOLDR Secondary Clearing House

HOLDR Price

HOLDR Minimum Share Lot

HOLDR CID#HOLDR ISIN

HOLDR TAS Acct No

HOLDR ACTION Company#

HOLDR ACTION Issue#

HOLDR SEC S1 File Number

HOLDR SEC S1 File Date

HOLDR Local Tax

Constituent Name

Constituent CUSIP

Constituent Ticker

Constituent ISIN

Constituent ExchangeConstituent Security Type

Constituent Price

Constituent Inclusion Date

Constituent Removal Date

Constituent Share Count

Constituent GICS

SHARE

AMOUNTSPer 100

PRIMARYTRADINGMARKET

C-I-LRate forFraction



ReportsReconciliationSpreadsheet ReportsIssuanceCancellationInstruction

NAME OF COMPANY

CUSIP

RATIO

REQUIRED

HELD

DIFFERENCE

Market Price

Market Value of Difference



ReportsAuditLog ReportsCashDeliveryReport

Item Item

Event Date Effected Constituent Name

Affected Constituent CUSIP

Affected CUSIP Ticker Symbol

Affected Ticker Comments on the effected Constituent

Affected Constituent Comments CA Date(Declared Constituent)

System Comments CA Type(Declared Constituent)

CA Date Comments (Declared Constituent)

CA Type Constituent Name(Declared Constituent)

Declared Constituent Comments CUSIP(Declared Constituent)

Declared Constituent Name Start Date

Declared CUSIP End Date

Declared Ticker Rate



ReportsMonthlyHOLDRIssueCancelActivityResults

Item

HOLDR Name

HOLDR CUSIP

Month

Issued

Cancelled

Net Issued/Cancelled

Total Issued/Cancelled

Outstanding

Outstanding % Change

Month End Close Price

Market Cap

Registered Holders

PreRelease Balance



ReportsDailyHOLDRIssueCancelActivityResults ReportsHOLDRCrossBorderActivity

Item HOLDR Name

HOLDR Name HOLDR CUSIP

HOLDR CUSIP Broker

Date Issued

Issued # Of Trans

Cancelled Cancelled

Net Issued/Cancelled # Of Trans

Total Issued/Cancelled Net Issued/Canceled

Outstanding Total Cross-Border Trading

Close Price



ReportsDailyBrokerActiviyResults CorporateActionHeader EnterpriseProfileAddressTab

Item CA Date Address Line1

HOLDR Name CA Type Address Line2

HOLDR CUSIP Comments Address Line3

Date City

DRs Issued State/Province

# of Trans Issued Zip/Postal Code

DRs Cancelled Country

# of Trans Cancelled Headquarters

Net Issued/Cancelled

Total Broker Activity

Total Cross-Border Trading Activity

Broker Activity as a % of Total



EnterpriseProfileRelationshipTab DRProfileCUSIPSummaryAddTab

Enterprise Type

Relationship Type CUSIP

Start DR Exchange

End DR Ticker Symbol

Ratio DRs


Current CUSIP



DSFForecastReportMaximumFee IssuerDRServicesTab

Item DR Service

CUSIP

CUSIP Name

CUSIP Type

CUSIP Price

DR Effective Date

S/U

DSF in Deposit Agreement

Charge DSF

Net DSF from Cash Dividend

Depositary Service Fee

Reportable DRs Outstanding

Projected Maximum DSF

DSF Notice Date

DSF U.S. Record Date

DSF Rate

Prior Year Div Fee CollectedCommon Depository


Region

Relationship Manager-New York



IssuerProfileBNYContactsTab IssuerProfileUnderlyingSecurityMarketsTab

Role Country

Contact Market Status

Non-US Location Home Market

Effective Date



IssuerProfileCustodiansTab IssuerProfileAdvisersTab IssuerProductsTab

Custodian Type Product

Country Name Subscription ID

Mnemonic Start

master file reports

Documents