EBA RT1 SEPA INST - Routing Tables Mapping

Bellow table provides information about File type supported and File format.

File Types Supported

File Name File Types Supported File Formats Supported File Naming Conventions

SCI Participant Routing Table

FULL

TXT

RT01SCIBBBBBBBBYYMMDDHHMMSSDNN.T

SCI Addressable PSP Routing Table

FULL

TXT

RT01SCIBBBBBBBBYYMMDDHHMMSSINN.T
BBBBBBBB is the BIC(8) of the Direct Participant or of the Preferred Agent configured for the CGS Settlement BIC. YYMMDDHHMMSS is the file creation date and time. NN is the incremental number reset for every file creation date. T indicates the type of the file (RTF file). Highlighted part of the file name is used to identify the file during ingestion for AWS S3 ingestion.
The client implementations should not modify the files names provided by industry sources and ingest the files as received.

Mapping Definitions

CSM Participant Attribute SCI Participant Routing Table (Direct Participants) SCI Addressable PSP Routing Table (Indirect Participants) Comment

ProcessingEntity

Value = UNKNOWN

Value = UNKNOWN

This is an attribute provided through use of DPS for dynamic config management. Industry data are global dynamic configurations and available to all processing entities.

csmAgentId

Value = "RT1"

Value = "RT1"

csmMemberId

 — 

 — 

csmParticipantIdentifier

P/LSP BIC

AP BIC

participantName

NAME

AP NAME

routingBIC

P/LSP BIC

P/LSP BIC

RoutingBIC mapping is being retained for backward compatibility purposes. The attribute has been deprecated and will be removed in future releases.

domicileAddress

 — 

 — 

postalAddress

 — 

 — 

postalCode

 — 

 — 

participantCity

 — 

 — 

participantCountry

 — 

 — 

activeFromDate

INIT DATE

INIT DATE

activeToDate

END DATE

END DATE

participantType

Value = "DIRECT"

Value = "INDIRECT"

rMessageOnly

Value = true, if STATUS = CHANGED, R-ONLY

Value = false, if STATUS = ENABLED

Default = false (If not specified on CSM Participant record)

Value = true, if STATUS = CHANGED, R-ONLY

Value = false, if STATUS = ENABLED

Default = false (If not specified on CSM Participant record)

Values - ENABLED, SUSPENDED, R-ONLY, CHANGED

The status of SUSPENDED is not loaded on the CSM Participants.

directParticipantDetails.csmMemberId

 — 

 — 

directParticipantDetails. participantIdentifiers.identifier

 — 

P/LSP BIC

directParticipantDetails. participantIdentifiers.identifierType

 — 

Value = "BIC"

directParticipantDetails. participantIdentifiers.identifierSubType

 — 

Value = "SCHEME-MEMBERSHIP_BIC"

routingDetails.routingPurpose

Standard

Standard

routingDetails.csmMemberId

 — 

 — 

routingDetails. routingIdentifiers.identifier

P/LSP BIC

P/LSP BIC

routingDetails. routingIdentifiers.identifierType

Value = "BIC"

Value = "BIC"

routingDetails. routingIdentifiers.identifierSubType

Value = "SCHEME-MEMBERSHIP_BIC"

Value = "SCHEME-MEMBERSHIP_BIC"

limits.limitType

 — 

 — 

limits.amount.amountValue

 — 

 — 

limits.amount.currency

 — 

 — 

paymentTypeAllowedList

PaymentTypeAllowedList

PaymentTypeAllowedList

Can be up to 5 values

industryFields

 — 

 — 

Example Mapping

The example records documented here are representational and do not confirm the participation of the entities with the CSM Agent, client implementations should use the files provided by industry data source for getting correct membership data.

Direct Participant

Source Record from Industry file

SCI PARTICIPANT ROUTING TABLE


SEARCH CRITERIA
P/LSP BIC	NAME	DATE FROM	DATE TO	STATUS	MATCHING RECORDS
        	                                                  	        	        	ALL      	 192

RESULTS
P/LSP BIC	NAME	INIT DATE	END DATE	TIPS ACCOUNT OWNER BIC	STATUS	PAYMENT TYPE ALLOWED
AABAFI22	Bank of Aland Plc                                 	20210907	99991231	AABAFI22XXX	ENABLED
ABKSDEFF	ABK                                               	20171211	99991231	ABKSDEFFXXX	ENABLED  	TEC
BARCDEF0	Barclays Bank Ireland PLC Frankfurt Branch        	20190425	20210928	BARCDEFFTIP	CHANGED

Destination Record - CSM Participant

{
  "_id": "DynamicSettings|participant-RT1-AABAFI22XXX",
  "payload": {
    "csmAgentId": "RT1",
    "csmParticipantIdentifier": "AABAFI22XXX",
    "routingBic": "AABAFI22",
    "participantName": "Bank of Aland Plc",
    "participantCountry": "FR",
    "activeFromDate": {
      "$date": "2008-01-28T00:00:00.000Z"
    },
    "participantType": "DIRECT",
    "paymentTypeAllowedList": [
      "TEC"
    ],
    "rMessageOnly": false,
    "routingDetails": [
      {
        "routingPurpose": "STANDARD",
        "routingIdentifiers": [
          {
            "identifier": "AABAFI22",
            "identifierType": "BIC",
            "identifierSubType": "SCHEME_MEMBERSHIP_BIC"
          }
        ]
      }
    ],
    "directParticipantDetails": null
  },
  "version": 1,
  "status": "ACTIVE",
  "processingEntity": "UNKNOWN",
  "_class": "com.iconsolutions.ipf.dynamicsettings.repository.ParticipantSettings"
}

Indirect Participant

Source Record from Industry file

SCI ADDRESSABLE PSP ROUTING TABLE


SEARCH CRITERIA
AP BIC	AP NAME	DATE FROM	DATE TO	P/LSP BIC	STATUS	MATCHING RECORDS
           	                                                  	        	        	           	ALL      	 711

RESULTS
AP BIC	AP NAME	INIT DATE	END DATE	P/LSP BIC	TIPS ACCOUNT OWNER BIC	STATUS	PAYMENT TYPE ALLOWED
ABKSDEFFRT1	ABK RT1 PSP                                       	20180109	99991231	ABKSDEFF	ABKSDEFFXXX	ENABLED  	NLA
ADWSGB22XXX	Advanced Wallet Solutions Limited                 	20191017	99991231	LIABLT2X	LIABLT2XDCA	ENABLED
AGRIFRPP802	CAISSE REGIONALE DE CREDIT AGRICOLE MUTUEL DU NORD	20190718	99991231	AGRIFRPP	AGRIFRPPXXX	R-ONLY

Destination Record - CSM Participant

{
  "_id": "DynamicSettings|participant-RT1-ABKSDEFFXXX",
  "payload": {
    "csmAgentId": "RT1",
    "csmParticipantIdentifier": "ABKSDEFFRT1",
    "participantName": "ABK RT1 PSP",
    "routingBIC": "ABKSDEFFXXX",
    "activeFromDate": {
      "$date": "2021-11-09T00:00:00.000Z"
    },
    "participantType": "INDIRECT",
    "rMessageOnly": false,
    "routingDetails": [
      {
        "routingPurpose": "STANDARD",
        "routingIdentifiers": [
          {
            "identifier": "ABKSDEFFXXX",
            "identifierType": "BIC",
            "identifierSubType": "SCHEME_MEMBERSHIP_BIC"
          }
        ]
      }
    ],
    "directParticipantDetails": {
      "participantIdentifiers": [
        {
          "identifier": "ABKSDEFFXXX",
          "identifierType": "BIC",
          "identifierSubType": "SCHEME_MEMBERSHIP_BIC"
        }
      ]
    }
  },
  "version": 1,
  "status": "ACTIVE",
  "processingEntity": "UNKNOWN",
  "_class": "com.iconsolutions.ipf.dynamicsettings.repository.ParticipantSettings"
}