...

1. Load list of faculty and staff with mapped Archibus dept codes into Archibus

2. Move tables of buildings, spaces and space charges from Archibus into Axiom

Design

Components

Bold items are final/consumed views

1. Box

   1. https://tufts.box.com/s/769g7q2an711v7ylustmzsqr7bcojnpl

   2. https://tufts.app.box.com/file/1499128437018?s=cnnx4ymr5qjobzpv0rq8nrk9sp5pnxz1

   3. https://tufts.box.com/s/ybok7ycosjorb4purixrr2wvtln4tfri

2. Denodo VDP

   1. operations_facilities

      1. 01-base_layer

         1. 01-connections

            1. Box

               1. ds_box_org_mappings

            2. ds_archibus

         2. 02-base_views

            1. archibus

               1. bv_bl

               2. bv_rm

               3. bv_rmtype

               4. bv_rmpct

            2. box

               1. bv_box_org_mappings

      2. 02-transformation

         1. archibus

            1. agg_archibus_dept_code_min_hr_dept_number

            2. p_buildings_axiom

            3. u_hr2pr_exmployee_vw_pr_identities_archibus

      3. 03-integration

         1. archibus

            1. j_hr_org_mapping_archibus

            2. j_space_axiom

            3. j_space_charges_axiom

3. Denodo Scheduler

   1. findb_load_buildings

   2. findb_load_space

   3. findb_load_space_charges

...