Alternative Investment Product

AIP Industry Enhancements & Internal Account Transfer Functionality

  • 2014

Milestone 1 / PSE Deploy – February 26, 2015 (The new coding will be implemented after the 7:00pm ET Cycle)
Milestone 2 / Production Deploy – March 26, 2015 (The new coding will be implemented after the 7:00pm ET Cycle)

1Contents

1BR–1 Security General Profile Enhancements

Description – Change Condition on Existing Field

Description – Add New Value to Existing Fields

2BR–1 Security Announcement Enhancements

Description – Rename Existing Announcement Type Value (18)

Description – Rename Existing Field Name

3BR–1 Position Enhancements

Description – Add New Field and Condition

4BR–1 Activity & Distribution Enhancements

Description – Add New Value to Existing Field

Description – Add New Field and Condition

Description – Rename Existing Field

5BR–1 Exchange Enhancements

Description – Add New Value to Existing Field and Change Condition

Description – Delete Field and Replace with Filler

6BR–1 Valuation Enhancements

Description – Delete Fields and Replace with Filler

Description – Change Condition on Existing Field

Description – Expand the length of Existing Field

7BR–1 Order Enhancements

Description – Add New Value to Existing Field and Change Condition

Description – Rename Existing Field

8BR–1 Order w/Registration Enhancements

Description – Add New Value to Existing Field and Change Condition

Description – Rename Existing Field

9BR–1 Confirmation/Correction/Contract Note Enhancements

Description – Add New Value to Existing Field and Change Condition

Description – Rename Existing Field

10BR–1 Account Registration/Maintenance Enhancements

Description – Delete Field and Replace with Filler

Description – Change to Filler on Existing Field

Description – Rename Existing Field

Description – Change Validation Rules on Existing Field

Description – Rename Existing Field & Add New Values

11BR–1 Account Registration-Maintenance-Activity Acknowledgement/Reject Enhancements

Description – Delete Field and Replace with Filler

Description – Consolidate Filler Space

12BR–1 Order Acknowledgement/Reject/Exit Enhancements

Description – Delete Fields and Replace with Filler

Description – Consolidate Filler Space

13BR–2 Account Transfer Enhancements

Description – New Internal Account Transfer Records

14BR–2 Fund/Firm Reject Reason Code Enhancements

Description – Non-Programming Changes to Data Dictionary

15BR–2 Data Dictionary Changes

Description – Non-Programming Changes to Data Dictionary

1BR–1 Security General Profile Enhancements

Description – Change Condition on Existing Field

During the AIP Round Table at Ameriprise in 2013, the group agreed that the ROA field should be changed to ‘optional’, since it is not used for Non-Traded REITS.

Impacted Records:

  • Security General Profile – 061

Proposed Changes:

Change Condition from ‘Required’ to ‘Optional’

Impacted Fields:

  • ROA Eligible
  • LOI Eligible

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
ROA Eligible / 613 / 613 / 1 / A/N / 0 = No
1 = Yes
2 = N/A / R / 0215

New – Change Condition from ‘Required’ to ‘Optional’

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
ROA Eligible / 613 / 613 / 1 / A/N / 0 = No
1 = Yes
2 = N/A / O / 0215

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
LOI Eligible / 612 / 612 / 1 / A/N / 0 = No
1 = Yes
2 = N/A / R / 0215

New – Change Condition from ‘Required’ to ‘Optional’

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
LOI Eligible / 612 / 612 / 1 / A/N / 0 = No
1 = Yes
2 = N/A / O / 0215

Description – Add New Value to Existing Fields

During the AIP Round Table at Ameriprise in 2013, the group agreed that a new value called 'Placement Fee' should be added to the Load Type Indicator.

AIP has added a new value to the Ownership Structure Indicator called ‘Delaware Statutory Trust’.

Impacted Records:

  • Security General Profile – 061

Proposed Changes:

Add new value to existing fields

Impacted Fields:

  • Load Type Indicator
  • Ownership Structure Indicator

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Load Type / 353 / 353 / 1 / A/N / 1 = Level Load
2 = Back-End Load
3 = Front-End Load
4 = Finder’s Fee
5 = Other
6 = Medium
7 = Hybrid
8 = N/A / R / 0039

New – Add New Value

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Load Type / 353 / 353 / 1 / A/N / 1 = Level Load
2 = Back-End Load
3 = Front-End Load
4 = Finder’s Fee
5 = Other
6 = Medium
7 = Hybrid
8 = N/A
9 = Placement Fee / R / 0039

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Ownership Structure / 178 / 179 / 2 / A/N / 39 = Massachusetts Business Trust
40 = Maryland Real Estate Investment Trust
41 = Cayman Exempt Limited Partnership
42 = BVI Company Limited by Shares / R / 0314

New – Add New Value

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Ownership Structure / 178 / 179 / 2 / A/N / 39 = Massachusetts Business Trust
40 = Maryland Real Estate Investment Trust
41 = Cayman Exempt Limited Partnership
42 = BVI Company Limited by Shares
43 = Delaware Statutory Trust / R / 0314

2BR–1 Security Announcement Enhancements

Description – Rename Existing Announcement Type Value (18)

Change the description for the 'Recurring Exchange' Announcement Type, since it is not included in the order process. During the Round Table the group agreed with the request to change the description to reflect 'Internal Transfer'.

Impacted Records:

  • Security Announcement – 062

Proposed Changes:

Rename existing description for Announcement Type (18)

Impacted Announcement Type Value:

  • 18 = Recurring Exchange

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Announcement Type / 136 / 137 / 2 / A/N / 16 = Recurring Subscription
17 = Recurring Redemption
18 = Recurring Exchange / R / 0171

New – Rename Existing Value Description

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Announcement Type / 136 / 137 / 2 / A/N / 16 = Recurring Subscription
17 = Recurring Redemption
18 = Internal Transfer / R / 0171

Description – Rename Existing Field Name

During the AIP Broker Dealer Roundtable at Ameriprise, the group has decided that DTCC should rename the Documentation Date to reflect Documentation Date/Expiration Date

Impacted Records:

  • Security Announcement – 062

Proposed Changes:

Rename existing field name

Impacted Field:

  • Documentation Date

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Documentation Date / 217 / 224 / 8 / N / mmddccyy / O / 0311

New – Rename Existing Field Name

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Documentation Date / Expiration Date / 217 / 224 / 8 / N / mmddccyy / O / 0311

3BR–1 Position Enhancements

Description – Add New Field and Condition

During the AIP Round Table at Ameriprise in 2013, the group agreed that a new field should be added to identify the effective date of the NAV.

The NAV effective date is the actual date of the NAV (price) and NOT the submission date.

Impacted Records:

  • Position – 052

Proposed Changes:

Add new field, description, condition and reject code/message to existing ‘filler’ space

New Field:

  • NAV Effective Date (Backdating is Allowed)

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Filler / 172 / 179 / 8 / A/N / mmddccyy / R

New – Add New Field, Condition and Reject Code/Message

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
NAV Effective Date / 172 / 179 / 8 / N / mmddccyy
(Backdating is Allowed) / O / 0136

4BR–1 Activity & Distribution Enhancements

Description – Add New Value to Existing Field

During the AIP Round Table at Ameriprise in 2013, the group agreed that a new value called 'Placement Fee' should be added to the Load Type Indicator.

Impacted Records:

  • Activity & Distribution – 050
  • Activity Confirmation - 056

Proposed Changes:

Add new value to existing field

Impacted Fields:

  • Load Type Indicator

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Load Type Indicator / 281 / 281 / 1 / A/N / 1 = Level Load
2 = Back-End Load
3 = Front-End Load
4 = Finder’s Fee
5 = Other
6 = Medium
7 = Hybrid
8 = N/A / O / 0039

New – Add New Value

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Load Type Indicator / 281 / 281 / 1 / A/N / 1 = Level Load
2 = Back-End Load
3 = Front-End Load
4 = Finder’s Fee
5 = Other
6 = Medium
7 = Hybrid
8 = N/A
9 = Placement Fee / O / 0039

Description – Add New Field and Condition

During the AIP Broker Dealer Roundtable at CNL (March 7, 2014), a request was made to add a new field called ‘Total Distribution Amount’. This will allow the funds to have the ability to settle the withholding amount, report the total distribution and the penalty withholding amount on a single record via AIP.

The new field called ‘Total Distribution Amount’ will be ‘required’ for Activity Type 63 = Penalty Withholding for Reinvested Accounts. This will ensure that the total distribution amount is populated for Reinvested Accounts that are subject to penalty withholdings.

Impacted Records:

  • Activity & Distribution – 050
  • Activity Confirmation - 056

Proposed Changes:

Add new field, description, condition and reject code/message

New Field:

  • Total Distribution Amount

New – Add New Field, Condition and Reject Code/Message

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Total Distribution Amount / 725 / 740 / 16 / N / 99999999999999.99
Required for Activity Type 63 = Penalty Withholding for Reinvested Accounts / OC / 0140

Description – Rename Existing Field

When most people think of a value they think of a dollar ($) amount and NOT share quantity. DTCC will rename the existing field called ‘Value Confirm Shares’ to 'Confirm Share Quantity’, for clarity.

Impacted Records:

  • Activity & Distribution – 050
  • Activity Confirmation - 056

Proposed Changes:

Rename existing field

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Value Confirm Shares / 334 / 347 / 14 / N / 99999999.999999 / O / 0047

New – Rename Existing Field Name:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Confirm Share Quantity / 334 / 347 / 14 / N / 99999999.999999 / O / 0047

5BR–1 Exchange Enhancements

Description – Add New Value to Existing Fieldand Change Condition

During the AIP Round Table at Ameriprise in 2013, the group agreed that a new value called 'Placement Fee' should be added to the Load Type Indicator and the condition should be changed to ‘optional’

Impacted Records:

  • Exchange
  • Firm Exchange – 015
  • Fund Exchange - 016
  • Fund Confirmation of Exchange - 018

Proposed Changes:

Add new value to existing fields and change condition from ‘required’ to ‘optional’

Impacted Fields:

  • Load Type Indicator

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Load Type Indicator / 725 / 725 / 1 / A/N / 1 = Level Load
2 = Back-End Load
3 = Front-End Load
4 = Finder’s Fee
5 = Other
6 = Medium
7 = Hybrid
8 = N/A / R / 0039

New – Add New Value and Change Condition from ‘Required’ to ‘Optional’

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Load Type Indicator / 725 / 725 / 1 / A/N / 1 = Level Load
2 = Back-End Load
3 = Front-End Load
4 = Finder’s Fee
5 = Other
6 = Medium
7 = Hybrid
8 = N/A
9 = Placement Fee / O / 0039

Description – Delete Field and Replace with Filler

DTCC has determined that the Settlement Date Override Indicator field does not belong on the exchange record and should be removed. This field will be changed to ‘filler’ for future usage.

Impacted Records:

  • Exchange
  • Firm Exchange – 015
  • Fund Exchange - 016
  • Fund Confirmation of Exchange - 018

Proposed Changes:

Delete Existing Field and replace with ‘filler’ for future usage.

Impacted Field:

  • Settlement Date Override Indicator

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Settlement Date Override Indicator / 131 / 131 / 1 / A/N / 0 = No
1 = Yes / O / 0019

New – Change to Filler

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Filler / 131 / 131 / 1 / A/N / Space / R

6BR–1 Valuation Enhancements

Description – Delete Fields and Replace with Filler

DTCC and the AIP Round Table Committee Members have determined that these fields should be removed from the valuation record. These fields will be replaced with ‘filler’ for future enhancements.

Impacted Records:

  • Valuation – 060

Proposed Changes:

Delete Fields and replace with ‘filler’ for future usage.

Impacted Field:

  • Base Currency
  • Base Currency Price
  • Base Currency Gross Asset Value (GAV)
  • Base Currency Percentage
  • Base Currency Units

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Base Currency / 121 / 123 / 3 / A/N / O / 0122

Existing

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Base Currency Price / 124 / 135 / 12 / N / 999999.999999 / R / 0161

Existing

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Base Currency Gross Asset Value (GAV) / 136 / 151 / 16 / N / 9999999999.999999 / O / 0340

Existing

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Base Currency Percentage / 152 / 157 / 6 / N / 999.999 / R / 0162

Existing

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Base Currency Units / 158 / 167 / 10 / N / 999999.9999 / R / 0163

New – Change to Filler

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Filler / 121 / 167 / 47 / A/N / Space / R

Description – Change Condition on Existing Field

The Reporting Currency Percentage and Reporting Currency Units should be changed from ‘Required’ to ‘Optional’

Impacted Records:

  • Valuation – 060

Proposed Changes:

Change Condition from ‘Required’ to ‘Optional’

Impacted Field:

  • Reporting Currency Percentage
  • Reporting Currency Units

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Reporting Currency Percentage / 199 / 204 / 6 / N / 999.999 / R / 0165

New – Change Condition from ‘Required’ to ‘Optional’

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Reporting Currency Percentage / 199 / 204 / 6 / N / 999.999 / O / 0165

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Reporting Currency Units / 205 / 214 / 10 / N / 999999.9999 / R / 0166

New –Change Condition from ‘Required’ to ‘Optional’

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Reporting Currency Units / 205 / 214 / 10 / N / 999999.9999 / O / 0166

Description – Expand the length of Existing Field

DTCC has expanded the ‘Reporting Currency NAV’ field from 12 bytes to 16 bytes to stay consistent with the other NAV (Net Asset Value) & GAV (Gross Asset Value) fields on the valuation record.

Impacted Records:

  • Valuation – 060

Proposed Changes:

Expand the field length for the Reporting Currency NAV field to stay consistent with the other NAV & GAV fields on the Valuation record. This field will be moved up in the record, since there is room in the previous ‘filler’ space in position 121-163 to accommodate this request.

Impacted Field:

  • Reporting Currency NAV

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Reporting Currency NAV / 171 / 182 / 12 / N / 999999.999999 / R / 0164

New – Expand the Length from 12 to 16 – THIS CHANGE WILL SHIFT THE RECORD by 4 bytes.

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Reporting Currency NAV / 167 / 182 / 16 / N / 9999999999.999999 / R / 0165

Description – Shifting fields on the Valuation record

Due to the expansion of the ‘Reporting Currency NAV’ field from 12 bytes to 16 bytes, it will be required for DTCC to shift the ‘Reporting Currency’ and ‘Reporting Currency NAV’ fields to accommodate the changes.

Impacted Records:

  • Valuation – 060

Proposed Changes:

Position change the Reporting Currency and Reporting Currency NAV fields

Impacted Field:

  • Reporting Currency
  • Reporting Currency NAV

All of the deleted ‘basecurrency’ fields will be included in the ‘filler’

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Filler / 121 / 167 / 47 / A/N / Space / R

Shift Reporting Currency up by 3 bytes (164 – 166)

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Filler / 121 / 163 / 43 / A/N / Space / R

NEW Position:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Reporting Currency / 164 / 166 / 3 / A/N / ISO Compliant / 0022

NEW Position:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Reporting Currency NAV / 167 / 182 / 16 / N / 9999999999.999999 / R / 0164

7BR–1 Order Enhancements

Description – Add New Value to Existing Fieldand Change Condition

During the AIP Round Table at Ameriprise in 2013, the group agreed that a new value called 'Placement Fee' should be added to the Load Type Indicator and the condition should be changed to ‘optional’.

Impacted Records:

  • Firm Order - 001
  • Fund Order - 002
  • Prepaid Firm Order - 032

Proposed Changes:

Add new value to existing fieldand change condition from ‘required’ to ‘optional’

Impacted Field:

  • Load Type Indicator

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Load Type Indicator / 719 / 719 / 1 / A/N / 1 = Level Load
2 = Back-End Load
3 = Front-End Load
4 = Finder’s Fee
5 = Other
6 = Medium
7 = Hybrid
8 = N/A / R / 0039

New – Add New Value and Change Condition from ‘Required’ to ‘Optional’

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Load Type Indicator / 719 / 719 / 1 / A/N / 1 = Level Load
2 = Back-End Load
3 = Front-End Load
4 = Finder’s Fee
5 = Other
6 = Medium
7 = Hybrid
8 = N/A
9 = Placement Fee / O / 0039

Description – Rename Existing Field

During the Introducing Broker Dealer Sub-Committee meeting, it was recommended for DTCC to rename the existing field called ‘Introducing Broker Dealer Name / Registered Investment Advisor Name’. The field name will be enhanced to reflect ‘Introducing Broker Dealer Name / Registered Investment Advisor Firm Name’.

Impacted Records:

  • Firm Order - 001
  • Fund Order - 002
  • Prepaid Firm Order - 032

Proposed Changes:

Rename existing field name

Impacted Fields:

  • Introducing Broker Dealer Name / Registered Investment Advisor Name

Existing:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Introducing Broker Dealer Name / Registered Investment Advisor Name / 429 / 463 / 35 / A/N / O / 0244

New – Rename Existing Field Name:

Field Name / Start / End / Length / Type / Description / Opt/Req / Reject Code
Introducing Broker Dealer Name / Registered Investment Advisor Firm Name / 429 / 463 / 35 / A/N / O / 0244

8BR–1 Order w/Registration Enhancements

Description – Add New Value to Existing Fieldand Change Condition

During the AIP Round Table at Ameriprise in 2013, the group agreed that a new value called 'Placement Fee' should be added to the Load Type Indicator and the condition should be changed to ‘optional’.