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
Generic Attribution - External ID Bundle
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
Regulatory Reporting External ID Bundle 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
SRTR Kidney Pre-Transplant Data
SRTR Liver Pre-Transplant Data
SART CORS
SART Configuration
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
NHSE Admin Pathway Submission - Cancer RTT - Current
NHSE Admin Pathway Submission - Cancer RTT - Weekly
NHSE Admin Pathway Submission - Cancer RTT - Monthly
NHSE Admin Pathway Submission - Cancer Treatment - Current
NHSE Admin Pathway Submission - Cancer Treatment - Weekly
NHSE Admin Pathway Submission - Cancer Treatment - Monthly
NHSE Outpatient Activity
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
CA-17 Duty Status Report
CA-20 Attending Physician's Report
MCSA-5870
Federal MCSA-5871
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
IPFQR Abstraction Registry
COVID-19 PUI Case Report
Building Blocks Registry
Certificate of Death
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
Quality Observation
SEP-1 Abstraction
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 (OPA Trigger)
Syndromic Surveillance Syndrome
GIQuIC-Colonoscopy
Analytics Registry
BH IPFQR Abstraction Details
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
Ready for Prospective Reporting
Prospective Reporting Complete
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
Procedure - Manual
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.