EXPOSURE_ABSTNS

Description:

This table contains information about outbreak and exposure abstractions.

Primary Key

Column Name	Ordinal Position
REGISTRY_DATA_ID	1

Column Information

	Name	Type	Discontinued?
1	REGISTRY_DATA_ID	NUMERIC	No
	The unique identifier (.1 item) for the registry data record.
2	EXPOSURE_NOTE_ID	VARCHAR	No
	The unique ID of the case note associated with the exposure abstraction.
3	PAT_ID	VARCHAR	No
	The unique ID of the patient who was exposed.
4	PATIENT_DIED_YN	VARCHAR	No
	Indicates whether the patient died. May contain organization-specific values: No Category Entries: No Yes
5	DEATH_DATE	DATETIME	No
	The date of the patient's death.
6	MDR_TYPE_C_NAME	VARCHAR	No
	The MDR type category ID that the patient was exposed to. May contain organization-specific values: Yes
7	EXPOSURE_STATUS_C_NAME	VARCHAR	No
	The status category ID for the exposure case. May contain organization-specific values: Yes No Entries Defined
8	DX_DATE	DATETIME	No
	The date that the exposed patient was diagnosed as positive with an infection.
9	PASSIVATING_DATE	DATETIME	No
	The date by which the patient's exposure case should be resolved.
10	MICROBE_ORGANISM_ID	NUMERIC	No
	The unique ID of the organism for the patient's exposure case.
11	MICROBE_ORGANISM_ID_NAME	VARCHAR	No
	The name of the organism.
12	SPA_TYPE_C_NAME	VARCHAR	No
	The SPA type category ID specifying the strain of MRSA for the patient's exposure. May contain organization-specific values: Yes No Entries Defined
13	RISK_PERMANENCE_C_NAME	VARCHAR	No
	The degree of permanence category ID for the patient's exposure to the organism. May contain organization-specific values: Yes No Entries Defined
14	RISK_CERTAINTY_C_NAME	VARCHAR	No
	The degree of certainty category ID that the patient was exposed to the microbe. May contain organization-specific values: Yes No Entries Defined
15	RESOURCE_C_NAME	VARCHAR	No
	The source of information category ID for the exposure investigation. May contain organization-specific values: Yes No Entries Defined
16	RISK_EDIT_REASON_C_NAME	VARCHAR	No
	The edit reason category ID for modifying the exposure case. May contain organization-specific values: Yes No Entries Defined
17	RISK_END_REASON_C_NAME	VARCHAR	No
	The end reason category ID for closing the exposure case. May contain organization-specific values: Yes No Entries Defined
18	RISK_REACTIVATE_REASON_C_NAME	VARCHAR	No
	The reactivation reason category ID for reopening a closed exposure case. May contain organization-specific values: Yes No Entries Defined
19	OUTBREAK_REGISTRY_DATA_ID	NUMERIC	No
	The unique ID of the outbreak investigation that the exposure case is a part of.
20	SAMPLE_TYPE_C_NAME	VARCHAR	No
	The sample type category ID which diagnosed the patient. May contain organization-specific values: Yes No Entries Defined
21	DX_DISTRICT_C_NAME	VARCHAR	No
	The region category ID where the patient was diagnosed with the infection. May contain organization-specific values: Yes No Entries Defined
22	DX_FACILITY_TYPE_C_NAME	VARCHAR	No
	The type of facility category ID where the patient was diagnosed with the infection. May contain organization-specific values: Yes No Entries Defined
23	DX_FACILITY_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
24	DX_DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
25	EPIDEMIC_CODE	VARCHAR	No
	The description of the outbreak event.
26	CREATION_USER_ID	VARCHAR	No
	The unique ID of the user who created the abstraction
27	CREATION_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
28	EXPOSER_PAT_ID	VARCHAR	No
	The unique ID of the patient who exposed other patients to the outbreak.
29	EXPOSURE_SOURCE_C_NAME	VARCHAR	No
	The exposure source category ID for whether the exposure occurred domestically or abroad. May contain organization-specific values: Yes No Entries Defined
30	HOSPITAL_CONTACT_C_NAME	VARCHAR	No
	The type of contact category ID for the visit where the patient was exposed. May contain organization-specific values: Yes No Entries Defined
31	TRANSMISSION_TYPE_C_NAME	VARCHAR	No
	The transmission type category ID for whether the transmission was hospital-acquired or community-acquired. May contain organization-specific values: Yes No Entries Defined
32	COUNTRY_C_NAME	VARCHAR	No
	The country category ID where the exposure occurred, if abroad. May contain organization-specific values: Yes
33	TRANSMISSION_DISTRICT_C_NAME	VARCHAR	No
	The region category ID where the patient was exposed to the microbe. May contain organization-specific values: Yes No Entries Defined
34	TRANSMISSION_FAC_TYPE_C_NAME	VARCHAR	No
	The type of facility category ID where the patient was exposed to the microbe. May contain organization-specific values: Yes No Entries Defined
35	TRANSMISSION_FACILITY_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
36	TRANSMISSION_DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
37	REGISTRY_TYPE_C_NAME	VARCHAR	No
	The registry type category ID for the exposure or outbreak abstraction. May contain organization-specific values: Yes Category Entries: Core Measures ACC-NCDR CathPCI Version 3 and 4 ACC-NCDR EP Device Implant Meaningful Use Quality Measures ACC-NCDR PINNACLE ACC-NCDR AFib Ablation ACC-NCDR CathPCI ACC-NCDR CathPCI Follow-up ACC-NCDR AFib Ablation Follow-Up UNOS Configuration Vermont Oxford Network Quality Measure - Individual Quality Measure - Patient Details Generic Attribution Physician Quality Reporting Summary - Incremental Meaningful Use Summary - Incremental Internal QM Summary - Incremental Physician Quality Reporting Registry Summary - Full Year Meaningful Use Summary - Final Physician Quality Reporting Registry Summary - Half Year Physician Quality Reporting EHR Summary - Full Year Universal Data System Summary Universal Data System Details QRDA-III XML Run Summary Regulatory Reporting Patient Metadata Objective Measures - Run Statistics Objective Measures - EP Fact Objective Measures - Patient Fact Objective Measures - Summary Objective Measures - EH Fact My Panel Metrics - Patient Pulse Information RDI Child Record Health and Care Plan UNOS Kidney Recipient Follow-up UNOS Liver Recipient Follow-up UNOS Pancreas Recipient Follow-up UNOS Kidney/Pancreas Recipient Follow-up UNOS Thoracic Recipient Follow-up UNOS Kidney Living Donor Follow-up UNOS Kidney Pancreas Wait List UNOS Liver Intestine Wait List UNOS Thoracic Wait List UNOS Kidney Candidate Registration UNOS Liver Candidate Registration UNOS Heart/Lung Candidate Registration UNOS Heart Candidate Registration UNOS Lung Candidate Registration UNOS Pancreas and Pancreas Islets Candidate Registration UNOS Kidney/Pancreas Candidate Registration UNOS Kidney Recipient Registration UNOS Liver Recipient Registration UNOS Pancreas Recipient Registration UNOS Kidney/Pancreas Recipient Registration UNOS Thoracic Recipient Registration UNOS Kidney Living Donor Registration UNOS Deceased Donor Registration UNOS Deceased Donor Histocompatibility ACS NSQIP THL Implant Surgical Care Improvement Project Hoitotahto Elinluovutustahto NHSE Admin Pathway Submission - Diagnostic - Current NHSE Admin Pathway Submission - Diagnostic - Weekly NHSE Admin Pathway Submission - Diagnostic - Monthly NHSE Admin Pathway Submission - RTT - Current NHSE Admin Pathway Submission - RTT - Weekly NHSE Admin Pathway Submission - RTT - Monthly NHSE Diagnostic Activity Submission NHSE Diagnostic Planned Waiting Lists HH Outcomes HH Adverse Events National POLST Form Ryan White Services Reporting Ryan White CAREWare Reporting Nationale Intensive Care Evaluatie Pediatrische Intensive Care Evaluatie Australian and New Zealand Pediatric Intensive Care Registry Australian and New Zealand Neonatal Network Swiss MDSi MyChart Federal MCSA-5875 State MCSA-5875 Certificate MCSA-5876 CG719K Form Belgium eBirth - Birth Notification Belgium eBirth - Medical Form Fødselsmelding Skatteetaten Medisinsk fødselsregister (MFR) Labour Birth Postpartum Maternal HBHC Birth Child Postpartum Child NICU Child HBHC Abstraction Subabstraction Minimum Data Set Infection Case NHSN Lab Identified Organism Procedure Abstraction COVID-19 Hospital Infections EQRS Submission CMS Registration Form 2728 CMS Death Form 2746 Nephrology Configuration American Heart Association Get With The Guidelines - Stroke COVID-19 PUI Case Report Lung Cancer Screening Registry ASCO-QOPI Cancer Outcomes and Services Dataset Perined: Kernset Aanleverbericht THL: Congenital Malformations Family Planning Annual Report IRF-PAI CMG Data 60% Rule Data CMG Score Config Data Map IGC Data IRF IGC Spotter Risk Adjusted Self Care Change Risk Adjusted Mobility Change Risk Adjusted Self Care Discharge Risk Adjusted Mobility Discharge IRF Risk Adjustment ICD-10 to HCC Mappings Infection Control Regulatory Definitions Infection Control LDA-Based Metric Definition Infection Control Metric Details Infection Control Manual Metric Details Configuration Template Infection Control Surveillance Abstraction Infection Control Search Parameters NHSN Antimicrobial Resistance Event Exposure Case Abstraction Outbreak Definition NHSN CLIP Abstraction Scoring System Deferral Configuration Scoring System Deferral User Interface Configuration Reporting Agency Configuration Reportable Condition Configuration Syndromic Surveillance Event Type (BPA Trigger) Syndromic Surveillance Syndrome GIQuIC-Colonoscopy Analytics Registry
38	CUR_STAT_C_NAME	VARCHAR	No
	The current status category ID of the abstraction. May contain organization-specific values: Yes Category Entries: New Associated Populated In Progress Edited Validated Needs Review Needs Review - Updated Ready for Export Exported Restored Signed Ready to Sign Ready to Submit Submitted Accepted Rejected Done Submit Historical Modified Inactivated Void Saved to EQRS Dialysis Intra-Facility Transfer Manually Submitted End COSD Pathway Investigating Closed Abstracting Completed Ready for Nurse Review Ready for Physician Review Waiting for Signoff Care Planning Complete Will Not Be Exported Accepted with Warnings Unopened Canceled A0410 Correction Requested Wrong FAC_ID Test Record Corrected/Inactivated/Deleted Abandoned Admission Complete Doc Complete Filed
39	CUR_STAT_USER_ID	VARCHAR	No
	The unique ID of the user who set the current abstraction status.
40	CUR_STAT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
41	CUR_STAT_DTTM	DATETIME (UTC)	No
	The date and time when the current abstraction status was set.
42	RECORD_CREATION_DATE	DATETIME	No
	The date the record was created.
43	HOW_CREATED_C_NAME	VARCHAR	No
	The creation method category ID for the exposure abstraction. May contain organization-specific values: No Category Entries: Imported NHSN LabID-Quick Create NHSN LabID-Abstract NHSN LabID-Abstract All NHSN Procedure-Quick Create NHSN Procedure-Abstract NHSN Procedure-Manual NHSN Procedure-Surgical Print Group Procedure-Batch Job NHSN SSI-Create SSI SSI-Create SSI (From Surveillance Abstraction) NHSN VAE-Batch Job Event-Create Case Event-Manual NHSN AR-Abstract All NHSN AR-Abstract NHSN CLIP - Manual NHSN CLIP - Created from LDA NHSN CLIP - Quick Create NHSN CLIP - Abstract Surveillance Abstraction - Batch Job Case Reporting - Manual Case Reporting - Automated - Diagnosis Case Reporting - Automated - Reason for Visit Case Reporting - Automated - Lab Result Case Reporting - Automated - Hospital Census NHSN PedVAE - Criteria Print Group NHSN PedVAE-Batch Job NHSN LOS/MEN Event - Batch Job NHSN LOS/MEN Event - Criteria Print Group
44	EXPOSURE_REMARKS	VARCHAR	No
	Information about how this exposure should impact patient care.
45	DECLARED_DATE	DATETIME	No
	The date the outbreak was declared.
46	DECLARED_OVER_DATE	DATETIME	No
	The date the outbreak was declared over.
47	EXPOSED_DATE	DATETIME	No
	Date the patient was exposed.