EMR_REFERRALS_IN · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

ACCOUNT → PATIENTS.ACCOUNT
MARITAL_STATUS → V_MARITAL_STATUS.MARITAL_STATUS
PROGRAM_CODE → PROGRAM_CODES.PROGRAM_CODE
RACE → V_RACES_CDC.RACE

03Columns

#	Column	Type	Source type	Null
1	REFERRAL_ID PK	integer	int	no
2	REFERRAL_DATE	datetime	datetime	no
3	PRACTICE_NAME	string	varchar(255)	no
4	REFER_LAST_NAME	string	varchar(70)	yes
5	REFER_FIRST_NAME	string	varchar(70)	yes
6	REFER_EMAIL	string	varchar(70)	yes
7	REFER_PHONE	string	varchar(20)	yes
8	REFERRAL_REASON	string	varchar(max)	yes
9	URGENT_IMMINENT_RISK	string	varchar(255)	yes
10	PAT_CONTACT_NOW	string	varchar(255)	yes
11	IMMEDIATE_NOW_REASON	string	varchar(max)	yes
12	PAT_MINOR	string	varchar(3)	yes
13	LAST_NAME	string	varchar(35)	yes
14	FIRST_NAME	string	varchar(25)	yes
15	EMAIL	string	varchar(70)	yes
16	HOME_PHONE	string	varchar(20)	yes
17	MOBILE_PHONE	string	varchar(20)	yes
18	DOB	datetime	datetime	yes
19	SSNO	string	varchar(11)	yes
20	GENDER	string	varchar(1)	yes
21	ADDRESS	string	varchar(110)	yes
22	CITY	string	varchar(50)	yes
23	STATE	string	varchar(2)	yes
24	ZIP	string	varchar(10)	yes
25	RACE	string	varchar(6)	yes
26	LANGUAGE	string	varchar(60)	yes
27	MARITAL_STATUS	string	char(1)	yes
28	FUNDING_SOURCE	string	varchar(20)	yes
29	COMPANY_NAME	string	varchar(200)	yes
30	POLICY_NUMBER	string	varchar(60)	yes
31	PAT_INSURED	string	varchar(3)	yes
32	GUARD_LAST_NAME	string	varchar(35)	yes
33	GUARD_FIRST_NAME	string	varchar(25)	yes
34	GUARD_RELATIONSHIP	string	varchar(25)	yes
35	POLICY_LAST_NAME	string	varchar(35)	yes
36	POLICY_FIRST_NAME	string	varchar(25)	yes
37	POLICY_FIRST_RELATIONSHIP	string	varchar(100)	yes
38	POLICY_DOB	datetime	datetime	yes
39	CREATED_DATE	datetime	datetime	no
40	CREATED_USER_ID	string	varchar(20)	no
41	PROGRAM_CODE	string	varchar(15)	yes
42	ACCOUNT	string	varchar(12)	yes
43	IS_DELETED	boolean	bit	no
44	PRACTICE_ZIP	string	varchar(10)	yes
45	REFERRAL_REASON_TYPE	string	varchar(55)	yes
46	PROGRAM_STATUS_CODE	string	varchar(3)	yes
47	GUARD_PHONE	string	varchar(20)	yes
48	REFERRAL_TYPE	string	varchar(70)	yes
49	TARGET_POPULATION	string	varchar(70)	yes
50	PREFERRED_CONTACT_METHOD	string	varchar(5)	yes
51	REFER_TITLE	string	varchar(30)	yes
52	REFER_COUNTY	string	varchar(30)	yes
53	HEALTH_HOME_NAME	string	varchar(255)	yes
54	DATE_OF_LOC	datetime	datetime	yes
55	DATE_SLOT_APPROVED	datetime	datetime	yes
56	LOC_OBTAINED	boolean	bit	yes
57	CAPACITY_MANG_APPROVED	boolean	bit	yes
58	REFER_ADDRESS	string	varchar(100)	yes
59	REFER_CITY	string	varchar(50)	yes
60	REFER_STATE	string	varchar(2)	yes
61	REFERRAL_TYPE_CODE	integer	int	no
62	GUARD_EMAIL	string	varchar(70)	yes
63	REFER_ZIP	string	varchar(10)	yes
64	ETHNICITY	string	varchar(80)	yes
65	LANGUAGE_SECONDARY	string	varchar(60)	yes
66	GENDER_IDENTITY	string	varchar(2)	yes
67	PSYCH_DATE_1	datetime	datetime	yes
68	PSYCH_DATE_1_DETAILS	string	varchar(max)	yes
69	PSYCH_DATE_2	datetime	datetime	yes
70	PSYCH_DATE_2_DETAILS	string	varchar(max)	yes
71	PSYCH_DATE_3	datetime	datetime	yes
72	PSYCH_DATE_3_DETAILS	string	varchar(max)	yes
73	ADDITIONAL_COMMENTS	string	varchar(max)	yes
74	DIAG_1	string	varchar(8)	yes
75	DIAG_2	string	varchar(8)	yes
76	SCHOOL_NAME	string	varchar(30)	yes
77	SCHOOL_DISTRICT	string	varchar(30)	yes