Previewing and Accepting Holdings Load Data

1. Expand the ArcFiling “Dataload” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcFiling” from the components list.

      

   3. Click the “Administration” tab at lower-left of the screen.

      

   4. Click the “Dataload” menu to view available items.

2. Expand the ArcReporting “Dataload” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcReporting” from the components list.

      

   3. Click the “Administration” tab at lower-left of the screen.

      

   4. Click the “Dataload” menu to view available items.

3. Click the “Holdings Load Profiles” item.

   The “Holdings Load Profiles” page displays.

   

4. Select the desired profile from the “Listing” pane at left of the page, or create a new profile for the complex.

5. Click the “Security Captions” tab at right of the page to specify which security library properties (if any) to overwrite with values contained in the source file(s).

   By default, all security caption check boxes on the tab are selected.

   1. Select the “Overwrite values with blanks” check box at the top of the tab to stipulate that a blank value in the data source file will overwrite existing values in the database for any fields whose corresponding “overwrite” check box is selected; if the check box is cleared, blank values that may exist in the data source file will not overwrite existing values in the database.

      The “Issuer Caption/Assignment, Issuer CIK and LEI” option is excluded from the behavior associated with the “Overwrite values with blanks” check box option.

   2. Select the “Use file security captions for new securities” check box at the top of the tab to stipulate that if a security is new to the specific security library, the value of the “Security Caption” field in the data source file will be used to populate the database field; the value from the Security/Investment Master library will not be used.

      If the “Security Caption” field is blank or the column is missing in the data source file, the database field will be populated with the value “[No Caption Loaded]”.

   • When the check box for any given property is selected, data from the source file for that property will be loaded, even if the source file contains a zero or blank value.
   • When any given property’s check box is cleared, data in the source file will be ignored, and values from the most recent account period end will be rolled forward.
   • For new securities, the overwrite option will be ignored and data from the source file will always be loaded.

   • For both automated FTP and manual push-button imports, any fields that are absent from the data source file will effectively have their corresponding check box cleared, regardless of the check box’s status on the application user interface.

   You can use the “Select all” or “Clear all” links to quickly select/clear the check boxes.

6. Click the “Security Categorization” tab to indicate whether the categorization settings for existing securities will be overwritten with values contained in the source file(s).

   

   1. When “True” is the specified “Load as Exception” option for any given category, every security loaded to the category is loaded as an exception (however, the category library assignment associated with the Master Identifier for any given security remains unchanged).

   2. Load options are as follows:

      • “Never Overwrite”
      • “Always Overwrite” (default selection)
      • “Overwrite if Previously Uncategorized”
      • When the “Never Overwrite” option is specified for any given category, data in the source file will be ignored. Values from the most recent account period end will be rolled forward.
      • When the “Always Overwrite” option is specified for a category, data in the source file will be loaded, unless the source file contains a zero or blank value. If the source file contains a zero or blank value, values from the most recent account period end will be rolled forward.
      • When the “Overwrite if Previously Uncategorized” option is specified for a category, data in the source file will be loaded only if the security is new to the category library. If the security exists in the category library, values from the most recent account period end will be rolled forward.

      You can use any one of the links on the page to set all load option drop-down lists at once to the corresponding selection.

7. Click the “Security Balance” tab at right of the page to specify which security balance values (if any) to overwrite with values contained in the source file(s).

   By default, all security balance check boxes on the tab are selected.

   

   1. Select the “Add to existing numeric values” check box at the top of the tab to stipulate that the respective database values of numeric fields marked with an asterisk will be increased/decreased by the amount contained in the data source file for that field, if the corresponding “overwrite” check box is selected.

   • Any fields that are absent from the data source file will effectively have their corresponding check box cleared, regardless of the check box’s status on the “Security Balance” tab.
   • When the check box for any given property is selected, data from the source file for that property will be loaded, even if the source file contains a zero or blank value.
   • For new securities, the overwrite option will be ignored and data from the source file will be loaded.
   • When any given property’s check box is cleared, data in the source file will be ignored, unless values for the field do not currently exist in the database. Data for previous account periods will not be rolled forward.

   You can use the “Select all” or “Clear all” links to quickly select/clear the check boxes.

8. Click the “Security Attributes” tab to indicate whether all previous assignments relating to Demand Feature Issuers, Enhancement Providers and Guarantors will be rolled forward, overwritten with values contained in the source file(s) or appended with those values.

   

   1. Load options are as follows:

      • “Never Overwrite”
      • “Always Overwrite” (default selection)
      • “Append to Existing Values if Different”
      • When the “Never Overwrite” option is specified for any given attribute, data in the source file will be ignored. Values from the most recent account period end will be rolled forward.
      • When the “Always Overwrite” option is specified for an attribute, data in the source file will be loaded. Values from the most recent account period end will be ignored.
      • When the “Append to Existing Values if Different” option is specified for an attribute, data in the source file will be loaded only if different from the values from the most recent account period end. Existing values from the most recent account period end will remain intact.
      • The load option specified for the “Demand Feature Issuers” drop-down list will affect the “DemandFeatureIssuerNRSROList”, “DemandFeatureIssuerNRSRORatingList” and “DemandFeatureList” field values.
      • The load option specified for the “Enhancement Providers” drop-down list will affect the “EnhancementProviderList”, “EnhancementProviderNRSROList”, “EnhancementProviderNRSRORatingList” and “EnhancementTypeList” field values.
      • The load option specified for the “Guarantors” drop-down list will affect the “GuarantorList”, “GuarantorNRSROList” and “GuarantorNRSRORatingList” field values.

      You can use any one of the links on the page to set all load option drop-down lists at once to the corresponding selection.

9. Click the “Footnotes” tab to specify attachment behavior for any footnotes in the load file.

   

   1. Footnote attachment options are as follows:

      • “Attach footnotes based on the contents of the load file” (default selection)

        • If this option is selected, any given footnote contained in the data source file will be appended to the existing footnote(s) attached to its corresponding holdings record.

      • “Replace footnotes for only specific holdings referenced in the load file”

        • If this option is selected, all existing footnotes attached to holdings records for funds referenced in the data source file will be removed, and then any given footnote contained in the data source file will be attached to its corresponding holdings record.

      • “Do not attach any footnotes contained in the load file”

        • If this option is selected, no footnotes contained in the data source file will be attached to their corresponding holdings record (i.e., the “FootnoteCode” and “FootnoteApplyTo” fields in the file are essentially ignored).

10. Click the “Save” button at lower-right of the page.

Holdings information can be loaded utilizing the secure FTP site process. See the “Transferring Load Files via Secure FTP” topic for details on using this method.

As an alternative to manually entering holdings information one record at a time via the associated application page or using the secure FTP load process, you can import multiple holdings records at once, along with their associated information, using an Excel (XLS) source file. Follow these steps to do so:

1. Expand the ArcFiling “N-MFP” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcFiling” from the components list.

      

   3. Click the “Filings Workspace” tab at lower-left of the screen.

      

   4. Click the “N-MFP” menu to view available items.

      If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

      • Using the selection bar

        1. Click the “[Select Date]” text or “»” symbol.

           All open account periods associated with a project, and to which you have access, are displayed.

           

        2. Click the “[Select Complex]” text or “»” symbol.

           Complexes with projects associated with the specified date are displayed.

           

           If only one complex is available based on the specified date, the complex is automatically chosen.

        3. Click the “[Select Group]” text or “»” symbol.

           Groups associated with the specified complex with active projects for the specified date are displayed.

           

           Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

           

           If only one fund group is available based on the specified complex, the group is automatically chosen.

        4. Click the “[Select Fund]” text or “»” symbol.

           Funds associated with the specified group with active projects for the specified date are displayed.

           

           Alternatively, you can specify “All Funds”.

           

           If only one fund is available based on the specified group, the fund is automatically chosen.

        When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

        

        • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
        • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
        • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
        • Change the fund. Changing the fund refreshes the data for all open pages.
        • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

      • Using the selection button

        1. Click the selection button at upper-left of the window.

           All open account periods associated with a project, and to which you have access, are displayed.

           

           If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

           

        2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
        3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

2. Expand the ArcReporting “Portfolio” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcReporting” from the components list.

      

   3. Click the “Reporting Workspace” tab at lower-left of the screen.

      

   4. Click the “Portfolio” menu to view available items.

      If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

      • Using the selection bar

        1. Click the “[Select Date]” text or “»” symbol.

           All open account periods associated with a project, and to which you have access, are displayed.

           

        2. Click the “[Select Complex]” text or “»” symbol.

           Complexes with projects associated with the specified date are displayed.

           

           If only one complex is available based on the specified date, the complex is automatically chosen.

        3. Click the “[Select Group]” text or “»” symbol.

           Groups associated with the specified complex with active projects for the specified date are displayed.

           

           Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

           

           If only one fund group is available based on the specified complex, the group is automatically chosen.

        4. Click the “[Select Fund]” text or “»” symbol.

           Funds associated with the specified group with active projects for the specified date are displayed.

           

           Alternatively, you can specify “All Funds”.

           

           If only one fund is available based on the specified group, the fund is automatically chosen.

        When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

        

        • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
        • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
        • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
        • Change the fund. Changing the fund refreshes the data for all open pages.
        • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

      • Using the selection button

        1. Click the selection button at upper-left of the window.

           All open account periods associated with a project, and to which you have access, are displayed.

           

           If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

           

        2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
        3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

3. Click the “Fund Holdings” item.

   The “Fund Holdings” page displays, which provides the relevant financial data for each security held by the selected fund.

   

   To modify a value, simply type in the corresponding field or click the relevant field link.

   You must save information before navigating between tabs.

   • You can filter the holdings that display in the grid by balance type, language and account period using the corresponding controls in the section at the top of the page.

   • The column headers in the grid are color coded, based on the type of data contained in each.

     • Blue - Fields with this coloration (e.g., “Caption”, “Description 1”, “Maturity Date”, etc.) are associated with the security library, and their values are common across the library. Changes can be made to these fields from the “Fund Holdings” or “Security Libraries” pages. Changes to these fields will impact all funds assigned to the same security library.

     • Red - The only field with this coloration is “Item C.1 - Name of the Issuer”“Issuer Caption”. It is common across all funds using the same issuer caption library. The field value can only be changed on the “Issuer Library” page. The “Fund Holdings” page allows you to update the “Issuer” assignment only.

       The “Issuer” assignment syncing is based on the “Security Library” assignment, not the “Issuer Library”.

     • Orange - Fields with this coloration (e.g., “Category of Investment”, “Country”, “Sector”, etc.) are associated with the category library, and their values are common across the library. Changes to “Category” assignment can be made on the “Fund Holdings” page. Changes to the “Category” assignment will impact all funds assigned to that particular category library. Changes to the category captions can be made on the “Category Libraries” page only. Changes made to captions will impact all funds assigned to that library.
     • (shaded) - Fields whose header is shaded with a gray gradient are associated with either the Security/Investment Master library (e.g., “Master Identifier”, etc.) or the Issuer Master library (“Issuer CIK”), and are common across the database. Changes to their values can only be made on the “Security/Investment Master” or “Issuer Master” pages, respectively, or updated during data load. Changes to these fields impact all funds across the database. Columns containing system calculations (e.g., “% of Net Assets”, “% of par”, etc.) are also read-only on the “Fund Holdings” page.
     • (no coloration) - Fields whose header has no shading nor coloration at all (e.g., “Shares”, “Market Value”, “Cost”, etc.) contain security balance data, and are unique to the specified fund, account period and balance instance. Changes made to these fields never impact nor synchronize with any other instance of the security.
   • Click the “Refresh data” button at lower-right of the tab to display the latest holdings data contained in the database.
4. Click the “View” drop-down list at the top of the page to specify the system or custom view with which you will display existing and imported data in the grid of the “Holdings” tab.
5. Click the “Search” button at right of the “Search Criteria” section to load existing data in the grid.

6. Click the “Get import template” button at lower-right of the pane where existing items are listed to retrieve an Excel import file template.

   The “File Download” dialogue displays.

   

   1. Click the “Open” button to open the template within Microsoft Excel.
   2. Or, click the “Save” button, and then specify a local or network directory in which to store the template.
7. Use Excel’s “Save As...” command to create your data import file, giving it a unique and meaningful name (e.g., “HoldingsImport_20101231.xlsx”).
8. Populate your new file with information for as many exchange rate records as you’d like to import, and then save it (see the “Holdings Import File Structure” table for specifics).

9. Click the “Import data” button at lower-right of the pane where existing items are listed to import data contained in your Excel source file.

   The “Holdings Import” dialogue displays.

   

   1. Select your import file using the “Browse” button at right of the “File” field.
   2. Specify a predefined import profile, if desired, using the “Holdings Load Profile” drop-down list beneath the “File” field.

   3. Click the “Security Captions” tab to specify which security library properties (if any) to overwrite with values contained in the source file.

      

      By default, all check boxes on the tab are cleared.

      1. Select the “Overwrite values with blanks” check box at the top of the tab to stipulate that a blank value in the data source file will overwrite existing values in the database for any fields whose corresponding “overwrite” check box is selected; if the check box is cleared, blank values that may exist in the data source file will not overwrite existing values in the database.

         The “Issuer Caption/Assignment, Issuer CIK and LEI” option is excluded from the behavior associated with the “Overwrite values with blanks” check box option.

      2. Select the “Use file security captions for new securities” check box at the top of the tab to stipulate that if a security is new to the specific security library, the value of the “Security Caption” field in the data source file will be used to populate the database field; the value from the Security/Investment Master library will not be used.

         If the “Security Caption” field is blank or the column is missing in the data source file, the database field will be populated with the value “[No Caption Loaded]”.

      • When the check box for any given property is selected, data from the source file for that property will be loaded, even if the source file contains a zero or blank value.
      • When any given property’s check box is cleared, data in the source file will be ignored, and values from the most recent account period end will be rolled forward.
      • For new securities, the overwrite option will be ignored and data from the source file will always be loaded.

      • For both automated FTP and manual push-button imports, any fields that are absent from the data source file will effectively have their corresponding check box cleared, regardless of the check box’s status on the application user interface.

      You can use the “Select all” or “Clear all” links to quickly select/clear the check boxes.

   4. Click the “Security Categorization” tab to indicate whether securities loaded to a given category will be loaded as an exception, and whether the categorization settings for existing securities will be overwritten with values contained in the source file.

      

      1. When “True” is the specified “Load as Exception” option for any given category, every security loaded to the category is loaded as an exception (however, the category library assignment associated with the Master Identifier for any given security remains unchanged).

      2. Load options are as follows:

         • “Never Overwrite” (default selection)
         • “Always Overwrite”
         • “Overwrite if Previously Uncategorized”
         • When the “Never Overwrite” option is specified for any given category, data in the source file will be ignored. Values from the most recent account period end will be rolled forward.
         • When the “Always Overwrite” option is specified for a category, data in the source file will be loaded, unless the source file contains a zero or blank value. If the source file contains a zero or blank value, values from the most recent account period end will be rolled forward.
         • When the “Overwrite if Previously Uncategorized” option is specified for a category, data in the source file will be loaded only if the security is new to the category library. If the security exists in the category library, values from the most recent account period end will be rolled forward.

         You can use any one of the links on the page to set all load option drop-down lists at once to the corresponding selection.

   5. Click the “Security Balance” tab to specify which security balance values (if any) to overwrite with values contained in the source file.

      

      By default, all check boxes on the tab are cleared.

      1. Select the “Add to existing numeric values” check box at the top of the tab to stipulate that the respective database values of numeric fields marked with an asterisk will be increased/decreased by the amount contained in the data source file for that field, if the corresponding “overwrite” check box is selected.

      • Any fields that are absent from the data source file will effectively have their corresponding check box cleared, regardless of the check box’s status on the “Security Balance” tab.
      • When the check box for any given property is selected, data from the source file for that property will be loaded, even if the source file contains a zero or blank value.
      • For new securities, the overwrite option will be ignored and data from the source file will be loaded.
      • When any given property’s check box is cleared, data in the source file will be ignored, unless values for the field do not currently exist in the database. Data for previous account periods will not be rolled forward.

      You can use the “Select all” or “Clear all” links to quickly select/clear the check boxes.

   6. Click the “Security Attributes” tab to indicate whether all previous assignments relating to Demand Feature Issuers, Enhancement Providers and Guarantors will be rolled forward, overwritten with values contained in the source file(s) or appended with those values.

      

      1. Load options are as follows:

         • “Never Overwrite” (default selection)
         • “Always Overwrite”
         • “Append to Existing Values if Different”
         • When the “Never Overwrite” option is specified for any given attribute, data in the source file will be ignored. Values from the most recent account period end will be rolled forward.
         • When the “Always Overwrite” option is specified for an attribute, data in the source file will be loaded. Values from the most recent account period end will be ignored.
         • When the “Append to Existing Values if Different” option is specified for an attribute, data in the source file will be loaded only if different from the values from the most recent account period end. Existing values from the most recent account period end will remain intact.
         • The load option specified for the “Demand Feature Issuers” drop-down list will affect the “DemandFeatureIssuerNRSROList”, “DemandFeatureIssuerNRSRORatingList” and “DemandFeatureList” field values.
         • The load option specified for the “Enhancement Providers” drop-down list will affect the “EnhancementProviderList”, “EnhancementProviderNRSROList”, “EnhancementProviderNRSRORatingList” and “EnhancementTypeList” field values.
         • The load option specified for the “Guarantors” drop-down list will affect the “GuarantorList”, “GuarantorNRSROList” and “GuarantorNRSRORatingList” field values.

         You can use any one of the links on the page to set all load option drop-down lists at once to the corresponding selection.

   7. Click the “Process” tab to specify whether or not you wish to preview data in the source file before importing.

      1. Preview data before it imports:

         1. Click the “Process” button at left of the tab.

            The record(s) to be imported display in the grid.

            

            1. Review information for each record included in the import file via the grid of the “Process” tab.

            2. Click the “Errors” tab to read any information provided for specific rows in the data import source file.

               

               If warnings and/or errors were encountered, you can take the steps necessary to resolve them (either by editing the source file accordingly, or making appropriate adjustments to database library settings, etc.), and then attempt to reload the data.

            3. Click the “Accept” button or “Reject” button at lower-right of the “Process” tab when you’re ready to import the data.

               You must choose to either accept or reject the import before you can close the dialogue; the “Cancel” button at far lower-right will be disabled until you do.

               If you accept the import, the records are imported to the database.

      2. Import data without preview:

         1. Click the “Process” button at left of the tab.

            The import settings dialogue closes, records are placed in the import processing queue and the load will be automatically accepted by Arc Suite if it yields no prohibitive errors (otherwise, it will be rejected).

      • Only one file can be imported and processed at a time.

      • The system automatically rejects any import that contains one or more records associated with a “Closed” account period.

You can sort, group and filter information in a grid through various means in order to find what you’re looking for more easily.

Grid Management

1. Filtering: You can filter the items presented in a grid by using the “Filter” buttons at the top of any column.

   1. To remove any particular column filter, click the “Filter” button at the top of that column, and then click the “Clear Filter” button on the filter criteria dialogue that displays.

   2. To remove all column filters for the grid at once, click the “Clear all filters” button at upper-left of the grid.

      The “Clear all filters” button is not available on all Arc Suite grids.

      • The “Clear all filters” button is not available on all Arc Suite grids.
      • Column filtering only affects the rows that have been loaded in the grid. If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), be sure all available rows have been loaded if you expect column filtering to affect all securities in the data set.
2. Sorting: You can sort items in a grid by clicking any column header. Once sorted, the column header will change color and indicate whether the list is sorted in ascending or descending order.

3. Grouping: In some grids, the items can be grouped in the display by selecting a column header, and then dragging it into the “Grouped by” area of a grid.

   1. To expand or collapse a grouping, click the buttons, respectively, at left of the grouping row in the grid.

   2. To remove a grouping, hover your cursor over the grouping box, and then click the “Remove” button that displays on its right.

      

4. Grid Splitting: Grids feature a vertical splitter bar, which you can grab and move over the line dividing any two columns. As you scroll horizontally to see more columns of data, the columns to the left of the splitter bar are “frozen” in view.

5. Pagination: Some grids feature a “Rows Per Page” spinner control at lower-left, which you can use to specify the maximum number of records/rows to display in the grid at once. If the number of records in the database meeting the specified criteria exceeds the specified “Rows Per Page” value, a set of navigation controls at lower-right of the grid is enabled to allow access to the records in successive grid “pages”.

   If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), the value specified for the associated “FundHoldingsGridPageSize” setting will determine the upper limit of the “Rows Per Page” spinner control, as well as how many rows are loaded at once to the grid.

6. Field Selection: You can also specify which columns of data to show in the current grid. You can choose from one or more “standard” views of the grid, or you can create and save your own custom views.

   1. Choosing a View. Using the “View” selection drop-down list associated with the grid, you can switch between custom views and standard views.

   2. Creating a Custom View. You can leverage the standard views or existing custom views as starting points to create new custom views (standard views cannot be edited).

      1. Choose a view that most closely resembles the view you’d like to create.

      2. Select “Save View As...” from the “Action” button menu to name the new custom view.

         The “Save View As...” dialogue displays.

         

         

         1. Specify the desired “View Name”.

         2. For the “Fund Holdings” page, also use the corresponding option button set on the dialogue to specify whether the new view will be visible to only you (“User” selection), or to all application users in the current environment (“Global” selection).

            

            You must be assigned the “Add/Edit/Delete Global Fund Holdings Views” user right to specify the “Global” selection (the option button is disabled if you are not assigned the right).

         3. Click the “Accept” button at lower-right of the dialogue to save the new view.

            The new view is automatically selected in the “View” drop-down list.

            

      3. Edit the new custom view, as needed.

         1. The following properties of a custom view can be modified, and these changes are retained when the view is saved:

            1. View name

               1. Select “Edit View” from the “Action” button menu to change the name of the custom view.

                  The “Edit View” dialogue displays.

                  

                  1. Specify the desired “View Name”.

                  2. Click the “Accept” button at lower-right of the dialogue.

            2. Columns shown in view

               1. Select “Edit View” from the “Action” button menu to add or remove columns from the custom view.

                  The “Edit View” dialogue displays.

                  

                  1. Select or clear the check box in the “Visible” column of the grid for each field you wish to show or hide in the custom view.

                  2. Click the “Accept” button at lower-right of the dialogue.

            3. Numeric-type column subtotal display for groups (“Fund Holdings” page only)

               1. Select “Edit View” from the “Action” button menu to display or hide a subtotal for one or more numeric-type fields in each group of the view.

                  The “Edit View” dialogue displays.

                  

                  1. Select or clear the check box in the “Calc” column of the grid for each field for which you wish to show or hide a subtotal.

                  2. Click the “Accept” button at lower-right of the dialogue.

            4. Column ordering

               1. Arrange the visible columns in any order by dragging-and-dropping them within the grid.
               2. Select “Save View” from the “Action” button menu to save this and all other properties of the current view.

            5. Column widths

               1. As required, adjust the width of one or more visible columns in the grid by dragging the left or right edge of the corresponding column header(s).
               2. Select “Save View” from the “Action” button menu to save this and all other properties of the current view.

            6. Grid grouping

               1. Set up groups of data in the grid by dragging one or more column headers into the grouping section above the grid.
               2. Select “Save View” from the “Action” button menu to save this and all other properties of the current view.

         Column sorting, column filters and the grid splitter position are not currently remembered as part of the custom view functionality.

      Only the standard views are visible to all users. Custom views are only visible to the user who created them.

   3. Viewing All Columns. The standard “All columns” selection allows you to quickly view all available columns for the current grid.

      

   You can change the settings of a standard view while it’s selected, but such changes will not be saved. You can only permanently save changes to custom views.

1. Expand the ArcFiling “Production Utilities” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcFiling” from the components list.

      

   3. Click the “Filings Workspace” tab at lower-left of the screen.

      

   4. Click the “Production Utilities” menu to view available items.

2. Expand the ArcReporting “Production Utilities” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcReporting” from the components list.

      

   3. Click the “Reporting Workspace” tab at lower-left of the screen.

      

   4. Click the “Production Utilities” menu to view available items.

3. Click the “Dataload Status” item.

   The “Dataload Status” widget displays.

   

4. Use the “Funds to view” drop-down list to specify the scope of dataload information displayed.
5. Expand the grid groupings to see the status of any data import for a specific fund.

You can sort, group and filter information in a grid through various means in order to find what you’re looking for more easily.

Grid Management

1. Filtering: You can filter the items presented in a grid by using the “Filter” buttons at the top of any column.

   1. To remove any particular column filter, click the “Filter” button at the top of that column, and then click the “Clear Filter” button on the filter criteria dialogue that displays.

   2. To remove all column filters for the grid at once, click the “Clear all filters” button at upper-left of the grid.

      The “Clear all filters” button is not available on all Arc Suite grids.

      • The “Clear all filters” button is not available on all Arc Suite grids.
      • Column filtering only affects the rows that have been loaded in the grid. If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), be sure all available rows have been loaded if you expect column filtering to affect all securities in the data set.
2. Sorting: You can sort items in a grid by clicking any column header. Once sorted, the column header will change color and indicate whether the list is sorted in ascending or descending order.

3. Grouping: In some grids, the items can be grouped in the display by selecting a column header, and then dragging it into the “Grouped by” area of a grid.

   1. To expand or collapse a grouping, click the buttons, respectively, at left of the grouping row in the grid.

   2. To remove a grouping, hover your cursor over the grouping box, and then click the “Remove” button that displays on its right.

      

4. Grid Splitting: Grids feature a vertical splitter bar, which you can grab and move over the line dividing any two columns. As you scroll horizontally to see more columns of data, the columns to the left of the splitter bar are “frozen” in view.

5. Pagination: Some grids feature a “Rows Per Page” spinner control at lower-left, which you can use to specify the maximum number of records/rows to display in the grid at once. If the number of records in the database meeting the specified criteria exceeds the specified “Rows Per Page” value, a set of navigation controls at lower-right of the grid is enabled to allow access to the records in successive grid “pages”.

   If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), the value specified for the associated “FundHoldingsGridPageSize” setting will determine the upper limit of the “Rows Per Page” spinner control, as well as how many rows are loaded at once to the grid.

Various user interfaces (pages) within Arc Suite allow you to view and edit the values of data points that have been loaded into the database and/or mapped in the output settings for portfolio and financial statements.

The information in the tables below serves as a cross reference between data points that are loaded and/or mapped and the respective user interfaces that allow for viewing/editing of the data point values. The tables also denote which data points are shared by ArcFiling and ArcReporting and demonstrate if the data points are referenced differently between the two products.

• Fund Data Points (click to see table)

  Fund Data Point Name	ArcReporting User Interface	ArcFiling User Interface	Environment Administration User Interface
  7-day gross yield (as of the month end)	Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > 7-day Gross Yield	Filings Workspace > N-MFP > Fund Information > Item A.19 - 7-day gross yield (as of the month end)	(ArcFiling or ArcReporting)
  Abbreviation	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Information tab > Abbreviation
  CIK	(Environment Administration)	Filings Workspace > N-MFP > Part A: Fund/Class Setup > CIK Number of Registrant	Environment Administration > Settings > Funds > Fund > CIK
  Close Date	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Information tab > Close Date
  Currency Code	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Information tab > Currency Code
  Dollar Weighted Average Life	Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Dollar Weighted Average Life	Filings Workspace > N-MFP > Fund Information > Item A.12 - Dollar Weighted Average Life	(ArcFiling or ArcReporting)
  Dollar Weighted Average Maturity	Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Dollar Weighted Average Maturity	Filings Workspace > N-MFP > Fund Information > Item A.11 - Dollar Weighted Average Maturity	(ArcFiling or ArcReporting)
  EDGAR Series Identifier	(Environment Administration)	Filings Workspace > N-MFP > Part A: Fund/Class Setup > EDGAR Series Identifier	Environment Administration > Settings > Funds > Fund > EDGAR Series Identifier
  Fund Code	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Code
  Fund Display Name 1	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Display Name 1
  Fund Display Name 2	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Display Name 2
  Fund Legal Name	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Legal Name
  Fund Name	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Name
  Inception Date	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Information tab > Inception Date
  Legal Entity	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Legal Entity
  Net value of other assets	Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Value of Other Assets	Filings Workspace > N-MFP > Fund Information > Item A.14.c	(ArcFiling or ArcReporting)
  Net value of other liabilities	Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Value of Other Liabilities	Filings Workspace > N-MFP > Fund Information > Item A.15	(ArcFiling or ArcReporting)
  Net value of the series	Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Net Assets	Filings Workspace > N-MFP > Fund Information > Item A.16	(ArcFiling or ArcReporting)
  N-MFP Category	(ArcFiling)	Filings Workspace > N-MFP > Part A: Fund/Class Setup > Item A.10 - Category	(ArcFiling)
  Securities Act File Number	(Environment Administration)	Filings Workspace > N-MFP > Part A: Fund/Class Setup > Item A.1 - Securities Act File Number	Environment Administration > Settings > Funds > Fund > Filings Info > Securities Act File Number
  Total value of portfolio securities at amortized cost	Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Value of Total Investments	Filings Workspace > N-MFP > Fund Information > Item A.14.b.i	(ArcFiling or ArcReporting)

• Class Data Points (click to see table)

  Class Data Point Name	ArcReporting User Interface	ArcFiling User Interface	Environment Administration User Interface
  1 Year Expense Ratio	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > 1 Year Expense Ratio	(ArcReporting)	(ArcReporting)
  6 Month Expense Ratio	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > 6 Month Expense Ratio	(ArcReporting)	(ArcReporting)
  7-day net yield (shown as %)	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > 7-day net yield (Show as %)	Filings Workspace > N-MFP > Class Information > Item B.7 - 7-day net yield (show as %)	(ArcFiling or ArcReporting)
  Average Net Assets - 1 Year	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Average Net Assets - 1 Year	(ArcReporting)	(ArcReporting)
  Average Net Assets - 6 Months	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Average Net Assets - 6 Months	(ArcReporting)	(ArcReporting)
  Base Class	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Base Classes > Base Class Name
  Class Display Name 1	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Class Display Name 1
  Class Display Name 2	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Class Display Name 2
  Class Name	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Class Name
  CUSIP	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > CUSIP
  Description	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Description
  Distributions in Excess of Net Investment Income	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Distributions in Excess of Net Investment Income	(ArcReporting)	(ArcReporting)
  Dividends Reinvested	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Dividends Reinvested	(ArcReporting)	(ArcReporting)
  Dividends Reinvested - Shares	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Dividends Reinvested - Shares	(ArcReporting)	(ArcReporting)
  EDGAR Class Identifier	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > EDGAR Class Identifier
  Expense Cap Percentage	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Expense Cap Percentage
  Gross Redemptions	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Gross Redemptions	Filings Workspace > N-MFP > Class Information > Item B.6.f.ii - Gross Redemptions	(ArcFiling or ArcReporting)
  Gross Subscriptions (Including dividend reinvest)	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Gross Subscriptions (Including dividend reinvest)	Filings Workspace > N-MFP > Class Information > Item B.6.f.i - Gross Subscriptions (Including dividend reinvest)	(ArcFiling or ArcReporting)
  Inception Date	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Inception Date
  Load Code	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Load Code(s)
  Maximum Back End Load	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Maximum Back End Load
  Maximum Front End Load	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Maximum Front End Load
  Minimum Initial Investment	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Minimum Initial Investment
  NAV	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > NAV	Filings Workspace > N-MFP > Class Information > Item B.5 - NAV	(ArcFiling or ArcReporting)
  Net Assets of the Class	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Net Assets of the Class	Filings Workspace > N-MFP > Class Information > Item B.3 - Net Assets of the Class	(ArcFiling or ArcReporting)
  Net Investment Income Distributed Per Share	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Net Investment Income Distributed Per Share	(ArcReporting)	(ArcReporting)
  Net Shareholder activity for the month	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Net Shareholder activity for the month	Filings Workspace > N-MFP > Class Information > Net Shareholder activity for the month	(ArcFiling or ArcReporting)
  Par Value	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Par Value
  POP (Public Offering Price)	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > POP (Public Offering Price)	(ArcReporting)	(ArcReporting)
  Prospectus Ratio	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Prospectus Ratio
  Realized Gains Distributed Per Share	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Realized Gains Distributed Per Share	(ArcReporting)	(ArcReporting)
  Redemption Fee	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Redemption Fee
  Redemptions	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Redemptions	(ArcReporting)	(ArcReporting)
  Redemptions - Exchanges	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Redemptions - Exchanges	(ArcReporting)	(ArcReporting)
  Redemptions - Exchanges - Shares	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Redemptions - Exchanges - Shares	(ArcReporting)	(ArcReporting)
  Redemptions - Shares	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Redemptions - Shares	(ArcReporting)	(ArcReporting)
  Security Class	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Security Class
  SEDOL	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > SEDOL
  Shares Outstanding	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Shares Outstanding	(ArcReporting)	(ArcReporting)
  Subscriptions	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Subscriptions	(ArcReporting)	(ArcReporting)
  Subscriptions - Exchanges	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Subscriptions - Exchanges	(ArcReporting)	(ArcReporting)
  Subscriptions - Exchanges - Shares	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Subscriptions - Exchanges - Shares	(ArcReporting)	(ArcReporting)
  Subscriptions - Shares	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Subscriptions - Shares	(ArcReporting)	(ArcReporting)
  Ticker	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Ticker
  Total Return - 1 Month	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 1 Month	(ArcReporting)	(ArcReporting)
  Total Return - 1 Year	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 1 Year	(ArcReporting)	(ArcReporting)
  Total Return - 2 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 2 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 2 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 2 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - 3 Month	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 3 Month	(ArcReporting)	(ArcReporting)
  Total Return - 3 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 3 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 3 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 3 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - 4 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 4 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 4 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 4 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - 5 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 5 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 5 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 5 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - 6 Month	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 6 Month	(ArcReporting)	(ArcReporting)
  Total Return - 6 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 6 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 6 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 6 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - 7 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 7 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 7 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 7 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - 8 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 8 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 8 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 8 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - 9 Month	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 9 Month	(ArcReporting)	(ArcReporting)
  Total Return - 9 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 9 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 9 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 9 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - 10 Year Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 10 Year Annualized	(ArcReporting)	(ArcReporting)
  Total Return - 10 Year Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 10 Year Cumulative	(ArcReporting)	(ArcReporting)
  Total Return - Since Inception Annualized	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - Since Inception Annualized	(ArcReporting)	(ArcReporting)
  Total Return - Since Inception Cumulative	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - Since Inception Cumulative	(ArcReporting)	(ArcReporting)
  Transfer Agent Code	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Class > Transfer Agent Code
  Turnover %	Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Turnover %	(ArcReporting)	(ArcReporting)

• Holdings Data Points (click to see table)

  Holdings Data Point Name	ArcReporting User Interface	ArcFiling User Interface	Environment Administration User Interface
  144A	Reporting Workspace > Portfolio > Fund Holdings > 144A	(ArcReporting)	(ArcReporting)
  Account Period	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Account Periods > Period End
  Accrued Interest	Reporting Workspace > Portfolio > Fund Holdings > Accrued Interest	(ArcReporting)	(ArcReporting)
  Affiliated	Reporting Workspace > Portfolio > Fund Holdings > Affiliated	(ArcReporting)	(ArcReporting)
  AM Best Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > AMBest Credit Rating	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - AMBest Credit Rating	(ArcFiling or ArcReporting)
  Balance Instance	Reporting Workspace > Portfolio > Fund Holdings > Balance Instance	Filings Workspace > N-MFP > Fund Holdings > Balance Instance	(ArcFiling or ArcReporting)
  Base Currency Bought	Reporting Workspace > Portfolio > Fund Holdings > Currency Bought - Base	(ArcReporting)	(ArcReporting)
  Base Currency Sold	Reporting Workspace > Portfolio > Fund Holdings > Currency Sold - Base	(ArcReporting)	(ArcReporting)
  Base Unit Price	Reporting Workspace > Portfolio > Fund Holdings > Unit Price - Base	(ArcReporting)	(ArcReporting)
  Bought	Reporting Workspace > Portfolio > Fund Holdings > Bought	(ArcReporting)	(ArcReporting)
  Caption	Administration > Reporting Libraries > Security/Investment Master > Security Name Reporting Workspace > Portfolio > Fund Holdings > Caption	Administration > Filing Libraries > Security/Investment Master > Security Name Filings Workspace > N-MFP > Fund Holdings > Item C.2 - Title of Issue	(ArcFiling or ArcReporting)
  Category Caption	Reporting Workspace > Portfolio > Fund Holdings > All Categories Assigned to the Fund	Filings Workspace > N-MFP > Fund Holdings > Item C.6 - Category of Investment	(ArcFiling or ArcReporting)
  Category Notes	N/A	Filings Workspace > N-MFP > Fund Holdings > Item C.6 - Description	N/A
  CIK	Reporting Workspace > Portfolio > Fund Holdings > Issuer CIK	Filings Workspace > N-MFP > Fund Holdings > Item C.1 - Name of the Issuer	(ArcFiling or ArcReporting)
  Class	Reporting Workspace > Portfolio > Fund Holdings > Class	(ArcReporting)	(ArcReporting)
  Collateral	Reporting Workspace > Portfolio > Fund Holdings > Collateral	(ArcReporting)	(ArcReporting)
  Collateral	Reporting Workspace > Portfolio > Fund Holdings > Fully Collateralized Repo	(ArcReporting)	(ArcReporting)
  Commitments	Reporting Workspace > Portfolio > Fund Holdings > Commitments	(ArcReporting)	(ArcReporting)
  Contract Rate	Reporting Workspace > Portfolio > Fund Holdings > Contract Rate	(ArcReporting)	(ArcReporting)
  Cost	Reporting Workspace > Portfolio > Fund Holdings > Cost	(ArcReporting)	(ArcReporting)
  Counterparty	Reporting Workspace > Portfolio > Fund Holdings > Counterparty	(ArcReporting)	(ArcReporting)
  Coupon Rate	Reporting Workspace > Portfolio > Fund Holdings > Coupon	Filings Workspace > N-MFP > Fund Holdings > Item C.2 - Coupon	(ArcFiling or ArcReporting)
  Coupon Rate Type	Reporting Workspace > Portfolio > Fund Holdings > Coupon Rate Type	(ArcReporting)	(ArcReporting)
  Currency Code	Reporting Workspace > Portfolio > Fund Holdings > Currency Code	(ArcReporting)	(ArcReporting)
  Currency Code Purchased	Reporting Workspace > Portfolio > Fund Holdings > Currency Code Purchased	(ArcReporting)	(ArcReporting)
  Currency Code Sold	Reporting Workspace > Portfolio > Fund Holdings > Currency Code Sold	(ArcReporting)	(ArcReporting)
  CUSIP	Administration > Reporting Libraries > Security Libraries > Security Captions tab > CUSIP Reporting Workspace > Portfolio > Fund Holdings > CUSIP	Administration > Filing Libraries > Security Libraries > Security Captions tab > CUSIP Filings Workspace > N-MFP > Fund Holdings > Item C.3 - CUSIP	(ArcFiling or ArcReporting)
  Custom Identifier	Administration > Reporting Libraries > Security Libraries > Security Captions tab > Custom Identifier Administration > Security Libraries > Security Captions tab > Custom Identifier	Reporting Workspace > Portfolio > Fund Holdings > Custom Identifier Filings Workspace > N-MFP > Fund Holdings > Item C.5.c - Other Unique Identifier	(ArcFiling or ArcReporting)
  Day To Maturity	Reporting Workspace > Portfolio > Fund Holdings > Days To Maturity	(ArcReporting)	(ArcReporting)
  DBRS Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > DBRS Credit Rating	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - DBRS Credit Rating	(ArcFiling or ArcReporting)
  DemandFeatureIssuerNRSROList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.14.e - Designated NRSRO for Demand Feature(s) or provider(s)	(ArcFiling )
  DemandFeatureIssuerNRSRORatingList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.14.e - Rating for each Designated NRSRO	(ArcFiling)
  DemandFeatureList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.14.a - Demand Feature Issuer(s)	(ArcFiling)
  Description 01	Reporting Workspace > Portfolio > Fund Holdings > Description 1	(ArcReporting)	(ArcReporting)
  Description 02	Reporting Workspace > Portfolio > Fund Holdings > Description 2	(ArcReporting)	(ArcReporting)
  Description 03	Reporting Workspace > Portfolio > Fund Holdings > Description 3	(ArcReporting)	(ArcReporting)
  Description 04	Reporting Workspace > Portfolio > Fund Holdings > Description 4	(ArcReporting)	(ArcReporting)
  Description 05	Reporting Workspace > Portfolio > Fund Holdings > Description 5	(ArcReporting)	(ArcReporting)
  Description 06	Reporting Workspace > Portfolio > Fund Holdings > Description 6	(ArcReporting)	(ArcReporting)
  Description 07	Reporting Workspace > Portfolio > Fund Holdings > Description 7	(ArcReporting)	(ArcReporting)
  Description 08	Reporting Workspace > Portfolio > Fund Holdings > Description 8	(ArcReporting)	(ArcReporting)
  Description 09	Reporting Workspace > Portfolio > Fund Holdings > Description 9	(ArcReporting)	(ArcReporting)
  Description 10	Reporting Workspace > Portfolio > Fund Holdings > Description 10	(ArcReporting)	(ArcReporting)
  Display On Condensed	Reporting Workspace > Portfolio > Fund Holdings > Display On Condensed	(ArcReporting)	(ArcReporting)
  Egan Jones Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > Egan Jones Credit Rating	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Egan Jones Credit Rating	(ArcFiling or ArcReporting)
  EnhancementProviderList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.16.a - Identity of enhancement provider(s)	(ArcFiling)
  EnhancementProviderNRSROList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.16.d - Designated NRSRO for the enhancement(s) or provider(s)	(ArcFiling)
  EnhancementProviderNRSRORatingList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.16.d - Rating for each Designated NRSRO	(ArcFiling)
  EnhancementTypeList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.16.b - Type of enhancement(s)	(ArcFiling)
  Exchange Rate	Reporting Workspace > Portfolio > Fund Holdings > Exchange Rate	(ArcReporting)	(ArcReporting)
  Expiration Date	Reporting Workspace > Portfolio > Fund Holdings > Expiration Date	(ArcReporting)	(ArcReporting)
  Fair Value Level	Reporting Workspace > Portfolio > Fund Holdings > Fair Value Level	(ArcReporting)	(ArcReporting)
  Fair Value Type	Reporting Workspace > Portfolio > Fund Holdings > Fair Value Type	(ArcReporting)	(ArcReporting)
  Fair Valued	Reporting Workspace > Portfolio > Fund Holdings > Fair Valued	(ArcReporting)	(ArcReporting)
  Final Legal Maturity Date	Reporting Workspace > Portfolio > Fund Holdings > Final Legal Maturity Date	Filings Workspace > N-MFP > Fund Holdings > Item C.12 - Maturity Date (WAL)	(ArcFiling or ArcReporting)
  Fitch Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > Fitch Credit Rating	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Fitch Credit Rating	(ArcFiling or ArcReporting)
  Fixed Interest	Reporting Workspace > Portfolio > Fund Holdings > Fixed Interest	(ArcReporting)	(ArcReporting)
  Floating Interest	Reporting Workspace > Portfolio > Fund Holdings > Floating Interest	(ArcReporting)	(ArcReporting)
  Fund Code	(Environment Administration)	(Environment Administration)	Environment Administration > Settings > Funds > Fund > Fund Code
  GuarantorList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.15.a - Identity of guarantor(s)	(ArcFiling)
  GuarantorNRSROList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.15.c - Designated NRSRO for the guarantor(s)	(ArcFiling)
  GuarantorNRSRORatingList	(ArcFiling)	Filings Workspace > N-MFP > Fund Holdings > Item C.15.c - Rating for each Designated NRSRO	(ArcFiling)
  Has Demand Feature	Reporting Workspace > Portfolio > Fund Holdings > Has Demand Feature	Filings Workspace > N-MFP > Fund Holdings > Item C.14 - Security has Demand Feature	(ArcFiling or ArcReporting)
  Has Enhancement	Reporting Workspace > Portfolio > Fund Holdings > Has Enhancement	Filings Workspace > N-MFP > Fund Holdings > Item C.16 - Security have any enhancements	(ArcFiling or ArcReporting)
  Has Guarantee	Reporting Workspace > Portfolio > Fund Holdings > Has Guarantee	Filings Workspace > N-MFP > Fund Holdings > Item C.15 - Security has a guarantee	(ArcFiling or ArcReporting)
  Illiquid Security	Reporting Workspace > Portfolio > Fund Holdings > Illiquid Security	Filings Workspace > N-MFP > Fund Holdings > Item C.23 - Illiquid Security	(ArcFiling or ArcReporting)
  In Default	Reporting Workspace > Portfolio > Fund Holdings > In Default	(ArcReporting)	(ArcReporting)
  Investment Type	Administration > Reporting Libraries > Security/Investment Master > Investment Type Reporting Workspace > Portfolio > Fund Holdings > Investment Type	Administration > Filing Libraries > Security/Investment Master > Investment Type	(ArcFiling or ArcReporting)
  ISIN	Administration > Reporting Libraries > Security Libraries > Security Captions tab > ISIN Reporting Workspace > Portfolio > Fund Holdings > ISIN	Administration > Filing Libraries > Security Libraries > Security Captions tab > ISIN	(ArcFiling or ArcReporting)
  Issuer	Reporting Workspace > Portfolio > Fund Holdings > Issuer Caption	(ArcReporting)	(ArcReporting)
  JCR Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > JCR Credit Rating	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - JCR Credit Rating	(ArcFiling or ArcReporting)
  LACE Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > Kroll Credit Rating (FKA LACE)	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Kroll Credit Rating (FKA LACE)	(ArcFiling or ArcReporting)
  Language Code	Reporting Workspace > Portfolio > Fund Holdings > Language	(ArcReporting)	(ArcReporting)
  Local Cross Trade	Reporting Workspace > Portfolio > Fund Holdings > Local Cross Trade	(ArcReporting)	(ArcReporting)
  Local Currency Bought	Reporting Workspace > Portfolio > Fund Holdings > Currency Bought - Local	(ArcReporting)	(ArcReporting)
  Local Currency Sold	Reporting Workspace > Portfolio > Fund Holdings > Currency Sold - Local	(ArcReporting)	(ArcReporting)
  Local Unit Price	Reporting Workspace > Portfolio > Fund Holdings > Unit Price - Local	(ArcReporting)	(ArcReporting)
  Market Value	Reporting Workspace > Portfolio > Fund Holdings > Market Value	(ArcReporting)	(ArcReporting)
  Market Value Ask	Reporting Workspace > Portfolio > Fund Holdings > Market Value Ask	(ArcReporting)	(ArcReporting)
  Market Value Bid	Reporting Workspace > Portfolio > Fund Holdings > Market Value Bid	(ArcReporting)	(ArcReporting)
  Master Identifier	Administration > Reporting Libraries > Security/Investment Master > Master Identifier	Administration > Filing Libraries > Security/Investment Master > Master Identifier Filings Workspace > N-MFP > Fund Holdings > Master Identifier	(ArcFiling or ArcReporting)
  Maturity Date	Reporting Workspace > Portfolio > Fund Holdings > Maturity Date	Filings Workspace > N-MFP > Fund Holdings > Item C.11 - Maturity Date (WAM)	(ArcFiling or ArcReporting)
  Moodys Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > Moody’s Credit Rating	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Moody’s Credit Rating	(ArcFiling or ArcReporting)
  Multiplier	Reporting Workspace > Portfolio > Fund Holdings > Multiplier	(ArcReporting)	(ArcReporting)
  NMFP Notes	Reporting Workspace > Portfolio > Fund Holdings > Explanatory Notes	Filings Workspace > N-MFP > Fund Holdings > Item C.24 - Explanatory Notes	(ArcFiling or ArcReporting)
  Non Income	Reporting Workspace > Portfolio > Fund Holdings > Non Income	(ArcReporting)	(ArcReporting)
  Notional Amount	Reporting Workspace > Portfolio > Fund Holdings > Notional Amount	(ArcReporting)	(ArcReporting)
  On Loan	Reporting Workspace > Portfolio > Fund Holdings > On Loan	(ArcReporting)	(ArcReporting)
  Option Premium	Reporting Workspace > Portfolio > Fund Holdings > Option Premium	(ArcReporting)	(ArcReporting)
  Other Credit Rating 1	Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 1	(ArcReporting)	(ArcReporting)
  Other Credit Rating 2	Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 2	(ArcReporting)	(ArcReporting)
  Other Credit Rating 3	Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 3	(ArcReporting)	(ArcReporting)
  Other Credit Rating 4	Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 4	(ArcReporting)	(ArcReporting)
  Other Credit Rating 5	Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 5	(ArcReporting)	(ArcReporting)
  Other Credit Rating 6	Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 6	(ArcReporting)	(ArcReporting)
  Pay Type	Reporting Workspace > Portfolio > Fund Holdings > Pay Type	(ArcReporting)	(ArcReporting)
  Perpetual	Reporting Workspace > Portfolio > Fund Holdings > Perpetual	(ArcReporting)	(ArcReporting)
  Position Type	Reporting Workspace > Portfolio > Fund Holdings > Position Type	(ArcReporting)	(ArcReporting)
  Proceeds	Reporting Workspace > Portfolio > Fund Holdings > Proceeds	(ArcReporting)	(ArcReporting)
  Purchase Amount Base	Reporting Workspace > Portfolio > Fund Holdings > Purchase Amount Base	(ArcReporting)	(ArcReporting)
  Purchase Amount Local	Reporting Workspace > Portfolio > Fund Holdings > Purchase Amount Local	(ArcReporting)	(ArcReporting)
  Purchase Cost	Reporting Workspace > Portfolio > Fund Holdings > Purchase Cost	(ArcReporting)	(ArcReporting)
  R&I Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > R&I Credit Rating	(ArcReporting)	(ArcReporting)
  Realpoint Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > Morningstar Credit Rating (FKA Realpoint)	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Morningstar Credit Rating (FKA Realpoint)	(ArcFiling or ArcReporting)
  Receive Type	Reporting Workspace > Portfolio > Fund Holdings > Receive Type	(ArcReporting)	(ArcReporting)
  Repo Used For Diversification	Reporting Workspace > Portfolio > Fund Holdings > Is Repo Used for Diversification	Filings Workspace > N-MFP > Fund Holdings > Item C.7 - Is Repo Used for Diversification	(ArcFiling or ArcReporting)
  Reset Date	Reporting Workspace > Portfolio > Fund Holdings > Reset Date	(ArcReporting)	(ArcReporting)
  Restricted	Reporting Workspace > Portfolio > Fund Holdings > Restricted	(ArcReporting)	(ArcReporting)
  S&P Credit Rating	Reporting Workspace > Portfolio > Fund Holdings > S&P Credit Rating	Filings Workspace > N-MFP > Fund Holdings > Item C.10 - S&P Credit Rating	(ArcFiling or ArcReporting)
  Security Rating	Reporting Workspace > Portfolio > Fund Holdings > Security Rating	(ArcReporting)	(ArcReporting)
  SEDOL	Administration > Reporting Libraries > Security Libraries > Security Captions tab > SEDOL Reporting Workspace > Portfolio > Fund Holdings > SEDOL	Administration > Filing Libraries > Security Libraries > Security Captions tab > SEDOL	(ArcFiling or ArcReporting)
  Series	Reporting Workspace > Portfolio > Fund Holdings > Series	(ArcReporting)	(ArcReporting)
  Shares	Reporting Workspace > Portfolio > Fund Holdings > Shares	(ArcReporting)	(ArcReporting)
  Short Term Debt	Reporting Workspace > Portfolio > Fund Holdings > Short-Term Debt	(ArcReporting)	(ArcReporting)
  Sold	Reporting Workspace > Portfolio > Fund Holdings > Sold	(ArcReporting)	(ArcReporting)
  Sold Amount Base	Reporting Workspace > Portfolio > Fund Holdings > Sold Amount Base	(ArcReporting)	(ArcReporting)
  Sold Amount Local	Reporting Workspace > Portfolio > Fund Holdings > Sold Amount Local	(ArcReporting)	(ArcReporting)
  Source	Reporting Workspace > Portfolio > Fund Holdings > Security Balance Source	(ArcReporting)	(ArcReporting)
  Step-up Bond	Reporting Workspace > Portfolio > Fund Holdings > Step-up Bond	(ArcReporting)	(ArcReporting)
  Strike Price	Reporting Workspace > Portfolio > Fund Holdings > Strike Price	(ArcReporting)	(ArcReporting)
  Strips	Reporting Workspace > Portfolio > Fund Holdings > Strips	(ArcReporting)	(ArcReporting)
  TBA Description	Reporting Workspace > Portfolio > Fund Holdings > TBA Description	(ArcReporting)	(ArcReporting)
  Unrealized Value	Reporting Workspace > Portfolio > Fund Holdings > Unrealized	(ArcReporting)	(ArcReporting)
  Valoren	Administration > Reporting Libraries > Security Libraries > Security Captions tab > Valoren Reporting Workspace > Portfolio > Fund Holdings > Valoren	Administration > Filing Libraries > Security Libraries > Security Captions tab > Valoren	(ArcFiling or ArcReporting)
  Variable Rate	Reporting Workspace > Portfolio > Fund Holdings > Variable Rate	(ArcReporting)	(ArcReporting)
  Werkpapier	Administration > Reporting Libraries > Security Libraries > Security Captions tab > Werkpapier Reporting Workspace > Portfolio > Fund Holdings > Werkpapier	Administration > Filing Libraries > Security Libraries > Security Captions tab > Werkpapier	(ArcFiling or ArcReporting)
  When-Issued	Reporting Workspace > Portfolio > Fund Holdings > When-Issued	(ArcReporting)	(ArcReporting)
  Yield	Reporting Workspace > Portfolio > Fund Holdings > Yield	Filings Workspace > N-MFP > Fund Holdings > Item C.17 - Yield	(ArcFiling or ArcReporting)
  Yield Date	Reporting Workspace > Portfolio > Fund Holdings > Yield Date	(ArcReporting)	(ArcReporting)
  Zero Coupon	Reporting Workspace > Portfolio > Fund Holdings > Zero Coupon	(ArcReporting)	(ArcReporting)

1. Expand the ArcFiling “Dataload” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcFiling” from the components list.

      

   3. Click the “Administration” tab at lower-left of the screen.

      

   4. Click the “Dataload” menu to view available items.

2. Expand the ArcReporting “Dataload” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcReporting” from the components list.

      

   3. Click the “Administration” tab at lower-left of the screen.

      

   4. Click the “Dataload” menu to view available items.

3. Click the “Archive” item.

   The “Archive” page displays.

   

4. Specify search criteria to filter the list of archived data load batches.

   1. Use the “From Date” and “To Date” calendar controls to set the date range within which to search (by default, dates in these fields are set to the current date).
   2. You can also narrow search results by load batch “Status” (i.e., “Accepted”, “Accepted with Errors/Warnings” or “Awaiting Processing” or “Rejected”).
   3. You may also filter the list of resulting load batch records by “Load Type” using the corresponding drop-down list.

5. Click the “Search” button at right of the “Search Criteria” section.

   Load batches that match the specified criteria display in the “Search Results” grid.

   • Times displayed in the results grid are in Coordinated Universal Time (UTC).

   • Each load batch displays a “Status”, whose possible values are as follows:

     “Accepted”

     • Denotes a batch that was automatically accepted or manually accepted by a user, using the “Accept” button on the data import dialogue.

     “Accepted with Errors/Warnings”

     • Denotes a batch that was automatically accepted or manually accepted by a user, using the “Accept” button on the data import dialogue, but which contained one or more errors or warnings with regard to data contained in the batch.

     “Awaiting Processing”

     • Denotes a batch that has been submitted by a user, but for which another batch of the same load type awaits acceptance/rejection.

     • Load types to which this status is applicable (types which support multiple FTP and/or push-button import file queuing) are as follows:

       • Attributes
       • Class Information
       • Fund Information
       • Holdings
       • N-MFP (XML)
       • Repo Collateral Information

     “Rejected”

     • Denotes a batch that was either manually rejected by a user, using the “Reject” button on the data import dialogue, or automatically “Rejected” during the data load process due to invalid file structure, or some other error.

       For Holdings data imports, it is possible for a file to have a portion of its data loaded, but still be in a “Rejected” state. As data is migrated into the production database, the system will process the data in logical units: Security Captions, Security Balances, Security Categorization, etc. If, for example, step 9 of 10 encounters an error, then data from steps 1-8 will be retained, and the load will enter a “Rejected” state.

6. Click the “View Details” link at right of the load batch record whose information you wish to view.

   The “Archive Details” page opens with the “Details” tab selected, displaying data as it was staged prior to load acceptance or rejection.

   

   • The “View Details” link is disabled for any load batch with a “Status” of “Awaiting Processing” (a batch that has been submitted by a user, but for which another batch of the same load type awaits acceptance/rejection by a user).
   • Times displayed in the “Batch Details” section at the top of the page are in Coordinated Universal Time (UTC).

   1. Click the “Errors/Warnings/Info” tab to read any information provided for specific rows in the data source file.

      If errors were encountered, you can take the steps necessary to resolve them (either by editing the source file accordingly, or making appropriate adjustments to database library settings, etc.), and then attempt to reload the data.

      

      • Warnings represent issues that should be reviewed/verified prior to loading data, but that will not prevent the records from being loaded.
      • Errors denote conditions that must be corrected before data can be successfully loaded into Arc Suite.
      • Times displayed in the “Batch Details” section at the top of the page are in Coordinated Universal Time (UTC).

1. Expand the ArcFiling “Dataload” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcFiling” from the components list.

      

   3. Click the “Administration” tab at lower-left of the screen.

      

   4. Click the “Dataload” menu to view available items.

2. Expand the ArcReporting “Dataload” menu.

   1. Click the “Home” button at the top of the application window to return to the landing page.

   2. Select “ArcReporting” from the components list.

      

   3. Click the “Administration” tab at lower-left of the screen.

      

   4. Click the “Dataload” menu to view available items.

3. Click the “Data Purge” item.

   The “Data Purge” page displays.

   

4. Select criteria for the data to be purged.

   1. Set the “Balance Data Type” to either “Holdings” or “Repo Collateral”“General Ledger” via the corresponding drop-down list.

   2. Use the “Complex” drop-down list to select the complex with which the fund(s) containing the portfolio or financial data are associated.

      Complexes available for selection in the drop-down list are limited to those to which you have access, per settings on the “Complexes” tab of the “Users” page.

   3. Specify a balance type, or leave the default selection of “[All]”, via the “Balance Type” drop-down list.
   4. Specify an account period, or leave the default selection of “[All]”, via the “Account Period” drop-down list.

5. Click the “Search” button at right of the “Search Criteria” section.

   A listing of records is displayed in the grid on the lower portion of the page, which reflects the fund(s) and account period(s) into which portfolio or financial data has been loaded that match the specified search criteria.

6. Select the check box to the left of the data record(s) you wish to purge.

   In the results grid, the check box and the entire row are disabled for any records associated with a closed account period.

   You can use the “Select all” or “Clear all” links to quickly select/clear the check boxes.

7. Click the “Purge” button at lower-right of the page to initiate the data purge.

   The “Confirm Data Purge” dialogue displays.

   1. Click the “Accept” button at lower-right of the dialogue to carry out the data purge operation.

      This action is irreversible once complete!

      Balance data that is associated with the fund(s) and account periods(s) represented by the selected rows in the results grid will be purged entirely from the database.

      Once data represented by selected rows has been purged from the database, a status of “Purged” displays in the “Status” column of the results grid, the entire row is disabled, and the check box cannot be selected.

   2. Click the “Cancel” button at lower-right of the dialogue to cancel the data purge action.

      The “Data Purge” page remains open, in the same state as before the “Purge” button was clicked (with all selections intact).