master file


Also found in: Dictionary, Thesaurus, Medical, Legal, Financial, Acronyms, Wikipedia.
Related to master file: transaction file

master file

[′mas·tər ′fīl]
(computer science)
A computer file containing relatively permanent information, usually updated periodically, such as subscriber records or payroll data other than time worked.
A computer file that is used as an authoritative source of data in carrying out a particular job on the computer.

master file

A collection of records pertaining to one of the main subjects of an information system, such as customers, employees, products and vendors. Master files contain descriptive data, such as name and address, as well as summary information, such as amount due and year-to-date sales. Contrast with transaction file. See master data management.

Although there can be many more, following are the typical fields in a business master record. The "key" fields are generally indexed for matching against the transaction records as well as fast retrieval for queries. The account number is usually the primary key, but name may also be primary. There can be secondary indexes; for example, in an inverted file structure, almost all the fields could be indexed. See transaction file for examples of transaction records.

EMPLOYEE MASTER RECORD
  key  Employee account number
  key  Name (last)
       Name (first)
       Address, city, state, zip
       Hire date
       Birth date
       Title
       Job class
       Pay rate
       Year-to-date gross pay

       CUSTOMER MASTER RECORD
  key  Customer account number
  key  Name
       Bill-to address, city, state, zip
       Ship-to address, city, state, zip
       Credit limit
       Date of first order
       Sales-to-date
       Balance due

       VENDOR MASTER RECORD
  key  Vendor account number
  key  Name
       Address, city, state, zip
       Terms
       Quality rating
       Shipping method

       PRODUCT MASTER RECORD
  key  Product number
  key  Name
       Description
       Quantity on hand
       Location
       Primary vendor
       Secondary vendor
References in periodicals archive ?
Report on Trial Master Files (TMF) Shows Growing Software Adoption, but Many Pharmaceutical Companies are Lagging
BioLife Chairman and Chief Executive Mike Rice remarked, "This Master File submission for HypoThermosol completes our stated corporate objective of offering the easiest to use biopreservation media products with the best regulatory footprint in the industry.
With this data and our FDA Master File, we are striving to raise the regulatory standards for biopreservation media products and are committed, through our proprietary products, to enabling our customers' successful development and commercialization of new cell and tissue-based products and therapies.
With the addition of S&P's CUSIP Master File connection to its product line, GoldenSource continues to offer its clients leading industry data sources through preconfigured interfaces," said Tom Stock, GoldenSource Senior Vice President, Product Management.
Of the 40 cases, 10 were instances in which SSA's Death Master File had incorrectly listed as deceased the individual on whom a prescription was dispensed and 30 resulted from Department of Defense (DOD) data entry errors.
Materials included under the policy have been assessed for biocompatibility, are covered by an FDA Drug or Device Master File, and are subject to formula lock and a stringent change management process.
Health Canada's Natural Health Products Directorate has accepted the Master File submitted by ADM, Decatur, IL, for its BeneFlax flax lignan concentrate.
ScinoPharm is the first filer of Drug Master File (DMF) for irinotecan HCI with the US Food and Drug Administration (FDA).
announced today that it has provided a Master File on the AutoXpress System to the FDA.
Our new master file is the most extensive list of its kind available anywhere," said Pauline Murphy, 1 Stop Data founder and managing director.
the technology leader in Windows NT System Resource Management, today introduced its new PerfectDisk 2000 defragmenter, the only product that can defragment every type of file on Windows NT, Windows 2000, Windows 95/98 system disks, including the Master File Table (MFT), paging files, and directories.

Full browser ?