HMIS / LSASampleCode

Longitudinal System Analysis (LSA) Sample Code and Documentation
22 stars 10 forks source link

Please check if X placeholder in SSN described in the Glossary affects SSNValid rule in LSA #1220

Closed nataliesus closed 3 weeks ago

nataliesus commented 1 month ago

Hi @MollyMcEvilley , @JulesABrown ,

I have a question about SSN validation rule that checks that SSN contains only digits:

image

According to the Glossary, SSN may contain vendor-designated placeholder character(s) (i.e. we will use "x" in our system) that are allowed and their existence does not make SSN invalid:

image

Maybe c.SSN like '%[^0-9]%' should be rewritten as replace( c.SSN, 'x', '' ) like '%[^0-9]%'.

What do you think?

Best regards, Natalie

nataliesus commented 1 month ago

just in case, the Spec also needs correction: image

nataliesus commented 1 month ago

also, "SSN begins with '000', '666', or '9'" instructions should be updated to "the First three digits cannot be “000,” “666,” or in the 900 series” to mimic Glossary, Or maybe it is a Glossary that should be fixed... image

MollyMcEvilley commented 3 weeks ago

The LSA specs aren't impacted by Glossary changes. We are going to leave the SSN validation as is for this year.