LightningStepEmr_Uploaded_Document_API_2021_Fields.xlsx

	A	B	C	D	E	F	G
1	Uploaded Documents (exdocs) fields
2
3	Field_Name	Field_Type	Nullable?	Field_Description	API_Usage	API Create?	Notes:
4	id	int(10) unsigned	NO	Record ID	System calculated	N
5	datedoc	date	YES	Document Date	Optional, must be current or past, future not allowed, defaults to current date	Y
6	fname	varchar(50)	YES	First Name	Calculated from Inquiry_ID	N
7	lname	varchar(50)	YES	Last Name	Calculated from Inquiry_ID	N
8	title	varchar(50)	YES	Title	Optional	Y
9	keywords	varchar(150)	YES	Optional	Optional	Y
10	category	varchar(150)	YES	Category	Optional, defaults to “Imported Document”	Y
11	mrn	varchar(25)	YES	MRN	Calculated from Inquiry_ID	N
12	staff_id	int(11)	YES	Staff ID	Calculated from API Information	N
13	sfname	varchar(50)	YES	Staff First Name	Calculated from API Information	N
14	slname	varchar(50)	YES	Staff Last Name	Calculated from API Information	N
15	sigline	varchar(100)	YES	Staff Sigline	Calculated from API Information	N
16	client_id	int(11)	YES	Client_ID	Calculated from Inquiry_ID	N
17	episode_id	int(11)	YES	Episode_ID	Calculated from Inquiry_ID	N
18	admission_id	int(11)	YES	Admission ID	Calculated from Inquiry_ID	N
19	inquiry_id	int(11)	YES	Inquiry_ID	Required	Y
20	authlog_id	int(11)	YES	Authlog_ID	Optional, defaults to null	Y
21	filename	varchar(150)	YES	Filename	Calculated based on imported file	N
22	filelocation	text	YES	File Location	Calculated based on imported file	N
23	content	longblob	YES	Deprecated	No longer used, defaults to null	N
24	docsize	float(10,2)	YES	File Size	Calculated based on imported file	N
25	mimetype	varchar(100)	YES	MIME Type	Calculated based on imported file	N
26	eie	tinyint(1)	YES	Entered in Error	System calculated	N	Use Delete route
27	created_at	timestamp	YES	Create Date	System calculated	N
28	updated_at	timestamp	YES	Update Date	System calculated	N
29	thadmission_id	int(11)	YES	Telehealth Admission ID	System calculated	N
30	thepisode_id	int(11)	YES	Telehealth Episode	System calculated	N
31	thclient_id	int(11)	YES	Telehealth Client ID	System calculated	N
32	casemgmt_id	int(11)	YES	Case Management ID	System calculated	N
33	uploaded_by	varchar(50)	YES	Uploaded By	Calculated from API Information	N
34	src	varchar(50)	YES	Source	Optional, defaults to “API Import”	Y
35	accesstype_allowed	varchar(50)	YES	Deprecated	No longer used, defaults to null	N
36	ulogin_id	int(11)	YES	Portal Login ID	Calculated from Inquiry_ID	N
37	fupclient_id	int(11)	YES	Follow Up Client ID	Calculated from Inquiry_ID	N
38	location_id	int(11)	YES	Location ID	Optional	Y
39	resident_id	int(11)	YES	Resident ID	System calculated	N
40	doc_id	int(11)	YES	Document ID	System calculated	N
41	modelname	varchar(50)	YES	Model Name	System calculated	N
42	url	varchar(255)	YES	Deprecated	No longer used, defaults to null	N
43	location	varchar(50)	YES	Location Name	Optional, defaults to Null	N
44	displayfilename	varchar(255)	YES	Display Filename	System calculated	N
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