formatting
the source formatted weekly on mondays
what is opendata
what is 1
the frequency of which frozen tables are refreshed
what is daily
the value to push via API if attempting to null a value in CRM
what is #N/A
the vendor which receives an outbound feed from beghou daily
what is claritas
the column name of the source unique identifier in mdm source data
what is dpu_id
the name of the medpro unique identifier
what is medpro master id
the number of times a new frozen catalog is made per year
what is 4
the name of aveo's old CRM
what is OCE
the frequency with which SBC Refresh runs
what is weekly
the hco source with four different production formatting scripts
what is GPO
the required field if name is not populated
what is npi
the frozen table that has to be updated if a merge loser is tied to claritas
what is id_xref
the name of the catalog that stores the table tracking HCPs sent to/returned from MedPro, the sent token, and whether the HCP has been integrated to MDM or sent to Mainsail
what is mdm.queue
the method with which the aveo team receives the mediledger feed
what is email
the name of function called in formatting that renames columns and standardizes values like specialties
what is alignWithMDMNames
the number of segments received from medpro
what is 5
the frozen table which is filtered to only records flagged as primary upon seeding
what is account_to_address
the order of the three main codes in the HCO and HCP Main runs
what is ranking, attribute, final
the number of days it takes for a version to be archived automatically
the name of the .txt file written at the end of every formatting script
what is refreshed_in_mdm
the type of file received for high-priority updates like pdrp
what is proactive
the snowflake schema where frozen tables are stored
what is RPT
the most recently added MDM final table
what is AMA no contact
the state that Stacy and Chloe live in