CMS_SEP1_ABSTN
Description:
This table containts basic information about CMS SEP-1 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 associated patient's EPT .1
3 PAT_DATE DATETIME No
The date of linked EPT contacts to this record.
4 UNOS_STAGE_C_NAME VARCHAR No
The current state of the registry record
May contain organization-specific values: Yes
Category Entries:
New
Associated
Populated
In Progress
Edited
Validated
Needs Review
Needs Review - Updated
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
Ready for Prospective Reporting
Prospective Reporting Complete
5 RYN_WHT_ETHNICITY_C_NAME VARCHAR No
The patient's Hispanic/Latino ethnicity category ID
May contain organization-specific values: No
Category Entries:
Hispanic/Latino
Non-Hispanic/Latino
6 CLINICAL_TRIAL_YN VARCHAR No
Indicates whether the patient was enrolled in a clinical trial for sepsis during the hospital stay.
May contain organization-specific values: No
Category Entries:
No
Yes
7 CMS_SEX_ASGN_AT_BIRTH_C_NAME VARCHAR No
The patient's sex assigned at birth category ID for the CMS SEP-1 core measure.
May contain organization-specific values: No
Category Entries:
Female
Male
Intersex
None of the Above, Other, or Unable to Determine
Preferred Not to Answer
8 TJC_RACE_C_NAME VARCHAR No
The patient's race category ID for the CMS SEP-1 core measure.
May contain organization-specific values: No
Category Entries:
White
Black or African American
American Indian or Alaska Native
Asian or Pacific Islander
Unable to determine the patient’s race or not stated
9 DISCH_UTC_DTTM DATETIME (UTC) No
The date and time the patient was discharged from acute care, discharged as left against medical advice, or discharged as expired during this stay.
10 TRANS_YN VARCHAR No
Indicates if the patient was received as a transfer from an inpatient, outpatient. or emergency/observation department of an outside hospital or from an ambulatory surgery center (ASC).
The category values for this column were already listed for column: CLINICAL_TRIAL_YN
11 PREG_OR_POST_DLVR_YN VARCHAR No
Indicates if the patient was at least 20 weeks pregnant or within three days after delivery at the instant of severe sepsis presentation.
The category values for this column were already listed for column: CLINICAL_TRIAL_YN
12 SEP_SHOCK_YN VARCHAR No
Indicates the presence of septic shock.
The category values for this column were already listed for column: CLINICAL_TRIAL_YN
13 SEP_SHOCK_UTC_DTTM DATETIME (UTC) No
The earliest date and time on which the final criterion was met to establish the presence of septic shock.
14 SEVERE_SEP_YN VARCHAR No
Indicates the presence of severe sepsis.
The category values for this column were already listed for column: CLINICAL_TRIAL_YN
15 SEVERE_SEP_UTC_DTTM DATETIME (UTC) No
The earliest date and time on which the final criterion was met to establish the presence of severe sepsis.
16 SEP1_FINAL_STATUS_C_NAME VARCHAR No
The final measure status category ID of the SEP-1 abstraction case.
May contain organization-specific values: Yes
Category Entries:
Rejected
In Numerator Population
Not In Measure Population
In Measure Population
17 SEP_SHOCK_REFUSE_YN VARCHAR No
Indicates if refusal of blood draw, IV fluid administration, or vasopressor administration is documented before or within six hours after the Septic Shock Presentation Instant.
The category values for this column were already listed for column: CLINICAL_TRIAL_YN
18 SEVERE_SEP_REFUSE_YN VARCHAR No
Indicates if refusal of blood draw, IV fluid administration, or vasopressor administration is documented before or within six hours after the Severe Sepsis Presentation Instant.
The category values for this column were already listed for column: CLINICAL_TRIAL_YN
19 BLD_CULT_COLL_UTC_DTTM DATETIME (UTC) No
The date and time when a blood culture sample was collected.
20 LACT_COLL_UTC_DTTM DATETIME (UTC) No
The date and time an initial lactate level was collected.
21 SEP1_LACTATE_RESULT_C_NAME VARCHAR No
The initial lactate level category ID for the CMS SEP-1 core measure.
May contain organization-specific values: Yes
Category Entries:
Less than or equal to 2 mmol/L
Between 2 and 4 mmol/L
Greater than or equal to 4 mmol/L
22 RE_LACT_COLL_UTC_DTTM DATETIME (UTC) No
The earliest date and time the repeat lactate level was collected.
23 ANTIBIO_ADMIN_UTC_DTTM DATETIME (UTC) No
The earliest date and time a broad spectrum or other antibiotic was started.
24 CRYS_FLUID_ADMIN_UTC_DTTM DATETIME (UTC) No
The earliest date and time on which crystalloid fluids were initiated within six hours prior through three hours after either the Initial Hypotension Instant or the Septic Shock Presentation Instant, whichever is earlier.
25 SEP_SHOCK_PAL_CARE_YN VARCHAR No
Indicates if hospice or palliative care is ordered within the specific time frame for septic shock care.
The category values for this column were already listed for column: CLINICAL_TRIAL_YN
26 SEVERE_PAL_CARE_YN VARCHAR No
Indicates if hospice or palliative care is ordered before or within six hours after the presentation of severe sepsis.
The category values for this column were already listed for column: CLINICAL_TRIAL_YN
27 HYPOTN_UTC_DTTM DATETIME (UTC) No
The date and time of initial hypotension in the six hours prior to or within six hours following Severe Sepsis Presentation Instant and prior to the completion of the target ordered volume of crystalloid fluids.
28 PRST_HYPOTN_UTC_DTTM DATETIME (UTC) No
The date and time of persistent hypotension following the administration of the target ordered volume of crystalloid fluids.
29 VSPR_ADMIN_UTC_DTTM DATETIME (UTC) No
The date and time at which an IV or intraosseous vasopressor was administered within the Septic Shock Presentation Instant through six hours after the Septic Shock Presentation Instant.
30 SIRS_UTC_DTTM DATETIME (UTC) No
The earliest date and time two or more SIRS criteria were met.
31 ORGAN_DSFX_UTC_DTTM DATETIME (UTC) No
The earliest date and time of evidence of organ dysfunction.
32 SEP_DOCU_UTC_DTTM DATETIME (UTC) No
The earliest date and time a physician, APN, or PA documented sepsis.
33 RE_VOL_ASMT_UTC_DTTM DATETIME (UTC) No
The earliest date and time the repeat volume status and tissue perfusion assessment was documented.
34 BLD_DELAY_YN VARCHAR No
Indicates if there was an acceptable delay in blood culture collection.
The category values for this column were already listed for column: CLINICAL_TRIAL_YN