# Column medicare._ps.fips3_is_approximated

## Overview of column fips3_is_approximated in table medicare._ps 

|                               |                        |
| ----------------------------- | ---------------------- |
| Table                         | [medicare._ps](../medicare._ps.md)           |
| Qualified name                | medicare._ps.fips3_is_approximated  |
| Datatype                      | string        |
| Column type | computed |



## Expressions

```sql
CASE WHEN ssa3 is NOT NULL THEN
    False
  ELSE
    (SELECT NOT public.is_zip_to_fips_exact(year, zip))
END AS fips3_is_approximated
```


```{toctree}
---
maxdepth: 1
hidden:
---
fips3_is_approximated_svg_envelop.md
```


```{figure} fips3_is_approximated.svg
:align: center
:alt: Column medicare._ps.fips3_is_approximated Lineage SVG
:target: fips3_is_approximated_svg_envelop.html

Data lineage for column medicare._ps.fips3_is_approximated

```