IIHE Information, HFHS Panel Field Dictionary

Field	Length	Type	Description
Medical Record Number	8	Text	HFHS patient medical record number
Plan Number	9	Text	HAP patient ID number
Site Cd	-	number	General Ledger site code that PCP's revenue center is assigned to
		19	Hamtramck
		57	State Fair
		76	East Jefferson
		80	Detroit Northwest
		83	Detroit East
Revenue Center Cd	6	Text	Revenue/cost center where procedure/visit occurred
REV_CEN_NAME	40	Text	Name of the Revenue/cost center where patient is assigned
Capitation Type Cd	1	Text	Capitation type code
		C	Capitated
		N	Non-capitated
Product Line Cd	1	Text	Product line code
		R	Regular
		S	Senior Plus
		C	Medicare Complementary
		M	Medicaid Regular
		W	Medicaid Complementary
		P	Preferred Provider Organization (PPO)
Age Major Group	1	Text	Member major age group
		1	Pediatrics (18 and under)
		2	Adults (19-64)
		3	Geriatrics (65+)
Age Minor Group	2	Text	Member minor age group
		01	0-5 months
		02	6-23 months
		03	2-4 years
		04	5-12 years
		05	13-18 years
		06	19-39 years
		07	40-54 years
		08	55-64 years
		09	65-74 years
		10	75+ years
Age Year Count	-	Number	Patient age in years at date of encounter
Financial Class Cd	1	Text	Patient financial class code; indicates which broad classification of insurance has primary financial responsibility for patient
		0	Private
		1	HAP
		2	Blue Cross
		3	HMO
		4	Medicare A & B
		5	Medicaid
		6	County Care
		7	Commercial
		9	PHP
		A	Senior Plus
		C	Campus
		G	HFHS Self Insured
		H	Blue Choice
		J	Medicare B Only
		N	Pending MA / MCC / RCH
		R	Research Grant
		W	Workers Compensation
		X	Industrial Medicine
		Z	Workers Compensation
Primary Care Physician	5	Text	Primary care physician code
PCP Name	25	Text	Primary care physician name
PCP Specialty Cd	3	Text	Primary care physician specialty code; indicates the specialty the revenue center physician is associated with
Primary Provider Cd	5	Text	Primary provider code
PP Name	25	Text	Primary provider name
Sex Cd	1	Text	Member's gender
		M	Male
		F	Female
Birth Date	-	Date	Member's date of birth
Last Name	20	Text	Member's last name
First Name	20	Text	Member's first name
Middle Initial	1	Text	Member's middle initial
Address 1	30	Text	Member's address
Address 2	30	Text	Member's address continuation line
City	25	Text	City where member lives
State	2	Text	State where member lives
Zip Cd	5	Text	Zip code where member lives
Home Phone	10	Text	Home phone number of member
Work Phone	10	Text	Work phone number of member
Death Indicator	1	Text	Indicates whether the member has died
		blank	The member is alive
		1	The member has died

	HFHS Panel Field Dictionary
IIHE \| Information \| HFHS Panel Field Dictionary