Page Comparison

...

SELECT
  l.LocationID shortIdentifier,
  (case when l.active = 1 then 'active' else 'inactive' end) locationStatus,
  l.LocationString displayName,
  l.Site Site,
  l.Room Room,
  l.UnitType UnitType,
  l.UnitNumber UnitNumber,
  l.UnitPosition UnitPosition
FROM
  locations l
;

notes

• it is suggested here that the numeric LocationID be converted into a unique recognizable id by prefix the number with 'ls'. Perhaps this is unwarranted.the five levels of the hierarchy will need to be mapped into some sort of CSpace hierarchy. The BT/NT relations ships or else relationships may be sufficent, but this remains to be demonstrated. At any rate the schema (and UI?) would need to be modified to hold and render these values.
• there is probably some cleaning that can be identified and performed as part of this migration. TBD!