ACS Data Users Group

 View Only
Back to discussions
Expand all | Collapse all

Some tables have field names with dates in them, so to re-run any reports each year = revisit field names / descriptions

  • 1.  Some tables have field names with dates in them, so to re-run any reports each year = revisit field names / descriptions

    Posted 09-09-2023 08:23 PM

    OK, some tables ex B25038 have hard-coded field descriptions that change every 2 years. I think the actual column name would stay the same? and it would just be the description would change. Typicially you never have time dimensions like this. It's last 2 years, last 3 years etc. so its good year after year. If you had a report that you relabeled / shortened any names or descriptions, you would have to be careful the following year.

    Column Name Label
    GEO_ID Geography
    NAME Geographic Area Name
    B25038_001E Estimate!!Total:
    B25038_001EA Annotation of Estimate!!Total:
    B25038_001M Margin of Error!!Total:
    B25038_001MA Annotation of Margin of Error!!Total:
    B25038_002E Estimate!!Total:!!Owner occupied:
    B25038_002EA Annotation of Estimate!!Total:!!Owner occupied:
    B25038_002M Margin of Error!!Total:!!Owner occupied:
    B25038_002MA Annotation of Margin of Error!!Total:!!Owner occupied:
    B25038_003E Estimate!!Total:!!Owner occupied:!!Moved in 2019 or later
    B25038_003EA Annotation of Estimate!!Total:!!Owner occupied:!!Moved in 2019 or later
    B25038_003M Margin of Error!!Total:!!Owner occupied:!!Moved in 2019 or later
    B25038_003MA Annotation of Margin of Error!!Total:!!Owner occupied:!!Moved in 2019 or later
    B25038_004E Estimate!!Total:!!Owner occupied:!!Moved in 2015 to 2018
    B25038_004M Margin of Error!!Total:!!Owner occupied:!!Moved in 2015 to 2018
    B25038_004MA Annotation of Margin of Error!!Total:!!Owner occupied:!!Moved in 2015 to 2018


  • 2.  RE: Some tables have field names with dates in them, so to re-run any reports each year = revisit field names / descriptions

    Posted 09-09-2023 08:27 PM

    This is something people do have to be aware of that isn't obvious. Keeps everyone on their toes. It also comes up in tables dealing with year home built, among others.