Back to search
stay account number
stay_acct_nbrgeneral
Updated 3/30/2026
Definition
The account reference number for a inpatient care duration. Used as a unique reference to identify and track the stay across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for stay management and reporting.
Standard Abbreviation
stay_acct_nbr
Category
general
Database Usage
-- Example column naming
CREATE TABLE claims (
claim_id VARCHAR(50),
stay_acct_nbr VARCHAR(100), -- stay account number
...
);
-- Example in SELECT
SELECT
claim_id,
stay_acct_nbr as stay_account_number
FROM claims;Looking for more healthcare terms?
Browse our complete library of 65,000+ standardized healthcare data terms
Browse All Terms