Data Grid: Search

You can use the data grid to display scrollable, paginated search results on the screen with actionable items. To display the data grid, select the Activity Inquiry option from the Activity drop-down menu on the Settlement Web's Navigation Bar.

To search for your settlement activity:

1. Select the Activity Inquiry option from the Activity drop-down menu within the Settlement Web’s navigation bar.

   
   

   

   
   

   The Settlement Activity screen appears.

   
   

   

   
   

2. Enter the business date in the Business Date field for the activity you want to retrieve.

   You can further refine your search using the CUSIP, Contra, Activity, Amount (> or =), Status, Del/Rec/All, Activity Type, Sub Activity, Free/Valued, Third Party, Reason Code, Transaction ID, MA/NA, and Reclaims fields. The more you refine your search criteria, the more specific your search.

   
   

   

   
   

3. Select Data Grid for the display type for your search criteria.

4. Enter additional search criteria to refine your search and click Search.

   Your query results are displayed in the data grid.

   
   

   

   
   

   Note: There are limits to the amount of data that can be requested in one data grid or Excel search request. For data grid searches, the total lines of data equals 2,000. To see more records, click the More Recs button in the data grid. For Excel searches, the total lines of data searchable is 5,000. To see more records, click the Search More button next to the Save Query/Report button. The More Recs and Search More buttons only display when there are additional records available.