Skip to main content

ke_customer_master

This table contains data for customer accounts, including their identification numbers, status, and additional descriptive details.

extraction_date​

  • Description: ETL Date (t-1), when the data was last extracted.
  • Example: 2023-04-03T21:00:00.000Z
  • Type: timestamp

customer_number​

  • Description: Unique Identifier for the customer.
  • Example: 101874
  • Type: varchar(255)

cus_mnemonic​

  • Description:
  • Example:
  • Type:

cus_short_name​

  • Description:
  • Example:
  • Type:

cus_name_1​

  • Description:
  • Example:
  • Type:

cus_name_2​

  • Description:
  • Example:
  • Type:

street​

  • Description:
  • Example:
  • Type:

country​

  • Description:
  • Example:
  • Type:

client_res_addr​

  • Description:
  • Example:
  • Type:

relation_code​

  • Description:
  • Example:
  • Type:

rel_customer​

  • Description:
  • Example:
  • Type:

sector​

  • Description: The sector in which the business operates in.
  • Example: 4000, 1100, 2000
  • Type: varchar(255)

sector_description​

  • Description: Description of the sector code.
  • Example: FOREIGN TRADE, INDIVIDUALS, MANUFACTURING, FINANCIAL INSTITUTIONS

cus_acc_officer​

  • Description:
  • Example:
  • Type:

account_officer_name​

  • Description:
  • Example:
  • Type:

other_officer​

  • Description:
  • Example:
  • Type:

industry​

  • Description:
  • Example:
  • Type:

industry_description​

  • Description:
  • Example:
  • Type:

target​

  • Description:
  • Example:
  • Type:

nationality​

  • Description:
  • Example:
  • Type:

customer_status​

  • Description:
  • Example:
  • Type:

residence​

  • Description:
  • Example:
  • Type:

contact_date​

  • Description:
  • Example:
  • Type:

introducer​

  • Description:
  • Example:
  • Type:

pin_number​

  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:
  • Description:
  • Example:
  • Type:

off_phone​

  • Description:
  • Example:
  • Type:

cust_off_phone​

  • Description:
  • Example:
  • Type:

cust_mob_phone​

  • Description:
  • Example:
  • Type:

birth_incorp_date​

  • Description:
  • Example:
  • Type:

global_customer​

  • Description:
  • Example:
  • Type:

company_book​

  • Description:
  • Example:
  • Type:

family_name​

  • Description:
  • Example:
  • Type:

gender​

  • Description:
  • Example:
  • Type:

date_of_birth​

  • Description:
  • Example:
  • Type:

date_of_births​

  • Description:
  • Example:
  • Type:

marital_status​

  • Description:
  • Example:
  • Type:

no_of_dependents​

  • Description:
  • Example:
  • Type:

phone_1​

  • Description:
  • Example:
  • Type:

sms_1​

  • Description:
  • Example:
  • Type:

employment_status​

  • Description:
  • Example:
  • Type:

occupation​

  • Description: The customer's occupation
  • Example: JUA KALI,teacher
  • Type: varchar(255)

job_title​

  • Description:
  • Example:
  • Type:

customer_branch​

  • Description:
  • Example:
  • Type:

classification​

  • Description:
  • Example:
  • Type:

business_segment​

  • Description:
  • Example:
  • Type:

business_segment_desc​

  • Description:
  • Example:
  • Type:

sub_segement​

  • Description:
  • Example:
  • Type:

sub_segement_desc​

  • Description:
  • Example:
  • Type:

employers_name​

  • Description:
  • Example:
  • Type:

employers_add​

  • Description:
  • Example:
  • Type:

employers_buss​

  • Description:
  • Example:
  • Type:

employment_start​

  • Description:
  • Example:
  • Type:

calc_risk_class​

  • Description:
  • Example:
  • Type:

manual_risk_class​

  • Description:
  • Example:
  • Type:

aml_check​

  • Description:
  • Example:
  • Type:

aml_result​

  • Description:
  • Example:
  • Type:

aml_risk_class​

  • Description:
  • Example:
  • Type:

cus_dao2​

  • Description:
  • Example:
  • Type:

cus_nic_ref​

  • Description:
  • Example:
  • Type:

wht_cert_expiry​

  • Description:
  • Example:
  • Type:

pep_status​

  • Description:
  • Example:
  • Type:

disability​

  • Description:
  • Example:
  • Type:

disabled​

  • Description:
  • Example:
  • Type:

otherdisability​

  • Description:
  • Example:
  • Type:

co_code​

  • Description:
  • Example:
  • Type:

cust_email_id​

  • Description:
  • Example:
  • Type:

cust_title​

  • Description:
  • Example:
  • Type:

tax_exempt​

  • Description:
  • Example:
  • Type:

ft_grp_charg​

  • Description:
  • Example:
  • Type:

cust_cba_info​

  • Description:
  • Example:
  • Type:

us_rpt_acct_c​

  • Description:
  • Example:
  • Type:

us_rpt_acct_n​

  • Description:
  • Example:
  • Type:

us_tin​

  • Description:
  • Example:
  • Type:

us_report​

  • Description:
  • Example:
  • Type:

excise_exempt​

  • Description:
  • Example:
  • Type:

inputter​

  • Description:
  • Example:
  • Type:

authoriser​

  • Description:
  • Example:
  • Type:

regenerate_pass​

  • Description:
  • Example:
  • Type:

customer_branch_name​

  • Description:
  • Example:
  • Type:

last_update_date​

  • Description:
  • Example:
  • Type:

title​

  • Description:
  • Example:
  • Type:

customer_status_description​

  • Description:
  • Example:
  • Type:

account_officer_area​

  • Description:
  • Example:
  • Type:

account_officer_level​

  • Description:
  • Example:
  • Type:

cust_type​

  • Description:
  • Example:
  • Type:

cust_contact_date​

  • Description:
  • Example:
  • Type:

cust_channel​

  • Description:
  • Example:
  • Type:

kyc_last_rv_dt​

  • Description:
  • Example:
  • Type:

kyc_next_rv_dt​

  • Description:
  • Example:
  • Type: