ELIG_REQUESTS · Accumedic EHI Export Format

01Relates to the patient

PATIENT_ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

ACCOUNT → PATIENTS.ACCOUNT
OFFICE_LOCATION → LOCATIONS.OFFICE_LOCATION
PATIENT_ACCOUNT → PATIENTS.ACCOUNT
ELIG_SVC_TYPE_CODE → V_ELIG_SVC_TYPE_CODES.ELIG_SVC_TYPE_CODE
INSURANCE_ID, COMPANY_CODE → INSURANCE_POLICIES.INSURANCE_ID, COMPANY_CODE

#	Column	Type	Source type	Null	Notes
1	REQUEST_ID PK	integer	int	no
2	ACCOUNT	string	varchar(12)	no	Account of the insured.
3	PATIENT_ACCOUNT	string	varchar(12)	no	The patient the eligibility request is for.
4	PROVIDER_CODE	string	varchar(20)	no
5	COMPANY_CODE	string	varchar(20)	no
6	INSURANCE_ID	string	varchar(25)	no
7	DATE_OF_SERVICE	datetime	datetime	yes
8	DATE_OF_SERVICE_THRU	datetime	datetime	yes
9	SERVICE_TYPE_CODE	string	varchar(2)	no
10	INVOICE	integer	int	yes
11	OFFICE_LOCATION	string	varchar(20)	yes
12	ELIG_SVC_TYPE_CODE	string	varchar(2)	yes
13	REQUEST_SENT_DATETIME	datetime	datetime	yes
14	RESPONSE_RECEIVED_DATETIME	datetime	datetime	yes
15	RESPONSE_TEXT	string	varchar(300)	yes
16	OTHER_INS_INFO	string	varchar(25)	yes
17	OTHER_INS_ID	string	varchar(25)	yes
18	COPAY	decimal	decimal(19,4)	yes
19	COVERAGE_TYPE	string	varchar(2)	yes
20	FOLLOW_UP_ACTION	string	varchar(2)	yes
21	COVERAGE_LEVEL_CODE	string	varchar(3)	yes
22	APPT_ID	integer	int	yes
23	CREATE_DATE	datetime	datetime	yes
24	LAST_NAME	string	varchar(35)	yes
25	FIRST_NAME	string	varchar(25)	yes
26	MI	string	char(1)	yes
27	SSNO	string	varchar(11)	yes
28	SEX	string	char(1)	yes
29	DATE_OF_BIRTH	datetime	datetime	yes
30	ADDR1	string	varchar(55)	yes
31	ADDR2	string	varchar(55)	yes
32	CITY	string	varchar(50)	yes
33	STATE	string	varchar(2)	yes
34	ZIP	string	varchar(10)	yes
35	PLAN_START	datetime	datetime	yes
36	PLAN_END	datetime	datetime	yes
37	PLAN_ISSUED	datetime	datetime	yes
38	ADMISISON_DATE	datetime	datetime	yes
39	DISCHARGE_DATE	datetime	datetime	yes
40	ELIG_FILENAME	string	varchar(100)	yes