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
APPENDIX 12 - Business Party Role Codes - 2/14/19

USED IN THE FOLLOWING STANDARD FILES: ACCF/ACCT, BPFD/BPFF

APPENDIX 2 - FATCA CODES - 6/26/19

Used in the following standard file: FATC

APPENDIX 5 - RESTRICTED INDUSTRY CODES - 01/03/17

Used in the following standard files: AMAF

APPENDIX 7 - PAR and MAXX Key Codes - 07/11/17

Used in the following standard files: GACT

APPENDIX 8 - Source Codes - 6/28/19

USED IN THE FOLLOWING STANDARD FILES: FT90, GACT/GAC1

(NOTE: The ISRC/SRCD standard files contain a digital version of the Source Codes)

Appendix 9 - COD SSI Product Codes - 09/08/17

Used in the following standard file: SETD/SETF

This appendix contains the following information:

  • SSI Product Codes (page 1)

  • Settlement Location Market Codes (pages 2-11)

APPENDIX A-Interest Frequency - 01/23/17

Used in the following standard files: ISCA.

APPENDIX B - Security Codes - 8/23/19

This appendix contains the following information:

  •  Security Code Matrix (pages 1-4)

  •  Minor Product Codes (pages 5-8)

  • Asset Type, SubType and Sub-Subtype (pages 9-13)

  • Tranche Types (for Mortgage-Backed Securities) (pages 14-15)

  • Security Code Matrix

APPENDIX D - Plan Types - 02/06/17

Used in the following standard files: ACCT/ACCF.

APPENDIX H-CAPS Product Codes - 11/02/11

The CAPS product codes are available to all of our customers. Because individual clients may have access to additional product codes, other codes may appear in the file. For a complete list of CAPS product codes, see the CAPS online system, Codes Maintenance Product Browse (CDPB).

APPENDIX I-ACAM Codes - 02/06/17

The ACAM Codes Appendix identifies the different types of money fund activity that can appear in the ACAM history record file. Refer to this appendix in conjunction with the ACTV form.

APPENDIX K - Legend Codes 11/02/16

Used in the following standard files: GACT, GAC1, GTDE/GSDE, GTOE, OELG.

APPENDIX L-ComplianceView Account Types - 08/01/03

The ComplianceView Account Type Appendix can be used to help identify the classification of a particular account. Refer to this appendix in conjunction with the following standard files: ASTM and GTRD.

APPENDIX M - Document Codes and Descriptions - 2/11/19

USED IN THE FOLLOWING STANDARD FILES: KTMS, KTRV

APPENDIX N - Currency Codes - 03/13/18

Used in the following standard files: ACCT/F, ALTI, CAPS/CAPT, FT10, FT20, FT90, GACT/GAC1, GCUS/GCS1, GSDE/GTDE, GTOE, ISCA, OELG.

APPENDIX P – Source of Input – 02/07/17

Used in the following standard files: CAPS/T, GACT, GTDE/GSDE, GTOE.

Appendix Q - GEOGRAPHICAL CODES, ACCOUNT HOLDER ROLES, REGISTRATION TYPES and FATCA CODES - 7/15/19

This appendix contains the following information:

  • Country Codes (sorted by ISO Country Code) (pages 2-8)
  • Country Codes (sorted by Country Name) (pages 9-15)
  • Discontinued Country Codes (sorted by Country Name) (pages 16-17)
  • Canadian Province Codes (sorted by Province Code) (page 18)
  • United States Codes (sorted by alpha State Code) (page 18)
  • Account Holder/Participant Roles (pages 19-20)
  • Registration Types (pages 21-24)
  • Exempt Payee Codes (page 25)
  • Exempt from FATCA Reporting Codes (page 25)
  • Tax Filing Codes (page 26)
APPENDIX S - Trade and Exchange Codes - 08/09/19

This appendix contains the following information:

  • Market Mnemonic Codes (pages 2-3)
  • Account Type Indicators for Blue Sheet Reporting (page 4)
  • Settlement Location Codes (pages 5-8)
  • International Exchange Codes (pages 9-12)
  • Confirmation Codes (pages 13-14)
APPENDIX T-Asset Transfer and Status Codes - 10/04/17

Used in the following standard files: ACA2

APPENDIX V - Principal and Agency Codes - 7/10/19

Used in the following standard files: GTOE, OELG.

APPENDIX W - Source System Source ID - 06/01/18

Used in the following standard files: OELG.

APPENDIX X - Portfolio Transaction Codes 08/30/17

The Portfolio Open Tax Lots file (POTL) is the open tax lot file. It includes an aggregate/summary record (Record A) followed by the tax lot records for each position (Record B) held in accounts maintained on the Portfolio System. The aggregate record is joined to its associated tax lot records by the sequence number in position 004-011.

APPENDIX Y - OATS Audit Reporting Codes - 02/06/17

Used in the following standard files: OATS.

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