Medicaid Data Layout.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1	Medicaid Data Layout
2	Column Name:	billing_state	billing_npi	servicing_npi	proc_code	yrmonth	num_benes	num_claims	paid_amt	ao_fname	ao_mname	ao_lname	billing_org_name	billing_fname	billing_mname	billing_lname	billing_credentials	billing_orgname_other	billing_addr1	billing_addr2	billing_city	billing_state	billing_zip	servicing_org_name	servicing_fname	servicing_mname	servicing_lname	servicing_credentials	servicing_orgname_other	servicing_addr1	servicing_addr2	servicing_city	servicing_state	servicing_zip
3	Column Label:	location state of the billing provider	billing provider NPI	servicing provider NPI	HCPCS procedure code	year-month of date of service	number of Medicaid beneficiaries	number of claims	total paid amt	authorized official first name	authorized official middle name	authorized official last name	billing provider org name	billing provider first name	billing provider middle name	billing provider last name	billing provider credentials	billing provider other name	billing provider street 1	billing provider street2	billing provider city	billing provider state	billing provider zip code	servicing provider name	servicing provider first name	servicing provider middle name	servicing provider last name	servicing provider credentials	servicing provider other name	servicing provider street 1	servicing provider street 2	servicing provider city	servicing provider state	servicing provider zip
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100