RCM_INTERFACE_LOG · Accumedic EHI Export Format

01Relates to the patient

not linked to a patient

Single-patient export: not included.

#	Column	Type	Source type	Null
1	RIL_PK PK	integer	bigint	no
2	APPT_ID	integer	int	no
3	ENTRY_USER_ID	string	varchar(20)	no
4	ENTRY_DATE	datetime	datetime	no
5	TRANSMIT_DATE	datetime	datetime	yes
6	RESPONSE_DATE	datetime	datetime	yes
7	RESPONSE_MSG	string	varchar(max)	yes
8	RETURN_VISIT_ID	string	varchar(20)	yes
9	IS_VALID	boolean	bit	yes
10	PROCESS_MESSAGE	string	varchar(max)	yes
11	PROCESS_DATE	datetime	datetime	yes
12	GEN_MSG	string	varchar(max)	yes
13	CLAIM_BATCH_NUMBER	integer	int	yes
14	INVOICE	integer	int	yes