Stress Test Data Framework Dictionary 2017: Version 02

External_reconciliations

This worksheet outlines the external reconciliation rules relevant to the STDF submissions. The firm is expected to return the template with the reported amount and description columns filled in as required.

201702 Reconciliations

Order Field Name Enumeration Definition
1 Submission type SubmissionType States whether the submission is historical or future projections.
2 Unique ID An internal identifier that a submitting firm uses to uniquely identify a instrument within a firm’s IT system. In structured finance data, this identifier will be used to match the instrument data in the historical data submission to the same instrument in the projections data submission.
3 Control type Source: A data item from the STDF data item reference. Reconciling item: Reasons for difference between source(s) and target(s). Firms must describe all reconciling differences with meaningful and justifiable descriptions. Target: An STDF or external target.
4 Qualified name QualifiedNameExternal Reconciliation calculation identifier for data across submissions.
5 Sign The sign, (positive or negative) that will be multiplied to the reported amount to determine the unreconciled difference.
6 Reported amount The amount reported via the qualified name in the STDF data item reference or external report data item reference sheets.
7 Description A meaningful and justifiable description of the data item / control type reference.