APL |
New Account Audit Report |
New Account Audit Report
This enhancement adds two functions READRECONAUDIT and READGALAXYAUDITNEW. The functions will generate two downloadable audit reports. For a given account selection, the reports will show:
- Accounts on APL, but not on the Sponsor or Custodian file
- Accounts on the Sponsor or Custodian file, but not on APL
These two downloadable files will be created for the following account audits:
- Recon Engine (RECONCILE)
- Trade Network (GALAXYAUDITNEW)
- Standalone Functions (INTF^ML^AUDIT and "INTF^MSSB^AUDITSLV)
Data Elements
Data Element |
Account on APL, Not on Sponsor/Custodian |
Account on Sponsor/Custodian, Not on APL |
|---|---|---|
Account ID* |
DTCNO |
Account ID as provided by Sponsor/Custodian |
BWNUM |
BWNUM |
BLANK |
SNAM |
SNAM |
BLANK |
RR |
RR |
BLANK |
NDATE |
NDATE |
BLANK |
AUDDTE (Date Account first appeared on report) |
Derived Date |
Current date |
OPEDT |
OPEDT |
BLANK |
CLODT |
CLODT |
BLANK |
CHGDTE |
CHGDTE |
BLANK |
OLDNUM |
OLDNUM |
BLANK |
LNAME1 |
LNAME1 |
BLANK |
Account Description |
Account Description |
Account Description as provided by Sponsor/Custodian, if available on the file. |
DESBRK |
DESBRK |
BLANK |
DIVSON |
DIVSON |
BLANK |
MGR |
MGR |
BLANK |
RELMGR |
RELMGR |
BLANK |
STATUS |
STATUS |
BLANK |
Sponsor or Custodian UMA Acct ID |
MSPACT |
If report is for a Trade Network Sponsor, this is the SNAM of the account on the Sponsor side. If the report is for a non-Trade Network Custodian, this is the Account ID as provided by the Custodian. All Else - BLANK |
UMA Sleeve ID |
MSPMOD |
If the report is for a Trade Network Sponsor, this is the sleeve code on the Sponsor side. Generally, non-Trade Network Custodians will not have the sleeve-level detail on the account file. For BlackRock, there are some exceptions to this: Envestnet UMA, Merrill One, and Morgan Stanley+. All Else - BLANK |