Interface Transaction Standards: Transaction Formats

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

6.0 Transaction Formats

This section contains detailed descriptions of all transaction record formats.

If any record is rejected, at least one record of the error is written into the Error File (filename.err).

If any field designated "mandatory" is blank, an error message is generated with an Error Code of "8104".

6.1 Record Type "001" – Header Record

PURPOSE: To identify the source of a transaction file.

REQUIREMENTS: None.

Record Type "001" Header 
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "001" - Record Header  
Program identifier X(4) 4-7 "CDSP"  
Autdorized Agent BN X(15) 8-22    
Date Sent X(8) 23-30 Date on which file was sent to the CDSP system
or
Date on which the CDSP system created the file.
YYYYMMDD
File number 9(2) 31-32 Number to distinguish files sent on the same day.
Range 01-99
 
Data Version X(4) 33-36 Version of the CDSP system Data Interface Standard currently in use.
"03.1".
Filler X(464) 37-500  Spaces  

6.1.1 Record Type "001" Validation Rules

When record type "001" is generated by the CDSP system, validation rules are not applicable. For files being sent to the CDSP system, the header record, type "001", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "001" Validation Rules
Field Rule Error Code
Record Type There must be a header record. 8004
The first record in every file must be type "001". 8003
No other record can be type "001". 8005
Program Identifier Mandatory field. 8104
Must be "CDSP". 8102
Authorized Agent BN Mandatory field. 8104
The authorized agent BN must match the authorized agent BN in the filename. 8000
The authorized agent BN must exist in the CDSP system database. 8101
The authorized agent BN must be identified in the CDSP system as authorized to send files. 8006
Authorized agent BN must be associated to a specimen plan. 8006
Date Sent Mandatory field. 8104
The Date Sent must match the date in the filename. 8000
The Date Sent must be on or before the current date. 8100
The Date Sent must be on or after December 1st, 2008. 8100
The Date Sent must be in a valid format. 8100
File number Mandatory field. 8104
The File number must match the File number in the file name. 8000
Data Version Mandatory field. 8104
Data Version must be ‘02.1’, ‘02.2’, ‘02.3’, ‘03.0’ or ‘03.1’. 8007

6.2 Record Type "002" – Sub-Header Record (Transaction Processing File)

The record type "002" is only included in the transaction processing file produced by the CDSP system.

PURPOSE: The sub-header records supply reporting period information, one for each issuer in the transaction processing file.

REQUIREMENTS: This record is generated by the CDSP system and occurs as the second record type in the transaction processing file.

Record Type "002" Sub-Header
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "002" - Sub-header Record  
Issuer BN X(15) 4-18 BN of the issuer.  
Reporting Period Start Date X(8) 19-26 Valid date. YYYYMMDD
Reporting Period End Date X(8) 27-34 Valid date. YYYYMMDD
Summary Amount 9(10).99 35-47 Sum of grant and bond payments less the sum of re-payments for an issuer in this reporting period. Positive if grant plus bond disbursed exceeds repayment by the issuer.
Payment Amount 9(10).99 48-60 Grant and bond money paid to authorized agent in this reporting period. $0 if net re-payment of grant or bond.
Payment Requisition ID 9(10) 61-70   Generated by CDSP system.
Filler X(430) 71-500    

6.2.1 Record Type "002" Validation Rules

Because record type "002" is generated by the CDSP system, validation rules are not applicable.

6.3 Record Type "003" – Files Processed Record (Transaction Processing File)

The record type "003" is only included in the transaction processing file produced by the CDSP system.

PURPOSE: The "Files Processed Record" gives the name of a production file sent by the authorized agent that was processed by the CDSP system during the production run. One record is generated for each production file sent and processed.

REQUIREMENTS: This record is generated by the CDSP system and occurs as the third record type in the transaction processing file.

Record Type "003" Files Processed
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "003" - Files Processed Record  
Authorized Agent BN X(15) 4-18 BN of the authorized agent.  
Date Sent X(8) 19-26 Date authorized agent sent the file to the CDSP system.  
Date Received X(8) 27-34 Date the CDSP system received the file.  
File Number 9(2) 35-36 File Number generated by the authorized agent.  
Filler X(464) 37-500    

6.3.1 Record Type "003" Validation Rules

Because record type "003" is generated by the CDSP system, validation rules are not applicable.

6.4 Record Type "101" - Contract Registration Information

Record type "101" is used to provide all contract information relating to registration.

PURPOSE: Issuers use this record type to provide all information elements necessary to register a new contract.

REQUIREMENTS: The record type "101" requires three separate components to achieve registration of a contract. These include:

  • Record Type "101", Transaction Type "01", Contract Information.
  • Record Type "101", Transaction Type "02", Beneficiary Information.
  • Record Type "101", Transaction Type "03", Holder Information (report one transaction type "03" for each holder named on the contract).

All components of a Contract Registration Information record must be submitted during the same production cycle and all must have the same issuer transaction number. The CDSP system will process all components as one, and return the results to the authorized agent, identifying errors on each component, if applicable. A single error on any one component will "error out" all three components. All three components must be resubmitted in one processing cycle when correcting an error.

NOTE: If the contract is already registered, please refer to record type 201 to add, update or remove holder information as well as to update beneficiary information.

6.4.1 Record Type "101-01" Record Component Layout - Contract Registration - Contract Information

Implementation Date - December 2008

Record Type "101-01" - Contract Registration - Contract Information 
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "101" - Contract Registration Information  
Transaction Type X(2) 4-5 "01" - Contract information  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.
The transaction ID must be identical for all components ("01", "02" and "03") of the contract registration information record.
Issuer transaction number must not be reused to submit corrections.
Specimen Plan X(7) 36-42   Assigned by CRA.
Filler X(3) 43-45 Spaces  
Contract X(15) 46-60 Issuer's contract number.  
Contract Signature Date X(8) 61-68 The date that the contract was signed with the issuer. YYYYMMDD
Primary Caregiver SIN or Agency BN X(15) 69-83 Used to determine:
Disability Tax Credit (DTC) eligibility, Canadian Residency and Family Income.
Specified only until the end of the month in which the beneficiary turns 18. 9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN provided by CRA : 9 digits + X(2) + 4 digit reference number.
Primary Caregiver Name X(30) 84-113   Specified only until the end of the month in which the beneficiary turns 18. Specified only when the PCG is an Individual.
Primary Caregiver Surname
or
Agency Name
X(60) 114-173   Specified only until the end of the month in which the beneficiary turns 18.
Primary Caregiver Type X(1) 174-174 "1" - Individual (SIN)
"2" - Agency (BN)
Specified only until the end of the month in which the beneficiary turns 18.
Transfer Indicator X(1) 175-175 "Y" - There is an existing contract for the beneficiary with assets that will be transferred into this contract.
"N" - This contract registration request does not involve the transfer of another contract.
 
Contract Creation or Update Date X(8) 176-183 Date the Contract was created or updated with the issuer. YYYYMMDD
Other Contract X(15) 184-198 Contract number of relinquishing contract if transfer Indicator="Y". In order for transfer to be resolved, must match existing contract in CDSP system database.
Other Specimen Plan X(7) 199-205 Specimen plan of relinquishing contract if transfer Indicator="Y". In order for transfer to be resolved, must match existing specimen plan in CDSP system database.
Filler X(295) 206-500 Spaces  
6.4.1.1 Record Type "101-01" Validation Rules

The Contract Information record, type "101-01", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "101-01" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Issuer BN must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each contract registration requests at the issuer. Severe error (1)
Contract registration request is missing a component (101-02 or 101-03). 8238
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be valid. 8220
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Contract Mandatory field. 8104
Must not already be Registered, Closed, De-registered or Nullified. 8230
The beneficiary must not already have a Pending, Registered or De-registered contract unless the Transfer indicator is 'Yes' on the current submission. 8231
Duplicate contract registration in the same period. 8239
Only one contract registration request for the beneficiary in the same period is permitted. 8240
Conflicting contract transactions pertaining to the same contract received in the period. 8254
Contract Signature Date Mandatory field. 8104
Must be a valid date. 8100
Contract signature date cannot change once a contract status is 'Pending'. 8233
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after Dec 1st, 2008. 8200
Primary Caregiver SIN or
Agency BN
Mandatory field until the end of the month in which the beneficiary turns 18 years old. 8104
When present, the first nine characters are numerals only. 8101
When present, the SIN or BN must be numerically valid. 8250
When PCG type = ‘2’ - Agency, must be 15 characters in length. 8101
Primary Caregiver Given Name Mandatory field if PCG SIN is present and the PCG type = '1' - Individual. 8104
Primary Caregiver Surname
or
Agency Name
Mandatory field if PCG BN/SIN is present. 8104
Primary Caregiver Type Mandatory field if PCG BN/SIN is present. 8104
Must be '1' or '2'. 8101
Transfer Indicator Mandatory field. 8104
Must be 'Y' or 'N'. 8101
There must not already be a contract awaiting transfer in the CDSP system for the beneficiary. 8253
Contract Creation or Update Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Date must be on or after contract signature date. 8206
Must be within the dates the issuer is eligible. 8207
Other Contract Mandatory if transfer indicator = 'Y'. 8104
Must exist in CDSP system database. 8102
Must be associated to the beneficiary and other specimen plan and must be Pending, Registered, De-registered or Closed. 8234
Must not change after transfer resolved. 8261
Other Specimen Plan Mandatory if transfer indicator = 'Y'. 8104
Must exist in CDSP system database. 8102
Must not change after transfer resolved. 8261

6.4.2 Record Type "101-02" Record Component Layout - Contract Registration - Beneficiary Information

Implementation Date - December 2008

Record Type "101-02" - Contract Registration - Beneficiary Information 
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "101" - Contract Registration Information   
Transaction Type X(2) 4-5 "02" - Beneficiary information  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer. The transaction number must be identical for all components ('01', '02' and '03') of the contract registration information record. Issuer transaction number must not be reused to submit corrections.
Beneficiary SIN X(9) 36-44    
Beneficiary Given Name X(30) 45-74    
Beneficiary Surname X(30) 75-104    
Beneficiary Date of Birth X(8) 105-112   YYYYMMDD
Beneficiary Sex X(1) 113-113 '1' - Female
'2' - Male
 
Address Line 1 X(40) 114-153 Street name, number, and apartment.  
Address Line 2 X(40) 154-193 Street name, number, and apartment (cont'd).  
Address Line 3 X(40) 194-233 If Country = "002", contains "State, ZIP Code". If Country = "999" contains "Province equivalent, Postal Code, Country ".  
City X(30) 234-263    
Province X(2) 264-265 Refer to Appendix A. If Country not Canada, Province ignored.
Country X(3) 266-268 "001" - Canada
"002" - USA
"999" - Other Country
 
Postal Code X(6) 269-274 Postal Code if Country is Canada.  
Language X(1) 275-275 '1'- English
'2'- French
 
Filler X(225) 276-500 Spaces  
6.4.2.1 Record Type "101-02" Validation Rules

The Beneficiary Information record, type "101-02", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "101-02" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
Transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
BN of issuer must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Contract registration information is missing a component (101-01 or 101-03). 8238
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must be numerically valid. 8250
Must pass SIR validation as outlined in Appendix C. 8105
Contract already associated to another beneficiary SIN. 8252
Beneficiary Given Name Mandatory field. 8104
Must pass SIR validation as outlined in Appendix C. 8105
Beneficiary Surname Mandatory field. 8104
Must pass SIR validation as outlined in Appendix C. 8105
Beneficiary Date of Birth Mandatory field. 8104
Must be a valid date. 8100
Must pass SIR validation as outlined in Appendix C. 8105
Year of birth must be the same if beneficiary is already in CDSP system. 8251
Beneficiary Sex Mandatory field. 8104
Must be '1' or '2'. 8101
Must pass SIR validation as outlined in Appendix C. 8105
Address Line 1 Mandatory field. 8104
Address Line 2 Not validated.  
Address Line 3 Not validated.  
City Mandatory field. 8104
Province Mandatory if Country is Canada. 8104
If Country Canada, must match code in Appendix "A", Province Codes. 8101
Country Mandatory field. 8104
Must be '001', '002' or '999'. 8101
Postal Code Mandatory if Country is Canada. 8104
Language Mandatory field. 8104
Must be English or French. 8101

6.4.3 Record Type "101-03" Record Component Layout - Contract Registration - Holder Information

Implementation Date - December 2008

Record Type "101-03" - Contract Registration - Holder Information 
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "101" - Contract Registration Information.  
Transaction Type X(2) 4-5 "03" - Holder Information.  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer. The transaction ID must be identical for all components (01, 02 and 03) of the Contract Registration Information record. Issuer transaction number must not be reused to submit corrections.
Holder SIN or BN X(15) 36-50 Used to determine DTC eligibility, Canadian Residency and Family Income. 9 left justified digits with 6 trailing blanks when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN as provided by CRA:; 9 digits + X(2) + 4 digit reference number.
Holder Given Name X(30) 51-80    
Holder Surname or Holder Agency Name X(60) 81-140    
Holder Type X(1) 141-141 "1" - Individual (SIN)
"2" - Agency (BN)
 
Holder Relationship X(2) 142-143 '01' - Beneficiary
'02' - Legal Parent
'03' - Guardian
'04' - Tutor
'05' - Curator
'06' - Legal Representative or Qualified Family Member
'07' - Public Department
'08' - Agency
'09' - Institution
 
Holder Date of Birth X(8) 144-151   YYYYMMDD
Holder Sex X(1) 152-152 '1' - Female
'2' - Male
 
Address Line 1 X(40) 153-192 Street name, number, and apartment.  
Address Line 2 X(40) 193-232 Street name, number, and apartment (cont'd).  
Address Line 3 X(40) 233-272 If Country = "002", contains "State, ZIP Code". If Country = "999" contains "Province equivalent, Postal Code, Country ".  
City X(30) 273-302    
Province X(2) 303-304 Refer to Appendix A. If Country not Canada, Province ignored.
Country X(3) 305-307 "001" - Canada
"002" - USA
"999" - Other country
 
Postal Code X(6) 308-313 Postal Code if Country is Canada.  
Language X(1) 314-314 '1' - English
'2' - French
 
Filler X(186) 315-500 Spaces  
6.4.3.1 Record Type "101-03" Validation Rules

The Holder Information record, type "101-03", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "101-03" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
BN of issuer must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Contract registration request is missing a component (101-01 or 101-02). 8238
Holder SIN
or
Holder Agency BN
Mandatory field. 8104
Numerals (9) only. 8101

The SIN or BN must be numerically valid

8250
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
When holder type = '2' (Agency), must be 15 characters in length. 8101
Holder Given Name Mandatory field if holder type is 'Individual'. 8104
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Surname
Or
Holder Agency Name
Mandatory field. 8104
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Type Mandatory field. 8104
Must be '1' (Individual) or '2' (Agency). 8101
Holder Relationship Mandatory field. 8104
Must be '01' through '09'. 8101
Holder Date of birth Mandatory field if holder type is 'Individual'. 8104
Must be a valid date. 8100
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Sex Mandatory field if holder type is 'Individual'. 8104
Must be '1' or '2'. 8101
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Address Line 1 Mandatory field. 8104
Address Line 2 Not validated.  
Address Line 3 Not validated.  
City Mandatory field. 8104
Province Mandatory if Country is Canada. 8104
If Country Canada, must match code in Appendix A, Province Codes. 8101
Country Mandatory field. 8104
Must be '001', '002' or '999'. 8101
Postal Code Mandatory if Country is Canada. 8104
Language Mandatory field. 8104
Must be English or French. 8101

6.5 Record Type "102" - Contract Update Information

Record type "102" is used by the issuer to update contract information. There are two (2) types of contract update transactions reported, "10" - Close a Contract and "11" - Rename a Contract.

PURPOSE: Issuers use these record types to perform specific updates to a contract.

REQUIREMENTS: The record type "102" will refer to the contract number requiring updates.

6.5.1 Record Type "102-10" - Record Component Layout - Contract Updates - Close a Contract

Implementation Date - May 2009

Record Type "102-10" - Close a Contract
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "102" - Contract Update  
Transaction Type X(2) 4-5 "10" - Close a Contract  
Issuer BN X(15) 6-20 Business Number of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer. Issuer transaction number must not be reused to submit corrections.
Specimen Plan X(7) 36-42   Assigned by CRA.
Filler X(3) 43-45 Spaces  
Contract X(15) 46-60 Issuer's contract number.  
Closure Reason X(2) 61-62 '01' - Death of beneficiary
'02' - Loss of DTC
'03' - Transfer
'04' - Plan De-Registered
'05' - Other
 
Closure Reason Date X(8) 63-70 Date related to closure reason. YYYYMMDD
Closure Date X(8) 71-78 Date the contract was closed with the issuer.  
Filler X(422) 79-500 Spaces  
6.5.1.1 Record Type "102-10" Validation Rules

The Close a Contract record, type "102-10", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "102-10" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Issuer BN must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be valid. 8220
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Contract Mandatory field. 8104
Must be a contract that is Pending, Registered, or De-registered. 8246
Contract must be associated to the specimen plan. 8235
Closure Reason Mandatory field. 8104
Must be '01' through '05'. 8101
Closure Reason Date Must be a valid date. 8100
Mandatory if closure reason = '01' - Death of beneficiary. 8104
Closure Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Date must be on or after contract signature date. 8206
Must be within the dates the issuer is eligible. 8207

6.5.2 Record Type "102-11" - Record Component Layout - Contract Update - Rename a Contract

Implementation Date - May 2009

Record Type "102-11" - Rename a Contract 
Data Element Name Type Size Trxn Posn

Description

Notes
Record Type X(3) 1-3 "102" - Contract Update  
Transaction Type X(2) 4-5 "11" - Rename a Contract  
Issuer BN X(15) 6-20 Business Number of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Filler X(3) 43-45 Spaces Filler
Contract X(15) 46-60 Issuer's new contract number.  
Original Contract X(15) 61-75 Issuer's original contract number.  
Rename Date X(8) 76-83 Date the contract was renamed. YYYYMMDD
Filler X(417) 84-500 Spaces  
6.5.2.1 Record Type "102-11" Validation Rules

The Rename a Contract record, type "102-11", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "102-11" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Issuer BN must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be valid. 8220
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Contract Mandatory field. 8104
Must not exist in the CDSP system. 8245
Conflicting contract transactions pertaining to the same contract received in the period. 8254
Original Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Must exist in the CDSP system with a status of "Registered", "Pending" or "Closed". 8247
Rename Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Date must be on or after contract signature date. 8206
Must be within the dates the issuer is eligible. 8207

6.6 Record Type "201" - Beneficiary and Holder Update Information

Record type "201" is used to update beneficiary information, update holder information, as well as adding and removing a holder from a contract. These transactions are only to be used in situations where the contract has already achieved a status of "registered".

PURPOSE: Issuers use these record types to change the contract information elements that have been previously reported on a "registered" Contract Registration Information Transaction with respect to the beneficiary and or the holder.

REQUIREMENTS: The record type "201" refers to the beneficiary or holder where the information held in the CDSP system needs to be changed.

6.6.1 Record Type "201-02" Record Component Layout - Update Beneficiary Information

Implementation Date - May 2009

Record Type "201-02" - Update Beneficiary Information 
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "201" - Beneficiary and Holder Updates  
Transaction Type X(2) 4-5 "02" - Update Beneficiary information  
Issuer BN X(15) 6-20 Business Number.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Beneficiary SIN X(9) 36-44    
Beneficiary Given Name X(30) 45-74    
Beneficiary Surname X(30) 75-104    
Beneficiary Date of Birth X(8) 105-112   YYYYMMDD
Beneficiary Sex X(1) 113-113 '1' - Female
'2' - Male
 
Address Line 1 X(40) 114-153 Street name, number, and apartment.  
Address Line 2 X(40) 154-193 Street name, number, and apartment (cont'd).  
Address Line 3 X(40) 194-233 If Country = "002", contains "State, ZIP Code". If Country = "999" contains "Province equivalent, Postal Code, Country ".  
City X(30) 234-263    
Province X(2) 264-265 Reference : Appendix A. If Country not Canada, Province ignored.
Country X(3) 266-268 "001" - Canada
"002" - USA
"999" - Other Country
 
Postal Code X(6) 269-274 Postal Code if Country is Canada.  
Language X(1) 275-275 '1' - English
'2' - French
 
Specimen Plan X(7) 276-282   Assigned by CRA.
Filler X(3) 283-285 Spaces  
Contract X(15) 286-300 Issuer's contract number.  
Update Date X(8) 301-308 Date the beneficiary information was updated with the issuer.  
Filler X(192) 309-500 Spaces  
6.6.1.1 Record Type "201-02" Validation Rules

The Update Beneficiary Information record, type "201-02", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "201-02" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
BN of issuer must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must be numerically valid 8250
Must pass SIR validation as outlined in Appendix C. 8105
Must exist in the CDSP system. 8102
Beneficiary Given Name Mandatory field. 8104
Must pass SIR validation as outlined in Appendix C. 8105
Beneficiary Surname Mandatory field. 8104
Must pass SIR validation as outlined in Appendix C. 8105
Beneficiary Date of Birth Mandatory field. 8104
Must be a valid date. 8100
Must pass SIR validation as outlined in Appendix C. 8105
Year of birth must match beneficiary already in CDSP system. 8251
Beneficiary Sex Mandatory field. 8104
Must be '1' or '2'. 8101
Must pass SIR validation as outlined in Appendix C. 8105
Address Line 1 Mandatory field. 8104
Address Line 2 Not validated.  
Address Line 3 Not validated.  
City Mandatory field. 8104
Province Mandatory if Country is Canada. 8104
If Country Canada, must match code in Appendix A, Province Codes. 8101
Country Mandatory field. 8104
Must be '001', '002' or '999'. 8101
Postal Code Mandatory if Country is Canada. 8104
Language Mandatory field. 8104
Must be '1' or '2'. 8101
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system. 8102
Specimen plan must be valid. 8220
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be associated to the beneficiary. 8236
Contract must be registered. 8241
Update Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Date must be on or after the contract signature date. 8206
Must be within the dates the issuer is eligible. 8207

6.6.2 Record Type "201-03" Record Component Layout - Update Holder Information

Implementation Date - May 2009

Record Type "201-03" - Update Holder Information
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "201" - Beneficiary and Holder Updates  
Transaction Type X(2) 4-5 "03" - Update Holder Information  
Issuer BN X(15) 6-20 Business Number.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Holder SIN or BN X(15) 36-50 Used to determine DTC eligibility, Canadian Residency and Family Income. 9 left justified digits with 6 trailing blanks when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.
Holder Given Name X(30) 51-80    
Holder Surname or Holder Agency Name X(60) 81-140    
Holder Type X(1) 141-141 "1" - Individual (SIN)
"2" - Agency (BN)
 
Holder Relationship X(2) 142-143 '01' - Beneficiary
'02' - Legal Parent
'03' - Guardian
'04' - Tutor
'05' - Curator
'06' - Legal Representative or Qualified Family Member
'07' - Public Department
'08' - Agency
'09' - Institution
 
Holder Date of Birth X(8) 144-151   YYYYMMDD
Holder Sex X(1) 152-152 '1' - Female
'2' - Male
 
Address Line 1 X(40) 153-192 Street name, number, and apartment.  
Address Line 2 X(40) 193-232 Street name, number, and apartment (cont'd).  
Address Line 3 X(40) 233-272 If Country = "002", contains "State, ZIP Code". If Country = "999" contains "Province equivalent, Postal Code, Country ".  
City X(30) 273-302    
Province X(2) 303-304 Refer to Appendix A. If Country not Canada, Province ignored.
Country X(3) 305-307 "001" - Canada
"002" - USA
"999" - Other country
 
Postal Code X(6) 308-313 Postal Code if Country is Canada.  
Language X(1) 314-314 '1' - English
'2' - French
 
Specimen Plan X(7) 315-321   Assigned by CRA.
Filler X(3) 322-324 Spaces  
Contract X(15) 325-339 Issuer's contract number.  
Update Date X(8) 340-347 Date the holder information was updated.  
Filler X(153) 348-500 Spaces  
6.6.2.1 Record Type "201-03" Validation Rules

The Update Holder Information record, type "201-03", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "201-03" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
BN of issuer must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Holder SIN
Or
Holder Agency BN
Mandatory field. 8104
Numerals (9) only. 8101
The SIN or BN must be numerically valid 8250
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
When holder type = '2' (Agency), must be 15 characters in length. 8101
Must exist in the CDSP system. 8102
Holder Given Name Mandatory field if holder type is 'Individual'. 8104
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Surname
Or
Holder Agency Name
Mandatory field. 8104
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Type Mandatory field. 8104
Must be '1' (Individual) or '2' (Agency). 8101
Holder Relationship Mandatory field. 8104
Must be '01' through '09'. 8101
Holder Date of Birth Mandatory field if holder type is 'Individual'. 8104
Must be a valid date. 8100
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Sex Mandatory field if holder type is 'Individual'. 8104
Must be '1' or '2'. 8101
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Address Line 1 Mandatory field. 8104
Address Line 2 Not validated.  
Address Line 3 Not validated.  
City Mandatory field. 8104
Province Mandatory if Country is Canada. 8104
If Country CAN, must match code in Appendix A, Province Codes. 8101
Country Mandatory field. 8104
Must be '001', '002' or '999'. 8101
Postal Code Mandatory if Country is Canada. 8104
Language Mandatory field. 8104
Must be English or French. 8101
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system. 8102
Specimen plan must be valid. 8220
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be currently associated to the holder. 8237
Contract must be registered. 8241
Update Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Date must be on or after the contract signature date. 8206
Must be between the dates the issuer is eligible. 8207

6.6.3 Record Type "201-13" Record Component Layout - Add Holder to Contract

Implementation Date - May 2009

Record Type "201-13" - Add Holder to Contract 

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type X(3) 1-3 "201" - Beneficiary and Holder Updates  
Transaction Type X(2) 4-5 "13" - Add Holder  
Issuer BN X(15) 6-20 Business Number.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Holder SIN or BN X(15) 36-50 Used to determine DTC eligibility, Canadian Residency and Family Income. 9 left justified digits with 6 trailing blanks when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.
Holder Given Name X(30) 51-80    
Holder Surname or Holder Agency Name X(60) 81-140    
Holder Type X(1) 141-141 "1" - Individual (SIN)
"2" - Agency (BN)
 
Holder Relationship X(2) 142-143 '01' - Beneficiary
'02' - Legal Parent
'03' - Guardian
'04' - Tutor
'05' - Curator
'06' - Legal Representative or Qualified Family Member
'07' - Public Department
'08' - Agency
'09' - Institution
 
Holder Date of Birth X(8) 144-151   YYYYMMDD
Holder Sex X(1) 152-152 '1' - Female
'2' - Male
 
Address Line 1 X(40) 153-192 Street name, number, and apartment.  
Address Line 2 X(40) 193-232 Street name, number, and apartment. (Cont'd)  
Address Line 3 X(40) 233-272 If Country = "002", contains "State, ZIP Code". If Country = "999" contains "Province equivalent, Postal Code, Country ".  
City X(30) 273-302    
Province X(2) 303-304 Refer to Appendix A. If Country not Canada, Province ignored.
Country X(3) 305-307 "001" - Canada
"002" - USA
"999" - Other country
 
Postal Code X(6) 308-313 Postal Code if Country is Canada.  
Language X(1) 314-314 '1' - English
'2' - French
 
Specimen Plan X(7) 315-324   Assigned by CRA.
Filler X(3) 322-324 Spaces Filler
Contract X(15) 325-339 Issuer's contract number.  
Add Date X(8) 340-347 Date the Holder was added to the contract with the issuer.  
Filler X(153) 348-500 Spaces  
6.6.3.1 Record Type "201-13" Validation Rules

The Add Holder record, type "201-13", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "201-13" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
BN of issuer must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Holder SIN
Or
Holder Agency BN
Mandatory field. 8104
Numerals (9) only. 8101

The SIN or BN must be numerically valid

8250
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
When holder type = '2' (Agency), must be 15 characters in length. 8101
Holder Given Name Mandatory field if holder type is 'Individual'. 8104
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Surname
Or
Holder Agency Name
Mandatory field. 8104
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Type Mandatory field. 8104
Must be '1' (Individual) or '2' (Agency). 8101
Holder Relationship Mandatory field. 8104
Must be '01' through '09'. 8101
Holder Date of Birth Mandatory field if holder type is 'Individual'. 8104
Must be a valid date. 8100
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Holder Sex Mandatory field if holder type is 'Individual'. 8104
Must be a valid sex. 8101
Must pass SIR validation as outlined in Appendix C, if holder type is 'Individual'. 8105
Address Line 1 Mandatory field. 8104
Address Line 2 Not validated.  
Address Line 3 Not validated.  
City Mandatory field. 8104
Province Mandatory if Country is Canada. 8104
If Country CAN, must match code in Appendix "A", Province Codes. 8101
Country Mandatory field. 8104
Must be '001', '002' or '999'. 8101
Postal Code Mandatory if Country is Canada. 8104
Language Mandatory field. 8104
Must be English or French. 8101
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system. 8102
Specimen plan must be valid. 8220
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be registered. 8241
Must not be currently associated to the holder. 8248
Add Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Date must be on or after contract signature date. 8206
Must be between the dates the issuer is eligible. 8207

6.6.4 Record Type "201-23" Record Component Layout - Remove Holder from Contract

Implementation Date - May 2009

Record Type "201-23" - Remove Holder from Contract 

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type X(3) 1-3 "201" - Beneficiary and Holder Updates
Transaction Type X(2) 4-5 "23" - Remove Holder  
Issuer BN X(15) 6-20 Business Number.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Holder SIN or BN X(15) 36-50   9 left justified digits with 6 trailing blanks when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.
Specimen Plan X(7) 51-57   Assigned by CRA.
Filler X(3) 58-60 Spaces  
Contract X(15) 61-75 Issuer's contract number.  
Removal Date X(8) 76-83 Date the holder was removed with the issuer.  
Filler X(417) 84-500 Spaces  
6.6.4.1 Record Type "201-23" Validation Rules

The Remove Holder record, type "201-23", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "201-23" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
BN of issuer must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Holder SIN
Or
Holder Agency BN
Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system. 8102
Must not be the only active holder on the contract. 8249
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system. 8102
Specimen plan must be valid. 8220
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be currently associated to the holder. 8237
Contract must be registered. 8241
Removal Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Date must be on or after contract signature date. 8206
Must be between the dates the issuer is eligible. 8207

6.7 Record Type "202" - Consent Information for Beneficiary

Record type ''202'' is used to add or revoke consent for the beneficiary as well as to update said consent.

PURPOSE: Issuers use these record types to add, revoke or change consent information required by CRA with respect to the beneficiary.

REQUIREMENTS: The record type "202" will refer to the beneficiary where add, revoke or update consent information is required.

6.7.1 Record Type "202-01" Record Component Layout - Add or Update Consent for Beneficiary

Implementation Date - January 2012

Record Type "202-01" - Add or Update Consent for Beneficiary

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type X(3) 1-3 "202" - Consent for Beneficiary  
Transaction Type X(2) 4-5 "01" - Add/Update Consent for Beneficiary  
Issuer BN X(15) 6-20 Business Number.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57 Issuer contract number.  
Beneficiary SIN X(9) 58-66    
Add Consent Date X(8) 67-74 The date the add consent transaction was completed with the issuer. YYYYMMDD
Consent SIN/BN X(15) 75-89 The SIN/BN of the Individual/Agency granting consent. 9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN provided by CRA : 9 digits + X(2) + 4 digit reference number.
Consent Given Name X(30) 90-119 Given name of the Individual granting consent.  
Consent Surname/Agency X(60) 120-179 Surname/Name of the Individual/Agency granting consent.  
Consent Type X(1) 180-180 "1" - Individual (SIN)
"2" - Agency (BN)
 
Filler X(320) 181-500 Spaces  
6.7.1.1 Record Type "202-01" Validation Rules

The "Add/Update Consent for Beneficiary" record, type "202-01", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "202-01" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
BN of issuer must be identified in the CDSP system. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be associated to beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Add Consent Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Date must be within the dates the issuer is eligible. 8207
Date must be on or after contract signature date. 8206
When consent already exists , must be later than the last consent transaction date. 8264
Consent SIN/BN Mandatory field. 8104
First nine characters are numerals (9) only. 8101
When consent type = "2" - Agency, must be 15 in length. 8101
The SIN or BN must be numerically valid 8250
Must not exist as an active holder on any contract of the reported beneficiary. 8265
Consent Given Name Mandatory field, if consent type = "1" - Individual. 8104
Consent Surname/Agency Mandatory field. 8104
Consent Type Mandatory field. 8104
Value must be 1 or 2. 8100

6.7.2 Record Type "202-02" Record Component Layout - Revoke Consent for Beneficiary

Implementation Date - January 2012

Record Type "202-02" - Revoke Consent for Beneficiary 

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type X(3) 1-3 "202" - Consent for Beneficiary  
Transaction Type X(2) 4-5 "02" - Revoke Consent for Beneficiary  
Issuer BN X(15) 6-20 Business Number.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57 Issuer Contract number.  
Beneficiary SIN X(9) 58-66    
Revoke Consent Date X(8) 67-74 The date the revoke consent transaction was completed with the issuer. YYYYMMDD
Consent SIN/BN X(15) 75-89 The SIN/BN of the Individual/Agency granting consent. Must not be an active holder on the current contract.
Filler X(411) 90-500 Spaces  
6.7.2.1 Record Type "202-02" Validation Rules

The "Revoke Beneficiary" Consent record, type "202-02", is validated and error codes are generated for failures as outlined in the following table and notes:

Type "202 - 02" Validation Rules
Field Rule Error Code(s)
Record Type

Mandatory field.

Severe error (2)

Transaction Type

Mandatory field.

Severe error (2)

The transaction type must be valid for the record type.

Severe error (2)

Issuer BN

Mandatory field.

Severe error (4)

Must be 15 characters.

Severe error (4)

BN of issuer must be identified in the CDSP system.

8102

Specimen

Plan

Mandatory field.

8104

Specimen plan must exist in the CDSP system database.

8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221

Specimen plan must be valid.

8220

Contract

Mandatory field.

8104

Contract must be associated to the specimen plan.

8235

Contract must be associated to the beneficiary.

8236

Contract must not be nullified.

8255

Beneficiary SIN

Mandatory field.

8104

Numerals (9) only.

8101

Must exist in the CDSP system database.

8102

Revoke Consent Date

Mandatory field.

8104

Must be a valid date.

8100

Date must be on or before the current reporting period end date.

8201

Date must be within the dates the issuer is eligible.

8207

Date must be on or after contract signature date.

8206

Consent SIN/BN

Mandatory field.

8104

Must be 9 or 15 characters.

8101

First nine characters are Numerals (9) only.

8101

The SIN or BN must be numerically valid

8250

Must already be recorded as a consent for the beneficiary.

8266

Must not be an active holder on the current beneficiary contract.

8267

Beneficiary cannot revoke consent.

8268

6.8 Record Type "401" - Financial Transactions

Record type 401 is used by the issuer to report all financial transactions and to request bond payments. There are fourteen (14) types of financial transactions reported, “01” – Contribution/Grant Request, “02” – Contribution/Grant Request Correction, “05” – Request for Bond Payment, “06” – Stop Bond Payment, “08” – Retirement Savings Rollover, “09” – Retirement Savings Rollover Reversal, “10” – Repayment of Grant and/or Bond, “11” – Reverse Repayment of Grant and/or Bond, “20” – DAP, “21” – LDAP, “22” – Reverse DAP, “23” – Reverse LDAP, “30” – Education Savings Rollover and “31” – Education Savings Rollover Reversal.

PURPOSE: Issuers use these record types to report all financial transactions that occur on a registered contract.

REQUIREMENTS: The record type "401" will refer to the contract number of the contract and the date on which the financial transaction occurs with the issuer.

6.8.1 Record Type "401-01" Record Component Layout - Financial Information - Contribution/Grant Request

Implementation Date - December 2008

Record Type "401-01" - Financial Transaction – Contribution/Grant Request

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type

X(3)

1-3

"401" - Financial Transaction

 
Transaction Type

X(2)

4-5

"01" - Contribution

 
Issuer BN X(15) 6-20 BN of issuer  
Issuer Transaction Number

X(15)

21-35

Unique identifier assigned to each transaction by the issuer.

Issuer transaction number must not be reused to submit corrections.

Specimen Plan

X(7)

36-42

 

Assigned by CRA

Filler

X(3)

43-45

Spaces

 
Contract

X(15)

46-60

   
Beneficiary SIN X(9) 61-69    
Contribution Date X(8) 70-77 The date on which the financial business was conducted with the issuer. YYYYMMDD
Contribution Amount 9(7).99 78-87 The amount of the contribution.  
Grant Requested

X(1)

88-88

"N" - No
"Y" - Yes

If grant request flag is "N", no grant is awarded for the transaction.

Primary Caregiver SIN (1)
or
Agency BN (1)

X(15)

89-103

Used to determine DTC eligibility, Canadian Residency and Family Income.

Specified only until the end of the month in which the beneficiary turns 18:
9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.

Primary Caregiver Given Name (1)

X(30)

104-133

 

Specified only until the end of the month in which the beneficiary turns 18.

Specified only when the PCG is an Individual.

Primary Caregiver Surname (1)
or;
Primary Caregiver Agency Name (1)

X(60)

134-193

 

Specified only until the end of the month in which the beneficiary turns 18.

Primary Caregiver Type (1)

X(1)

194-194

1 - Individual (SIN)

2 - Agency (BN)

Specified only until the end of the month in which the beneficiary turns 18.

Primary Caregiver SIN (2)
or
Agency BN (2)

X(15)

195-209

Used to determine DTC eligibility, Canadian Residency and Family Income.

Used only up until December 31 the year beneficiary turns 18:
9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.

Primary Caregiver Given Name (2)

X(30)

210-239

 

Used only up until December 31 the year beneficiary turns 18.

Specified only when the PCG is an Individual.

Primary Caregiver Surname (2)
or;
Primary Caregiver Agency Name (2)

X(60)

240-299

 

Used only up until December 31 the year beneficiary turns 18.

Primary Caregiver Type (2)

X(1)

300-300

1 - Individual (SIN)
2 - Agency (BN)

Used only up until December 31 the year beneficiary turns 18.

Filler X(200) 301-500 Spaces  
6.8.1.1 Record Type "401-01" Validation Rules

The "Contribution and/or Grant Request" transaction type "401-01" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-01" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Contribution Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8107
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Contribution Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than $0. 8106
Grant Requested Mandatory field. 8104
Must be 'Y' or 'N'. 8101
Primary Caregiver SIN (1)
Or
Agency BN (1)
Mandatory field until the end of the month in which the beneficiary turns 18. 8104
When present, the first nine characters are numerals only. 8101

When present, the SIN or BN must be numerically valid.

8250
When PCG type = '2' (Agency), must be 15 characters in length. 8101
Primary Caregiver Given Name (1) Mandatory if PCG (1) is present and the PCG type = '1' - Individual. 8104
Primary Caregiver Surname (1)
Or
Primary Caregiver Agency Name (1)
Mandatory if PCG (1) is present. 8104
Primary Caregiver Type (1) Mandatory if PCG (1) is present. 8104
Must be '1' or '2.' 8101
Primary Caregiver SIN (2)
Or
Agency BN (2)
Mandatory field up until December 31 the year beneficiary turns 18. 8104
When present, the first nine characters are numerals only. 8101

When present, the SIN or BN must be numerically valid.

8250
When PCG type = '2' (Agency), must be 15 characters in length. 8101
Primary Caregiver Given Name (2) Mandatory if PCG (2) is present and the PCG type = '1' - Individual. 8104
Primary Caregiver Surname
(2)
Or
Primary Caregiver Agency Name (2)
Mandatory if PCG (2) is present. 8104
Primary Caregiver Type (2) Mandatory if PCG (2) is present. 8104
Must be '1' or '2'. 8101

6.8.2 Record Type "401-02" Record Component Layout - Financial Information - Correction of Contribution/Grant Request

Implementation Date - May 2009

Record Type "401-02" - Correction of Contribution/Grant Request

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type

X(3)

1-3

"401" - Financial Transaction

 
Transaction Type

X(2)

4-5

"02" - Contribution Correction

 
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number

X(15)

21-35

Unique identifier assigned to each transaction by the issuer.

Issuer transaction number must not be reused to submit corrections.

Specimen Plan X(7) 36-42   Assigned by CRA.
Filler

X(3)

43-45

Spaces

 
Contract

X(15)

46-60

   
Beneficiary SIN X(9) 61-69    
Contribution Date

X(8)

70-77

The date on which the contribution was originally made.

YYYYMMDD

Contribution Amount

9(7).99

78-87

The correct amount of the contribution. Can be the same as the original contribution amount.

 
Grant Requested X(1) 88-88

"N" - No
"Y" - Yes

If grant request flag is "N", no grant is awarded for the transaction.

Primary Caregiver SIN (1)
Or
Agency BN (1)

X(15)

89-103

Used to determine DTC eligibility, Canadian Residency and Family Income.

Specified only until the end of the month in which the beneficiary turns 18
9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.

Primary Caregiver Given Name (1)

X(30)

104-133

 

Specified only until the end of the month in which the beneficiary turns 18.

Specified only when the PCG is an Individual.

Primary Caregiver Surname (1)
Or
Primary Caregiver Agency Name (1)

X(60)

134-193

 

Specified only until the end of the month in which the beneficiary turns 18.

Primary Caregiver Type (1)

X(1)

194-194

1 - Individual (SIN)
2 - Agency (BN)

Specified only until the end of the month in which the beneficiary turns 18.

Primary Caregiver SIN (2)
Or
Agency BN (2)

X(15)

195-209

Used to determine DTC eligibility, Canadian Residency and Family Income.

Used only up until December 31 of the year in which the beneficiary turns 18
9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.

Primary Caregiver Given Name (2)

X(30)

210-239

 

Used only up until December 31 of the year in which the beneficiary turns 18
Specified only when the PCG is an Individual.

Primary Caregiver Surname (2)
Or
Primary Caregiver Agency Name (2)

X(60)

240-299

 

Used only up until December 31 of the year in which the beneficiary turns 18

Primary Caregiver Type (2)

X(1)

300-300

1 - Individual (SIN)
2 - Agency (BN)

Used only up until December 31 of the year in which the beneficiary turns 18

Original Issuer BN

X(15)

301-315

BN of the Original issuer for the transaction to be corrected.

 
Original Issuer Transaction Number X(15) 316-330 Unique identifier used on the original transaction for which the correction has been submitted.  
Correction Date X(8) 331-338 Date the correction was made for the contribution. YYYYMMDD
Filler X(162) 339-500 Spaces  
6.8.2.1 Record Type "401-02" Validation Rules

The "Correction of Contribution and/or Grant Request" transaction type "401-02" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-02" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be associated with the issuer. 8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Contribution Date Mandatory field. 8104
Must be a valid date. 8100
Must match the original contribution date in the CDSP system. 8242
Date must be on or after beneficiary's date of birth. 8203
Contribution Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Grant Requested Mandatory field. 8104
Must be 'Y' or 'N'. 8101
Grant requested may only change from 'No' to 'Yes". 8243
Primary Caregiver SIN (1)
Or
Agency BN (1)
Mandatory field until the end of the month in which the beneficiary turns 18. 8104
When present, the first nine characters are numerals only. 8101
When present, the SIN or BN must be numerically valid. 8250
When PCG type = '2' (Agency), must be 15 characters in length. 8101
Primary Caregiver Given Name (1) Mandatory if PCG (1) is present and the PCG type = '1' - Individual. 8104
Primary Caregiver Surname (1)
Or
Primary Caregiver Agency
Name (1)
Mandatory if PCG (1) is present. 8104
Primary Caregiver Type (1) Mandatory if PCG (1) is present. 8104
Must be '1' or '2.' 8101
Primary Caregiver SIN (2)
Or
Agency BN (2)
Mandatory field up until December 31 of the year the beneficiary turns 18. 8104
When present, the first nine characters are numerals only. 8101

When present, the SIN or BN must be numerically valid.

8250
When PCG type = '2' (Agency), must be 15 characters in length. 8101
Primary Caregiver Given Name (2) Mandatory if PCG (2) is present and the PCG type = '1' - Individual. 8104
Primary Caregiver Surname(2)
Or
Primary Caregiver Agency Name (2)
Mandatory if PCG (2) is present. 8104
Primary Caregiver Type (2) Mandatory if PCG (2) is present. 8104
Must be '1' or '2'. 8101
Original Issuer BN Mandatory field. 8104
Must be 15 characters. 8101
Must exist in the CDSP database. 8102
Original Issuer Transaction Number Mandatory field. 8104
Original issuer must have previously reported the transaction to the CDSP system. 8303
Original Transaction must not have been in error. 8301
A more recent correction transaction is already associated to the contribution. 8307
Correction Date Mandatory field. 8104
Must be a valid date. 8100
Must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after the original contribution date. 8244

6.8.3 Record Type "401-05" Record Component Layout - Financial Information - Bond Payment Request

Implementation Date - December 2008

Record Type "401-05" - Bond payment request

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type

X(3)

1-3

"401" - Financial Transaction

 
Transaction Type X(2) 4-5 "05" - Bond Request  
Issuer BN X(15) 6-20 BN of issuer  
Issuer Transaction Number

X(15)

21-35

Unique identifier assigned to each transaction by the issuer.

 
Specimen Plan

X(7)

36-42

 

Assigned by CRA

Filler

X(3)

43-45

Spaces

 
Contract X(15) 46-60    
Beneficiary SIN X(9) 61-69    
Bond Request Date X(8) 70-77

The date on which the bond was requested by the holder to the issuer.

YYYYMMDD
Primary Caregiver SIN (1)
Or
Agency BN (1)

X(15)

78-92

Used to determine DTC eligibility, Canadian Residency and Family Income.

Specified only until the end of the month in which the beneficiary turns 18.
9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.

Primary Caregiver Given Name (1) X(30) 93-122  

Specified only until the end of the month in which the beneficiary turns 18 Specified only when the PCG is an Individual.

Primary Caregiver Surname (1)
Or
Primary Caregiver Agency Name (1)

X(60)

123-182

 

Specified only until the end of the month in which the beneficiary turns 18.

Primary Caregiver Type (1)

X(1)

183-183

1 - Individual (SIN)
2 - Agency (BN)

Specified only until the end of the month in which the beneficiary turns 18.

Primary Caregiver SIN (2)
Or
Agency BN (2)

X(15)

184-198

Used to determine DTC eligibility, Canadian Residency and Family Income.

Used only up until December 31 of the year in which the beneficiary turns 18.
9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.

Primary Caregiver Given Name (2)

X(30)

199-228

 

Used only up until December 31 of the year in which the beneficiary turns 18.

Primary Caregiver Surname (2)
Or
Primary Caregiver Agency Name (2)

X(60)

229-288

 

Used only up until December 31 of the year in which the beneficiary turns 18.

Primary Caregiver Type (2)

X(1)

289-289

1 - Individual (SIN)
2 - Agency (BN)

Used only up until December 31 of the year in which the beneficiary turns 18.

Filler X(211) 290-500 Spaces  
6.8.3.1 Record Type "401-05" Validation Rules

The "Bond Payment Request" transaction type "401-05" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-05" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104

Contract must be associated to the specimen plan.

8235

Contract must be associated to the beneficiary.

8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Bond Request Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or after Dec 1st, 2008. 8200
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Date must be on or before December 31st of the year in which the beneficiary turns 49. 8204
Must be within the dates the issuer is eligible. 8207
Primary Caregiver SIN (1)
Or
Agency BN (1)
Mandatory field until the end of the month in which the beneficiary turns 18. 8104
When present, the first nine characters are numerals only. 8101
When present, the SIN or BN must be numerically valid. 8250
When PCG type = '2' (Agency), must be 15 characters in length. 8101
Primary Caregiver Given Name (1) Mandatory if PCG (1) is present and the PCG type = '1' - Individual. 8104
Primary Caregiver Surname (1)
Or
Primary Caregiver Agency
Name (1)
Mandatory if PCG (1) is present. 8104
Primary Caregiver Type (1) Mandatory if PCG (1) is present. 8104
Must be '1' or '2'. 8101
Primary Caregiver SIN (2)
Or
Agency BN (2)
Mandatory field up until December 31st the year beneficiary turns 18. 8104
When present, the first nine characters are numerals only. 8101

When present, the SIN or BN must be numerically valid.

8250
When PCG type = '2' (Agency), must be 15 characters in length. 8101
Primary Caregiver Given Name (2) Mandatory if PCG (2) is present and the PCG type = '1' - Individual. 8104
Primary Caregiver Surname (2)
Or
Primary Caregiver Agency Name (2)
Mandatory if PCG (2) is present. 8104
Primary Caregiver Type (2) Mandatory if PCG (2) is present. 8104
Must be '1' or '2'. 8101

6.8.4 Record Type "401-06" Record Component Layout - Financial Information - Stop Bond Payment Request

Implementation Date - December 2008

Record Type "401-06" - Stop Bond Payment Request 

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type

X(3)

1-3

"401" - Financial Transaction

 
Transaction Type

X(2)

4-5

"06" - Stop Bond Request

 
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number

X(15)

21-35

Unique identifier assigned to each transaction by the issuer.

 
Specimen Plan X(7) 36-42   Assigned by CRA
Filler

X(3)

43-45

Spaces

 
Contract

X(15)

46-60

   
Beneficiary SIN X(9) 61-69    
Stop Request Date

X(8)

70-77

Date the stop request was made by the holder.

YYYYMMDD

Original Issuer BN X(15) 78-92 Issuer BN reported on the transaction to be stopped.  
Original Issuer Transaction Number

X(15)

93-107

Transaction number of the transaction to be stopped.

 
Filler X(393) 108-500 Spaces  
6.8.4.1 Record Type "401-06" Validation Rules

The "Stop Bond Payment Request" transaction type "401-06" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-06" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104

Contract must be associated to the specimen plan.

8235
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Stop Request Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or before the current reporting period end date. 8201
Must be within the dates the issuer is eligible. 8207
Must be on or after original bond request date. 8208
Original Issuer BN Mandatory field. 8104
The issuer BN must exist in the CDSP system database. 8102
Must be 15 characters. 8101
Original Issuer Transaction Number Mandatory field. 8104
Original issuer must have previously reported the transaction to the CDSP system. 8303
Original transaction must not have been in error. 8301
Original transaction must not be stopped more than once. 8306
Original transaction must have been designated as the active request. 8305

6.8.5 Record Type "401-08" Record Component Layout - Financial Information - Retirement Savings Rollover

Implementation Date - July 2011

Record Type "401-08"- Retirement Savings Rollover
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "401" - Financial Transaction  
Transaction Type X(2) 4-5 "08" - Retirement Savings Rollover  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
Retirement Savings Rollover Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Retirement Savings Rollover Amount 9(7).99 75-84 The amount of the Retirement Savings rollover.  

Primary Caregiver SIN
Or
Agency BN

X(15) 85-99

Used to determine DTC eligibility, Canadian Residency and Family Income.

Specified only until the end of the month in which the beneficiary turns 18.
9 digits when specifying a SIN of an individual, or;
15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number.

Primary Caregiver Given Name X(30) 100-129  

Specified only until the end of the month in which the beneficiary turns 18.

Specified only when the PCG is an Individual.

Primary Caregiver Surname
Or
Primary Caregiver Agency Name

X(60) 130-189   Specified only until the end of the month in which the beneficiary turns 18.
Primary Caregiver Type X(1) 190-190

1 - Individual (SIN)
2 - Agency (BN)

Specified only until the end of the month in which the beneficiary turns 18.
Filler

X(310)

191-500

Spaces

 
6.8.5.1 Record Type "401-08" Validation Rules

The " Retirement Savings Rollover request" transaction type "401-08" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-08" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Original transaction and its reversal were found in the same processing period. 8308
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Must be designated by CRA to accept rollovers. 8262
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Retirement Savings Rollover Date Mandatory field. 8104
Must be a valid date. 8100
Must be on or after July 1st 2011. 8113
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Must be within the date range the specimen plan is designated by CRA to accept rollovers. 8263
Retirement Savings Rollover Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than $0. 8106
Primary Caregiver SIN
Or
Agency BN
Mandatory field until the end of the month in which the beneficiary turns 18. 8104
When present, the first nine characters are numerals only. 8101

When present, the SIN or BN must be numerically valid.

8250
When PCG type = '2' (Agency), must be 15 characters in length. 8101
Primary Caregiver Given Name Mandatory if PCG is present and the PCG type = '1' - Individual. 8104

Primary Caregiver Surname
Or
Primary Caregiver Agency Name

Mandatory if PCG is present. 8104
Primary Caregiver Type Mandatory if PCG is present. 8104
Must be '1' or '2'. 8101

6.8.6 Record Type "401-09" Record Component Layout - Financial Information - Retirement Savings Rollover Reversal

Implementation Date - July 2011

Record Type "401-09" - Retirement Savings Rollover Reversal

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type X(3) 1-3 "401" - Financial Transaction  
Transaction Type X(2) 4-5 "09" - Retirement Savings Rollover Reversal  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
Retirement Savings Rollover Reversal Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Original Issuer BN X(15) 75-89 Issuer BN reported on the transaction to be reversed.  
Original Issuer Transaction Number X(15) 90-104 Transaction number of the transaction to be reversed.  
Filler X(396) 105-500 Spaces  
6.8.6.1 Record Type "401-09" Validation Rules

The " Retirement Savings Rollover Reversal request" transaction type "401-09" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-09" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104

Contract must be associated to the specimen plan.

8256

Contract must be associated to the beneficiary.

8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Retirement Savings Rollover Reversal Date Mandatory field. 8104

Must be a valid date.

8100
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Must be on or after original rollover date. 8300
Original Issuer BN Mandatory field. 8104
Must exist in the CDSP system. 8102
Original Issuer Transaction Number Mandatory field. 8104
Original issuer must have previously reported the transaction to the CDSP system. 8303
Original transaction and its reversal were found in the same processing period. 8308
Error in original transaction, current transaction cannot be processed. 8301
Original transaction must not already have been reversed. 8258
Must not be more than one reversal for the same transaction within the current processing period. 8259

6.8.7 Record Type "401-10" Record Component Layout - Financial Information - Repayment of Grant and/or Bond

Implementation Date - May 2010

Record Type "401-10" - Repayment of Grant and/or Bond

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type X(3) 1-3 "401" - Financial Transaction  
Transaction Type X(2) 4-5 "10" - Repayment  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
Repayment Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Grant Repayment Amount 9(7).99 75-84 The amount of grant to be repaid.  
Bond Repayment Amount 9(7).99 85-94 The amount of bond to be repaid.  
Grant Termination Adjustment Amount 9(7).99 95-104 The amount of the grant termination adjustment.  
Bond Termination Adjustment Amount 9(7).99 105-114 The amount of the bond termination adjustment.  
Repayment Reason X(2) 115-116 Allowable values : '01' DAP
'02' LDAP
'03' Contract terminated
'04' Contract ceases to be registered
'05' Beneficiary ceases to be DTC eligible
'06' Death of beneficiary
'07' Non entitlement (as per legislation)
'08' Bond payment rectification
Reason closest to original event.
Filler X(384) 117-500 Spaces  
6.8.7.1 Record Type "401-10" Validation Rules

The "Repayment" transaction type "401-10" is validated and error codes are generated for failures as outlined in the following table:

Type "401-10" - Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)

The issuer transaction number must be unique for each issuer.

Severe error (1)
Sum of all amounts reported must be between 0.01 and 9,999,999.99. 8110
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Repayment Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Grant Repayment Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Amount is greater than $0, grant must have been paid. 8111
Bond Repayment Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Amount is greater than $0, bond must have been paid. 8112
Grant Termination Adjustment Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Amount is greater than $0. grant must have been paid. 8111
Bond Termination Adjustment Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Amount is greater than $0. bond must have been paid. 8112
Repayment Reason Mandatory field. 8104
Must be a valid repayment reason. 8101

6.8.8 Record Type "401-11" Record Component Layout - Financial Information - Reverse Repayment of Grant and/or Bond

Implementation Date - May 2010

Record Type "401-11" - Reverse Repayment of Grant and/or Bond

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type X(3) 1-3 "401" - Financial Transaction  
Transaction Type X(2) 4-5 "11" -Repayment Reversal  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
Repayment Reversal Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Original Issuer BN (15) 75-89 Issuer BN reported on the transaction to be reversed.  
Original Issuer Transaction Number X(15) 90-104 Transaction number of the transaction to be reversed.  
Reverse Repayment Reason X(2) 105-106 Allowable values : '01' - DAP/LDAP reversal
'02' - Change in payment date of DAP/LDAP
'03' - Assistance Holdback Amount Calculated Incorrectly
'04' - Administrative Error - Wrong Plan
'05' - Administrative Error - Misunderstood Instructions
'06' - Administrative Error - Input
 
Filler X(394) 107-500 Spaces  
6.8.8.1 Record Type "401-11" Validation Rules

The "Reverse Repayment of Grant and/or Bond" transaction type "401-11" is validated and error codes are generated for failures as outlined in the following table:

Type "401-11" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Reverse Repayment Date Mandatory field. 8104

Must be a valid date.

8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Date must be on or after Original repayment date. 8300
Original Issuer BN Mandatory field. 8104
Must exist in the CDSP system. 8102
Original Issuer Transaction Number Mandatory field. 8104
Original issuer must have previously reported the transaction to the CDSP system. 8303
Original transaction must not have been in error. 8301
Original transaction must not already have been reversed. 8258
Must not be more than one reversal for the same transaction within the current processing period. 8259
Reverse Repayment Reason Mandatory field. 8104
Must be a valid reverse repayment reason. 8101

6.8.9 Record Type "401-20" Record Component Layout - Financial Information - DAP

Implementation Date - May 2010

Record Type "401-20" - DAP
Data Element Name Type Size Trxn Posn Description Notes
Record Type

X(3)

1-3

"401" - Financial Transaction

 
Transaction Type

X(2)

4-5

"20" - DAP

 
Issuer BN

X(15)

6-20

BN of issuer.

 
Issuer Transaction Number

X(15)

21-35

Unique identifier assigned to each transaction by the issuer.

 
Specimen Plan

X(7)

36-42

 

Assigned by CRA.

Contract

X(15)

43-57

 

 
Beneficiary SIN

X(9)

58-66

   
DAP Date

X(8)

67-74

The date on which the financial business was conducted with the issuer. YYYYMMDD
Contribution Portion of the Non-Taxable Formula

9(7).99

75-84

Amount by which prior contributions exceed the non-taxable portions of prior DAPs and LDAPs. Refer to Appendix D.

Variable "B" of the non-taxable formula in subsection 146.4(7) of the Income Tax Act.

Grant Portion of the DAP

9(7).99

85-94

Amount of CDS grant included in the DAP. Refer to Appendix D.

Grant will not be included in DAP transactions before 2019.
Bond Portion of the DAP 9(7).99 95-104 Amount of CDS bond included in the DAP. Refer to Appendix D. Bond will not be included in DAP transactions before 2019
Non Taxable Portion of the DAP

9(7).99

105-114

The proportion that total contributions is to the total value of the plan's assets. Refer to Appendix D.

Result of the non-taxable formula in subsection 146.4(7) of the Income Tax Act
Total DAP Amount

9(7).99

115-124

The total DAP amount.

 
DAP Retirement Savings Rollover Amount 9(7).99 125-134 Discontinued  
Filler

X(366)

135-500

Spaces

 
6.8.9.1 Record Type "401-20" Validation Rules

The "DAP" transaction type "401-20" is validated and error codes are generated for failures as outlined in the following table:

Type "401-20" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
DAP Date Mandatory field. 8104

Must be a valid date.

8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Contribution Portion of the Non-Taxable Formula Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Grant Portion of the DAP Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Bond Portion of the DAP Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Non Taxable Portion of the DAP Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Total DAP Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
DAP Retirement Savings Rollover Amount Discontinued  

6.8.10 Record Type "401-21" Record Component Layout - Financial Information - LDAP

Implementation Date - May 2010

Record Type "401-21" - LDAP
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "401" - Financial Transaction  
Transaction Type X(2) 4-5 "21" - LDAP  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
LDAP Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Contribution Portion of the Non-Taxable Formula 9(7).99 75-84 Amount by which prior contributions exceed the non-taxable portions of prior DAPs and LDAPs. Refer to Appendix D. Variable "B" of the non-taxable formula in subsection 146.4(7) of the Income Tax Act.
Grant Portion of the LDAP 9(7).99 85-94 Amount of CDS grant included in the LDAP. Refer to Appendix D. Grant not included in DAP transactions before 2019.
Bond Portion of the LDAP 9(7).99 95-104 Amount of CDS bond included in the LDAP. Refer to Appendix D. Bond not included in DAP transactions before 2019.
Non Taxable Portion of the LDAP 9(7).99 105-114 The proportion that total contributions is to the total value of the plan's assets. Refer to Appendix D. Result of the non-taxable formula in subsection 146.4(7) of the Income Tax Act.
Total LDAP Amount 9(7).99 115-124 The total LDAP amount.  
LDAP Retirement Savings Rollover Amount 9(7).99 125-134 Discontinued  
Filler X(366) 135-500 Spaces  
6.8.10.1 Record Type "401-21" Validation Rules

The "LDAP" transaction type "401-21" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-21" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
LDAP Date Mandatory field. 8104

Must be a valid date.

8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Contribution Portion of the Non-Taxable Formula Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Grant Portion of the LDAP Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Bond Portion of the LDAP Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Non Taxable Portion of the LDAP Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Total LDAP Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $1. 8109
LDAP Retirement Savings Rollover Amount Discontinued  

6.8.11 Record Type "401-22" Record Component Layout - Financial Information - DAP Reversal

Implementation Date - December 2010

Record Type "401-22" - DAP Reversal
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "401" - Financial Transaction  
Transaction Type X(2) 4-5 "22" - DAP Reversal  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
DAP Reversal Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Original Issuer BN X(15) 75-89 Issuer BN reported on the transaction to be reversed.  
Original Issuer Transaction Number X(15) 90-104 Transaction number of the transaction to be reversed.  
DAP Reversal Reason X(2) 105-106 Allowable values : '01' - Change in payment date of DAP.
'02' - Administrative Error - Incorrect DAP amount.
'03' - Administrative Error - Wrong plan.
'04' - Administrative Error - Misunderstood instructions.
'05' - Administrative Error - Input Error.
 
Filler X(394) 107-500 Spaces  
6.8.11.1 Record Type "401-22" DAP Reversal Validation Rules

The "DAP" Reversal transaction type "401-22" is validated and error codes are generated for failures as outlined in the following table:

Type "401-22" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
DAP Reversal Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Date must be on or after Original DAP Date. 8300
Original Issuer BN Mandatory field. 8104
Must exist in the CDSP system. 8102
Original Issuer Transaction Number Mandatory field. 8104
Original issuer must have previously reported the transaction to the CDSP system. 8303
Original transaction must not have been in error. 8301
Original transaction must not already have been reversed. 8258
Must not be more than one reversal for the same transaction within the current processing period. 8259
DAP Reversal Reason Mandatory field. 8104
Must be a valid DAP reversal reason. 8101

6.8.12 Record Type "401-23" Record Component Layout - Financial Information - LDAP Reversal

Implementation Date - December 2010

Record Type "401-23" - LDAP Reversal
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "401" - Financial Transaction  
Transaction Type X(2) 4-5 "23" - LDAP Reversal  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
LDAP Reversal Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Original Issuer BN X(15) 75-89 Issuer BN reported on the transaction to be reversed.  
Original Issuer Transaction Number X(15) 90-104 Transaction number of the transaction to be reversed.  
LDAP Reversal Reason X(2) 105-106 Allowable values : 01-Change in payment date of LDAP.
02-Administrative Error - Incorrect LDAP amount.
03-Administrative Error - Wrong plan.
04-Administrative Error - Misunderstood instructions.
05-Administrative Error - Input Error.
 
Filler X(394) 107-500 Spaces  
6.8.12.1 Record Type "401-23" Validation Rules

The "LDAP Reversal" transaction type "401-23" is validated and error codes are generated for failures as outlined in the following table:

Type "401-23" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
LDAP Reversal Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Date must be on or after Original LDAP Date. 8300
Original Issuer BN Mandatory field. 8104
Must exist in the CDSP system. 8102
Original Issuer Transaction Number Mandatory field. 8104
Original issuer must have previously reported the transaction to the CDSP system. 8303
Original transaction must not have been in error. 8301
Original transaction must not already have been reversed. 8258
Must not be more than one reversal for the same transaction within the current processing period. 8259
LDAP Reversal Reason Mandatory field. 8104
Must be a valid reverse LDAP reason. 8101

6.8.13 Record Type "401-30" Record Component Layout – Financial Information – Education Savings Rollover

Implementation Date – January 2014

Record Type "401-30" Financial Transaction – Education Savings Rollover
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "401" – Financial Transaction  
Transaction Type X(2) 4-5 "30" – Education Savings Rollover  
Issuer BN X(15) 6-20 BN of issuer  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
Education Savings Rollover Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Education Savings Rollover Amount 9(7).99 75-84 The amount of the Education Savings Rollover.  

Primary Caregiver SIN
Or
Agency BN

X(15) 85-99 Used to determine DTC eligibility, Canadian Residency and Family Income.

Specified only until the end of the month in which the beneficiary turns 18

9 digits when specifying a SIN of an individual, or

15 characters when specifying an Agency's BN; 9 digits + X(2) + 4 digit reference number

Primary Caregiver Given Name X(30) 100-129  

Specified only until the end of the month in which the beneficiary turns 18

Specified only when the PCG is an Individual

Primary Caregiver Surname
Or
Primary Caregiver Agency Name
X(60) 130-189   Specified only until the end of the month in which the beneficiary turns 18
Primary Caregiver Type X(1) 190-190 1 – Individual (SIN)
2 – Agency (BN)
Specified only until the end of the month in which the beneficiary turns 18
Filler X(310) 191-500 Spaces  
6.8.13.1 Record Type "401-30" Validation Rules

The Education Savings Rollover transaction type "401-30" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-30" - Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Original transaction and its reversal were found in the same processing period. 8308
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Must be designated by CRA to accept rollovers. 8262
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8235
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Education Savings Rollover Date Mandatory field. 8104
Valid date. 8100
Must be on or after January 1st 2014 8312
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
Must be within the date range the specimen plan is designated by CRA to accept rollovers. 8263
Education Savings Rollover Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than $0. 8106
Primary Caregiver SIN
Or
Agency BN
Mandatory field until the end of the month in which the beneficiary turns 18. 8104
When present, the first nine characters are numerals only. 8101
When present, the SIN or BN must be numerically valid. 8250
When PCG type = ‘2’ (Agency), must be 15 characters in length. 8101
Primary Caregiver Given Name Mandatory if PCG is present and the PCG type = ‘1’ - Individual. 8104
Primary Caregiver Surname
Or
Primary Caregiver Agency Name
Mandatory if PCG is present. 8104
Primary Caregiver Type Mandatory if PCG is present. 8104
Must be ‘1’ or ‘2.’ 8101

6.8.14 Record Type "401-31" Record Component Layout – Financial Information – Education Savings Rollover Reversal

Implementation Date – January 2014

Record Type "401-31" Financial Transaction – Education Savings Rollover Reversal
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "401" – Financial Transaction  
Transaction Type X(2) 4-5 "31" – Education Savings Rollover Reversal  
Issuer BN X(15) 6-20 BN of issuer  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
Education Savings Rollover Date X(8) 67-74 The date on which the financial business was conducted with the issuer. YYYYMMDD
Original Issuer BN X(15) 75-89 Issuer BN reported on the transaction to be reversed.  
Original Issuer Transaction Number X(15) 90-104 Transaction number of the transaction to be reversed.  
Filler X(396) 105-500 Spaces  
6.8.14.1 Record Type "401-31" Validation Rules

The Education Savings Rollover Reversal transaction type "401-31" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "401-31" - Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Education Savings Rollover Reversal Date Mandatory field. 8104
Valid date. 8100

Date must be within the dates the issuer is eligible.

8207

Date must be on or before the current reporting period end date.

8201
Must be on or after original Rollover date 8300
Original Issuer BN

Mandatory field.

8104
Must exist in the CDSP system. 8102
Original Issuer Transaction Number

Mandatory field.

8104
Original issuer must have previously reported the transaction to the CDSP system. 8303
Original transaction and its reversal were found in the same processing period. 8308
Error in original transaction, current transaction cannot be processed. 8301

Original transaction must not already have been reversed.

8258
Must not be more than one reversal for the same transaction within the current processing period 8259

6.9 Record Type "501" - Reporting Transactions

Record type 501 is used by the issuer to report election information. There are four (4) election types reported : "01" Episodic DTC Election; "02" Episodic DTC Election Reversal; "03" SDSP Election; "04" SDSP Election Reversal.

PURPOSE: These transactions are reported in order to establish a record of Episodic DTC and SDSP elections in the CDSP system or to remove previously reported elections.

REQUIREMENTS: Record type "501" must refer to the contract number and beneficiary named on the election. Once an election is established, grant and bond requests must no longer be forwarded to the CDSP system and no new grant and bond will be paid into the plan for the duration of the election.

6.9.1 Record Type "501-01" Record Component Layout - Episodic DTC Election

Implementation Date - January 2014

Record Type "501-01" – Episodic DTC Election

Data Element Name

Type Size

Trxn Posn

Description

Notes

Record Type

X(3)

1-3

"501" – Election

 
Transaction Type

X(2)

4-5

"01" – Episodic DTC Election

 
Issuer BN

X(15)

6-20

BN of issuer.

 
Issuer Transaction Number

X(15)

21-35

Unique identifier assigned to each transaction by the issuer.

 
Specimen Plan

X(7)

36-42

 

Assigned by CRA.

Contract

X(15)

43-57

   
Beneficiary SIN

X(9)

58-66

   
Certification Date

X(8)

67-74

Medical Doctor certification date. YYYYMMDD
Episodic DTC Election Transaction Date

(8)

75-82

The date on which the transaction was conducted with the issuer. YYYYMMDD
Filler X(418) 83-500 Spaces  
6.9.1.1 Record Type "501-01" Validation Rules

The Episodic DTC Election transaction type "501-01" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "501-01" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)

The issuer transaction number must be unique for each issuer.

Severe error (1)
Original transaction and its reversal were found in the same processing period. 8308
Specimen Plan Mandatory field. 8104

Specimen plan must exist in the CDSP system database.

8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104

Contract must be associated to the specimen plan.

8235

Contract must be associated to the beneficiary.

8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Certification Date Mandatory field. 8104
Valid date. 8100

Date must be within the dates the issuer is eligible.

8207

Date must be on or before the current reporting period end date.

8201

Date must be on or after beneficiary's date of birth.

8203

Date must be on or after contract signature date.

8206

Beneficiary must not be DTC Ineligible for 5 consecutive years on or after the contract signature year and before the year of election request processing.

8310
The resulting Episodic DTC election period must not overlap with an existing Episodic DTC election period for the same contract. 8311
Episodic DTC Election Transaction Date Mandatory field. 8104

Valid date.

8100
Date must be on or after the Certification Date. 8309

6.9.2 Record Type "501-02" Record Component Layout – Episodic DTC Election Reversal

Implementation Date - January 2014

Record Type "501-02" – Episodic DTC Election Reversal
Data Element Name Type Size Trxn Posn Description Notes
Record Type

X(3)

1-3

"501" – Election

 
Transaction Type X(2) 4-5 "02" – Episodic DTC Election Reversal  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
Episodic DTC Election Reversal Transaction Date X(8) 67-74 The date on which the transaction was conducted with the issuer. YYYYMMDD
Original Issuer BN X(15) 75-89 Issuer BN reported on the transaction to be reversed.  
Original Issuer Transaction Number X(15) 90-104 Transaction number of the transaction to be reversed.  
Filler X(396) 105-500 Spaces  
6.9.2.1 Record Type "501-02" Validation Rules

The "Episodic DTC Election Reversal" transaction type "501-02" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "701-02" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen plan Mandatory field. 8104

Specimen plan must exist in the CDSP system database.

8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104

Contract must be associated to the specimen plan.

8235

Must be associated to the beneficiary.

8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Episodic DTC Election Reversal Transaction Date Mandatory field. 8104

Valid date.

8100
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Must be on or after original Episodic DTC Election Transaction Date. 8300
Original Issuer BN

Mandatory field.

8104
Must exist in the CDSP system. 8102
Original Issuer Transaction Number

Mandatory field.

8104
Original issuer must have previously reported the transaction to the CDSP system. 8303

Original transaction must not have been in error

8301

Original transaction must not already have been reversed.

8258

Must not be more than one reversal for the same transaction within the current processing period.

8259
Original transaction and its reversal were found in the same processing period. 8308

6.9.3 Record Type "501-03" Record Component Layout – SDSP Election

Implementation Date - January 2014

Record Type "501-03" – SDSP Election
Data Element Name Type Size Trxn Posn Description Notes
Record Type

X(3)

1-3

"501" – Election

 
Transaction Type X(2) 4-5 "03" – SDSP Election  
Issuer BN X(15) 6-20 BN of issuer  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
SDSP Election Transaction Date X(8) 67-74 The date on which the transaction was conducted with the issuer. YYYYMMDD
Filler X(426) 75-500 Spaces  
6.9.3.1 Record Type "501-03" Validation Rules

The SDSP Election transaction type "501-03" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "501-03" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)

Must be 15 characters.

Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)

The issuer transaction number must be unique for each issuer.

Severe error (1)
Original transaction and its reversals were found in the same processing period. 8308
Specimen Plan Mandatory field. 8104

Specimen plan must exist in the CDSP system database.

8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104

Contract must be associated to the specimen plan.

8235

Contract must be associated to the beneficiary.

8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
SDSP Election Transaction Date

Mandatory field.

8104
Valid date. 8100

Date must be within the dates the issuer is eligible.

8207

Date must be on or before the current reporting period end date.

8201

Date must be on or after beneficiary's date of birth.

8203
Date must be on or after contract signature date. 8206

6.9.4 Record Type "501-04" Record Component Layout – SDSP Election Reversal

Implementation Date - January 2014

Record Type "501-04" – SDSP Election Reversal
Data Element Name Type Size Trxn Posn Description Notes
Record Type

X(3)

1-3

"501" – Election

 
Transaction Type X(2) 4-5 "04" – SDSP Election Reversal  
Issuer BN X(15) 6-20 BN of issuer  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA
Contract X(15) 43-57    
Beneficiary SIN X(9) 58-66    
SDSP Election Reversal Transaction Date X(8) 67-74 The date on which the transaction was conducted with the issuer. YYYYMMDD
Original Issuer BN X(15) 75-89 Issuer BN reported on the transaction to be reversed.  
Original Issuer Transaction Number X(15) 90-104 Transaction number of the transaction to be reversed.  
Filler X(396) 105-500 Spaces  
6.9.4.1 Record Type "501-04" Validation Rules

The SDSP Election Reversal transaction type "501-04" is validated and error codes are generated for failures as outlined in the following table and notes:

Type "501-04" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)

Must be 15 characters.

Severe error (4)
The issuer BN must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104

Specimen plan must exist in the CDSP system database.

8102

Specimen plan must be associated with the issuer.

8222

Agent must be authorized to send data for the specimen plan.

8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104

Contract must be associated to the specimen plan.

8235

must be associated to the beneficiary.

8236
Contract must not be nullified. 8255
Beneficiary SIN Mandatory field. 8104

Numerals (9) only.

8101
Must exist in the CDSP system database. 8102
SDSP Election Transaction Date

Mandatory field.

8104
Valid date. 8100

Date must be within the dates the issuer is eligible.

8207

Date must be on or before the current reporting period end date.

8201

Must be on or after original SDSP Election Transaction date.

8300
Original Issuer BN Mandatory field. 8104
Must exist in the CDSP system 8102
Original Issuer Transaction Number Mandatory field. 8104
Original issuer must have previously reported the transaction to the CDSP system. 8303
Original transaction must not have been in error. 8301
Original transaction must not already have been reversed. 8258
Must not be more than one reversal for the same transaction within the current processing period. 8259
Original transaction and its reversal were found in the same processing period. 8308

6.10 Record Type "701" - Reporting Transactions

Record type 701 is used by the issuer to meet the reporting requirements of the RDSP program. There are two (2) types of reporting transactions; "01" - Monthly Reporting of FMV, and "02" - Reporting of FMV and Earnings when the relinquishing issuer is transferring a contract.

PURPOSE: Issuers use these record types to report all required RDSP financial activity that has occurred on a registered contract.

REQUIREMENTS: The record type "701" will refer to the contract number of the contract and the date on which the reporting transaction occurs at the issuer.

6.10.1 Record Type "701-01" Record Component Layout - Reporting Information- Monthly Reporting of FMV

Implementation Date - June 2010

Record Type "701-01"- Monthly Reporting of FMV
Data Element Name Type Size Trxn Posn Description Notes
Record Type X(3) 1-3 "701" - Financial Transaction  
Transaction Type X(2) 4-5 "01" - Monthly reporting of FMV  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57 Issuer's contract number.  
Beneficiary SIN X(9) 58-66    
Reporting Date X(8) 67-74 Date on which the financial data was reported by the issuer. YYYYMMDD
FMV Amount 9(7).99 75-84 Fair Market Value of contract.  
Filler X(416) 85-500 Spaces  
6.10.1.1 Record Type "701-01" Validation Rules

The Monthly Reporting transaction 701-01 is validated and error codes are generated for failures as outlined in the following table and notes:

Type "701-01" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must be registered. 8241
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Reporting Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
FMV Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108

6.10.2 Record Type "701-02" Record Component Layout - Transfer Reporting of FMV and Earnings Amounts

Implementation Date - June 2010

Record Type "701-02" - Reporting Transfer Information Transaction
Data Element Name Type Size Trxn Posn Description Notes
Record Type

X(3)

1-3

"701" - Financial Transaction

 
Transaction Type X(2) 4-5 "02" - Transfer reporting of FMV and Earnings  
Issuer BN X(15) 6-20 BN of issuer.  
Issuer Transaction Number X(15) 21-35 Unique identifier assigned to each transaction by the issuer.  
Specimen Plan X(7) 36-42   Assigned by CRA.
Contract X(15) 43-57 Issuer's contract number.  
Beneficiary SIN X(9) 58-66    
Reporting Date X(8) 67-74 Date on which the financial data was reported by the issuer. YYYYMMDD
FMV Amount 9(7).99 75-84 Fair Market Value of contract.  
Earnings 9(7).99 85-94 Amount of Interest Earned.  
Filler X(406) 95-500 Spaces  
6.10.2.1 Record Type "701-02" Validation Rules

The Transfer Reporting transaction 701-02 is validated and error codes are generated for failures as outlined in the following table and notes:

Type "701-02" Validation Rules
Field Rule Error Code(s)
Record Type Mandatory field. Severe error (2)
Transaction Type Mandatory field. Severe error (2)
The transaction type must be valid for the record type. Severe error (2)
Issuer BN Mandatory field. Severe error (4)
Must be 15 characters. Severe error (4)
Must exist in the CDSP system database. 8102
Issuer Transaction Number Mandatory field. Severe error (3)
The issuer transaction number must be unique for each issuer. Severe error (1)
Specimen Plan Mandatory field. 8104
Specimen plan must exist in the CDSP system database. 8102
Specimen plan must be associated with the issuer. 8222
Agent must be authorized to send data for the specimen plan. 8221
Specimen plan must be valid. 8220
Contract Mandatory field. 8104
Contract must be associated to the specimen plan. 8256
Contract must be associated to the beneficiary. 8236
Contract must have a status of Registered or closed. 8260
Beneficiary SIN Mandatory field. 8104
Numerals (9) only. 8101
Must exist in the CDSP system database. 8102
Reporting Date Mandatory field. 8104
Must be a valid date. 8100
Date must be on or after Dec 1st, 2008. 8200
Date must be within the dates the issuer is eligible. 8207
Date must be on or before the current reporting period end date. 8201
Date must be on or after beneficiary's date of birth. 8203
Date must be on or after contract signature date. 8206
FMV Amount Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
Earnings Mandatory field. 8104
Numerals only. 8101
Amount must be greater than or equal to $0. 8108
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: