IDS: Reference Address type and Reference Person Location Type codes/descriptions are missing for Staff, Organization and Person address types

[dasaiahvenkatacha]

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) Padmanabha

Authoring Organization(s) State of Michigan

Email Address [email protected]

Use Case Title
Reference Address type and Reference Person Location Type codes and description/definitions are missing for Staff, Organization and Person

Use Case Overview
CEDSElements table has elements such as 'Address Type for Organization' and 'Address Type for Staff' but no corresponding codes/description records in the tables dbo.RefAddresstype and dbo.RefPersonLocationType

Pull Request Number(s) (If applicable)

Use Case Background
Unable to map 'Address Type for Organization' and 'Address Type for Staff' elements to get an different addresses such as Mailing,Physical, Other home address,Employer's address,Employment address,Billing address.

Components Affected
Delete everything from the list below except the components affected:

CEDS Integrated Data Store (complete IDS Design Overview Table) _CEDSElements, RefAddresstype, RefPersonLocationType