Extracting Holdings Data

Intro

You can export holdings-related information from Arc Suite for one or more complexes and a for a specified account period to Excel format via the “Holdings Data Extract” page. The resulting file(s) will be in a format that can be used for import to either Arc Suite or the FundSuite SX application, depending on the options you specify.

Certain functionality in this application area requires you to have one or more . For more information about any given right (i.e., what functionality it governs, etc.), please see the “Available User Rights” topic.

Data Structure (Arc Suite)

Information regarding the structure of the extract file for Arc Suite (column names, column order, data types, etc.) is offered in the table below.

To also view information associated with one or more filing forms, select the corresponding check box(es) below, then click the “Update structure view” link (if no check boxes are selected, no filing information will be displayed).

   

Update structure view

  • The first row in XLSX extract files is a header row. Actual data starts on row 2 of such files.

Data Structure (FundSuite SX)

Information regarding the structure of the extract file for FundSuite SX (column names, column order, data types, etc.) is offered in the table below.

To also view information associated with one or more filing forms, select the corresponding check box(es) below, then click the “Update structure view” link (if no check boxes are selected, no filing information will be displayed).

   

Update structure view

  • The first row in XLSX extract files is a header row. Actual data starts on row 2 of such files.

Tasks

    1. Expand the ArcFiling “Production Utilities” .

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

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

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

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

    2. Expand the ArcReporting “Production Utilities” .

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

      2. Select “ArcReporting” from the .
        Landing page components list (ArcReporting)

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

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

    3. Click the “Holdings Data Extract” item.

      “Holdings Data Extract” page

      Complexes shown in the “Available Complexes” pane at right of the page are those to which you have been granted access through your user account settings.

    4. Drag the complex(es) to be included in the export from the “Available Complexes” pane at right of the page to the “Complex(es)” to extract pane at left.

    5. Click the “Account Period” drop-down list to specify the account period for which data will be extracted.

      Values available for selection are open account periods that currently exist in the database for the selected complex(es). By default, the most recent account period is selected.

    6. Use the “Extract data by” to specify the granularity of the extract file(s) produced.
      1. Choose “Complex” (default) to produce just one extract file at the complex level.
      2. Select “Fund Group” in order to produce multiple extract files (one per fund group for the selected complex(es).
      3. Select “Fund” to produce multiple extract files (one per fund for the selected complex(es).

    7. Use the “Language” drop-down list to specify the language for text in the extract file(s).

      This drop-down list selection affects only extracts of “Arc Suite” format; it does not affect data in extracts of “FundSuite SX” format.

    8. Indicate whether the extract file will be used in connection with Arc Suite (default selection) or with the FundSuite SX application by selecting the corresponding “Format” option button.

    9. Click the “Generate output” button at lower-right of the page.

    1. To view project output or a report returned from the document processing service, or the status of filings submitted to the SEC, open the Output Queue by clicking the “Output Queue” button at far upper-right of the screen.

      “Output Queue” pane

    2. Filter the list of items in the queue, if desired, through use of the “Show previous” and/or “Status” .

      1. Show previous: Allows requests to be filtered according to those submitted within a specified time period.

        • 24 hours (default selection)
        • Week
        • Month
        • 6 Months
        • Year

      2. Status: Filters requests according to their processing status.

        • <All> (default selection)
        • Requested
        • Success
        • Failed
        • Success with warnings

    3. Click the “View Output” at right of the document you wish to view to open or save it.
      “File Download” dialogue (output file)
      1. Click “Open” to view the document with your computer’s registered application for the file type.
      2. Click “Save” to save the document to a local or network drive, for viewing by you or others at a later time.

    4. Click the “View Message” at right of the document whose output message you wish to view.
      “Message” dialogue
      1. You can select the text of the message by striking “Ctrl + a” on your keyboard, and then copy it to your Windows keyboard by striking “Ctrl + c”.
      2. Click the “Cancel” button at lower-right of the dialogue to close it.

    5. Click the “Save Output” at right of a document if you simply wish to save it.
      “Save Output Queue” dialogue
      1. Click the “Accept” button at lower-right of the dialogue once the document has downloaded in order to save it to a local or network drive, for viewing by you or others at a later time.
      2. Click the “Cancel” button at lower-right of the dialogue to close it without saving the document.

  • The purpose of the N-MFP holdings data extract is to allow you to transfer holdings-related information from Arc Suite into FundSuite SX. The method in which to do so is a manual multi-step process as follows:

    1. After extracting data from Arc Suite via the “Holdings Data Extract” page, save the resulting Excel (XLSX) file to a local or network drive.

    2. Open the file within Microsoft Excel and modify its contents as follows:

      1. Update values in the “Category Type Codes” column from “NMFP” to appropriate 2-character codes that correspond to those found in the FundSuite SX database.
      2. Change the formatting of the “Account Period”, “Maturity Date” and “Yield Date” columns from “General” to “Date”.
    3. Saves changes to the Excel file.
    4. Open the appropriate form within the FundSuite SX application and select the Excel file for import.

Exporting Fund Holdings Data