NEIC_STATUS_RECORDS · Accumedic EHI Export Format

01Relates to the patient

INVOICE matches ACCOUNTS_RECEIVABLE.INVOICE on a row of ACCOUNTS_RECEIVABLE that relates to the patient

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	SEQUENCE_NO PK	integer	int	no
2	INVOICE	integer	int	no
3	STATUS_DATE	datetime	datetime	yes
4	RECEIPT_DATE	datetime	datetime	yes
5	CHARGE	decimal	decimal(19,4)	yes
6	AMOUNT_PAID	decimal	decimal(19,4)	yes
7	DATE_OF_SERVICE	datetime	datetime	yes
8	DATE_OF_SERVICE_THRU	datetime	datetime	yes
9	NEIC_STATUS_CODE	string	varchar(3)	yes
10	PAYOR_ID	string	varchar(15)	yes
11	PROVIDER_ID	string	varchar(15)	yes
12	REFERENCE_NO	string	varchar(20)	yes
13	ACTION_CODE	string	char(1)	yes
14	EXCEPTION_CODE	string	char(1)	yes
15	LAST_NAME	string	varchar(35)	yes
16	MI	string	char(1)	yes