Department of Labor Logo United States Department of Labor
Dot gov

The .gov means it's official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you're on a federal government site.

Https

The site is secure.
The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.

Bureau of Labor Statistics > Office of Survey Methods and Research > Publications > Browse Research Papers

Record Linkage Methodology in Longitudinal Database of Quarterly Census of Employment and Wages

Marek W. Kaminski and Vinod Kapani

Abstract

The Longitudinal Database of Quarterly Census of Employment and Wages (QCEW) links quarterly reports of employment and total wages of all nonfarm establishments covered by State Unemployment Insurance. QCEW uses two types of linkage: deterministic and probabilistic. Deterministic linkage is performed by SESA IDs - a combination of state FIPS code, Unemployment Insurance Number, and Reported Unit Number. The remaining establishments, those not linked by SESA IDs, are linked by a probabilistic method (weighted matching), based on the Fellegi and Sunter theory. This paper performs and evaluates both deterministic and weighted linkage. Recommendations for weighted linkage are given.