Apps and Their Sync Tables

Last updated
Save as PDF

Apps and Their Sync Tables

App	Sync Tables Used
Asset & Equipment Survey	On app load: background data tables: afm_currencies afm_scmpref afm_activity_params (restricted to a list of values) afm_users (only current user) site bl fl rm survey (surveys for the device employee with ISSUED status) em dv dp eqstd afm_dwgs (restricted) sync data tables: eq_audit download floor plans
Asset & Equipment Registration	On app load: background data tables: afm_activity_params (restricted to a list of values) afm_currencies afm_scmpref afm_users (only current user) site bl After site selection: background data tables: fl (only for selected sites and buildings) rm (only for selected sites and buildings) em (only for selected sites and buildings) sync data tables: eqstd_sync On Sync or Complete: sync data tables: eq_sync eqstd_sync
Assessment	On Sync: background data tables: afm_currencies afm_scmpref afm_activity_params (restricted to a list of values) afm_users (only current user) project site bl fl rm eqstd em activitytype pd questionnaire questions afm_dwgs (restricted) eq (only for activity_log_sync items) sync data tables: activity_log_sync Floor plans are downloaded on Floor Plan view display.
Incidents Reporting	On app load: background data tables: afm_currencies afm_scmpref afm_activity_params (restricted to a list of values) afm_users (only current user) ehs_incident_types ehs_incident_injury_cat ehs_incident_injury_areas em site property bl fl rm contact afm_dwgs (restricted) On Sync: background data tables: all tables downloaded on app load if download is necessary sync data tables: ehs_incidents_sync ehs_incident_witness_sync docs_assigned_sync
Hazardous Materials	On app load: background data tables: site After site selection: download site drawing background data tables: bl (only for the selected site) afm_activity_params (restricted to a list of values) afm_currencies afm_scmpref afm_users (only current user) fl (only for buildings in selected site) rm (only for buildings in selected site) aisle (only for buildings in selected site) cabinet (only for buildings in selected site) shelf (only for buildings in selected site) bin (only for buildings in selected site) em (only for buildings in selected site) active_plantypes plantype_groups (restricted) msds_data msds_chemical msds_constituent hazard_container_cat (restricted by hazard_container_cat.activity_id ='AbRiskMSDS') hazard_container_type bill_unit (restricted by bill_unit.bill_type_id IN ('MSDS - MASS', 'MSDS - VOLUME', 'MSDS - PRESSURE') afm_dwgs (restricted by date_con_svg_last_pub NOT NULL0 sync data tables: msds_location_sync download floor plans On Sync / Close Inventory: sync data tables: msds_location_sync download floor plans Documents (msds_data.doc) are downloaded on request by tapping Download Documents for a location level or by requesting a document display for a material location record.
Space Book	On download data icon tap: background data tables: afm_currencies afm_scmpref afm_activity_params (restricted to a list of values) afm_users (only current user) rm em dv dp rmcat rmtype rmuse rmstd active_plantypes plantype_groups site bl (SpaceBuilding store) fl (SpaceFloor store) afm_dwgs (restricted) download site drawings On tap Download Floor Plans button: background data table: active_plantypes download floor plans (restricted by location level from where the action was called) On Start Survey / Sync Survey / Complete Survey sync data tables: surveymob_sync surveyrm_sync On Add to Survey sync data tables: surveyrm_sync On Close Survey sync data tables: surveymob_sync surveyrm_sync download floor plans (restricted by survey's floor codes)
Space & Occupancy Survey	On download data icon tap: background data tables : afm_currencies afm_scmpref afm_activity_params (restricted to a list of values) afm_users (only current user) em dv dp rm rmcat rmtype rmuse rmstd emstd site bl (SpaceBuilding store) fl (SpaceFloor store) active_plantypes plantype_groups afm_dwgs (restricted) download site drawings On tap Download Floor Plans button: background data tables: active_plantypes download floor plans (restricted by location level from where the action was called) On Start Survey / Sync Survey / Close Survey /Add To Survey sync data tables: surveymob_sync surveyrm_sync em_sync rmpctmob_sync (if Workspace Transactions are enabled) download floor plans (restricted by survey's floor codes)
Workplace Services Portal	On app load: background data tables : afm_currencies afm_scmpref afm_activity_params (restricted to a list of values) afm_users (only current user) site (Site store) rm rmcat rmstd rmtype dv dp em cf active_plantypes probtype activitytype (restricted by activitytype.group_name = 'WORKSVC-MOB') afm_mobile_menu (restricted by afm_mobile_menu.group_name = 'WORKSVC-MOB' AND afm_mobile_menu.activity_id = 'AbWorkplacePortal') reserve (restricted by reserve.user_requested_by = <current_user>) reserve_rm rm_arrange_type activity_log (restricted by activity_log.activity_type = 'SERVICE DESK - HOTELING') rmpct (restricted by rmpct.status = '1') site (SpaceSite store) bl (SpaceBuilding store) fl (SpaceFloor store) resource_std em ( restricted to em.email like '@') afm_dwgs (restricted) sync data tables : activity_log_sync (restricted by activity_log_sync.activity_type IN ('SERVICE DESK - COPY SERVICE', 'SERVICE DESK - DEPARTMENT SPACE', 'SERVICE DESK - FURNITURE', 'SERVICE DESK - INDIVIDUAL MOVE', 'SERVICE DESK - MAINTENANCE') download site drawings On Sync Reservations: background data tables: reserve reserve_rm On Sync Hoteling: background data tables: activity_log (restricted by activity_log.activity_type = 'SERVICE DESK - HOTELING') rmpct(restricted by rmpct.status = '1') On Sync Maintenance / Move / Space / Furniture / Copy: Same downloads and syncs as for 'On app load' above
Solution Templates	On app load: background data tables: em bl fl rm eqstd surveymob_sync questions questionnaire afm_redlines (restricted by afm_redlines.origin = 'HTML5-based Floor Plan' AND afm_redlines.redline_type = 'Marker' AND afm_redlines.layer_name = 'MY_MARKER_TABLE-assets') bl (BuildingCode store) bl (SolutionBuilding store) afm_dwgs (restricted)
Maintenance	On app load: background data tables: afm_currencies afm_scmpref afm_activity_params (restricted to a list of values) afm_users (only current user) bl (MaintenanceBuilding store) fl rm causetyp eq probtype other_rs pt pd site em cf bl (Building store) pmp pr repairty active_plantypes cf_work_team work_team dv dp eqstd tl tr pt_store_loc pt_store_loc_pt afm_dwgs (restricted) ac On Sync: background data tables: all tables downloaded on app load are downloaded again on Sync if necessary sync data tables: wr_sync wrpt_sync wr_other_sync wrcf_sync wrtl_sync wrtr_sync docs_assigned_sync Site drawings and floor plan drawings are downloaded on request.
Compliance Surveys	On app load: No data tables used. Background data and sync tables used only when app syncs. On sync: background data tables Rooms (rm) Sites (site) Buildings (bl) Floors (fl) Compliance Locations (compliance_locations) Questionnaires (questionnaire_ext) Questions (question_ext) Questionnaire’s Questions (quest_question_ext) Answer Options (quest_answer_option_ext) sync tables Compliance Surveys (activity_log_sync) Answers (quest_answer_ext_sync)