All Locations Spreadsheet

AllLocations_spreadsheet for testing.xlsx

Generic Clearance for Questionnaire Pretesting Research

All Locations Spreadsheet

OMB: 0607-0725

Document [xlsx]
Download: xlsx | pdf

Overview

Welcome
Data Dictionary
All Locations - Selected Items


Sheet 1: Welcome












Welcome - All Locations












2015 Report of Organization and/or Annual Survey of Manufactures








This spreadsheet allows the input of data using software external to Census Surveyor.






Import this data into Census Surveyor using the "Import from Spreadsheet" button.














This spreadsheet does not fulfill your reporting obligation.






You will need to enter additional data in either the Form or Workbook view for all form types,






or export the different form types and import using the "Import from Spreadsheet" button.














After completing items on all forms, submit your data to the Census Bureau using the






"Submit Responses" button.














The Data Dictionary (next tab) includes the Data Element Names that Census Surveyor uses to import data.






The Data Dictionary may be printed for convenience to outline the Data Element Names listed on the next tab.














Columns of the spreadsheet can be deleted or reordered, and the remaining data will import into Census Surveyor.






Do not modify the Data Element Names in the first row of the data tab.






Census Surveyor uses the Data Element Names to link the data from this spreadsheet.














Do not modify prelisted values for FORM_MAILED and RECORD_CFN.














It is recommended that you add locations prior to exporting to a spreadsheet.














To add locations after exporting:






Data for new locations should be entered into blank rows. It is important to enter a Form Number






(FORM_MAILED) of NC-99001(L) and unique Census File Number (RECORD_CFN) for each new location.






Use the following 10-character format for RECORD_CFN: ADD_000001, ADD_000002, ADD_000003, etc.






















For additional information:







Call: 1-800-838-2640, between 8:00 a.m. and 4:30 p.m., Eastern time, Monday through Friday.





















To add establishments to NC-99001(L) -






use Major Activity Code, ADD_MAJOR_ACT_CODE, from Item 5B:






01 - Agricultural production






02 - Agricultural services






03 - Minerals extraction/ore processing






04 - Mining services/oil and gas field services






05 - Utilities






06 - Construction






07 - Manufacturing






08 - Merchant wholesaler






09 - Commission merchant/broker/agent/electronic marketer (business to business)






10 - Manufacturers' sale branch/manufacturers' sales office






11 - Retail






12 - Transportation/public warehousing






13 - Information services/publishing/telecommunications






14 - Finance/insurance






15 - Real estate/renting/leasing






16 - Professional/scientific/technical service






17 - Waste management/remediation service/administrative/support service






18 - Educational service






19 - Health care






20 - Social assistance






21 - Arts/entertainment/recreation






22 - Accommodation/food service






23 - Corporate/subsidiary/regional/managing office






24 - Other































































































































































































































































































































































Sheet 2: Data Dictionary

Data Dictionary for All Locations




Row 1 - Data Element Name Row 2 - Data Element Description Row 3 - Data Element Characteristic
@RECORD_CFN *CFN (census file number) - Unique identifier used for exporting and importing data *Do not modify prelisted CFN
@RECORD_STORENUM *Store/Plant - Enter corrections to prelisted store/plant number *Maximum length is 12 characters
@RECORD_NAME1 Name 1 - Enter corrections to prelisted Name 1 Maximum length is 36 characters
@RECORD_NAME2 Name 2 - Enter corrections to prelisted Name 2 Maximum length is 36 characters
@ADDR_STREET Street - Enter corrections to prelisted street address Maximum length is 36 characters
@ADDR_CITY City - Enter corrections to prelisted city Maximum length is 20 characters
@ADDR_ST State - Enter corrections to prelisted state Use 2-letter state abbreviation
@ADDR_ZIP ZIP Code - Enter corrections to prelisted ZIP Code Use 5- or 9-digit ZIP Code
@EIN_NUM EIN (Employer Identification Number) - Enter corrections to prelisted EIN Enter 9-digit EIN
@PHYSLOC_ADDR Is this establishment's physical location the same as the mailing address (ADDR_STREET, ADDR_CITY, ADDR_ST, ADDR_ZIP)? 1=Yes; 2=No
@PHYSLOC_ADDR_STREET If PHYSLOC_ADDR is No - Enter the physical location number and street address Maximum length is 36 characters
@PHYSLOC_ADDR_CITY If PHYSLOC_ADDR is No - Enter the physical location city, town, village, etc. Maximum length is 20 characters
@PHYSLOC_ADDR_ST If PHYSLOC_ADDR is No - Enter the physical location state Use 2-letter state abbreviation
@PHYSLOC_ADDR_ZIP If PHYSLOC_ADDR is No - Enter the physical location ZIP Code Use 5- or 9-digit ZIP Code
@PHYSLOC_LGL Is this establishment physically located inside the legal boundaries of the city, town, village, etc.? 1=Yes; 2=No; 3=No legal boundaries; 4=Do not know
@PHYSLOC_MUNI In what type of municipality is this establishment physically located? 1=City, village, or borough; 2=Town or township; 3=Other; 4=Do not know
@OPSTAT Which best describes this establishment's operational status at the end of 2015? 1=In operation; 2=Temporarily inactive; 3=Ceased operation; 4=Sold/Leased to another operator; 5=Other or under construction
@OPSTAT_DATE Date - Enter date for ceased or sold/leased establishments Use MMDDYYYY format
@OPSTAT_NAME Name of new owner or operator - Enter new owner name for sold/leased establishments Maximum length is 36 characters
@OPSTAT_ADDR_STREET Mailing address - Enter new owner number and street (P.O. Box, etc.) address for sold/leased establishments Maximum length is 36 characters
@OPSTAT_ADDR_CITY City, town, village, etc. - Enter new owner city, town, village, etc. for sold/leased establishments Maximum length is 20 characters
@OPSTAT_ADDR_STATE State - Enter new owner state for sold/leased establishments Use 2-letter state abbreviation
@OPSTAT_ADDR_ZIP ZIP Code - Enter new owner ZIP Code for sold/leased establishments Use 5- or 9-digit ZIP Code
@ACTV_MIO Number of months in operation during 2015 Enter 0-12
@EMP_MAR12 Number of employees for pay period including March 12, 2015 Enter number - Enter '0' for None
@PAY_ANN 2015 Annual payroll before deductions (Exclude employer's cost for fringe benefits.) Report in thousands - Enter '0' for None
@PAY_QTR1 First quarter payroll before deductions (January-March, 2015) (Exclude employer's cost for fringe benefits.) Report in thousands - Enter '0' for None
@ADD_MAJOR_ACT_CODE NC-99001(L), Item 5B, column (c1): Code - Enter code from the Major Activity Codes list from the Welcome tab or Item 5B Enter 2-digit Major Activity Code from NC-99001(L), Item 5B

Sheet 3: All Locations - Selected Items

@FORM_MAILED @RECORD_CFN @RECORD_STORENUM @RECORD_NAME1 @RECORD_NAME2 @ADDR_STREET @ADDR_CITY @ADDR_ST @ADDR_ZIP @EIN_NUM @PHYSLOC_ADDR @PHYSLOC_ADDR_STREET @PHYSLOC_ADDR_CITY @PHYSLOC_ADDR_ST @PHYSLOC_ADDR_ZIP @PHYSLOC_LGL @PHYSLOC_MUNI @OPSTAT @OPSTAT_DATE @OPSTAT_NAME @OPSTAT_ADDR_STREET @OPSTAT_ADDR_CITY @OPSTAT_ADDR_STATE @OPSTAT_ADDR_ZIP @ACTV_MIO @EMP_MAR12 @PAY_ANN @PAY_QTR1 @ADD_MAJOR_ACT_CODE
*Form Number *CFN (census file number) - Unique identifier used for exporting and importing data *Store/Plant - Enter corrections to prelisted store/plant number Name 1 - Enter corrections to prelisted Name 1 Name 2 - Enter corrections to prelisted Name 2 Street - Enter corrections to prelisted street address City - Enter corrections to prelisted city State - Enter corrections to prelisted state ZIP Code - Enter corrections to prelisted ZIP Code EIN (Employer Identification Number) - Enter corrections to prelisted EIN Is this establishment's physical location the same as the mailing address (ADDR_STREET, ADDR_CITY, ADDR_ST, ADDR_ZIP)? If PHYSLOC_ADDR is No - Enter the physical location number and street address If PHYSLOC_ADDR is No - Enter the physical location city, town, village, etc. If PHYSLOC_ADDR is No - Enter the physical location state If PHYSLOC_ADDR is No - Enter the physical location ZIP Code Is this establishment physically located inside the legal boundaries of the city, town, village, etc.? In what type of municipality is this establishment physically located? Which best describes this establishment's operational status at the end of 2015? Date - Enter date for ceased or sold/leased establishments Name of new owner or operator - Enter new owner name for sold/leased establishments Mailing address - Enter new owner number and street (P.O. Box, etc.) address for sold/leased establishments City, town, village, etc. - Enter new owner city, town, village, etc. for sold/leased establishments State - Enter new owner state for sold/leased establishments ZIP Code - Enter new owner ZIP Code for sold/leased establishments Number of months in operation during 2015 Number of employees for pay period including March 12, 2015 2015 Annual payroll before deductions (Exclude employer's cost for fringe benefits.) First quarter payroll before deductions (January-March, 2015) (Exclude employer's cost for fringe benefits.) NC-99001(L), Item 5B, column (c1): Code - Enter code from the Major Activity Codes list from the Welcome tab or Item 5B
*Do not move column or modify prelisted form number *Do not modify prelisted CFN *Maximum length is 12 characters Maximum length is 36 characters Maximum length is 36 characters Maximum length is 36 characters Maximum length is 20 characters Use 2-letter state abbreviation Use 5- or 9-digit ZIP Code Enter 9-digit EIN 1=Yes; 2=No Maximum length is 36 characters Maximum length is 20 characters Use 2-letter state abbreviation Use 5- or 9-digit ZIP Code 1=Yes; 2=No; 3=No legal boundaries; 4=Do not know 1=City, village, or borough; 2=Town or township; 3=Other; 4=Do not know 1=In operation; 2=Temporarily inactive; 3=Ceased operation; 4=Sold/Leased to another operator; 5=Other or under construction Use MMDDYYYY format Maximum length is 36 characters Maximum length is 36 characters Maximum length is 20 characters Use 2-letter state abbreviation Use 5- or 9-digit ZIP Code Enter 0-12 Enter number - Enter '0' for None Report in thousands - Enter '0' for None Report in thousands - Enter '0' for None Enter 2-digit Major Activity Code from NC-99001(L), Item 5B
MA-10000(L) 7000012015 1 Test Example 1
Street Address 1 Milford MA 01757-1234 12-3456789
Street Address 9 Milford MA 01757-1234













NC-99001(L) 7000042015 4 Test Example 4
Street Address 4 Milford MA 01757-1234 12-3456789


















NC-99001(L) 7000052015 5 Test Example 5
Street Address 5 Akron OH 44312 12-3456789


















NC-99001(L) 7000062015 6 Test Example 6
Street Address 6 Culpepper VA 22701 12-3456789


















NC-99001(L) ADD_500003


























NC-99001(L) ADD_500004


























NC-99001(L) ADD_500005


























NC-99001(S) ADD_500006


























NC-99001(S) ADD_500007


























NC-99001(S) ADD_500008


























MA-10000(L) ADD_500001


























MA-10000(L) ADD_500002


























File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy