The Docs Agreement Report may be run from the "Docs Search" page in Docs, to create a CSV formatted output of Agreement details. This page is accessed by selecting "Documents" and then select "Search" from the dropdown.
Agreement Overview and Report
A user may run a Docs Agreement Report containing all agreements for which they are permissioned, by leaving all filters on the left side of the page blank, and selecting the "Search" button at the bottom of the section.
The full agreement list displays in the main section of the screen and individual agreements may be accessed by selecting the hyperlinked “ID” field. The Agreement Report Search Results may be downloaded by selecting the “Download" button in the upper right corner of the page and will download into a CSV file format. The date and time of the download is captured in the file name.
To note, the "items per page" dropdown defaults to a value of 30, however may be manually updated to change the results displayed per page.
To search for specific agreements within Docs, users may utilize a number of filters, including:
- Agreement Details - ID, State, Type
- Party Details - Party Name by Role
- Dates - Effective, Execution, Initiated, Last Modified, Termination
- Accounts - Exec. Account ID, Exec. Account Description, Clearing Account ID, Clearing Account Description
- Rate Schedule - Name, Type, Exchange
Workstream Status Overview and Report
To see an overview of the workstream status for each of the main parties on an agreement, select one or more filters in the section on the left side of the page (i.e. Agreement State, Agreement Type, etc.), and then select the checkbox next to "Workstream Status" in the upper right and then "Search". Details will show in the main section of the Docs Search page.
The overview headers will show the overall state of the agreement, agreement ID, agreement type, the state of the workstreams overall, and then each of the main parties on the agreement, followed by the status of each of the workstreams for that party (LL - Legal Language, RS - Rate Schedules, and CA - Clearing Accounts).
A blue circle indicates that a party has not approved that particular workstream, a green checkmark indicates that they have approved that workstream, a red X indicates that the party rejected the workstream and a grayed out circle indicates a non-conformed party that does not have the ability to approve workstreams. Additional details such as Effective, Executed and Last Modified dates can be seen when scrolling to the right.
To generate a full "Workstream Status Report" (which is different than a "Docs Agreement Report") select "Reports" and then "Workstream Report" in the Dropdown. The file will be placed in the Report Folder icon in the top toolbar and may be downloaded by selecting the Reports Folder, and then the download icon in the row of the desired report with the date and time of the file name.
Filter Search Results Within Excel
A filter may then be applied to the results via the "A-Z Sort & Filter" button.
The file may then be filtered as desired to identify specific agreements by various characteristics, including: State, Type, Party Name, Number of Accounts, or Dates.