CoMIS is a management information system that is used by county CPC's to manage their MH/MR/DD/BI cases.
Update to CoMIS for Data Warehouse Extracts and SPP bug fix - release Date 8/24/2007.
Q. What is the logic for determining the ValidSSN indicator in the extract for the WarehouseClient.XLS file?
A. the ValidSSN indicator is set to "No" when any one of the following conditions are met:
The first 3 characters of the SSN are less than "001"
The first 3 characters of the SSN are greater than "772"
The last 4 characters of the SSN are equal to "0000"
The SSN is equal to "111-11-1111"
The SSN is equal to "123-45-6789"
The SSN is equal to "222-22-2222"
The SSN is equal to "333-33-3333"
The SSN is equal to "444-44-4444"
The SSN is equal to "555-55-5555"
The SSN is equal to "666-66-6666"
The SSN is equal to "777-77-7777"
The SSN is equal to "888-88-8888"
The SSN is equal to "999-99-9999"
Q. What is the logic for determining the IsPerson indicator in the extract for WarehouseClient.XLS
A. An analysis was done of first and last names across all counties, and 2 lists were compiled: Last names that were not people and first names that were not people. The IsPerson indicator is set to no when the person's last name or first name matches a list of names that were determined to be non-clients. A client record with the first name of "Multiple Persons" would have the IsPerson indicator set to "No". Anoterh example is if the client record has a last name of "ADMINISTRATION" then the IsPerson indicator is set to "No". Finally, when the length of the first name is less than 3 characters, and when the ValidSSN indicator is set to "No", this will cause the IsPerson indicator to be set to "Check".
