PAT_DEMOGRAPHICS · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

POB_STATE → US_STATES.STATE
REFERRAL_SOURCE → REFERRAL_SOURCES.REFERRAL_SOURCE
TRANSPORT → TRANSPORTS.TRANSPORT
GENDER_IDENTITY → V_GENDER_IDENTITY.GENDER_IDENTITY
LIVING_SITUATION → V_LIVING_SITUATION.LIVING_SITUATION
MANNER_DEATH → V_MANNER_DEATH.MANNER_DEATH
SEXUAL_ORIENTATION → V_SEXUAL_ORIENTATION.SEXUAL_ORIENTATION
SMOKING_STATUS → V_SMOKING_STATUS.SMOKING_STATUS
EDUCATION_LEVEL → V_EDUCATION_LEVEL.EDUCATION_LEVEL
MILITARY_STATUS → V_MILITARY_STATUS.MILITARY_STATUS
RACE → V_RACES_CDC.RACE
RACE_2 → V_RACES_CDC.RACE
ACCOUNT → PATIENTS.ACCOUNT

03Columns

#	Column	Type	Source type	Null
1	ACCOUNT PK	string	varchar(12)	no
2	NUM_DEPENDENTS	integer	int	yes
3	NUM_IN_HOUSEHOLD	integer	int	yes
4	RACE	string	varchar(6)	yes
5	RELIGION	string	varchar(40)	yes
6	INCOME	decimal	decimal(19,4)	yes
7	HIV	string	char(1)	yes
8	SICKLE_CELL	string	char(1)	yes
9	DIABETIC	string	char(1)	yes
10	TUBERCULOSIS	string	char(1)	yes
11	PAT_HEIGHT	integer	int	yes
12	PAT_WEIGHT	integer	int	yes
13	EYE_COLOR	string	varchar(30)	yes
14	HAIR_COLOR	string	varchar(30)	yes
15	BLOOD_TYPE	string	varchar(3)	yes
16	SECONDARY_NAME	string	varchar(30)	yes
17	SCHOOL_DISTRICT	string	varchar(30)	yes
18	REFERRAL_SOURCE	string	varchar(30)	yes
19	TERMINATED	string	char(1)	yes
20	TERMINATION_DATE	datetime	datetime	yes
21	FORENSIC	string	char(1)	yes
22	MILITARY_SERVICE	string	char(1)	yes
23	PENSION	string	char(1)	yes
24	COURT_ORDERED	string	char(1)	yes
25	LANGUAGE	string	varchar(30)	yes
26	TRANSPORT	string	varchar(30)	yes
27	ETHNICITY	string	varchar(80)	yes
28	MOTHERS_MAIDEN_NAME	string	varchar(35)	yes
29	MOTHERS_FIRST_NAME	string	varchar(25)	yes
30	POB_CITY	string	varchar(30)	yes
31	POB_STATE	string	varchar(2)	yes
32	POB_COUNTRY_CODE	string	varchar(2)	yes
33	CSDS	string	char(1)	yes
34	METHADONE	string	char(1)	yes
35	MR_DD	string	char(1)	yes
36	TRAUMATIC_BRAIN_INJURY	string	char(1)	yes
37	SMOKING_STATUS	string	char(1)	yes
38	TERMINAL_ILLNESS	boolean	bit	yes
39	COUNTY	string	varchar(30)	yes
40	EDUCATION_LEVEL	integer	int	yes
41	SPECIAL_EDUCATION	string	char(1)	yes
42	NOT_LABOR_FORCE	integer	int	yes
43	EMPLOYMENT_LENGTH	integer	int	yes
44	ADOL_LIVING	integer	int	yes
45	ADULT_LIVING	integer	int	yes
46	INCOME_SOURCE	integer	int	yes
47	HOMELESS	integer	int	yes
48	STATUS_CONDITION	integer	int	yes
49	MILITARY_STATUS	string	varchar(2)	yes
50	MILITARY_SERVICE_START_DATE	datetime	smalldatetime	yes
51	MILITARY_SERVICE_END_DATE	datetime	smalldatetime	yes
52	ENGLISH_PROFICIENCY	string	varchar(20)	yes
53	SOCIOCULTURAL	string	varchar(30)	yes
54	SED	string	char(1)	yes
55	CO_OCCURRENCE	string	varchar(10)	yes
56	CRIMINAL_JUSTICE_REFERRAL	integer	int	yes
57	RACE_2	string	varchar(6)	yes
58	GENDER_IDENTITY	string	varchar(2)	yes
59	SEXUAL_ORIENTATION	string	varchar(2)	yes
60	LAST_MEANS_DATE	datetime	datetime	yes
61	NO_ANNUAL_PHYSICAL	boolean	bit	yes
62	HIGH_ER_VISITS	boolean	bit	yes
63	NO_DIABETES_SCREENING	boolean	bit	yes
64	NO_DIABETES_MONITORING	boolean	bit	yes
65	LANGUAGE_ABILITY_MODE	string	varchar(20)	yes
66	LANGUAGE_PROFICIENCY	string	varchar(10)	yes
67	RACE_ALT	string	varchar(20)	yes
68	NYS_ID	string	varchar(10)	yes
69	OSAS_ID	string	varchar(10)	yes
70	LIVING_SITUATION	string	varchar(6)	yes
71	BAR_CODE	string	varchar(20)	yes
72	MANNER_DEATH	string	varchar(6)	yes
73	IV_DRUG_USER	boolean	bit	yes
74	HEPATITIS_C	boolean	bit	yes
75	PREGNANT	boolean	bit	yes
76	LAST_PREGNANCY_TEST	datetime	datetime	yes
77	ETHNICITY_2	string	varchar(80)	yes
78	FIRST_NAME_BIRTH	string	varchar(25)	yes
79	LAST_NAME_BIRTH	string	varchar(35)	yes
80	MIDDLE_NAME	string	varchar(35)	yes
81	SEX_BIRTH	string	char(1)	yes
82	PREFERRED_NAME	string	varchar(50)	yes
83	PRONOUNS	string	varchar(25)	yes
84	ASTHMA	boolean	bit	yes
85	ASAMID	string	varchar(255)	yes