4a - MMP variables

Attachment 4a

MMP Formative Research Minimum Dataset Variables, Person-Level Variables from eHARS

SAS variable Number	eHARS dataset name	SAS Variable Name	Label	Description	Values	SAS Format	HARS Var Name
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
253	aids_age_mos_entered	aids_age_mos_entered	Entered age at AIDS diagnosis (months)	The entered age at AIDS diagnosis, in months; the system does not validate this field; therefore, an incorrect age at diagnosis could potentially be entered.			age_mos
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
254	aids_age_yrs_entered	aids_age_yrs_entered	Entered age at AIDS diagnosis (years)	The entered age at AIDS (HIV, stage 3) diagnosis, in years; the system does not validate this field; therefore, an incorrect age at diagnosis could be entered.			age_yrs
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. For a description of the algorithm used to calculate aids_categ, refer to section 8 of the eHARS Technical Reference Guide.	7 - AIDS (HIV, stage 3) case defined by immunologic (CD4 count or percent) criteria, A- AIDS (HIV, stage 3) case defined by clinical disease (OI) criteria, 9- Not an AIDS (HIV, stage 3) case	$A_CAT	categ
156	aids_cdc	aids_cdc	CDC case definition for AIDS	Has this person met the CDC AIDS (HIV, stage 3) case definition? 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).	Y- Yes, N – No	$YN	N/A
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? 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).	Y- Yes, N – No	$YN	N/A
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
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, 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	$INSURE	N/A
162	aids_rep_dt	aids_rep_dt	Date reported as AIDS (HIV, stage 3)	The date reported to the health department as AIDS (HIV, stage 3)		YYYYMMDD	N/A
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
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
257	birth_sex	birth_sex	Sex at birth	The patient’s sex at birth	M- Male, F- Female, U- Unknown	$BTH_SEX	sex
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, N- No, U- Unknown, 2- CDC Confirmed (applies to COPHI cases only)Yes	$YNUCDC	bldprd
475	c_art	c_art	Patient received anti-retroviral therapy	For a pediatric case: Child received anti-retroviral therapy?	Y – Yes, N – No, U – Unknown	$YNU	antiretv
598	c_bldprd_legacy	c_bldprd_legacy	Child received clotting factor (LEGACY)	For a pediatric case: Did the child receive clotting factor? (Legacy variable from HARS)	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	bldprd
588	c_clotting_factor	c_clotting_factor	Child received clotting factor	For a pediatric case: The child had received clotting factor for hemophilia/coagulation disorder. This is collected in eHARS, not HARS. In eHARS, this is considered a COPHI risk factor.	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	N/A
587	c_idu	c_idu	Child IDU	For a pediatric case: Had the child injected nonprescription drugs?	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	iv
597	c_nir	c_nir	Child no identified risk factor (NIR)	For a pediatric case: Did the child have no identified risk factors?	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	N/A
596	c_oth_risk	c_oth_risk	Child other documented risk	For a pediatric case: Before the diagnosis of HIV infection, did this patient have any risk behavior other than those specified by the other risk behavior questions? (Refer to p. 7-15 of eHARS Technical Reference Guide for a list of pediatric risk factors.)	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	oth_risk
595	c_sex_female	c_sex_female	Child sexual contact with female	For a pediatric case: The child had sexual relations with a female.	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	sex_fmle
594	c_sex_male	c_sex_male	Child sexual contact with male	For a pediatric case: The child had sexual relations with male.	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	sex_male
590	c_transfusion	c_transfusion	Child received transfusion	For a pediatric case: The child had received transfusion of blood/blood components other than clotting factor.	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	transfus
593	c_transplant	c_transplant	Child received transplant	For a pediatric case: The child had received transplant of tissue/organs.	Y- Yes, N - No, U - Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	tranplnt
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
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 2- Viral Load	$CD4_VL	N/A
390	cityno	CITYNO	The CITYNO variable for the patient			cityno	390
185	class	class	HIV class	The HIV classification variable, based on the algorithm in HARS. For a description of the algorithm used to calculate class, refer to sections 8 and 18 of the eHARS Technical Reference Guide.	A1- Asymptomatic (HIV, stage 1), CD4 count > 500 or percent > 29%, 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	$CLASS	class
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, N- No, U- Unknown, 2- CDC Confirmed (applies to COPHI cases only)	$YNUCDC	N/A
258	current_gender	current_gender	Current gender	The patient’s current gender	CD- Cross dresser, DQ- Drag queen, F- Female, FM- Female to male, I- Intersexed, M- Male, MF- Male to female, SM- She male	$CUR_GEN	N/A
259	current_sex	current_sex	Current sex	The patient’s current sex	M- Male F- Female I- Intersexed	$CUR_SEX	N/A
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
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
260	dob	dob	Date of birth	The patient’s date of birth		YYYYMMDD	birth
251	dod	Date of death	The date the patient died		YYYYMMDD	death ndi_date
203	dx_status	dx_status	Diagnostic status (calculated)	The calculated diagnostic status of the case.	1- Adult HIV (Stage 1, 2, or unknown), 2- AIDS (HIV, Stage 3), 3- Perinatal Exposure, 4- Pediatric HIV, 5- Pediatric AIDS, 6- Pediatric seroreverter, 9- Unknown, Not a Case	$DX_STS	diagstat
263	ethnicity1	ethnicity1	Ethnicity	The ethnicity of the patient (i.e., whether or not he/she is Hispanic/Latino)	E1- Hispanic or Latino 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	$ETHNIC	race, hisp ,ndi_hisp
204	expo_categ	Exposure category	The exposure category of the patient	01- MSM Only, 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)	$EX_CAT	N/A
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 N- No, U- Unknown	$YNU	N/A
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 N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	hcw
205	hiv_age_mos	hiv_age_mos	Age at HIV diagnosis (months)	The calculated age at HIV diagnosis, in months			hage_mos
266	hiv_age_mos_entered	hiv_age_mos_entered	Entered age at HIV diagnosis (months)	The entered age at HIV diagnosis, in months; this is not validated by the system, meaning an incorrect age at diagnosis could potentially be entered.			hage_mos
206	hiv_age_yrs	hiv_age_yrs	Age at HIV diagnosis (years)	The calculated age at HIV diagnosis in years			hage_yrs
267	hiv_age_yrs_entered	hiv_age_yrs_entered	Entered age at HIV diagnosis (years)	The entered age at HIV diagnosis, in years; this is not validated by the system, meaning an incorrect age at diagnosis could be entered.			hage_yrs
207	hiv_aids_age_mos	hiv_aids_age_mos	Age at HIV disease diagnosis (months)	Age at HIV disease diagnosis, in months; the algorithm takes the earlier of the two ages (calculated age at diagnosis of HIV [Stage 1, 2, or unknown] or AIDS [HIV, stage 3]).			N/A
208	hiv_aids_age_yrs	hiv_aids_age_yrs	Age at HIV disease diagnosis (years)	Age at HIV disease diagnosis, in years. The algorithm takes the earlier of the two ages (calculated age at diagnosis of HIV [stage 1, 2, or unknown] or AIDS [HIV, stage 3]).			N/A
285	hiv_aids_dx_dt	hiv_aids_dx_dt	HIV disease diagnosis date	Compares the following dates and returns the earliest of the three: • the date of the first positive HIV test result or physician diagnosis of HIV (hiv_dx_dt, calc_obs_uid 224) • the date of the first AIDS-defining condition based on the current AIDS case definition (aids_dx_dt, calc_obs_uid 281) • the date of the first AIDS-defining condition based on the applicable AIDS case definition (aids_dxx_dt, calc_obs_uid 280)
213	hiv_categ	hiv_categ	HIV case definition category	Calculates the CDC HIV case definition met by the patient, based on the guidelines that became effective January 1, 2000; HARS legacy cases remain included; the value for hiv_categ can change based on updated information.	1- HIV positive definitive	$H_CAT	hcateg
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
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, 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	$INSURE	N/A
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
557	idu	idu	Adult IDU	The adult patient injected non-prescription drugs.	Y- Yes, N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	iv
482	informed	Informed of HIV infection	Has this patient been informed of his/her HIV infection?	Y- Yes, N - No, U - Unknown	$YNU	informed	482
577	m_hiv_perinatal	m_hiv_perinatal	Mother perinatally acquired HIV infection	For a pediatric case: The mother had perinatally acquired HIV infection.	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	N/A
576	m_hiv_status	m_hiv_status	Mother's infection status	For a pediatric case: This field provides the HIV status category (the maternal infection status) of the child’s biologic mother.	1- Refused HIV testing, 2- Known UNINFECTED after birth, 3- Know HIV+ before pregnancy, 4- Know HIV+ during pregnancy, 5- Known HIV+ at time of delivery, 6- Known HIV+ sometime before birth, 7- Known HIV+ sometime after birth, 8- HIV+ with time unknown, 9- Unknown	$INF_STS	mhivstat
578	m_idu	m_idu	Mother IDU	For a pediatric case: After 1977 and before the child’s birth, did the mother inject non-prescription drugs?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_ivda
580	m_sex_bisexual_male	m_sex_bisexual_male	Mother heterosexual contact with bisexual male	For a pediatric case: After 1977 and before the child’s birth, did the mother have heterosexual relations with a bisexual male?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_sexhbi
581	m_sex_hemo	m_sex_hemo	Mother heterosexual contact with male with hemophilia	For a pediatric case: After 1977 and before the child’s birth, did the mother have heterosexual relations with a male with hemophilia/coagulation disorder?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_sexhem
584	m_sex_hiv	m_sex_hiv	Mother had heterosexual contact with male with HIV infection	For a pediatric case: After 1977 and before the child’s birth, did the mother have heterosexual relations with a male diagnosed with HIV disease, risk not specified?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_sexhiv
579	m_sex_idu	m_sex_idu	Mother heterosexual contact with IDU	For a pediatric case: After 1977 and before the child’s birth, did the mother have heterosexual relations with an intravenous/injecting drug user?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_sexiv
582	m_sex_transfusion	m_sex_transfusion	Mother had heterosexual contact with transfusion recipient with HIV infection	For a pediatric case: After 1977 and before the child’s birth, did the mother have heterosexual relations with a transfusion recipient with documented HIV infection?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_sextrn
583	m_sex_transplant	m_sex_transplant	Mother had heterosexual contact with transplant recipient with HIV infection	For a pediatric case: After 1977 and before the child’s birth, did the mother have heterosexual relations with a transplant recipient with documented HIV infection?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_sextpl
585	m_transfusion	m_transfusion	Mother received transfusion	For a pediatric case: After 1977 and before the child’s birth, did the mother receive a transfusion of blood/blood components (other than clotting factor)?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_trans
586	m_transplant	m_transplant	Mother received transplant or artificial insemination	For a pediatric case: After 1977 and before the child’s birth, did the mother receive a transplant of tissue/organs or artificial insemination?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	m_trnplt
573	nir	nir	Adult no identified risk factor (NIR)	Does the adult case have identified risk factors? (NIR)	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	N/A
572	oth_risk	oth_risk	Adult other documented risk	For an adult case: Before the diagnosis of HIV, did this patient have any risk behavior other than those specified by the other risk behavior questions?	Y- Yes,N- No, U- Unknown 2 - CDC confirmed	$YNUCDC	oth_risk
491	pcp_prophylaxis	pcp_prophylaxis	Received PCP prophylaxis	Received PCP prophylaxis?	Y – Yes, N – No, U – Unknown	$YNU	pcpproph
492	pcp_prophylaxis_dt	pcp_prophylaxis_dt	Date received PCP prophylaxis	Date received PCP prophylaxis		YYYYMMDD	pcp_date
224	race	race	Race	Race (calculated)	1- Hispanic, any race, 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	$C_RACE	N/A
269	race1	race1	Race 1	The race of the patient	R1-American Indian / Alaska Native, R2-Asian, R3-Black / African American, R4-Native Hawaiian / Other Pacific Islander, R5-White, Unk-Unknown	$E_RACE	all HARS race fields
270	race2	race2	Race 2	The race of the patient	R1-American Indian / Alaska Native, R2-Asian, R3-Black / African American,R4-Native Hawaiian / Other Pacific Islander,R5-White, Unk-Unknown	$E_RACE	all HARS race fields
271	race3	race3	Race 3	The race of the patient	R1-American Indian / Alaska Native, R2-Asian, R3-Black / African American, R4-Native Hawaiian / Other Pacific Islander, R5-White, Unk-Unknown	$E_RACE	all HARS race fields
272	race4	race4	Race 4	The race of the patient	R1-American Indian / Alaska Native, R2-Asian, R3-Black / African American,R4-Native Hawaiian / Other Pacific Islander, R5-White, Unk-Unknown	$E_RACE	all HARS race fields
273	race5	race5	Race 5	The race of the patient	R1-American Indian / Alaska Native, R2-Asian, R3-Black / African American, R4-Native Hawaiian / Other Pacific Islander, R5-White, Unk-Unknown	$E_RACE	all HARS race fields
225	receive_dt	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
68	rsa_city_fips	rsa_city_fips	City FIPS code of residence at AIDS diagnosis	City FIPS code for the city of residence at the time of AIDS (HIV, stage 3) diagnosis	See Section 3.1		rgeocty
67	rsa_city_name	rsa_city_name	City of residence at AIDS diagnosis	The patient's city of residence at the time of AIDS (HIV, stage 3) diagnosis, based on FIPS city code			rcity
73	rsa_country_cd	rsa_country_cd	Country code of residence at AIDS diagnosis	The ISO country code for the country of residence at the time of AIDS (HIV, stage 3) diagnosis	See Section 3.2	$CTRY_CD	rcntry
74	rsa_country_usd	rsa_country_usd	U.S. dependency code of residence at AIDS diagnosis	The FIPS US Dependency code for the US Dependency of residence at the time of AIDS (HIV, stage 3) diagnosis (where applicable)	See Section 3.2	$CTRY_CD	st, rcntry
70	rsa_county_fips	rsa_county_fips	County FIPS code of residence at AIDS diagnosis	The FIPS code for the county of residence at the time of AIDS (HIV, stage 3) diagnosis	See Section 3.1		rgeoco
69	rsa_county_name	rsa_county_name	County of residence at AIDS diagnosis	The patient's county of residence at the time of earliest AIDS (HIV, stage 3) diagnosis, based on the FIPS county of residence			rcounty
71	rsa_state_cd	rsa_state_cd	State of residence at AIDS diagnosis	The patient's state of residence at the time of AIDS (HIV, stage 3) diagnosis (i.e., time of the first AIDS classifying condition; aids_dxx_dt)	See Section 3.5	$STATE	st
52	rsh_city_fips	rsh_city_fips	City FIPS code of residence at HIV diagnosis	The FIPS code for the city of residence at the time of HIV (stage 1, 2, or unknown) diagnosis	See Section 3.1		hrgeocty
51	rsh_city_name	rsh_city_name	City of residence at HIV diagnosis	The patient's city of residence at the time of HIV (stage 1, 2, or unknown) diagnosis; based on FIPS city code			hcity
57	rsh_country_cd	rsh_country_cd	Country code of residence at HIV diagnosis	The ISO country code for the country of residence at the time of HIV (stage 1, 2, or unknown) diagnosis	See Section 3.2	$CTRY_CD	hzip
58	rsh_country_usd	rsh_country_usd	U.S. dependency code of residence at HIV diagnosis	The FIPS US dependency code for the US dependency of residence at the time of HIV (stage 1, 2, or unknown) diagnosis (where applicable)	See Section 3.2	$CTRY_CD	hst rhcntry
54	rsh_county_fips	rsh_county_fips	County FIPS code of residence at HIV diagnosis	The FIPS code for the county of residence at the time of HIV (stage 1, 2, or unknown) diagnosis	See Section 3.1		hrgeoco
53	rsh_county_name	rsh_county_name	County of residence at HIV diagnosis	The patient's county of residence at the time of HIV (stage 1, 2, or unknown) diagnosis; based on the FIPS county of residence			hcounty
55	rsh_state_cd	rsh_state_cd	State of residence at HIV diagnosis	The patient's state of residence at the time of HIV (stage 1, 2, or unknown) diagnosis (i.e., time of the first positive HIV test result or doctor diagnosis of HIV; hiv_dx_dt)	See Section 3.5	$STATE	hst
500	Report_state_cd	Report_state_cd		Reporting state
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 N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	s_bi
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, N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	sex_fmle
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 N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	s_hemo
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 N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	s_hiv
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, N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	s_iv
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, N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	sex_male
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 N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	s_tx
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 N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	s_trnplt
504	site_cd	site_cd	Site code	Unique identifier (state code + two digits) that represents the reporting site or location where eHARS is installed; For states with multiple jurisdictions/decentralized eHARS, the site code represents the area that entered the document into eHARS.			N/A
405	stateno	STATENO	State patient number (STATENO)			stateno	stateno
505	status_flag	status_flag	Person View status	Person view status, Active = Active case; data will be transferred to CDC if case is CDC eligible. Deleted = The Person View and all documents pertaining to this person have been marked for deletion. Error = Critical edit checks have failed. The Person View and all related documents will not be used in the national dataset and/or for national reporting purposes. Moved = All documents for this person have been moved/merged to another person. Purged = Case has been deleted, acknowledged by CDC, and can be purged from database. Required field missing = Fields that are needed to determine CDC case eligibility are missing. (For more information on required fields, refer to section 3 of the eHARS Technical Reference Guide.) Warning = Non-critical edit checks have failed, but case's data will be transferred to CDC.	A- Active, D- Deleted, E- Error, M- Moved, P- Purged, R- Required field missing, W- Warning	$PV_STS	status
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, 2- Viral load	$CD4_VL	N/A
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, NEG- Negative, IND- Indeterminate	$PNI	N/A
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, 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	$TR_CAT	mode
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 N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	transfus
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 N- No, U- Unknown, 2- CDC confirmed	$YNUCDC	tranplnt
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
274	vital_status	Vital status	The vital status of the patient	1- Alive, 2- Dead, 9- Unknown	$VIT_STS	stat
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