Operations

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.

Represents the aggregate number of rooms within a defined unit, facility, or reporting category. Used in healthcare facility management, capacity planning, and regulatory reporting systems to track total room inventory, bed availability, and utilization metrics across inpatient settings.

The elapsed time in minutes between one patient exiting an operating room, procedure room, or clinical space and the next patient entering, encompassing cleaning, equipment setup, and preparation. Room turnover time is a key throughput metric — reducing turnover time directly increases the number of cases or appointments a facility can accommodate within available hours.

The category classification identifying the type of patient room, such as private, semi-private, ICU, NICU, or observation, in hospital ADT and billing systems. Maps to UB-04 revenue codes 010x–019x. Data engineers use rm_typ to stratify accommodation charges, support payer contract analysis, and validate claim submissions.

The nursing unit or care area designation associated with a patient room within hospital ADT, EHR, and staffing systems. Links physical room assignments to clinical departments. Data engineers use rm_unt to join room records with unit-level cost centers, staffing ratios, and departmental billing attributes in facility datasets.

Captures the most recent date on which a patient room record was modified in the facility management or healthcare information system. Used for audit trail maintenance, data governance, and synchronization across bed management, scheduling, and clinical documentation platforms.

Indicates the priority or time-sensitivity level assigned to a patient room request or room-related event, such as emergency turnover or urgent bed assignment. Used in bed management and facility operations systems to triage room preparation tasks and support rapid patient throughput.

A discrete measured data point associated with a patient room record in hospital EHR, ADT, or facility management systems, such as accommodation charge amount, acuity score, or occupancy metric. Data engineers use rm_val as a flexible numeric attribute in room-level analytics and financial reconciliation workflows.

The sequential version number assigned to a patient room record, tracking changes to room attributes such as designation, capacity, or equipment over time. Enables audit trails and historical comparisons of room configurations within facility management and clinical data systems.

The postal ZIP code associated with the physical location of a patient care room or clinical space. Used in facility management systems to identify the geographic location of care delivery, support billing accuracy, and enable location-based reporting across multi-site healthcare facilities.

The full address associated with a medication or treatment administration route record, identifying the physical location where the route is documented or administered. Used in pharmacy and clinical systems to link administration pathways to specific care sites or home infusion locations.

The current authorization state of a medication or treatment administration route, indicating whether the route has been reviewed, approved, pending, or rejected by clinical staff. Supports pharmacy workflow management and ensures only validated administration pathways are used in active care plans.

The monetary charge associated with a specific medication or treatment administration route, capturing the cost billed for route-specific delivery methods such as IV, intramuscular, or subcutaneous administration. Used in pharmacy billing and claims processing to itemize administration-related service fees.

The date on which a specific medication or treatment administration route becomes active and valid for clinical use. Used in pharmacy and clinical documentation systems to define the start of an approved route within a care plan, treatment protocol, or formulary record.

The group identifier associated with a medication or treatment administration route, used to categorize routes within a defined formulary group, care protocol, or insurance benefit structure. Supports pharmacy management and reporting by linking routes to applicable coverage or clinical groupings.

The unique patient medical record number linked to a specific medication or treatment administration route record, enabling patient-level tracking of prescribed and administered routes. Used in pharmacy and clinical systems to associate route documentation with an individual patient's longitudinal health record.

The planned calendar date on which a medication or treatment administration via a specific route is scheduled to occur. Used in pharmacy and nursing workflow systems to coordinate care delivery, ensure timely medication administration, and support scheduling compliance reporting.

The planned clock time at which a medication or treatment is scheduled to be administered via a specific route. Used in pharmacy and nursing systems to coordinate time-sensitive drug delivery, support medication administration records (MAR), and monitor adherence to prescribed dosing schedules.