What to know
An MFT contains all information (metadata) needed by the BioSense Platform to process data from a facility. Each MFT is site-specific. The MFT fields make sure data map correctly from facility to BioSense Platform and that data are easily identifiable when queried.
Resources
- Master Facility Table (MFT) Data Reference Guide This guide describes data elements and processing rules, provides SQL queries for locating data in facility and crosswalk tables, and summarizes information dropped when NSSP converted legacy data to the new data flow.
Frequent Questions
All site administrators can access their site's Master Facility Table (MFT). To grant access to others, site admins may update the user's Privilege Level in the AMC User Profile. There are two MFT user roles:
- MFT View-Only User who can access the MFT for that site and view entries but NOT make changes or
- MFT Edit User who can view and edit that site's MFT.
NSSP's onboarding team can also access MFTs to confirm requested updates and verify data entered by site admins and MFT Edit Users. Because the MFT user interface is the site's key to processing facility data, MFT access is restricted to just those users who may need to update, add, or review facility information.
Everyone wants the onboarding process to progress smoothly and be error free. By updating the Master Facility Table (MFT) regularly and keeping it current, you decrease the likelihood for discrepancies once the facility begins transmitting data to NSSP. Any discrepancies between what the site administrator enters into the MFT versus what the facility sends could raise issues. For example, if the site administrator entered a FacilityID_UUID into the MFT different from that submitted in the data, the mismatched identifiers will prevent incoming data from mapping accurately to the facility listed in the MFT. Worse yet, data will not process and will continuously route to the exceptions table until the issue is resolved. (Tip: This is a good reason to check Data Quality reports in WinSCP for staging exceptions data or the Data Quality Dashboard and SAS Data Quality [DQ] On Demand for production exceptions data.)
POSTED IN NSSP UPDATE, APRIL 2020.