Verify Location Codes

The SISfm page database/verifyLocCode.aspx is available to verify that all loc_code field values are correct.

The following tables are processed, in this order:

rm
XX_rm(for each facility type code XX in FacilityType settings)
rm_zone(if PersonModule is TRUE)
rmpct(if PersonModule is TRUE and PersonArchibusMode is TRUE)
em(if PersonModule is not TRUE)
em_editable(if PersonModule is TRUE) and EmEditable specifies this table)
em_schedule(if PersonModule is TRUE)

The resulting page lists verification failures like this:

rm.bl_id='1' fl_id='01' rm_id='102' loc_code='20015A01102a' invalid, should be '20015A01102'
...

and concludes with statistics for each table:

Table rm loc_code invalid n1 valid n2 undefined n3 total n4 rows
...

If verification failures were listed, this is followed by the link:

UPDATE ALL INVALID loc_code VALUES

which if selected will list fixed verification failures like this:

rm.bl_id='1' fl_id='01' rm_id='102' loc_code='20015A01102a' invalid, should be '20015A01102' *** FIXED
...