NSCC File Formats

You can access the NSCC file formats for the CNS/Non-CNS Settlement Account from the
CNS Record Layouts tab available in the DTCC Learning Center. Login with either your Learning Center account or by using your DTCC Portal ID and password.

CMU / Fixed Income

Subject Description Type Date

Fixed Income Corp/UIT Contracts File
94.3KB
pdf
Jun 22, 2016

Fixed Income Muni Contract File
98.8KB
pdf
Jun 22, 2016

Correspondent Clearing

Subject Description Type Date

Correspondent Clearing MQ Message Format
69KB
pdf
Aug 01, 2009

Correspondent Clearing Input Format
44KB
pdf
Dec 01, 2008

Equity Commission Bill

Subject Description Type Date

Universal Equity Commission Bill Daily pre-edit MRO
12KB
pdf
Dec 05, 2013

Equity Commission Bill Input
22KB
pdf
Dec 01, 2008

Universal Commission Bill Final Monthly MRO
35KB
pdf
Dec 01, 2008

ETF

Subject Description Type Date

DATATRAK Production 11300/PSE 41300
Enhanced ETF Create and Redeem Instruction Input MRO
DATATRAK Input
Jul 18, 2019

AutoRoute Production 02261254/PSE 02981254
Enhanced ETF Create and Redeem Instruction Data Output (MRO)
AutoRoute
Jul 16, 2019

AutoRoute Production 02261255/PSE 02981255
Enhanced Consolidated Portfolio Composition Receipt Reject MRO
AutoRoute Output
Sep 27, 2018

AutoRoute Production 02261954/Test 02981954
Exchange Traded Funds (ETF) Record Layout: Enhanced Intraday Create/Redeem Receipt/Reject Report
AutoRoute Output
Aug 10, 2018

AutoRoute Production 02260291/PSE 02980291
Exchange Traded Funds (ETF) Record Layout: Enhanced ETF Create and Redeem Instruction Print Image Report
AutoRoute Output
Jan 25, 2018

AutoRoute Production 02081673/Test 02981673
UTC MRO Trade Capture Data File
AutoRoute Output
Jan 22, 2018

02262335 Near Real Time Supplemental PCF MRO File Layout
Near Real-Time Supplemental PCF AutoRoute Production 02262335/Test 02982335

Note: To view the client business requirement and record layouts associated with the 2020 deployment of the PCF enhancements for multiple basket types, see the ETF Phase 1 - 2020 Deployment tab in the ETF Working Groups section available at:
https://dtcclearning.com/products-and-services/equities-clearing/exchange-traded-fund-etf/etf-working-groups.html
AutoRoute Output
Feb 11, 2016

02262222 Historical Portfolio Composition Output File Layout
02262222 Historical Portfolio Composition Output File Layout
AutoRoute Output
Mar 17, 2015

02262222 Canned Test Data
Historical Portfolio Composition
AutoRoute Output
Mar 17, 2015

02261256 Canned Test Data
Enhanced Consolidated Portfolio Composition
AutoRoute Output
Nov 12, 2014

02261256 Enhanced Consolidated Portfolio Composition Output File Layout
Enhanced Consolidated Portfolio Composition Output Data File: AutoRoute Production 02261256/PSE 02981256

Note: To view the client business requirement and record layouts associated with the 2020 deployment of the PCF enhancements for multiple basket types, see the ETF Phase 1 - 2020 Deployment tab in the ETF Working Groups section available at:
https://dtcclearning.com/products-and-services/equities-clearing/exchange-traded-fund-etf/etf-working-groups.html
AutoRoute Output
Jul 31, 2014

11301 Enhanced Consolidated Portfolio Composition Input File
11301 Enhanced Consolidated Portfolio Composition Input File

Note: To view the client business requirement and record layouts associated with the 2020 deployment of the PCF enhancements for multiple basket types, see the ETF Phase 1 - 2020 Deployment tab in the ETF Working Groups section available at: https://dtcclearning.com/products-and-services/equities-clearing/exchange-traded-fund-etf/etf-working-groups.html
DATATRAK Input
Jul 31, 2014

11301 Canned Test Data
Enhanced Consolidated Portfolio Composition
DATATRAK Input
Jul 01, 2012

11301 File Layout
Enhanced Consolidated Portfolio Composition
DATATRAK Input
May 01, 2012

Master Files

Subject Description Type Date

Continuous Net Settl. Equity Master File
Continuous Net Settl. Equity Master File (342KB)
pdf
Feb 05, 2015

Continuous Net Settl. Equity-Bond Master File Mnthly
276KB
pdf
Dec 04, 2013

Mutual Funds Security Master File
436KB
pdf
Dec 04, 2013

Continuous Net Settl. Equity-Bond Master File Wkly
28KB
pdf
Dec 04, 2013

Continuous Net Settl. Broker Master File
30KB
pdf
Dec 04, 2013

Autoroute Header Record
216KB
pdf
Dec 04, 2013

Universal Datatrak Header & Trailer
136KB
pdf
Dec 04, 2013

Fund/SERV Security Master - Daily
20KB
pdf
Jun 01, 2009

Fund/SERV Security Master - Weekly
21KB
pdf
Jun 01, 2009

Revised Autoroute Header Record - 6-digit
62KB
pdf
Nov 05, 2005

Revised Autoroute Header Record - 8-digit
636KB
pdf
Nov 05, 2005

Money Settlement

Subject Description Type Date

02132518 - Money Settlement Act Fund/Serv File
17KB
pdf
Dec 05, 2013

02132661 - Money Settlement Settling Bank File
31KB
pdf
Dec 05, 2013

02130162 - Universal Equity Commission Bill Daily pre-edit MRO
12KB
pdf
Dec 05, 2013

02132065 - NSCC Debit & Credit File
24KB
pdf
Dec 05, 2013

02132107 - Universal Commission Bill Final Monthly MRO
22KB
pdf
Dec 05, 2013

OTC Equities

Subject Description Type Date

02022231 - OTC Foreign Receive & Deliver MRO
23KB
pdf
Dec 05, 2013