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