Data Import Template

[NCIPC] OD2A: LOCAL Linkage to and Retention in Care Surveillance

Att D - OD2A_LOCAL_LTC_Data_Import_Template_Aggregate_v2.xlsx

Data Import Template

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

Data Dictionary
Data Import Template-Indicators

Sheet 1: Data Dictionary
Variable Name Description Subset of Other Indicators Field Type Values Years 2/3
Required or Optional		 Years 4/5
Required or Optional
jurisdiction The name of the local jurisdiction
Character ACPA - Allegheny County, PA
BCMD - Baltimore County, MD
BCFL - Broward County, FL
CCOH - Cuyahoga County, OH
DCFL - Duval County, FL
FCOH - Franklin County, OH
HCOH - Hamilton County, OH
NHCT - City of New Haven, CT
PBCFL - Palm Beach County, FL
PHPA - Philadelphia, PA
PCAZ - Pima County, AZ
SKCWA - Seattle & King County, WA		 R R
quarter The one-digit value corresponding to the quarter of the calendar year (1=Jan-Mar, 2=Apr-Jun, 3=Jul-Sept, 4=Oct-Dec).
Numeric 1, 2, 3, 4 R R
year The four-digit calendar year (e.g., 2024)
Date YYYY R R
entry_point Setting where individuals with a treatment need for opioid use/Opioid Use Disorder or stimulant use/Stimulant Use Disorder are identified.
Character 1 - Nonfatal overdose
2 - Other clinical
3 - Criminal justice
4 - Harm reduction program
5 - Community-based program
6 - Self-referral
7 - Other		 R
(At least one other entry point is required)		 R
(At least one other entry point is required)
substance_type The specific category of substance use or substance use disorder (Opioid Use Disorder or Stimulant Use Disorder) that prompts the recognition of a treatment need or the need for linkage to care.
Character 1 - Opioids
2 - Stimulants		 R
O		 R
R
sex Four categories: Total, Male, Female, Missing
Character 1 - Total
2 - Male
3 - Female
4 - Missing		 O R
age_group Eleven categories: Total, 0-14 years, 15-24 years, 25-34 years, 35-44 years, 45-54 years, 55-64 years, 65-74 years, 75-84 years, 85 years and up, missing
Character 1 - Total
2 - 0-14 years
3 - 15-24 years
4 - 25-34 years
5 - 35-44 years
6 - 45-54 years
7 - 55-64 years
8 - 65-74 years
9 - 75-84 years
10 - 85 years and up
11 - Missing		 O R
race Ten categories: Total, American Indian or Alaska Native, Asian, Black or African American, Middle Eastern or North African, Native Hawaiian or Pacific Islander, White, Multiple race, Other race, Unknown or Missing
Character 1 - Total
2 - American Indian or Alaska Native
3 - Asian
4 - Black or African American
5 - Middle Eastern or North African
6 - Native Hawaiian or Pacific Islander
7 - White
8 - Multiple race
9 - Other race
10 - Unknown or Missing		 O R
ethnicity Four categories: Total, Hispanic/Latino, non-Hispanic/Latino, Unknown or Missing
Character 1 - Total
2 - Hispanic or Latino
3 - Non-Hispanic or Latino
4 - Unknown or Missing		 O R
identified_n The number of persons identified with a treatment need during the reporting period.
Numeric n/a R R
engaged_n Among those identified with a treatment need during the reporting period, the number of persons engaged by linkage to care program staff. identified_n Numeric n/a R R
refer_anytx_n Among those identified with a treatment need during the reporting period, the number of persons who were referred to MOUD or behavioral treatment. identified_n Numeric n/a O R
refer_MOUD_n Among those identified with a treatment need during the reporting period, the number of persons who were referred to MOUD. identified_n
refer_anytx_n		 Numeric n/a R R
refer_behav_n Among those identified with a treatment need during the reporting period, the number of persons who were referred to behavioral health treatment. identified_n
refer_anytx_n		 Numeric n/a O R
refer_harmred_n Among those identified with a treatment need during the reporting period, the number of persons who were referred to harm reduction services. identified_n
 Numeric n/a R R
initiate_anytx_n Among those identified with a treatment need during the reporting period, the number of persons who were successfully linked to MOUD or behavioral health treatment (e.g. initiated MOUD or behavioral health treatment). identified_n Numeric n/a O R
initiate_MOUD_n Among those identified with a treatment need during the reporting period, the number of persons who were successfully linked to MOUD (e.g. initiated MOUD). identified_n Numeric n/a R R
initiate_behav_n Among those identified with a treatment need during the reporting period, the number of persons who were successfully linked to behavioral health treatment (e.g. initiated behavioral health treatment). identified_n Numeric n/a O R
initiate_harmred_n Among those identified with a treatment need during the reporting period, the number of persons who were successfully linked to harm reduction services (e.g. initiated harm reduction services). identified_n Numeric n/a R R
status_MOUD_retain_n Among those identified with a treatment need during the reporting period who were linked to MOUD, the number of persons who are retained in treatment 6 months after initiating MOUD treatment. identified_n
initiate_MOUD_n		 Numeric n/a R R
status_MOUD_compl_n Among those identified with a treatment need during the reporting period who are linked to MOUD, the number of persons who completed treatment within 6 months after initiating MOUD treatment. identified_n
initiate_MOUD_n		 Numeric n/a R R
status_MOUD_lost_n Among those identified with a treatment need during the reporting period who are linked to MOUD, the number of persons who were lost to follow-up (e.g., did not complete the treatment program and are no longer active in treatment) within 6 months after initiating MOUD treatment. identified_n
initiate_MOUD_n		 Numeric n/a R R
status_MOUD_incarc_n Among those identified with a treatment need during the reporting period who are linked to MOUD, the number of persons who are incarcerated 6 months after initiating MOUD treatment. identified_n
initiate_MOUD_n		 Numeric n/a R R
status_MOUD_decd_n Among those identified with a treatment need during the reporting period who were linked to MOUD, the number of persons who are deceased 6 months after initiating MOUD treatment. identified_n
initiate_MOUD_n		 Numeric n/a R R
status_MOUD_oth_n Among those identified with a treatment need during the reporting period who were linked to MOUD, the number of persons who had another known status 6 months after initiating MOUD treatment. identified_n
initiate_MOUD_n		 Numeric n/a R R
status_MOUD_unkn_n Among those identified with a treatment need during the reporting period who were linked to MOUD, the number of persons who had unknown status 6 months after initiating MOUD treatment. identified_n
initiate_MOUD_n		 Numeric n/a R R
status_behav_retain_n Among those identified with a treatment need during the reporting period who were linked to behavioral treatment, the number of persons who are retained in treatment 6 months after initiating behavioral treatment. identified_n
initiate_behav_n		 Numeric n/a O R
status_behav_compl_n Among those identified with a treatment need during the reporting period who were linked to behavioral treatment, the number of persons who completed treatment within 6 months after initiating behavioral treatment. identified_n
initiate_behav_n		 Numeric n/a O R
status_behav_lost_n Among those identified with a treatment need during the reporting period who are linked to behavioral treatment, the number of persons who were lost to follow-up (e.g., did not complete the treatment program and are no longer active in treatment) within 6 months after initiating behavioral treatment. identified_n
initiate_behav_n		 Numeric n/a O R
status_behav_incarc_n Among those identified with a treatment need during the reporting period who were linked to behavioral treatment, the number of persons who are incarcerated 6 months after initiating behavioral treatment. identified_n
initiate_behav_n		 Numeric n/a O R
status_behav_decd_n Among those identified with a treatment need during the reporting period who were linked to behavioral treatment, the number of persons who are deceased 6 months after initiating behavioral treatment. identified_n
initiate_behav_n		 Numeric n/a O R
status_behav_oth_n Among those identified with a treatment need during the reporting period who were linked to behavioral treatment, the number of persons who had another known status 6 months after initiating behavioral treatment. identified_n
initiate_behav_n		 Numeric n/a O R
status_behav_unkn_n Among those identified with a treatment need during the reporting period who were linked to behavioral treatment, the number of persons who had unknown status 6 months after initiating behavioral treatment. identified_n
initiate_behav_n		 Numeric n/a O R

Sheet 2: Data Import Template-Indicators
jurisdiction quarter year entry_point substance_type sex age_group race ethnicity identified_n engaged_n refer_anytx_n refer_MOUD_n refer_behav_n refer_harmred_n initiate_anytx_n initiate_MOUD_n initiate_behav_n initiate_harmred_n status_MOUD_retain_n status_MOUD_compl_n status_MOUD_lost_n status_MOUD_incarc_n status_MOUD_decd_n status_MOUD_oth_n status_MOUD_unkn_n status_behav_retain_n status_behav_compl_n status_behav_lost_n status_behav_incarc_n status_behav_decd_n status_behav_oth_n status_behav_unkn_n




Opioids Total Total Total Total



























Opioids Female Total Total Total



























Opioids Male Total Total Total



























Opioids Missing Total Total Total



























Opioids Total 0-14 Total Total



























Opioids Total 15-24 Total Total



























Opioids Total 25-34 Total Total



























Opioids Total 35-44 Total Total



























Opioids Total 45-54 Total Total



























Opioids Total 55-64 Total Total



























Opioids Total 65-74 Total Total



























Opioids Total 75-84 Total Total



























Opioids Total 85 years and up Total Total



























Opioids Total Missing Total Total



























Opioids Total Total American Indian or Alaska Native Not Hispanic or Latino



























Opioids Total Total Asian Not Hispanic or Latino



























Opioids Total Total Black or African American Not Hispanic or Latino



























Opioids Total Total Middle Eastern or North African Not Hispanic or Latino



























Opioids Total Total Native Hawaiian or Pacific Islander Not Hispanic or Latino



























Opioids Total Total White Not Hispanic or Latino



























Opioids Total Total Multiple race Not Hispanic or Latino



























Opioids Total Total Other race Not Hispanic or Latino



























Opioids Total Total Unknown or Missing Not Hispanic or Latino



























Opioids Total Total American Indian or Alaska Native Hispanic or Latino



























Opioids Total Total Asian Hispanic or Latino



























Opioids Total Total Black or African American Hispanic or Latino



























Opioids Total Total Middle Eastern or North African Hispanic or Latino



























Opioids Total Total Native Hawaiian or Pacific Islander Hispanic or Latino



























Opioids Total Total White Hispanic or Latino



























Opioids Total Total Multiple race Hispanic or Latino



























Opioids Total Total Other race Hispanic or Latino



























Opioids Total Total Unknown or Missing Hispanic or Latino



























Opioids Total Total American Indian or Alaska Native Unknown or Missing



























Opioids Total Total Asian Unknown or Missing



























Opioids Total Total Black or African American Unknown or Missing



























Opioids Total Total Middle Eastern or North African Unknown or Missing



























Opioids Total Total Native Hawaiian or Pacific Islander Unknown or Missing



























Opioids Total Total White Unknown or Missing



























Opioids Total Total Multiple race Unknown or Missing



























Opioids Total Total Other race Unknown or Missing



























Opioids Total Total Unknown or Missing Unknown or Missing



























Stimulants Total Total Total Total



























Stimulants Female Total Total Total



























Stimulants Male Total Total Total



























Stimulants Missing Total Total Total



























Stimulants Total 0-14 Total Total



























Stimulants Total 15-24 Total Total



























Stimulants Total 25-34 Total Total



























Stimulants Total 35-44 Total Total



























Stimulants Total 45-54 Total Total



























Stimulants Total 55-64 Total Total



























Stimulants Total 65-74 Total Total



























Stimulants Total 75-84 Total Total



























Stimulants Total 85 years and up Total Total



























Stimulants Total Missing Total Total



























Stimulants Total Total American Indian or Alaska Native Not Hispanic or Latino



























Stimulants Total Total Asian Not Hispanic or Latino



























Stimulants Total Total Black or African American Not Hispanic or Latino



























Stimulants Total Total Middle Eastern or North African Not Hispanic or Latino



























Stimulants Total Total Native Hawaiian or Pacific Islander Not Hispanic or Latino



























Stimulants Total Total White Not Hispanic or Latino



























Stimulants Total Total Multiple race Not Hispanic or Latino



























Stimulants Total Total Other race Not Hispanic or Latino



























Stimulants Total Total Unknown or Missing Not Hispanic or Latino



























Stimulants Total Total American Indian or Alaska Native Hispanic or Latino



























Stimulants Total Total Asian Hispanic or Latino



























Stimulants Total Total Black or African American Hispanic or Latino



























Stimulants Total Total Middle Eastern or North African Hispanic or Latino



























Stimulants Total Total Native Hawaiian or Pacific Islander Hispanic or Latino



























Stimulants Total Total White Hispanic or Latino



























Stimulants Total Total Multiple race Hispanic or Latino



























Stimulants Total Total Other race Hispanic or Latino



























Stimulants Total Total Unknown or Missing Hispanic or Latino



























Stimulants Total Total American Indian or Alaska Native Unknown or Missing



























Stimulants Total Total Asian Unknown or Missing



























Stimulants Total Total Black or African American Unknown or Missing



























Stimulants Total Total Middle Eastern or North African Unknown or Missing



























Stimulants Total Total Native Hawaiian or Pacific Islander Unknown or Missing



























Stimulants Total Total White Unknown or Missing



























Stimulants Total Total Multiple race Unknown or Missing



























Stimulants Total Total Other race Unknown or Missing



























Stimulants Total Total Unknown or Missing Unknown or Missing



























Opioids Total Total Total Total



























Opioids Female Total Total Total



























Opioids Male Total Total Total



























Opioids Missing Total Total Total



























Opioids Total 0-14 Total Total



























Opioids Total 15-24 Total Total



























Opioids Total 25-34 Total Total



























Opioids Total 35-44 Total Total



























Opioids Total 45-54 Total Total



























Opioids Total 55-64 Total Total



























Opioids Total 65-74 Total Total



























Opioids Total 75-84 Total Total



























Opioids Total 85 years and up Total Total



























Opioids Total Missing Total Total



























Opioids Total Total American Indian or Alaska Native Not Hispanic or Latino



























Opioids Total Total Asian Not Hispanic or Latino



























Opioids Total Total Black or African American Not Hispanic or Latino



























Opioids Total Total Middle Eastern or North African Not Hispanic or Latino



























Opioids Total Total Native Hawaiian or Pacific Islander Not Hispanic or Latino



























Opioids Total Total White Not Hispanic or Latino



























Opioids Total Total Multiple race Not Hispanic or Latino



























Opioids Total Total Other race Not Hispanic or Latino



























Opioids Total Total Unknown or Missing Not Hispanic or Latino



























Opioids Total Total American Indian or Alaska Native Hispanic or Latino



























Opioids Total Total Asian Hispanic or Latino



























Opioids Total Total Black or African American Hispanic or Latino



























Opioids Total Total Middle Eastern or North African Hispanic or Latino



























Opioids Total Total Native Hawaiian or Pacific Islander Hispanic or Latino



























Opioids Total Total White Hispanic or Latino



























Opioids Total Total Multiple race Hispanic or Latino



























Opioids Total Total Other race Hispanic or Latino



























Opioids Total Total Unknown or Missing Hispanic or Latino



























Opioids Total Total American Indian or Alaska Native Unknown or Missing



























Opioids Total Total Asian Unknown or Missing



























Opioids Total Total Black or African American Unknown or Missing



























Opioids Total Total Middle Eastern or North African Unknown or Missing



























Opioids Total Total Native Hawaiian or Pacific Islander Unknown or Missing



























Opioids Total Total White Unknown or Missing



























Opioids Total Total Multiple race Unknown or Missing



























Opioids Total Total Other race Unknown or Missing



























Opioids Total Total Unknown or Missing Unknown or Missing



























Stimulants Total Total Total Total



























Stimulants Female Total Total Total



























Stimulants Male Total Total Total



























Stimulants Missing Total Total Total



























Stimulants Total 0-14 Total Total



























Stimulants Total 15-24 Total Total



























Stimulants Total 25-34 Total Total



























Stimulants Total 35-44 Total Total



























Stimulants Total 45-54 Total Total



























Stimulants Total 55-64 Total Total



























Stimulants Total 65-74 Total Total



























Stimulants Total 75-84 Total Total



























Stimulants Total 85 years and up Total Total



























Stimulants Total Missing Total Total



























Stimulants Total Total American Indian or Alaska Native Not Hispanic or Latino



























Stimulants Total Total Asian Not Hispanic or Latino



























Stimulants Total Total Black or African American Not Hispanic or Latino



























Stimulants Total Total Middle Eastern or North African Not Hispanic or Latino



























Stimulants Total Total Native Hawaiian or Pacific Islander Not Hispanic or Latino



























Stimulants Total Total White Not Hispanic or Latino



























Stimulants Total Total Multiple race Not Hispanic or Latino



























Stimulants Total Total Other race Not Hispanic or Latino



























Stimulants Total Total Unknown or Missing Not Hispanic or Latino



























Stimulants Total Total American Indian or Alaska Native Hispanic or Latino



























Stimulants Total Total Asian Hispanic or Latino



























Stimulants Total Total Black or African American Hispanic or Latino



























Stimulants Total Total Middle Eastern or North African Hispanic or Latino



























Stimulants Total Total Native Hawaiian or Pacific Islander Hispanic or Latino



























Stimulants Total Total White Hispanic or Latino



























Stimulants Total Total Multiple race Hispanic or Latino



























Stimulants Total Total Other race Hispanic or Latino



























Stimulants Total Total Unknown or Missing Hispanic or Latino



























Stimulants Total Total American Indian or Alaska Native Unknown or Missing



























Stimulants Total Total Asian Unknown or Missing



























Stimulants Total Total Black or African American Unknown or Missing



























Stimulants Total Total Middle Eastern or North African Unknown or Missing



























Stimulants Total Total Native Hawaiian or Pacific Islander Unknown or Missing



























Stimulants Total Total White Unknown or Missing



























Stimulants Total Total Multiple race Unknown or Missing



























Stimulants Total Total Other race Unknown or Missing



























Stimulants Total Total Unknown or Missing Unknown or Missing























File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00
© 2026 OMB.report | Privacy Policy