Back to search

authorization legal name

auth_legal_nm
general
Updated 3/30/2026

Definition

The official registered name for a service pre-approval. Used to display and describe the authorization in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for authorization management and reporting.

Standard Abbreviation

auth_legal_nm

Category

general

Database Usage

-- Example column naming
CREATE TABLE claims (
  clm_id VARCHAR(50),
  auth_legal_nm VARCHAR(100),  -- authorization legal name
  ...
);

-- Example in SELECT
SELECT
  clm_id,
  auth_legal_nm as authorization_legal_name
FROM claims;

Common uses in healthcare data

  • Healthcare data warehouse schema design and modeling
  • Interoperability and cross-system data exchange
  • ETL pipeline development and orchestration
  • Master data management (MDM) programs
  • Analytics and business intelligence reporting

Example database column name

ISO-11179 snake_case standard

-- Recommended column name
authorization_legal_name

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  authorization_legal_name VARCHAR(255),  -- authorization legal name
  created_dt  TIMESTAMP     NOT NULL DEFAULT NOW()
);

Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.

Looking for more healthcare terms?

Browse our complete library of 100,000+ standardized healthcare data terms

Browse All Terms