Column medicare.beneficiaries.number_of_gap_years

Overview of column number_of_gap_years in table medicare.beneficiaries

Table

medicare.beneficiaries

Qualified name

medicare.beneficiaries.number_of_gap_years

Datatype

INT

Column type

generated

Expressions

SELECT GENERATED ALWAYS AS (last_enrollment_year - first_enrollment_year + 1 - CARDINALITY(all_enrollment_years)) STORED
Column medicare.beneficiaries.number_of_gap_years Lineage SVG

Data lineage for column medicare.beneficiaries.number_of_gap_years