FINS Loan Origination System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| CommonTools | This module provides utility functions and mappings used by this System API |
| map-get-customers-response | Customer Query Mapping for Loan Origination System |
| map-post-customers-payload | Customer Create Mapping for Loan Customer of Loan Origination System |
| map-patch-customers-payload | Customer Update Mapping for Loan Origination System |
| map-get-individuals-response | Query Individual Mapping From MDM DB |
| map-get-loanapplications-response | LoanApplication - Retrieve Mapping Loan Origination System (LOS) |
| map-post-loanapplications-payload | |
| map-patch-loanapplications-payload | Loan PATCH request Mapping for Loan Origination System (LOS) |
| map-get-loandocuments-response | |
| map-post-loandocuments-payload | |
| map-patch-loandocuments-payload |
CommonTools
This module provides utility functions and mappings used by this System API
Source:
./src/main/resources/dwl/CommonTools.dwl
Functions
fun getEmailArr (contactPoints)
This function gets the EmailAddress from ContactPoints Array
fun getPrimaryEmailInfo (contactPoints)
This function returns the Primary EmailAddress
map-get-customers-response
Customer Query Mapping for Loan Origination System
Source:
./src/main/resources/dwl/map-get-customers-response.dwl
Mapping Tables
Maps Loan Origination System Customer to CIM Customer format
| CIM | Loan Origination System | Description |
|---|---|---|
| id | ID | The id of the customer in Loan Origination System Banking System system |
| churnScore | CHURN_SCORE | The churn score of the customer |
| customerNumber | CUSTOMER_NUMBER | The Customer Number in Loan Origination System |
| customerStatus | CUSTOMER_STATUS | The status of the customer in Loan Origination System |
| originatingCustomerSource | ORIGINATING_CUSTOMER_SOURCE | The originating source of the customer |
| party | [ if(vars.individualRecord != null) (vars.individualRecord) else PARTY_ID ] | The id of the individual as party |
| partyRoleType | PARTY_ROLE_TYPE | The type of party role - default as Customer |
| externalIds | GLOBAL_CUSTOMER_ID | The externalIds of the customer that are stored in Loan Origination System |
| auditInfo.createdBy | CREATED_BY | Identifies the system or user which created the entity |
| auditInfo.createdDate | CREATED_DATETimestamp of when the entity was created - default as current timestamp | |
| auditInfo.updatedBy | UPDATED_BY | Identifies the system or user which last updated the entity |
| auditInfo.updatedDate | UPDATED_DATE | Timestamp of when the entity was last updated |
| auditInfo.isDeleted | isDeleted | Indicates whether or not the entity has been soft-deleted - default as false |
map-post-customers-payload
Customer Create Mapping for Loan Customer of Loan Origination System
Source:
./src/main/resources/dwl/map-post-customers-payload.dwl
Mapping Tables
Maps CIM Customer to JSON which is used by stored procedure - sp_Customers_Upsert
| JSON used by the stored procedure | CIM | Description | |
|---|---|---|---|
| customerNumber | customerNumber | The Customer Number to be stored in Core Banking System | |
| originatingCustomerSource | originatingCustomerSource | The customer source at origin | |
| customerStatus | customerStatus | The status of the customer | |
| id | id | The id of the customer | |
| globalCustomerId | globalCustomerId | The Global Customer Id of the customer | |
| partyId | party[0] | The id of the individual as party | |
| partyRoleType | partyRoleType | "Customer" | The type of party role - default as Customer |
| createdDate | auditInfo.createdDate | Identifies the system or user which created the entity - default as current timestamp | |
| createdBy | auditInfo.createdBy | Timestamp of when the entity was created - default as current timestamp | |
| updatedBy | auditInfo.updatedBy | Identifies the system or user which last updated the entity - default as property app.name | |
| updatedDate | auditInfo.updatedDate | Timestamp of when the entity was last updated - default as current timestamp |
map-patch-customers-payload
Customer Update Mapping for Loan Origination System
Source:
./src/main/resources/dwl/map-patch-customers-payload.dwl
Variables
var payloadRecordfromDB
payloadRecordfromDB is the existing customer record in Loan Origination System
Mapping Tables
Maps CIM Customer to Loan Origination System Customer PATCH payload is created by validating the Input Request payload with DB Record Payload.
| Loan Origination System | CIM | Description |
|---|---|---|
| id | vars.customerId | The id of the customer in Loan Origination System |
| churnScore | if(CHURN_SCORE?) CHURN_SCORE else payloadRecordfromDB.churnScore | The churn score of the customer |
| createdBy | p('app.name') | Identifies the system or user which created the entity - default as property app.name |
| createdDate | now() | Timestamp of when the entity was created - default as current timestamp |
| customerNumber | if(CUSTOMER_NUMBER?) CUSTOMER_NUMBER else payloadRecordfromDB.customerNumber | The Customer Number to be stored in Loan Origination System |
| customerStatus | if(CUSTOMER_STATUS?) CUSTOMER_STATUS else payloadRecordfromDB.customerStatus | The status of the customer |
| globalCustomerId | GLOBAL_CUSTOMER_ID | The Global Customer Id of the customer |
| originatingCustomerSource | if(ORIGINATING_CUSTOMER_SOURCE?) ORIGINATING_CUSTOMER_SOURCE else payloadRecordfromDB.originatingCustomerSource | The originating source of the customer |
| updatedBy | p('app.name') | Identifies the system or user which last updated the entity - default as property app.name |
| updatedDate | now() | Timestamp of when the entity was last updated - default as current timestamp |
| partyId | if(party?) party[0] else payloadRecordfromDB.party[0] | The id of the individual as party |
| partyRoleType | if(PARTY_ROLE_TYPE?) PARTY_ROLE_TYPE else payloadRecordfromDB.partyRoleTypeThe type of party role - default as Customer |
map-get-individuals-response
Query Individual Mapping From MDM DB
Source:
./src/main/resources/dwl/map-get-individuals-response.dwl
map-get-loanapplications-response
LoanApplication - Retrieve Mapping Loan Origination System (LOS)
Source:
./src/main/resources/dwl/map-get-loanapplications-response.dwl
map-post-loanapplications-payload
Source:
./src/main/resources/dwl/map-post-loanapplications-payload.dwl
map-patch-loanapplications-payload
Loan PATCH request Mapping for Loan Origination System (LOS)
Source:
./src/main/resources/dwl/map-patch-loanapplications-payload.dwl
map-get-loandocuments-response
Source:
./src/main/resources/dwl/map-get-loandocuments-response.dwl
Mapping Tables
Maps FINSDB Loan Document to BankingSpec Loan Document format
| BankingSpec | FINSDB | Description |
|---|---|---|
| ID | id | Document Id of the Application |
| LOAN_APPLICATION | loanApplication | Loan Application Id |
| NAME | name | Name of the Document |
| Description | description | Description of the Document |
| DOCUMENT_STATUS | documentStatus | Status of the Document |
| SIGNATURE_STATUS | signatureStatus | Status of Signature on the Document |
| GLOBAL_DOCUMENT_ID | externalIds | External Id of the Document. This will be DOCUSIGN Id |
| CREATED_DATE | createdDate | Created Date |
| CREATED_BY | createdBy | Created by |
| UPDATED_DATE | updatedDate | Updated date |
| UPDATED_BY | updatedBy | Updated by |
map-post-loandocuments-payload
Source:
./src/main/resources/dwl/map-post-loandocuments-payload.dwl
Mapping Tables
Maps BankingSpec Loan Document format to FINSDB Loan Document
| BankingSpec | FINSDB | Description |
|---|---|---|
| id | ID | Loan Id of the Application |
| loanApplication | LOAN_APPLICATION | Loan Application Id |
| name | NAME | Name of the Document |
| description | Description | Description of the Document |
| documentStatus | DOCUMENT_STATUS | Status of the Document |
| signatureStatus | SIGNATURE_STATUS | Status of Signature on the Document |
| externalIds | GLOBAL_DOCUMENT_ID | External Id of the Document |
| createdDate | CREATED_DATE | Created Date |
| createdBy | CREATED_BY | Created by |
| updatedDate | UPDATED_DATE | Updated date |
| updatedBy | UPDATED_BY | Updated by |
map-patch-loandocuments-payload
Source:
./src/main/resources/dwl/map-patch-loandocuments-payload.dwl
Mapping Tables
Maps BankingSpec Loan Document format to FINSDB Loan Document
| BankingSpec | FINSDB | Description |
|---|---|---|
| id | ID | Loan Id of the Application |
| loanApplication | LOAN_APPLICATION | Loan Application Id |
| name | NAME | Name of the Document |
| description | Description | Description of the Document |
| externalId | GLOBAL_DOCUMENT_ID | Global Document Id as external Id |
| documentStatus | DOCUMENT_STATUS | Status of the Document |
| signatureStatus | SIGNATURE_STATUS | Status of Signature on the Document |
| externalIds | EXTERNAL_ID.EXTERNAL_ID | External Id of the Document |
| createdDate | CREATED_DATE | Created Date |
| createdBy | CREATED_BY | Created by |
| updatedDate | UPDATED_DATE | Updated date |
| updatedBy | UPDATED_BY | Updated by |