Function Validate PHIN: Difference between revisions

m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
No edit summary
 
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary =  
| DIC_summary =  
* for patients with Province = MB, the PHIN has to be (> 100 000 000 and <= 130 000 000) or 999 999 999 (to accommodate [[PHIN_field#Location_Manitoba_and_no_PHIN]]  
* for patients with Province = MB, the PHIN has to be (> 100 000 000 and <= 130 000 000) or 999 999 999 (to accommodate [[PHIN_field#Location_Manitoba_and_no_PHIN]]  
* for out-of-province patients, the PHIN must be entered as blank
* for out-of-province patients, the PHIN must be entered as blank
Line 8: Line 8:
| DIC_timing =
| DIC_timing =
| DIC_app = CCMDB.accdb
| DIC_app = CCMDB.accdb
| DIC_coding =
| DIC_coding = Function Validate_PHIN()
| DIC_status = implemented
| DIC_status = implemented
| DIC_implementation_date = 2008-01-01
| DIC_implementation_date = 2008-01-01