Announcement

Collapse
No announcement yet.

SQL Dictionary Scripts

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Dictionary Scripts

    The attached SQL scripts will create the dictionary tables from the source ASCII files within ClinPlus Coding Version 3.x. These scripts are written to work as system stored programs that can be used with multiple dictionary builds as new versions are required.

    The programs and scripts supplied by ClinPlus have been validated. While ClinPlus makes every effort to provide accurate and complete information, we strongly recommend that clients who use the scripts also validate the results.

    Changes to scripts from Coding 3.0 to Coding 3.1
    The following changes were made to the dictionary scripts for use under coding version 3.1.
    • Added column LLT_Name_WordSorted to contain the word sorted version of the dictionary term.
    • Several functions were added to create the word sorted value.
    • A TSQL variable was added with the replacement tag {SPECIALCHARACTERS} that is populated from the coding template. The characters specified will be removed from the word sorted term.
    • In the SQL Server script, the replacement tag {OWNER} was added to all objects so that the correct schema, as specified in the template, is used.

    Changes to scripts from Coding 3.1 to Coding 3.2
    The following changes were made to the dictionary scripts for use under coding version 3.2
    • Two new scripts have been created to support the new WHO Drug formats B3 and C3, WHODrugB3_V1.sql and WHO Drug C3_V1.sql. Note that the term length has been increased to 1500 characters. Your data must also be altered to support this new format.
    Attached Files
    Last edited by Greg Wagner; 06-13-2018, 09:53 AM.
Working...
X