RC87A1 RECORD LAYOUT 1987 RETAIL TRADE: General Statistics for the U.S., States, Counties, Places and Metropolitan Areas -------------------------------------------------------------------------------- FIELD TYPE SIZE DESCRIPTION NAME -------------------------------------------------------------------------------- GEOTYPE C 1 Type of geography 1 United States 2 State 3 County 5 Place 6 Metropolitan area (MSA, CMSA, or PMSA) ST C 2 FIPS State code COUNTY C 3 FIPS county code PLACE C 5 FIPS place code CONSCITY C 1 Consolidated city code (NA) MSA C 4 MSA or CMSA code (9999=not in MSA) PMSA C 4 PMSA code (9999=not in PMSA) PART C 1 Part code (P=part place in county) TRADEKEY C 1 Trade area/SIC division code (R=Retail Trade) SICKEY C 4 Retail kind-of-business code, 1987 YR C 2 Reference year (87 only) ESTAB N 8 Number of establishments ESTABF C 1 Flag for ESTAB VALUE N 11 Sales ($1,000) VALUEF C 1 Flag for VALUE EMP N 9 Number of employees EMPF C 1 Flag for EMP PAY N 10 Annual payroll ($1,000) PAYF C 1 Flag for PAY PAY1Q N 10 First quarter payroll ($1,000) PAY1QF C 1 Flag for PAY1Q -------- File sequence: STxCOUNTYxPLACExSICKEY; MSAxPMSAxSICKEY