Alternative Investment Product
AIP Introducing Broker Dealer & New AIP Production Cycle Time Enhancements
- 2015
Milestone 1 / PSE Migration – Effective July 31, 2015 (The new coding will be implemented after the 7:00pm EOD Cycle on July 30, 2015) - (Eastern Time)
Milestone 2 / Production Migration – Effective October 23, 2015 (The new coding will be implemented after the 7:00pm EOD Cycle on October 22) - (Eastern Time)
Table of Contents
BR-1 Order Enhancements
BR-1.1 Rename “Introducing Broker Dealer Name / Registered Investment Advisor Firm Name” and change the field requirement
BR-1.2 Change the condition on the existing “RIA/RR Indicator” field
BR-1.3 Rename the field “Account Representative Name” and change the field requirement
BR-1.4 Rename the field “Account Representative Number” and change the field requirement
BR-1.5 Change the field requirement for “Branch ID Number”
BR-1.6 Add a new field – “Trading Model”
BR-1.7 Add a New field and Values– “AIP Firm Role”
BR-1.8 Add existing field – “Firm CRD Number”
BR-1.9 Add a new field – “Individual CRD/IARD Number”
BR-1.10 Change Conditions on Existing “Erisa” Fields
BR-1.11 Add new “NAV Account Indicator” and Values to existing filler
BR-2 Order with Registration Enhancements
BR-2.1 Rename “Introducing Broker Dealer Name / Registered Investment Advisor Firm Name” and change the field requirement
BR-2.2 Rename the field “Account Representative Name” and change the field requirement
BR-2.3 Rename the field “Account Representative Number” and change the field requirement
BR-2.4 Change the field requirement for “Branch ID Number”
BR-2.5 Add a new field – “Trading Model”
BR-2.6 Add a new field – “AIP Firm Role”
BR-2.7 Rename “CRD Number” and change the field requirement
BR-2.8 Add a new field – “Individual CRD/IARD Number”
BR-2.9 Rename and add new values to existing “NAV Account Indicator” field
BR-3 Order Correction-Confirmation Enhancements
BR-3.1 Add the new field – “Introducing Broker Dealer Firm Name / Registered Investment Advisor Firm Name”
BR-3.2 Change the condition on the existing “RIA/RR Indicator” field
BR-3.3 Rename the “Account Representative Name” and add new validation rules
BR-3.4 Rename the “Account Representative Number” and add validation rules
BR-3.5 Add a new field “Branch ID Number”
BR-3.6 Add a new field – “Trading Model”
BR-3.7 Add a new field “AIP Firm Role”
BR-3.8 Add an existing field – “Firm CRD Number”
BR-3.9 Add a new field – “Individual CRD/IARD Number”
BR-3.10 Change conditions on existing “Erisa” fields
BR-3.11 Add new “NAV Account Indicator” and values to existing filler
BR-4 Order Acknowledgement/Reject/Exit Enhancements
BR-4.1 Change conditions on existing “Erisa” fields
BR-5 Account Registration & Maintenance Enhancements
BR-5.1 Add new validation rules to the existing “RIA/RR Indicator” field
BR-5.2 Rename “Introducing Broker Dealer Name/Registered Investment Advisor Firm Name” and change the field requirements
BR-5.3 Rename the field “Account Representative Name” and change the field requirement
BR-5.4 Rename the field “Account Representative Number” and change the field requirement
BR-5.5 Change the field requirement for “Branch ID Number”
BR-5.6 Rename “CRD Number” and change the field requirement
BR-5.7 Add a new field – “Individual CRD/IARD Number”
BR-5.8 Add a new field – “Trading Model”
BR-5.9 Add a new field – “AIP Firm Role”
BR-5.10 Rename and add additional values to existing “NAV Account Indicator” field name
BR-6 Exchange-Switch Field Rename
BR-6.1 Rename the field “Account Representative Name”
BR-6.2 Rename the field “Account Representative Number”
BR-7 Commission Field Rename
BR-7.1 Rename the field “Account Representative Number”
BR-7.2 Rename “Name Indicator 1” Code List Value
BR-7.3 Rename “Name Indicator 2” Code List Value
BR-7.4 Rename existing “Related Control Number” to the new field name “Control Number”
BR-7.5 Add a new field – “Related Control Number”
BR-7.6 Change the Existing “Transaction Code” Field Name to Filler
BR-8 Account Transfer Rename
BR-8.1 Rename “Introducing Broker Dealer Name/Registered Investment Advisor Firm Name”
BR-8.2 Rename “Receiving Broker Dealer Name/Registered Investment Advisor Firm Name”
BR-9 Account Transfer Acknowledgement-Reject-Exit Rename
BR-9.1 Rename “Introducing Broker Dealer Name/Registered Investment Advisor Firm Name”
BR-9.2 Rename “Receiving Broker Dealer Name/Registered Investment Advisor Firm Name”
BR-10 Account Transfer Confirmation-Correction Rename
BR-10.1 Rename “Introducing Broker Dealer Name/Registered Investment Advisor Firm Name”
BR-10.2 Rename “Receiving Broker Dealer Name/Registered Investment Advisor Firm Name”
BR-11 Reject Codes Additions and Description Changes
BR-11.1 Add New “NSCC Reject Reason Codes & Descriptions”
BR-11.2 Rename Existing “NSCC Reject Reason Codes & Descriptions”
BR-11.3 Rename Existing “Firm/Fund Reject Reason Codes & Descriptions”
BR-11.4 Add New “Firm/Fund Reject Reason Codes & Descriptions”
BR-12 New Output Processing Cycle – Production Only
BR-12.1 Add a New 6:10am Output Processing Cycle
BR-1 Order Enhancements
BR-1.1 Rename “Introducing Broker Dealer Name / Registered Investment Advisor Firm Name” and change the field requirement
- Rename “Introducing Broker Dealer Name / Registered Investment Advisor Firm Name” to “Introducing Broker Dealer Firm Name / Registered Investment Advisor Firm Name”
- Change the field requirement from Optional to Optional Conditional.
- Add Conditional requirement - Required if Trading Model = 2
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeNew Field Name
Introducing Broker Dealer Name / Registered Investment Advisor Firm Name / 429 / 463 / 35 / A/N / O / Special characters are allowed / 0244
Existing Field Name
Introducing Broker Dealer Firm Name / Registered Investment Advisor Firm Name / 429 / 463 / 35 / A/N / OC / Required if Trading Model = 2
Special characters are allowed / 0244
BR-1.2 Change the condition on the existing “RIA/RR Indicator” field
- Change the field requirement from Optional to Optional Conditional
- Add Conditional requirement - Required if Trading Model = 2
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
RIA/RR Indicator / 428 / 428 / 1 / A/N / O / 0031
New Field Name
RIA/RR Indicator / 428 / 428 / 1 / A/N / OC / Required if Trading Model = 2
1 = Registered Investment Advisor
2 = Registered Representative / 0031
BR-1.3 Rename the field “Account Representative Name” and change the field requirement
- Rename the “Account Representative Name” field to ” Account Representative/Advisor Name”
- Change the field requirement from Optional to Optional Conditional
- Add Conditional requirement - Required if the following fields are provided: Trading Model = 2 and RIA/RR Indicator = 2
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Account Representative Name / 464 / 478 / 15 / A/N / O / Special characters are allowed / 0245
New Field Name
Account Representative/Advisor Name / 464 / 478 / 15 / A/N / OC / Required if the following fields are provided:
Trading Model = 2
RIA/RR Indicator = 2
Special characters are allowed / 0245
BR-1.4 Rename the field “Account Representative Number” and change the field requirement
- Rename the “Account Representative Number” field to “Account Representative/Advisor Number”
- Change the field requirement from Optional to Optional Conditional
- Add Conditional requirement - Required if the following fields are provided: Trading Model = 2, RIA/RR Indicator = 2 and Individual CRD/IARD Number is not populated
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Account Representative Number / 479 / 487 / 9 / A/N / O / Special characters are allowed / 0032
New Field Name
Account Representative/Advisor Number / 479 / 487 / 9 / A/N / OC / Required if the following fields are provided:
Trading Model = 2
RIA/RR Indicator = 2 and
Individual CRD/IARD Number is not populated.
Special characters are allowed / 0032
BR-1.5 Change the field requirement for “Branch ID Number”
- Change the field requirement from Optional to Optional Conditional
- Add Conditional requirement – Required if the following fields are provided:
Trading Model = 2 and RIA/RR Indicator = 2
- Special Characters are allowed
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Branch ID Number / 488 / 496 / 9 / A/N / O / Special characters are allowed / 0033
New Field Name
Branch ID Number / 488 / 496 / 9 / A/N / OC / Required if the following fields are provided: Trading Model = 2 and RIA/RR Indicator = 2
Special characters are allowed / 0033
BR-1.6 Add a new field – “Trading Model”
- The Trading Model field will be added replacing a filler field
- This will be a Required field
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Filler / 713 / 718 / 6 / A/N / R / space
New Field Name
Trading Model / 713 / 713 / 1 / A/N / R / 1 = Non-clearing Trade
2 = Clearing Trade / 0161
BR-1.7 Add a New field and Values– “AIP Firm Role”
- The AIP Firm Role field will be added replacing a filler field
- This will be an Optional Conditional field
- Add Conditional requirement - Required if Trading Model = 2
- Add new values
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Filler / 713 / 718 / 6 / A/N / R / space
New Field Name
AIP Firm Role / 714 / 714 / 1 / A/N / OC / Required if Trading Model = 2
1 = Custodian
2 = Broker
3 = Custodian & Broker / 0162
Filler / 715 / 718 / 4 / A/N / R / space
BR-1.8 Add existing field – “Firm CRD Number”
- The Firm CRD Number field will be added to the Order record at the end of the record
- This new Firm CRD Number will be a Numeric Optional Conditional field
- Add Conditional requirement - Required if Trading Model = 2
- Add requirement - This field must be10 bytes in length; if less than 10 bytes, it must be padded with leading zeros (zeros are allowed)
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeNew Field Name
Firm CRD Number / 944 / 953 / 10 / N / OC / Required if Trading Model = 2
If less than 10 bytes, pad with leading zero.
Zeros are allowed. / 0335
BR-1.9 Add a new field – “Individual CRD/IARD Number”
- The Individual CRD/IARD Number field will be added to the Order record at the end of the record after new field “Firm CRD Number”
- The Individual CRD/IARD Number will be a Numeric Optional Conditional field
- Add Conditional requirement - Required if the flowing fields are provided: Trading Model = 2, RIA/RR Indicator = 2 and Account Representative/Advisor Number is not populated
- Add requirement - This field must be 10 bytes in length; if less than 10 bytes, it must be padded with leading zeros
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeNew Field Name
Individual CRD/IARD Number / 954 / 963 / 10 / N / OC / Required if the following fields are provided:
Trading Model = 2
RIA/RR Indicator = 2 and
Account Representative/Advisor Number is not populated
If less than 10 bytes, pad with leading zeros.
Zeros are allowed. / 0163
BR-1.10 Change Conditions on Existing “Erisa”Fields
During the 2014 AIP Round Table, it was agreed upon by the members to change the Erisa fields from required to optional on the Order Records. The Erisa fields should only be ‘required’ on the Account Registration Records
- Change Condition from Required to Optional on existing field
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Erisa Eligible Indicator / 805 / 805 / 1 / A/N / R / 0 = No
1 = Yes / 0397
New Field Name
Erisa Eligible Indicator / 805 / 805 / 1 / A/N / O / 0 = No
1 = Yes / 0397
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject Code
Existing Field Name
Erisa Percentage / 806 / 811 / 6 / N / R / 999.999 / 0398
New Field Name
Erisa Percentage / 806 / 811 / 6 / N / O / 999.999 / 0398
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject Code
Existing Field Name
Erisa Pre-Certified Indicator / 812 / 812 / 1 / A/N / R / 0 = No
1 = Yes / 0399
New Field Name
Erisa Pre-Certified Indicator / 812 / 812 / 1 / A/N / O / 0 = No
1 = Yes / 0399
BR-1.11 Add new“NAV Account Indicator” and Values to existing filler
Rename and add additional values to clearly identify the reason why trades are being placed at NAV
- Add new existing field name called ‘NAV Account Indicator’ to record
- Add new values – (See table below)
- Use existing NAV Account Indicator Reject Code & Reject Message (0104 – NAV Account Indicator invalid/missing)
- The Data Dictionary has been updated
Order (001, 002, 032)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeNew Field Name
NAV Account Indicator / 715 / 715 / 1 / A/N / O / 0 = Other
1 = NAV Transfer
2 = Repurchase
3= Firm Employee
4= Sponsor Employee
5 = Wrap Account
6 = RIA / 0104
Filler / 716 / 718 / 3 / A/N / R / Space
BR-2 Order with Registration Enhancements
BR-2.1 Rename “Introducing Broker Dealer Name / Registered Investment Advisor Firm Name” and change the field requirement
- Rename “Introducing Broker Dealer Name / Registered Investment Advisor Firm Name” to “Introducing Broker Dealer Firm Name / Registered Investment Advisor Firm Name
- Change the field requirement from Optional to Optional Conditional
- Add Conditional requirement - Required if Trading Model = 2
- The Data Dictionary has been updated
Order with Registration (011, 012, 043)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Introducing Broker Dealer Name / Registered Investment Advisor Firm Name / 429 / 463 / 35 / A/N / O / Special characters are allowed / 0244
New Field Name
Introducing Broker Dealer Firm Name / Registered Investment Advisor Firm Name / 429 / 463 / 35 / A/N / OC / Required if Trading Model = 2
Special characters are allowed / 0244
BR-2.2 Rename the field “Account Representative Name” and change the field requirement
- Rename the “Account Representative Name” field to ” Account Representative/Advisor Name”
- Change the field requirement from Optional to Optional Conditional
- Add Conditional requirement – Required if Trading Model = 2 and RIA/RR Indicator = 2
- The Data Dictionary has been updated
Order with Registration (011, 012, 043)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Account Representative Name / 464 / 478 / 15 / A/N / O / Special characters are allowed / 0245
New Field Name
Account Representative/Advisor Name / 464 / 478 / 15 / A/N / OC / Required if the following fields are provided:
Trading Model = 2
RIA/RR Indicator = 2
Special characters are allowed / 0245
BR-2.3 Rename the field “Account Representative Number” and change the field requirement
- Rename the “Account Representative Number” field to “Account Representative/Advisor Number”
- Change the field requirement from Optional to Optional Conditional
- Add Conditional requirement – Required if the following fields are provided: Trading Model = 2, RIA/RR Indicator = 2 and Individual CRD/IARD Number is not populated
- The Data Dictionary has been updated
Order with Registration (011, 012, 043)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Account Representative Number / 479 / 487 / 9 / A/N / O / Special characters are allowed / 0032
New Field Name
Account Representative/Advisor Number / 479 / 487 / 9 / A/N / OC / Required if the following fields are provided:
Trading Model = 2
RIA/RR Indicator = 2 and
Individual CRD/IARD Number is not populated
Special characters are allowed / 0032
BR-2.4 Change the field requirement for “Branch ID Number”
- Change the field requirement from Optional to Optional Conditional
- Add Conditional requirement - Required if the following fields are provided: Trading Model = 2, RIA/RR Indicator = 2
- The Data Dictionary has been updated
Order with Registration (011, 012, 043)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Branch ID Number / 488 / 496 / 9 / A/N / O / Special characters are allowed / 0033
New Field Name
Branch ID Number / 488 / 496 / 9 / A/N / OC / Required if the following fields are provided:
Trading Model = 2
RIA/RR Indicator = 2
Special characters are allowed / 0033
BR-2.5 Add a new field – “Trading Model”
- The Trading Model field will be added replacing a filler field
- This will be a Required field
- Add new values for the Trading Model
- The Data Dictionary has been updated
Order with Registration (011, 012, 043)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Filler / 713 / 718 / 6 / A/N / R / space
New Field Name
Trading Model / 713 / 713 / 1 / A/N / R / 1 = Non-clearing Trade
2 = Clearing Trade / 0161
BR-2.6 Add a new field – “AIP Firm Role”
- The AIP Firm Role field will be added replacing a filler field
- This will be an Optional Conditional field
- The Data Dictionary has been updated
Order with Registration (011, 012, 043)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
Filler / 713 / 718 / 6 / A/N / R / space
New Field Name
AIP Firm Role / 714 / 714 / 1 / A/N / OC / Required if the Trading Model = 2
1 = Custodian
2 = Broker
3 = Custodian & Broker / 0162
Filler / 715 / 718 / 4 / A/N / R / space
BR-2.7 Rename “CRD Number” and change the field requirement
- Rename “CRD Number” to “Firm CRD Number”
- Type should be A/N
- Add Conditional requirement - Required if Trading Model = 2
- The Data Dictionary has been updated
Order with Registration (011, 012, 043)
Field Name / Start / End / Length / Type / Opt/Req / Values / Reject CodeExisting Field Name
CRD Number / 759 / 768 / 10 / A/N / O / 0335
New Field Name
Firm CRD Number / 759 / 768 / 10 / N / OC / Required if Trading Model = 2
If less than 10 bytes, pad with leading zeros.
Zeros are allowed. / 0335
BR-2.8 Add a new field – “Individual CRD/IARD Number”
- The Individual CRD/IARD Number field will be added replacing a filler field
- This will be a Numeric Optional Conditional field
- Add Conditional requirement - Required if the following fields are provided: Trading Model = 2, RIA/RR Indicator = 2 and Account Representative/Advisor Number is not populated
- Add requirement - This field must be 10 bytes in length; if less than 10 bytes, it must be padded with leading zeros
- The Data Dictionary has been updated
Order with Registration (011, 012, 043)