LightningStepEmr_Admission_API_2022_Fields.xlsx

	A	B	C
1	Admissions Table
2
3	Name	Type	API Notes
4	id	int unsigned	Not Considered, set by system
5	datedoc	date	Defaults to dateadmission
6	fname	varchar(50)	Set by Inquiry
7	lname	varchar(50)	Set by Inquiry
8	inquiry_id	int	Required
9	client_id	int	Optional, set by inquiry
10	episode_id	int	Optional, set by inquiry
11	eie	tinyint(1)	Defaults to 0
12	dss	tinyint(1)	Defaults to 0
13	program_id	int	Required
14	subprogram_id	int unsigned	Required
15	location_id	int	Required
16	provideruser_id	int unsigned	Optional
17	status_id	int	Not Considered, set by system
18	sfname	varchar(50)	Optional
19	slname	varchar(50)	Optional
20	mrn	varchar(25)	Optional, set by inquiry
21	staff_id	int	Optional
22	dateadmission	date	Optional, defaults to current date
23	timeadmission	time	Optional, defaults to current time
24	transferto_id	int	Not Considered, set by system
25	datetransfer	date	Not Considered, set by system
26	timetransfer	time	Not Considered, set by system
27	datedischarge	date	Not Considered, set by system
28	timedischarge	time	Not Considered, set by system
29	dctype_id	int	Not Considered, set by system
30	successful_dc	tinyint(1)	Not Considered, set by system
31	unit_id	int	Optional
32	bed_id	int	Optional
33	room_id	int	Optional
34	unitname	varchar(150)	Not Considered, set by system
35	program	varchar(150)	Not Considered, set by system
36	status	varchar(100)	Not Considered, set by system
37	dctype	varchar(150)	Not Considered, set by system
38	created_at	timestamp	Not Considered, set by system
39	transferlocation_id	int	Not Considered, set by system
40	updated_at	timestamp	Not Considered, set by system
41	datenewepisode	date	Not Considered, set by system
42	isnewepisode	tinyint	Not Considered, set by system
43	LastModifiedDate	datetime	Not Considered, set by system
44	sobject	varchar(50)	Not Considered, set by system
45	recordid	varchar(50)	Not Considered, set by system
46	gender	varchar(25)	Optional, set by inquiry
47	lsdtupdate	datetime	Not Considered, set by system
48	lsluby_id	int	Not Considered, set by system
49	sf_id	varchar(50)	Optional
50	fupclient_id	int	Not Considered, set by system
51	mname	varchar(25)	Optional, set by inquiry
52	fuplname	varchar(50)	Not Considered, set by system
53	fupfname	varchar(50)	Not Considered, set by system
54	fupstaff_id	int	Not Considered, set by system
55	datefupdue	date	Not Considered, set by system
56	isfollowup	tinyint	Not Considered, set by system
57	dtkeycheck	datetime	Not Considered, set by system
58	keycheck	tinyint	Not Considered, set by system
59	payortype	varchar(150)	Not Considered, set by system
60	isoutpatient	tinyint	Not Considered, set by system
61	isautocharge	int	Not Considered, set by system
62	isactive	tinyint	Defaults to 1
63	mo	int	Not Considered, set by system
64	dom	int	Not Considered, set by system
65	yr	int	Not Considered, set by system
66	doy	int	Not Considered, set by system
67	los	int	Not Considered, set by system
68	mi	varchar(5)	Not Considered, set by system
69	dob	date	Optional, set by inquiry
70	luby_id	int	Not Considered, set by system
71	jfc	text	Not Considered, set by system
72	dateaction	date	Not Considered, set by system
73	dcreason	varchar(255)	Not Considered, set by system
74	dccode	varchar(255)	Not Considered, set by system
75	isdd	tinyint	Not Considered, set by system
76	dctypedd_id	int	Not Considered, set by system
77	datedd	date	Not Considered, set by system
78	timedd	time	Not Considered, set by system
79	dcreasondd	varchar(150)	Not Considered, set by system
80	staffdd_id	int	Not Considered, set by system
81	dcstatuscode	varchar(5)	Not Considered, set by system
82	serv_program	varchar(2)	Not Considered, set by system
83	termtype	int	Not Considered, set by system
84	methadoneyn	int	Not Considered, set by system
85	legalauth	varchar(150)	Not Considered, set by system
86	transferredfrom_id	int	Not Considered, set by system
87	projdatedc	date	Not Considered, set by system
88	projdatetf	date	Not Considered, set by system
89
90
91
92
93
94
95
96
97
98
99
100