master file


Also found in: Dictionary, Thesaurus, Medical, Legal, Financial, Acronyms.
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 ?
An international group having multiple Indian constituent entities may designate one constituent entity to file the Master File.
Stellar Biotechnologies chief pharmaceutical officer, Catherine Brisson, said, 'We are very pleased to have this master file submitted to CBER.
Positron Corporation (OTCBB:POSC) a molecular imaging healthcare company, has submitted a Drug Master File with the Food and Drug Administration for the production of Active Pharmaceutical Ingredient grade strontium-82, it was reported on August 22, 2012.
PharmaVigilant, an innovative solution provider in the clinical technology market, announced today that they have released I-Vault, the first commercially available Electronic Trial Master File System (ETMF) in the industry.
Insurers can use the United States Social Security Administration s Death Master File to identify deceased policyholders and pay out benefits.
In addition to an agreement with ING, California insurance commissioner also released a statement clearing MassMutual of any improper use of the Social Security Death Master File database.
M2 EQUITYBITES-August 24, 2012-Positron Corporation submits Drug Master File for production of strontium-82(C)2012 M2 COMMUNICATIONS http://www.
Providing labour for sweeping & desalting of the area Part-C Municipal Council Faridkot on outsource, contract basis for one year The list of area could be seen in master file.
Columbus, Ohio (Nationwide) has entered into a multi-million dollar settlement with the insurance departments of California, Florida, Illinois, New Hampshire, North Dakota, Pennsylvania and Ohio for its misuse of the Social Security Death Master File database (DMF).
Barco s Master File for its patented QAWeb Mobile methodology has been accepted by the US Food and Drug Administration, which allows healthcare developers and integrators to apply for FDA 510(k) clearance when integrating Barco s QA and calibration tool for mobile devices.
Ajinomoto is the only US amino acid facility that manufactures, packages, and inventories cGMP and Drug Master File (DMF) pharmaceutical grade amino acids, for the IV, pharmaceutical, food, and supplement industries.
CHICAGO -- Celsis International plc, a Chicago-based life science products and services company, today announced that the US Food and Drug Administration (FDA) has accepted a Celsis Drug Master File (DMF) for Celsis AKuScreen[TM].

Full browser ?