Standard File Layouts

The documents on this website explain Pershing’s Standard Files--outgoing files of standard sizes and formats delivered via nightly batch processes. Standard Files are raw data from all our applications providing all you require to gather information, generate reports, and directly feed your systems.

For an overview of the Standard Files Product, view this short video: https://communications.pershing.com/reader/pershing/pershing-standard-files-overview

The Standard A-Z tab on the left includes detailed layouts for each standard file offered.

The Appendices tab includes documents referenced within various layouts listed under the Standard A-Z tab.

Available fields of the five most utilized Standard Files, noted in their web descriptions, are offered as real time messages as well. The link to intraday message layouts is found on the right under Content Aids.

 

A
APPENDIX 12 - Business Party Role Codes - 4/08/21

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

Appendix 14 - Receive and Deliver Codes 20210312.pdf

USED IN THE FOLLOWING STANDARD FILES: RD01-RD23

APPENDIX 2 - FATCA CODES - 6/23/20

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 - 12/08/20

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

(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 - 04/29/21

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 – 04/01/21

Used in the following Standard files: CAPS/T, GACT, GTDE/GSDE, GTOE/GTOL

APPENDIX S - Trade and Exchange Codes - 09/15/20

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.

Delivery and Configuration Aids