Standard File Layouts

Layouts and documents listed under the Standard A-Z, IntraDay and Appendices tabs pertain to files containing data for our Brokerage line of business or those that contain data from and related to multiple lines of business. Other tabs host layouts for files containing data specific to the line of business indicated only.

A
ACTB – ACAM Activity for Bank Custody - 12/13/16

The ACAM Expanded Activity file (ACTB) is created daily after the history in the sweep products has been updated. The file reflects all of the activity that has occurred in various sweep products, both money funds and bank deposit products in the selected office(s) for individual investor accounts for the current day. This file contains header and trailer records that confirm the beginning and end of the file, the date it was created, and the file’s total number of records. ACTB will be made available after Pershing receives updated activity from our Bank Custody provider.

back to top

F
FUNB - ACAM Expanded Fund Balance - 11/2/15

FUNB - ACAM Expanded Fund Balance - 11/2/15 The ACAM Expanded Fund Balance file (FUNB) is created daily after the update balances are received from Funds Transfer Agent and/or Fund Group. This file represents all of the balances held by various money funds in the selected office(s). This file contains header and trailer records that confirm the beginning and end of the file, the date it was created, and the file’s total number of records. FUNB will be made available after Pershing receives updated money fund positions from our Bank Custody provider.

back to top

G
GAC1 – Global Bookkeeping Activity - 01/11/18

GAC1 – Global Bookkeeping Activity - 01/11/18 GAC1 is based on the Bank Custody activity attributed to accounts held on the Global Data Repository (GDR) as delivered to Pershing by our service provider(s). GAC1 will run on a different schedule than GACT, and the data from these two files will not be commingled.

GCS1 - Global Customer Position - 07/25/17

GCS1 - Global Customer Position - 07/25/17 The Global Customer Position files (GCUS and GCS1) are created after the close of business each day. The file reflects account positions within your office range on an update and refresh basis. Based on Pershing’s business model, refresh (full) files are not transmitted daily. Update records are generated only by changes in quantity; market value changes alone do not drive the creation of an update record. All amounts depicted in this file are displayed in USDE (US Dollar Equivalent). Currencies are displayed as holdings, represented by the User CUSIP. For example, US dollar CUSIP is USD9999997; Euros are EUR999995. Note: This file contains information on Security/Currency positions only. Money Fund positions are shown on our FUND file and Annuity holdings are shown on our ASPS file. GCS1 is based on the Bank Custody positions attributed to accounts held on the Global Data Repository (GDR) as delivered to Pershing by our service provider(s). GCS1 will run on a different schedule than GCUS, and the data from these two files will not be commingled. GCS1 is based on the Bank Custody positions attributed to accounts held on the Global Data Repository (GDR) as delivered to Pershing by our service provider(s). GCS1 will run on a different schedule than GCUS, and the data from these two files will not be commingled.

GMN1 – Global Moneyline - 12/14/16

GMN1 – Global Moneyline - 12/14/16 GMN1 is based on Bank Custody data attributed to accounts held on the Global Data Repository (GDR) as delivered to Pershing by our service provider(s). GMN1 will run on a different schedule than GMON, and the data from these two files will not be commingled.

back to top

M
MFTB - Mutual Fund Trades for Bank Custody file - 20181203

The Mutual Fund Trades for Bank Custody file (MFTB) is created daily, reflecting the Mutual Fund Daily Trade Activity Log report. The Mutual Fund Trade Activity Log report provides the mutual fund trading desk a daily report that contains all the mutual fund orders that were routed to the MIPMASTR file along with their present statuses and other details. The file is created in parallel to the creation of the report and contains a duplicate of the information fields from the report. There is a possibility of receiving multiple “B” records for each transaction.
All values will be displayed in the currency that the fund is denominated in. A fund can be denominated in more than one currency and each currency of the same fund will have a different CUSIP assigned to it. The symbol “
” is used on our standard files to represent spaces.

back to top

P
POT1 - Portfolio Open Tax Lots - 6/5/19

POT1 - Portfolio Open Tax Lots - 6/5/19 POT1 is based on the Bank Custody activity and positions attributed to accounts held on the Global Data Repository (GDR) as delivered to Pershing by our service provider(s). POT1 will run on a different schedule than POTL, and the data from these two files will not be commingled.

PTL1 - Portfolio Tax Lot Dispositions - 11/02/16

PTL1 - Portfolio Tax Lot Dispositions - 11/02/16 PTL1 is based on the Bank Custody activity and positions attributed to accounts held on the Global Data Repository (GDR) as delivered to Pershing by our service provider(s). PTL1 will run on a different schedule than PTLD, and the data from these two files will not be commingled.

back to top

S
SUBD/SUBF - Sub-Account for Bank Custody - 6/26/15

SUBD/SUBF - Sub-Account for Bank Custody - 6/26/15 The Sub-Account for Bank Custody files (SUBD and SUBF) are created after the close of business batch cycle. The files contain the sub-accounts associated with Bank Custody accounts and their appropriate characteristics. SUBD is created nightly and SUBF is refreshed nightly, weekly or monthly.

Contact Us

For immediate production issues, please call Pershing's Technology Help Desk: 888-878-3142 or 732-622-2150, option 4

For general questions, please email the Data Delivery group at: datadelivery@pershing.com

For file content questions, email Standard Files Project Management: standard.files.pms@bnymellon.com

Content Aids

Standard File Layouts Overview

Standard File Layouts Overview The Overview provides an introduction to Pershing Standard File Layouts including a description and the various methods by which standard files can be transmitted to your firm.

Helpful Hints

Helpful Hints

Delivery and Configuration Aids

infoDirect Migration FAQ's

infoDirect Migration FAQ's

Netx360 GS Using InfoDirect User Guide

Netx360 GS Using InfoDirect User Guide

infoDirect Instructions

infoDirect Instructions

SFG Notification IBD

SFG Notification IBD