Skip to content

Update the program participation fields in the Staging tables and supporting code #857

@lizbrunet

Description

@lizbrunet

CIID 7941

CEDS uses "exit date" to indicate when a person leaves a program, rather than "end date." To align with CEDS naming conventions, the Column Names need to be updated.

Update the program participation fields in the Staging tables and supporting code:

Change [ProgramParticipationEndDate] to [ProgramParticipationExitDate] across ProgramParticipationCTE, NorD, SpecialEducation, TitleI, and TitleIII.

Change [FosterCare_ProgramParticipationEndDate] to [FosterCare_ProgramParticipationExitDate] in PersonStatus.

Change [Immigrant_ProgramParticipationEndDate] to [Immigrant_ProgramParticipationExitDate] in PersonStatus.

Change [Section504_ProgramParticipationEndDate] to [Section504_ProgramParticipationExitDate] in PersonStatus.

Metadata

Metadata

Assignees

No one assigned

    Labels

    v13.0Tickets identified as part of the v13.0 release

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions