PAT_PROGRAMS · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

ADMIT_DEPT_CODE → DEPARTMENTS.DEPT_CODE
ADMIT_DIAG_CODE → DIAGNOSIS_CODES.DIAG_CODE
ADMIT_LOCATION → LOCATIONS.OFFICE_LOCATION
ADMIT_PROVIDER_CODE → PROVIDERS.PROVIDER_CODE
ATTEND_PROVIDER_CODE → PROVIDERS.PROVIDER_CODE
CONTACT_RELATION → CONTACT_RELATIONS.CONTACT_RELATION
EVAL_LOCATION → EVAL_LOCATIONS.EVAL_LOCATION
PATIENT_STATUS_UB → V_PATSTAT_UB.PATIENT_STATUS_UB
REFERRAL_SOURCE → REFERRAL_SOURCES.REFERRAL_SOURCE
PROVIDER_CODE → PROVIDERS.PROVIDER_CODE
ACCOUNT, ACCIDENT_DATE → PAT_ACCIDENTS.ACCOUNT, ACCIDENT_DATE
ATTORNEY_CODE → ATTORNEYS.ATTORNEY_CODE
CALLING_USER_ID → USERS.USER_ID
ACCOUNT → PATIENTS.ACCOUNT
HOUSING_UNIT → HOUSING_UNITS.HOUSING_UNIT
OFFICE_LOCATION → LOCATIONS.OFFICE_LOCATION
PROGRAM_CODE → PROGRAM_CODES.PROGRAM_CODE
PSYCH_PROVIDER_CODE → PROVIDERS.PROVIDER_CODE
REF_PROV_CODE → REFERRING_PROVIDERS.REF_PROV_CODE
ADMISSION_SOURCE_CODE → V_ADMISSION_SOURCE.ADMISSION_SOURCE_CODE
ADMISSION_TYPE_CODE → V_ADMISSION_TYPE.ADMISSION_TYPE_CODE
PATIENT_STATUS_UB → V_PATSTAT_UB.PATIENT_STATUS_UB
PROGRAM_STATUS → PROGRAM_STATUS_CODES.PROGRAM_STATUS

03Columns

#	Column	Type	Source type	Null
1	ACCOUNT PK	string	varchar(12)	no
2	EPISODE_CARE_ID PK	integer	int	no
3	PROGRAM_CODE	string	varchar(15)	no
4	FIRST_CONTACT_DATE	datetime	smalldatetime	no
5	PROGRAM_STATUS	string	char(1)	yes
6	PROGRAM_ACTIVE	string	char(1)	yes
7	INTAKE_DATE	datetime	smalldatetime	yes
8	SCREENING_DATE	datetime	smalldatetime	yes
9	DATE_OF_ADMISSION	datetime	smalldatetime	yes
10	DATE_OF_DISCHARGE	datetime	smalldatetime	yes
11	TREATMENT_PLAN_DATE	datetime	smalldatetime	yes
12	UTILIZATION_REVIEW_DATE	datetime	smalldatetime	yes
13	PROVIDER_CODE	string	varchar(20)	yes
14	PSYCH_PROVIDER_CODE	string	varchar(20)	yes
15	CONTACT_TYPE	string	char(1)	yes
16	CONTACT_URGENCY	string	char(1)	yes
17	CONTACT_DATE	datetime	smalldatetime	yes
18	EVAL_CLEARED_DATE	datetime	smalldatetime	yes
19	EVAL_ARRIVED_DATE	datetime	smalldatetime	yes
20	EVAL_LOCATION	string	varchar(15)	yes
21	PREV_INPATIENT	string	char(1)	yes
22	PREV_PARTIAL	string	char(1)	yes
23	PREV_OUTPATIENT	string	char(1)	yes
24	DIVERSION_FROM_JAIL	string	char(1)	yes
25	REENTRY_FROM_PRISON	string	char(1)	yes
26	REFERRED_BY_CLERGY	string	char(1)	yes
27	REFERRAL_SOURCE	string	varchar(30)	yes
28	CONTACT_NAME	string	varchar(40)	yes
29	CONTACT_PHONE	string	varchar(20)	yes
30	CONTACT_RELATION	string	varchar(15)	yes
31	PRESENTING_PROBLEM	string	text	yes
32	INTAKE_OFFERED_DATE	datetime	smalldatetime	yes
33	INTAKE_ACCEPTED_DATE	datetime	smalldatetime	yes
34	CALL_HOME	string	char(1)	yes
35	CALL_WORK	string	char(1)	yes
36	MESSAGE_HOME	string	char(1)	yes
37	MESSAGE_WORK	string	char(1)	yes
38	SEND_MAIL	string	char(1)	yes
39	ASK_SURVEY	string	char(1)	yes
40	PREV_OTHER_24HR	string	char(1)	yes
41	NEW_PROGRAM	string	char(1)	yes
42	ADMIT_DIAG_CODE	string	varchar(8)	yes
43	ADMISSION_TYPE_CODE	string	char(1)	yes
44	ADMISSION_SOURCE_CODE	string	char(1)	yes
45	PATIENT_STATUS_UB	string	varchar(2)	yes
46	CSDS_START_DATE	datetime	datetime	yes
47	CSDS_END_DATE	datetime	datetime	yes
48	ADMIT_PROVIDER_CODE	string	varchar(20)	yes
49	ATTEND_PROVIDER_CODE	string	varchar(20)	yes
50	NON_COVD_DAYS	integer	int	yes
51	COVD_DAYS	integer	int	yes
52	ADMIT_LOCATION	string	varchar(20)	yes
53	ADMIT_DEPT_CODE	string	varchar(15)	yes
54	MED_EVAL_OFFERED_DATE	datetime	smalldatetime	yes
55	MED_EVAL_ACCEPTED_DATE	datetime	smalldatetime	yes
56	OFFICE_LOCATION	string	varchar(20)	yes
57	LAST_REVIEW_DATE	datetime	smalldatetime	yes
58	NEXT_REVIEW_DATE	datetime	smalldatetime	yes
59	ISP_DATE	datetime	smalldatetime	yes
60	PHYSICAL_EXAM_DATE	datetime	smalldatetime	yes
61	PSYCH_EXAM_DATE	datetime	smalldatetime	yes
62	LAST_QA_DATE	datetime	smalldatetime	yes
63	NEXT_QA_DATE	datetime	smalldatetime	yes
64	ATTORNEY_CODE	string	varchar(20)	yes
65	ROOM	string	varchar(20)	yes
66	BED	string	varchar(20)	yes
67	AVAILABLE_TIMES	string	varchar(50)	yes
68	REQUESTED_LANGUAGE	string	varchar(30)	yes
69	REQUESTED_PROV_SEX	string	char(1)	yes
70	TREATMENT_COORDINATOR	string	varchar(20)	yes
71	REQUESTED_PROV_CODE	string	varchar(20)	yes
72	REQUESTED_OTHER	string	varchar(max)	yes
73	ACCIDENT_DATE	datetime	smalldatetime	yes
74	MICA	string	char(1)	yes
75	TATI	string	char(1)	yes
76	IS_DELETED	boolean	bit	yes
77	PHYSICAL_EXAM_DOC_DATE	datetime	smalldatetime	yes
78	BAC_REQUIRED	boolean	bit	yes
79	FIRST_DOSE_DATE	datetime	datetime	yes
80	EXT_EPISODE_CARE_ID	string	varchar(20)	yes
81	HOUSING_UNIT	string	varchar(20)	yes
82	CALLING_USER_ID	string	varchar(20)	yes
83	CALL_DATETIME	datetime	datetime	yes
84	CALL_PROGRAM_NAME	string	varchar(100)	yes
85	CALL_PROGRAM_PHONE	string	varchar(20)	yes
86	REF_PROV_CODE	string	varchar(20)	yes
87	ROUNDING_INTERVAL	boolean	bit	yes