Note that this codebook is for database programmers—it is not a clear and easy way for data collectors to know what information has to be collected, how, in what order, and how it should be systematically recorded. To that end, we anticipate scheduling a training that walks through the variables, possible values, and decision rules so that grantees know exactly what you are going to need to report into TRAC, and can ensure that the right type of information is available for later TRAC data entry.

H. PBHCI: PHYSICAL HEALTH ITEMS

  1. Health measurements:
  1. Systolic blood pressuremmHg
  2. Diastolic blood pressuremmHg
  3. Weight kgkg
  4. Height cm
  5. Waist circumference[1]cm
  6. Breath CO1ppm
  1. Did patient successfully fast for 8 hours prior

to providing the blood sample?

  1. Blood test results:

Date of blood draw: |__|__| / |__|__| /|__|__|__|__|

MONTH DAY YEAR

FOR 3a AND b: ENTER ONE OR THE OTHER, NOT BOTH:

  1. Fasting plasma glucosemg/dL
  2. HgBA1c%
  1. Total Cholesterolmg/dL
  2. HDL Cholesterolmg/dL
  3. LDL Cholesterolmg/dL
  4. Triglyceridesmg/dL

Version: 1.0.51Last updated: 10/11/2018

2a. Why was the interview not conducted? Choose only one.

[PLEASE MARK YOUR ANSWER UNDER THE COLUMN RELATING TO THE ASSESSMENT TYPE]

Baseline
Assessment / Reassessments / Clinical
Discharge
Consumer refused interview /  /  / 
Not able to obtain consent from proxy /  /  / 
Consumer was impaired/unable to provide consent /  /  / 
Consumer cannot be reached for interview /  / 
Staff previously indicated “Administrative data only” or “No data” would be submitted /  / 
[IF THIS ANSWER IS SELECTED, GO TO SECTION H (if applicable) or I] / [IF THIS ANSWER IS SELECTED, GO TO SECTION H (if applicable) or J]

Version: 1.0.51Last updated: 10/11/2018

Codebook Updates

Field Name / Question Number / Description / Value Descriptions / Edit and Skip Information / Crosscheck
RECORD MANAGEMENT [This section is always applicable (where program applies).]
WhyNotConducted / 2a / Why was the interview not conducted? / * Only applicable if an interview was not conducted (ConductedInterview = 0). Else, code this as -1.
1 = Consumer refused interview
2 = Not able to obtain consent from proxy
3 = Consumer was impaired/unable to provide consent
4 = Consumer cannot be reached for interview / * Applicable only to a reassessment or a clinical discharge (Assessment = 0601 to 0699). / * Must be entered for each reassessment due for the consumer before the start of the next reassessment interview window.
5= Staff previously indicated “Administrative data only” or “No data” would be submitted / * Applicable only to a reassessment or a clinical discharge (Assessment = 0601 to 0699).
* This code cannot be selected by the user. It is preselected based on a prior interview selection from the user (see crosscheck for details). / * If a reassessment or clinical discharge (Assessment = 0601 to 0699) and a previous interview had "Administrative data only", then the system will pre-fill that an interview was not conducted (ConductedInterview = 0) and Staff previously indicated "Administrative data only" or "No Data" would be submitted (WhyNotConducted = 5). For programs that require Section H, Section will still be required for current and future records (in same episode of care).
* If a clinical discharge (Assessment = 0699) and a previous interview indicated No data (NextReassessment = 3), then the system will pre-fill that an interview was not conducted (ConductedInterview = 0) and that Staff previously indicated “Administrative data only” or “No data” would be submitted (WhyNotConducted = 5). For programs that require Section H, Section H will be skipped for current and future records (in same episode of care).
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-5 = NOT ASKED ON PREVIOUS NOMS TOOL / * This N/A code is not valid for data entry. It is for Data Download purposes only. / * Coded only for questions not asked on previous versions of the TRAC NOMs tools.
NextReassessment / 2b / What data will be submitted for the next reassessment?
1 = Interview data (all sections).
2 = Administrative data only [Record Management, Sections H (if applicable), I or J, & K] – will not attempt any subsequent interviews. / * If Administrative data only, then:
-- All future reassessment records will be pre-filled so that an interview was not conducted (ConductedInterview = 0), Staff previously indicated Administrative data only" or "No data" would be submitted (WhyNotConducted = 5), and NextReassessment = 2. Only the Record Management and Sections H (if applicable) I and K will be submitted.
-- Clinical discharge record will be pre-filled so that an interview was not conducted (ConductedInterview = 0), Staff previously indicated “Administrative data only” or “No data” would be submitted (WhyNotConducted = 5), and NextReassessment = -1. Only the Record Management and Sections H (if applicable), J and K will be submitted.
3 = No data – will only provide discharge status [Record Management & Section J] when discharged. / * If No data - will only provide discharge status [Record Management and Section J] when the consumer is discharged (NextReassessment = 3), then:
-- Future reassessment records will not be permitted.
-- Clinical Discharge record will be pre-filled so that an interview was not conducted (ConductedInterview = 0), Staff previously indicated “Administrative data only” or “No data” would be submitted (WhyNotConducted = 5), and NextReassessment = -1. Only the Record Management and Section J will be submitted.
--No Services data will allowed in Section K - Services Received
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only. / If ConductedInterview = 1 (Yes) or Assessment = 0699 (Clinical Dicharge.
-5 = NOT ASKED ON PREVIOUS NOMS TOOL / * This N/A code is not valid for data entry. It is for Data Download purposes only. / * Coded only for questions not asked on previous versions of the TRAC NOMs tools.
SubmittedAtClinicalDischarge / 2c / [CLINICAL DISCHARGE ONLY] What data will be submitted for this Clinical Discharge? / * Applicable only if an interview was not conducted (ConductedInterview = 0) at Clinical Discharge (Assessment = 0699) and Consumer refused interview, Not able to obtain consent from proxy, Consumer was impaired/unable to provide consent or Consumer cannot be reached for interview (WhyNotConducted = 1, 2, 3 or 4)..
* If ConductedInterview = 1 (Yes) or Assessment = 0600 - 0611 then set SubmittedAtClinicalDischarge = -1.
1 = Administrative data only – [Record Management and Sections H (if applicable), J, & K]. / * Only the Record Management and Sections H (if applicable), J and K will be submitted for this Clinical Discharge record.
2 = No data – will only provide discharge status [Record Management & Section J]. / * Only the Record Management and Section J will be submitted for this Clinical Discharge record.
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only. / If ConductedInterview = 1 (Yes) or Assessment = 0699 (Clinical Dicharge.
-5 = NOT ASKED ON PREVIOUS NOMS TOOL / * This N/A code is not valid for data entry. It is for Data Download purposes only. / * Coded only for questions not asked on previous versions of the TRAC NOMs tools.
H. PBHCI: PHYSICAL HEALTH ITEMS [This section is always applicable (where program applies).]
BPressure_s / H1a / Systolic blood pressure / 40 - 400 (displayed in mmHg)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-7 = REFUSED
-9 = MISSING DATA
BPressure_d / H1b / Diastolic blood pressure / 20 - 250 (displayed in mmHg)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-7 = REFUSED
-9 = MISSING DATA
WeightKG / H1c / Weight in kg / 22 - 455 (displayed in kg)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-7 = REFUSED
-9 = MISSING DATA
HeightCM / H1d / Height in cm / 90 - 425 (displayed in cm)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-7 = REFUSED
-9 = MISSING DATA
WaistCircum / H1e / Waist circumference / 40 - 450 (displayed in cm)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-7 = REFUSED
-9 = MISSING DATA
BreathCO / H1f / BreathCO (ppm) - for smoking status / 0 - 250 (displayed in ppm)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-7 = REFUSED
-9 = MISSING DATA
8h_fast / H2 / Did patient successfully fast for 8 hours prior to providing the blood sample? / 0 = No / H3a-H3g will be defaulted to NOT APPLICABLE. / User may still edit H3a-H3g.
1 = Yes
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-5 = NOT REQUIRED AT THIS ASSESSMENT / H3a-H3g will be set to NOT REQUIRED AT THIS ASSESSMENT. / User cannot edit H3a-H3g unless H2 code is changed.
-7 = REFUSED / H3a-H3g will be defaulted to MISSING DATA
-8 = DON'T KNOW / H3a-H3g will be defaulted to MISSING DATA
-9 = MISSING DATA / H3a-H3g will be defaulted to MISSING DATA
DateBloodDraw / H3a / Date blood drawn / date entered will be converted to datetime
01/01/1869 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
05/01/1869 = NOT REQUIRED AT THIS ASSESSMENT / This value cannot be edited, unless 8h_fast is changed
06/01/1869 = NOT APPLICABLE / Only available if H2 = 0.
07/01/1869= REFUSED
08/01/1869= DON'T KNOW
09/01/1869 = MISSING DATA
Plasma_gluc / H3b / Fasting plasma glucose / 20 - 1500 (displayed in mg/dL)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-3 = PENDING LAB RESULTS
-5 = NOT REQUIRED AT THIS ASSESSMENT / This value cannot be edited, unless 8h_fast is changed
-6 = NOT APPLICABLE / Only available if H2 = 0.
-7 = REFUSED
-9 = MISSING DATA
HgbA1c / H3c / HgBA1c / 1 - 25 (displayed in %)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-3 = PENDING LAB RESULTS
-5 = NOT REQUIRED AT THIS ASSESSMENT / This value cannot be edited, unless 8h_fast is changed
-6 = NOT APPLICABLE / Only available if H2 = 0.
-7 = REFUSED
-9 = MISSING DATA
Lipid_TotChol / H3d / Total Cholesterol / 100 - 500 (displayed in mg/dL)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-3 = PENDING LAB RESULTS
-5 = NOT REQUIRED AT THIS ASSESSMENT / This value cannot be edited, unless 8h_fast is changed
-6 = NOT APPLICABLE / Only available if H2 = 0.
-7 = REFUSED
-9 = MISSING DATA
Lipid_HDL / H3e / HDL Cholesterol / 10 - 120 (displayed in mg/dL)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-3 = PENDING LAB RESULTS
-5 = NOT REQUIRED AT THIS ASSESSMENT / This value cannot be edited, unless 8h_fast is changed
-6 = NOT APPLICABLE / Only available if H2 = 0.
-7 = REFUSED
-9 = MISSING DATA
Lipid_LDL / H3f / LDL Cholesterol / 50 - 300 (displayed in mg/dL)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-3 = PENDING LAB RESULTS
-5 = NOT REQUIRED AT THIS ASSESSMENT / This value cannot be edited, unless 8h_fast is changed
-6 = NOT APPLICABLE / Only available if H2 = 0.
-7 = REFUSED
-9 = MISSING DATA
Lipid_Tri / H3g / Tricglycerides / 50 - 999 (displayed in mg/dL)
-1 = N/A / * This N/A code is not valid for data entry. It is for Data Download purposes only.
-3 = PENDING LAB RESULTS
-5 = NOT REQUIRED AT THIS ASSESSMENT / This value cannot be edited, unless 8h_fast is changed
-6 = NOT APPLICABLE / Only available if H2 = 0.
-7 = REFUSED
-9 = MISSING DATA

Version: 1.0.51Last updated: 10/11/2018

[1] Optional