Defining Portfolio Statement Template Output Settings

1. Expand the ArcFiling “Structure Templates” 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 “Structure Templates” menu to view available items.

2. Expand the ArcReporting “Structure Templates” 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 “Structure Templates” menu to view available items.

3. Click the “Portfolio Statement Templates” item.

   The “Portfolio Statement Templates” page displays.

   

4. Select the desired item from the “Listing” pane at left of the page.

5. Click the “Output Settings” link at right of the “Settings” section to view/edit settings that affect the display and behavior of statement information in output.

   The “Portfolio Statement Template Output Settings” page displays (the “Portfolio Statement Templates” page remains open).

   

   

   • You can also open the “Portfolio Statement Template Output Settings” page directly by clicking the corresponding item in the “Structure Templates” menu section on the “Administration” tab .
   • Click the “Refresh data” button at lower-right of the pane to refresh content to reflect any changes made to the output settings’ associated template.

6. Review and edit information for the template.

   1. Add data points, custom tags and standard (e.g., “$”, “%”, “€”, “£”, etc.) or custom literal values to the cells of specific statement items.

      1. Select an item from the statement structure tree at left, and then add data points and literal values by dragging-and-dropping them from their respective panes on the tabs beneath the “Mapping” grid.

         

      2. Add custom tags via the associated button at lower-left of the grid.

         1. Select a cell in the grid, and then click the “Insert custom tag” button to define the custom tag settings.

            The “Insert Custom Tag” dialogue displays.

            

            1. Specify the tag to insert via the “Custom Tag” drop-down list.

               The read-only “Description” text box displays the “Description” value associated with the specified custom tag, as defined via the “Custom Tags” page.

            2. If the specified custom tag has the “Additional Fixed Options” check box selected in the Custom Tags library, select one of the available options via the “Additional Fixed Option” drop-down list (the drop-down list is disabled if no fixed options are defined for the selected tag).

            3. If the specified custom tag has the “Additional Arguments” check box selected in the Custom Tags library, enter the appropriate argument(s) in the “Additional Argument(s)” text box.

               For a custom tag requiring additional arguments, it is helpful to provide definitions and/or examples of argument values in the “Description” field when creating/editing the tag via the “Custom Tags” page. This offers some guidance to any user who insert the tag in a text editor.

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

      • If multiple items are added to any given cell, you can control the placement of the appended item during the drag-and-drop action by placing the item in its desired position before the drop occurs within the cell. Items can be removed from cells, and the order of items in the cell can be adjusted using the drop-and-drag functionality.
      • To create a custom literal item, type the desired text in the box at lower-right of the page. The text for the “{custom}” item at the top of the “Literals” pane reflects the text you enter, and that item can be dragged-and-dropped to the appropriate cell in the desired position to insert the custom literal.
      • Hard returns, soft returns, tabs and spaces can also be added to cells. Items representing these can be found at the end of the list of literals provided.

      • Data points available for mapping vary by node selected.

        • When “Custom Data Point” is the specified data point type, a “Library” drop-down list displays through which you can designate the data point library containing the desired data points to map. Only those libraries associated with the same complex as the current template are available for selection.
      • All mapped data points must be added to the “Calculations” tab of the “Portfolio Statement Templates” page.

      • Click the “Add new item to the grid” button at lower-left of the “Mapping” grid, respectively, to add or remove rows.
      • To move selected rows up or down in the “Mapping” grid, use the corresponding positioning arrows at lower-left of the grid.
      • To delete all mapped items and associated formatting and suppression settings in all columns for the selected item, click the “Delete Column Mappings” link at lower-left of the “Mapping” grid.
   2. At any point during the mapping process, you can move entire rows and columns within the grid up/down/left/right by clicking the header of the desired row/column to select it, and then clicking the positioning buttons     appropriately.

   3. You can merge cells in the grid across columns by selecting the cell representing the upper-left cell of the range, and then clicking the “Span cells” button beneath the grid.

      The “Span Cells” dialogue displays.

      

      1. Specify the “Number of Columns to Span” using the corresponding spinner control on the dialogue.

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

         • Any data that was in the upper-left (start) cell of the specified span area will be displayed in the span area text box of the grid; any data in any other cells of the span area range will be deleted.
         • Multiple span areas may exist within a table, but span areas cannot overlap.
         • All row and column positioning buttons are disabled when at least one span area exists in a given template’s grid.

      Click the “Remove Span” button beneath the grid to remove any selected span area.

   4. Indicate the cell style and apply formatting (e.g., bold, italic, underline, color, alignment, etc.) to the text of mapped items.

      1. Format the text of all items within a selected cell.

         Select a cell in the grid, and then click the “Format Cell” button at lower-left of the grid to view/edit cell settings.

         The “Format Cell” dialogue displays.

         

         1. Specify formatting settings, as required.

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

         • When the dialogue is opened, Arc Suite examines the settings of all items in the currently-selected cell to determine what state each check box on the dialogue will display.

           • Cleared

             • All items in the currently-selected cell have the attribute cleared.

           • Selected

             • All items in the currently-selected cell have the attribute selected.

           • Mixed/Indeterminate

             • Some items in the currently-selected cell have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” dialogue).
             • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cell.
         • Formatting settings made via the “Format Cell” dialogue are not reflected in the component preview on the “Project” page; only in output.

      2. Format the text of all items within all the cells of a selected row.

         1. Select a cell in the grid, and then click the “Format Row” button at lower-left of the grid to view/edit row settings.

            The “Format Row” dialogue displays.

            

            1. Specify formatting settings, as required.

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

            • When the dialogue is opened, Arc Suite examines the settings of all items in all cells of the currently-selected row to determine what state each check box on the dialogue will display.

              • Cleared

                • All items in all cells of the currently-selected row have the attribute cleared.

              • Selected

                • All items in all cells of the currently-selected row have the attribute selected.

              • Mixed/Indeterminate

                • Some items in one or more cells of the currently-selected row have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” and/or “Format Column” dialogues).
                • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cells of the selected row.
            • Formatting settings made via the “Format Row” dialogue are not reflected in the component preview on the “Project” page; only in output.

      3. Format the text of all items within all the cells of a selected column.

         1. Select a cell in the grid, and then click the “Format Column” button at lower-left of the grid to view/edit column settings.

            The “Format Column” dialogue displays.

            

            1. Specify formatting settings, as required.

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

            • When the dialogue is opened, Arc Suite examines the settings of all items in all cells of the currently-selected column to determine what state each check box on the dialogue will display.

              • Cleared

                • All items in all cells of the currently-selected column have the attribute cleared.

              • Selected

                • All items in all cells of the currently-selected column have the attribute selected.

              • Mixed/Indeterminate

                • Some items in one or more cells of the currently-selected column have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” and/or “Format Row” dialogues).
                • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cells of the selected column.
            • Formatting settings made via the “Format Column” dialogue are not reflected in the component preview on the “Project” page; only in output.

      Rows in the “Mapping” grid that have only formatting settings applied, but no mapped items, will display in statement preview and output.

      To better understand how project output can be impacted by leveraging different styles, table types and custom tags, click the “Style Guide” link on the page.

   5. Specify display settings for the text of specific items within selected cells.

      1. Click the “Format Items” tab.

      2. Click the cell of the “Mapping” grid that contains the mapped item(s).

         The column number of the selected cell is shown at the top of the “Selected Column Detail” section. The contents of the cell display in the pane at left, in left-to-right order from top-to-bottom.

         

      3. Select a mapped item from the pane at left of the “Selected Column Detail” section.

         1. Set the item’s formatting options via the pane at right (these will vary, based on the type of item selected).

            1. Custom Data Point

               1. (there are no formatting options for custom data point items)

            2. Custom Tag

               1. (there are no formatting options for custom tag items, however a read-only “Tag Description” text box displays the “Description” value associated with the selected custom tag, as defined via the “Custom Tags” page)

            3. Numeric

               1. Use the “Format” drop-down list to specify the format of the numeric value. (click to see option information)

                  Option	Details
                  “n.nn” (default selection)	Decimals based upon rounding level. Displays comma as thousands separator.
                  “n.(n)(n)”	Decimals based upon rounding level, but drops all remaining digits if zero. Displays comma as thousands separator. The period is also dropped if the format is set to 6 decimals.
                  “(n).nn(n)”	Decimals based upon rounding level, but drops first and/or last digit if zero. Displays comma as thousands separator.
                  “(n).nn”	Decimals based upon rounding level, but drops first digit if zero. Displays comma as thousands separator.
                  “nnnn.nn(n)”	Decimals based upon rounding level, but drops last digit if zero. Displays comma as thousands separator.
                  “(nnn.n%)”	Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays comma as thousands separator. If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “Custom Zero Display” value is numeric.
                  “n,nn”	Decimals based upon rounding level. Displays period as thousands separator.
                  “n,(n)(n)”	Decimals based upon rounding level, but drops all remaining digits if zero. Displays period as thousands separator. The comma is also dropped if the format is set to 6 decimals.
                  “(n),nn(n)”	Decimals based upon rounding level, but drops first and/or last digit if zero. Displays period as thousands separator.
                  “(n),nn”	Decimals based upon rounding level, but drops first digit if zero. Displays period as thousands separator.
                  “nnnn,nn(n)”	Decimals based upon rounding level, but drops last digit if zero. Displays period as thousands separator.
                  “(nnn,n%)”	Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays period as thousands separator. If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “>Custom Zero Display” value is numeric.
                  “n nn [comma]”	Decimals based upon rounding level. Displays space as thousands separator. Displays comma as decimal separator.
                  “n nn [period]”	Decimals based upon rounding level. Displays space as thousands separator. Displays period as decimal separator.
                  “n (n)(n) [comma]”	Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays comma as decimal separator. The comma is also dropped if the format is set to 6 decimals.
                  “n (n)(n) [period]”	Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays period as decimal separator. The period is also dropped if the format is set to 6 decimals.
                  “1st, 2nd, 3rd”	Ordinal (1st, 2nd, 3rd) represents the abbreviated ordinal version of the associated numeric.
                  “First, Second, Third”	Ordinal (First, Second, Third) represents the unabbreviated alpha ordinal of the associated numeric.

               2. Use the “Zero Display” drop-down list to specify the value to display if the data point’s raw value is zero. (click to see option information)

                  Option	Details
                  “0 - Decimals based on rounding level” (default selection)	Puts a zero in front of the decimal (where applicable). If the rounding option is set to “000’s” or “000’s (suppressed)”, any value less than 500 (e.g.., “499”) will be shown as “0”. If the rounding option is set to “000’s” or “000’s (suppressed)”, any value above 499 will be rounded up (e.g.., “500” would be rounded to “1,000” or “1” depending on the rounding setting).
                  “0”
                  “.0”
                  “.00”
                  “.000”
                  “.0000”
                  “.00000”
                  “.000000”
                  “0.0”
                  “0.00”
                  “0.000”
                  “0.0000”
                  “0.00000”
                  “0.000000”
                  “Blank”
                  “Dash (-)”
                  “Em Dash (—)”
                  “n/a”
                  “N/A”
                  “zero”
                  “Zero”
                  “ZERO”
                  “zero coupon”
                  “Zero coupon”
                  “Zero Coupon”
                  “ZERO COUPON”

               3. Select the “Custom Zero Display” check box to specify a custom value to display if the data point’s raw value is zero.

                  1. Click the link at right of the check box to view/edit the custom value.

                     The “Add Custom Zero Display” dialogue displays.

                     1. Enter the desired value in the “Display Text” text box.

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

                  • The check box is cleared by default for newly-added data points.
                  • The maximum character limit for the “Display Text” field is 64.
                  • When the check box is cleared, the specified “Display Text” value is retained (for possible future use), however the custom zero display feature is turned off for the currently-selected item; the specified “Zero Display” value will be used in output.

               4. Use the “Negative Display” drop-down list to specify the format of the numeric value if the data point’s raw value is negative. (click to see option information)

                  Option	Sample
                  “Parentheses” (default selection)	(123456.78)
                  “Negative Sign”	-123456.78
                  “Display as Positive”	123456.78

               5. Select the “Display positive/negative values as negative/positive” check box to cause the sign of the value displayed in project preview and output to be “flipped” (similar to multiplying the value by negative 1).

                  • The check box is cleared by default for newly-added data points.

                  • Positive values will be displayed as negative.

                    “100,000” becomes “(100,000)”

                  • Negative values will be displayed as positive.

                    “(100,000)” becomes “100,000”

                  • When displaying a value as negative the specified “Negative Display” setting is used.

                    • If the “Display as Positive” option is specified, all values are displayed as positive, regardless of whether or not the “Display positive/negative values as negative/positive” check box is selected.
                  • This functionality impacts the display of data point values only; it does not alter any calculations within Arc Suite.

               6. Use the “Rounded to Zero Display” drop-down list to specify the value to display if the data point’s raw value was positive and was rounded to zero. (click to see option information)

                  Option	Details
                  “0 - Decimals based on rounding level” (default selection)	Puts a zero in front of the decimal (where applicable). If the rounding option is set to “000’s” or “000’s (suppressed)”, any value less than 500 (e.g.., “499”) will be shown as “0”. If the rounding option is set to “000’s” or “000’s (suppressed)”, any value above 499 will be rounded up (e.g.., “500” would be rounded to “1,000” or “1” depending on the rounding setting).
                  “0”
                  “.0”
                  “.00”
                  “.000”
                  “.0000”
                  “.00000”
                  “.000000”
                  “0.0”
                  “0.00”
                  “0.000”
                  “0.0000”
                  “0.00000”
                  “0.000000”
                  “Blank”
                  “Dash (-)”
                  “Em Dash (—)”
                  “n/a”
                  “N/A”
                  “zero”
                  “Zero”
                  “ZERO”
                  “zero coupon”
                  “Zero coupon”
                  “Zero Coupon”
                  “ZERO COUPON”
                  “(0)”
                  “(.0)”
                  “(.00)”
                  “(.000)”
                  “(.0000)”
                  “(.00000)”
                  “(.000000)”
                  “(0.0)”
                  “(0.00)”
                  “(0.000)”
                  “(0.0000)”
                  “(0.00000)”
                  “(0.000000)”

               7. Select the “Custom Rounded Display” check box to specify a custom value to display if the data point’s raw value was positive and was rounded to zero.

                  1. Click the link at right of the check box to view/edit the custom value.

                     The “Add Custom Rounded Display” dialogue displays.

                     1. Enter the desired value in the “Display Text” text box.

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

                  • The check box is cleared by default for newly-added data points.
                  • The maximum character limit for the “Display Text” field is 64.
                  • When the check box is cleared, the specified “Display Text” value is retained (for possible future use), however the custom rounded display feature is turned off for the currently-selected item; the specified “Rounded to Zero Display” value will be used in output.

               8. Use the “Rounded to Zero Negative Display” drop-down list to specify the value to display if the data point’s raw value was negative and was rounded to zero. (click to see option information)

                  Option	Sample
                  “Parentheses” (default selection)	(123456.78)
                  “Negative Sign”	-123456.78
                  “Display as Positive”	123456.78

            4. Text

               1. Use the “Format” drop-down list to specify the format of the text string. (click to see option information)

                  Option	Details
                  “Proper”	Converts text values that contain one or more lower-case characters to proper case, but will not alter any values that contain ALL upper-case characters.
                  “Uppercase”	Displays the text value in upper-case.

            5. Boolean

               1. Use the “Format” drop-down list to specify the format of the Boolean value. (click to see option information)

                  Option	Details
                  “Proper”	Converts Boolean values that contain one or more lower-case characters to proper case, but will not alter any values that contain ALL upper-case characters.
                  “Uppercase”	Displays the Boolean value in upper-case.

            6. Literal

               1. (there are no formatting options for literal items)

            7. Custom Literal

               1. (there are no formatting options for custom literal items, but you can edit the value of the item in the “Custom Literal” text box)

            8. Date/Time

               1. Use the “Format” drop-down list to specify the format of the date/time value. (click to see option information)

                  Option	Details
                  “(Ordinal suffix)”	Displays an ordinal Suffix only. (English only)
                  “d-M-yy”	Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.
                  “d-M-yyyy”	Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.
                  “d-M”	Displays a numeric Day and Month only, removing the leading zero from each.
                  “d-MM-yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “d-MM-yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “d-MM”	Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.
                  “d-MMM-yy”	Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.
                  “d-MMM-yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “d-MMM”	Displays a numeric Day and 3-character Month abbreviation, removing the leading zero from the numeric Day.
                  “d M yy”	Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.
                  “d M yyyy”	Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.
                  “d M, yy”	Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.
                  “d M, yyyy”	Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.
                  “d M”	Displays a numeric Day and Month only, removing the leading zero from each.
                  “d MM yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “d MM yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “d MM, yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “d MM, yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “d MM”	Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.
                  “d MMM yy”	Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.
                  “d MMM yyyy”	Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year, removing the leading zero from the numeric Day.
                  “d MMM, yy”	Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.
                  “d MMM, yyyy”	Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year, removing the leading zero from the numeric Day.
                  “d MMM”	Displays a numeric Day and 3-character Month abbreviation, removing the leading zero from the numeric Day.
                  “d MMMM (Upper)”	Displays a numeric Day and uppercase spelled-out Month only, removing the leading zero from the numeric Day.
                  “d MMMM yy”	Displays a numeric Day and spelled-out Month, with a 2-digit Year, removing the leading zero from the numeric Day.
                  “d MMMM yyyy”	Displays a numeric Day and spelled-out Month, with a 4-digit Year, removing the leading zero from the numeric Day.
                  “d MMMM, yy”	Displays a numeric Day and spelled-out Month, with a 2-digit Year, removing the leading zero from the numeric Day.
                  “d MMMM, yyyy”	Displays a numeric Day and spelled-out Month, with a 4-digit Year, removing the leading zero from the numeric Day.
                  “d MMMM”	Displays a numeric Day and spelled-out Month only, removing the leading zero from the numeric Day.
                  “d.M.yy”	Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.
                  “d.M.yyyy”	Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.
                  “d.M”	Displays a numeric Day and Month only, removing the leading zero from each.
                  “d.MM.yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “d.MM.yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “d.MM”	Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.
                  “d/M/yy”	Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.
                  “d/M/yyyy”	Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.
                  “d/M”	Displays a numeric Day and Month only, removing the leading zero from each.
                  “d/MM/yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “d/MM/yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “d/MM”	Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.
                  “d”	Removes the leading zero, and displays a single Day only.
                  “dd-M-yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “dd-M-yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “dd-M”	Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.
                  “dd-MM-yy”	Displays a numeric Day and Month, with a 2-digit Year.
                  “dd-MM-yyyy”	Displays a numeric Day and Month, with a 4-digit Year.
                  “dd-MM”	Displays a numeric Day and Month only.
                  “dd-MMM-yy”	Displays a numeric Day and Month, with a 2-digit Year.
                  “dd-MMM-yyyy”	Displays a numeric Day and Month, with a 4-digit Year.
                  “dd-MMM”	Displays a numeric Day and 3-character Month abbreviation.
                  “dd M yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “dd M yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “dd M, yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “dd M, yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “dd M”	Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.
                  “dd MM yy”	Displays a numeric Day and Month, with a 2-digit Year.
                  “dd MM yyyy”	Displays a numeric Day and Month, with a 4-digit Year.
                  “dd MM, yy”	Displays a numeric Day and Month, with a 2-digit Year.
                  “dd MM, yyyy”	Displays a numeric Day and Month, with a 4-digit Year.
                  “dd MMM yy”	Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year.
                  “dd MMM yyyy”	Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.
                  “dd MMM, yy”	Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year.
                  “dd MMM, yyyy”	Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.
                  “dd MMM”	Displays a numeric Day and 3-character Month abbreviation.
                  “dd MMMM (Upper)”	Displays a numeric Day and uppercase spelled-out Month only.
                  “dd MMMM yy”	Displays a numeric Day and spelled-out Month, with a 2-digit Year.
                  “dd MMMM yyyy”	Displays a numeric Day and spelled-out Month, with a 4-digit Year.
                  “dd MMMM, yy”	Displays a numeric Day and spelled-out Month, with a 2-digit Year.
                  “dd MMMM, yyyy”	Displays a numeric Day and spelled-out Month, with a 4-digit Year.
                  “dd MMMM”	Displays a numeric Day and spelled-out Month only.
                  “dd. MMM yyyy”	Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.
                  “dd. MMMM yyyy”	Displays a numeric Day and spelled-out Month, with a 4-digit Year.
                  “dd.M.yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “dd.M.yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “dd.M”	Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.
                  “dd.MM.yy”	Displays a numeric Day and Month, with a 2-digit Year.
                  “dd.MM.yyyy”	Displays a numeric Day and Month, with a 4-digit Year.
                  “dd.MM”	Displays a numeric Day and Month only.
                  “dd/M/yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “dd/M/yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “dd/M”	Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.
                  “dd/MM/yy”	Displays a numeric Day and Month, with a 2-digit Year.
                  “dd/MM/yyyy”	Displays a numeric Day and Month, with a 4-digit Year.
                  “dd/MM”	Displays a numeric Day and Month only.
                  “dd”	Displays a 2-digit Day only.
                  “M-d-yy”	Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.
                  “M-d-yyyy”	Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.
                  “M-d”	Displays a numeric Month and Day only, removing the leading zero from each.
                  “M-dd-yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “M-dd-yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “M-dd”	Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.
                  “M d yy”	Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.
                  “M d yyyy”	Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.
                  “M d”	Displays a numeric Month and Day only, removing the leading zero from each.
                  “M dd yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “M dd yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “M dd”	Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.
                  “M.d.yy”	Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.
                  “M.d.yyyy”	Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.
                  “M.d”	Displays a numeric Month and Day only, removing the leading zero from each.
                  “M.dd.yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “M.dd.yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “M.dd”	Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.
                  “M/d/yy”	Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.
                  “M/d/yyyy”	Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.
                  “M/d”	Displays a numeric Month and Day only, removing the leading zero from each.
                  “M/dd/yy”	Removes the leading zero from the numeric Month only, and displays a 2-digit Year.
                  “M/dd/yyyy”	Removes the leading zero from the numeric Month only, and displays a 4-digit Year.
                  “M/dd”	Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.
                  “M”	Removes the leading zero, and displays a single numeric Month only.
                  “MM-d-yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “MM-d-yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “MM-d”	Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.
                  “MM-dd-yy”	Displays a numeric Month and Day, with a 2-digit Year.
                  “MM-dd-yyyy”	Displays a numeric Month and Day, with a 4-digit Year.
                  “MM-dd”	Displays a numeric Month and Day only.
                  “MM d yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “MM d yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “MM d”	Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.
                  “MM dd yy”	Displays a numeric Month and Day, with a 2-digit Year.
                  “MM dd yyyy”	Displays a numeric Month and Day, with a 4-digit Year.
                  “MM dd”	Displays a numeric Month and Day only.
                  “MM.d.yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “MM.d.yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “MM.d”	Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.
                  “MM.dd.yy”	Displays a numeric Month and Day, with a 2-digit Year.
                  “MM.dd.yyyy”	Displays a numeric Month and Day, with a 4-digit Year.
                  “MM.dd”	Displays a numeric Month and Day only.
                  “MM/d/yy”	Removes the leading zero from the numeric Day only, and displays a 2-digit Year.
                  “MM/d/yyyy”	Removes the leading zero from the numeric Day only, and displays a 4-digit Year.
                  “MM/d”	Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.
                  “MM/dd/yy”	Displays a numeric Month and Day, with a 2-digit Year.
                  “MM/dd/yyyy”	Displays a numeric Month and Day, with a 4-digit Year.
                  “MM/dd”	Displays a numeric Month and Day only.
                  “MM/yy”	Displays a numeric Month, with a 2-digit Year.
                  “MM”	Displays a numeric Month only.
                  “MMM (Upper)”	Displays an uppercase 3-character Month abbreviation only.
                  “MMM d (Ordinal)”	Displays a 3-character Month abbreviation and ordinal Day only.
                  “MMM d, yy”	Displays a 3-character Month abbreviation and numeric Day, with a 2-digit Year, removing the leading zero from the numeric Day.
                  “MMM d, yyyy”	Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year, removing the leading zero from the numeric Day.
                  “MMM d”	Displays a 3-character Month abbreviation and numeric Day only, removing the leading zero from the numeric Day.
                  “MMM dd, yy”	Displays a 3-character Month abbreviation and numeric Day, with a 2-digit Year.
                  “MMM dd, yyyy”	Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year.
                  “MMM dd. yyyy”	Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year.
                  “MMM dd”	Displays a 3-character Month abbreviation and numeric Day only.
                  “MMM yy”	Displays a 3-character Month abbreviation, with a 2-digit Year.
                  “MMM yyyy”	Displays a 3-character Month abbreviation, with a 4-digit Year.
                  “MMM”	Displays a 3-character Month abbreviation only.
                  “MMMM (Upper)”	Displays an uppercase spelled-out Month only.
                  “MMMM d, yy”	Displays a spelled-out Month and numeric Day, with a 2-digit Year, removing the leading zero from the numeric Day.
                  “MMMM d, yyyy”	Displays a spelled-out Month and numeric Day, with a 4-digit Year, removing the leading zero from the numeric Day.
                  “MMMM d”	Displays a spelled-out Month and numeric Day only, removing the leading zero from the numeric Day.
                  “MMMM dd, yy”	Displays a spelled-out Month and numeric Day, with a 2-digit Year.
                  “MMMM dd, yyyy” (default selection)	Displays a spelled-out Month and numeric Day, with a 4-digit Year.
                  “MMMM dd”	Displays a spelled-out Month and numeric Day only.
                  “MMMM yy”	Displays a spelled-out Month, with a 2-digit Year.
                  “MMMM yyyy”	Displays a spelled-out Month, with a 4-digit Year.
                  “MMMM”	Displays a spelled-out Month only.
                  “yy”	Displays a 2-digit Year only.
                  “yyyy”	Displays a 4-digit Year only.

         2. If desired, specify conditional suppression settings for the mapped item.

            1. Click the “Edit” link at right of the “Item Suppression” section heading to view/edit suppression settings.

               The “Edit Item Suppression” dialogue displays.

               

               1. Select the check box(es) corresponding to the suppression option(s) you wish to apply to the mapped item.

                  You can select more than one suppression option for a given item. If any of the selected suppression options evaluates to “True”, the item will be suppressed.

                  1. Select the “Suppress if previous item is empty” check box if you want to suppress the mapped item if the item that comes before it in the current column and cell (whether of type text, date or numeric) is empty.
                  2. Select the “Suppress if subsequent item is empty” check box if you want to suppress the mapped item if the item that comes after it in the current column and cell (whether of type text, date or numeric) is empty.

                  3. Select the “Custom suppression” check box if you want to suppress the mapped item based on a specific condition that you specify.

                     1. Use the “Column Name” drop-down list to specify the field whose value will be evaluated.

                     2. Use the “Condition” drop-down list to designate the condition to employ when evaluating the specified field’s value (available selections will vary, based on the type of field specified in the “Column Name” drop-down list).

                        “Condition” Selection		Operand Data Type
                        		Text	Numeric	Date	Boolean
                        contains
                        equal to
                        greater than
                        greater than or equal to
                        less than
                        less than or equal to
                        not equal to

                     3. Enter one or more values against which the specified “Column Name” value will be compared in the “Value(s)” text box (multiple values must be separated by a semicolon, with no space).

                        1. For Boolean-type fields, you must specify “True” or “False” in the text box.
                        2. For date-type fields, you must specify the date in “mm/dd/yyyy” format.
                        3. For numeric-type fields, you must enter only numeric values in the text box (except for semicolons).

                        If multiple values are entered in the text box, the comparison statement will use either “and” or “or” logic, based on the type of the specified “Column Name”.

                        • “equal to” = “or”
                        • “contains” = “or”
                        • “greater than” = (invalid condition; returns “false”)
                        • “less than” = (invalid condition; returns “false”)
                        • “not equal to” = “and”

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

                  The item suppression option(s) you specified are listed beneath the “Item Suppression” section heading.

               The “Edit” link is enabled/clickable only when a node of type “Security”, “Other Securities” or “Aggregated Securities” is selected; for any other type of node, the link is disabled.

         3. If the item is mapped to any security-type statement item (i.e., “Security”, “Security Single”, “Stack Level Security Single”, “Aggregated Securities” or “Other Securities”), and if desired, specify conditional display settings for it.

            “Conditional Display” options assist in the control of common output template logic, such as the need to display the currency symbol for the first security that displays on a page, or to suppress a security’s currency code if it is the same as the previous security, etc.

            1. Select the check box(es) corresponding to the display option(s) you wish to apply to the mapped item.

               1. Select the “Display if top of page” check box to designate that the selected data point should only be displayed when the line appears on the top of the page or column.
               2. Select the “Display if different than previous security” check box to specify that the selected data point should be displayed only when its value is different than the value of the same data point for the previous security.
               3. Select the “Display if first in outermost category/group” option to designate that the selected data point should be displayed only when it if the first record to appear within an outermost category or group.

               If none of the check box options are selected for a given data point, the data point will always display.

         4. Specify the style and position of a selected item.

            1. Select an item within the cell, and then click the “Format Item” button at lower-left of the pane to view/edit item settings.

               The “Format Item” dialogue displays.

               

               1. Specify formatting settings, as required.

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

               • When editing an item whose style formatting has been set previously (whether via the “Format Item”, “Format Cell”, “Format Row” or “Format Column” dialogues), the check box state of each setting will reflect the current respective settings of the item.
               • When editing an item whose position formatting has been set previously via the “Format Item” dialogue, the option button selection will reflect the current position setting of the item.
               • Formatting settings made via the “Format Item” dialogue are not reflected in the component preview on the “Project” page; only in output.
         5. Move a selected item up or down (left or right) using the “Move item up” and “Move item down” buttons   at lower-left of the pane.
         6. Remove selected items from the column via the “Remove item” button at lower-left of the pane.

   6. If desired, opt to suppress the selected item from the holdings preview and in project output.

      1. Click the “Suppression” tab to view/edit suppression settings.

         

         This tab is only enabled when nodes of type “Security”, “Other Securities” (“condensed” statements only), “Aggregated Securities”, “Category Header”, “Category Total”, “Formula”, “Group Header”, “Group Total”, “Stack Level Header”, “Stack Level Total”, “Negative Subtotal”, “Positive Subtotal”, “Net Assets”, “Other Assets” or “Total Investments” are selected in the statement structure tree.

         1. Specify suppression options for statement items of type “Category Header”, with any cell in the “Column Header” row of the “Mapping” grid selected.

            1. Select the “Suppress column header text if same as previous” option button to suppress the text in the current cell when its complete text is identical to that of the previous column header.
            2. Select the “Suppress column header text for this cell” option button to suppress the column header text, regardless of the header text contained in any previous column header rows.
            3. Select the “Display column header text for this cell” option button to display the column header text, regardless of the header text contained in any previous column header rows.

         2. Specify suppression options for any other supported node type (except “Category Header”, with any cell in the “Column Header” row of the “Mapping” grid selected).

            1. Select the “Zero Suppress” check box to suppress the item based on whether the value of a specified numeric-type portfolio field is zero (“0”).

               • The check box is cleared by default (i.e., suppression is turned off) for new portfolio statement templates.

                 • For items of type “Positive Subtotal” or “Positive Subtotal”, the check box is selected by default.

               • For items of type “Security”, If the specified “Value Type” is “Raw”, the evaluation of zero suppression will be made before all rounding, totaling and footing.

                 • If a security’s raw value is “0”, it will be completely removed from all calculations and totaling.

                   This will not work for aggregate fields, such as “Min”, “Max” or “Avg”, as they require calculations to occur first.

               • For items of type “Aggregated Securities”, if there are no “other” securities and the “Market Value” is “0”, the line item will suppress in project preview and output when the check box is selected.

               • For items of type “Formula”, if the total of selected categories in the formula is “0”, the line item will suppress in project preview and output when the check box is selected.

                 • You can also select the associated “Suppress formula if only 1 item in the formula definition does not equal zero” check box (cleared by default), if desired.

                   For example, if three categories are specified in the formula and you want to suppress the formula if two of the categories have a value of “0”, but one category has a non-zero value.

               1. Use the associated “Based On” drop-down list to specify the data point whose value should be considered when the zero suppression logic is run for the selected item.

                  If the value of the specified data point is zero, the item will be suppressed; if the value of the data point is greater than or less than zero, the item will not be suppressed.

               2. Identify which “Value Type” to analyze (i.e., “Footed”, “Raw” or “Rounded”) when the zero suppression logic is run.

                  • For items of type “Other Securities”, the only selection available in the drop-down list is “Footed”.

            2. For items of type “Category Total” (i.e., category and category exception total lines), select the “Suppress category total if single security item is displayed” check box (displayed beneath the “Value Type” drop-down list), if desired.

               • For innermost categories or category exceptions, specific logic applies.

                 • If the check box is selected for a given category total line:

                   • The total line will be suppressed in statement preview and output when:

                     • A single security exists in the category OR
                     • Only the “Other Securities” line item exists in the category OR
                     • Only one “Aggregated Securities” line item exists in the category.

                   • The total line will be displayed in statement preview and output when:

                     • Any combination of two or more security row types (i.e., “Aggregated Securities” or “Other Securities”) will display under the innermost level.
                 • If the check box is cleared for a given category total line, the total line will be displayed in statement preview and output.

               • For outer categories and category exceptions, specific logic applies.

                 • If the check box is selected for a given category total line:

                   • The total line will be suppressed in statement preview and output when a single security exists in the category.

                     There could be, for example, 1,000 securities within the outer-level category, but if they are all assigned to a single category, then the outer-level category total will be suppressed.

                   • The total line will be displayed in statement preview and output when more than one category will display under the outer category.
                 • If the check box is cleared for a given category total line, the total line will be displayed in statement preview and output.

               1. You can also select the associated “Enable single security row layout (if only one security in this category)” check box to enable the specification of distinct mappings/settings for use if only one security exists in the category.

                  • When the check box is selected, the following occurs:

                    • An item of type “Security Single” displays in the tree view above the “Security” item for the selected category after the “Save” button is clicked.

                      

                    • If the selected category has only one security, the mappings/settings for the “Security Single” item are used for statement preview and output, rather than those for the “Security” item.

                      This logic applies if the single security appears within any of the following areas:

                      1. An “Other Securities” section on a statement of type “Condensed”
                      2. An “Aggregated Securities” section
                      3. A “Stack” section

                    When the check box is cleared, the “Security Single” item and any associated mappings/settings are removed from the template after the “Save” button is clicked.

            3. For items of type “Category Total” (i.e., category and category exception total lines), select the “Suppress category total if single category is displayed” check box to suppress the total line in statement preview and output when the selected category is the only one that exists at the innermost level.

            4. For items of type “Stack Level Header” or “Stack Level Total”, select the “Suppress stack row if stack level is blank” check box to suppress the line in statement preview and output.

      2. Ensure that the specified suppression “Based On” data point calculates a total in the statement template, via the “Calculations” tab of the “Portfolio Statement Templates” page.

         1. Open the “Portfolio Statement Templates” page.
         2. Choose the appropriate template from the “Listing” section at left of the page.
         3. Select the statement node from the “Detail” section at right of the page.
         4. Click the “Calculations” tab.

         5. If the data point upon which you want to base security suppression does not display in the “Calculations” grid, Click the “Add” button at lower-left of the grid to add it.

            For example, if you want to suppress securities or a category or a category total if the “Market Value” value is zero, verify that you have a calculation for “Market Value” defined in this tab.

            

            • If you do not specify that the data point be calculated, the raw, rounded and footed numbers will all be the same.
            • In the case of category headers and category totals, if you do not specify that the data point be calculated, Arc Suite will interpret the total as zero (“0”) and suppress all category headers or totals, regardless of the underlying values.

7. Click the “Save” button at lower-right of the page if any updates were made.

1. Expand the ArcFiling “Structure Templates” 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 “Structure Templates” menu to view available items.

2. Expand the ArcReporting “Structure Templates” 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 “Structure Templates” menu to view available items.

3. Click the “Portfolio Statement Template Output Settings” item.

   The “Portfolio Statement Template Output Settings” page displays.

   

   You can also open the “Portfolio Statement Template Output Settings” page for any given portfolio statement template by clicking the “Output Settings” link while viewing that template on the “Statement Detail” tab of the “Portfolio Statement Templates” page.

4. Select the desired item from the “Listing” pane at left of the page.

   The structure and settings defined in the selected template are displayed in the “Detail” pane at right of the page.

5. Select the line item whose column mappings you wish to review in the tree view structure at left of the “Detail” pane.

6. Click the “Delete Mappings” link at lower-left of the “Mapping” grid.

   If you respond “Yes” on the confirmation dialogue that displays, all mappings and associated formatting and suppression settings will be deleted for the selected line item.

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

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 “Structure Templates” 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 “Structure Templates” menu to view available items.

2. Expand the ArcReporting “Structure Templates” 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 “Structure Templates” menu to view available items.

3. Click the “Portfolio Statement Templates” item.

   The “Portfolio Statement Templates” page displays.

   

4. Click the “Add” button at lower-right of the page to add the template.

   The “Create Portfolio Statement Template” dialogue displays.

   

   1. Specify whether to create a completely new template, or to base the new template on a previously-created template.

      1. Select the “Blank Template” optionoption (default) to create a new, blank template.

         1. Specify the desired “Portfolio Type”.

            1. Select “Full” (default) to create a portfolio statement (1) that will include all securities OR (2) for a diversification table OR (3) that will include a Top ‘N’ filter.
            2. Select “Condensed/Summary” to create a portfolio statement that will include aggregation settings and display options for an “Other” securities line item.
            3. Select “Categories” to create a portfolio statement that will aggregate innermost categories that are less than X% of Net Assets or Total Investments into one statement line item.

      2. Select the “Copy Existing Template” option to create a template whose properties and settings match those of an existing template in the database.

         

         1. Specify the complex associated with the template upon which the new statement template will be based via the “Source Complex” drop-down list.
         2. Specify the existing template on which the new statement template will be based via the “Source Template” drop-down list.
         3. Specify the complex with which the new statement template will be associated via the “Target Complex” drop-down list.

      3. Select the “Import” option to create a template whose properties and settings match those of an existing template that has been exported to a file of XML format.

         

         1. Select your import file using the “Browse” button at right of the “Source File” field.
         2. Specify the complex with which the new statement template will be associated via the “Target Complex” drop-down list.

         For information on how to export a template, see the “Exporting a portfolio statement template” task.

   2. Click the “Create/Import Template” button at lower-right of the dialogue.

      The dialogue closes, and the new statement template is selected/displayed.

5. Specify template properties in the upper portion of the “Detail” pane at right of the page.

   1. “Blank Template” option

      1. Click the “Complex” drop-down list to specify the complex with which the new portfolio statement template will be associated.
      2. Enter a “Template Name”, “Description” and “Output Style Type” for the new template, either in the cells of the new row at left of the page, or in the fields of the “Detail” pane at right.

   2. “Copy Existing Template” option

      1. Edit the newly-copied template’s “Template Name”, “Description” and “Output Style Type” as appropriate.

   3. “Import” option

      1. Edit the newly-imported template’s “Template Name”, “Description” and “Output Style Type” as appropriate.

   Available output style types are limited to those designated as “active” in association with the current complex, via the Table Styles library.

6. Define the template’s structure and associated settings via the “Statement Detail” tab.

   1. To define the sort order of items in the statement, select the “Statement” item in the structure tree, and then click the “Sorting” tab in the “Settings” section at right.

      

      1. Click the “Add” button at lower-left of the “Sorting” tab in the “Settings” section to define sort settings.

         The “Add Sorting Specification” dialogue displays.

         

         1. Click the “Column Name” drop-down list.

         2. Select the desired column name by which to sort.
         3. Specify a “Sort Direction” of either “Ascending” (default) or “Descending”.

         4. Specify whether the sort will be of type “Standard” or “Custom”.

            1. For a “Standard” sort, do the following:

               1. Click the “Column Name” drop-down list.

               2. Select the desired column name by which to sort.
               3. Specify a “Sort Direction” of either “Ascending” (default) or “Descending”.
            2. For a “Custom” sort, specify a “Portfolio Custom Sort Profile” definition to govern sorting.

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

            The specified sorting settings will apply to items contained within the selected statement node.

         Selected rows can be moved up or down in the “Sorting” grid by means of the corresponding positioning arrows , also at lower-left of the grid.

   2. Specify settings on the “Prior Period” tab to govern the display of prior account period values on a portfolio statement.

      1. Select the “Enable prior period functionality” check box to turn on prior period functionality for any statement using the template.

         • The check box is cleared by default when a new portfolio statement template is created.
         • When the check box is selected, the remainder of the controls on the tab (whose settings are used) are enabled.
         • If the check box is selected, additional data points (with the suffix “(prior)”) will be available for mapping from the “Security” pane on the “Format Items” tab of the “Portfolio Statement Template Output Settings” page.

      2. Use the “Prior Period” drop-down list to specify the prior period (i.e., “Comparative 1st prior”, “Fiscal Year End 1st prior”, “Fiscal Year Semi End”, “Fiscal Year Semi End 1st prior” or “Quarter End 1st prior”) that will be used to populate all prior period values on the statement.

         • Category captions are always are populated from the current account period. If the current account period is missing a caption, statement preview and output will display “Unknown”.
         • The “Fiscal year end changes” setting for the fund (specified via the “Fund” tab of the “Funds” page) is respected if it falls within one of the existing data points.

      3. Select the “Display category header if no securities held in current period” check box to display a category header row in statement preview and output if a given category had no securities in it in the current period, but had at least one security in it in the prior year.

         • The check box is cleared by default when a new portfolio statement template is created.
         • If the check box is selected, neither individual securities nor the category total row will be displayed.
         • When displaying zero for the current period, statement preview and output will respect the Zero Display setting for the data point specified on the “Portfolio Statement Template Output Settings” page.

   3. Specify settings on the “Calculations” tab for calculating certain values when including a “Percent of Net Assets” and/or “Total Investments” line on a portfolio statement.

      1. Select the “Use primary statement to calculate statement values” check box on the template’s “Statement” node if a primary statement has been designated for the fund and the newly-created secondary statement template will use values/percentages from that statement in its calculations.

         • The check box is selected by default when a new portfolio statement template is created.
         • If the statement template is the primary statement, or to specify independent calculation settings for a secondary statement, clear the “Use primary statement to calculate statement values” check box.

         1. Select the “Use primary statement’s footed values and percentages to calculate statement values” option button to utilize footed values and percentages from the designated primary portfolio statement template.

            • This option button is selected by default when a new portfolio statement template is created.

            • Specifying this option introduces the possibility of creating scenarios where footing is incorrect on the secondary statement, when the “Total Investments”/“Net Assets” values, or other impactful portfolio statement template setup/configuration settings are not identical between the primary and secondary statements.

         2. Select the “Use primary statement’s footed values to calculate statement values” option button to utilize footed values only from the designated primary portfolio statement template.

      2. For portfolio statement templates of type “Full” and “Condensed”, if you select the “Calculate category totals using rounded values” check box for a given category or group, the calculation engine switches from “Calculating category totals from raw values then footing” to “Calculating category total from rounded security values”.

         • This functionality only affects category/group total calculations. The “Total Investments” line continues to calculate using raw values and does not change based on use of this option.
         • This functionality does not disable the footing engine. However, the footing logic adjusts securities in other categories/groups to make up for lost footing opportunities within the current category/group.
         • This functionality applies to all values set on the “Calculations” tab at the statement level, except for the “Percent of Net Assets”, “Percent of Par” and “Percent of Total Investments”.
         • If all categories/groups have this check box option selected, securities within them may be adjusted for footing.
         • The rounded value for each number is determined by the “Rounding” setting on the “Calculations” tab at the statement level.
         • The check box is cleared by default.

      3. For portfolio statement templates of type “Full” and “Condensed”, you can use the “Calculation Exceptions” grid on the tab for categories, category exceptions and groups to specify different rounding settings for numeric values than those designated at the “Statement” level (a read-only “Statement-level Calculations” grid at the top of the tab displays calculation settings for the “Statement” node for review/comparison purposes).

         • You may enter any integer value in the “Sample Number” text box at the top of the group box. After a rounding level is designated for any field added to the calculation exceptions grid, the specified numeric value is displayed accordingly in the “Example” column of the grid.
         • You can export a listing of calculation exception definitions for selected category/category exception/group by clicking the “Export Data” button at lower-right of the “Calculation Exceptions” grid.
      4. For information on how to add a net assets line and its associated calculations, see the “Defining Portfolio Statement Template Output Settings” task.
      5. For information on how to add a total investments line and its associated calculations, see the “Defining Portfolio Statement Template Output Settings” task.

      • Values not calculated on the primary statement’s “Calculations” tab return a value of “0” on any secondary statements using those values. The desired values must be added to the primary statement’s “Calculations” tab to render appropriate values on secondary statements.
      • All mapped data points must be added to the “Calculations” tab of the “Portfolio Statement Templates” page.

   4. Designate which specific securities to include or exclude from your statement, based on the value of one or more fields, via the “Filter” tab.

      1. Specify securities to include in the “Inclusions” section of the tab.

         1. Click the “Add” button at lower-left of the grid to view/edit settings.

            The “Add Filter Inclusion” dialogue displays.

            1. Specify the inclusion “Type” (i.e., “Category Type”, “Field”, “Footnote” or “Top N”) from the drop-down list and define the associated settings.

               1. If you specify “Category Type” as the inclusion type, designate one or more categories to include in the filter.

                  

                  1. Specify the appropriate “Type” in the corresponding drop-down list.

                  2. Specify the category library that contains the categories to include in the filter via the “Library” drop-down list.

                     Available selections are limited to libraries associated with the complex of the current portfolio statement template.

                  3. Designate the categories to be included.

                     • To add a category, drag-and-drop it from the “Available Categories” pane at right to the “Included Category(ies)” pane at left.

                     • Drag-and-drop categories from left to right to remove them from the filter inclusion.
                     • You can multi-select categories for the drag/drop operation.

                  • If a given security is assigned to any category in the “Included Category(ies)” list, it will be included.
                  • Any number of filter inclusions of type “Category Type” can be defined.

               2. If you specify “Field” as the inclusion type, define a condition under which a specified field is included in the filter.

                  1. Specify the field to include using the “Field” drop-down list.
                  2. Specify an “Operator” value for the condition (e.g., “contains”, “equal to”, “greater than”, etc.).

                  3. If you specify “Expiration Date”, “Maturity Date”, “Reset Date” or “Yield Date” as the “Field”, use the “Days” spinner control to designate the number of days after the current reporting period against which to compare the specified field.

                     

                  4. If you specify any field value except “Expiration Date”, “Maturity Date”, “Reset Date” or “Yield Date” as the “Field”, use the “Value” text box to designate the value against which to compare the specified field.

                     

                  • The “Total Investments” value for portfolio statement templates that use this functionality will only be based on the included securities shown on the statement.
                  • The “Percent of Total Investments” value will only include and calculate based on securities shown on the statement, unless the option to “Use primary statement’s footed values to calculate statements” is selected.
                  • Any number of filter inclusions of type “Field” can be defined.

               3. If you specify “Footnote” as the inclusion type, designate a footnote as the basis for the inclusion (i.e., any security to which the specified footnote is attached is included in the filter).

                  

                  1. Specify the footnote library that contains the footnote to be used in the filter via the “Footnote Library” drop-down list.

                     Available selections are limited to libraries associated with the complex of the current portfolio statement template.

                  2. Specify the desired “Footnote” from the library.

                  Any number of filter inclusions of type “Footnote” can be defined.

               4. If you specify “Top N” as the inclusion type, indicate the number of securities to include based on the value of a given field.

                  

                  1. Use the “Top” spinner control to designate the number of securities to consider for inclusion.
                  2. Specify the field whose value will be evaluated via the “By” drop-down list.
                  3. Select the “Group like fields” check box if you wish to designate a field by which to aggregate securities when the “Top N” holdings are evaluated. This causes each set of aggregated records to be counted as a single record for “Top N” purposes.

                  4. If you selected the “Group like fields” check box, designate the field by which to group via the associated “By” drop-down list. (click to see example(s))

                     If there are three holdings with the same “Issuer” value, these “Issuer” balances will be aggregated. Once these values are aggregated, the sum of the market values will be part of the Top 5 holdings and will show in the report. For counting purposes, the combined Issuer records will only be counted as one of the Top 5 holdings in the report. Whether the three securities will display in project preview and output will depend on aggregation settings in the portfolio statement template.

                  Any number of filter inclusions of type “Top N” can be defined.

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

      2. Set conditions for a security’s exclusion in the “Exclusions” section of the tab.

         1. Click the “Add” button at lower-left of the grid to view/edit settings.

            The “Add Filter Exclusion” dialogue displays.

            1. Specify the exclusion “Type” (i.e., “Category Type” or “Field”) from the drop-down list and define the associated settings.

               1. If you specify “Category Type” as the exclusion type, designate one or more categories to exclude from the filter.

                  

                  1. Specify the appropriate “Category Type” in the corresponding drop-down list.

                  2. Specify the category library that contains the categories to exclude from the filter via the “Library” drop-down list.

                     Available selections are limited to libraries associated with the complex of the current portfolio statement template.

                  3. Designate the categories to be excluded.

                     • To add a category, drag-and-drop it from the “Available Categories” pane at right to the “Excluded Category(ies)” pane at left.

                     • Drag-and-drop categories from left to right to remove them from the filter exclusion.
                     • You can multi-select categories for the drag/drop operation.

                  • If a given security is assigned to any category in the “Excluded Category(ies)” list, it will be excluded.
                  • Any number of filter exclusions of type “Category Type” can be defined.

               2. If you specify “Field” as the exclusion type, define a condition under which a specified field is excluded from the filter.

                  1. Specify the field to exclude using the “Field” drop-down list.
                  2. Specify an “Operator” value for the condition (e.g., “contains”, “equal to”, “greater than”, etc.).

                  3. If you specify “Expiration Date”, “Maturity Date”, “Reset Date” or “Yield Date” as the “Field”, use the “Days” spinner control to designate the number of days after the current reporting period against which to compare the specified field.

                     

                  4. If you specify any field value except “Expiration Date”, “Maturity Date”, “Reset Date” or “Yield Date” as the “Field”, use the “Value” text box to designate the value against which to compare the specified field.

                     

                  • The values from holdings excluded from the portfolio statement preview and output due to “Exclusion” settings will be excluded from the “Total Investments” calculation.
                  • Any number of filter exclusions of type “Field” can be defined.

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

      If one or more filter inclusions and one or more filter exclusions are specified, all securities that meet the exclusion criteria will be removed from consideration before logic is run to determine which securities meet the inclusion criteria.

   5. For statements of type “Condensed/Summary” (not “Full”), use the “Condensed” tab to designate which holdings will display on the statement individually, as opposed to being grouped in an “Other Securities” section on the statement.

      1. Select the “Attribute” check box to base holdings display on one or more of a holding’s attributes (e.g., “Illiquid Security”, “Non-Income”, “Restricted”, etc.).

         1. Select one or more check boxes in the section to specify which attribute value(s) should be set to “True” for the security.

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

      2. Select the “Top ‘N’” check box to base holdings display on the value of a specified field for any given holding.

         1. Set a value in the spinner control that represents the number of securities to display, based on the specified field value.
         2. Select a field from the drop-down list whose value will be evaluated as the basis for display.

         The default settings dictate the display of the top 50 individual holdings by “Market Value”.

      3. Select the “Additional Inclusions” check box to base holdings display on a holding’s specified “Category”, “Date” (expiration, maturity, reset or yield), “Investment Type”, “Issuer Master” and/or “Security/Investment Master”.

         1. Click the “Add” button at lower-left of the grid to view/edit settings.

            The “Add Inclusion Type” dialogue displays.

            1. Select an “Inclusion Type” from the corresponding drop-down list.
            2. Based on the selected type, provide appropriate values for the remainder of fields that display on the dialogue.
            3. Select the “Don’t count in Top ‘N’” check box if you wish to exclude securities matching the inclusion rule’s criteria from the Top ‘N’ holdings.

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

      4. Select the “Percentage” check box to base holdings display on the percentage of a security grouping’s value (e.g., “Market Value”, “Cost”, etc.) with respect to either “Net Assets” or “Total Investments”.

         1. Select a field from the first drop-down list that represents the field by which to group the holdings.
         2. Select a field from the second drop-down list that represents the value to consider for the grouping.

         3. Specify a value in the spinner control that represents the percentage of either “Net Assets” or “Total Investments”.

            • The minimum value of the spinner is “1.00”.
            • The maximum value of the spinner is “100.00”.
            • The spinner allows for two decimal places to be specified.

            • Absolute value is considered in determining if the percentage of any given holdings grouping is greater than the specified spinner value.

              “5.25%” and “(5.25%)” are both greater than 5.00% of Net Assets. Therefore, in both of these cases the securities would be broken out from the “Other Securities” section of the statement.

         4. Select a field from the third drop-down list that represents the value against which the comparison will be made (i.e., “Net Assets” or “Total Investments”).
         5. Select the “Do not aggregate long and short positions” check box if you wish to prevent the aggregation of long and short position holdings into the same grouping.
         6. Select the “Combine Fully Collateralized Repos for Percentage” check box if you wish to aggregate all holdings that are marked as “Fully Collateralized Repo” via the “Fund Holdings” page, group them together and display all of them on a Condensed statement if they exceed the specified percentage threshold.

         The default settings dictate the display of individual holdings when grouped by “Issuer” whose “Market Value” is greater than or equal to 1.00% of “Net Assets”.

      5. Populate the “Other Securities Caption” grid to specify the desired caption, per language, for the “Other Securities” line item based on the number of securities contained therein.

         • When the “Other Securities” statement item contains a single record the specified “Single Security Caption” text will be returned in project preview and output.

           • The default value for the column is “Other Security”.

         • When the “Other Securities” statement item contains multiple records the specified “Multiple Securities Caption” text will be returned in project preview and output.

           • The default value for the column is “Other Securities”.
           • When the “Other Securities” item contains multiple records, but these are combined into a single record for output purposes due to aggregation settings, the specified “Single Security Caption” text will be returned in project preview and output.

   6. For statements of type “Full” or “Condensed/Summary”, use the “Aggregate” tab to specify settings to be used as aggregation logic is applied for a given statement line item.

      

      1. Select the “Enable aggregation” check box.

      2. Add one or more fields to the grid using the “Add” button at lower-left of the grid.

         • Use the “Remove” button to delete fields from the grid.
         • Use the “Move item up” or “Move item down” buttons   to adjust the order of fields in the grid, as necessary.
      3. Select the “Recalculate percentages based on aggregated ‘Market Value Calculation Basis’” check box at lower-left of the tab if you wish to recalculate percentages based on the aggregated “Market Value Calculation Basis” specified.
      4. Select the “Ignore footnotes when evaluating Holdings to aggregate” check box at lower-left of the tab if you wish to ignore the symbols of any footnotes attached to holdings’ fields when performing aggregation.
      5. Select the “Ignore Top ‘N’ securities when evaluating Holdings to aggregate” check box at lower-left of the tab if you wish to ignore any securities that are among the specified top “n” securities when performing aggregation.

      • A maximum of 10 aggregation levels can be specified; the “Add” button will be disabled once 10 rows have been added to the grid.

      • The “Aggregated Securities” record will display and be considered for sorting purposes along with all other “Security” records.

        • For sorting by numeric-type fields, the aggregated value of all the securities in the aggregated row for each numeric field will be used for sorting purposes.

          • This value is based on the footed value that the system has calculated based on the “Calculations” tab settings.
        • For sorting by text-type fields, the field value of the first security that the sorting engine encounters within the group of aggregated securities will be used for sorting purposes.

        • For sorting by date/time-type fields, the field value of the first security that the sorting engine encounters within the group of aggregated securities will be used for sorting purposes.

          • When sorting aggregated and non-aggregated securities by date/time, the group will be sorted based on the “MinDate” of the former and the “Date” of the latter.

      • Where both stacking and aggregation settings are specified within the same template, the settings on each of the various tabs will be applied in a specific order.

        • For SOI’s of type “Full” or “Categories”:

          1. Aggregate
          2. Stack
          3. Sorting

        • For SOI’s of type “Condensed”:

          1. Condensed
          2. Aggregate

          3. Stack

             • Securities that display in the “Other Securities” row will not be included in the stacking.
             • The “Other Securities” row will not be included in the stacking.
          4. Sorting

   7. For statements of type “Categories”, use the “Aggregate” tab to specify aggregation logic on the parent of an innermost category or group, based on top “n” settings or percentage value.

      1. Select the “Aggregate Top ‘N’ Categories” check box to enable this functionality and to apply associated settings for category evaluation.

         

         1. Specify the top “n” categories (any value between “1” and “100”) for inclusion in the aggregation and the data point by which to aggregate using the corresponding spinner control and drop-down list.

      2. Select the “Aggregate Categories based on Percentage” check box to enable this functionality and to apply associated settings for category evaluation.

         

         1. Specify the percentage of “Net Assets” or “Total Investments” (any value between “0.01” and “100.00”) for inclusion in the aggregation using the corresponding spinner control and drop-down list.

      You can select only one of the two options for any given statement node.

   8. For statements of type “Full” or “Condensed/Summary”, use the “Stack” tab to specify the number of levels deep by which to stack.

      

      1. Select the “Enable Stacking” check box.

      2. Add one or more fields to the grid using the “Add” button at lower-left of the grid.

         • Use the “Remove” button to delete fields from the grid.
         • Use the “Move item up” or “Move item down” buttons   to adjust the order of fields in the grid, as necessary.
      3. Select the “Ignore footnotes when evaluating holdings to stack” check box at lower-left of the tab if you wish to ignore the symbols of any footnotes attached to holdings’ fields when performing stacking.
      4. Select the “Enable single security roll-up (if only one security in the innermost stack level)” check box at lower-left of the tab to cause the resulting rolled-up line item to display inside the innermost stack level.

      • The “Stack” tab is disabled for statements of type “Categories”.
      • All stacking row types are supported in project preview and output once they are mapped on the “Portfolio Statement Template Output Settings” page.
      • A maximum of 5 stack levels can be specified; the “Add” button will be disabled once 5 rows have been added to the grid.

      • Where both stacking and aggregation settings are specified within the same template, the settings on each of the various tabs will be applied in a specific order.

        • For SOI’s of type “Full” or “Categories”:

          1. Aggregate
          2. Stack
          3. Sorting

        • For SOI’s of type “Condensed”:

          1. Condensed
          2. Aggregate

          3. Stack

             • Securities that display in the “Other Securities” row will not be included in the stacking.
             • The “Other Securities” row will not be included in the stacking.
          4. Sorting
   9. For information on how to add a category, see the “Defining Portfolio Statement Template Output Settings” task.
   10. For information on how to add a column header, see the “Defining Portfolio Statement Template Output Settings” task.
   11. For information on how to add a formula, see the “Defining Portfolio Statement Template Output Settings” task.
   12. For information on how to add a legend, see the “Defining Portfolio Statement Template Output Settings” task.
   13. For information on how to add a net assets line, see the “Defining Portfolio Statement Template Output Settings” task.
   14. For information on how to add an other assets line, see the “Defining Portfolio Statement Template Output Settings” task.
   15. For information on how to add a text element, see the “Defining Portfolio Statement Template Output Settings” task.
   16. For information on how to add a total investments line, see the “Defining Portfolio Statement Template Output Settings” task.

7. Add one or more languages in association with the template via the “Languages” tab.

   1. Click the “Add” button at lower-left of the “Settings” section to add a language.

      The “Add Language” dialogue displays.

      

      1. Click the “Language” drop-down list to specify the desired language.

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

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

1. Expand the ArcFiling “Structure Templates” 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 “Structure Templates” menu to view available items.

2. Expand the ArcReporting “Structure Templates” 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 “Structure Templates” menu to view available items.

3. Click the “Portfolio Statement Templates” item.

   The “Portfolio Statement Templates” page displays.

   

4. Select the desired item from the “Listing” pane at left of the page.

5. Review and edit information for the item in the “Detail” pane at right of the page.

6. Click the “Save” button at lower-right of the page if any updates were made.

1. Expand the ArcFiling “Structure Templates” 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 “Structure Templates” menu to view available items.

2. Expand the ArcReporting “Structure Templates” 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 “Structure Templates” menu to view available items.

3. Click the “Portfolio Statement Templates” item.

   The “Portfolio Statement Templates” page displays.

   

4. Select the desired item from the “Listing” pane at left of the page.

5. Click the “Export portfolio statement template” button at lower-right of the page.

6. Click the “Yes” button on the confirmation dialogue that displays.

   Once the output request has been submitted to the document processing service, a Please Note message displays to indicate that you may go to the Output Queue to check the request’s status.

7. Click the “OK” button.

8. Click the “Output Queue” button at upper-right of the browser window, select the row in the grid that represents your export and save the file to your local or network drive.

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.

   The “Output Queue” pane displays.

   

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

   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” link at right of the document you wish to view to open or save it.

   The “File Download” dialogue displays.

   

   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” link at right of the document whose output message you wish to view.

   The “Message” dialogue displays.

   

   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” link at right of a document if you simply wish to save it.

   The “Save Output Queue” dialogue displays.

   

   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.