Filetype Excel XLS | Posted on 26 Jun 2022 | 3 years ago
Authentication
digital resources
250x Filetype XLS File size 1.16 MB Source: www.dtcc.com
Sheet 1: NSCC Formats
| NSCC POSITIONS & VALUES (PVF, PNF, PFF) RECORD LAYOUTS | |||||||||||||||
| Updated: 05/2022 | Change Log | 10 Submitting Header | |||||||||||||
| 12 Contra Record | |||||||||||||||
| 13-01 Contract Record | |||||||||||||||
| This document describes the record formats to be used for data submitted in NSCC's fixed-length format. The same formats are also used to transmit the NSCC output. | 13-02 Contract Valuation Record | ||||||||||||||
| 13-03 Contract Underlying Assets | |||||||||||||||
| 13-04 Contract Band Guaranteed Loop | |||||||||||||||
| The following definitions apply to the record layouts. The column headings are as follows: | 13-05 Contract Agent Record | ||||||||||||||
| 13-06 Contract Dates Record | |||||||||||||||
| Start | The position where the field starts | 13-07 Contract Events Record | |||||||||||||
| 13-09 Contract Party Record | |||||||||||||||
| End | The position where he field ends | 13-10 Contract Party Address Record | |||||||||||||
| 13-11 Contract Annuitization Record | |||||||||||||||
| 13-12 Contract Party Communication Record | |||||||||||||||
| Length | The length of the field in bytes | 13-15 Contract Service Feature Record | |||||||||||||
| Reject Code List | |||||||||||||||
| Type | The type of field: | Code List | |||||||||||||
| A/N | = | Alphanumeric | POV Cycles | ||||||||||||
| N | = | Numeric | |||||||||||||
| D | = | Date Format: | YYYYMMDD | ||||||||||||
| Field Name | The name of the field | ||||||||||||||
| Description | Field description (format, valid value, conditional requirements, etc.) | ||||||||||||||
| Item Number | The corresponding item number from the Data Dictionary documentation. | ||||||||||||||
| Field Indicator | Indicates whether the field is optional or required: | ||||||||||||||
| O | = | Optional | |||||||||||||
| M | = | Mandatory | |||||||||||||
| OC | = | Optional/Conditional | |||||||||||||
| Reject Code | The reject code that indicates this field is invalid, available on the output only. The reject code field is 12 bytes to hold up to 4, 3-byte reject codes. | ||||||||||||||
| Test Indicator | P = Production Data; T = Test Data | ||||||||||||||
| Filler | Filler is bytes reserved for future fields. Information should not be submitted in any bytes designated as filler. DTCC, on output, will delete any information in filler, and pass the bytes as spaces to the receiving firm. | ||||||||||||||
| POSITION (PFF) LOOPING STRUCTURE | |||||||||||||||||||||||
| Shown below are the relationships of the segments used for data submitted in NSCC format. | |||||||||||||||||||||||
| 10 - Submitting Header - Mandatory - at least 1 occurrence required for each file. | |||||||||||||||||||||||
| 12 - Contra Header - Mandatory - 1 - occurrence for each contra party sent. | |||||||||||||||||||||||
| 13/Seq01 - Contract Record - Mandatory - (99,999,999 occurrences per Contra Header, at least one is required) | |||||||||||||||||||||||
| 13/Seq02 - Contract Valuation Record - Optional - (20 occurrences per Contract Record) | |||||||||||||||||||||||
| 13/Seq03 - Contract Underlying Assets Record - Optional - 999 occurrences per Contract Record) | |||||||||||||||||||||||
| 13/Seq04 - Contract Band/Guaranteed Loop with Underlying Assets Record - Optional - | |||||||||||||||||||||||
| (1999 occurrences per Contract Underlying Assets Record) (If 13/04 is present, then 13/03 is required) | |||||||||||||||||||||||
| 13/Seq07 - Contract Events Record - Optional - (9 occurrences per Contract Record) | |||||||||||||||||||||||
| (1) | (2) | (3) | (4) | (5) | (6) | ||||||||||||||||||
no reviews yet
Please Login to review.
