Att_4 minimum data set

Attachment 4

0920-0740

Medical Monitoring Project (MMP)

Minimum Dataset Variables

SAS variable Number	eHARS PERSON dataset	SAS Variable Name	Label	Description	Values	SAS Format	HARS Var Name
405	stateno	STATENO	State patient number (STATENO)			stateno	stateno
260	dob	dob	Date of birth	The patient’s date of birth		YYYYMMDD	birth
203	dx_status	dx_status	Diagnostic status (calculated)	The calculated diagnostic status of the case.	1- Adult HIV (Stage 1, 2, or unknown)	$DX_STS	diagstat
					2- AIDS (HIV, Stage 3)
					3- Perinatal Exposure
					4- Pediatric HIV
					5- Pediatric AIDS
					6- Pediatric seroreverter
					9- Unknown, Not a Case
206	hiv_age_yrs	hiv_age_yrs	Age at HIV diagnosis (years)	The calculated age at HIV diagnosis in years			hage_yrs
152	aids_age_yrs	aids_age_yrs	Age at AIDS diagnosis (years)	The calculated age at AIDS (HIV, stage 3) diagnosis, in years			age_yrs
257	birth_sex	birth_sex	Sex at birth	The patient’s sex at birth	M- Male	$BTH_SEX	sex
					F- Female
					U- Unknown
258	current_gender	current_gender	Current gender	The patient’s current gender	CD- Cross dresser	$CUR_GEN	N/A
					DQ- Drag queen
					F- Female
					FM- Female to male
					I- Intersexed
					M- Male
					MF- Male to female
					SM- She male
259	current_sex	current_sex	Current sex	The patient’s current sex	M- Male	$CUR_SEX	N/A
					F- Female
					I- Intersexed
263	ethnicity1	ethnicity1	Ethnicity	The ethnicity of the patient (i.e., whether or not he/she is Hispanic/Latino)	E1- Hispanic or Latino	$ETHNIC	race, hisp ,ndi_hisp
					E1.01-Spaniard
					E1.02-Mexican
					E1.03-Central American
					E1.04-South American
					E1.05-Latin American
					E1.06-Puerto Rican
					E1.07-Cuban
					E1.08-Dominican
					E2-Not Hispanic or Latino
					Unk-Unknown
224	race	race	Race	Race (calculated)	1- Hispanic, any race	$C_RACE	N/A
					2- Not Hispanic, American Indian/Alaska Native
					3- Not Hispanic, Asian
					4- Not Hispanic, Black
					5- Not Hispanic, Native Hawaiian/Pacific Islander
					6- Not Hispanic, White
					7- Not Hispanic, Legacy Asian/Pacific Islander
					8- Not Hispanic, Multi-race
					9- Unknown
269	race1	race1	Race 1	The race of the patient	R1-American Indian / Alaska Native	$E_RACE	all HARS race fields
					R2-Asian
					R3-Black / African American
					R4-Native Hawaiian / Other Pacific Islander
					R5-White
					Unk-Unknown
270	race2	race2	Race 2	The race of the patient	R1-American Indian / Alaska Native	$E_RACE	all HARS race fields
					R2-Asian
					R3-Black / African American
					R4-Native Hawaiian / Other Pacific Islander
					R5-White
					Unk-Unknown
271	race3	race3	Race 3	The race of the patient	R1-American Indian / Alaska Native	$E_RACE	all HARS race fields
					R2-Asian
					R3-Black / African American
					R4-Native Hawaiian / Other Pacific Islander
					R5-White
					Unk-Unknown
272	race4	race4	Race 4	The race of the patient	R1-American Indian / Alaska Native	$E_RACE	all HARS race fields
					R2-Asian
					R3-Black / African American
					R4-Native Hawaiian / Other Pacific Islander
					R5-White
					Unk-Unknown
273	race5	race5	Race 5	The race of the patient	R1-American Indian / Alaska Native	$E_RACE	all HARS race fields
					R2-Asian
					R3-Black / African American
					R4-Native Hawaiian / Other Pacific Islander
					R5-White
					Unk-Unknown
255	birth_country_cd	birth_country_cd	Country code of birth	The patient’s country of birth	CountryUS_DependencyCode	$CTRY_CD	bhcntry
256	birth_country_usd (for US Dependencies)	birth_country_usd	Birth country, U.S. dependency code	The patient’s country of birth, if U.S. Dependency	CountryUS_DependencyCode	$CTRY_CD	bhosp_st bhcntry
555	sex_male	sex_male	Adult sex with male	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient have sexual relations with a male?	Y- Yes	$YNUCDC	sex_male
					N- No
					U- Unknown
					2- CDC confirmed
556	sex_female	sex_female	Adult sex with female	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient have sexual relations with a female?	Y- Yes	$YNUCDC	sex_fmle
					N- No
					U- Unknown
					2- CDC confirmed
557	idu	idu	Adult IDU	The adult patient injected non-prescription drugs.	Y- Yes	$YNUCDC	iv
					N- No
					U- Unknown
					2- CDC confirmed
574	bldprd_legacy	bldprd_legacy	Adult received clotting factor (LEGACY)	For an adult case: The person received clotting factor for hemophilia/coagulation disorder. (Legacy variable from HARS)	Y- Yes	$YNUCDC	bldprd
					N- No
					U- Unknown
					2- CDC Confirmed (applies to COPHI cases only)
558	clotting_factor	clotting_factor	Adult received clotting factor	For adult HIV cases: Person received clotting factor for hemophilia/coagulation disorder (as collected in eHARS, not HARS)	Y- Yes	$YNUCDC	N/A
					N- No
					U- Unknown
					2- CDC Confirmed (applies to COPHI cases only)
560	sex_idu	sex_idu	Adult heterosexual contact with IDU	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient have heterosexual relations with an intravenous/injection drug user?	Y- Yes	$YNUCDC	s_iv
					N- No
					U- Unknown
					2- CDC confirmed
561	sex_bisexual_male	sex_bisexual_male	Adult heterosexual contact with bisexual male	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient have heterosexual relations with a bisexual male?	Y- Yes	$YNUCDC	s_bi
					N- No
					U- Unknown
					2- CDC confirmed
562	sex_hemo	sex_hemo	Adult heterosexual contact with person with hemophilia	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient have heterosexual relations with a patient with hemophilia/coagulation disorder?	Y- Yes	$YNUCDC	s_hemo
					N- No
					U- Unknown
					2- CDC confirmed
563	sex_transfusion	sex_transfusion	Adult heterosexual contact with transfusion recipient with HIV infection	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did he patient have heterosexual relations with a transfusion recipient with documented HIV infection?	Y- Yes	$YNUCDC	s_tx
					N- No
					U- Unknown
					2- CDC confirmed
564	sex_transplant	sex_transplant	Adult heterosexual contact with transplant recipient with HIV infection	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient have heterosexual relations with a transplant recipient with documented HIV infection?	Y- Yes	$YNUCDC	s_trnplt
					N- No
					U- Unknown
					2- CDC confirmed
565	sex_hiv	sex_hiv	Adult heterosexual contact with person with HIV infection	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient have heterosexual relations with a patient with AIDS or documented HIV infection, risk not specified?	Y- Yes	$YNUCDC	s_hiv
					N- No
					U- Unknown
					2- CDC confirmed
566	transfusion	transfusion	Adult received transfusion	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient receive a transfusion of blood/blood products (other than clotting factor)?	Y- Yes	$YNUCDC	transfus
					N- No
					U- Unknown
					2- CDC Confirmed
569	transplant	transplant	Adult received transplant or artificial insemination	After 1977 and preceding the first positive HIV antibody test or AIDS (HIV, stage 3) diagnosis, did the patient receive a transplant of tissue/organs or, if the patient was female, artificial insemination?	Y- Yes	$YNUCDC	tranplnt
					N- No
					U- Unknown
					2- CDC Confirmed
264	hcw	hcw	Health care worker	Does this patient’s occupation involve working in the health care industry? This is a demographic variable and is not related to the risk factor variable.	Y- Yes	$YNU	N/A
					N- No
					U- Unknown
570	hcw_risk	hcw_risk	Adult worked in health care or clinical laboratory setting	Has the adult patient worked in a healthcare or clinical laboratory setting (as a health care worker) before acquiring HIV?	Y- Yes	$YNUCDC	hcw
					N- No
					U- Unknown
					2- CDC Confirmed
173	cd4_first_hiv_value	cd4_first_hiv_value	Value of first CD4 test after HIV diagnosis	The value of the first CD4 test after HIV diagnosis			N/A
174	cd4_low_cnt_dt	cd4_low_cnt_dt	Date of lowest CD4 count	The date of the lowest CD4 count test result value		YYYYMMDD	N/A
175	cd4_low_cnt_value	cd4_low_cnt_value	Value of lowest CD4 count	The lowest CD4 count test result value			N/A
176	cd4_low_pct_dt	cd4_low_pct_dt	Date of lowest CD4 percent	The date of the lowest CD4 percent test result value.		YYYYMMDD	N/A
177	cd4_low_pct_value	cd4_low_pct_value	Value of lowest CD4 percent	The lowest CD4 percent test result value.			N/A
178	cd4_recent_cnt_dt	cd4_recent_cnt_dt	Date of most recent CD4 count	The date of the most recent CD4 count.		YYYYMMDD	N/A
180	cd4_recent_cnt_value	cd4_recent_cnt_value	Value of most recent CD4 count	The value of the most recent CD4 count.			N/A
182	cd4_recent_pct_value	cd4_recent_pct_value	Value of most recent CD4 percent	The value of the most recent CD4 percent.			N/A
183	cd4_recent_cnt_pct_dt	cd4_recent_cnt_pct_dt	Date of most recent CD4 test (count or percent)	The date of the most recent CD4 test result (count or percent).		YYYYMMDD	N/A
164	cd4_first_14_dt	cd4_first_14_dt	Date of first CD4 percent < 14	The date of the first CD4 percent that was less than 14		YYYYMMDD	N/A
165	cd4_first_14_value	cd4_first_14_value	Value of first CD4 percent < 14	The value of the first CD4 percent that was less than 14			N/A
166	cd4_first_200_14_dt	cd4_first_200_14_dt	Date of first CD4 count < 200 or percent < 14	The date of the first CD4 count < 200 or CD4 percent < 14		YYYYMMDD	N/A
167	cd4_first_200_dt	cd4_first_200_dt	Date of first CD4 count < 200	The date of the first CD4 count that was less than 200		YYYYMMDD	N/A
168	cd4_first_200_value	cd4_first_200_value	Value of first CD4 count < 200	The value of the first CD4 count that was less than 200			N/A
169	cd4_first_350_dt	cd4_first_350_dt	Date of first CD4 count < 350	The date of the first CD4 count that was less than 350		YYYYMMDD	N/A
170	cd4_first_350_value	cd4_first_350_value	Value of first CD4 count < 350	The value of the first CD4 count that was less than 350			N/A
171	cd4_first_hiv_dt	cd4_first_hiv_dt	Date of first CD4 test after HIV diagnosis	The date of the first CD4 test after HIV diagnosis		YYYYMMDD	N/A
172	cd4_first_hiv_type	cd4_first_hiv_type	Type of first CD4 test after HIV diagnosis (count or percent)	The type of CD4 test after HIV diagnosis (count or percent)			N/A
173	cd4_first_hiv_value	cd4_first_hiv_value	Value of first CD4 test after HIV diagnosis	The value of the first CD4 test after HIV diagnosis			N/A
174	cd4_low_cnt_dt	cd4_low_cnt_dt	Date of lowest CD4 count	The date of the lowest CD4 count test result value		YYYYMMDD	N/A
175	cd4_low_cnt_value	cd4_low_cnt_value	Value of lowest CD4 count	The lowest CD4 count test result value			N/A
176	cd4_low_pct_dt	cd4_low_pct_dt	Date of lowest CD4 percent	The date of the lowest CD4 percent test result value.		YYYYMMDD	N/A
177	cd4_low_pct_value	cd4_low_pct_value	Value of lowest CD4 percent	The lowest CD4 percent test result value.			N/A
178	cd4_recent_cnt_dt	cd4_recent_cnt_dt	Date of most recent CD4 count	The date of the most recent CD4 count.		YYYYMMDD	N/A
179	cd4_recent_cnt_pct_dt	cd4_recent_cnt_pct_dt	Date of most recent CD4 test (count or percent)	The date of the most recent CD4 test result (count or percent).		YYYYMMDD	N/A
180	cd4_recent_cnt_value	cd4_recent_cnt_value	Value of most recent CD4 count	The value of the most recent CD4 count.			N/A
181	cd4_recent_pct_dt	cd4_recent_pct_dt	Date of most recent CD4 percent	The date of the most recent CD4 percent.		YYYYMMDD	N/A
182	cd4_recent_pct_value	cd4_recent_pct_value	Value of most recent CD4 percent	The value of the most recent CD4 percent.			N/A
183	cd4_vl_first_hiv_dt	cd4_vl_first_hiv_dt	Date of first CD4 or viral load test after HIV diagnosis	The date of the first CD4 or viral load test after HIV diagnosis		YYYYMMDD	N/A
184	cd4_vl_first_hiv_type	cd4_vl_first_hiv_type	Type of first test after HIV diagnosis (CD4 or viral load)	The type of the first test (CD4 or viral load test) on or after HIV diagnosis	1- CD4	$CD4_VL	N/A
					2- Viral Load
474	aids_insurance	aids_insurance	Primary reimbursement for medical treatment (AIDS)	At the time of AIDS (HIV, satge 3) diagnosis, the person’s primary reimbursement source for medical treatment	01- CHAMPUS/TRICARE	$INSURE	N/A
					02- CHIP
					03- Medicaid
					04- Medicaid, pending
					05- Medicare
					06- Other public funding
					07- Private insurance, HMO
					08- Private insurance, PPO
					09- Private insurance, unspecified
					10- Self insured
					11- State funded, COBRA
					12- State funded, other
					13- State funded, unspecified
					14- VA
					15- No health insurance
					88- Other
					99- Unknown
481	hiv_insurance	hiv_insurance	Primary reimbursement for medical treatment (HIV)	Primary reimbursement type for the patient’s HIV medical treatment at the time of HIV diagnosis	01- CHAMPUS/TRICARE	$INSURE	N/A
					02- CHIP
					03- Medicaid
					04- Medicaid, pending
					05- Medicare
					06- Other public funding
					07- Private insurance, HMO
					08- Private insurance, PPO
					09- Private insurance, unspecified
					10- Self insured
					11- State funded, COBRA
					12- State funded, other
					13- State funded, unspecified
					14- VA
					15- No health insurance
					88- Other
					99- Unknown
475	c_art	c_art	Patient received anti-retroviral therapy	For a pediatric case: Child received anti-retroviral therapy?	Y - Yes	$YNU	antiretv
					N - No
					U – Unknown
491	pcp_prophylaxis	pcp_prophylaxis	Received PCP prophylaxis	Received PCP prophylaxis?	Y- Yes	$YNU	pcpproph
					N- No
					U- Unknown
235	trans_categ	trans_categ	Transmission category	This calculated variable represents HIV exposure, based on a group of risk behaviors. The risk factors are grouped by adult and pediatric, based on the patient's age at diagnosis of HIV. The selection of the most likely route of transmission is based on a presumed hierarchical order of transmission.	01- Adult MSM	$TR_CAT	mode
					02- Adult IDU
					03- Adult MSM & IDU
					04- Adult received clotting factor
					05- Adult heterosexual contact
					06- Adult received transfusion/transplant
					07- Perinatal exposure, HIV diagnosed at age 13 years or older
					08- Adult with other confirmed risk
					09- Adult with no identified risk (NIR)
					10- Adult with no reported risk (NRR)
					11- Child received clotting factor
					12- Perinatal exposure
					13- Child received transf/transplant
					18- Child with other confirmed risk
					19- Child with no indentified risk (NIR)
					20- Child with no reported risk (NRR)
					99- Risk factors selected with no age at diagnosis
236	transx_categ	transx_categ	Expanded transmission category	This calculated variable represents an expanded list of HIV exposures, based on risk behaviors, grouped by adult and pediatric dependent on the patient's age at diagnosis of HIV.	See Section 3.10	$TRX_CAT	modex
196	death_rep_dt	death_rep_dt	Date death reported	The date on which the vital status of the case is changed to dead (vital_status = 2) in eHARS		YYYYMMDD	deathrep
194	death_age_mos	death_age_mos	Age at death (months)	The calculated age, in months, of the patient at the time of death			N/A
195	death_age_yrs	death_age_yrs	Age at death (years)	The calculated age, in years, of the patient at the time of death			N/A
151	aids_age_mos	aids_age_mos	Age at AIDS diagnosis (months)	The calculated age at AIDS (HIV, stage 3) diagnosis, in months			age_mos
153	aids_categ	aids_categ	AIDS case definition category	The CDC case definition for AIDS (HIV, stage 3) met by the patient; calculated based on lab information and opportunistic diseases entered for a person.	7 - AIDS (HIV, stage 3) case defined by immunologic (CD4 count or percent) criteria	$A_CAT	categ
				For a description of the algorithm used to calculate aids_categ, refer to section 8 of the eHARS Technical Reference Guide.	A- AIDS (HIV, stage 3) case defined by clinical disease (OI) criteria
					9- Not an AIDS (HIV, stage 3) case
156	aids_cdc	aids_cdc	CDC case definition for AIDS	Has this person met the CDC AIDS (HIV, stage 3) case definition?	Y- Yes	$YN	N/A
				To meet the CDC AIDS (HIV, stage 3) case definition, the case must be defined by immunologic criteria or clinical disease criteria (aids_categ = A or 7).	N – No
157	aids_cdc_elig	aids_cdc_elig	CDC eligibility for AIDS	If this person is an AIDS (HIV, stage 3) case, does this person/case meet CDC eligibility criteria?	Y- Yes	$YN	N/A
				To meet the CDC eligibility criteria for AIDS (HIV, stage 3), the case must be defined as AIDS by immunologic criteria or clinical disease criteria (i.e., aids_categ = A or 7) and have a person view status of either Active or Warning (status_flag = A or W).	N – No
158	aids_dx_dt	aids_dx_dt	Date of first AIDS classifying condition	The date of the first condition classifying as AIDS, based on the 1993 CDC AIDS case definition		YYYYMMDD	dxmoyr
159	aids_dxx_dt	aids_dxx_dt	Date of first AIDS classifying condition, applicable AIDS case definition	The date of the first condition classifying as AIDS, based on the applicable case definition. If the date is before 1993, eHARS returns the date of first OI diagnosis based on the pre-1993 expanded AIDS case definition (aids_oix_dt); otherwise, eHARS returns the date of the first AIDS classifying condition based on the current AIDS case definition (aids_dx_dt).		YYYYMMDD	dxx_moyr
163	antigen_first_pos_dt	antigen_first_pos_dt	First positive HIV antigen test result date	The first positive HIV antigen test result date; the earliest of all HIV-1 p24 Antigen tests entered for the patient		YYYYMMDD	N/A
185	class	class	HIV class	The HIV classification variable, based on the algorithm in HARS	A1- Asymptomatic (HIV, stage 1), CD4 count > 500 or percent > 29%	$CLASS	class
				For a description of the algorithm used to calculate class, refer to sections 8 and 18 of the eHARS Technical Reference Guide.	A2- Asymptomatic (HIV, stage 2), CD4 count 200-499 or percent 14-28%
					A3- Asymptomatic (HIV, stage 3), CD4 count < 200 or percent < 14%
					A9- Asymptomatic, unknown CD4
					B1- Symptomatic (HIV, stage 3), CD4 count > 500 or percent > 29%
					B2- Symptomatic (HIV, stage 3), CD4 count 200-499 or percent 14-28%
					B3- Symptomatic (HIV, stage 3), CD4 count < 200 or percent < 14%
					B9- Symptomatic (HIV, stage 3), unknown CD4
					C1- AIDS (HIV, stage 3), CD4 count > 500 or percent > 29%
					C2- AIDS (HIV, stage 3), CD4 count 200-499 or percent 14-28%
					C3- AIDS (HIV, stage 3), CD4 count < 200 or percent < 14%
					C9- AIDS (HIV, stage 3), unknown CD4
					X1- Unknown clinical category, CD4 count > 500 or percent > 29%
					X2- Unknown clinical category, CD4 count 200-499 or percent 14-28%
					X3- Unknown clinical category, CD4 count < 200 or percent < 14%
					X9- Unknown clinical category, unknown CD4
205	hiv_age_mos	hiv_age_mos	Age at HIV diagnosis (months)	The calculated age at HIV diagnosis, in months			hage_mos
251	dod	Date of death	The date the patient died		YYYYMMDD	death ndi_date
204	expo_categ	Exposure category	The exposure category of the patient	01- MSM Only	$EX_CAT	N/A
				02- IDU Only
				03- Heterosexual contact only
				04- MSM and IDU
				05- IDU & Hetero. Contact
				06- MSM & Hetero. Contact
				07- MSM & IDU & Hetero. Contact
				08- Perinatal Exposure
				09- Other
				10- No identified risk (NIR)
				11- No reported risk (NRR)
216	hiv_dx_dt	Date of first positive HIV test result or doctor diagnosis of HIV	The date of the diagnosis (first positive HIV test result or doctor diagnosis) of HIV infection		YYYYMMDD	hivpmoyr
220	hiv_rep_dt	Date reported as HIV positive	The date the case was reported to the health department as HIV positive; based on the eHARS system date when the HIV case definition category for the person/case (in Person View) changed to HIV Definitive (adult and pediatric cases) or Presumptive (pediatric cases only). Legacy HARS cases maintain their HIV report date (hposdate).		YYYYMMDD	hposdate
225	receive_dt	Earliest date the first document was received at the health department	Earliest date the first document was received at the health department; among all documents entered for a person, the earliest of either the date the document was entered in eHARS (document.entered_dt; assigned by the system) OR the date the document was received at the health department (document.receive_dt; entered by a user)			N/A
232	test_recent_dt	Date of most recent test result	The date of the most recent test result (CD4 or viral load)		YYYYMMDD	N/A
233	test_recent_type	Most recent test type	Most recent test type	1- CD4	$CD4_VL	N/A
				2- Viral load
234	test_recent_value	Most recent test result value	Most recent test result value; for viral load tests, displays copies/ml value; if there are CD4 count and percent results from the same day, displays the CD4 count value	POS- Positive	$PNI	N/A
				NEG- Negative
				IND- Indeterminate
274	vital_status	Vital status	The vital status of the patient	1- Alive	$VIT_STS	stat
				2- Dead
				9- Unknown
239	vl_last_non_det_dt	Date of last non-detectable viral load test result	The date of the last non-detectable viral load test		YYYYMMDD	N/A
240	vl_recent_dt	Date of most recent viral load test result	The date of the most recent viral load test		YYYYMMDD	N/A
241	vl_recent_value	Most recent viral load test result value (copies/ml)	The most recent viral load test result (copies/ml)			N/A