EMR_ORDER_AFP · Accumedic EHI Export Format

01Relates to the patient

LAB_ORDER_NUMBER + LAB_ID matches EMR_ORDERS.LAB_ORDER_NUMBER + EMR_ORDERS.LAB_ID on a row of EMR_ORDERS that relates to the patient

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	LAB_ORDER_NUMBER PK	string	varchar(20)	no
2	LAB_ID PK	string	varchar(40)	no
3	GEST_AGE	string	varchar(4)	yes
4	GEST_AGE_CALC_TYPE	string	varchar(3)	yes
5	GEST_AGE_DATE	datetime	datetime	yes
6	PREGNANCY_TYPE	string	varchar(1)	yes
7	MOTHER_RACE	string	varchar(6)	yes
8	MOTHER_WEIGHT	string	varchar(3)	yes
9	INSULIN_DEPENDENT	string	varchar(1)	yes
10	OTHER_INDICATIONS	string	varchar(1)	yes
11	EST_DELIVERY_DATE	datetime	datetime	yes
12	LMP_DATE	datetime	datetime	yes
13	HX_CYSTIC_FIBROSIS	string	varchar(1)	yes
14	AFP_INFO	string	varchar(20)	yes
15	RR_PREV_ELEVATED_AFP	string	varchar(1)	yes
16	CROWN_RUMP_LEN	decimal	decimal(5,1)	yes
17	CROWN_RUMP_LEN_DATE	datetime	datetime	yes
18	CROWN_RUMP_LEN_TWIN	decimal	decimal(5,1)	yes
19	NUCHAL_TRANSL_1ST_FETUS	decimal	decimal(5,1)	yes
20	NUCHAL_TRANSL_TWIN	decimal	decimal(5,1)	yes
21	DONOR_EGG	boolean	bit	yes
22	EGG_DONOR_AGE	string	varchar(2)	yes
23	PRIOR_ONTD_SCREENING	boolean	bit	yes
24	PRIOR_1ST_TRIM_SCREENING	boolean	bit	yes
25	PRIOR_2ND_TRIM_SCREENING	boolean	bit	yes
26	FAM_HX_NTD	boolean	bit	yes
27	PRIOR_PREG_DWN_SYND	boolean	bit	yes
28	CHORIONICITY	string	varchar(4)	yes
29	SONOGRAPHER_FNAME	string	varchar(15)	yes
30	SONOGRAPHER_LNAME	string	varchar(25)	yes
31	SONOGRAPHER_CERT_NUM	string	varchar(20)	yes
32	SONOGRAPHER_CRED_BY	string	varchar(5)	yes
33	ULTRASOUND_SITE	string	varchar(20)	yes
34	READING_PHYSICIAN_ID	string	varchar(20)	yes