NHSN_CLIP_ABSTNS
Description:
The NHSN_CLIP_ABSTNS table contains information from Central Line Insertion Practices abstractions.

Primary Key
Column Name Ordinal Position
REGISTRY_DATA_ID 1

Column Information
Name Type Discontinued?
1 REGISTRY_DATA_ID NUMERIC No
The unique ID for the CLIP event.
2 PAT_ID VARCHAR No
The unique ID of the associated patient record for the CLIP event.
3 CUR_STAT_C_NAME VARCHAR No
The current status category ID of the CLIP event.
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
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
4 CUR_STAT_USER_ID VARCHAR No
The internal ID of the user who set the current abstraction status for the CLIP event.
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 date and time when the current abstraction status was set for the CLIP event.
7 CREATION_DATE DATETIME No
The date when the CLIP event was created.
8 NHSN_INSERTION_DATE DATETIME No
The date when the central line was inserted for the CLIP event.
9 NHSN_RECORDER_C_NAME VARCHAR No
The recorder category ID for the CLIP event.
May contain organization-specific values: No
Category Entries:
Inserter
Observer
10 NHSN_INSRTR_EMP_ID VARCHAR No
The unique ID of the employee who inserted the central line for the CLIP event.
11 NHSN_INSRTR_EMP_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 NHSN_INSERTER_JOB_C_NAME VARCHAR No
The occupation category ID of the central line inserter for the CLIP event.
May contain organization-specific values: No
Category Entries:
Fellow
Medical Student
Other Student
Other Medical Staff
Physician Assistant
Attending Physician
Intern/Resident
Registered Nurse
Advanced Practice Nurse
Other
13 NHSN_ON_PICC_TEAM_YN VARCHAR No
Stores whether the central line inserter was a member of the PICC/IV team.
May contain organization-specific values: No
Category Entries:
No
Yes
14 NHSN_INSRTN_RSN_C_NAME VARCHAR No
The reason category ID for the central line insertion for the CLIP event.
May contain organization-specific values: No
Category Entries:
New indication for central line
Replace malfunctioning central line
Suspected central line-associated infection
Other
15 NHSN_GUIDEWIRE_YN VARCHAR No
Indicates whether the central line was exchanged over a guidewire for the CLIP event. This column is only populated if NHSN_INSRTN_RSN_C has a value of 3 - Suspected central line-associated infection.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
16 NHSN_HAND_HYGIENE_YN VARCHAR No
Indicates whether hand hygiene was performed prior to the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
17 NHSN_WORE_MASK_YN VARCHAR No
Indicates whether a sterile mask was worn for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
18 NHSN_WORE_GOWN_YN VARCHAR No
Indicates whether a sterile gown was worn for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
19 NHSN_USED_DRAPE_YN VARCHAR No
Indicates whether a sterile drape was used for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
20 NHSN_WORE_GLOVES_YN VARCHAR No
Indicates whether sterile gloves were worn for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
21 NHSN_WORE_CAP_YN VARCHAR No
Indicates whether a sterile cap was worn for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
22 NHSN_PREP_CHG_YN VARCHAR No
Indicates whether chlorhexidine gluconate was used as a skin prep agent for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
23 NHSN_PREP_IODINE_YN VARCHAR No
Indicates whether povidone iodine was used as a skin prep agent for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
24 NHSN_PREP_ALCOHOL_YN VARCHAR No
Indicates whether alcohol was used as a skin prep agent for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
25 NHSN_PREP_OTHER_YN VARCHAR No
Indicates whether any other agent (aside from chlorhexidine gluconate, povidone iodine, or alcohol) was used as a skin prep agent for the central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
26 NHSN_CHG_CONTRAIND_C_NAME VARCHAR No
The CHG contraindication category ID for the central line insertion for the CLIP event. This column is only populated if NHSN_PREP_CHG_YN has a value of N.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
27 NHSN_PREP_DRY_YN VARCHAR No
Indicates whether the skin prep agent used was dry at the time of central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
28 NHSN_INSRTN_SITE_C_NAME VARCHAR No
The insertion site category ID for the central line insertion for the CLIP event.
May contain organization-specific values: No
Category Entries:
Femoral
Jugular
Lower Extremity
Scalp
Subclavian
Umbilical
Upper Extremity
29 NHSN_COATED_CATH_YN VARCHAR No
Indicates whether an antimicrobial coated catheter was used for this central line insertion for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
30 NHSN_CL_CATH_TYPE_C_NAME VARCHAR No
The catheter type category ID for the central line insertion for the CLIP event.
May contain organization-specific values: No
Category Entries:
Non-tunneled (other than dialysis)
Tunneled (other than dialysis)
Dialysis non-tunneled
Dialysis tunneled
PICC
Umbilical
Other
31 NHSN_CL_SUCCESS_YN VARCHAR No
Indicates whether the central line insertion was successful for the CLIP event.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
32 NHSN_OTHER_JOB VARCHAR No
The occupation of the person inserting a central line for the CLIP event. This column is only populated if NHSN_INSERTER_JOB_C has a value of 10 - Other.
33 NHSN_OTHER_RSN VARCHAR No
The reason for a central line for the CLIP event. This column is only populated if NHSN_INSRTN_RSN_C has a value of 4 - Other.
34 NHSN_OTHER_PREP VARCHAR No
The skin prep agent used for a central line for the CLIP event. This column is only populated if NHSN_PREP_OTHER_YN has a value of Y.
35 NHSN_OTHER_CL_TYPE VARCHAR No
The catheter type used during a central line insertion for the CLIP event. This column is only populated if NHSN_CL_CATH_TYPE_C has a value of 7 - Other.
36 NHSN_CHG_AGE_YN VARCHAR No
Indicates whether the patient was less than 2 months old when the central line was inserted for the CLIP event. This column is only populated if NHSN_CHG_CONTRAIND_C has a value of 1 - Yes.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
37 NHSN_CHG_ALLERGY_YN VARCHAR No
Indicates whether the patient has an allergy to chlorhexidine gluconate for the CLIP event. This column is only populated if NHSN_CHG_CONTRAIND_C has a value of 1 - Yes.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
38 NHSN_CHG_SAFETY_YN VARCHAR No
Indicates whether facility restrictions or safety concerns for chlorhexidine gluconate use in premature infants precludes its use for the CLIP event. This column is only populated if NHSN_CHG_CONTRAIND_C has a value of 1 - Yes.
The category values for this column were already listed for column: NHSN_ON_PICC_TEAM_YN
39 ASSOCIATED_LOC_NHSN_DEF_ID_CMS_MU_NAME VARCHAR No
The name of the CMS Meaningful Use record.