Move Manager Database

The SISfm Move Manager database has the following structure:

Boolean fields can be of Boolean data type (in Microsoft Access), or of integer data type with value -1 representing True, or of text data type with case-insensitive value 'True' representing True.

The move_report_fields table must be populated manually, based on the supplied example database or as shown below.

Other tables are maintained by the Move Manager module and should not normally be otherwise updated.

The following describes each table:

 
move_email
groupID Email group identifier.
email Email address of a member of this group.
 
move_email_info
ID Email group identifier.
title The name of the email group. The following values have special significance:
Admin Mandatory group to which notification of all move requests is sent.
FMO Optional Facility Management Officer group to whose members notification of all move approvals is sent.
FMO_site_code Optional site FMO group to whose members notification of all move approvals involving that site is sent.
FMO_Other Optional FMO group to whose members notification of all move approvals which involve no site with its own FMO group is sent.
Contact The Contact person for a move. This group requires no entries in the EMAIL table.
DP_Mgr The department manager for a move, defined by its cost centre. This group requires no entries in the EMAIL table.
dept True if emails to members of this group include Department information.
contact True if emails to members of this group include Contact information.
approvedBy True if emails to members of this group include Approved By information.
costCtr True if emails to members of this group include Cost Centre information.
moveNotes True if emails to members of this group include Comment information.
userNotes True if emails to members of this group include User Notes information.
adminNotes True if emails to members of this group include Admin Notes information.
ext True if emails to members of this group include phone Ext information.
fax True if emails to members of this group include Equipment and Removalist information.
 
move_report_fields
outputField One of the values shown in the table below, indicating a report column to include.
fieldName The heading text for each report column, for example:
outputFieldfieldName
numMovesNumber of Staff Moved
m2ToSquare Meterage Allocated
m2FromSquare Meterage Released
siteFromSite Moving From
siteToSite Moving To
buBusiness Unit
dvDivision
dpDepartment
moveDateMove Date
roomTypeFromRoom Type Moving From
roomTypeToRoom Type Moving To
staffTypeStaff Type
initiatedByMove Initiator
costCtrCost Centre
allMoves False if the report column is only available when showing Individual moves.
dispOrder Numbers to indicate the order in which report columns are listed in the selection dialog, lowest first.
 
move_index
moveID Move identifier.
moveDate Move date.
bu_id Business unit identifier.
dv_id Division identifier.
contact Email address of move initiator.
approvedBy Email address of the supervisor of the person initiating the move. NOTE that this is not the approver of the move, which is defined according to the MoveMethodCostCentre setting.
ccProject Cost centre project identifier.
ccCostCtr Cost centre code.
fax Equipment to be moved. Field required if MoveMethodEquipment is the default.
comments Removalist notes. Field required if MoveMethodRemovalist is the default.
removalists True if removalists are required. Field required if MoveMethodRemovalist is 2.
removal_boxes Number of boxes required. Field required if MoveMethodRemovalist is 2.
removal_delivery_date Date preferred for removal delivery. Field required if MoveMethodRemovalist is 2.
removal_details Description of items to be moved. Field required if MoveMethodRemovalist is 2.
adminNotes Administration notes about the move.
moveInit Move initiation type, "A" if the initiator is a Move Manager administrator, otherwise "B" for Business Unit initiation.
hr True if the move involves HR staff updates.
fmStatus The current status of the move: waiting or approved or declined
approved True if move has been approved.
approvalDate Date of approval.
archibus True if Archibus has been updated.
archibusDate Date of Archibus update.
archived True if move has been archived.
archiveDate Date of move archival.
 
move_user
ID Unique record identifier.
moveID Move identifier.
employeeID Person's personnel number, as in the ads table of the facility database.
staffPosition Person's position description.
newDept True if a new department is created for this person during the move.
dept Department identifier.
staffType Person type: "A" for academic, "G" for general.
newStaff True if the person is a new staff member.
fromSite The identifier of the site the person is moving from.
fromBldg The identifier of the building the person is moving from.
fromLoc_Code The location code of the room the person is moving from.
fromZone The zone in the room the person is moving from. Only required if the People Manager module is enabled.
fromArea The area of the room the person is moving from.
fromRmType The room type of the room the person is moving from.
toSite The identifier of the site the person is moving to.
toBldg The identifier of the building the person is moving to.
toLoc_Code The location code of the room the person is moving to.
toZone The zone in the room the person is moving to. Only required if the People Manager module is enabled.
toArea The area of the room the person is moving to.
toRmType The room type of the room the person is moving to.
keyRequired True if the person will require a key.
ext Existing telephone extension number of the person.
newExtReq False if the telephone extension number of the person is not being transferred.
extNew New telephone extension number of the person.
port The port number of the person's existing telephone extension.
notes Notes about this person's move.
 
move_equipment(required if MoveMethodEquipment is 2)
moveID Move identifier.
tag Equipment tag.
description Equipment description.
fromLocation Equipment current location code.
toLocation Equipment destination location code.