Archibus Data Accuracy – Project Tracking
Data Update Tasks
Task |
Description |
Assigned to |
Status |
Room Type Names |
Update, fix capitalization, make readable |
Bill |
Complete |
CadNow Republishing |
Publish NA floorplans to new standards |
Josephine |
Complete |
Update Floor Names |
Update to standardize |
Janice |
Complete |
Update Active Sites |
Set sites to active if in global list of active sites, else inactive |
Janice |
Complete |
Update Active Buildings |
Review list of unknown status buildings and confirm status – all owned buildings from Melanie’s research and leased buildings from Archibus lease records have been given a status |
Melanie/Ghazaleh |
Complete |
Add Missing Floors |
Confirm scrub report data and submit ticket |
Ghazaleh |
Complete |
Submit Tickets for Missing Floorplans |
Confirm scrub report data and submit tickets for new drawings |
Ghazaleh |
Complete |
Building/Site Updates |
Add missing data fields |
Ghazaleh |
Complete |
Map Personnel Sub Areas to Buildings |
For automated seating of new hires |
Bill |
Complete |
Add Building Images |
Upload images |
Bill |
Complete |
Review Room Names |
Define Standards |
Melanie |
Complete |
Add Building Use |
Associate building use with buildings (use scrub report) |
Bill |
Complete |
Scrub Properties List |
Update status and type for old property records (Sandisk) |
Ghazaleh/Keith |
Complete |
Submit Drawing Verification Tickets |
Submit tickets for all active drawings to be verified, include comments from spreadsheet |
RSC |
Complete |
Clean Up Drawing Folder |
Keith – discussed with Matt and documented standards are in knowledge base |
Keith |
Complete |
Building Data Admins |
Designate who is responsible for data updates by building |
Bill/Sharon |
Cancelled |
Drawing Verification |
Keith |
Complete |
|
Drawing Certification |
Discuss how to assign this out |
All |
Complete |
Floor Walks |
Room category/type and occupants |
All |
Complete |
Scrub Reports
Table |
Data Issue |
Report |
Assigned To |
Room |
Not connected to drawing |
https://wdc.rsc2lc.com/archibus/rsc-rm-scrub-report.axvw |
Keith |
Room |
Missing Room Category |
https://wdc.rsc2lc.com/archibus/rsc-rm-scrub-report.axvw |
Keith |
Room |
Missing Room Type |
https://wdc.rsc2lc.com/archibus/rsc-rm-scrub-report.axvw |
Keith |
Room |
Missing Floorplan |
https://wdc.rsc2lc.com/archibus/rsc-rm-scrub-report.axvw |
Keith |
Building |
Location Background Scrub Report |
https://wdc.rsc2lc.com/archibus/rsc-loc-scrub.axvw |
Janice |
Building |
Missing Floor |
https://wdc.rsc2lc.com/archibus/rsc-bl-scrub.axvw |
Ghazaleh |
Building |
Missing Name |
https://wdc.rsc2lc.com/archibus/rsc-bl-scrub.axvw |
Ghazaleh |
Building |
Missing Postal Code |
https://wdc.rsc2lc.com/archibus/rsc-bl-scrub.axvw |
Ghazaleh |
Building |
Missing Coordinates |
https://wdc.rsc2lc.com/archibus/rsc-bl-scrub.axvw |
Janice |
Site |
Missing Site Number |
https://wdc.rsc2lc.com/archibus/rsc-site-scrub.axvw |
Keith |
Building Image |
Missing Building Image |
https://wdc.rsc2lc.com/archibus/rsc-bl-scrub.axvw |
Bill |
Building Use |
Building Use Unknown |
https://wdc.rsc2lc.com/archibus/rsc-bl-scrub.axvw |
Bill |
Room Type |
Old Room Types |
https://wdc.rsc2lc.com/archibus/schema/rsc-scrub-rmtype-old.axvw |
Keith |
Standards Documents
Document |
Description |
Assigned to |
Status |
Drawing Standard Layers |
Drawing standard layers used |
Janice |
Complete |
CAFM Background Information |
Location data standards, Room categories, types, standards |
Janice |
Complete |
Drawing Publishing Process |
Publishing process |
Janice |
Complete |
Global Portfolio Maintenance Process |
Adding buildings, leases, requesting floorplans, closing buildings |
Janice |
Complete |
Drawing Folder Standards |
Drawing Publishing – Drawing Folder Standards |
Janice |
Complete |
MicroView Floorwalk Process |
Space – MicroView Floorwalks |
Janice |
Complete |
Data Automation Tasks (to be added after upgrade)
Task |
Description |
Assigned to |
Status |
Set Room Capacity |
Update capacity for all personnel space to 1 where it is zero (UPDATE rm SET rm.cap_em = ‘1’ WHERE rm.cap_em = ‘0’ and rm.rm_cat = ‘PERS’ and rm.rm_type NOT IN (‘OPEN-PLAN’, ‘TOUCHDOWN’)) |
Janice |
Completed |
Reports
Report |
Status |
All Active Buildings in Portfolio (by site, building, floor) https://wdc.rsc2lc.com/archibus/schema/ab-rsc-areas-by-building-site-summary.axvw https://wdc.rsc2lc.com/archibus/schema/ab-rsc-areas-by-building.axvw https://wdc.rsc2lc.com/archibus/schema/rsc-areas-by-fl-summary.axvw |
Completed |
Portfolio update status (floor drawing status: not required, required, requested, completed, verified, certified, closed) https://wdc.rsc2lc.com/archibus/schema/wdc-drawing-status.axvw |
Completed |
Restrict standard RSC reports to active buildings https://wdc.rsc2lc.com/archibus/schema/rsc-01-occupancy-grid.axvw https://wdc.rsc2lc.com/archibus/schema/rsc-02-divsum-tree_drill.axvw https://wdc.rsc2lc.com/archibus/schema/rsc-03-bldgsum-tree.axvw https://wdc.rsc2lc.com/archibus/schema/rsc-04-sitesum-tree.axvw |
Completed |
Usable Room Area Breakdown by Building and Category https://wdc.rsc2lc.com/archibus/schema/rsc-usable-area-by-bl-rmcat.axvw |
Completed |
Was this helpful?
0 / 0