Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "dataFeeds": [
- {
- "dataFeedId": "bb210b82-7108-4cfe-b763-a9e265a24558",
- "name": "COLLATERALS",
- "description": "Collaterals data feed",
- "source": {
- "name": "COLLATERALS",
- "description": "Collaterals data source",
- "notes": "",
- "extract": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "payload": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "controls": {
- "enforceSchemaValidation": false,
- "schema": {}
- }
- },
- "streams": [
- {
- "streamId": "8d2aaa69-5206-4e0b-b145-9267f8b422c0",
- "name": "Collaterals",
- "description": "Collaterals data stream",
- "target": {
- "sinkId": "2577866c-5c28-4d4b-b733-ad3282ff4bb0",
- "sinkName": "Collaterals"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "3d96e51d-627f-45c3-8dbc-201b3489d031",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "CollateralId",
- "transformations": [
- {
- "type": "CollateralId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "ORIGIN_COLLATERAL",
- "comment": "type = 3 (loan deposit) & 5 (collateral), get value from L2_COLLATERAL.IDE_POSITION_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "OriginCollateralId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "ORIGIN_COLLATERAL",
- "comment": "type = 3 (loan deposit) & 5 (collateral), get value from L2_COLLATERAL.IDE_POSITION_REF"
- }
- }
- ]
- },
- {
- "toProperty": "OriginSystemId",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "GDM_COLLATERALS"
- }
- ]
- },
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- },
- {
- "toProperty": "Currency",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CCY_ISO_CURRENCY"
- }
- ]
- },
- {
- "toProperty": "CollateralType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_COLLATERAL"
- }
- ]
- },
- {
- "toProperty": "CollateralAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "OCA_AMOUNT"
- }
- ]
- },
- {
- "toProperty": "AppraisalDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_VALUE"
- }
- ]
- },
- {
- "toProperty": "CollateralLinks",
- "transformations": [
- {
- "type": "Array",
- "fromProperty": "CONTRACTS",
- "array": [
- {
- "toProperty": "ContractId",
- "transformations": [
- {
- "type": "ContractId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "parent.VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "ORIGIN_CONTRACT",
- "comment": "type = 3 (loan deposit) get value from L2_LOAN_DEPOSIT.IDE_POSITION_REF | type = 5 (collateral), get value from L2_COLLATERAL.IDE_CONTRACT_REF"
- }
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "toProperty": "CollateralTypeProperty",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "CollateralMaturityDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_MATURITY"
- }
- ]
- }
- ]
- }
- ]
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "2f0c993b-e031-4e90-91d8-23fef020e8c4",
- "qualityProfileName": "Collaterals",
- "qualityProfileDescription": "Collaterals data quality profile"
- }
- }
- ]
- },
- {
- "dataFeedId": "5361e4ae-86c5-45eb-833b-5b3ed7bf6e25",
- "name": "COUNTERPARTY",
- "description": "Counterparty data feed",
- "source": {
- "name": "COUNTERPARTY",
- "description": "Counterparty data source",
- "notes": "",
- "extract": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "payload": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "controls": {
- "enforceSchemaValidation": false,
- "schema": {}
- }
- },
- "streams": [
- {
- "streamId": "4c248de9-f61e-488f-b6d1-94b0626a2c0e",
- "name": "Counterparty",
- "description": "Counterparty data stream",
- "target": {
- "sinkId": "c39b1b08-740e-44ae-a2f8-1fcc49cb5ef8",
- "sinkName": "Counterparties"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "b1611b6f-4d11-4d0c-a513-73675c017933",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "CounterpartyId",
- "transformations": [
- {
- "type": "CounterpartyId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- },
- {
- "toProperty": "Name",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DES_LONGNAME",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginCounterpartyId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- },
- {
- "toProperty": "OriginSystemId",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "Apply fixed value to GDM_SECURITY",
- "fromValue": "GDM_COUNTERPARTY"
- }
- ]
- },
- {
- "toProperty": "CounterpartyType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_CPTY_TYPE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EnterpriseSize",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_ENTERPRISE_SIZE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BusinessUnit",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- }
- ]
- }
- ]
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "15a82033-4c7b-4ebc-9621-e29b3b5b3ccd",
- "qualityProfileName": "Counterparty",
- "qualityProfileDescription": "Counterparty data quality profile"
- }
- },
- {
- "streamId": "1560e553-993b-4835-8940-2aa73a4d4d34",
- "name": "Counterparty Props",
- "description": "Counterparty props data stream",
- "target": {
- "sinkId": "bbde8d1d-3920-4d34-ab0b-04e46be0d5f8",
- "sinkName": "Counterparty Properties Bag"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "c1d3c71f-08a7-42b7-91c4-d62e6a9b1f75",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "CounterpartyId",
- "transformations": [
- {
- "type": "CounterpartyId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "PropertyBag",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "CounterpartyProps"
- }
- ]
- },
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- },
- {
- "toProperty": "OriginCounterpartyId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- },
- {
- "toProperty": "EnterpriseSize",
- "description": "",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_ENTERPRISE_SIZE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "NonResidentialExposure",
- "description": "",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "NON_RESIDENTIAL_EXPOSURE",
- "comment": ""
- }
- ]
- }
- ]
- }
- ]
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "12679780-7226-4d9b-9235-186d5235a47c",
- "qualityProfileName": "Counterparty Props",
- "qualityProfileDescription": "Counterparty props data quality profile"
- }
- }
- ]
- },
- {
- "dataFeedId": "6704978f-0343-4a18-bfe2-0bb1a6de537a",
- "name": "CUSTOMER-ACCOUNT",
- "description": "Customer account data feed",
- "source": {
- "name": "GDM-CUSTOMER-ACCOUNT",
- "description": "Customer account data source",
- "notes": "",
- "extract": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "payload": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "controls": {
- "enforceSchemaValidation": false,
- "schema": {}
- }
- },
- "streams": [
- {
- "streamId": "95acadac-ee43-4d2e-8772-2285dac58a59",
- "name": "Customer Account",
- "description": "Customer account data stream",
- "target": {
- "sinkId": "6c705dfd-eace-4cc1-89be-396e6a8c87eb",
- "sinkName": "Contracts"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "98086c97-7a4e-436e-8347-513eb3c9468a",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "ContractId",
- "transformations": [
- {
- "type": "ContractId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_POSITION_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "CounterpartyId",
- "transformations": [
- {
- "type": "CounterpartyId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- },
- {
- "toProperty": "Entity",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_PARTY_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Aslb",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_AL_INDICATOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginContractId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_POSITION_REF"
- }
- }
- ]
- },
- {
- "toProperty": "OriginSystemId",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "GDM_CUSTOMER_ACCOUNT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_ONE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductSubtype",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_TWO",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BusinessUnit",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginCounterpartyId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- },
- {
- "toProperty": "BaseLgd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BasePd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CreditRating",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CreditRatingAgency",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Collectibility",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsRestructured",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "false",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Currency",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CCY_ISO_CURRENCY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CurrentPd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DaysPastDue",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DiscountRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRateIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Segment",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "AUDIT_INFO",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsSecured",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "true",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InitialPd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_AAR_INTEREST",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestSpread",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RTE_SPREAD",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "InterestCurve",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "StartDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_DEAL",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "MaturityDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_NEXT_INT_FIX",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PrincipalAmount",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT401",
- "comment": ""
- },
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "OutstandingAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1_150",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OutstandingAmountIrrbb",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "LimitAmount",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "UndrawnAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT17",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "AccruedInterest",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT20",
- "comment": ""
- },
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT57",
- "comment": ""
- },
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT58",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "PenaltyInterest",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- },
- {
- "toProperty": "PresentValue",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PresentValueIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "PRD_PRODUCT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "NextRepricingDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_NEXT_INT_FIX",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestPaymentFreq",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INTEREST_PAY_FREQUENCY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ContractRef",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_CONTRACT_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CapRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_CAP",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "FloorRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_FLOOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "AssetLiabIndicator",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_AL_INDICATOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRefixFreq",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INT_REFIX_FREQ",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRateType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INTEREST_RATE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PerformingStatus",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_NON_PERFORMING",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Duration",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "BrokerRef",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_BROKER_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "TypeOfLaw",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_THREE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Phase",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "Purpose",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "ExposureClass",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_EXPOSURE_CLASS",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "NaceType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_NACE2",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "RiskIndicator",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_RISK_QUAL_INDIC",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EconomicSector",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CDE_ECONOMICAL_SECTOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EligibleType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_ELIGIBLE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "RestructuredType",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ClientMonitType",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- }
- ]
- }
- ]
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "35ec060d-e4f2-4673-907c-b796f1e69e44",
- "qualityProfileName": "Contracts",
- "qualityProfileDescription": "Contracts data quality profile"
- }
- }
- ]
- },
- {
- "dataFeedId": "0f4806e0-800c-49c6-b9a4-451c3e0c48ec",
- "name": "GENERAL-LEDGER",
- "description": "General ledger data feed",
- "source": {
- "name": "GDM-GENERAL-LEDGER",
- "description": "General ledger data source",
- "notes": "",
- "extract": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "payload": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "controls": {
- "enforceSchemaValidation": false,
- "schema": {}
- }
- },
- "streams": [
- {
- "streamId": "0e87875d-347c-4822-b72f-059f11f3b467",
- "name": "General Ledger",
- "description": "General ledger data stream",
- "target": {
- "sinkId": "6c705dfd-eace-4cc1-89be-396e6a8c87eb",
- "sinkName": "Contracts"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "23e15c5d-e8b6-4c0d-bde2-b855460ba3c9",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "ContractId",
- "transformations": [
- {
- "type": "ContractId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "PRD_PRODUCT"
- }
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "CounterpartyId",
- "transformations": [
- {
- "type": "CounterpartyId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- },
- {
- "toProperty": "Entity",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_PARTY_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Aslb",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_AL_INDICATOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginContractId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "PRD_PRODUCT"
- }
- }
- ]
- },
- {
- "toProperty": "OriginSystemId",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "GDM_GENERAL_LEDGER",
- "comment": "Apply fixed value to GDM_GENERAL_LEDGER"
- }
- ]
- },
- {
- "toProperty": "ProductType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "PRD_PRODUCT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductSubtype",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "PRD_PRODUCT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BusinessUnit",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginCounterpartyId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- },
- {
- "toProperty": "BaseLgd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BasePd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CreditRating",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CreditRatingAgency",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Collectibility",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsRestructured",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_RESTRUCTURED",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Currency",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CCY_ISO_CURRENCY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CurrentPd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DaysPastDue",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DiscountRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRateIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Segment",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsSecured",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "true",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InitialPd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestSpread",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestCurve",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "StartDate",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "DTE_DEAL",
- "comment": ""
- },
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "MaturityDate",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "DTE_MATURITY",
- "comment": ""
- },
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "PrincipalAmount",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "OutstandingAmount",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "LimitAmount",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "UndrawnAmount",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "AccruedInterest",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PenaltyInterest",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PresentValue",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PresentValueIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "PRD_PRODUCT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ContractRef",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_CONTRACT_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "AssetLiabIndicator",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_AL_INDICATOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "GlCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_GL_REF",
- "comment": ""
- }
- ]
- }
- ]
- }
- ]
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "bf265b73-f3ac-4841-91d2-d3f02d65f1a7",
- "qualityProfileName": "Contracts GL",
- "qualityProfileDescription": "Contract GL data quality profile"
- }
- }
- ]
- },
- {
- "dataFeedId": "c19907e6-edaa-44cf-8622-027aedceaee2",
- "name": "HISTORICAL-CONTRACT",
- "description": "Historical contract data feed",
- "source": {
- "name": "HISTORICAL-CONTRACT",
- "description": "Historical contract data source",
- "notes": "",
- "extract": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "payload": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "controls": {
- "enforceSchemaValidation": false,
- "schema": {}
- }
- },
- "streams": [
- {
- "streamId": "9af9d620-0fb7-4671-ad71-f46db604d214",
- "name": "Historical Contracts",
- "description": "Historical contract data stream",
- "target": {
- "sinkId": "53f7ddc2-e1c1-4b61-b43f-049395d7657e",
- "sinkName": "Historical Contract Docs"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "2ae3fe09-9d3c-4503-a709-c0ef52329b4d",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "ContractId",
- "transformations": [
- {
- "type": "HistoricalContractId",
- "comment": "",
- "parameters": [
- {
- "type": "Trim",
- "parameter": {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_POSITION_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "DatasetName",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "",
- "fromValue": "Historical-Contract"
- }
- ]
- },
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "OBSERVATION_DATE"
- }
- ]
- },
- {
- "toProperty": "HistoricalContractObservationItems",
- "transformations": [
- {
- "type": "Array",
- "comment": "",
- "fromProperty": "dataObservation",
- "array": [
- {
- "toProperty": "ObservationDate",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "OBSERVATION_DATE"
- }
- ]
- },
- {
- "toProperty": "Collectibility",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "NA",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DaysPastDue",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DAYS_PAST_DUE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OutstandingAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "OUTSTANDING",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DiscountRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_AAR_INTEREST",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsDefaulted",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "IS_DEFAULTED"
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "toProperty": "HistoricalContractRecoveryItems",
- "transformations": [
- {
- "type": "Array",
- "comment": "",
- "fromProperty": "dataRecoveries",
- "array": [
- {
- "toProperty": "RecoveryDate",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "REC_DATE"
- }
- ]
- },
- {
- "toProperty": "RecoveryAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "REC_AMOUNT",
- "comment": ""
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "toProperty": "Entity",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_INTERNAL_PARTY_REF"
- }
- ]
- },
- {
- "toProperty": "OriginContractId",
- "transformations": [
- {
- "type": "Trim",
- "parameter": {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_POSITION_REF"
- }
- }
- ]
- },
- {
- "toProperty": "OriginSystemId",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "",
- "fromValue": "GDM_HISTORICAL"
- }
- ]
- },
- {
- "toProperty": "ProductType",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_INTERNAL_ONE"
- }
- ]
- },
- {
- "toProperty": "ProductSubtype",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_INTERNAL_TWO"
- }
- ]
- },
- {
- "toProperty": "BusinessUnit",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "Segment",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_AUDIT_PORTFOLIO_CODE"
- }
- ]
- },
- {
- "toProperty": "Currency",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "CCY_ISO_CURRENCY"
- }
- ]
- },
- {
- "toProperty": "MaturityDate",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "DTE_MATURITY_DATE"
- }
- ]
- },
- {
- "toProperty": "CounterpartyId",
- "transformations": [
- {
- "type": "HistoricalCounterpartyId",
- "comment": "",
- "parameters": [
- {
- "type": "Trim",
- "parameter": {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "OriginCounterpartyId",
- "transformations": [
- {
- "type": "Trim",
- "parameter": {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- },
- {
- "toProperty": "Phase",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "CDE_INTERNAL_RATING"
- }
- ]
- },
- {
- "toProperty": "Purpose",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_AUDIT_PURPOSE_CODE"
- }
- ]
- },
- {
- "toProperty": "TypeOfLaw",
- "transformations": [
- {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_AUDIT_INSTRUMENT_CODE"
- }
- ]
- },
- {
- "toProperty": "ContractRef",
- "transformations": [
- {
- "type": "Trim",
- "parameter": {
- "type": "Map",
- "comment": "",
- "fromProperty": "IDE_CONTRACT_REF"
- }
- }
- ]
- }
- ]
- }
- ]
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "e5fddfc9-286f-43bc-a34c-1b2e62c947fd",
- "qualityProfileName": "Historical Contracts",
- "qualityProfileDescription": "Historical contract data quality profile"
- }
- }
- ]
- },
- {
- "dataFeedId": "018905be-c373-438f-9c5c-337be3ca95b6",
- "name": "LOAN-DEPOSIT",
- "description": "Loan deposit data feed",
- "streams": [
- {
- "streamId": "ea8f6184-e53c-4921-a4e3-26dbeb7782e8",
- "name": "LOAN-DEPOSIT",
- "description": "Loan deposit data contracts",
- "target": {
- "sinkId": "6c705dfd-eace-4cc1-89be-396e6a8c87eb",
- "sinkName": "Contracts"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "ea4705ad-d660-4845-9e8d-6c187744e19d",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "ContractId",
- "transformations": [
- {
- "type": "ContractId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_POSITION_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "CounterpartyId",
- "transformations": [
- {
- "type": "CounterpartyId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- },
- {
- "toProperty": "Entity",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_PARTY_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Aslb",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_AL_INDICATOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginContractId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_POSITION_REF"
- }
- }
- ]
- },
- {
- "toProperty": "OriginSystemId",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "GDM_LOAN_DEPOSIT",
- "comment": "Apply fixed value to GDM_LOAN_DEPOSIT"
- }
- ]
- },
- {
- "toProperty": "ProductType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_ONE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductSubtype",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_TWO",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BusinessUnit",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "CKV",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginCounterpartyId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- },
- {
- "toProperty": "BaseLgd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BasePd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CreditRating",
- "transformations": [
- {
- "type": "If",
- "expression": "MAT_PAST_DUE = 0",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "1"
- },
- "whenFalse": {
- "type": "If",
- "expression": "MAT_PAST_DUE <= 30",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "2"
- },
- "whenFalse": {
- "type": "If",
- "expression": "MAT_PAST_DUE <= 60",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "3"
- },
- "whenFalse": {
- "type": "If",
- "expression": "MAT_PAST_DUE <= 90",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "4"
- },
- "whenFalse": {
- "type": "If",
- "expression": "MAT_PAST_DUE > 90",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "5"
- }
- }
- }
- }
- }
- }
- ]
- },
- {
- "toProperty": "CreditRatingAgency",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "CKV",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Collectibility",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsRestructured",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_RESTRUCTURED",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Currency",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CCY_ISO_CURRENCY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CurrentPd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DaysPastDue",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "MAT_PAST_DUE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DiscountRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRateIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Segment",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_AUDIT_PORTFOLIO_CODE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsSecured",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "true",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InitialPd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_AAR_INTEREST",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestSpread",
- "transformations": [
- {
- "type": "If",
- "comment": "Term deposits need to have spread, the others can be 0.",
- "expression": "IDE_INTERNAL_ONE = 'Termijnrekening'",
- "whenTrue": {
- "type": "Map",
- "fromProperty": "RTE_SPREAD",
- "comment": "Term deposits need to have spread."
- },
- "whenFalse": {
- "type": "Coalesce",
- "comment": "The others can be 0.",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RTE_SPREAD",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- }
- ]
- },
- {
- "toProperty": "InterestCurve",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "StartDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_DEAL",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "MaturityDate",
- "transformations": [
- {
- "type": "If",
- "comment": "Saving accounts will not have a Maturity Date put Reporting Date instead. For other contracts without Maturity Date, reject.",
- "expression": "IDE_INTERNAL_ONE = 'Spaarrekening'",
- "whenTrue": {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": "Saving accounts will not have a Maturity Date put Reporting Date instead."
- }
- },
- "whenFalse": {
- "type": "Map",
- "fromProperty": "DTE_MATURITY",
- "comment": "For other contracts without Maturity Date, reject."
- }
- }
- ]
- },
- {
- "toProperty": "PrincipalAmount",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT401",
- "comment": ""
- },
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "OutstandingAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1_150",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OutstandingAmountIrrbb",
- "transformations": [
- {
- "type": "If",
- "comment": "Apply for Liab, Nostro and NBB reserve: RCA_AMOUNT1",
- "expression": "TYP_AL_INDICATOR = 2 || IDE_INTERNAL_ONE = 'Nostro' || IDE_INTERNAL_ONE = 'NBB reserve'",
- "whenTrue": {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- },
- "whenFalse": {
- "type": "If",
- "comment": " Apply for Assets: Use RCA_AMOUNT153 + RCA_AMOUNT416 - RCA_AMOUNT82 - RCA_AMOUNT150 for non-performing contracts.",
- "expression": "TYP_RISK_QUAL_INDIC = 4 || TYP_RISK_QUAL_INDIC = 5 || TYP_NON_PERFORMING = 1",
- "whenTrue": {
- "type": "If",
- "comment": "Apply zero value for negative amount.",
- "expression": "RCA_AMOUNT153_416_82_150 < 0",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- },
- "whenFalse": {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT153_416_82_150",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- },
- "whenFalse": {
- "type": "Coalesce",
- "comment": "Apply for Assets: For performing contracts and others use: RCA_AMOUNT153 + RCA_AMOUNT416",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT153_416",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- }
- }
- ]
- },
- {
- "toProperty": "LimitAmount",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "UndrawnAmount",
- "transformations": [
- {
- "type": "If",
- "comment": "Contracts with IDE_INTERNAL_FOUR equal to OF should have a value, if not reject. For the others, set to 0.",
- "expression": "IDE_INTERNAL_FOUR = 'OF'",
- "whenTrue": {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT17",
- "comment": "Should have a value, if not reject."
- },
- "whenFalse": {
- "type": "Coalesce",
- "comment": "The others can be 0.",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT17",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- }
- ]
- },
- {
- "toProperty": "AccruedInterest",
- "transformations": [
- {
- "type": "If",
- "comment": "Apply for Liab: RCA_AMOUNT58",
- "expression": "TYP_AL_INDICATOR = 2",
- "whenTrue": {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT58",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- },
- "whenFalse": {
- "type": "If",
- "comment": "Apply for Nostro and NBB reserve: RCA_AMOUNT57",
- "expression": "IDE_INTERNAL_ONE = 'Nostro' || IDE_INTERNAL_ONE = 'NBB reserve'",
- "whenTrue": {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT57",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- },
- "whenFalse": {
- "type": "Coalesce",
- "comment": "Apply for Assets: Use RCA_AMOUNT57",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT57",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- }
- }
- ]
- },
- {
- "toProperty": "PenaltyInterest",
- "transformations": [
- {
- "type": "If",
- "comment": "Apply for Liab: zero value",
- "expression": "TYP_AL_INDICATOR = 2",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- },
- "whenFalse": {
- "type": "If",
- "comment": "Apply for Nostro and NBB reserve: RCA_AMOUNT57",
- "expression": "IDE_INTERNAL_ONE = 'Nostro' || IDE_INTERNAL_ONE = 'NBB reserve'",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- },
- "whenFalse": {
- "type": "If",
- "comment": "Apply for Assets - Non Performaing Contracts: Use RCA_AMOUNT38 - RCA_AMOUNT4 + RCA_AMOUNT82 + RCA_AMOUNT150",
- "expression": "TYP_RISK_QUAL_INDIC = 4 || TYP_RISK_QUAL_INDIC = 5 || TYP_NON_PERFORMING = 1",
- "whenTrue": {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT38_4_82_150",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- },
- "whenFalse": {
- "type": "Coalesce",
- "comment": "Apply for Assets - Performing contracts: RCA_AMOUNT38",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT38",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- }
- }
- }
- ]
- },
- {
- "toProperty": "PresentValue",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PresentValueIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "PRD_PRODUCT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "NextRepricingDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_NEXT_INT_FIX",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestPaymentFreq",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INTEREST_PAY_FREQUENCY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ContractRef",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_CONTRACT_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CapRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_CAP",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "FloorRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_FLOOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "AssetLiabIndicator",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_AL_INDICATOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRefixFreq",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INT_REFIX_FREQ",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRateType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INTEREST_RATE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PerformingStatus",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_NON_PERFORMING",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Duration",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_DURATION",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BrokerRef",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_BROKER_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "TypeOfLaw",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_AUDIT_INSTRUMENT_CODE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "RefIndexCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_THREE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ContractRefIndex",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_FOUR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Phase",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CDE_INTERNAL_RATING",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Purpose",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_AUDIT_PURPOSE_CODE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PhaseDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_ONE_PHASE_DATE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Depreciation",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT82",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "Impairment",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT150",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "ExposureClass",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_EXPOSURE_CLASS",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "NaceType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_NACE2",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "RiskIndicator",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_RISK_QUAL_INDIC",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EconomicSector",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CDE_ECONOMICAL_SECTOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "SpecificProvisionAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT150",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EligibleType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_ELIGIBLE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "RestructuredType",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ClientMonitType",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- }
- ]
- }
- ]
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "35ec060d-e4f2-4673-907c-b796f1e69e44",
- "qualityProfileName": "Contracts",
- "qualityProfileDescription": "Contracts data quality profile"
- }
- }
- ],
- "source": {
- "name": "LOAN-DEPOSIT",
- "description": "Loan deposit data source",
- "notes": "",
- "extract": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "payload": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "controls": {
- "enforceSchemaValidation": false,
- "schema": {}
- }
- }
- },
- {
- "dataFeedId": "b6631434-08bc-46ef-b727-f98178939a95",
- "name": "SECURITY",
- "description": "Security data feed",
- "source": {
- "name": "SECURITY",
- "description": "Security data source",
- "notes": "",
- "extract": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "payload": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "controls": {
- "enforceSchemaValidation": false,
- "schema": {}
- }
- },
- "streams": [
- {
- "streamId": "35df0cdb-f149-49df-81f7-7da769c7c50d",
- "name": "Security",
- "description": "Security data stream",
- "target": {
- "sinkId": "6c705dfd-eace-4cc1-89be-396e6a8c87eb",
- "sinkName": "Contracts"
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "35ec060d-e4f2-4673-907c-b796f1e69e44",
- "qualityProfileName": "Contracts-data",
- "qualityProfileDescription": "Contracts data quality profile"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "dc5bc604-466f-4f05-9eaf-520a79dc728f",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "ContractId",
- "transformations": [
- {
- "type": "ContractId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_POSITION_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "CounterpartyId",
- "transformations": [
- {
- "type": "CounterpartyId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "VALID_ON"
- },
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON",
- "comment": ""
- }
- }
- ]
- },
- {
- "toProperty": "Entity",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_PARTY_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Aslb",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "2",
- "comment": "Apply fixed value to 2."
- }
- ]
- },
- {
- "toProperty": "OriginContractId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_POSITION_REF"
- }
- }
- ]
- },
- {
- "toProperty": "OriginSystemId",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "Apply fixed value to GDM_SECURITY",
- "fromValue": "GDM_SECURITY"
- }
- ]
- },
- {
- "toProperty": "ProductType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_ONE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductSubtype",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_TWO",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BusinessUnit",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginCounterpartyId",
- "transformations": [
- {
- "type": "Trim",
- "comment": "Removes all leading and trailing white-space characters.",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- },
- {
- "toProperty": "BaseLgd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BasePd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CreditRating",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CreditRatingAgency",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Collectibility",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsRestructured",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "false",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Currency",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CCY_ISO_CURRENCY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CurrentPd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DaysPastDue",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DiscountRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRate",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRateIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Segment",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "AUDIT_INFO",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "IsSecured",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "true",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InitialPd",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_AAR_INTEREST",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestSpread",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RTE_SPREAD",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "InterestCurve",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "StartDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_DEAL",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "MaturityDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_MATURITY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PrincipalAmount",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT401",
- "comment": ""
- },
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "OutstandingAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1_150",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OutstandingAmountIrrbb",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT1",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "LimitAmount",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "UndrawnAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT17",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "AccruedInterest",
- "transformations": [
- {
- "type": "Coalesce",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT20",
- "comment": ""
- },
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT57",
- "comment": ""
- },
- {
- "type": "Map",
- "fromProperty": "RCA_AMOUNT58",
- "comment": ""
- },
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- }
- ]
- },
- {
- "toProperty": "PenaltyInterest",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "0",
- "comment": "Apply zero value."
- }
- ]
- },
- {
- "toProperty": "PresentValue",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PresentValueIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ProductCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "PRD_PRODUCT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "NextRepricingDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "DTE_NEXT_INT_FIX",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestPaymentFreq",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INTEREST_PAY_FREQUENCY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ContractRef",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_CONTRACT_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CapRate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "FloorRate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "AssetLiabIndicator",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "2",
- "comment": "Apply fixed value to 2."
- }
- ]
- },
- {
- "toProperty": "InterestRefixFreq",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INT_REFIX_FREQ",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "InterestRateType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_INTEREST_RATE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PerformingStatus",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_NON_PERFORMING",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Duration",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "RTE_DURATION",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BrokerRef",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_BROKER_REF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "TypeOfLaw",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "IDE_INTERNAL_THREE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "Phase",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "Purpose",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "ExposureClass",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_EXPOSURE_CLASS",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "NaceType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_NACE2",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "RiskIndicator",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_RISK_QUAL_INDIC",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EconomicSector",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CDE_ECONOMICAL_SECTOR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "EligibleType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "TYP_ELIGIBLE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "RestructuredType",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "ClientMonitType",
- "transformations": [
- {
- "type": "Null",
- "comment": ""
- }
- ]
- }
- ]
- }
- ]
- }
- }
- ]
- },
- {
- "dataFeedId": "1364411b-1637-4c5a-9962-b32cc44889fc",
- "name": "COUNTERPARTY-RATINGS",
- "description": "Counterparty ratings data feed",
- "source": {
- "name": "COUNTERPARTY-RATINGS",
- "description": "Counterparty ratings data source",
- "notes": "",
- "extract": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "payload": {
- "enforceSchemaValidation": false,
- "schema": {}
- },
- "controls": {
- "enforceSchemaValidation": false,
- "schema": {}
- }
- },
- "streams": [
- {
- "streamId": "ab0dd5da-f3b2-4c72-a391-02b414754405",
- "name": "Counterparty Ratings",
- "description": "Counterparty ratings data stream",
- "target": {
- "sinkId": "44398cc1-0240-43fb-ba02-a5bc1956a3d7",
- "sinkName": "Counterparty Ratings"
- },
- "transformations": {
- "enableTrace": false,
- "mappingRules": [
- {
- "ruleId": "163fc25e-0724-4a69-8d87-207e512b5a2b",
- "name": "Rules",
- "description": "",
- "condition": null,
- "priority": 1,
- "mappings": [
- {
- "toProperty": "CounterpartyId",
- "transformations": [
- {
- "type": "CounterpartyId",
- "parameters": [
- {
- "type": "Trim",
- "parameter": {
- "type": "Map",
- "fromProperty": "VALID_ON"
- }
- },
- {
- "type": "Trim",
- "parameter": {
- "type": "Map",
- "fromProperty": "IDE_COUNTERPARTY_REF"
- }
- }
- ]
- }
- ]
- },
- {
- "toProperty": "RatingAgencyCode",
- "transformations": [
- {
- "type": "If",
- "comment": "",
- "expression": "CDE_RATING_AGENCY = 1",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "S&P"
- },
- "whenFalse": {
- "type": "If",
- "comment": "",
- "expression": "CDE_RATING_AGENCY = 2",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "Moodys"
- },
- "whenFalse": {
- "type": "If",
- "comment": "",
- "expression": "CDE_RATING_AGENCY = 3",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "Fitch"
- }
- }
- }
- }
- ]
- },
- {
- "toProperty": "RatingScaleCode",
- "transformations": [
- {
- "type": "If",
- "comment": "",
- "expression": "TYP_SHORTLONG_TERM = 0",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "NA"
- },
- "whenFalse": {
- "type": "If",
- "comment": "",
- "expression": "TYP_SHORTLONG_TERM = 1",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "Long-Term Issuer"
- },
- "whenFalse": {
- "type": "If",
- "comment": "",
- "expression": "TYP_SHORTLONG_TERM = 2",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "Short-Term Issue"
- }
- }
- }
- }
- ]
- },
- {
- "toProperty": "RatingCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CDE_DF_EXT_RATING",
- "comment": "By logic with lookup on the extractor"
- }
- ]
- }
- ]
- }
- ]
- },
- "qualityProfile": {
- "qualityProfileVersionId": "ff993f4c-d664-4cd6-87ba-ee1902c60c5b",
- "qualityProfileVersionName": "CKV Titanium Validation",
- "qualityProfileVersionDescription": "CKV Titanium Validation",
- "qualityProfileId": "b34b80c1-1c3e-4824-9e6a-865454028b65",
- "qualityProfileName": "Counterparty Ratings",
- "qualityProfileDescription": "Counterparty ratings data quality profile"
- }
- }
- ]
- }
- ]
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement