Operations

The specific calendar date on which room and board or accommodation services were delivered to an inpatient, as recorded in hospital billing and EHR systems. Maps to UB-04 service date fields and is used by data engineers to validate daily accommodation charges against payer adjudication timelines.

A classification indicating the clinical seriousness or acuity level associated with a patient's room assignment in hospital ADT and EHR systems. Differentiates ICU, step-down, and medical-surgical placements. Data engineers use rm_sev to support case mix analysis, staffing models, and DRG severity reporting.

Designates the biological sex classification assigned to a patient room, indicating whether the room is designated for male, female, or mixed-gender patients. Used in inpatient bed management systems to enforce patient placement policies and maintain privacy compliance.

The originating system or data feed from which a room assignment record was captured, such as ADT, EHR, or facility management platforms. Used by data engineers during ETL to track data provenance, resolve duplicate room records, and maintain audit trails across Epic, Cerner, or HL7 ADT message pipelines.

The calendar date marking the beginning of a patient's assignment to a specific inpatient room, captured in ADT and EHR systems via admit or transfer events. Data engineers use rm_start_dt to calculate room tenure, validate billing periods, and build patient flow timelines across facility encounters.

Records the clock time at which a patient room becomes active for occupancy, a clinical procedure begins, or a scheduled room event commences. Used in facility management and surgical or procedural suite scheduling systems to track room utilization and throughput.

Captures the US state or Canadian province associated with a patient room's facility location. Used in healthcare facility registry and credentialing systems to support geographic reporting, regulatory compliance, and multi-site hospital network administration.

The current operational state of a patient room or room assignment within hospital ADT, EHR, and facility management systems. Common values include occupied, vacant, cleaning, or reserved. Data engineers use rm_sts to support bed management analytics, capacity planning, and real-time census reporting pipelines.

Records the physical street address of the facility building where the patient room is located. Used in healthcare facility management systems and provider directories to identify the precise location of inpatient units, clinics, or procedural spaces within a health system.

Indicates the capacity or structural rating associated with a patient room, such as weight-bearing limits for specialized equipment or the number of patients the room is rated to accommodate. Used in facility management systems for equipment placement and safety compliance.

Represents a partial aggregated value associated with room-level charges, utilization counts, or resource consumption within a billing period. Used in healthcare revenue cycle and facility cost accounting systems to calculate intermediate totals before final room charge reconciliation.

A unique system-generated key assigned to a patient room record within a healthcare information or facility management system. Used as the primary reference to link room data across bed management, scheduling, billing, and clinical documentation platforms throughout the health system.

The destination room or unit identified for a patient transfer or placement within hospital ADT and EHR systems. Captured during bed request and transfer workflows. Data engineers use rm_tgt to analyze transfer efficiency, bed turnaround times, and patient flow bottlenecks across inpatient facility data pipelines.

A standardized classification code categorizing the type or functional designation of a patient room, such as ICU, surgical suite, or isolation room. Used in facility management and healthcare data systems to organize rooms by clinical purpose for reporting and resource allocation.

The recorded ambient temperature of a specific patient care room or clinical space, used to monitor environmental conditions for infection control, medication storage compliance, and patient comfort. Tracked in facility management and clinical systems to ensure regulatory standards are met.

Records the date on which a patient room is officially decommissioned, taken out of service, or its active designation ends within the facility management system. Used to maintain accurate room inventory records and support historical reporting on room availability and utilization.

The specific time of day associated with a room assignment event such as admission, transfer, or discharge in hospital ADT and EHR systems. Combined with room date fields to create precise timestamps. Data engineers use rm_tm to calculate throughput metrics, shift-level census counts, and bed utilization rates.

The combined date and time value recording when a room assignment event occurred in hospital ADT, EHR, or facility management systems. Supports precise sequencing of patient movements. Data engineers use rm_ts for event-driven analytics, HL7 ADT message reconciliation, and inpatient flow latency calculations.

Stores the formal name or designated label assigned to a patient room within a healthcare facility, such as Room 214 or Trauma Bay 1. Used in facility management, clinical documentation, and scheduling systems to consistently identify and reference specific rooms across workflows.

The aggregated monetary or unit sum of room and board charges associated with an inpatient stay or billing period in hospital billing and EHR systems. Used in UB-04 claim construction. Data engineers use rm_tot to validate accommodation line item totals against payer remittance and expected reimbursement models.