|
Category: Constituent
|
Frequency: Weekly
|
Platform: SQL Server Stored Procedure
|
Owner: DMT
|
What Does It Do?
The OUD-DS3 best practice is for gender data to be kept on a record during changes, so that if the data is unavailable in an update that the value be maintained.
This integrity check identifies constituent records that have recently had their gender changed from Male or Female to Unknown so that the record can be updated with the previously known gender value.
How Is This Done?
This integrity check is run using a SQL Server stored procedure called “[uspDI_Constituent_Gender_Audit_Recovery]”, which is located in DB-OUD > Databases > DMT > Programmability > Stored Procedures.
That stored procedure queries non-organizational constituent records that previously had a value of Male or Female for gender and now have a value of Unknown so that the gender can be updated with the previously known value of Male or Female.