Open VT-AOE-DMAD-Drew-Bennett opened 2 years ago
This issue is part of an active working group, and all are welcome to join. If you're interested, please contact jackie.hughes@aemcorp.com or duane.brown@aemcorp.com.
The group addresses issues submitted by SEAs that require approval from three organizations. You can access the priority tickets spreadsheet here. Teams meeting link here.
This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.
Author(s) Drew Bennett Authoring Organization(s) State of Vermont Email address drew.bennett@vermont.gov Use Case Title Add StatusStartDate and StatusEndDate for PersonMilitary
Use Case Description rds.PersonStatus includes elements that are MilitaryConnected_StatusStartDate, MilitaryConnected_StatusEndDate
Work Around My current workaround is getting the StatusStartDate and StatusEndDate from OrganizationPersonRole EntryDate and ExitDate
SELECT PersonMilitaryId, PersonMilitary.DataCollectionId, PersonMilitary.PersonId, CODE AS MilitaryConnectedStudentIndicator, EntryDate AS MilitaryConnected_StatusStartDate, ExitDate AS MilitaryConnected_StatusEndDate INTO ##PersonMilitary FROM Generate.dbo.PersonMilitary PersonMilitary INNER JOIN Generate.dbo.RefMilitaryConnectedStudentIndicator RefMilitaryConnectedStudentIndicator ON PersonMilitary.RefMilitaryConnectedStudentIndicatorId = RefMilitaryConnectedStudentIndicator.RefMilitaryConnectedStudentIndicatorId INNER JOIN Generate.dbo.OrganizationPersonRole OrganizationPersonRole ON OrganizationPersonRole.DataCollectionId = PersonMilitary.DataCollectionId AND OrganizationPersonRole.PersonId = PersonMilitary.PersonId