EBA STEP2 Routing Tables - Mapping

File Types Supported

File Name File Types Supported File Formats Supported File Naming Conventions

SCT Direct Participant Routing Table

FULL

TXT

S204SCTBBBBBBBBYYMMDDHHMMSSDNN.T

SCT Reachable BIC Routing Table

FULL

TXT

S204SCTBBBBBBBBYYMMDDHHMMSSINN.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 SCT Direct Participant Routing Table Mapping (Direct Participants) SCT Reachable BIC Routing Table Mapping (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 = "STEP2 SCT"

Value = "STEP2 SCT"

csmMemberId

 — 

 — 

csmParticipantIdentifier

DP BIC

RB BIC

participantName

DP Name

RB Name

routingBIC

 — 

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

Value = false, if STATUS = ENABLED

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

Value = true, if STATUS = CHANGED

Value = false, if STATUS = ENABLED

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

Values - ENABLED, SUSPENDED, DISABLED, CHANGED

The statuses SUSPENDED and DISABLED are not loaded on the CSM Participants.

directParticipantDetails.csmMemberId

 — 

 — 

directParticipantDetails. participantIdentifiers.identifier

 — 

DP BIC

directParticipantDetails. participantIdentifiers.identifierType

 — 

Value = "BIC"

directParticipantDetails. participantIdentifiers.identifierSubType

 — 

Value = "SCHEME-MEMBERSHIP_BIC"

routingDetails.routingPurpose

Value = "Standard"

Value = "Standard"

routingDetails.csmMemberId

 — 

 — 

routingDetails. routingIdentifiers.identifier

DP BIC

DP 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

The Payment Type Allowed column may repeat up to 10 times for each successive product that the BIC may use. Format is 3 alphanumeric, e.g. A01, A03, C00, C01 and ERI.

industryFields

 — 

 — 

Example Mappings

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

SCT DIRECT PARTICIPANT ROUTING TABLE


SEARCH CRITERIA
BIC	NAME	DATE FROM	DATE TO	STATUS	MATCHING RECORDS
        	                                                  	        	        	ALL      	 426

RESULTS
BIC	NAME	INIT DATE	END DATE	SETTLEMENT BIC	STATUS	PAYMENT TYPE ALLOWED
AABBCCD1	AEGON BANCA                                       	20180723	20180923	AABBCCD1XXX	ENABLED
AAKRDK20	BANK OF ALAND PLC                                 	20101001	20160210	AAKRDK21XXX	ENABLED  	C00	C01

Destination Record - CSM Participant

{
  "_id": "DynamicSettings|participant-STEP2-AABBCCD1",
  "payload": {
    "csmAgentId": "STEP2 SCT",
    "csmParticipantIdentifier": "AABBCCD1",
    "participantName": "AEGON BANCA",
    "participantCountry": "FR",
    "activeFromDate": {
      "$date": "2018-07-23T00:00:00.000Z"
    },
    "activeToDate": {
      "$date": "2018-09-23T00:00:00.000Z"
    },
    "participantType": "DIRECT",
    "paymentTypeAllowedList": [
      "C00"
    ],
    "rMessageOnly": false,
    "routingDetails": [
      {
        "routingPurpose": "STANDARD",
        "routingIdentifiers": [
          {
            "identifier": "AABBCCD1",
            "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

SCT DIRECT PARTICIPANT ROUTING TABLE


SEARCH CRITERIA
BIC	NAME	DATE FROM	DATE TO	STATUS	MATCHING RECORDS
        	                                                  	        	        	ALL      	 426

RESULTS
BIC	NAME	INIT DATE	END DATE	SETTLEMENT BIC	STATUS	PAYMENT TYPE ALLOWED
AABBCCD1	AEGON BANCA                                       	20180723	20180923	AABBCCD1XXX	ENABLED
AAKRDK20	BANK OF ALAND PLC                                 	20101001	20160210	AAKRDK21XXX	ENABLED  	C00	C01

Destination Record - CSM Participant

{
  "_id": "DynamicSettings|participant-STEP2-AABBCCD1",
  "payload": {
    "csmAgentId": "STEP2 SCT",
    "csmParticipantIdentifier": "AABBCCD1",
    "participantName": "AEGON BANCA",
    "routingBIC": "BNPAFRPPXXX",
    "activeFromDate": {
      "$date": "2021-11-09T00:00:00.000Z"
    },
    "activeToDate": {
      "$date": "9999-12-31T00:00:00.000Z"
    },
    "participantType": "INDIRECT",
    "rMessageOnly": false,
    "routingDetails": [
      {
        "routingPurpose": "STANDARD",
        "routingIdentifiers": [
          {
            "identifier": "AABBCCD1",
            "identifierType": "BIC",
            "identifierSubType": "SCHEME_MEMBERSHIP_BIC"
          }
        ]
      }
    ],
    "directParticipantDetails": {
      "participantIdentifiers": [
        {
          "identifier": "AABBCCD1",
          "identifierType": "BIC",
          "identifierSubType": "SCHEME_MEMBERSHIP_BIC"
        }
      ]
    }
  },
  "version": 1,
  "status": "ACTIVE",
  "processingEntity": "UNKNOWN",
  "_class": "com.iconsolutions.ipf.dynamicsettings.repository.ParticipantSettings"
}