NSQIP_PREOP_LABS

Description: |
The NSQIP_PREOP_LABS table contains information about preoperative lab data. This table is used in conjunction with NSQIP_INFO to provide NSQIP registry data for the surgeries that are selected for NSQIP submission.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REGISTRY_DATA_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REGISTRY_DATA_ID | NUMERIC | No |
The unique identifier (.1 item) for the registry data record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | NSQIP_LAB_COMPON_C_NAME | VARCHAR | No |
The category ID for the lab component.
May contain organization-specific values: No
Category Entries:
Serum Sodium (Na)
Blood Urea Nitrogen (BUN)
Serum Creatinine (Cr)
Albumin (Alb)
Total Bilirubin (TB)
Serum Glutamic-Oxaloacetic Transaminase (SGOT/AST)
Alkaline Phosphatase (Alk Phos)
White Blood Count (WBC)
Hematocrit (Hct)
Platelet Count (Plt)
Internat'l Normalized Ratio (INR)
Partial Thromboplastin Time (PTT)
Hemoglobin A1c (HbA1c)
Hemoglobin (Hgb)
4 | NSQIP_LAB_VALUE | NUMERIC | No |
The lab value.
5 | NSQIP_LAB_DT | DATETIME | No |
The date the lab was collected.
6 | NSQIP_LAB_UNKNOWN_YN | VARCHAR | No |
Indicates whether the lab component value is unknown.
May contain organization-specific values: No
Category Entries:
No
Yes
7 | NSQIP_LAB_UNIT_C_NAME | VARCHAR | No |
The category ID of the NSQIP preop lab unit.
May contain organization-specific values: No
Category Entries:
mmol/L
mEq/L
mg/dL
umol/L
g/L
g/dL
U/L
K/mm3
Decimal
Percentage
Seconds
mmol/mol