Data Element Extract Specific Data

SAM Data Element List Column Order

DUNS 1

DUNS+4 2

CAGE CODE 3

DODAAC 4
SAM EXTRACT CODE 5

PURPOSE OF REGISTRATION 6

INITIAL REGISTRATION DATE 7

EXPIRATION DATE 8

LAST UPDATE DATE 9

ACTIVATION DATE 10

LEGAL BUSINESS NAME 11

DBA NAME 12
COMPANY DIVISION 13

DIVISION NUMBER 14

PHYSICAL ADDRESS LINE 1 15

PHYSICAL ADDRESS LINE 2 16

PHYSICAL ADDRESS CITY 17

PHYSICAL ADDRESS PROVINCE OR STATE 18

PHYSICAL ADDRESS ZIP/POSTAL CODE 19

PHYSICAL ADDRESS ZIP CODE +4 20

PHYSICAL ADDRESS COUNTRY CODE 21

ENTITY CONGRESSIONAL DISTRICT 22

BUSINESS START DATE 23

FISCAL YEAR END CLOSE DATE 24

CORPORATE URL 25

ENTITY STRUCTURE 26

STATE OF INCORPORATION 27

COUNTRY OF INCORPORATION 28

BUSINESS TYPE COUNTER 29

BUS TYPE STRING 30

PRIMARY NAICS 31
NAICS CODE COUNTER 32

NAICS CODE STRING 33

PSC CODE COUNTER 34

PSC CODE STRING 35

CREDIT CARD USAGE 36

CORRESPONDENCE FLAG 37

MAILING ADDRESS LINE 1 38

MAILING ADDRESS LINE 2 39

MAILING ADDRESS CITY 40

MAILING ADDRESS ZIP/POSTAL CODE 41

MAILING ADDRESS ZIP CODE +4 42

MAILING ADDRESS COUNTRY 43

MAILING ADDRESS STATE OR PROVINCE 44

GOVT BUS POC FIRST NAME 45

GOVT BUS POC MIDDLE INITIAL 46

GOVT BUS POC LAST NAME 47

GOVT BUS POC TITLE 48

GOVT BUS POC ST ADD 1 49

GOVT BUS POC ST ADD 2 50

GOVT BUS POC CITY 51

GOVT BUS POC ZIP/POSTAL CODE 52

GOVT BUS POC ZIP CODE +4 53

GOVT BUS POC COUNTRY CODE 54

GOVT BUS POC STATE OR PROVINCE 55

ALT GOVT BUS POC FIRST NAME 61

ALT GOVT BUS POC MIDDLE INITIAL 62

ALT GOVT BUS POC LAST NAME 63

ALT GOVT BUS POC TITLE 64

ALT GOVT BUS POC ST ADD 1 65

ALT GOVT BUS POC ST ADD 2 66

ALT GOVT BUS POC CITY 67

ALT GOVT BUS POC ZIP/POSTAL CODE 68

ALT GOVT BUS POC ZIP CODE +4 69

ALT GOVT BUS POC COUNTRY CODE 70

ALT GOVT BUS POC STATE OR PROVINCE 71

PAST PERF POC POC FIRST NAME 77

PAST PERF POC POC MIDDLE INITIAL 78

PAST PERF POC POC LAST NAME 79

PAST PERF POC POC TITLE 80

PAST PERF POC ST ADD 1 81

PAST PERF POC ST ADD 2 82

PAST PERF POC CITY 83

PAST PERF POC ZIP/POSTAL CODE 84

PAST PERF POC ZIP CODE +4 85

PAST PERF POC COUNTRY CODE 86

PAST PERF POC STATE OR PROVINCE 87

ALT PAST PERF POC FIRST NAME 93

ALT PAST PERF POC MIDDLE INITIAL 94

ALT PAST PERF POC LAST NAME 95

ALT PAST PERF POC TITLE 96

ALT PAST PERF POC ST ADD 1 97

ALT PAST PERF POC ST ADD 2 98

ALT PAST PERF POC CITY 99

ALT PAST PERF POC ZIP/POSTAL CODE 100

ALT PAST PERF POC ZIP CODE +4 101

ALT PAST PERF POC COUNTRY CODE 102

ALT PAST PERF POC STATE OR PROVINCE 103

ELEC BUS POC FIRST NAME 109

ELEC BUS POC MIDDLE INITIAL 110

ELEC BUS POC LAST NAME 111

ELEC BUS POC TITLE 112

ELEC BUS POC ST ADD 1 113

ELEC BUS POC ST ADD 2 114

ELEC BUS POC CITY 115

ELEC BUS POC ZIP/POSTAL CODE 116

ELEC BUS POC ZIP CODE +4 117

ELEC BUS POC COUNTRY CODE 118

ELEC BUS POC STATE OR PROVINCE 119

ALT ELEC POC BUS POC FIRST NAME 125

ALT ELEC POC BUS POC MIDDLE INITIAL 126

ALT ELEC POC BUS POC LAST NAME 127

ALT ELEC POC BUS POC TITLE 128

ALT ELEC POC BUS ST ADD 1 129

ALT ELEC POC BUS ST ADD 2 130

ALT ELEC POC BUS CITY 131

ALT ELEC POC BUS ZIP/POSTAL CODE 132

ALT ELEC POC BUS ZIP CODE +4 133

ALT ELEC POC BUS COUNTRY CODE 134

ALT ELEC POC BUS STATE OR PROVINCE 135

NAICS EXCEPTION COUNTER 141

NAICS EXCEPTION STRING 142

DEBT SUBJECT TO OFFSET FLAG 143

EXCLUSION STATUS FLAG 144

SBA BUSINESS TYPES COUNTER 145

SBA BUSINESS TYPES STRING 146

NO PUBLIC DISPLAY FLAG 147

DISASTER RESPONSE COUNTER 148

DISASTER RESPONSE STRING 149

END OF RECORD INDICATOR 150

 SAM D

Max
Datatype Data Format
Length
STRING Numeric 9

STRING Numeric 4

STRING STRING 5

STRING STRING 9
STRING STRING 1

STRING STRING 2

STRING YYYYMMDD 8

STRING YYYYMMDD 8

STRING YYYYMMDD 8

STRING YYYYMMDD 8

STRING STRING 120

STRING STRING 120
STRING STRING 60

STRING STRING 10

STRING STRING 150

STRING STRING 150

STRING STRING 40

STRING STRING 55

STRING STRING 50

STRING Numeric 4

STRING STRING 3

STRING Numeric 10

STRING YYYYMMDD 8

STRING MMDD 4

STRING STRING 200

STRING STRING 2

STRING STRING 2

STRING STRING 3

STRING Numeric 4

STRING ~ Separated 220

STRING STRING 6
STRING Numeric 4

STRING ~ Separated 12000

STRING Numeric 4
STRING ~ Separated 2500

STRING Y or N 1
STRING M, F, or E 1

STRING STRING 150

STRING STRING 150

STRING STRING 40

STRING STRING 50

STRING Numeric 4

STRING STRING 3

STRING STRING 55

STRING STRING 65

STRING STRING 3

STRING STRING 65

STRING STRING 50

STRING STRING 150

STRING STRING 150

STRING STRING 40

STRING STRING 50

STRING Numeric 4

STRING STRING 3

STRING STRING 55

STRING STRING 65

STRING STRING 3

STRING STRING 65

STRING STRING 50
STRING STRING 150

STRING STRING 150

STRING STRING 40

STRING STRING 50

STRING Numeric 4

STRING STRING 3

STRING STRING 55

STRING STRING 65

STRING STRING 3

STRING STRING 65

STRING STRING 50

STRING STRING 150

STRING STRING 150

STRING STRING 40

STRING STRING 50

STRING Numeric 4

STRING STRING 3

STRING STRING 55

STRING STRING 65

STRING STRING 3

STRING STRING 65

STRING STRING 50

STRING STRING 150

STRING STRING 150

STRING STRING 40

STRING STRING 50
STRING Numeric 4

STRING STRING 3

STRING STRING 55

STRING STRING 65

STRING STRING 3

STRING STRING 65

STRING STRING 50

STRING STRING 150

STRING STRING 150

STRING STRING 40

STRING STRING 50

STRING Numeric 4

STRING STRING 3

STRING STRING 55

STRING STRING 65

STRING STRING 3

STRING STRING 65

STRING STRING 50

STRING STRING 150

STRING STRING 150

STRING STRING 40

STRING STRING 50

STRING Numeric 4

STRING STRING 3

STRING STRING 55

STRING Numeric 4
STRING ~ Separated 1100

STRING Y, N, Null 1

STRING D or Null 1

STRING Numeric 4

STRING ~ Separated 125

STRING NPDY or null 4

STRING Numeric 4

STRING ~ Separated 75

STRING STRING 4
 SAM DATA ELEMENT LIST
Data Element Details
Definition
See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

Single character code that defines the status of the record being
sent in the extract. The monthly file contains the complete record
whether active or expired. For the daily files, the SAM Extract
Code further specifies which data elements are sent for the
record.

See SAM Functional Data Dictionary

The date the initial entity registration was activated either in SAM
or its predecessor, CCR. This date does not change.

The date this current registration will expire or has already

expired. This date is 365 days after the user submitted the
registration.

The date this registration was last updated. This can change
while the Activation Date remains the same for many reasons,
such as POC changes, reference data changes, or SAM
Technical Team database changes.

The date this registration record was made active. This can differ
from the date that the registration was submitted due to the time it
takes for TIN Validation and CAGE Code Assignment/Validation.

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary
See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

This is part of the entity's Physical Address. See SAM Functional

Data Dictionary for more information.
This is part of the entity's Physical Address. See SAM Functional
Data Dictionary for more information.
This is part of the entity's Physical Address. See SAM Functional
Data Dictionary for more information.
This is part of the entity's Physical Address. See SAM Functional
Data Dictionary for more information.
This is part of the entity's Physical Address. See SAM Functional
Data Dictionary for more information.
This is part of the entity's Physical Address. See SAM Functional
Data Dictionary for more information.
This is part of the entity's Physical Address. See SAM Functional
Data Dictionary for more information.
This is part of the entity's Physical Address. See SAM Functional
Data Dictionary for more information.
See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

Four digit identifier that provides the number of business types to

be provided in the business type String.
Tilde (~) delimited string that includes all of the entity's business
type information. For more information on the business types,
See the STRING Clarification TAB
See SAM Functional Data Dictionary
Four digit identifier that provides the number of NAICS Codes to
be provided in the NAICS Code String.
Tilde (~) delimited string that includes all of the entity's NAICS
information. For more information on the NAICS Code String,
See the STRING Clarification TAB
Four digit identifier that provides the number of PSC Codes to be
provided in the PSC Code String.
Tilde (~) delimited string that includes all of the entity's PSC
information. For more information on the PSC Code String, See
the STRING Clarification TAB
See SAM Functional Data Dictionary
See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

See SAM Functional Data Dictionary

Four digit identifier that provides the number of NAICS

Exceptions to be provided in the NAICS Exception String.
Tilde (~) delimited string that includes exception information for
any NAICS Codes that the user has selected that has exceptions.
For more information on the NAICS Exception String, See the
STRING Clarification TAB

See SAM Functional Data Dictionary

This flag indicates whether the entity represented by this DUNS

Number has an active exclusion record. If this flag is set to “D”,
this will indicate that the registrant has an exclusion record. A
null value indicates that this registrant's DUNS Number does not
have an active exclusion record.

Four digit identifier that provides the number of SBA Business

Types to be provided in the SBA Business Types String.
Tilde (~) delimited string that includes SBA business type and
expiration information as provided to SAM by SBA. For more
information on the SBA Business Types String, See the STRING
Clarification TAB

See SAM Functional Data Dictionary

Four digit identifier that provides the number of Disaster

Response Types to be provided in the Disaster Response String.

Tilde (~) and caret (^) delimited string that includes Disaster
Response data as collected in the assertions page of the SAM
Registration. For more information on the Disaster Response
String, See the STRING Clarification TAB
Identifier that serves to demarcate the end of each individual
record in the extract file.
SAM DATA ELEMENT LIST
Data Element Details
Enumeration Mandatory
Mandatory (All Awards/Federal
Assistance)
Optional

Mandatory (All Awards/Federal

Assistance)
Optional (IGT Only)
Monthly File: Mandatory
A - Active - Send the Complete Record.
E - Expired - Send the Complete Record.

Daily File:
1 - Deleted/Deactivated Record - Send DUNS, DUNS+4, CAGE Code,
DODAAC, SAM Extract Code, Purpose of Registration
2 - New Active Record - Send the Complete Record.
3 - Updated Active Record - Send the Complete Record.
4 - Expired Record - DUNS, DUNS+4, CAGE Code, DODAAC, SAM
Extract Code, Purpose of Registration

Z1 - Federal Assistance Awards Mandatory

Z2 - All Awards
Z3 - IGT-Only
Z4 - Federal Assistance Awards & IGT
Z5 - All Awards & IGT

Mandatory

Mandatory

Mandatory

Mandatory

Mandatory
Optional
 Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory

Optional

Mandatory

Optional

Optional

Optional

Mandatory

Optional

Mandatory (All Awards/Federal

Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
2J - Sole Proprietorship Mandatory
2K - Partnership or Limited Liability Partnership
2L - Corporate Entity (Not Tax Exempt)
8H - Corporate Entity (Tax Exempt)
2A - U.S. Government Entity
CY - Country - Foreign Government
X6 - International Organization
ZZ - Other

Optional (All Awards/Federal

Assistance)
Mandatory (All Awards/Federal
Assistance)
Mandatory

See STRING Clarification Tab Mandatory

Mandatory (All Awards)

Mandatory

See STRING Clarification Tab Mandatory (All Awards)

Mandatory
See STRING Clarification Tab Optional (All Awards)

Optional
M - US Mail Optional (All Awards/Federal
F - FAX Assistance)
E - Email
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Optional (All Awards/Federal
Assistance)
Mandatory
See STRING Clarification Tab Optional (All Awards)

Y - The entity has delinquent debt subject to offset. Optional

N - The entity does not have delinquent debt subject to offset.
Null - SAM has not received information from the Treasury Offset
Program (TOP) for this entity, or, this entity does not fall under the TOP.

Optional

Mandatory

See STRING Clarification Tab Optional (All Awards/Federal

Assistance)

NPDY - User did not authorize their public registration data to be Optional (All Awards/Federal
included in SAM Public Search results. Assistance)
Null Value - User authorized their public registration data to be included
in SAM Public Search results.
Mandatory

See STRING Clarification Tab Optional (All Awards)

Mandatory
 Substitution for Mandatory Sample Values
006213111

Mandatory to enter DUNS+4 if the DUNS 1111

has multiple bank accounts.
1E5G9

Mandatory if DoD entity DODF2K3AJ

A

Z2

20020409

20131021

20020409

20131021

PIEDMONT VAN LANES INC

U.S. BANK GOVERNMENT SERVICES
 STOKO SKIN CARE

8003340242

801 W YOUNG AVE

214 TRYON ST, 27TH FLR

MINNEAPOLIS

Mandatory if Country is USA or CAN MN

Mandatory if Country is USA 32920

Populated, when available, if Country is 4307

USA
USA

Mandatory if Country is USA 10

19800301

1231

http://www.usbank.com

2L

Mandatory if "Country of Incorporation" is MN

USA
USA

0008

If Counter is greater than "0000" string is 23~27~2X~8E~8W~A2~FR~HQ~LJ~VW

mandatory

543321
0005

If Counter is greater than "0000" string is 333611Y~333612N~333613Y~334513Y~334519Y~541330Y~5

mandatory

0004
If Counter is greater than "0000" string is Y159~Y161~Y162~Y163~Y179~Y222~Z200~Z300
mandatory

Y
M

4080 MALLARD DR

18TH Floor

WASHINGTON

Mandatory if Country is USA 20036

5422

USA

Mandatory if Country is USA or CAN DC

Sam

Merica

Mr

123 Main Street

Floor 5

Arlington

Mandatory if Country is USA 99999

0001

USA

Mandatory if Country is USA VA

Sam

Merica

Mr
 123 Main Street

Floor 5

Arlington

Mandatory if Country is USA 99999

0001

USA

Mandatory if Country is USA or CAN VA

Sam

Merica

Mr

123 Main Street

Floor 5

Arlington

Mandatory if Country is USA 99999

0001

USA

Mandatory if Country is USA or CAN VA

Sam

Merica

Mr

123 Main Street

Floor 5

Arlington

Mandatory if Country is USA 99999

 0001

USA

Mandatory if Country is USA or CAN VA

Sam

Merica

Mr

123 Main Street

Floor 5

Arlington

Mandatory if Country is USA 99999

0001

USA

Mandatory if Country is USA or CAN VA

Sam

Merica

Mr

123 Main Street

Floor 5

Arlington

Mandatory if Country is USA 99999

0001

USA

Mandatory if Country is USA or CAN VA

0003
If Counter is greater than "0000" string is 237990Y ~541330Y ~541712Y
mandatory

Only applies to entities which provide a Y

Taxpayer Identification Number (TIN)
during registration.

0001

If Counter is greater than "0000" string is A620191108~XX20191108

mandatory

Mandatory to be present if the entity has NPDY

opted out of public search.

0003

If Counter is greater than "0000" string is CTYFL051~CTYFL085~CTYFL099~MSA2700~MSA2710~MSA

mandatory

!end
 Sensitivity
Sensitivity Sensitivity
Public
Level Level
Public 1
X
Public 1
X
Public 1
X
Public 1 X
Public 1

Public 1

Public 1
X

Public 1

Public 1

Public 1

Public 1 X
Public 1 X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1

Public 1
X
Public 1
X
Public 1
X
Public 1
X

Public 1 X
Public 1
X
Public 1
X

Public 1
X
Public 1
X

Public 1 X
Public 1
X

Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1
X
Public 1

Public 1

Public 1

Public 1
X
Public 1

Public 1
X

Public 1
X

Public 1
X

Public 1
X
SAM Numerics Code String
CODE_TYPE Sequence Number Description
LS Local Size numbers
LS 1 Local Avg. Number of Employees (max. 999,999)
LS 2 Local Avg. Annual Revenue (max. 999,999,999,999)
LS 3 Not Used
LS 4 Not Used
BK SBA NAICS Banking Size Addl data
BK 1 Total Assets from 4th qtr, preceding year
BK 2 Not Used
BK 3 Not Used
BK 4 Not Used
PG SBA NAICS Power Gen. Addl data
PG 1 Total MWH, preceding fiscal year, all affiliates
PG 2 Not Used
PG 3 Not Used
PG 4 Not Used
PT SBA NAICS Petroleum Addl data
PT 1 Bbl/day, Oper. Atmos. Crude Oil Distil. capacity
PT 2 Not Used
PT 3 Not Used
PT 4 Not Used
BL Bonding Levels for Disaster Relief Registry
BL 1 Construction Bonding Level, Per Contract (dollars)
BL 2 Construction Bonding Level, Aggregate (dollars)
BL 3 Service Bonding Level, Per Contract (dollars)
BL 4 Service Bonding Level, Aggregate (dollars)

SAM Disaster Response String

Type Code Type Description
ANY Any area
STA State
CTY County
MSA Metropolitan Service
Area
Bus Type String
Business
Business Type Name
Type Code
U.S Federal
2R Government

2F U.S. State Government

12 U.S. Local Government

3I Tribal Government
CY Foreign Government
AbilityOne Non Profit
A7 Agency
20 Foreign Owned
Small Agricultural
1D Cooperative
Limited Liability
LJ Company
Subchapter S
XS Corporation

MF Manufacturer of Goods

2X For Profit Organization

A8 Non-Profit Organization
Other Not For Profit
2U Organization
 Community
Development
Corporation Owned
HK Firm

A3 Labor Surplus Area Firm

Veteran Owned
A5 Business
Service Disabled
Veteran Owned
QF Business
Woman Owned
A2 Business
Minority Owned
23 Business
Asian-Pacific American
FR Owned
Subcontinent Asian
(Asian-Indian)
QZ American Owned

OY Black American Owned

Hispanic American
PI Owned
Native American
NB Owned
Woman Owned Small
8W Business

Self Certified Small

27 Disadvantaged Business

Economically
Disadvantaged Women
8E Small Owned Business
Joint Venture Women
8C Owned Small Business

Joint Venture
Economically
Disadvantaged Women
8D Small Owned Business
NG Federal Agency
 Federally Funded
Research and
QW Development Center
C8 City
C7 County
ZR Inter-municipal
Local Government
MG Owned
C6 Municipality
H6 School District
TW Transit Authority
Council of
UD Governments
Housing Authorities
8B Public/Tribal
86 Interstate Entity
KM Planning Commission
T4 Port Authority
Community
Development
H2 Corporation
6D Domestic Shelter
M8 Educational Institution
1862 Land Grant
G6 College
1890 Land Grant
G7 College
1994 Land Grant
G8 College
Historically Black
HB College or University
1A Minority Institution
Private University or
1R College
ZW School of Forestry
Hispanic Servicing
GW Institution
State Controlled
Institution of Higher
OH Learning
HS Tribal College
QU Veterinary College
Alaskan Native
G3 Servicing Institution
 Native Hawaiian
G5 Servicing Institution
BZ Foundation
80 Hospital
FY Veterinary Hospital
HQ DOT Certified DBE
Alaskan Native
Corporation Owned
05 Firm
American Indian
OW Owned
Indian Tribe (Federally
XY Recognized)
Native Hawaiian
Organization Owned
8U Firm
1B Tribally Owned Firm
FO Township
TR Airport Authority
Other Than One of the
G9 Proceeding
V2 ** Grants ** Business Type Codes V2 and VW are no longer active in SAM.
VW ** Contracts and Grants These are legacy business type codes which map to SAM Purpose of Regi

NAICS Code String

NAICS CODE; Repeat X times to correspond with counter. The letter next to the NAICS code is the
Please note: The following NAICS codes do not have any size standards with SBA and therefore th
small business status associated with the NAICS codes below. These NAICS codes will be sent wit
Y/N/E answer:

112130, 233110, 233210, 233220, 233310, 233320, 234110, 234120, 234910, 234920, 234930, 23
235410, 235420, 235430, 235510, 235520, 235610, 235710, 235810, 235910, 235920, 235930, 23
421110, 421120, 421130, 421140, 421210, 421220, 421310, 421320, 421330, 421390, 421410, 42
421460, 421490, 421510, 421520, 421610, 421620, 421690, 421710, 421720, 421730, 421740, 42
 Breakdown of the string and example below:

"… ~237990N~541340N~ …"

Position1 = NAICS Code == "237990" , "541340"

Position2 = Small Business Indication == "N" , "N"

PSC Code String

PSC CODE; Repeat X times to correspond with counter.

Breakdown of the string and example below:

"… ~Y159~Y161~Y162~Y163~Y179~Y222~Z200~Z300~ …"

Position1 = PSC Code == "Y159", "Y161", "Y162", "Y163", "Y179", "Y222", "Z200", "Z300"

NAICS Exception String

NAICS Code Exception # NAICS Exception Description

115310 1 General Size Standard for Support Activities for

Forestry
115310 2 Exception for Forest Fire Suppression
115310 3 Exception for Fuels Management Services
237990 1 General Size Standard for Other Heavy and Civil
Engineering Construction
237990 2 Exception for Dredging and Surface Cleanup
Activities
238990 1 General Size Standard for All Other Speciality Trade
Contractors
238990 2 Exception for Building and Property Speciality Trade
Services
488510 1 General Size Standard for Freight Transportation
Arrangement
488510 2 Exception for Non‑Vessel Owning Common Carriers
and Household Goods Forwarders
531190 1 General Size Standard for Lessors of Other Real
Estate Property
531190 2 Exception for Leasing of Building Space to Federal
Government by Owners

541330 1 General Size Standard for Engineering Services

541330 2 Exception for Military and Aerospace Equipment
and Military Weapons
541330 3 Exception for Contracts and Subcontracts for
Engineering Services Awarded Under the National
Energy Policy Act of 1992
541330 4 Exception for Marine Engineering and Naval
Architecture
541519 1 General Size Standard for Other Computer Related
Services
541519 2 Exception for Information Technology Value Added
Resellers
541712 1 General Size Standard for Research and
Development in the Physical, Engineering, and Life
Sciences (except Biotechnology)
541712 2 Exception for Aircraft Engine and Engine Parts
541712 3 Exception for Other Aircraft Parts and Auxiliary
Equipment
541712 4 Exception for Guided Missiles and Space Vehicles,
Their Propulsion Units and Propulsion Parts
562910 1 General Size Standard for Remediation Services
562910 2 Exception for Environmental Remediation Services

611519 1 General Size Standard for Other Technical and

Trade Schools
611519 2 Exception for Job Corps Centers

SBA Business Types String

Business
Business Type Name
Type Code
A6 SBA Certified 8A
Program Participant
JT SBA Certified 8A Joint
Venture
XX SBA Certified Hub Zone
Firm

Proceedings String
The Proceedings string is made up of one or more proceedings entries. Each unique entry is separa

Position1 = Instrument Number == "DEAC2701RV39484DN14136"

Position2 = Proceeding Date (YYYYMMDD) == “20080213"
Position3 = Instrument ID == "U.S.Federal issued contract"
Position4 = State == "WA", "VA", "DC"
Position5 = Proceeding Type == “Administrative”, “Civil”, Criminal”
Position6 = Disposition Description == “Conviction/Finding of fault”
Position7 = Proceeding Description == “The DOE found the accused guilty.”

Breakdown of the string and example below:

DEAC2701RV39484DN14136^20080213^U.S.Federal issued contract^WA^Administrative^Convictio
Instrument Number = DEAC2701RV39484DN14136
Proceeding Date = 20080213
Instrument ID = U.S.Federal issued contract
State = WA
Proceeding Type = Administrative
Disposition Description = Conviction/Finding of fault
 Proceeding Description = THE DOE OFFICE OF HEARING AND APPEALS DETERMINED THAT C

Executive Compensation String

The Executive Compensation string is made up of one or more executive compensation entries. Ea

Position1 = Executive Name == "Jane Doe"

Position2 = Executive Title == “CEO", “President”, “VP”
Position3 = Executive Compensation == "12", “120000”, “5000000”

Breakdown of the example Executive Compensation string portion and sample below:
“JANIS JONES^PRESIDENT^4000000~ROBERT MACKLIN^VP^3000000~JACK PHILLIPS^CEO^2
JANIS JONES = executive name
PRESIDENT = executive title
4000000 = compensation
ROBERT MACKLIN = executive name
VP = executive title
3000000 = compensation
JACH PHILLIPS = executive name
CEO = executive title
2000000 = compensation
BARBARA BAXTER = executive name
CFO = executive title
1000000 = compensation
SEAN MCMILLEN = executive name
PEON = executive title
300000 = compensation
 *SAM Numerics explanation:
SAM Numerics are various SAM values that are further defined as noted below.

The first 2 positions of SAM Numerics is a numeric identification code, followed by a set of '^' delimited

SAM NUMERICS CODE STRING: Holds X related 'Metrics' groups.

Breakdown of the string and example below:

". . . ~BL^30000000^15000000^30000000^15000000~LS^42^5000000^0^0~PG^1^0^0^0~ . . ."

Position1 = Code Type == "BL" , "LS", "PG"

Position2 = Value For Sequence #1 == "30000000" , "42", "1"
Position3 = Value For Sequence #2 == "15000000" , "42", "0"
Position4 = Value For Sequence # == "30000000" , "42", "0"
Position4 = Value For Sequence #1 == "30000000" , "42", "0"

LS1 = Local Avg. Number of Employees

1239 = Location Employees Value
BK1 = Total Assets from 4th qtr, preceding year
220000 = Total Assets Value

*SAM Disaster Response explanation:

SAM Disaster Response contains various SAM values that are further defined as noted below.

The first three positions of a Disaster Response represent an area serviced code, followed by an
area code. State area codes are two positions, County area codes are five positions and
Metropolitan Service Area area codes are four positions. An area serviced code of "ANY" will not
be followed by an area code.
Breakdown of the string and example below:

"CTYFL051~CTYFL085~CTYFL099~MSA2700~MSA2710~MSA8960~STAFL"

Position1 = Type Code == "CTY" , "CTY", "CTY", "MSA" , "MSA", "MSA", "STA"
Position2 = Area Code == "FL051" , "FL085" , "FL099", "2700", "2710", "8960", "FL"

CTY = County code

FL051 = Pasco
FL085 = Sarasota
FL099 = Fairfield
MSA = Metropolitan Service Area code
2700 = Fort Myers-Cape Coral, FL
2710 = Fort Pierce-Port Stlucie, FL
8960 = West Palm Beach-Boca Raton, FL
STA = State code
FL = Florida (Per STATE_List.csv)

Breakdown of the string and example below:

". . . ~8W~A7~A8~. . ."

Position1 = Business Type Code == "8W" , "A7" , "A8"

onger active in SAM.
map to SAM Purpose of Registration Codes

next to the NAICS code is the Small Business indicator (Y/N/E).

rds with SBA and therefore there will be no Y/N/E answer for the
e NAICS codes will be sent with a blank space " " in place of the

234910, 234920, 234930, 234990, 235110, 235210, 235310,

235910, 235920, 235930, 235940, 235950, 235990, 339111,
421330, 421390, 421410, 421420, 421430, 421440, 421450,
421720, 421730, 421740, 421810, 421820, 421830, 421840,
222", "Z200", "Z300"

Size standard in
Size Standard in
number of
dollars
employees

$7,500,000.00

$19,000,000.00
$19,000,000.00
$36,500,000.00

$27,500,000.00

$15,000,000.00

$15,000,000.00

$15,000,000.00

$27,500,000.00

$27,500,000.00

$38,500,000.00

$15,000,000.00
$38,500,000.00

$38,500,000.00

$38,500,000.00

$27,500,000.00

150

1,000

1,500
1,250

1,250

$20,500,000.00
 750

$15,000,000.00

$38,500,000.00

SBA Certification String: Holds X program participation and expiration dates

The first 2 positions of SBA Certifications is an SBA Business Code followed by an expiration date

in YYYYMMDD format.

Breakdown of the string and example below:

". . . ~A620110101~XX20110102~. . ."

Position1 = Business Type Code == "A6" , "XX"

Position2 = SBA Cert Expiration Date == "20110101" , "20110102"

s. Each unique entry is separated by a ~ (tilde) with the unique identifiers (instrument number, proceeding date) within the proceeding itself

t^WA^Administrative^Conviction/Finding of fault^THE DOE OFFICE OF HEARING AND APPEALS DETERMINED THAT COMPANY ABC
EALS DETERMINED THAT COMPANY ABC HAD NOT MET ITS BURDEN UNDER 10 CFR PART 708 TO PROVE BY CLEAR AND CON

ive compensation entries. Each unique entry is separated by a ~ (tilde) with the unique identifiers (name, title, compensation) within the ex

d sample below:
0000~JACK PHILLIPS^CEO^2000000~BARBARA BAXTER^CFO^1000000~SEAN MCMILLEN^PEON^300000".
arious SAM values that are further defined as noted below.

of SAM Numerics is a numeric identification code, followed by a set of '^' delimited numbers that fill four positions.

ODE STRING: Holds X related 'Metrics' groups.

ing and example below:

15000000^30000000^15000000~LS^42^5000000^0^0~PG^1^0^0^0~ . . ."

pe == "BL" , "LS", "PG"

r Sequence #1 == "30000000" , "42", "1"
r Sequence #2 == "15000000" , "42", "0"
r Sequence # == "30000000" , "42", "0"
r Sequence #1 == "30000000" , "42", "0"

mber of Employees
ployees Value
rom 4th qtr, preceding year

AM values that are further defined as noted below.

nse represent an area serviced code, followed by an

ns, County area codes are five positions and
our positions. An area serviced code of "ANY" will not
700~MSA2710~MSA8960~STAFL"

CTY", "MSA" , "MSA", "MSA", "STA"

" , "FL099", "2700", "2710", "8960", "FL"
There are currently 10 NAICS codes with possible size exceptions. And there are from two to four
exceptions for each of these NAICS codes. The first 6 digits (1st position) of NAICS EXCEPTIONS is
the NAICS code, followed by a ‘Y’, ‘N’ or NULL in each of the next four positions. Note that in this
string a NULL value is denoted by a space rather than the word "NULL". The values of the string are
outlined below within the quotation marks. Breakdown of the string and example below:

"… ~115310YN ~541330NYY ~ …"

Position1 = NAICS Code == "115310" , "541330"

Position2 = NAICS Exception 1 == "Y" , "N"

Position3 = NAICS Exception 1 == "N" , "Y"

Position4 = NAICS Exception 1 == NULL " " , "Y"

Position5 = NAICS Exception 1 == NULL " " , NULL " "

How the NAICS Exception String Works:

The NAICS Exception string is utilized when one of the NAICS Codes in the table to the left is used.
When one of these NAICS Codes is present, the NAICS String will have an "E" rather than the normal
"Y" or "N" response. This is to direct the user to look at the NAICS Exception String. Every NAICS
Code that has an exception has betwwen 1 and 4 exceptions, as outlined in the table.

The first exception (1) is always the Y/N answer General Base NAICS Business Size standard. This is
the Y/N answer tha would have been in the NAICS String, had the NAICS not have been an Exception
NAICS. The remaining exceptions are the exceptions for the specific industry sectors.
articipation and expiration dates

an SBA Business Code followed by an expiration date

0110101" , "20110102"

unique identifiers (instrument number, proceeding date) within the proceeding itself is separated by a ^.

OE OFFICE OF HEARING AND APPEALS DETERMINED THAT COMPANY ABC HAD NOT MET ITS BURDEN UNDER 10 CFR PART 70
 MET ITS BURDEN UNDER 10 CFR PART 708 TO PROVE BY CLEAR AND CONVINCING EVIDENCE THAT IT WOULD HAVE SELECT

ed by a ~ (tilde) with the unique identifiers (name, title, compensation) within the executive compensation entry itself is separated by a ^.

ER^CFO^1000000~SEAN MCMILLEN^PEON^300000".
BURDEN UNDER 10 CFR PART 708 TO PROVE BY CLEAR AND CONVINCING EVIDENCE THAT IT WOULD HAVE SELECTED AN IND
E THAT IT WOULD HAVE SELECTED AN INDIVIDUAL FOR RELEASE AS PART OF A 2005 REDUCTION IN FORCE ABSENT HIS PRO

n entry itself is separated by a ^.

WOULD HAVE SELECTED AN INDIVIDUAL FOR RELEASE AS PART OF A 2005 REDUCTION IN FORCE ABSENT HIS PROTECTED D
ION IN FORCE ABSENT HIS PROTECTED DISCLOSURES.
RCE ABSENT HIS PROTECTED DISCLOSURES.~