IIHE Information, HFHS Visits Field Dictionary

Field	Length	Type	Description
MRN	8	Text	HFHS patient medical record number (8 characters)
SITE_CD	-	Number	HFHS site code where visit occurred
		8	HENRY FORD - LASALLE CNTR
		1B	BELMONT - HFCCC
		1D	WESTPARK BEHAVIORAL SRVCS
		1E	HENRY FORD WEST BLMFLD
		1F	CLINTON OAKS BEHAVIORAL
		1J	ASSOCIATES OF BIRMINGHAM
		1V	ASSOCIATES OF BIRMINGHAM
		10	CENTER FOR HEALTH PROMO
		11	HENRY FORD HEALTH SYSTEM
		12	HENRY FORD GREENFIELD HS
		13	HENRY FORD KINGSWOOD HOSP
		14	HENRY FORD NEW CNTR PAV
		15	HENRY FORD DETROIT CENTER
		16	HENRY FORD BROOKFIELD
		17	HENRY FORD BIOSTATS RES
		18	HENRY FORD EPILEPSY CTR
		19	HENRY FORD HAMTRAMCK
		2N	DEARBORN ACCESS CLINIC
		2P	NEUROSURG ASSOC OKLND TRY
		2R	HARBORTOWN
		2T	HENRY FORD TROY
		2U	ORAL SURGERY UDM
		2Y	NEW CENTER ONE
		20	HENRY FORD HOSPITAL
		21	HENRY FORD TAYLOR DIALYS
		22	HENRY FORD TROY DIALYSIS
		25	HENRY FORD GRANTS
		26	BEAUMONT NEUROSURGERY
		27	RIVERSIDE HOSPITAL
		28	FITNESS CENTER
		29	HENRY FORD FAIRLANE DIALY
		3A	OAKLAND HOSPITAL - WB
		3N	DEPART OF NEUROSURGERY
		30	HENRY FORD FAIRLANE
		31	HENRY FORD WEST BLOOMFLD
		32	HENRY FORD STERLING HGTS
		33	HENRY FORD LAKESIDE
		34	WEST BLOOMFIELD PSYCH
		35	HENRY FORD TROY
		36	HENRY FORD TAYLOR
		37	HENRY FORD WOODHAVEN
		38	KALEIDOSCOPE KIDS
		39	HENRY FORD HEALTH SYSTEM
		40	HENRY FORD ORCHARD LAKE
		42	CLINTON OAKS
		44	BIRMINGHAM AOB PSYCH
		46	OAKWOOD NEUROSURGERY
		48	HENRY FORD GROSSE PT OPTH
		49	HENRY FORD SOMERSET IVF
		50	HENRY FORD PLYMOUTH
		51	HENRY FORD ROCHESTER
		52	HENRY FORD REDFORD
		53	HENRY FORD ROYAL OAK
		54	HENRY FORD SOUTHFIELD
		55	HENRY FORD SOUTHLAND
		56	HENRY FORD WARREN
		57	STATE FAIR MEDICAL CENTER
		58	HENRY FORD OPTIMEYES
		59	HENRY FORD WATERFORD
		60	HENRY FORD NORTHFIELD
		61	HENRY FORD ANN ARBOR
		62	HENRY FORD CANTON
		63	HENRY FORD WESTLAND
64	HFH ST JOES CANCER CENTER
66	HENRY FORD ROCHESTER
67	HENRY FORD PIERSON
68	HENRY FORD BLOOMFLD TWP
69	HENRY FORD GM TECH CTR
70	HENRY FORD KINGSWOOD
71	HENRY FORD WBC TELEG PT
72	HENRY FORD DOWNRIVER PT
73	HENRY FORD POINTE CLNC
74	HENRY FORD LIVONIA
76	HENRY FORD JEFFERSON
77	HENRY FORD TRAUMA BRAIN
78	HENRY FORD N BALTIMORE
79	HENRY FORD COTTAGE HOSP
80	HENRY FORD DETROIT NW
81	HENRY FORD LIVONIA
82	HENRY FORD DEARBORN MED
83	HENRY FORD DETROIT EAST
84	HENRY FORD ALLEN PARK
85	HENRY FORD ROSEVILLE MED
86	HENRY FORD SOUTHFIELD
87	HENRY FORD NOVI
88	HENRY FORD HAMTRAMCK
89	HENRY FORD REHAB SRVS
90	WYANDOTTE HOSPITAL
91	HENRY FORD HEALTH SYSTEM
93	HENRY FORD STORAGE
94	HENRY FORD EXPIRED
95	HENRY FORD FAIRLANE STG
96	HENRY FORD RETIREMENT VIL
97	HENRY FORD SENIOR INDEP
98	JOSEPHINE FORD CANCER CTR
DX_CD_PRI	7	Text	Primary diagnosis code assigned by doctor which is used for billing
DX_CD_PRI_SHORT_DESC	24	Text	Description of Primary diagnosis code
DX_CD_ENC	7	Text	Diagnosis code assigned by CSR, based on patient's reason for encounter
DX_CD_ADDTL1	7	Text	Additional diagnosis code assigned by doctor
DX_CD_ADDTL2	7	Text	Additional diagnosis code assigned by doctor
ENCNTR_TP_CD	3	Text	Code indicating type of encounter/visit
		ER
		OPP	Outpatients seen in a clinic by HFMG-credentialed provider.
		OPN	Outpatient medical no-charge visits in a clinic with HFMG-credentialed provider.
		OPA	Outpatients seen in a clinic by non-credentialed provider.
PROD_LN_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)
REVCTR	6	Text	Revenue/cost center code where procedure/visit occurred
REVCTR_NAME	40	Text	Revenue/cost center name
SERV_DT	-	Date	Date service was performed
AGE_YR_CT	-	Number	Patient age (in years) at date of encounter
SEX_CD	1	Text	Patient gender
		M	Male
		F	Female
RACE_CD	1	Text	Patient race
		A	Asian
		B	Black/African-American
		C	Caucasian
		H	Hispanic
		I	Native American/American Indian
		M	Middle Eastern
		O	Oriental
		U	Unknown
		Z	Other
MAR_STAT_CD	1	Text	Patient marital status
		D	Divorce
		M	Married
		S	Single
		U	Unknown
		W	Widowed
		X	Legally Separated
FIN_CLS_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
ZIP_CD	5	Text	Patient zip code (5 characters)
DR_CD	5	Text	HFHS assigned physician ID number who rendered service being charged
DR_NAME	25	Text	HFHS assigned physician name
DR_SPEC_CD_PRI	3	Text	Code for doctor's primary specialty as determined by certification
		ALC	Alcoholism Treatment
		ALL	Allergy
		AMB	Ambulatory Surgery
		ANE	Anesthesiology
		ATH	Athletic Medicine
		AUD	Audiology
		BON	Bone And Mineral
		CAD	Cardiovascular Disease
		CAR	Cardiology
		CAT	Cat Scan
		COL	Colon & Rectal Surgery
		DEN	Dentistry
		DER	Dermatology
		DXR	Diagnostic Radiology
		EHC	Employee Health Center
		EME	Emergency Medicine
		EMI	EMI
		END	Endocrinology
		EXM	Executive Medicine
		FAM	Family Practice
		FLX	Flexible
		GAS	Gastroenterology
		GEN	Genetics
		GEP	General Practice
		GER	Geriatrics Outreach
		GYN	Gynecology
		GYO	GYN/Oncology
		HEM	Hematology
		HYP	Hypertension
		IMG	Internal Medicine
		INF	Infectious Disease
		LAB	Laboratory
		LSL	Geriatric Center - LSL
		MDS	Medical Department Service
		MD1	Medical Division One
		MD2	Medical Division Two
		MD3	Medical Division Three
		MD4	Fourth Medical Division
		MD5	Fifth Medical Division
		MD6	MD6 Executive Medicine
		MD7	Fairlane Exec Medicine
		MD8	MD8 W Bloomfield Medicine
		MD9	Other Satellite Medicine
		MED	Medical Admin (Consults)
		MET	Metabolic Disease
		MGS	Metro General Surgery
		MGY	Metro GYN
		MMC	Metro Medical Conner
		MMT	Metro Medical Tuxedo
		MMW	Metro Medical Wyoming
		MNB	Metro Newborn
		MOB	Metro OB/GYN
		MON	Metro Oncology
		MOP	Metro Ophthalmology
		MOR	Metro Orthopedics
		MUR	Metro Urology
		NEM	New Employee
		NEP	Nephrology
		NES	Neurological Surgery
		NEU	Neurology
		NPS	Neuropsychology
		NUT	Nutrition
		OBG	Obstetrics/Gynecology
OBS	Obstetrics
OCM	Occupational Medicine
OCT	Occupation Therapy
ONC	Oncology
OPH	Ophthalmology
OPT	Optometry
ORA	Oral Surgery
ORT	Orthopedic Surgery
OTO	Otolaryngology
PAL	Pediatric Allergy
PAT	Pathology
PCA	Pediatric Cardiology
PDE	Pediatric Dentistry
PED	Pediatrics
PHO	Peds Hematology Oncology
PHT	Physical Therapy
PLA	Plastic & Recon Surgery
PNE	Pediatric Newborn
POD	Podiatry
POR	Pediatric Orthopedics
PPS	Pediatric Psychology
PSU	Pediatric Surgery
PSY	Psychiatry
PUL	Pulmonary Disease
RAD	Radiology
RHE	Rheumatology
SLC	Sleep Center
SPP	Speech Pathology
SUB	Substance Abuse
SUR	General Surgery
THE	Therapeutic Radiology
THO	Thoracic & Cardiac Surgery
TRA	Trauma Surgery
TRS	Transplant Surgery
ULS	Ultrasound
URO	Urology
VAS	Vascular Surgery
STAFF_DR_CD	5	Text	HFHS staff physician code
STAFF_DR_NAME	25	Text	HFHS staff physician name

	HFHS Visits Field Dictionary
IIHE \| Information \| HFHS Visits Field Dictionary