Understand NSS Data Store structure

The guide represents the structure and content of the Data Store tables storing the data used in Evelyn processes and analytics.

Main processing tables

NSS document

Data Store name: ds_uc_b_aml_pep_nss_document_v2_0

Column	Type	Index	Description
uuid	nvarchar(36), UUID, not null	+	UUID
transaction_id	nvarchar(36), UUID, not null		Transaction ID
input_id	nvarchar(255)		Input ID
hit_id	nvarchar(255)		Hit ID
hit_json_data	nvarchar(MAX)		Hit details in the JSON format
resolution_json_data	nvarchar(MAX)		Resolution data in the JSON format
location_lookup	nvarchar(MAX)		Details about the location lookup result

Transaction table

• Data Store name: ds_uc_B_AML_PEP_transaction_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID, not null	+	Transaction UUID
  variation_id	nvarchar(255)		DW title
  parent_uuid	nvarchar(36)		Parent UUID
  start_time	Date Time		Transaction processing start time
  end_time	Date Time		Transaction processing end time
  status	nvarchar(36)		Transaction status: NEW, PROCESSING, READY_FOR_REPORT, ERROR, COMPLETED
  error_status	nvarchar(36)		Error status
  start_bp_uuid	nvarchar(36), UUID		UUID of the Business Process (BP) where the transaction was processed
  is_spt	int		Indicator to show if a record required manual intervention
  split_status	nvarchar(255)		Split record details
  skip_until	nvarchar(255)		The step where a transaction failed

• Data Store name: ds_uc_B_AML_PEP_transaction_data_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36),UUID, not null	+	UUID
  transaction_id	nvarchar(36),UUID, not null	+	Transaction UUID
  bp_run_id	nvarchar(36),UUID, not null		BP UUID
  input_data_json	nvarchar(MAX)		Input data in the JSON format
  resolution_data_json	nvarchar(MAX)		Resolution data in the JSON format
  sys_ext_record_id	nvarchar(36)		External record ID
  location_lookup	nvarchar(MAX)		Location lookup details
  auto_qc	nvarchar(36)		Indicates if a transaction is selected for the Auto quality check feature

Master record table

Data Store name: ds_uc_B_AML_PEP_master_record_v2_0

Column	Type	Index	Description
uuid	nvarchar(36), UUID, not null	+	UUID
bp_run_id	nvarchar(36), UUID, not null		BP UUID
transaction_id	nvarchar(36), UUID		Transaction UUID
sys_ext_record_id	nvarchar(36)		REST request ID

Ticker enrichment table

Data Store name: ds_uc_B_AML_PEP_tickers_v2_0

Column	Type	Index	Description
uuid	nvarchar(36), UUID	+	UUID
symbol	nvarchar(255)		Ticker symbol
company_name	nvarchar(Max)		Company name associated with the ticker

Monitor configuration

• Data Store name: uc_b_aml_pep_monitor_configuration_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID, not null	+	UUID
  variation_id	nvarchar(255)		DW variation ID
  monitor_class	nvarchar(255), not null	+	Monitor class name
  polling_interval	nvarchar(255)		Polling interval
  sleep_time	nvarchar(255)		Sleep time
  max_loop	int		Maximum number of pools
  max_running_time	nvarchar(255)		Maximum running time

• Data Store name: uc_b_aml_pep_monitor_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID, not null	+	UUID
  variation_id	nvarchar(255)		DW variation name
  monitor_id	nvarchar(255), not null	+	Monitor UUID
  creation_time	nvarchar(255)		Monitor creation time
  completed_loops	int		Number of loops
  last_polling_time	nvarchar(255)		Last polling time
  stopped	int		Stop indicator

Screening system tables

Firco Trust

• Data Store name: ds_uc_B_AML_PEP_firco_configuration_v2_0

  Column	Type	Index	Description
  uid	nvarchar(36), UUID, not null	+	UUID
  batch_size	int		Firco Trust processing batch size
  wait_time	int		Wait time between batches in milliseconds

• Data Store name: ds_uc_B_AML_PEP_firco_monitor_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID, not null	+	UUID
  bp_run_id	nvarchar(36), UUID		BP UUID
  sys_ext_record_id	nvarchar(36)		External record ID
  is_active	int		Is active indicator

• Data Store name: ds_uc_B_AML_PEP_firco_processing_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID, not null	+	UUID
  firco_system_id	nvarchar(255), not null	+	Firco Trust message system ID
  firco_message_id	nvarchar(255)		Firco Trust message ID
  firco_unit	nvarchar(MAX)		Firco Trust message unit
  firco_business_unit	nvarchar(255)		Firco Trust message business unit
  transaction_id	nvarchar(36)		Transaction UUID
  bp_run_id	nvarchar(36)		BP run UUID
  ext_record_id	nvarchar(255)		REST request UUID

Dow Jones Risk and Compliance

• Data Store name: ds_uc_B_AML_PEP_alerts_cache_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID, not null	+	UUID
  alert_id	nvarchar(36), not null	+	Alert ID
  alert_update_date	nvarchar(255), not null		Alert last updated date
  alert_response	nvarchar(MAX), not null		Alert DJ response

• Data Store name: ds_uc_B_AML_PEP_search_cache_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID, not null	+	UUID
  search_string	nvarchar(255), not null		DJ Factiva search request
  search	nvarchar(MAX), not null		DJ Factiva search response

Thomson Reuters

• Data Store name: ds_uc_b_aml_pep_countries_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID, not null	+	UUID
  iso2_code	varchar(2), not null	+	Country ISO 2 code
  iso3_code	varchar(3)		Country ISO 3 code
  name	varchar(56)		Country full name

• Data Store name: ds_uc_b_aml_pep_us_states_v2_0

  Column	Type	Index	Description
  uuid	nvarchar(36), UUID		UUID
  iso2_code	varchar(2), not_null	+	US state ISO 2 code
  name	varchar(56)	+	US state name