WRAP Data Freeze - "ConsensusConferenceDiagnosis" Field Definitions

The calculated fields of the "ConsensusConferenceDiagnosis" table all use the

"ConsensusConference" table field values in their determinations.  The fields of

the "ConsensusConference" table take their values from the "WRAP NACC ver5_02-19.docx"

document  This document records the determinations from the WRAP Consensus Conference.

This document is available for viewing here.WRAPNACCver5_02-19.docx

Below is the SQL which defines each of the "ConsensusConferenceDiagnosis"

field values.  Note that the numeral portion of the field reference refers to the

question number, i.e. "cc3" refers to Question 3 on the "WRAP NACC ver5_02-19.docx"

document.

Field "consensus_dx":

      Switch(
         NZ(cc3,-999) = 1, "Dementia",
         NZ(cc2,-999)=1 Or (NZ(cc4_early,-999)=0 And NZ(cc4_clinical,-999)=0), "Cog_Unimpaired_Stable",                
         NZ(cc4e,-999) = 1, "Impaired_Not_MCI",
         NZ(cc4_early,-999) = -1, "Cog_Unimpared_Declining",
         NZ(cc4_clinical,-999) = -1, "Clinical_MCI") AS consensus_dx

     

Field "dementia_type":

      Iif(NZ(cc3,-999) = 1, Switch(
            NZ(cc5,-999) = 1, Switch(NZ(cc5a,-999) = 1, "Probable_AD_Primary", NZ(cc5a,-999) = 2, "Probable_AD_Secondary"),
            NZ(cc6,-999) = 1, Switch(NZ(cc6a,-999) = 1, "Possible_AD_Primary", NZ(cc6a,-999) = 2, "Possible_AD_Secondary"))) AS dementia_type

Field "cons_memory":

      Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4a,-999) = 1 or NZ(cc4b,-999) = 1, 1, 0),NULL) AS cons_memory

Field: "cons_language":

      Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4b_lang,-999) = 1 or NZ(cc4c_lang,-999) = 1 or NZ(cc4d_lang,-999) = 1, 1, 0),NULL) AS cons_language

Field: "cons_attention":

      Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4b_att,-999) = 1 or NZ(cc4c_att,-999) = 1 or NZ(cc4d_att,-999) = 1, 1, 0),NULL) AS cons_attention

Field: "cons_execfunc":

      Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4b_exec,-999) = 1 or NZ(cc4c_exec,-999) = 1  or NZ(cc4d_exec,-999) = 1, 1, 0),NULL) AS cons_execfunc

Field: "cons_visuospatial":

      Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4b_vis,-999) = 1    or NZ(cc4c_vis,-999) = 1 or NZ(cc4d_vis,-999) = 1, 1, 0),NULL) AS cons_visuospatial

The SQL above is contained in the "qryCCLong" query.  Within this query is referenced the "qryTallies" query,  The contents of these queries in their entirety

are available below:

      qryCCLong.txt

      qryTallies.txt

Note that all of these queries are run in a MS-Access 2016 environment.  The "NonMiss" function is one that was locally written

to indicate if a particular value was missing.  This can be provided as well if desired.

Note that all of the SQL above was written by Erin Jonaitis of WRAP. 

If you have any questions about this documentation or suggestions for it's improvement, please contact

      Allen Wenzel

      WRAP Administrative Program Specialist

      EMail: awenzel@wisc.edu