LightningStepEmr_Case_Review_Note_API_2023_Fields.xlsx

	A	B	C
1	Case Review Note Fields
2	2023-01-18
3
4	Name	Type	API Notes
5	id	int unsigned	Not considered, set automatically by API
6	datedoc	date	Optional, defaults to current date
7	timedoc	time	Optional, defaults to current time
8	discipline	varchar(50)	Required, must be from list obtained via endpoint
9	fname	varchar(50)	Not considered, set automatically by API
10	lname	varchar(50)	Not considered, set automatically by API
11	client_id	int	Optional, defaults from inquiry_id if not sent
12	episode_id	int	Optional, defaults from inquiry_id if not sent
13	inquiry_id	int	Required
14	admission_id	int	Not considered, set automatically by API
15	location_id	int	Not considered, set automatically by API
16	mrn	varchar(25)	Not considered, set automatically by API
17	dob	date	Not considered, set automatically by API
18	staff_id	int	Required
19	sfname	varchar(50)	Not considered, set automatically by API
20	slname	varchar(50)	Not considered, set automatically by API
21	sigline	varchar(100)	Not considered, set automatically by API
22	sigfield	text	Not considered, set automatically by API
23	datestaffsig	datetime	Not considered, set automatically by API
24	usetxt1	tinyint	Not considered, set automatically by API
25	captiontxt1	varchar(150)	Not considered, set automatically by API
26	txtsize1	int	Not considered, set automatically by API
27	txt1	text	Optional, defaults to null
28	usetxt2	tinyint	Not considered, set automatically by API
29	captiontxt2	varchar(150)	Not considered, set automatically by API
30	txtsize2	int	Not considered, set automatically by API
31	txt2	text	Optional, defaults to null
32	usetxt3	tinyint	Not considered, set automatically by API
33	captiontxt3	varchar(150)	Not considered, set automatically by API
34	txtsize3	int	Not considered, set automatically by API
35	txt3	text	Optional, defaults to null
36	usetxt4	tinyint	Not considered, set automatically by API
37	captiontxt4	varchar(150)	Not considered, set automatically by API
38	txtsize4	int	Not considered, set automatically by API
39	txt4	text	Optional, defaults to null
40	usetxt5	tinyint	Not considered, set automatically by API
41	captiontxt5	varchar(150)	Not considered, set automatically by API
42	txtsize5	int	Not considered, set automatically by API
43	txt5	text	Optional, defaults to null
44	subject	varchar(150)	Optional, defaults based on Discipline
45	captionfld1	varchar(150)	Not considered, set automatically by API
46	captionfld2	varchar(150)	Not considered, set automatically by API
47	captionfld3	varchar(150)	Not considered, set automatically by API
48	captionfld4	varchar(150)	Not considered, set automatically by API
49	captionfld5	varchar(150)	Not considered, set automatically by API
50	fld1	varchar(150)	Optional, defaults to null
51	fld2	varchar(150)	Optional, defaults to null
52	fld3	varchar(150)	Optional, defaults to null
53	fld4	varchar(150)	Optional, defaults to null
54	fld5	varchar(150)	Optional, defaults to null
55	duration	int	Deprecated, not used
56	isattached	tinyint	Not considered, set automatically by API
57	txteamnote_id	int	Not considered, set automatically by API
58	ifs	tinyint(1)	Not considered, set automatically by API
59	luby_id	int	Not considered, set automatically by API
60	eie	tinyint(1)	Optional, defaults to 0
61	dss	tinyint(1)	Optional, defaults to 0
62	qccstatus	tinyint	Not considered, set automatically by API
63	supstatus	tinyint	Not considered, set automatically by API
64	qcc_id	int	Not considered, set automatically by API
65	datesupsig	datetime	Not considered, set automatically by API
66	supsigfield	text	Not considered, set automatically by API
67	supsigline	varchar(100)	Not considered, set automatically by API
68	requiresreview	tinyint	Not considered, set automatically by API
69	sup_id	int	Not considered, set automatically by API
70	suprequired	tinyint	Not considered, set automatically by API
71	qccrequired	tinyint	Not considered, set automatically by API
72	qccdoc_id	int	Not considered, set automatically by API
73	supdoc_id	int	Not considered, set automatically by API
74	created_at	timestamp	Not considered, set automatically by API
75	updated_at	timestamp	Not considered, set automatically by API
76	tmptxteamnote_id	int	Not considered, set automatically by API
77	service_id	int unsigned	Not considered, set automatically by API
78	servicename	varchar(100)	Not considered, set automatically by API
79	sourcesig_id	int unsigned	Set based on staff_id
80	srccasereviewnote_id	int unsigned	Not considered, set automatically by API
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100