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
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 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
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 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
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.