Record Layouts

ACATS (IPS)/BIN/REP/BEN - Inforce Transactions (IFT)

• Inforce Transactions (IFT) Layouts v22-3 (MS-Excel .xlsx, 850KB, Updated 06/2022)

Asset Pricing

• NSCC Annuity Asset Pricing Record (AAP) Layouts v23-3 (MS-Excel .xlsx, 305KB, Updated 03/2023)

Attachments

• Attachments Data Dictionary v23-8 (MS-Excel .xlsx, 54.4KB, Updated 11/2023)
• Attachments Implementation Guide (Word .docx, 786KB, Updated 7/2024)
• Attachments Technical Reference Guide (Acrobat .pdf, 278KB, Updated 10/2019)
• Attachments Connectivity Guide (Acrobat .pdf, 277KB, Updated 10/2019)
• Attachments WSDLs and Schemas  (ZIP Archive. zip, 9.96KB, Updated 11/2023)
• Attachments XML Samples (ZIP Archive .zip, 22.9KB, Updated 10/2023)

Commissions

• COM Record Layouts v24-7 (MS-Excel .xlsx, 400KB, Updated 07/2024)

Financial Activity Reporting

• FAR Record Layouts v24-7 (MS-Excel .xlsx, 432KB, Updated 07/2024)
• FAR Import Documentation: Report Sample and Specification (MS-Excel .xlsx, 33.5KB, Current Version)
• FAR Import Documentation: Code List Translation (Acrobat .pdf, 18KB, Updated 06/2008)
• FAR to Asset Managers (FAM) Record Layout (Acrobat .pdf, 401KB, Updated 01/2023)

InForce Web Transactions (IFW) - Fund Transfers/Withdrawals/Arrangements/Non-Financial

• IFT Web Services Implementation Guide (MS-Word .doc, 173KB, Updated 12/2017)
• IFT Web Services Technical Reference Guide  (Acrobat .pdf, 139KB, Updated 12/2017)
• IFT WSDL's and Schemas  (ZIP Archive .zip, 46KB, Updated 07/2023)
• IFT Web Services Message Data Dictionary  (MS-Excel .xls, 496KB, Updated 07/2023)

IFT Access

• IFT Import Specifications  (MS-Excel .xls, 68.5KB, Updated 09/2019)
• IFT Activity Template  (MS-Excel .xls, 33KB, Updated 05/2010)
• IFT Import Template  (MS-Excel .xls, 84.5KB, Updated 09/2019)
• IFT Access - How to Download Data File Procedure  (Acrobat .pdf, 453KB, Updated 05/2019)
• IFT Access Upload Template (BIN REP)  (MS-Excel .xlsx, 149KB , Updated 09/2020)
• IFT Access Upload Template (BDR)  (MS-Excel .xlsx, 153KB , Updated 09/2020)

Initial Application (APP) and Subsequent Premium (SUB)

• APP/SUB Record Layouts v24-7  (MS-Excel .xlsx, 1.4MB, Updated 07/2024)

Insurance Information Exchange

• CST Record Layout (MS-Excel .xlsx, 187KB)
• FET Data Dictionary (MS-Excel .xlsx, 131KB Updated 03/2023)
• FET Schema (ZIP Archive. zip, 37KB)

Licensing & Appointments

• Training Vendor Input File Reject Codes  (MS-Excel .xls, 30KB, Updated 11/2011)
• Training Vendor Input File (Comma Delimited - Variable Length)  (MS-Excel .xls, 186KB, Updated 11/2022)
• L&A Record Layouts  (MS-Excel .xls, 548KB, Updated 03/2024)
• LNA - How to Download Data File Procedure  (Acrobat .pdf, 485KB, Updated 05/2019)
• LNA Activity Template  (MS-Excel.xls, 45KB, Updated 05/2019)
• LNA Import Specifications  (MS-Excel.xls, 82.5KB, Updated 09/2019)
• LNA Import Sample  (MS-Excel .xls, 68KB, Updated 09/2020)
• LNA Import Template  (MS-Excel .xls, 233KB, 04/2017)

Money Settlement

• Tolerance Monitoring of I&RS Service Settlement Amounts  (Acrobat .pdf, 82KB, Updated 04/2021)
• NSCC Money Settlement Detail (MSD) Record Layout  (Acrobat .pdf, 17KB, Updated 12/2016)
• MSD Canned File (Text .txt, 1.66KB, Current Version)
• Money Settlement System (MSS) Record Layout (Acrobat .pdf, 142KB, Updated 11/2020)
• MSS Canned File (Text .txt, 1KB, Current Version)

Positions & Valuations

• POV Layouts v24-7 (MS-Excel .xlsx, 466KB, Updated  09/2024)
• PRP Retirement Plans Record Layouts (MS-Excel .xlsx, 454KB, Updated 11/2023)

Producer Management Portal

• DTCC Producer Management Portal (PMP) Implementation Guide (Acrobat .pdf, 474KB, Updated 06/2013)  
• DTCC Producer Management Portal Data Dictionary  
• DTCC Producer Management Portal Schemas & WDSLs (.zip, 12.0KB, Updated 09/2020)

Reject Processing Guidelines

• Reject File Processing (Acrobat .pdf, 14KB, Updated 06/2009)

Settlement Processing for Insurance^SM

• Settlement Processing Implementation Guide (Acrobat .pdf, 316KB, Updated 03/2023)
• Settlement Record Layouts (MS-Excel.xlsx, 492KB, Updated 03/2024)

DataTrak and AutoRoute

• DataTrak Record Layouts (MS-Excel .xlsx, 71KB, Current Version)
• AutoRoute Record Layouts (MS-Excel .xlsx, 51KB, Current Version)