CASE_RPT_ABSTNS

Description: |
This table contains information about reportable case 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 | CASE_RPT_AGENCY_C_NAME | VARCHAR | No |
The reporting agency category ID for the reportable case abstraction.
May contain organization-specific values: Yes
Category Entries:
Alabama Department of Public Health
Alaska Department of Health and Social Services
Arizona Department of Health Services
Arkansas Department of Health
California Department of Public Health
Colorado Department of Public Health & Environment
Connecticut Department of Public Health
Delaware Division of Public Health
Florida Department of Health
Georgia Department of Public Health
Hawaii State Department of Health
Idaho Department of Health and Welfare
Illinois Department of Public Health
Indiana State Department of Health
Iowa Department of Public Health
Kansas Department of Health and Environment
Kentucky Department for Public Health
Louisiana Department of Health & Hospitals
Maine Department of Health and Human Services
Maryland Department of Health and Mental Hygiene
Massachusetts Department of Public Health
Michigan Department of Health & Human Services
Minnesota Department of Health
Mississippi State Department of Health
Missouri Department of Health & Senior Services
Montana Department of Public Health and Human Services
Nebraska Department of Health & Human Services
Nevada Division of Public and Behavioral Health
New Hampshire Department of Health and Human Services
State of New Jersey Department of Health
New Mexico Department of Health
New York State Department of Health
North Carolina Department of Health and Human Services
North Dakota Department of Health
Ohio Department of Health
Oklahoma State Department of Health
Oregon Health Authority
Pennsylvania Department of Health
State of Rhode Island Department of Health
South Carolina Department of Health and Environmental Control
South Dakota Department of Health
Tennessee Department of Health
Texas Department of State Health Services
Utah Department of Health
Vermont Department of Health
Virginia Department of Health
Washington State Department of Health
West Virginia Department of Health & Human Resources
Wisconsin Department of Health Services
Wyoming Department of Health
District of Columbia Department of Health
Terveyden ja Hyvinvoinnin Laitos
3 | CASE_RPT_TYPE_C_NAME | VARCHAR | No |
The report type category ID for the reportable case abstraction.
May contain organization-specific values: Yes
Category Entries:
Non STD
STD
4 | CASE_RPT_COND_ID | NUMERIC | No |
The unique ID of the associated reportable condition (HFR) record. This column is frequently used to link to the REGISTRY_CONFIG table.
5 | CASE_RPT_COND_ID_REGISTRY_NAME | VARCHAR | No |
The name of the registry record.
6 | PAT_ID | VARCHAR | No |
The unique ID of the associated patient (EPT) record. This column is frequently used to link to the PATIENT table.
7 | CUR_STAT_C_NAME | VARCHAR | No |
The current status category ID for the reportable case 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
Ready for Final Export
8 | CREATION_DATE | DATETIME | No |
The date that the case was created.
9 | COND_DATE | DATETIME | No |
The date associated with the condition.
10 | REGISTRY_TYPE_C_NAME | VARCHAR | No |
The registry type category ID for the reportable case 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
NSQIP
NSQIP Pediatric
MBSAQIP
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
eMED3 Fit Note
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
NHSE Emergency Activity
NHSE Admitted Patient Care Activity
HH Outcomes
HH Adverse Events
National POLST Form
Anaphylaxis Emergency Action Plan
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
MCSA-5871
MCSA-5872
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
AQI Anesthesia Community Registry
AJRR Procedure Layout
AJRR PROMs Layout
AJRR PostOp Layout
11 | HOW_CREATED_C_NAME | VARCHAR | No |
The creation method category ID for the reportable case 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
12 | CASE_NOTE_ID | VARCHAR | No |
The unique ID of the case note associated with the reportable case abstraction.
13 | HOSPITAL_CENSUS_UTC_DTTM | DATETIME (UTC) | No |
Stores the instant of the hospital census in UTC if the Hospital Census batch created this abstraction row.
14 | HOSPITAL_CENSUS_DTTM | DATETIME (Attached) | No |
Stores the instant of the hospital census in local time if the Hospital Census batch created this abstraction.
15 | ASSOC_RFV_ID_REASON_VISIT_NAME | VARCHAR | No |
The name of the Reason for Visit record.