LightningStepEmr_Episode_API_2023_Fields.xlsx

	A	B
1	Field	Type
2	AccountId	varchar(50)
3	additionalnote	text
4	address	varchar(150)
5	address2	varchar(150)
6	admission_id	int
7	admittingfacility	varchar(100)
8	admittingloc	varchar(50)
9	admittingusstate	varchar(50)
10	age	int
11	alias	varchar(50)
12	aliasfname	varchar(50)
13	aliaslname	varchar(50)
14	apnea	tinyint
15	benefitphone	varchar(15)
16	call_source_id	mediumtext
17	caller_as_contact	tinyint(1)
18	callercphone	varchar(25)
19	calleremail	varchar(150)
20	callerfname	varchar(100)
21	callerhphone	varchar(25)
22	callerlname	varchar(100)
23	callerwphone	varchar(15)
24	calltype	varchar(100)
25	city	varchar(50)
26	clearanceoutcome	varchar(50)
27	clearancesentto	varchar(100)
28	Client__c	varchar(50)
29	client_id	int
30	closedby_id	int
31	closereason	varchar(150)
32	cmorg_id	int unsigned
33	cmperson_id	int unsigned
34	compref	varchar(50)
35	country	Varchar(3)
36	county	varchar(40)
37	cphone	varchar(25)
38	created_at	timestamp
39	CreatedById	varchar(50)
40	CreatedDate	datetime
41	ctm_source_name	tinyint
42	dateadmission	date
43	dateclosed	date
44	datedischarge	date
45	datedoc	date
46	datepgmadmission	date
47	datereferout	date
48	disposition_code	varchar(2)
49	dob	date
50	doc	varchar(50)
51	dom	int
52	doy	int
53	dss	tinyint(1)
54	dtclosed	datetime
55	eie	tinyint(1)
56	email	varchar(150)
57	emergconsentstatus	varchar(50)
58	emergcontact	varchar(100)
59	emergphone	varchar(25)
60	emergreltoclient	varchar(100)
61	empstatus	varchar(50)
62	episodenum	int
63	ethnicity	varchar(100)
64	expected_los	int unsigned
65	financialprofile	varchar(25)
66	fname	varchar(100)
67	fundingsrc	varchar(50)
68	gender	varchar(50)
69	grade	varchar(10)
70	groupnumber	varchar(15)
71	household	varchar(150)
72	howhear	varchar(150)
73	hphone	varchar(25)
74	id	int unsigned
75	import_id	int
76	incomerange	varchar(25)
77	inquiries	varchar(100)
78	inquiry_id	int(11)
79	inquirydispo	varchar(150)
80	inquirystatus	varchar(50)
81	insaddress	varchar(100)
82	inscity	varchar(50)
83	inscphone	varchar(15)
84	insdob	date
85	insemployer	varchar(100)
86	insfname	varchar(50)
87	insgender	varchar(100)
88	inshphone	varchar(15)
89	insispg	tinyint(4)
90	inslname	varchar(50)
91	insreltoclient	varchar(50)
92	insssn	varchar(15)
93	insusstate	varchar(5)
94	inswphone	varchar(15)
95	inszip	varchar(10)
96	isalias	tinyint
97	isclosed	tinyint
98	ised	tinyint
99	isfromctm	tinyint
100	isimport	tinyint