API - Updates to PPR lien check logic

[mstanton1]

No API PPR blocking restrictions for staff users
API PPR blocking restrictions for non-staff:

MHR Reg Types	PPR Reg Types	Additional Conditions
All	SA_TAX, TA_TAX, TM_TAX	Active secured party name includes "TAX DEFERME"
EXEMPTION_RES	SA_GOV, TA_GOV, TM_GOV	Active secured party name includes "HER MAJESTY"
		and base registration date <= 2004-03-31
EXEMPTION_RES	FR, LT, ML, MN, SG	None
PERMIT	LT, ML, MN	None
TRAN*	SA_GOV, TA_GOV, TM_GOV	Active secured party name includes "HER MAJESTY"
		and base registration date <= 2004-03-31
TRAN*	FR, LT, ML, MN, SG	None

API changes

• Update the MHR database view for querying the existence of a PPR registration matching on the serial collateral MHR number.
• Update the view to append "_TAX" to the PPR registration type if it is SA, TA, TM, and an active secured party name includes "TAX DEFFERME".
• Update the view to append "_GOV" to the PPR registration type if it is SA, TA, TM, and an active secured party name includes "HER MAJESTY" and the base registration date is <= 2004-03-31
• Update the API data validiation rules for non-staff change registrations to add the above restrictions.

Note:
The UI has some additional rules allowing non-staff registrations but requiring confirmation of secured party consent.
The UI displays a warning or an error for all homes that have an existing PPR registration depending on the combination of user role and PPR registration type.

This ticket could be tested with the UI changes.

[mstanton1]

@lbergero819 can you attached the most recent documentation from Kevin on the rules for lien check types? cc @doug-lovett

[lbergero819]

These are the rules from Kevin and the related updates to the exemptions, transfers, transports requirements documents/business rules sheet.

Kevin's PPR rules doc:
PPR registrations affecting MHR - application and policy guidance.pdf

Rescind exemptions:
https://docs.google.com/spreadsheets/d/1nxTG6Qcv7BQw9bLHbGpgtgGSewcLpZBB/edit#gid=1909519054

Residential exemption:
https://docs.google.com/spreadsheets/d/169Yd7Bg91bYL1Jb25RTuhyFJhqaAF1KM/edit#gid=759470850

Non-residential exemptions:
https://docs.google.com/spreadsheets/d/1vwDY05Rw2dEL1aZOoHlv9qDIuoZyw4CZ/edit#gid=331490516

Transport permit:
https://docs.google.com/spreadsheets/d/1THlmisT_fO89k61VV91frXevFgpPoy4M/edit#gid=1727788641

Transfers:
https://docs.google.com/spreadsheets/d/11gLZJdBmhJRun69bTC08ticO2Vnjm9be/edit#gid=1132546852

[mstanton1]

Hey team! Please add your planning poker estimate with Zenhub @cameron-eyds @chdivyareddy @dimak1 @doug-lovett @RuoxuanPengBC

[doug-lovett]

DEV MHR numbers with outstanding PPR registrations for testing:
LT:
064182
085548
064110
060984
103155

FR:
743567
523425
064377

SA_TAX:
067667
093733

SA_GOV:
026222

SA:
104007
061700
088766
094352
023120

ML:
022083
097973
094268
047078
001952

MN:
523425

[chdivyareddy]

Will verify this after the UI change is implemented.

[chdivyareddy]

Verified with the UI ticket 17744.