Interface Transaction Standards: Record Type "971" - Transfer Information Extract File

Disclaimer: RDSP issuers

The information contained on this page is technical in nature and is intended for Registered Disability Savings Plan (RDSP), Canada Disability Savings Grant (grant) and Canada Disability Savings Bond (bond) issuers. For general information, visit the RDSP section.

Consult this page frequently for newer versions. The following laws and regulations take precedence over information contained in InfoCapsules in the event of discrepancies:

  • Income Tax Act
  • Canada Disability Savings Act
  • Canada Disability Savings Regulations

11.0 Record Type "971" – Transfer Extract File

Further to the termination and transfer of a contract on the part of a relinquishing issuer and the registration of a new contract under a receiving issuer, the Transfer Extract File, reports to the receiving issuer all successfully processed financial transactions. These include transactions that have been reported to the CDSP system for the contract of the relinquishing issuer, as well as those reported for earlier contracts also transferred for the same beneficiary.

The Transfer Information Extract file consists of: 

  • RT "001" - Header record.
  • RT "971-01" - Contribution/Contribution Correction Information.
  • RT "971-02" - Bond Request Information.
  • RT "971-03" - Retirement Savings Rollover/Retirement Savings Rollover Reversal Information.
  • RT "971-04" - Grant/Bond Repayment - Grant/Bond Repayment Reversal Information.
  • RT "971-05" -  DAP / DAP Reversal Information.
  • RT "971-06" - LDAP/ LDAP Reversal Information.
  • RT "971-07" - Education Savings Rollover/Education Savings Rollover Reversal Information.
  • Trailer record – type "999".

NOTE: The ITS documents the data elements common to all components of the Transfer Information Extract file in the "971" Record Component Layout followed by the "971-01" through "971-07" Record Component Layouts specific to each transaction type.  The only exceptions in the "971" Common Elements table are the "Original Issuer BN" and "Original Issuer Transaction Number" fields which are excluded in the "971-02" Bond Request transaction.

PURPOSE: Provide to the receiving issuer all information in ESDC's possession for administrative purposes.

REQUIREMENTS: None.

11.1 Record Type "971" Record Component Layout – Data Elements Common to All Transfer Extract File Transaction Types

Implementation Date – January 2013

Record Type "971" - Transfer Extract File (.xfr) - Common Elements RT 971-01 to 07

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type

X(3)

1-3

"971".

Transaction Type

X(2)

4-5

"01" through "07".

Refer to Section 11 introduction above.

Receiving Issuer BN

X(15)

6-20

BN of issuer Receiving File.

Receiving Issuer Specimen Plan Number

X(7)

21-27

Current specimen plan number of the Receiving contract.

Receiving Issuer Contract

X(15)

28-42

Contract Number of the receiving issuer.

Reporting Issuer BN 

X(15)

43-57

Business Number of the reporting issuer.

Issuer originally reported to CDSP system.

Reporting Issuer Transaction Number

X(15)

58-72

Transaction Number of the reporting issuer or as assigned by CDSP system when manual intervention is required.

Transaction Number originally reported to CDSP system.

Reporting Issuer Specimen Plan

X(7)

73-79

Specimen plan Number of the reporting issuer.

Specimen plan originally reported to CDSP system.

Reporting Issuer Contract

X(15)

80-94

Contract Number of the reporting issuer.

Contract Number originally reported to CDSP system.

Beneficiary SIN

X(9)

95-103

Beneficiary SIN.

Reporting Issuer Event Date

X(8)

104-111

Date reported by the reporting issuer.

Event date originally reported to CDSP system.

Transaction Origin

X(2)

112-113

Indicates origin of transaction.

Refer to record type – "901".

Original Issuer BN

X(15)

114-128

Business Number of issuer originally reporting Reversal/Correction transaction.

Field excluded in "971-02" Bond Request transaction.

Original Issuer Transaction Number

X(15)

129-143

Transaction Number originally reported in Reversal/Correction transaction.

Field excluded in "971-02" Bond Request transaction.

11.2 Record Type "971-01" Record Component Layout – Transfer Extract File Data Elements Specific to Contribution / Contribution Correction Transactions

Record Type "971-01" File (.xfr) - Specific to Contribution / Contribution Correction

Data Element Name

Type Size

Trxn Posn

Description

Notes

Contribution Amount

9(9).99 or -9(8).99

144-155

Amount of the Contribution reported by the issuer or as assigned by the CDSP system when manual intervention is required.

Negative amount when transaction is a correction.

Grant Requested

X(1)

156

Indicates if grant has been requested as reported by the issuer.

"Y" = Yes
"N" = No

Grant Amount

9(9).99 or -9(8).99

157-168

Amount of grant calculated by the CDSP system.

Negative amount when transaction is a correction.

Refusal Reason

X(2)

169-170

Reported by the CDSP system when no grant or partial grant is paid.

Refer to Appendix A.

Payment Date

X(8)

171-178

Date grant payment is first processed in the CDSP system.

YYYYMMDD Relevant for AHA calculation.

Payment Requisitioned

X(1)

179

Indicates whether payment amount is affected as reported by the CDSP system.

"Y" = Yes,
Blank if No

11.3 Record Type "971-02" Record Component Layout – Transfer Extract File Data Elements Specific to Bond Request Transaction

Record Type "971-02" File(.xfr) – Specific to Bond Request Transaction

Data Element Name

Type Size

Trxn Posn

Description

Notes

Bond Amount

9(9).99

114-125

Amount of bond calculated by the CDSP system.

 

Refusal Reason

X(2)

126-127

Reported by the CDSP system when no bond or partial bond is paid.

Refer to Appendix A.

Payment Date

X(8)

128-135

Date bond payment is first processed in the CDSP system.

YYYYMMDD Relevant for AHA calculation.

Payment Requisitioned

X(1)

136

Payment amount indicator reported to the issuer.

"Y" = Yes
Blank if No

11.4 Record Type "971-03" Record Component Layout – Transfer Extract File Data Elements Specific to Retirement Savings Rollover/Rollover Reversal Transactions

Record Type "971-03" (.xfr) File – Specific to Retirement Savings Rollover/Rollover Reversal Transactions

Data Element Name

Type Size

Trxn Posn

Description

Notes

Rollover Amount

9(9).99 or -9(8).99

144-155

Amount of the Rollover reported by the issuer or as assigned by the CDSP system when manual intervention is required.

Negative amount when transaction is a reversal.

Rollover Issue

X(2)

156-157

Reported by the CDSP system when an issue occurs with a Rollover.

Refer to Appendix A.

11.5 Record Type "971-04" Record Component Layout – Transfer Extract File Data Elements Specific to Repayment/Repayment Reversal Transactions

Record Type "971-04" (.xfr) File – Specific to Repayment/Repayment Reversal Transactions

Data Element Name

Type Size

Trxn Posn

Description

Notes

Grant Repayment Amount

9(9).99 or -9(8).99

144-155

Amount of grant repayment reported by the issuer or as assigned by the CDSP system when manual intervention is required.

Negative amount when transaction is a reversal.

Bond Repayment Amount

9(9).99 or -9(8).99

156-167

Amount of bond repayment reported by the issuer or as assigned by the CDSP system when manual intervention is required.

Negative amount when transaction is a reversal.

Repayment Reason
or
Repayment Reversal Reason

X(2)

168-169

Reported by the issuer when a Repayment or Repayment Reversal is completed.

Refer to RT "401-10/11" for Repayment Reasons/Repayment Reversal Reasons

Payment Requisitioned

X(1)

170

Payment amount indicator reported to the issuer.

"Y" = Yes,
Blank if No

11.6 Record Types "971-05" DAP and "971-06" LDAP Record Component Layouts – Transfer Extract File Data Elements Specific to DAP/DAP Reversals and LDAP/LDAP Reversals

Record Type "971-05/06" (.xfr) File - Specific to DAP/DAP Reversals and LDAP/LDAP Reversals

Data Element Name

Type Size

Trxn Posn

Description

Notes

Contribution Portion of Non-Taxable Formula

9(9).99 or -9(8).99

144-155

Contribution amount reported by the issuer in a DAP/LDAP calculated using Variable "B" of the non-taxable formula.

Refer to Appendix D - DAP/LDAP formulas.

Negative amount when transaction is a reversal.

Grant Portion of the DAP/LDAP

9(9).99 or -9(8).99

156-167

Amount of grant reported by the issuer in the DAP/LDAP.

Refer to Appendix D - DAP/LDAP formulas.

Negative amount when transaction is a reversal.

Bond Portion of the DAP/LDAP

9(9).99 or -9(8).99

168-179

Amount of grant reported by the issuer in the DAP/LDAP.

Refer to Appendix D - DAP/LDAP formulas.

Negative amount when transaction is a reversal.

Non-Taxable Portion of the DAP/LDAP 

9(9).99 or -9(8).99

180-191

Non-taxable amount reported by the Issuer in the DAP/LDAP.

Refer to Appendix D - DAP/LDAP formulas.

Negative amount when transaction is a reversal.

Total DAP/LDAP Amount

9(9).99 or -9(8).99

192-203

Total Amount of the DAP/LDAP reported by the issuer.

Negative amount when transaction is a reversal.

DAP/LDAP Reversal Reason

X(2)

204-205

Reason for a DAP Reversal/LDAP Reversal as reported by the issuer.

Refer to DAP Reversals/LDAP Reversals.

11.7 Record Types "971-07" Record Component Layout – Transfer Extract File Data Elements Specific to Education Savings Rollover/Rollover Reversal Transactions

Record Type "971-07" (.xfr) File - Specific to Education Savings Rollover/Rollover Reversal Transactions

Data Element Name

Type Size

Trxn Posn

Description

Notes

Rollover Amount

9(9).99 or -9(8).99

144-155

Amount of the Rollover reported by issuer or as assigned bye the CDSP system when manual intervention is required.

Negative amount when transaction is a reversal.

Rollover Issue

X(2)

156-167

Reported by CDSP system when an issue occurs with a Rollover.

Refer to Appendix A.

11.8 Record Type "971" Validation Rules

Record type "971" is generated by the CDSP system, validation rules are not applicable.

Report a problem or mistake on this page
Please select all that apply:

Thank you for your help!

You will not receive a reply. For enquiries, contact us.

Date modified: