Skip to content

[FEATURE] Add [run_id] column to [inputs].[special_mgras] #91

@Eric-Liu-SANDAG

Description

@Eric-Liu-SANDAG

Is your feature request related to a problem? Please describe

Currently, [inputs].[special_mgras] is created with the assumption that all Estimates runs will use the exact same set of special MGRAs. As a result, the table has no [run_id] column. This assumption is suspect, as I anticipate adding additional MGRAs relating the college areas or senior facilities. If more MGRAs are added, then we need some way to associate different sets of special MGRA with different runs for documentation purposes.

Describe the solution you'd like

Of course, the obvious way to do so is to add a [run_id] column. That way, different runs can use different sets of special MGRAs. Then, [inputs].[special_mgras] would be created for each [run_id] when the startup module was run

Describe alternatives you've considered

N/A

Additional context

This is actually already reflected in the wiki, as an output table of the Startup module

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions