MMT_ORDER_HOLDS · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

ACCOUNT, EPISODE_CARE_ID → PAT_PROGRAMS.ACCOUNT, EPISODE_CARE_ID
HOLD_USER_ID → USERS.USER_ID
POSTPONE_USER_ID → USERS.USER_ID
RELEASE_USER_ID → USERS.USER_ID
HOLD_TYPE → MMT_ORDER_HOLD_TYPES.HOLD_TYPE
ORDER_ID, ACCOUNT, EPISODE_CARE_ID → MMT_ORDERS.ORDER_ID, ACCOUNT, EPISODE_CARE_ID

03Columns

#	Column	Type	Source type	Null	Notes
1	ACCOUNT PK	string	varchar(12)	no
2	EPISODE_CARE_ID PK	integer	int	no
3	HOLD_DATE PK	datetime	smalldatetime	no
4	HOLD_USER_ID	string	varchar(20)	no
5	HOLD_ACTIVE	boolean	bit	no
6	HOLD_TYPE PK	integer	int	no
7	HOLD_RELEASE_DATE	datetime	datetime	yes
8	RELEASE_USER_ID	string	varchar(20)	yes
9	COMMENTS	string	varchar(1000)	yes
10	EFFECTIVE_DATE	datetime	datetime	yes
11	HOLD_PRIORITY	integer	int	no
12	EXPIRY_DATE	datetime	datetime	yes
13	POSTPONE_USER_ID	string	varchar(20)	yes
14	POSTPONE_LEN	integer	int	yes
15	POSTPONE_DATE	datetime	datetime	yes
16	HOLD_SOFT	boolean	bit	yes
17	ORDER_ID	integer	int	no