featurestore_id

entity_type_id

source

entity_id

customer_application_form_fs

customer_profile_features

Kafka Topic - Pub/Sub

customerid

customer_address_features

Kafka Topic - Pub/Sub

customerid

customer_preference_features

Kafka Topic - Pub/Sub

customerid

customer_additional_features

Kafka Topic - Pub/Sub

customerid

Last Updated: 10th Feb 2023

Currently, the features here are based on the list of Personal Information values that a new user is required to fill up during onboarding. Information at the moment is based on the Figma screens.

Customer Profile Features

customer_profile_features

{
  "customer":{
       "id":"edb2f1c5-8659-42bf-a4ee-74ad0ef3e98e",
       "countryCode":"63",
       "phoneNumber":"9178227703",
       "phoneNumberVerified":true,
       "email":null,
       "status":"ACTIVE",
       "profile":{
           "id":"15db8de2-3873-4ec7-81b5-e6bfa7039071",
           "firstName":"Maria",
           "middleName":"S Antos",
           "lastName":"Dela Cruz",
           "gender":"F",
           "dateOfBirth":3727,
           "placeOfBirth":"Manila",
           "nationality":"Filipinos",
           "createdAt":1670830850012,
           "updatedAt":1670831112327
       },
       "address":{
           ...
       },
       "notUsDeclaredAt":1670830807734,
       "notPepDeclaredAt":1670830807734,
       "profilePictureDocumentId":null,
       "isBankEmployee":false,
       "onboardedAt":1670831112327,
       "offboardedAt":null,
       "createdAt":1670830705695,
       "updatedAt":1670831112327
   }
}

Response Result

Description

feature_id

Atomic

Type

id

customerid - entity_id

YES

STRING

countryCode

countrycode

YES

STRING

phoneNumber

phonenumber

YES

STRING

phoneNumberVerified

phonenumberverified

YES

STRING

email

email

YES

STRING

status

status

YES

STRING

profile.id

NO

STRING

profile.firstName

profile_firstname

YES

STRING

profile.middleName

profile_middlename

YES

STRING

profile.lastName

profile_lastname

YES

STRING

profile.gender

profile_gender

YES

STRING

profile.dateOfBirth

{
  "name": "dateOfBirth",
  "type": {
    "type": "int",
    "logicalType": "date"
}

profile_dateofbirth

YES

INT

profile.placeOfBirth

profile_placeofbirth

YES

STRING

profile.nationality

profile_nationality

YES

STRING

profile.createdAt

profile_createdat

YES

STRING

profile.updatedAt

profile_updatedat

YES

STRING

notUsDeclaredAt

notusdeclaredat

YES

STRING

notPepDeclaredAt

notpepdeclaredat

YES

STRING

profilePictureDocumentId

profilepicturedocumentid

STRING

isBankEmployee

isbankemployee

STRING

onboardedAt

onboardedat

STRING

offboardedAt

offboardedat

STRING

createdAt

createdat

YES

STRING

updatedAt

updatedat

YES

STRING

Customer Address Features

customer_address_feaures

{
  "customer": {
      "id": "4b886d0e-e930-4289-8298-0137057a2486",
      ...
      },
      "address": {
          "id": "f72a1229-028d-4615-8e9b-305cf98eb4a2",
          "country": "Australia",
          "zipCode": "12345",
          "street": "221-B, The Baker Street",
          "province": "Wales",
          "city": "London",
          "barangay": "Best",
          "other": "Many other notes",
          "createdAt": "1660119154185"
      },
  },
  "preference": {},
  "additionalInfo": {}
}

Response Result

Description

feature_id

Atomic

Type

customer.id

customerid - entity_id

NO

country

country

YES

STRING

zipCode

zipcode

YES

STRING

street

street

YES

STRING

province

province

YES

STRING

city

city

YES

INT

barangay

barangay

YES

STRING

other

{
  "name": "other",
  "type": [
    "null",
    "string"
  ]
}

other

NO

STRING

(NULLABLE)

createdAt

createdat

YES

Customer Preference Features

customer_preference_features

"preference": {
    "id": "93e09866-83c9-47d1-8635-cf1a02f09460",
    "language": "ENGLISH",
    "toneOfVoice": "FRIENDLY",
    "createdAt": "1658488100722",
    "updatedAt": "1658841941524"
}

Response Result

Description

feature_id

Atomic

Type

customer.id

customerid - entity_id

NO

id

NO

language

language

toneOfVoice

toneofvoice

createdAt

createdat

updatedAt

updatedat

Customer Additional Features

customer_additional_features are derived from the additional survey questions that a customer has to fill in as part of the registration process

"additionalInfo": {
      "surveyId": "e892da3d-77b7-4bba-b63c-6837f7d07d39",
      "answers": {
          "SOURCE_OF_INCOME": "INHERITANCE",
          "OCCUPATION": "GOVERNMENT",
          "JOB_INDUSTRY": "SELF_EMPLOYED",
          "EMPLOYMENT_DURATION": "5-",
          "ACCOUNT_PURPOSE": "SALARY",
          "MONTHLY_INCOME": "72-96"
      }
  }

Response Result

Description

feature_id

Atomic

Type

customer.id

customerid - entity_id

No

STRING

surveyId

No

STRING

SOURCE_OF_INCOME

SALARY
INVESTMENT
INHERITANCE
REMITTANCE
OTHER

source_of_income

Yes

STRING

OCCUPATION

PRIVATE
PART_TIME
GOVERNMENT
BUSINESS_OWNER
STUDENT
FREELANCER
RETIRED
UNEMPLOYED

occupation

Yes

STRING

JOB_INDUSTRY

TRADE
AGRICULTURE
CONSTRUCTION
PRODUCTION
TRANSPORTATION
POLICE
SELF_EMPLOYED
IT
BUSINESS
REAL_ESTATE
DISTRIBUTION
EDUCATION
HEALTH
HOTELS
MEDIA
GOVERNMENT
OTHERS

job_industry

Yes

STRING

EMPLOYMENT_DURATION

0-0.5
0.5-1
1-3
3-5
5-

employment_duration

Yes

STRING

ACCOUNT_PURPOSE

SAVING
SALARY
BUSINESS
OTHER

account_purpose

Yes

STRING

MONTHLY_INCOME

In thousands

0-24
24-48
48-72
72-96
96-120
120-

monthly_income

Yes

STRING