What's New in 20R3.1

The Nitro 20R3.1 release includes several new features.

Our release notes offer brief, high-level descriptions of enhancements and new features. Configuration is available by selecting the feature name.

Features

Inbound Connectors

FTP Pattern Update

The pt_ftp_ods_upsert_deletion__v pattern now deletes records from the ODS only when both of the following conditions are met:

  • Field deletion_flag__v is set to true
  • YYYYMM record value equals the table yml date or datetime field deleteKey attribute

Data Quality

Rule and Group Email Alerts

In addition to email alerts for ETL jobs, customers can now receive email alerts for Data Quality Rule and Group jobs that either failed to run, or ran successfully but resulted in violations. Two email templates are used to send information to users, depending on the type of alert requested:

  • Rule Group - Provides information on the rules applied to the job
  • Rule Job - Provides results from the executed rule

Analytics

Connector Updates

The following connector updates are available:

  • Medscape
  • Product_id__v - Field type change from numeric(10) to varchar(255)
  • File_date__v - Field type change from date to timestamp on control file
  • Ms_mci_control__v - Order of fields in the table reordered to file_name__v, record_count__v, file_date__v
  • Ultmarc
  • Table Update - skipHeader now set to false
  • Jitsushoka
  • Class__v - Field type changed from varchar(55) to varchar(220)
  • Symphony APLD Claims - Load pattern and deleteKey updates for the following tables:

    Table

    deleteKey

    symphony_apld_diagnosis__v

    service_date__v

    symphony_apld_procedure__v

    procedure_date__v

    symphony_apld_rx_claims__v

    rx_fill_date__v

    symphony_apld_surgical__v

    Surgical_procedure_date__v

  • Symphony PTD Claims - Load pattern and deleteKey updates for the following tables:

    Table

    deleteKey

    symphony_claims_diagnosis__v

    service_date__v

    symphony_claims_procedure__v

    procedure_date__v

    symphony_claims_market_rx__v

    rx_fill_date__v

    symphony_claims_surgical__v

    surgical_procedure_date__v

    symphony_claims_nonmarket_rx__v

    rx_fill_date__v