NHSN_PROC_ABSTNS
Description:
This table contains basic information from procedure 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 PAT_ID VARCHAR No
The unique identifier (.1 item) for the associated patient (EPT) record.
3 CUR_STAT_C_NAME VARCHAR No
The current status of the procedure abstraction.
May contain organization-specific values: Yes
Category Entries:
New
Associated
Populated
In Progress
Edited
Validated
Needs Review
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
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
4 CUR_STAT_USER_ID VARCHAR No
The internal ID of the user who set the current status.
5 CUR_STAT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 CUR_STAT_DTTM DATETIME (UTC) No
The instant at which the current status (RDI-10024) was set.
7 NHSN_VERSION_C_NAME VARCHAR No
The category ID for the NHSN version to use for the abstraction. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
May contain organization-specific values: No
Category Entries:
IDM 7.1
IDM 8.1
IDM 8.3/8.4
IDM 8.5
IDM 8.6/8.7
IDM 8.8-9.0
IDM 9.2
IDM 9.4
IDM 9.5
IDM 10.1
IDM 11.1
IDM 12.0
8 NHSN_PROC_DT DATETIME No
The date of the procedure.
9 NHSN_PROC_DURATION_HOURS INTEGER No
The hour piece of the duration of the procedure.
10 NHSN_PROC_DURATION_MINS INTEGER No
The minute piece of the duration of the procedure.
11 NHSN_CPT_CODE VARCHAR No
The CPT code associated with procedure abstraction.
12 NHSN_GEN_ANESTH_YN VARCHAR No
Indicates whether general anesthesia was used for this operative procedure.
May contain organization-specific values: No
Category Entries:
No
Yes
13 NHSN_TRAUMA_CASE_YN VARCHAR No
Indicates whether this operative procedure was performed because of blunt or penetrating traumatic injury to the patient.
The category values for this column were already listed for column: NHSN_GEN_ANESTH_YN
14 NHSN_SCOPE_USED_YN VARCHAR No
Indicates whether this entire operative procedure was performed using a laparoscope/robotic assist.
The category values for this column were already listed for column: NHSN_GEN_ANESTH_YN
15 NHSN_DIABETES_YN VARCHAR No
Indicates whether the patient has a diagnosis of diabetes requiring management with insulin or a non-insulin anti-diabetic agent.
The category values for this column were already listed for column: NHSN_GEN_ANESTH_YN
16 NHSN_HEIGHT NUMERIC No
The patient's most recent height documented in the medical record in inches (in) prior to this operative procedure.
17 NHSN_WEIGHT NUMERIC No
The patient's most recent weight documented in the medical record in ounces (oz) prior to this operative procedure.
18 NHSN_OUTPAT_YN VARCHAR No
Indicates whether the operative procedure was performed on an NHSN Outpatient.
The category values for this column were already listed for column: NHSN_GEN_ANESTH_YN
19 NHSN_WOUND_CLASS_C_NAME VARCHAR No
The wound classification category ID for the operative procedure.
May contain organization-specific values: No
Category Entries:
Clean
Clean-contaminated
Contaminated
Dirty
20 NHSN_ASA_SCORE_C_NAME VARCHAR No
The ASA classification category ID for the operative procedure.
May contain organization-specific values: No
Category Entries:
ASA 1
ASA 2
ASA 3
ASA 4
ASA 5
ASA 6
21 NHSN_EMERG_YN VARCHAR No
Indicates whether the operative procedure was a non-elective, unscheduled operative procedure.
The category values for this column were already listed for column: NHSN_GEN_ANESTH_YN
22 NHSN_CLOSURE_TECH_C_NAME VARCHAR No
The closure technique category ID for the operative procedure.
May contain organization-specific values: No
Category Entries:
Primary
Other than Primary
23 NHSN_SPINAL_LVL_C_NAME VARCHAR No
The spinal fusion level category ID for the operative procedure.
May contain organization-specific values: No
Category Entries:
Atlas-axis
Atlas-axis / Cervical
Cervical
Cervical / Dorsal / Dorsolumbar
Dorsal / Dorsolumbar
Lumbar / Lumbosacral
24 NHSN_SPINAL_TECH_C_NAME VARCHAR No
The spinal fusion technique category ID for the operative procedure.
May contain organization-specific values: No
Category Entries:
Anterior
Posterior
Both Anterior and Posterior
Transoral
25 NHSN_PROST_TYPE_C_NAME VARCHAR No
The prosthesis type category ID for the operative procedure.
May contain organization-specific values: No
Category Entries:
Total: Total Primary
Total: Total Revision
Total: Partial Revision
Hemi: Partial Primary
Hemi: Total Revision
Hemi: Partial Revision
Resurfacing: Total Primary
Resurfacing: Total Revision
Resurfacing: Partial Primary
Resurfacing: Partial Revision
26 NHSN_SURGEON_CODE VARCHAR No
The code of the surgeon who performed the principal operative procedure.
27 LOG_ID VARCHAR No
The unique identifier of the surgical log (ORL .1) associated with the procedure abstraction.
28 NHSN_LABOR_DURATION INTEGER No
The number of hours the patient was in labor in the hospital.
29 NHSN_PROC_CODE_ID NUMERIC No
The NHSN procedure code associated with procedure abstraction.
30 NHSN_JOINT_INFECTION_YN VARCHAR No
Stores whether the prosthesis is associated with an infection at the index joint.
The category values for this column were already listed for column: NHSN_GEN_ANESTH_YN
31 NHSN_OR_LOG_PANEL_C_NAME VARCHAR No
The panel number from the OR log used to create an NHSN procedure abstraction.
May contain organization-specific values: No
Category Entries:
Panel 1
Panel 2
Panel 3
Panel 4
Panel 5
32 NHSN_ICD_PROC_ID VARCHAR No
The ICD code associated with a procedure abstraction.
33 NHSN_ICD_PROC_ID_ICD_PX_NAME VARCHAR No
The name of the ICD procedure record.
34 HOW_CREATED_C_NAME VARCHAR No
The category ID for the method used to create the procedure 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
35 ASSOCIATED_LOC_ID NUMERIC No
The unique ID of the location (hospital) associated with the procedure.
36 NHSN_ADMISSION_DT DATETIME No
The date the patient was admitted for the purpose of submission to the CDC.