INFECTION_ABSTNS_2
Description:
This table contains more basic information from infection 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 DAILY_MIN_MAP_YN VARCHAR No
Indicates whether the patient's daily minimum MAP value meets VAE criteria. 'Y' indicates that the patient's minimum MAP value has been documented as meeting VAE criteria. 'N' indicates that it has been documented as not meeting the criteria. NULL indicates that this information has not been documented.
May contain organization-specific values: No
Category Entries:
No
Yes
3 PEDVAE_CLIN_EVENT_C_NAME VARCHAR No
Indicates whether there were clinical events associated with the pediatric VAE event. Note that the shared category list for this column is stored in ZC_DNR_HTENSION.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
4 PEDVAE_OTHER_EVENT VARCHAR No
Free-text description of which "other" clinical event is associated with the pediatric VAE event.
5 NHSN_ABX_1_INTERNAL_ID NUMERIC No
The unique ID of the concept record that identifies the first antimicrobial agent given to the patient for the infection case.
6 NHSN_ABX_1_DATE DATETIME No
The date for the start of the first antimicrobial agent for the infection case.
7 NHSN_ABX_2_INTERNAL_ID NUMERIC No
The unique ID of the concept record that identifies the second antimicrobial agent given to the patient for the infection case.
8 NHSN_ABX_2_DATE DATETIME No
The date for the start of the second antimicrobial agent for the infection case.
9 NHSN_ABX_3_INTERNAL_ID NUMERIC No
The unique ID of the concept record that identifies the third antimicrobial agent given to the patient for the infection case.
10 NHSN_ABX_3_DATE DATETIME No
The date for the start of the third antimicrobial agent for the infection case.
11 PATH_IDENTIFIED_YN VARCHAR No
Indicates whether a pathogen was identified for the infection case. 'Y' indicates that a pathogen was identified. 'N' indicates that a pathogen was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
12 BLOOD_PATHOGEN_YN VARCHAR No
Indicates whether a pathogen was identified from a blood specimen for the infection case. 'Y' indicates that a blood pathogen was identified. 'N' indicates that a blood pathogen was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
13 NHSN_FIRST_ADMIT_TO_FAC_DATE DATETIME No
The date when the patient was first admitted to the facility where the event occurred.
14 NHSN_LTCF_INSERT_SITE_C_NAME VARCHAR No
The insertion site category ID for the abstraction.
May contain organization-specific values: No
Category Entries:
Your facility
Acute care hospital
Other
Unknown
15 NHSN_HAS_OTHER_DEVICE_YN VARCHAR No
Indicates whether another urinary device was in place besides a catheter. 'Y' indicates that another urinary device was present. 'N' indicates that another urinary device was not present. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
16 NHSN_OTHER_DEVICE_TYPE_C_NAME VARCHAR No
The other device type category ID for the abstraction.
May contain organization-specific values: No
Category Entries:
Suprapubic
External drainage (male or female)
Intermittent straight catheter
17 NHSN_LTCF_TRAN_FROM_ACUTE_YN VARCHAR No
Indicates whether the resident was transferred from acute care in the 4 weeks before the event. 'Y' indicates that the patient was transferred from acute care. 'N' indicates that the patient was not transferred. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
18 NHSN_LTCF_LAST_TRANSFER_DATE DATETIME No
If resident was transferred from acute care before the event, the date of that transfer.
19 NHSN_LTCF_TRAN_WITH_CATH_YN VARCHAR No
Indicates whether the resident had a catheter at the time they transferred. 'Y' indicates that the patient had a catheter at the time of transfer. 'N' indicates that the patient did not have a catheter at that time. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
20 NHSN_LTCF_PRIM_RES_SVC_C_NAME VARCHAR No
The primary resident service type category ID for the abstraction.
May contain organization-specific values: No
Category Entries:
Bariatric
Hospice/Palliative
Long-term dementia
Long-term general nursing
Long-term psychiatric
Skilled nursing/Short-term rehab
Ventilator
21 NHSN_LTCF_TRAN_TO_ACUTE_YN VARCHAR No
Indicates whether the resident transferred to acute care in the 7 days following the event. 'Y' indicates that the patient was transferred to acute care. 'N' indicates that the patient was not transferred. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
22 NHSN_FEVER_YN VARCHAR No
Indicates whether the patient had a fever as supporting evidence of the event. 'Y' indicates that a fever was identified. 'N' indicates that a fever was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
23 NHSN_RIGORS_YN VARCHAR No
Indicates whether the patient had rigors as supporting evidence of the event. 'Y' indicates that rigors were identified. 'N' indicates that rigors were not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
24 NHSN_CONFUSION_YN VARCHAR No
Indicates whether the patient had confusion as supporting evidence of the event. 'Y' indicates that confusion was identified. 'N' indicates that confusion was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
25 NHSN_HYPOTENSION_YN VARCHAR No
Indicates whether the patient had hypotension as supporting evidence of the event. 'Y' indicates that hypotension was identified. 'N' indicates that hypotension was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
26 NHSN_PAIN_SWELL_TEND_YN VARCHAR No
Indicates whether the patient had acute pain, swelling, or tenderness of the testes, epididymis, or prostate as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
27 NHSN_DYSURIA_YN VARCHAR No
Indicates whether the patient had acute dysuria as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
28 NHSN_URGENCY_YN VARCHAR No
Indicates whether the patient had urgency as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
29 NHSN_INCONTINENCE_YN VARCHAR No
Indicates whether the patient had incontinence as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
30 NHSN_COSTOVERT_PAIN_YN VARCHAR No
Indicates whether the patient had costovertebral angle pain or tenderness as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
31 NHSN_SUPRAPUBIC_TEND_YN VARCHAR No
Indicates whether the patient had suprapubic tenderness as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
32 NHSN_HEMATURIA_YN VARCHAR No
Indicates whether the patient had visible (gross) hematuria as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
33 NHSN_POS_URINE_CULT_YN VARCHAR No
Indicates whether the patient had a positive urine culture as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
34 NHSN_LEUKOCYTOSIS_YN VARCHAR No
Indicates whether the patient had leukocytosis as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
35 NHSN_BLOOD_CULT_MATCH_YN VARCHAR No
Indicates whether the patient had a positive blood culture as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
36 NHSN_FREQUENCY_YN VARCHAR No
Indicates whether the patient had frequency as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN
37 NHSN_PUR_DRAINAGE_YN VARCHAR No
Indicates whether the patient had purulent drainage as supporting evidence of the event. 'Y' indicates that this evidence was identified. 'N' indicates that this evidence was not identified. NULL indicates that this information was not documented for the infection case.
The category values for this column were already listed for column: DAILY_MIN_MAP_YN