ELR SOLUTIONS

Thursday, May 17, 2012

Home | Print this page | Email this page to a friend | | Login

CDPH

Chicago Health Event
Surveillance System, or
CHESS

ELR Solutions
Administration Bldg,
Suite 1013
1900 W. Polk St.
Chicago, IL 60612

ELR Database Schema Index

Sr	Object	Type
1	[dbo].[Tbl_ADT]	Table
2	[dbo].[Tbl_CONFIG]	Table
3	[dbo].[Tbl_DEM]	Table
4	[dbo].[Tbl_LAB_ORDER]	Table
5	[dbo].[Tbl_LAB_RESULT]	Table
6	[dbo].[Tbl_LUT_CONDITION]	Table
7	[dbo].[Tbl_LUT_ELR_ABX_LOINC]	Table
8	[dbo].[Tbl_LUT_ELR_LAB_LOINC]	Table
9	[dbo].[Tbl_LUT_ELR_LAB_SOURCES]	Table
10	[dbo].[Tbl_LUT_ELR_MICRO_LOINC]	Table
11	[dbo].[Tbl_LUT_ELR_MICRO_SOURCES]	Table
12	[dbo].[Tbl_LUT_ELR_RACE]	Table
13	[dbo].[Tbl_LUT_ELR_SNOMED]	Table
14	[dbo].[Tbl_LUT_ELR_SOURCE_CATEG]	Table
15	[dbo].[Tbl_LUT_FIELDLIST]	Table
16	[dbo].[Tbl_MICRO_ORDER]	Table
17	[dbo].[Tbl_MICRO_RESULT]	Table
18	[dbo].[Tbl_OUT_NK1]	Table
19	[dbo].[Tbl_OUT_NTE]	Table
20	[dbo].[Tbl_OUT_OBR]	Table
21	[dbo].[Tbl_OUT_OBX]	Table
22	[dbo].[Tbl_OUT_ORC]	Table
23	[dbo].[Tbl_OUT_PID]	Table

Table:[dbo].[Tbl_ADT]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(60)	N	Distinct Visit Patient Number
2	PTMEDREC	NVARCHAR(40)	Y	Patient Medical Record Number
3	LOCATION	NVARCHAR(100)	Y	Hospital Name
4	EVENT_TYPE	NVARCHAR(40)	Y	Type of event - Admit, Transfer, Discharge, Update
5	WARD_OLD	NVARCHAR(40)	Y	Old Ward Location
6	BED_OLD	NVARCHAR(40)	Y	Old Bed Location
7	WARD_NEW	NVARCHAR(40)	Y	New Ward Location
8	BED_NEW	NVARCHAR(40)	Y	New Bed Location
9	ADM_DATE	DATETIME	Y	Patient Admission Date
10	ADM_TIME	NVARCHAR(100)	Y	Patient Admission Time
11	DSCH_DATE	DATETIME	Y	Patient Discharge Date
12	DSCH_TIME	NVARCHAR(100)	Y	Patient DischargeTime
13	PT_LAST_NAME	NVARCHAR(510)	Y	Patient Last Name
14	PT_FIRST_NAME	NVARCHAR(510)	Y	Patient First Name
15	PT_PAT_ALIAS	NVARCHAR(510)	Y
16	PT_PAT_SSN	NVARCHAR(100)	Y
17	PT_DOB	DATETIME	Y	Patient Date Of Birth
18	PT_SEX	NVARCHAR(40)	Y	Patient Sex
19	PT_RACE	NVARCHAR(40)	Y	Patient Race
20	PT_ETHNICITY	NVARCHAR(80)	Y	Patient Ethnicity
21	PT_ADDRESS	NVARCHAR(510)	Y	Patient Address (street number)
22	PT_CITY	NVARCHAR(510)	Y	Patient City
23	PT_STATE	NVARCHAR(510)	Y	Patient State
24	PT_ZIP	NVARCHAR(40)	Y	Patient Zip Code
25	PT_COUNTY	NVARCHAR(100)	Y	Patient County
26	PT_HOME_PHONE_NO1	NVARCHAR(40)	Y	Patient Primary Home Phone Number
27	PT_HOME_PHONE_NO2	NVARCHAR(40)	Y	Patient Secondary Phone Number (cell)
28	PT_WORK_PHONE_NO	NVARCHAR(40)	Y	Patient Work Phone Number
29	PT_BIRTH_PLACE	NVARCHAR(510)	Y	Patient Birth Place (Country)
30	PT_DEATH_INDIC	NVARCHAR(100)	Y	Patient Death Description
31	PT_DEATH_DATETIME	NVARCHAR(510)	Y	Patient Death Datetime
32	PROVIDER_LAST_NAME	NVARCHAR(510)	Y

Table:[dbo].[Tbl_CONFIG]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description

Table:[dbo].[Tbl_DEM]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(60)	N	Distinct Visit Patient Number
2	PTMEDREC	NVARCHAR(40)	Y	Patient Medical Record Number
3	LOCATION	NVARCHAR(100)	Y	Hospital Name
4	WARD_LOCATION	NVARCHAR(40)	Y
5	BED_LOCATION	NVARCHAR(40)	Y
6	ADM_DATE	DATETIME	Y	Patient Admission Date
7	ADM_TIME	NVARCHAR(100)	Y	Patient Admission Time
8	DSCH_DATE	DATETIME	Y	Patient Discharge Date
9	DSCH_TIME	NVARCHAR(100)	Y	Patient DischargeTime
10	PT_LAST_NAME	NVARCHAR(510)	Y	Patient Last Name
11	PT_FIRST_NAME	NVARCHAR(510)	Y	Patient First Name
12	PT_PAT_ALIAS	NVARCHAR(510)	Y
13	PT_SSN	NVARCHAR(100)	Y	Patient Social Security Number
14	PT_DOB	DATETIME	Y	Patient Date Of Birth
15	PT_SEX	NVARCHAR(40)	Y	Patient Sex
16	PT_RACE	NVARCHAR(40)	Y	Patient Race
17	PT_ETHNICITY	NVARCHAR(80)	Y	Patient Ethnicity
18	PT_ADDRESS	NVARCHAR(510)	Y	Patient Address (street number)
19	PT_CITY	NVARCHAR(510)	Y	Patient City
20	PT_STATE	NVARCHAR(510)	Y	Patient State
21	PT_ZIP	NVARCHAR(40)	Y	Patient Zip Code
22	PT_COUNTY	NVARCHAR(100)	Y	Patient County
23	PT_HOME_PHONE_NO1	NVARCHAR(40)	Y	Patient Primary Home Phone Number
24	PT_HOME_PHONE_NO2	NVARCHAR(40)	Y	Patient Secondary Phone Number (cell)
25	PT_WORK_PHONE_NO	NVARCHAR(40)	Y	Patient Work Phone Number
26	PT_BIRTH_PLACE	NVARCHAR(510)	Y	Patient Birth Place (Country)
27	PT_DEATH_INDIC	NVARCHAR(100)	Y	Patient Death Description
28	PT_DEATH_DATETIME	NVARCHAR(510)	Y	Patient Death Datetime

Indexes

Sr.	Name	Type	Columns
1	PK_Tbl_DEM	Nonclustered	PAT_NUM
2	PrimePatNum	Clustered	PAT_NUM

Table:[dbo].[Tbl_LAB_ORDER]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(60)	Y	Distinct Visit Patient Number
2	PTMEDREC	NVARCHAR(40)	Y	Patient Medical Record Number
3	PT_LAST_NAME	NVARCHAR(510)	Y	Patient Last Name
4	PT_FIRST_NAME	NVARCHAR(510)	Y	Patient First Name
5	PT_ALIAS	NVARCHAR(510)	Y	Patient Alias
6	PT_SSN	NVARCHAR(100)	Y	Patient Social Security Number
7	PT_DOB	DATETIME	Y	Patient Date Of Birth
8	PT_SEX	NVARCHAR(40)	Y	Patient Sex
9	PT_RACE	NVARCHAR(40)	Y	Patient Race
10	PT_ETHNICITY	NVARCHAR(80)	Y	Patient Ethnicity
11	PT_ADDRESS	NVARCHAR(510)	Y	Patient Address (street number)
12	PT_CITY	NVARCHAR(510)	Y	Patient City
13	PT_STATE	NVARCHAR(510)	Y	Patient State
14	PT_ZIP	NVARCHAR(40)	Y	Patient Zip Code
15	PT_COUNTY	NVARCHAR(100)	Y	Patient County
16	PT_HOME_PHONE_NO1	NVARCHAR(40)	Y	Patient Primary Home Phone Number
17	PT_HOME_PHONE_NO2	NVARCHAR(40)	Y	Patient Secondary Phone Number (cell)
18	PT_WORK_PHONE_NO	NVARCHAR(40)	Y	Patient Work Phone Number
19	PT_LOCATION	NVARCHAR(100)	Y
20	PTCLASS	NVARCHAR(40)	Y	Patient Class
21	ORDER_WARD	NVARCHAR(40)	Y	ward of patient at time of order
22	ORDER_BED	NVARCHAR(40)	Y	bed of patient at time of order
23	ORDER_SERVICE	NVARCHAR(40)	Y	service ordering test
24	ORDER_NO1	NVARCHAR(80)	Y	Order/Accession Number 1
25	ORDER_NO2	NVARCHAR(80)	Y	Order/Accession Number 2
26	ORDER_NO3	NVARCHAR(80)	Y	Order/Accession Number 3
27	ORDER_NO4	NVARCHAR(80)	Y	Order/Accession Number 4
28	TEST_NAME1	NVARCHAR(100)	Y	Test Name 1
29	TEST_NAME2	NVARCHAR(100)	Y	Test Name 2
30	TEST_NAME3	NVARCHAR(100)	Y	Test Name 3
31	SOURCE1	NVARCHAR(100)	Y	Source 1
32	SOURCE2	NVARCHAR(100)	Y	Source 2
33	SOURCE3	NVARCHAR(100)	Y	Source 3
34	ADM_DATE	DATETIME	Y	Patient Admission Date
35	ORDER_DATE	DATETIME	Y	Order date
36	COLLECT_DATE	DATETIME	Y	Collection date
37	RECEIVE_DATE	DATETIME	Y	Receive date in lab
38	PROCESS_DATE	DATETIME	Y	Process date in lab
39	RESULT_DATE	DATETIME	Y	Result date in lab
40	FINAL_DATE	DATETIME	Y	Final date in lab
41	RESULT_STATUS	NVARCHAR(100)	Y	Result Status - P or F
42	ORDERING_PROVIDER_LAST_NAME	NVARCHAR(510)	Y	Ordering provider last name
43	ORDERING_PROVIDER_FIRST_NAME	NVARCHAR(510)	Y	Ordering Provider First name
44	ORDERING_PROVIDER_TITLE	NVARCHAR(510)	Y	Ordering Provider Title
45	ORDERING_PROVIDER_IDNO	NVARCHAR(510)	Y	Ordering Provider ID number
46	ORDERING_PROVIDER_PHONENO	NVARCHAR(510)	Y	Ordering Provider Phone Number
47	ORDERING_PROVIDER_ST_ADDRESS	NVARCHAR(510)	Y
48	ORDERING_PROVIDER_CITY	NVARCHAR(510)	Y
49	ORDERING_PROVIDER_STATE	NVARCHAR(510)	Y

Table:[dbo].[Tbl_LAB_RESULT]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(60)	Y	Distinct Visit Patient Number
2	PTMEDREC	NVARCHAR(40)	Y	Patient Medical Record Number
3	PT_LAST_NAME	NVARCHAR(510)	Y	Patient Last Name
4	PT_FIRST_NAME	NVARCHAR(510)	Y	Patient First Name
5	PT_ALIAS	NVARCHAR(510)	Y	Patient Alias
6	PT_SSN	NVARCHAR(100)	Y	Patient Social Security Number
7	PT_DOB	DATETIME	Y	Patient Date Of Birth
8	PT_SEX	NVARCHAR(40)	Y	Patient Sex
9	PT_RACE	NVARCHAR(40)	Y	Patient Race
10	PT_ETHNICITY	NVARCHAR(80)	Y	Patient Ethnicity
11	PT_ADDRESS	NVARCHAR(510)	Y	Patient Address (street number)
12	PT_CITY	NVARCHAR(510)	Y	Patient City
13	PT_STATE	NVARCHAR(510)	Y	Patient State
14	PT_ZIP	NVARCHAR(40)	Y	Patient Zip Code
15	PT_COUNTY	NVARCHAR(100)	Y	Patient County
16	PT_HOME_PHONE_NO1	NVARCHAR(40)	Y	Patient Primary Home Phone Number
17	PT_HOME_PHONE_NO2	NVARCHAR(40)	Y	Patient Secondary Phone Number (cell)
18	PT_WORK_PHONE_NO	NVARCHAR(40)	Y	Patient Work Phone Number
19	LOCATION	NVARCHAR(100)	Y	Hospital Name
20	PTCLASS	NVARCHAR(40)	Y	Patient Class
21	ORDER_NO1	NVARCHAR(80)	Y	Order/Accession Number 1
22	ORDER_NO2	NVARCHAR(80)	Y	Order/Accession Number 2
23	ORDER_NO3	NVARCHAR(80)	Y	Order/Accession Number 3
24	ORDER_NO4	NVARCHAR(80)	Y	Order/Accession Number 4
25	TEST_NAME1	NVARCHAR(200)	Y	Test Name 1
26	TEST_NAME2	NVARCHAR(200)	Y	Test Name 2
27	TEST_NAME3	NVARCHAR(200)	Y	Test Name 3
28	SOURCE1	NVARCHAR(300)	Y	Source 1
29	SOURCE2	NVARCHAR(300)	Y	Source 2
30	SOURCE3	NVARCHAR(300)	Y	Source 3
31	ORG_NAME	NVARCHAR(300)	Y	Organism Name
32	RESULT	NVARCHAR(300)	Y	Test Result
33	RESULT_OTHER1	NVARCHAR(510)	Y	Other results or Comments 1
34	RESULT_OTHER2	NVARCHAR(510)	Y	Other results or comments 2
35	ANTIBIOTIC_NAME	NVARCHAR(200)	Y	Antibiotic Name
36	ABX_SUSC_INTERP	NVARCHAR(40)	Y	Antibiotic Susceptibility - R, I, or S
37	ABX_MIC_VALUE	NVARCHAR(40)	Y	Antibiotic MIC for the specific organism and antibiotic combination
38	UNITS_MICRO	NVARCHAR(40)	Y	Units for MIC
39	BREAKPOINT	NVARCHAR(40)	Y	Reference Range/Breakpoint for the organism and antibiotic combination
40	UNITS_LAB	NVARCHAR(40)	Y	Units for test result
41	REF_RANGE	NVARCHAR(40)	Y	Reference Range for Result
42	ADM_DATE	DATETIME	Y	Patient Admission Date
43	ORDER_DATE	DATETIME	Y	Order date
44	COLLECT_DATE	DATETIME	Y	Collection date
45	RECEIVE_DATE	DATETIME	Y	Receive date in lab
46	PROCESS_DATE	DATETIME	Y	Process date in lab
47	RESULT_DATE	DATETIME	Y	Result date in lab
48	FINAL_DATE	DATETIME	Y	Final date in lab
49	RESULT_STATUS	NVARCHAR(100)	Y	Result Status - P or F
50	ORDERING_PROVIDER_LAST_NAME	NVARCHAR(510)	Y	Ordering provider last name
51	ORDERING_PROVIDER_FIRST_NAME	NVARCHAR(510)	Y	Ordering Provider First name
52	ORDERING_PROVIDER_TITLE	NVARCHAR(510)	Y	Ordering Provider Title
53	ORDERING_PROVIDER_IDNO	NVARCHAR(510)	Y	Ordering Provider ID number
54	ORDERING_PROVIDER_PHONENO	NVARCHAR(100)	Y	Ordering Provider Phone Number
55	ORDERING_PROVIDER_ST_ADDRESS	NVARCHAR(510)	Y
56	ORDERING_PROVIDER_CITY	NVARCHAR(510)	Y
57	ORDERING_PROVIDER_STATE	NVARCHAR(510)	Y
58	ORDERING_PROVIDER_ZIP	NVARCHAR(510)	Y
59	ORDERING_PROVIDER_COUNTRY	NVARCHAR(510)	Y
60	ORDERING_PROVIDER_ADDRESS_TYPE	NVARCHAR(510)	Y
61	ORDERING_PROVIDER_ADDRESS_COUNTY	NVARCHAR(510)	Y
62	ABNORMAL_FLAG	NVARCHAR(100)	Y	Abnormal Flag for result
63	ORDERING_PROVIDER_AREA_CODE	NVARCHAR(100)	Y
64	ORDERING_PROVIDER_PHONE	NVARCHAR(100)	Y
65	ORDERING_PROVIDER_PHONE_EXT	NVARCHAR(100)	Y
66	SNOMED_RESULT_TYPE	NVARCHAR(8)	Y
67	SNOMED_NO	NVARCHAR(100)	Y	Snomed Value, mapped from org_name

Table:[dbo].[Tbl_LUT_CONDITION]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable
1	CONDITION	NVARCHAR(510)	Y
2	COMMENTS	NVARCHAR(510)	Y
3	TEST_TYPE	NVARCHAR(510)	Y
4	PRECURSOR_LOINC	NVARCHAR(510)	Y

Table:[dbo].[Tbl_LUT_ELR_ABX_LOINC]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TEST_NAME1	NVARCHAR(510)	Y	Test Name 1
2	TEST_NAME2	NVARCHAR(510)	Y	Test Name 2
3	TEST_NAME3	NVARCHAR(510)	Y	Test Name 3
4	LOINC_NAME	NVARCHAR(510)	Y	Loinc value, mapped from test_name
5	LOINC_NO	NVARCHAR(510)	Y	Loinc value, mapped from test_name

Table:[dbo].[Tbl_LUT_ELR_LAB_LOINC]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TEST_NAME1	NVARCHAR(510)	Y	Test Name 1
2	TEST_NAME2	NVARCHAR(510)	Y	Test Name 2
3	TEST_NAME3	NVARCHAR(510)	Y	Test Name 3
4	LOINC_NAME	NVARCHAR(510)	Y	Loinc value, mapped from test_name
5	LOINC_NO	NVARCHAR(510)	Y	Loinc value, mapped from test_name

Table:[dbo].[Tbl_LUT_ELR_LAB_SOURCES]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TEST_NAME1	NVARCHAR(200)	Y	Test Name 1
2	TEST_NAME2	NVARCHAR(200)	Y	Test Name 2
3	TEST_NAME3	NVARCHAR(200)	Y	Test Name 3
4	TEST_NAME_DESC	NVARCHAR(510)	Y
5	SOURCE1	NVARCHAR(300)	Y	Source 1
6	SOURCE2	NVARCHAR(300)	Y	Source 2
7	SOURCE3	NVARCHAR(300)	Y	Source 3

Table:[dbo].[Tbl_LUT_ELR_MICRO_LOINC]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TEST_NAME1	NVARCHAR(510)	Y	Test Name 1
2	TEST_NAME2	NVARCHAR(510)	Y	Test Name 2
3	TEST_NAME3	NVARCHAR(510)	Y	Test Name 3
4	LOINC_NAME	NVARCHAR(510)	Y	Loinc value, mapped from test_name
5	LOINC_NO	NVARCHAR(510)	Y	Loinc value, mapped from test_name

Table:[dbo].[Tbl_LUT_ELR_MICRO_SOURCES]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TEST_NAME1	NVARCHAR(200)	Y	Test Name 1
2	TEST_NAME2	NVARCHAR(200)	Y	Test Name 2
3	TEST_NAME3	NVARCHAR(200)	Y	Test Name 3
4	TEST_NAME_DESC	NVARCHAR(510)	Y
5	SOURCE1	NVARCHAR(300)	Y	Source 1
6	SOURCE2	NVARCHAR(300)	Y	Source 2
7	SOURCE3	NVARCHAR(300)	Y	Source 3

Table:[dbo].[Tbl_LUT_ELR_RACE]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description

Table:[dbo].[Tbl_LUT_ELR_SNOMED]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	LOCAL_RESULT	NVARCHAR(510)	Y
2	SNOMED_NAME	NVARCHAR(100)	Y	Snomed Value, mapped from org_name

Table:[dbo].[Tbl_LUT_ELR_SOURCE_CATEG]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SOURCE_GROUP	NVARCHAR(510)	Y

Table:[dbo].[Tbl_LUT_FIELDLIST]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description

Table:[dbo].[Tbl_MICRO_ORDER]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(60)	Y	Distinct Visit Patient Number
2	PTMEDREC	NVARCHAR(40)	Y	Patient Medical Record Number
3	PT_LAST_NAME	NVARCHAR(510)	Y	Patient Last Name
4	PT_FIRST_NAME	NVARCHAR(510)	Y	Patient First Name
5	PT_PAT_ALIAS	NVARCHAR(510)	Y
6	PT_SSN	NVARCHAR(100)	Y	Patient Social Security Number
7	PT_DOB	DATETIME	Y	Patient Date Of Birth
8	PT_SEX	NVARCHAR(40)	Y	Patient Sex
9	PT_RACE	NVARCHAR(40)	Y	Patient Race
10	PT_ETHNICITY	NVARCHAR(80)	Y	Patient Ethnicity
11	PT_ADDRESS	NVARCHAR(510)	Y	Patient Address (street number)
12	PT_CITY	NVARCHAR(510)	Y	Patient City
13	PT_STATE	NVARCHAR(510)	Y	Patient State
14	PT_ZIP	NVARCHAR(40)	Y	Patient Zip Code
15	PT_COUNTY	NVARCHAR(100)	Y	Patient County
16	PT_HOME_PHONE_NO1	NVARCHAR(40)	Y	Patient Primary Home Phone Number
17	PT_HOME_PHONE_NO2	NVARCHAR(40)	Y	Patient Secondary Phone Number (cell)
18	PT_WORK_PHONE_NO	NVARCHAR(40)	Y	Patient Work Phone Number
19	LOCATION	NVARCHAR(100)	Y	Hospital Name
20	PTCLASS	NVARCHAR(40)	Y	Patient Class
21	ORDER_WARD	NVARCHAR(40)	Y	ward of patient at time of order
22	ORDER_BED	NVARCHAR(40)	Y	bed of patient at time of order
23	ORDER_SERVICE	NVARCHAR(40)	Y	service ordering test
24	ORDER_NO1	NVARCHAR(80)	Y	Order/Accession Number 1
25	ORDER_NO2	NVARCHAR(80)	Y	Order/Accession Number 2
26	ORDER_NO3	NVARCHAR(80)	Y	Order/Accession Number 3
27	ORDER_NO4	NVARCHAR(80)	Y	Order/Accession Number 4
28	TEST_NAME1	NVARCHAR(100)	Y	Test Name 1
29	TEST_NAME2	NVARCHAR(100)	Y	Test Name 2
30	TEST_NAME3	NVARCHAR(100)	Y	Test Name 3
31	SOURCE1	NVARCHAR(100)	Y	Source 1
32	SOURCE2	NVARCHAR(100)	Y	Source 2
33	SOURCE3	NVARCHAR(100)	Y	Source 3
34	ADM_DATE	DATETIME	Y	Patient Admission Date
35	ORDER_DATE	DATETIME	Y	Order date
36	COLLECT_DATE	DATETIME	Y	Collection date
37	RECEIVE_DATE	DATETIME	Y	Receive date in lab
38	PROCESS_DATE	DATETIME	Y	Process date in lab
39	RESULT_DATE	DATETIME	Y	Result date in lab
40	FINAL_DATE	DATETIME	Y	Final date in lab
41	RESULT_STATUS	NVARCHAR(100)	Y	Result Status - P or F
42	ORDERING_PROVIDER_LAST_NAME	NVARCHAR(510)	Y	Ordering provider last name
43	ORDERING_PROVIDER_FIRST_NAME	NVARCHAR(510)	Y	Ordering Provider First name
44	ORDERING_PROVIDER_TITLE	NVARCHAR(510)	Y	Ordering Provider Title
45	ORDERING_PROVIDER_IDNO	NVARCHAR(510)	Y	Ordering Provider ID number
46	ORDERING_PROVIDER_PHONENO	NVARCHAR(100)	Y	Ordering Provider Phone Number
47	ORDERING_PROVIDER_ST_ADDRESS	NVARCHAR(510)	Y
48	ORDERING_PROVIDER_CITY	NVARCHAR(510)	Y
49	ORDERING_PROVIDER_STATE	NVARCHAR(510)	Y

Table:[dbo].[Tbl_MICRO_RESULT]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(60)	Y	Distinct Visit Patient Number
2	PTMEDREC	NVARCHAR(40)	Y	Patient Medical Record Number
3	PT_LAST_NAME	NVARCHAR(510)	Y	Patient Last Name
4	PT_FIRST_NAME	NVARCHAR(510)	Y	Patient First Name
5	PT_ALIAS	NVARCHAR(510)	Y	Patient Alias
6	PT_SSN	NVARCHAR(100)	Y	Patient Social Security Number
7	PT_DOB	DATETIME	Y	Patient Date Of Birth
8	PT_SEX	NVARCHAR(40)	Y	Patient Sex
9	PT_RACE	NVARCHAR(40)	Y	Patient Race
10	PT_ETHNICITY	NVARCHAR(80)	Y	Patient Ethnicity
11	PT_ADDRESS	NVARCHAR(510)	Y	Patient Address (street number)
12	PT_CITY	NVARCHAR(510)	Y	Patient City
13	PT_STATE	NVARCHAR(510)	Y	Patient State
14	PT_ZIP	NVARCHAR(40)	Y	Patient Zip Code
15	PT_COUNTY	NVARCHAR(100)	Y	Patient County
16	PT_HOME_PHONE_NO1	NVARCHAR(40)	Y	Patient Primary Home Phone Number
17	PT_HOME_PHONE_NO2	NVARCHAR(40)	Y	Patient Secondary Phone Number (cell)
18	PT_WORK_PHONE_NO	NVARCHAR(40)	Y	Patient Work Phone Number
19	LOCATION	NVARCHAR(100)	Y	Hospital Name
20	PTCLASS	NVARCHAR(40)	Y	Patient Class
21	ORDER_NO1	NVARCHAR(80)	Y	Order/Accession Number 1
22	ORDER_NO2	NVARCHAR(80)	Y	Order/Accession Number 2
23	ORDER_NO3	NVARCHAR(80)	Y	Order/Accession Number 3
24	ORDER_NO4	NVARCHAR(80)	Y	Order/Accession Number 4
25	TEST_NAME1	NVARCHAR(200)	Y	Test Name 1
26	TEST_NAME2	NVARCHAR(200)	Y	Test Name 2
27	TEST_NAME3	NVARCHAR(200)	Y	Test Name 3
28	SOURCE1	NVARCHAR(300)	Y	Source 1
29	SOURCE2	NVARCHAR(300)	Y	Source 2
30	SOURCE3	NVARCHAR(300)	Y	Source 3
31	ORG_NAME	NVARCHAR(300)	Y	Organism Name
32	RESULT	NVARCHAR(300)	Y	Test Result
33	RESULT_OTHER1	NVARCHAR(510)	Y	Other results or Comments 1
34	RESULT_OTHER2	NVARCHAR(510)	Y	Other results or comments 2
35	ANTIBIOTIC_NAME	NVARCHAR(200)	Y	Antibiotic Name
36	ABX_SUSC_INTERP	NVARCHAR(40)	Y	Antibiotic Susceptibility - R, I, or S
37	ABX_MIC_VALUE	NVARCHAR(40)	Y	Antibiotic MIC for the specific organism and antibiotic combination
38	UNITS_MICRO	NVARCHAR(40)	Y	Units for MIC
39	BREAKPOINT	NVARCHAR(40)	Y	Reference Range/Breakpoint for the organism and antibiotic combination
40	UNITS_LAB	NVARCHAR(40)	Y	Units for test result
41	REF_RANGE	NVARCHAR(40)	Y	Reference Range for Result
42	ADM_DATE	DATETIME	Y	Patient Admission Date
43	ORDER_DATE	DATETIME	Y	Order date
44	COLLECT_DATE	DATETIME	Y	Collection date
45	RECEIVE_DATE	DATETIME	Y	Receive date in lab
46	PROCESS_DATE	DATETIME	Y	Process date in lab
47	RESULT_DATE	DATETIME	Y	Result date in lab
48	FINAL_DATE	DATETIME	Y	Final date in lab
49	RESULT_STATUS	NVARCHAR(100)	Y	Result Status - P or F
50	ORDERING_PROVIDER_LAST_NAME	NVARCHAR(510)	Y	Ordering provider last name
51	ORDERING_PROVIDER_FIRST_NAME	NVARCHAR(510)	Y	Ordering Provider First name
52	ORDERING_PROVIDER_TITLE	NVARCHAR(510)	Y	Ordering Provider Title
53	ORDERING_PROVIDER_IDNO	NVARCHAR(510)	Y	Ordering Provider ID number
54	ORDERING_PROVIDER_PHONENO	NVARCHAR(100)	Y	Ordering Provider Phone Number
55	ORDERING_PROVIDER_ST_ADDRESS	NVARCHAR(510)	Y
56	ORDERING_PROVIDER_CITY	NVARCHAR(510)	Y
57	ORDERING_PROVIDER_STATE	NVARCHAR(510)	Y
58	ORDERING_PROVIDER_ZIP	NVARCHAR(510)	Y
59	ORDERING_PROVIDER_COUNTRY	NVARCHAR(510)	Y
60	ORDERING_PROVIDER_ADDRESS_TYPE	NVARCHAR(510)	Y
61	ORDERING_PROVIDER_ADDRESS_COUNTY	NVARCHAR(510)	Y
62	ABNORMAL_FLAG	NVARCHAR(100)	Y	Abnormal Flag for result
63	ORDERING_PROVIDER_AREA_CODE	NVARCHAR(100)	Y
64	ORDERING_PROVIDER_PHONE	NVARCHAR(100)	Y
65	ORDERING_PROVIDER_PHONE_EXT	NVARCHAR(100)	Y
66	SNOMED_RESULT_TYPE	NVARCHAR(8)	Y
67	SNOMED_NO	NVARCHAR(100)	Y	Snomed Value, mapped from org_name

Table:[dbo].[Tbl_OUT_NK1]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(510)	Y	Distinct Visit Patient Number

Table:[dbo].[Tbl_OUT_NTE]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(510)	Y	Distinct Visit Patient Number

Table:[dbo].[Tbl_OUT_OBR]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(510)	Y	Distinct Visit Patient Number
2	CONDITION	NVARCHAR(510)	Y

Table:[dbo].[Tbl_OUT_OBX]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(510)	Y	Distinct Visit Patient Number
2	CONDITION	NVARCHAR(510)	Y

Table:[dbo].[Tbl_OUT_ORC]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(510)	Y	Distinct Visit Patient Number

Table:[dbo].[Tbl_OUT_PID]
Index

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PAT_NUM	NVARCHAR(510)	Y	Distinct Visit Patient Number

Home | Participation | Contact us | Privacy policy | Terms of use

Copyright ©1998-2010 ELR Solutions. All rights reserved.
All information is not a substitute for medical advice or treatment for specific medical conditions.
If you have any health-care related questions or suspect you have a health problem, you should consult your health-care provider.