CLAIM_BATCHES · Accumedic EHI Export Format

01Relates to the patient

CLAIM_BATCH_NUMBER matches CLAIM_BATCH_DETAILS.CLAIM_BATCH_NUMBER on a row of CLAIM_BATCH_DETAILS that relates to the patient

Single-patient export: only rows the patient's records refer to.

#	Column	Type	Source type	Null
1	CLAIM_BATCH_NUMBER PK	integer	int	no
2	CLAIM_PROCESSOR	string	varchar(4)	yes
3	BATCH_CREATION_DATE	datetime	datetime	no
4	BATCH_GENERATION_DATE	datetime	datetime	yes
5	BATCH_TRANSMISSION_DATE	datetime	datetime	yes
6	BATCH_POSTING_DATE	datetime	datetime	yes
7	HBOC_ID	string	varchar(6)	yes
8	CATEGORY	string	varchar(4)	yes
9	OUTPUT_FORMAT	string	varchar(10)	yes
10	CLAIM_FILENAME	string	varchar(255)	yes
11	ENTRY_USER_ID	string	varchar(20)	no
12	ENTRY_DATE	datetime	datetime	no
13	CHANGE_USER_ID	string	varchar(20)	no
14	CHANGE_DATE	datetime	datetime	yes
15	CLAIM_TYPE	string	char(1)	yes
16	REGENERATE_FLAG	string	char(1)	yes
17	LOCATION_NUMBER	string	varchar(15)	yes
18	PROVIDER_CODE	string	varchar(20)	yes
19	BATCH_ACK_MSG	string	varchar(255)	yes