Docstoc

SAM_Master_Extract_Mapping-v2.0

Document Sample
SAM_Master_Extract_Mapping-v2.0 Powered By Docstoc
					                      SAM EXTRACT/XML DATA ELEMENT LIST
                                   SAM To-Be Extract Details

                                                                                      CSV or
          SAM Extract Element List             Datatype        Data Format   Length
                                                                                       XML?
820s Request Flag                              STRING     Yes/No             3        BOTH
ABA Routing ID                                 STRING     Numeric            50       BOTH
Account Number                                 STRING     STRING             20       BOTH
Account Type                                   STRING     C or S             1        BOTH
ACH Email                                      STRING     STRING             80       BOTH
ACH Fax                                        STRING     STRING             30       BOTH
ACH Non-U.S. Phone                             STRING     STRING             30       BOTH
ACH U.S. Phone                                 STRING     Numeric            30       BOTH
Authorization Date                             STRING     MMDDYYYY           8        BOTH
Average Annual Revenue                         STRING     STRING             15       BOTH
Average Number of Employees                    STRING     STRING             15       BOTH
Sam Numerics Code String                       STRING     ^ Separated        1589     BOTH
(Bonding Level Value + Local # Employee +
Local Ann. Revenue + Total Assets + Megawatt
Hours + Barrels Capacity)




Business Start Date                            STRING     MMDDYYYY           8        BOTH

CAGE Code                                      STRING     STRING             5        BOTH

Company Division                               STRING     STRING             60       BOTH
Division Number                                           STRING             10       BOTH
Company Security Level                         STRING     STRING             2        BOTH
Corporate URL                                  STRING     STRING             200      BOTH
Correspondence Flag                            STRING     M, F, or E         1        BOTH
Country of Incorporation                       STRING     STRING             3        BOTH
Credit Card Usage                              STRING     Y or N             1        BOTH

D&B Out of Business Indicator                  STRING     0 or 1             1        BOTH
Legal Business Name                            STRING     STRING             120      BOTH


D&B Monitoring Address 1                       STRING     STRING             55       BOTH
D&B Monitoring Address 2                       STRING     STRING             55       BOTH
D&B Monitoring City                            STRING     STRING             35       BOTH
D&B Monitoring Corporation Name                STRING     STRING             120      BOTH
D&B Monitoring Country Code                    STRING     STRING             3        BOTH
D&B Monitoring DBA                             STRING     STRING             120      BOTH
D&B Monitoring Last Updated                    STRING     MMDDYYYY           10       BOTH
D&B Monitoring Postal Code                     STRING     STRING             35       BOTH
D&B Monitoring State or Province               STRING     STRING             50       BOTH
D&B Monitoring Status                          STRING     0 or 1             1        BOTH
DBA Name                                            STRING   STRING               120     BOTH


Delinquent Federal Debt Flag                        STRING   Y or N               1       BOTH

DUNS                                                STRING   Numeric              9       BOTH


DUNS+4                                              STRING   Numeric              4       BOTH


EFT Waiver                                          STRING   Y or F or null       1       BOTH
Tax Identifier Number                               STRING   Numeric              9       BOTH


Tax Identifier Type                                 STRING   1 (SSN) or 2 (TIN)   1       BOTH
Entity Structure                                    STRING   STRING               2       BOTH
Exclusion Status String                             STRING   STRING               50      BOTH
Financial Institute                                 STRING   STRING               30      BOTH
Fiscal Year End Close Date                          STRING   MMDD                 4       BOTH
Functional Group Identifier                         STRING   STRING               15      BOTH
Disaster Response String                            STRING   ^ Separated          70      BOTH
(Geographic Area Served: County + Geographic
Area Served: Metropolitan Statistical Area +
Geographic Area Served: State)
Bus Type String                                     STRING   ^ Separated          300     BOTH
( Government Type + Other Business or
Organization Qualifiers + Other Entity Qualifiers
+ AbilityOne Flag + Registration Purpose)


Highest Employee Security Level                     STRING   STRING               2       BOTH
ISA Identifier                                      STRING   STRING               15      BOTH
ISA Qualifier                                       STRING   STRING               2       BOTH
Lockbox Number                                      STRING   STRING               20      BOTH
MPIN                                                STRING   STRING               9       BOTH
NAICS Code String                                   STRING   ^ Separated          12000   BOTH

NAICS Exception String                              STRING   ^ Separated          1100    BOTH
No Public Display Flag                              STRING   Y or null            1       BOTH
DNB Linkage String                                  STRING   ^ Separated          1500    BOTH
(Parent Address + HQ Parent Address +
Domestic Parent Address + Global Parent
Address)
PSC Code String                STRING   ^ Separated   3500   BOTH

Registration Date              STRING   MMDDYYYY      8      BOTH

Registration Status            STRING   STRING        1      BOTH

Remittance Address Line 1      STRING   STRING        55     BOTH
Remittance Address Line 2      STRING   STRING        55     BOTH
Remittance Address Line 3      STRING   STRING        55     BOTH
Remittance Address Line 4      STRING   STRING        55     BOTH
Remittance City                STRING   STRING        35     BOTH
Remittance Country             STRING   STRING        3      BOTH
Remittance Name                STRING   STRING        60     BOTH
Remittance State or Province   STRING   STRING        50     BOTH
                                                             BOTH
Remittance Zip Code            STRING   STRING        35     BOTH
Remittance Zip Code +4         STRING   Numeric       4      BOTH
Renewal Date                   STRING   MMDDYYYY      8      BOTH
SAM Extract Code               STRING   Numeric       1      CSV
SAM Address 1                  STRING   STRING        55     BOTH


SAM Address 2                  STRING   STRING        55     BOTH


SAM Address 3                  STRING   STRING        55     BOTH
SAM Address 4                  STRING   STRING        55     BOTH
SAM City                       STRING   STRING        35     BOTH
SAM City                                   STRING   STRING        35      BOTH


SAM Country Code                           STRING   STRING        3       BOTH


SAM Province or State                      STRING   STRING        50      BOTH


SAM Zip Code                               STRING   STRING        35      BOTH


SAM Zip Code +4                            STRING   Numeric       4       BOTH
SAM Congressional District                 STRING   Numeric       2       BOTH
SBA Business Types String                  STRING   ^ Separated   110     BOTH
(SBA Business Types + SBA Cert Exp Date)
State of Incorporation                     STRING   STRING        2       BOTH
Agency Business Purpose                    STRING   STRING        1       BOTH
Agency Location Code                       STRING   STRING        8       BOTH
Annual Revenue                             STRING   STRING        15      BOTH
Department Codes                           STRING   STRING        2       BOTH
Disbursing Office Symbol                   STRING   STRING        5       BOTH
DODAAC                                     STRING   STRING        9       BOTH
Expiration Date                            STRING   MMDDYYYY      8       BOTH
Merchant ID 1                              STRING   STRING        120     BOTH
Merchant ID 2                              STRING   STRING        120     BOTH
Agency Parent DODAAC                       STRING   STRING        9       BOTH
Agency Parent DUNS                         STRING   Numeric       9       BOTH
Parent Legal Business Name                 STRING   STRING        120     BOTH

Agency Parent Address Line 1               STRING   STRING        55      BOTH
Agency Parent Address Line 2               STRING   STRING        55      BOTH
Agency Parent Address Line 3               STRING   STRING        55      BOTH
Agency Parent Address Line 4               STRING   STRING        55      BOTH
Agency Parent City                         STRING   STRING        35      BOTH
Agency Parent Country                      STRING   STRING        3       BOTH
Agency Parent State or Province            STRING   STRING        50      BOTH



Agency Parent Zip Code                     STRING   STRING        35      BOTH
Agency Parent Zip Code +4                  STRING   Numeric       4       BOTH
Accounting Station                         STRING   STRING        6       BOTH
FOUO POC String                            STRING   ^ Separated   8,000   BOTH
Primary NAICS                                 STRING   STRING        6      BOTH
Public POC String                             STRING   ^ Separated   6000   BOTH




Mailing Address Line 1                        STRING   STRING        55     BOTH
Mailing Address Line 2                        STRING   STRING        55     BOTH
Mailing Address Line 3                        STRING   STRING        55     BOTH
Mailing Address Line 4                        STRING   STRING        55     BOTH
Mailing City                                  STRING   STRING        35     BOTH
Mailing Country                               STRING   STRING        3      BOTH
Mailing Name                                  STRING   STRING        60     BOTH
Mailing State or Province                     STRING   STRING        50     BOTH

Mailing Zip Code                              STRING   STRING        35     BOTH
Mailing Zip Code +4                           STRING   Numeric       4      BOTH
Proceedings Qualifying Response 1             STRING   STRING        1      BOTH
Proceedings Qualifying Response 2             STRING   STRING        1      BOTH
Proceedings Qualifying Response 3             STRING   STRING        1      BOTH
Proceedings String                            STRING   ^ Separated   1500   BOTH
(Instrument, Instrument Number, Proceedings
State, Proceedings Description, Proceedings
Date, Proceedings Type, Disposition)
FAR Provision XXXXXXXX                        STRING   STRING               XML
SF330 PartII Provision XXXXXXXX               STRING   STRING               XML
DFARS Provision XXXXXXXX                      STRING   STRING               XML
         LEGACY DATA ELEMENT EQUIVALENT (CCR/FedReg/ORCA)
                                Legacy As-Is Extract Data Mapping

      As-Is      As-Is                                                                  CSV or
                              As-Is Extract Element Mapping         Datatype   Length
    Element #   Source                                                                   XML?
276             CCR      RECEIVE 820?                               CHAR       3        XML
210             CCR      ABA ROUTING ID                             CHAR       50       BOTH
209             CCR      ACCOUNT NUMBER                             CHAR       20       BOTH
211             CCR      PAYMENT TYPE                               CHAR       1        BOTH
218             CCR      ACH EMAIL                                  CHAR       80       BOTH
217             CCR      ACH FAX                                    CHAR       30       BOTH
216             CCR      ACH NON-U.S. PHONE                         CHAR       30       BOTH
215             CCR      ACH U.S. PHONE                             CHAR       30       BOTH
213             CCR      AUTHORIZATION DATE                         CHAR       8        BOTH
202             CCR      ANNUAL RECEIPTS                            CHAR       15       BOTH
201             CCR      AVG NUMBER OF EMPLOYEES                    CHAR       15       BOTH
240             CCR      CCR NUMERICS CODE STRING                   CHAR       1589     CSV




272             CCR      LOCATION EMPLOYEES                         Number     15       XML
273             CCR      LOCATION RECEIPTS                          Number     15       XML
17              CCR      BUS START DATE                             CHAR       8        BOTH
                ORCA     OperationsStartDate                        CHAR       10       XML
3               CCR      CAGE CODE                                  CHAR       5        BOTH
                ORCA     CAGE Code                                  STRING     5        XML
9               CCR      COMPANY DIVISION                           CHAR       60       BOTH
10              CCR      DIVISION NUMBER                            CHAR       10       BOTH
19              CCR      CO SECURITY LEVEL                          CHAR       2        BOTH
21              CCR      CORPORATE URL                              CHAR       200      BOTH
36              CCR      CORRESPONDENCE FLAG                        CHAR       1        CSV
24              CCR      COUNTRY OF INC                             CHAR       3        CSV
35              CCR      CREDIT CARD                                CHAR       1        CSV
399             FedReg   CREDIT CARD                                Number     1        CSV
259             CCR      DNB CURRENT BUSINESS STATUS                CHAR       1        XML
7               CCR      LEGAL BUS NAME                             CHAR       120      BOTH
286             FedReg   BUSINESS NAME                              Char       120      CSV
                ORCA     LegalName                                  STRING     120      XML
193             CCR      DNB MONITORING ST ADD (1)                  CHAR       55       BOTH
194             CCR      DNB MONITORING ST ADD (2)                  CHAR       55       BOTH
195             CCR      DNB MONITORING CITY                        CHAR       35       BOTH
191             CCR      DNB MONITORING CORP NAME                   CHAR       120      BOTH
197             CCR      DNB MONITORING COUNTRY CODE                CHAR       3        BOTH
192             CCR      DNB MONITORING DBA                         CHAR       120      BOTH
189             CCR      DNB MONITORING LAST UPDATED                CHAR       10       BOTH
196             CCR      DNB MONITORING POSTAL CODE                 CHAR       35       BOTH
198             CCR      DNB MONITORING STATE OR PROVINCE           CHAR       50       BOTH
190             CCR      DNB MONITORING STATUS                      CHAR       1        BOTH
8      CCR      DBA NAME                                            CHAR     60      BOTH
287    FedReg   TRADESTYLE NAME (PRIMARY)                           Char     120     CSV
       ORCA     DBAName                                             STRING   60      XML
258    CCR      DELINQUENT FEDERAL DEBT                             CHAR     1       XML
       ORCA     DelinquentFederalDebtIndication                     STRING   1       XML
1      CCR      DUNS                                                CHAR     9       BOTH
284    FedReg   DUNS NUMBER                                         Char     9       CSV
       ORCA     DUNSID                                              CHAR     9       XML
2      CCR      DUNS-PLUS4                                          CHAR     4       BOTH
285    FedReg   DUNS PLUS4                                          Char     4       CSV
       ORCA     DUNSPlus4ExtensionID                                CHAR     4       XML
214    CCR      EFT WAIVER                                          CHAR     1       CSV
200    CCR      TAX PAYER ID NUMBER                                 CHAR     9       BOTH
312    FedReg   EMPLOYER IDENTIFICATION NUMBER (EIN)                Number   9       CSV
203    CCR      SOCIAL SECURITY NUMBER                              STRING   9       XML
#N/A   #N/A     #N/A                                                #N/A     #N/A    #N/A
22     CCR      ORGANIZATIONAL TYPE                                 CHAR     2       BOTH
236    CCR      EXTERNAL CERTIFICATION STRING                       CHAR     50      CSV
208    CCR      FINANCIAL INSTUTE                                   CHAR     30      BOTH
18     CCR      FISCAL YEAR END CLOSE DATE                          CHAR     4       BOTH
268    CCR      GS02 IDENTIFIER                                     CHAR     15      XML
244    CCR      DISASTER RESPONSE STRING                            CHAR     70      CSV



#N/A   CCR      BUS TYPE STRING                                     CHAR     300     BOTH
                ( Government Type + Other Business or
                Organization Qualifiers + Other Entity Qualifiers
                + AbilityOne Flag + Registration Purpose)


20     CCR      EMPLOYEE SECURITY LEVEL                             CHAR     15      BOTH
271    CCR      ISA SENDER QUALIFIER                                CHAR     15      XML
270    CCR      ISA QUALIFIER                                       CHAR     2       XML
212    CCR      LOCKBOX NUMBER                                      CHAR     20      BOTH
232    CCR      MARKETING PARTNER ID NUMBER (MPIN)                  CHAR     9       BOTH
30     CCR      NAICS CODE STRING                                   CHAR     12000   CSV
401    FedReg   NAICS (space for 20, fixed)                         Char     120     CSV
234    CCR      NAICS EXCEPTIONS STRING                             CHAR     1100    CSV
275    CCR      NO PUBLIC DISPLAY FLAG                              CHAR     1       XML
52     CCR      PARENT DUNS NUMBER                                  CHAR     13      CSV
172    CCR      DOMESTIC PARENT DUNS NUMBER                         CHAR     13      CSV
181    CCR      GLOBAL PARENT DUNS NUMBER                           CHAR     13      CSV
163    CCR      HQ PARENT DUNS NUMBER                               CHAR     13      CSV
51     CCR      PARENT POC (GL)                                     CHAR     60      CSV
53     CCR      PARENT ST ADD (1)                                   CHAR     55      CSV
173    CCR      DOMESTIC PARENT ST ADD (1)                          CHAR     55      CSV
182    CCR      GLOBAL PARENT ST ADD (1)                            CHAR     55      CSV
164    CCR      HQ PARENT ST ADD (1)                                CHAR     55      CSV
54     CCR      PARENT ST ADD (2)                                   CHAR     55      CSV
174    CCR      DOMESTIC PARENT ST ADD (2)                          CHAR     55      CSV
183    CCR      GLOBAL PARENT ST ADD (2)                            CHAR     55      CSV
165    CCR      HQ PARENT ST ADD (2)                CHAR     55     CSV
55     CCR      PARENT CITY                         CHAR     35     CSV
175    CCR      DOMESTIC PARENT CITY                CHAR     35     CSV
184    CCR      GLOBAL PARENT CITY                  CHAR     35     CSV
166    CCR      HQ PARENT CITY                      CHAR     35     CSV
57     CCR      PARENT COUNTRY CODE                 CHAR     3      CSV
177    CCR      DOMESTIC PARENT COUNTRY CODE        CHAR     3      CSV
186    CCR      GLOBAL PARENT COUNTRY CODE          CHAR     3      CSV
168    CCR      HQ PARENT COUNTRY CODE              CHAR     3      CSV
178    CCR      DOMESTIC PARENT STATE OR PROVINCE   CHAR     2      CSV
187    CCR      GLOBAL PARENT STATE OR PROVINCE     CHAR     2      CSV
169    CCR      HQ PARENT STATE OR PROVINCE         CHAR     2      CSV
58     CCR      PARENT STATE OR PROVINCE            CHAR     2      CSV
56     CCR      PARENT POSTAL CODE                  CHAR     35     CSV
176    CCR      DOMESTIC PARENT POSTAL CODE         CHAR     35     CSV
185    CCR      GLOBAL PARENT POSTAL CODE           CHAR     35     CSV
167    CCR      HQ PARENT POSTAL CODE               CHAR     35     CSV
#N/A   #N/A     #N/A                                #N/A     #N/A   #N/A
260    CCR      DOMESTIC PARENT RECORD DATE         CHAR     8      CSV
267    CCR      GLOBAL PARENT RECORD DATE           CHAR     8      CSV
269    CCR      HQ PARENT RECORD DATE               CHAR     8      CSV
179    CCR      DOMESTIC PARENT PHONE               CHAR     30     CSV
188    CCR      GLOBAL PARENT PHONE                 CHAR     30     CSV
170    CCR      HQ PARENT PHONE                     CHAR     30     CSV
34     CCR      PSC CODE                            CHAR     3500   BOTH
403    FedReg   PSC (space for 20, fixed)           Char     80     CSV
5      CCR      REGISTRATION DATE                   CHAR     8      CSV
404    FedReg   REGISTRATION DATE (MMDDCCYY)        Char     8      CSV
277    CCR      REGISTRATION STATUS                 CHAR     1      XML
400    FedReg   REGISTRATION STATUS                 Char     1      CSV
220    CCR      REMIT INFO ST ADD (1)               CHAR     55     BOTH
221    CCR      REMIT INFO ST ADD (2)               CHAR     55     BOTH
#N/A   #N/A     #N/A                                #N/A     #N/A   #N/A
#N/A   #N/A     #N/A                                #N/A     #N/A   #N/A
222    CCR      REMIT INFO CITY                     CHAR     35     BOTH
225    CCR      REMIT INFO COUNTRY CODE             CHAR     3      BOTH
219    CCR      REMIT INFO POC (RI)                 CHAR     60     BOTH
223    CCR      REMIT INFO STATE OR PROVINCE        CHAR     50     BOTH
223    CCR      REMIT INFO STATE OR PROVINCE        CHAR     50     BOTH
224    CCR      REMIT INFO POSTAL CODE              CHAR     35     BOTH
#N/A   #N/A     #N/A                                #N/A     #N/A   #N/A
6      CCR      RENEWAL DATE                        CHAR     8      BOTH
4      CCR      CCR EXTRACT CODE                             1      CSV
11     CCR      ST ADD (1)                          CHAR     55     BOTH
288    FedReg   ADDRESS LINE 1 (PHYSICAL)           Char     55     CSV
       ORCA     Street                              STRING   55     XML
12     CCR      ST ADD (2)                          CHAR     55     BOTH
289    FedReg   ADDRESS LINE 2 (PHYSICAL)           Char     55     CSV
       ORCA     AdditionalStreet                    STRING   55     XML
#N/A   #N/A     #N/A                                #N/A     #N/A   #N/A
#N/A   #N/A     #N/A                                #N/A     #N/A   #N/A
13     CCR      CITY                                CHAR     35     BOTH
290    FedReg   CITY (PHYSICAL)                 Char     40     CSV
       ORCA     CityName                        STRING   35     XML
16     CCR      COUNTRY CODE                    CHAR     3      BOTH
294    FedReg   COUNTRY CODE (PHYSICAL)         Char     3      CSV
       ORCA     CountryIdentificationCode       STRING   3      XML
14     CCR      STATE OR PROVINCE               CHAR     50     BOTH
291    FedReg   STATE (PHYSICAL)                Char     50     CSV
       ORCA     CountrySubEntityCode            STRING   2      XML
15     CCR      POSTAL CODE                     CHAR     35     BOTH
295    FedReg   POSTAL CODE (PHYSICAL)          Char     35     CSV
       ORCA     PostalZone                      STRING   35     XML
#N/A   #N/A     #N/A                            #N/A     #N/A   #N/A
#N/A   #N/A     #N/A                            #N/A     #N/A   #N/A
238    CCR      SBA CERTIFICATION STRING        CHAR     110    BOTH

23     CCR      STATE OF INC                    CHAR     2      CSV
315    FedReg   BUSINESS TYPE                   Number   1      CSV
313    FedReg   AGENCY LOCATION CODE (ALC)      Char     8      CSV
396    FedReg   ANNUAL REVENUE                  Number   15     CSV
311    FedReg   TREASURY INDEX                  Char     2      CSV
314    FedReg   DISBURSING OFFICE (DO)          Char     5      CSV
284    FedReg   DUNS NUMBER                     Char     9      CSV
407    FedReg   EXPIRATION DATE (MMDDCCYY)      Char     8      CSV
397    FedReg   MERCHANT ID1                    Char     120    CSV
398    FedReg   MERCHANT ID2                    Char     120    CSV
301    FedReg   PARENT DUNS                     Char     9      CSV
301    FedReg   PARENT DUNS                     Char     9      CSV
302    FedReg   PARENT NAME                     Char     120    CSV
59     CCR      GOVT PARENT POC (QW)            STRING   60     BOTH
60     CCR      GOVT PARENT ST ADD (1)          STRING   55     BOTH
61     CCR      GOVT PARENT ST ADD (2)          STRING   55     BOTH
#N/A   #N/A     #N/A                            #N/A     #N/A   #N/A
#N/A   #N/A     #N/A                            #N/A     #N/A   #N/A
62     CCR      GOVT PARENT CITY                STRING   40     BOTH
64     CCR      GOVT PARENT COUNTRY CODE        STRING   3      BOTH
65     CCR      GOVT PARENT STATE OR PROVINCE   STRING   50     BOTH



63     CCR      GOVT PARENT POSTAL CODE         STRING   35     BOTH
#N/A   #N/A     #N/A                            #N/A     #N/A   #N/A
#N/A   #N/A     #N/A                            #N/A     #N/A   #N/A
#N/A   #N/A     #N/A                            #N/A     #N/A   #N/A
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A




38     CCR    MAILING ADD ST ADD (1)          CHAR   55     BOTH
39     CCR    MAILING ADD ST ADD (2)          CHAR   55     BOTH
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A
40     CCR    MAILING ADD CITY                CHAR   35     BOTH
42     CCR    MAILING ADD COUNTRY CODE        CHAR   3      BOTH
37     CCR    MAILING ADD POC (FE)            CHAR   60     BOTH
43     CCR    MAILING ADD STATE OR PROVINCE   CHAR   50     BOTH

41     CCR    MAILING ADD POSTAL CODE         CHAR   35     BOTH
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A
#N/A   #N/A   #N/A                            #N/A   #N/A   #N/A



       ORCA   FARXXXXXX                              1      XML
       ORCA   SF330Part II                           1      XML
       ORCA   DFARXXX.XXX-XXXX                       1      XML
                WHICH SAM EXTRACT IS THE ELEMENT IN?
         Sensitivity                               EXTRACT TYPE

Sensitivity    Sensitivity                                                       MPIN
                             Public Extract   FOUO Extract   Sensitive Extract
  Level          Level                                                           Extract
FOUO                   2                           X                X
Sensitive              3                                            X
Sensitive              3                                            X
Sensitive              3                                            X
Sensitive              3                                            X
Sensitive              3                                            X
Sensitive              3                                            X
Sensitive              3                                            X
Sensitive              3                                            X
FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2



                                                   X                X




Public                 1
                                   X               X                X
Public                 1
                                   X               X                X              X
Public                 1           X               X                X
Public                 1           X               X                X
FOUO                   2                           X                X
Public                 1           X               X                X
Public                 1           X               X                X
Public                 1           X               X                X
Public                 1
                                   X               X                X
FOUO                   2                           X                X
Public                 1
                                   X               X                X

FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2                           X                X
FOUO                   2                           X                X
Public      1
                X   X   X

Public      1
                X   X   X
Public      1
                X   X   X   X

Public      1
                X   X   X   X

Sensitive   3           X
Sensitive   3
                        X

Sensitive   3           X
Public      1   X   X   X
Public      1   X   X   X
Sensitive   3           X
Public      1   X   X   X
FOUO        2       X   X
Public      1
                X   X   X


Public      1


                X   X   X



FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
Sensitive   3           X
Sensitive   3           X   X
Public      1
                X   X   X
Public      1   X   X   X
Public      1   X   X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
FOUO        2                 X          X
Public      1
                   X          X          X
Public      1
                   X          X          X
Public      1
                   X          X          X
Sensitive   3                            X
Sensitive   3                            X
Sensitive   3                            X
Sensitive   3                            X
Sensitive   3                            X
Sensitive   3                            X
Sensitive   3                            X
Sensitive   3
                                         X
Sensitive   3                            X
Sensitive   3                            X
Public      1      X          X          X
Public      1   CSV Only   CSV Only   CSV Only   CSV Only
Public      1
                   X          X          X

Public      1
                   X          X          X

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

Public      1
                X   X   X

Public      1
                X   X   X

Public      1
                X   X   X

Public      1   X   X   X
Public      1   X   X   X
Public      1
                X   X   X
Public      1   X   X   X
Public      1   X   X   X
Public      1   X   X   X
FOUO        2       X   X
Public      1   X   X   X
Sensitive   3           X
Public      1   X   X   X
Public      1   X   X   X
Sensitive   3           X
Sensitive   3           X
Public      1   X   X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
FOUO        2
                    X   X

FOUO        2       X   X
FOUO        2       X   X
FOUO        2       X   X
Sensitive   3           X
FOUO        2




                    X   X
                 X   X




Public   1   X   X   X
Public   1




             X   X   X




Public   1   X   X   X
Public   1   X   X   X
Public   1   X   X   X
Public   1   X   X   X
Public   1   X   X   X
Public   1   X   X   X
Public   1   X   X   X
Public   1
             X   X   X
Public   1   X   X   X
Public   1   X   X   X
FOUO     2       X   X
FOUO     2       X   X
FOUO     2       X   X
FOUO     2
                 X   X


Public   1   X   X   X
Public   1   X   X   X
Public   1   X   X   X
SAM DNB Linkage String
ADDRESS_TYPE            ADDRESS_TYPE_DESC
GL                      GLOBAL PARENT
DM                      DOMESTIC PARENT
HQ                      HQ PARENT




SAM Numerics Code String
Size_Detail_CODE TYPE   Size_Detail_DESC
LS0                     Local Size numbers, uses NBRs 01 and 02 only
LS1                     Local Avg. Number of Employees (max. 999,999)
LS2                     Local Avg. Annual Revenue (max. 999,999,999,999)

AA0                     Legacy***List CCR_NUMBER table codes, zero for hdg or notes
AA1                     Verbiage for CCR_NBR_01_20614, if any
AA2                     Verbiage for CCR_NBR_02_20615, if any
AA3                     Verbiage for CCR_NBR_03_20616, if any
AA4                     Verbiage for CCR_NBR_04_20617, if any

BK0                     SBA NAICS Banking Size Addl data, use NBR 01 only
BK1                     Total Assets from 4th qtr, preceding year

PG0                     SBA NAICS Power Gen. Addl data, use NBR 01 only
PG1                     Total MWH, preceding fiscal year, all affiliates

PT0                     SBA NAICS Petroleum Addl data,use NBR 01 only
PT1                          Bbl/day, Oper. Atmos. Crude Oil Distil. capacity

DR_Bonding_Level_CODE_TYPE   DR_Bonding_Level_DESC
BL0                          Bonding Levels for Disaster Relief Registry
BL1                          Construction Bonding Level, Per Contract (dollars)
BL2                          Construction Bonding Level, Aggregate (dollars)
BL3                          Service Bonding Level, Per Contract (dollars)
BL4                          Service Bonding Level, Aggregate (dollars)


SAM Disaster Response String
DR_Area_Served_TYPE_CODE     DR_Area_Served_TYPE_DESC
ANY                          Any area
STA                          State
CTY                          County
MSA                          Metropolitan Service Area




SAM Bus Type String
Bus_Type_CODE                Bus_Type_NAME
8W                           Women-Owned Small Business
8E                           Economically Disadvantaged Women-Owned Small Business
8C                           Joint Venture Women-Owned Small Business
8D                           Joint Venture Economically Disadvantaged Women-Owned Small Business
12                           U.S. Local Government
1A                           Minority Institutions
20                           Foreign Owned and Located
G3                           Alaskan Native Servicing Institution (ANSI)
23                           Minority Owned Business
27                           Self Certified Small Disadvantaged Business
2F   U.S. State Government
2R   U.S. Federal Government
3I   Tribal Government
A2   Woman Owned Business
A3   Labor Surplus Area Firm
A5   Veteran Owned Business
A7   AbilityOne (formerly JWOD) Non-Profit Agency
A8   Nonprofit Organization
G5   Native Hawaiian Servicing Institution (NHSI)
C6   Municipality
FR   Asian-Pacific American Owned
HB   Historically Black College or University (HBCU)
G9   Other than one of the preceding
LJ   Limited Liability Company
M8   Educational Institution
MF   Manufacturer of Goods
NB   Native American Owned
OW   American Indian Owned
OY   Black American Owned
PI   Hispanic American Owned
QF   Service Disabled Veteran Owned Business
QZ   Subcontinent Asian (Asian-Indian) American Owned
XS   S Corporation
VN   Contracts
V2   Grants
VW   Contracts and Grants
TR   Airport Authority
UD   Council of Governments
BZ   Foundation
GW   Hispanic Servicing Institution
80   Hospital
KM   Planning Commission
T4   Port Authority
H6   School District
ZW   School of Forestry
TW   Transit Authority
QU   Veterinary College
FY   Veterinary Hospital
H2   Community Development Corporation
6D   Domestic Shelter
2X   For-Profit Organization
2U   Other Not for Profit Organization
G6   1862 Land Grant College
G7   1890 Land Grant College
G8   1994 Land Grant College
1R   Private University or College
OH   State Controlled Institution of Higher Learning
HS   Tribal College
NG   Federal Agency
QW   Federally Funded Research and Development Corp
C8   City
C7   County
ZR                Inter-municipal
MG                Local Government Owned
FO                Township
8B                Housing Authorities Public/Tribal
86                Interstate Entity
5                 Alaskan Native Corporation Owned Firm
1B                Tribally Owned Firm
HK                Community Development Corporation Owned Firm
XY                Indian Tribe (Federally Recognized)
8U                Native Hawaiian Organization Owned Firm
HQ                DoT Certified Disadvantaged Business Enterprise
1D                Small Agricultural Cooperative




SAM NAICS Code String




SAM NAICS Exceptions Code String
Code              SZ_MOD
         115310              1
         115310              2
         115310              3
         237990              1
         237990              2
         481211              1
         481211              2
         481212              1
         481212              2
         488510              1
         488510              2
         531190              1
         531190              2
         541330              1
         541330              2
         541330              3
         541330              4
         541340              1
         541340              2
         541519              1
                541519               2
                541712               1
                541712               2
                541712               3
                541712               4
                562910               1
                562910               2
                611519               1
                611519               2


SBA CERTIFICATION String
Bus_Type_CODE            Bus_Type_NAME
A4                       SBA Certified Small Disadvantaged Business
A6                       SBA Certified 8A Program Participant
XX                       SBA Certified Hub Zone Firm
JT                       SBA Certified 8A Joint Venture




SAM FOUO POC String
POC_Type                 POC_Desc
AP                       Accounts Payable
SL                       Sales
AR                       Accounts Receivable
EA                       EDI
PC                       Party Performing Certification
PR                       Proceedings
PA                       Proceedings Alternate
SP                       Sole Proprietor
EP                       Eliminations
SAM PUBLIC POC String
POC_Type    POC_Desc
EB          E-Business
E2          E-Business Alternate
GB          Government Business
GA          Government Business Alternate
PP          Past Performance
P2          Past Performance Alternate
age String
DDRESS_TYPE_DESC
LOBAL PARENT
OMESTIC PARENT




 Code String
ize_Detail_DESC
ocal Size numbers, uses NBRs 01 and 02 only
ocal Avg. Number of Employees (max. 999,999)
ocal Avg. Annual Revenue (max. 999,999,999,999)

egacy***List CCR_NUMBER table codes, zero for hdg or notes
erbiage for CCR_NBR_01_20614, if any
erbiage for CCR_NBR_02_20615, if any
erbiage for CCR_NBR_03_20616, if any
erbiage for CCR_NBR_04_20617, if any

BA NAICS Banking Size Addl data, use NBR 01 only
otal Assets from 4th qtr, preceding year

BA NAICS Power Gen. Addl data, use NBR 01 only
otal MWH, preceding fiscal year, all affiliates

BA NAICS Petroleum Addl data,use NBR 01 only
 bl/day, Oper. Atmos. Crude Oil Distil. capacity

 R_Bonding_Level_DESC
 onding Levels for Disaster Relief Registry
 onstruction Bonding Level, Per Contract (dollars)
 onstruction Bonding Level, Aggregate (dollars)
 ervice Bonding Level, Per Contract (dollars)
 ervice Bonding Level, Aggregate (dollars)


Response String
 R_Area_Served_TYPE_DESC



Metropolitan Service Area




  String
 us_Type_NAME
Women-Owned Small Business
 conomically Disadvantaged Women-Owned Small Business
 oint Venture Women-Owned Small Business
 oint Venture Economically Disadvantaged Women-Owned Small Business
 .S. Local Government
Minority Institutions
 oreign Owned and Located
 laskan Native Servicing Institution (ANSI)
Minority Owned Business
 elf Certified Small Disadvantaged Business
 .S. State Government
 .S. Federal Government
 ribal Government
Woman Owned Business
 abor Surplus Area Firm
 eteran Owned Business
 bilityOne (formerly JWOD) Non-Profit Agency
 onprofit Organization
 ative Hawaiian Servicing Institution (NHSI)

 sian-Pacific American Owned
 istorically Black College or University (HBCU)
  ther than one of the preceding
 mited Liability Company
 ducational Institution
Manufacturer of Goods
 ative American Owned
 merican Indian Owned
 lack American Owned
 ispanic American Owned
 ervice Disabled Veteran Owned Business
 ubcontinent Asian (Asian-Indian) American Owned



 ontracts and Grants
 irport Authority
 ouncil of Governments

 ispanic Servicing Institution

 lanning Commission

 chool District
 chool of Forestry
 ransit Authority
 eterinary College
 eterinary Hospital
 ommunity Development Corporation
 omestic Shelter
 or-Profit Organization
 ther Not for Profit Organization
 862 Land Grant College
 890 Land Grant College
 994 Land Grant College
 rivate University or College
 tate Controlled Institution of Higher Learning

 ederal Agency
 ederally Funded Research and Development Corp
nter-municipal
ocal Government Owned

 ousing Authorities Public/Tribal
nterstate Entity
 laskan Native Corporation Owned Firm
 ribally Owned Firm
 ommunity Development Corporation Owned Firm
ndian Tribe (Federally Recognized)
 ative Hawaiian Organization Owned Firm
 oT Certified Disadvantaged Business Enterprise
 mall Agricultural Cooperative




ode String




 ceptions Code String
             NAICS_SBA_SIZE_TEXT
             General $7.0m small business size standard
             Special $17.5m size standard for Forest Fire Suppression
             Special $17.5m size standard for Fuels Management
             General $33.5m small business size standard
             Special $20m small business size standard for Dredging and Surface Cleanup Activities
             General 1500 employees small business size standard
             Special $28m size standard for Offshore Marine Air Transportation Services
             General 1500 employees small business size standard
             Special $28m size standard for Offshore Marine Air Transportation Services
             General $7m small business size standard
             Special $25.5m size standard for Non-Vessel Owning Common Carriers and Household Goods Forwarders
             General $7m small business size standard
             Special $20.5m size standard for Leasing of Building Space to Federal Government by Owners
             General $4.5m small business size standard
             Special $18.5m size standard for Marine Engineering and Naval Architecture
             Special $27m size standard for Military and Aerospace Equipment and Military Weapons
             Special $27m size standard for Contracts and Subcontracts for Engineering Services Awarded Under the National Energy Polic
             General $7m small business size standard
             Special $4.5m small business size standard for Map Drafting
             General $25m small business size standard
             Special 150 employees size standard for Information Technology Value Added Resellers
             General 500 employees small business size standard
             Special 1500 employees size standard for Aircraft
             Special 1000 employees size standard for Aircraft Parts and Auxiliary Equipment and Aircraft Engine Parts
             Special 1000 employees size standard for Space Vehicles and Guided Missiles, their Propulsion units, their Propulsion Units Pa
             General $14m small business size standard
             Special 500 employees size standard for Environmental Remediation Services
             General $7m small business size standard
             Special $35.5m size standard for Job Corps Centers


ATION String
us_Type_NAME
BA Certified Small Disadvantaged Business
BA Certified 8A Program Participant
BA Certified Hub Zone Firm
BA Certified 8A Joint Venture




C String
ccounts Payable

ccounts Receivable

arty Performing Certification

roceedings Alternate
ole Proprietor




                                                                                Position4 = POC Middle Initial == "A"
                                                                                Position5 = POC Last Name      == "Merica"
                                                                                Position6 = POC Title           == "Mr"
                                                                                Position7 = POC US Phone       == "5555551212"
                                                                                Position8 = POC US Phone Ext == "1111"
                                                                                Position9 = POC Non US Phone == "NULL"
                                                                                Position10 = POC Fax             == "9876543211"
                                                                                Position11 = Address 1            == "123 Main Stree
                                Position12 = Address 2             == "NULL"
                                Position13 = Address 3             == "NULL"
                                Position14 = Address 4             == "NULL"
                                Position15 = City                    == "Arlington"
                                Position16 = Country Code         == "USA"
                                Position17 = State or Province   == "VA"
                                Position18 = Zip Code               == "99999"
                                Position19 = Zip Code +4           == "0001"




POC String
 -Business Alternate
 overnment Business
 overnment Business Alternate
 ast Performance
 ast Performance Alternate
The first 2 positions of SAM DNB LINKAGE is a numeric identification code, followed by a set of '^'
delimited numbers. The entire field of code, numbers, and delimiters may
reach 1500 characters as shown. The internal maximum (per record) is 500 characters for each record (^^…^^)
although this will seldom occur.

SAM DNB LINKAGE STRING: Holds X related DnB Linkage Parent Data groups.


Breakdown of the string and example below:

". . . ^^GL^123456789^5555551212^123 Main Street^NULL^NULL^NULL^Arlington^USA^VA^99999^0001^01012011^^. . ."

Position1 = Address Type         == "GL"
Position2 = Parent DUNS         == "123456789"
Position3 = US Phone             == "5555551212"
Position4 = Address 1            == "123 Main Street"
Position5 = Address 2            == "NULL"
Position6 = Address 3            == "NULL"
Position7 = Address 4            == "NULL"
Position8 = City                   == "Arlington"
Position9 = Country Code        == "USA"
Position10 = State or Province == "VA"
Position11 = Zip Code              == "99999"
Position12 = Zip Code +4          == "0001"
Position13 = Record Date         == "01012011"




*SAM Numerics explanation:
SAM Numerics are various SAM values that are further defined as noted below.


The first 3 positions of SAM Numerics is a numeric identification code, followed by a set of '^'
delimited numbers. The entire field of code, numbers, and delimiters may
reach 1589 characters as shown.




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

Breakdown of the string and example below:

". . . ^^LS1^1239^^BK1^220000^^. . ."

Position1 = Code Type == "LS1" , "BK1"
Position2 = Value      == "1239" , "220000"


LS1 = Local Avg. Number of Employees (max. 999,999)
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.

The entire field of code, numbers, and delimiters may reach 70 characters as shown below.

Breakdown of the string and example below:

". . . ^^CTY^AL058^^MSA^1000^^STA^AL^^. . ."

Position1 = Type Code == "CTY" , "MSA" , "STA"
Position2 = Area Code == "AL058" , "1000" , "AL"

CTY = County code
AL058 = Saint Clair (Per ST_County.csv)
MSA = Metropolitan Service Area code
1000 = Birmingham, AL (Per MSA_List.csv)
STA = State code
AL = Alabama (Per STATE_List.csv)




Breakdown of the string and example below:

". . . ^^8W^^A7^^A8^^. . ."

Position1 = Business Type Code == "8W" , "A7" , "A8"
            NAICS CODE; Repeat X times to correspond with counter. Small Business indicator,
            Emerging Small Business indicator.

            Breakdown of the string and example below:

            "… ^^237990^N^N^^541340^ N^Y^^ …"

            Position1 = NAICS Code == "237990" , "541340"
            Position2 = Small Business Indication == "N" , "N"
            Position3 = Emerging Small Business Indication == "N" , "Y"




            There are 12 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.

              Breakdown of the string and example below:
g and Surface Cleanup Activities
              "… ^^115310^Y^N^NULL^NULL^^541330^N^Y^Y^NULL^^ …"
 nsportation Services
              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"
pace to Federal Government by Owners

nd Naval Architecture
Equipment and Military Weapons
acts for Engineering Services Awarded Under the National Energy Policy Act of 1992
echnology Value Added Resellers


s and Auxiliary Equipment and Aircraft Engine Parts
 les and Guided Missiles, their Propulsion units, their Propulsion Units Parts, and their Auxiliary Equipment and Parts

l Remediation Services




              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 CCYYMMDD format.

              Breakdown of the string and example below:

              ". . . ^^A4^20110101^^A6^20110102^^. . ."

              Position1 = Business Type Code == "A4" , "A6"
              Position2 = SBA Cert Expiration Date == "20110101" , "20110102"




              The first 2 positions of SAM FOUO POC string is a numeric identification code, followed by a set of '^'
              delimited numbers. The entire field of code, numbers, and delimiters may
              reach 8000 characters as shown. The internal maximum (per record) is 1000 characters for each record (^^…^^)
              although this will seldom occur.

              SAM FOUO POC STRING: Holds X related FOUO POC data groups.


              Breakdown of the string and example below:

              ". . . ^^AF^unclesam@sam.gov^Sam^A^Merica^Mr^5555551212^1111^NULL^9876543211^123 Main Street^NULL^NULL^NUL

              Position1 = POC Type             == "AF"
              Position2 = POC Email           == "unclesam@sam.gov"
              Position3 = POC First Name     == "Sam"
              Position4 = POC Middle Initial == "A"
              Position5 = POC Last Name      == "Merica"
              Position6 = POC Title           == "Mr"
              Position7 = POC US Phone       == "5555551212"
              Position8 = POC US Phone Ext == "1111"
              Position9 = POC Non US Phone == "NULL"
              Position10 = POC Fax              == "9876543211"
              Position11 = Address 1             == "123 Main Street"
Position12 = Address 2             == "NULL"
Position13 = Address 3             == "NULL"
Position14 = Address 4             == "NULL"
Position15 = City                    == "Arlington"
Position16 = Country Code         == "USA"
Position17 = State or Province   == "VA"
Position18 = Zip Code               == "99999"
Position19 = Zip Code +4           == "0001"




The first 2 positions of SAM PUBLIC POC string is a numeric identification code, followed by a set of '^'
delimited numbers. The entire field of code, numbers, and delimiters may
reach 6000 characters as shown. The internal maximum (per type) is 1000 characters for each record (^^…^^)
although this will seldom occur.

SAM PUBLIC POC STRING: Holds X related PUBLIC POC data groups.


Breakdown of the string and example below:

". . . ^^ZR^unclesam@sam.gov^Sam^A^Merica^Mr^5555551212^1111^NULL^9876543211^123 Main Street^NULL^NULL^NUL

Position1 = POC Type              == "ZR"
Position2 = POC Email            == "unclesam@sam.gov"
Position3 = POC First Name     == "Sam"
Position4 = POC Middle Initial  == "A"
Position5 = POC Last Name       == "Merica"
Position6 = POC Title             == "Mr"
Position7 = POC US Phone        == "5555551212"
Position8 = POC US Phone Ext == "1111"
Position9 = POC Non US Phone == "NULL"
Position10 = POC Fax               == "9876543211"
Position11 = Address 1              == "123 Main Street"
Position12 = Address 2            == "NULL"
Position13 = Address 3            == "NULL"
Position14 = Address 4            == "NULL"
Position15 = City                   == "Arlington"
Position16 = Country Code        == "USA"
Position17 = State or Province == "VA"
Position18 = Zip Code             == "99999"
Position19 = Zip Code +4          == "0001"
 each record (^^…^^)




VA^99999^0001^01012011^^. . ."
the NAICS code,
r each record (^^…^^)




1^123 Main Street^NULL^NULL^NULL^Arlington^USA^VA^99999^0001^^. . ."
each record (^^…^^)




1^123 Main Street^NULL^NULL^NULL^Arlington^USA^VA^99999^0001^^. . ."
      XML Element

FAR PROVISIONS
      FAR522032
      Name
      Title
      FAR5220311
      CertIndication
      FAR522043
      TINHolderStatusCode
      TypeCode
      TypeCodeOtherDescription
      CommonParentIndication
      CommonParentOrganizationLegalName
      CommonParentOrganizationTINHolderStatusCode
      FAR522045

      WomenOwnedBusinessIndication
      FAR522092
      CertIndication
      FAR522095
      DebarmentIndication
      CivilJudgementIndication
      IndictedStatusIndication
      DelinquentFederalStatusIndication
      TerminationForCauseIndication
      FAR522123
      TINHolderStatusCode
      TypeCode
      TypeCodeOtherDescription
      CommonParentIndication
      CommonParentOrganizationLegalName
      CommonParentOrganizationTINHolderStatusCode
      BusinessSizeCode
      NAICSSmallBusinessStatus
                      NAICSCode
                      NAICSExceptionSizeCode
                      NAICSSBCode
      VeteranOwnedSmallBusinessIndication
      NAICSVeteranOwnedSmallBusinessStatus
                      NAICSCode
                      NAICSExceptionSizeCode
                      VOSBStatusCode
      SDVOSBIndication
      NAICSSDVOSmallBusinessStatus
                      NAICSCode
                      NAICSExceptionSizeCode
                      SDVOSBStatusCode
      SDBIndication
WomenOwnedSmallBusinessIndication
NAICSWomenOwnedSmallBusinessStatus
          NAICSCode
          NAICSExceptionSizeCode
          WOSBStatusCode

WOSBIndication
JVWOSBIndication
JVWOSBBusiness
              JVWOSBLegalName
EDWOSBIndication
JVEDWOSBIndication
JVEDWOSBBusiness
              JVEDWOSBLegalName
LaborSurplusArea

               USStateName
               LaborSurplusCountyName
               LaborSurplusJurisdictionDescription
Paragraphc8i
               EmergingSmallBusinessConcernIndication

               NAICSCode

               NAICSExceptionSizeCode

             ESBStatusCode
ParagraphC8iiB

               AverageEmployeeCountCode

              AverageRevenueAmountCode
SDBCertIndication
SDBApplicationSubmissionIndication


JointVentureIndication
JointVentureBusiness
              JointVentureBusinessLegalName
HUBZoneSBIndication


HUBZoneJointVentureSBIndication
HUBZoneJointVentureBusiness
               HUBZoneBusinessLegalName
PriorUSFAR52AwardIndication
EEOComplianceIndication
AffirmativeActionProgramIndication
AffirmativeActionProgramContractIndication
ParagraphFCertIndication
ParagraphF2
               Description
               CountryOfOriginResponse
ParagraphG1ii
              NonDomesticProductDescription
              CountryOfOriginResponse
ParagraphG1iii




                NonDomesticProductDescription
                CountryOfOriginResponse
ParagraphG2
                NonDomesticProductDescription
                CountryOfOriginResponse
ParagraphG3
                NonDomesticProductDescription
                CountryOfOriginResponse
ParagraphG4ii




                NonDomesticProductDescription
               CountryOfOriginResponse
PlaceOfManufacture
               CertIndication
               FSCCode
               PrimaryManufacturingCode
DebarmentIndication
CivilJudgementIndication
IndictedStatusIndication
DelinquentFederalStatusIndication
ChildLaborIndication
ForcedChildLaborUseIndication
ParagraphK1

              CompensationPolicyIndication
ParagraphK2



              ServiceContractExemptionIndication



EthncityCode
SDBAuthorizedRegionIndication
FAR5221414
AltPOPIndication
FAR5221414AltPOP
              AltPOPAddress
              OwnerName
              AltPOPOwnerAddress
FAR522156
AltPOPIndication
FAR522156AltPOP
              AltPOPAddress
              OwnerName
              AltPOPOwnerAddress
FAR522191
BusinessSizeCode
SmallBusinessConcernByNAICS
              NAICSCode
              NAICSExceptionSizeCode
              NAICSSBCode
SDBIndication
WomenOwnedSmallBusinessIndication
NAICSWomenOwnedSmallBusinessStatus
              NAICSCode
              NAICSExceptionSizeCode
              WOSBStatusCode
WOSBIndication
JVWOSBIndication
JVWOSBBusiness
              JVWOSBLegalName
EDWOSBIndication
JVEDWOSBIndication
JVEDWOSBBusiness
            JVEDWOSBLegalName
VeteranOwnedSmallBusinessIndication
NAICSVeteranOwnedSmallBusinessStatus
             NAICSCode
             NAICSExceptionSizeCode
             VOSBStatusCode
SDVOSBIndication
NAICSSDVOSmallBusinessStatus
             NAICSCode
             NAICSExceptionSizeCode
             SDVOSBStatusCode
HUBZoneSBIndication
HUBZoneJointVentureSBIndication
HUBZoneJointVentureBusiness
            HUBZoneBusinessLegalName



EthncityCode
FAR522192
LaborSurplusArea

             USStateName
             LaborSurplusCountyName
             LaborSurplusJurisdictionDescription
FAR5221919
EmergingBusinessConcernIndication
NAICSEmergingSmallBusinessStatus

             NAICSCode

             NAICSExceptionSizeCode

             ESBStatusCode

AverageEmployeeCountCode

AverageRevenueAmountCode
FAR5221921

AverageEmployeeCountCode

AverageRevenueAmountCode
FAR5221922
SDBCertIndication
SDBApplicationSubmissionIndication


JointVentureIndication
JointVentureBusiness
               JointVentureBusinessLegalName
SDBAuthorizedRegionIndication
FAR5222218
ChildLaborIndication
ForcedChildLaborUseIndication
FAR5222222
PriorUSFAR52AwardIndication
EEOComplianceIndication
FAR5222225
AffirmativeActionProgramIndication
AffirmativeActionProgramContractIndication
FAR5222238
CertIndication
FAR5222248

CompensationPolicyIndication
FAR5222252



ServiceContractExemptionIndication
FAR522231
CertIndication
FAR522234
CertIndication
FAR522239
USEPAGuidanceComplianceCode
FAR5222313

USEPCRAToxicFacilityUsageIndication

USEPCRAEmployeesIndication

USEPCRAReportThresholdIndication

NAICSSICToxicFacilityUsageIndication

ToxicFacilityUSLocationIndication
FAR522252
CertIndication
FAR522252ParagraphB
             NonDomesticProductDescription
             CountryOfOriginResponse
FAR522254
CertIndication
FAR522254ParagraphB
             NonDomesticProductDescription
             CountryOfOriginResponse
FAR522254ParagraphC
             NonDomesticProductDescription
             CountryOfOriginResponse
FAR522254ParagraphBAlternate1
             NonDomesticProductDescription
             CountryOfOriginResponse
FAR522254ParagraphBAlternate2
            NonDomesticProductDescription
            CountryOfOriginResponse
FAR522256
CertIndication
FAR522256ParagraphB




            NonDomesticProductDescription
            CountryOfOriginResponse
FAR5222518
CertIndication
PrimaryManufacturing

           FSCCode

             PrimaryManufacturingCode
FAR5222520
CertIndication
FAR5222525
CertIndication
FAR522262
HBCUIndication
MinorityInstitutionIndication
FAR522276
CertIndication
FAR5222715
FAR5222715ParagraphC
LimitedRightsProducts
             LimitedRightsProductName
SF330 PROVISIONS
       SF330PartII
       CertIndication

       HTMLURL


       PDFURL
       ACASSNumber
       FormerFirmName
                 FirmName
                 YearEstablished
                 DUNSID
       EmployeesByDiscipline
                 Code
                 Discipline
                 FirmCount
                 BranchCount
       EmployeesByDisciplineFirmTotal
       EmployeesByDisciplineBranchTotal
       AnnualRevenueByFirmExperience
                 Code
                 Description
                 RevenueIndexNumber
       AnnualAverageProfessionalServicesRevenues
                 Federal
                 NonFederal
                 Total


       SF330OwnerShipType




       SF330SmallBusinessStatus
       SF330Block7FirmName


       SF330AuthorizedRepresentativeName
       SF330AuthorizedRepresentativeTitle

DFARS PROVISIONS
       DFARS2522097001
       CertIndication
       DFARS2522097002
       OwnedByForeignGovernmentIndicator
       DisclosureCertContact
            GivenName
            MiddleName
            FamilyName
            Telephone
            Extension
            NonUSTelephone
OwnedByForeignGovernment
            LegalName
            Street
            AdditionalStreet
            CityName
            CountrySubEntityCode
            USZipCode
            USPostalZonePlus4
            PostalZone
            CountryIdentificationCode
            OwnershipDescription
            OwnershipPercentage
            ForeignGovernmentOwnerCountryName
DFARS2522097005
CertIndication
DFARS2522127000
CertIndication
DFARS2522167003
CertIndication
CountryIdentificationCode
DFARS2522257000
CertIndication
ParagraphC2ForeignEndProducts


          NonDomesticProductDescription
          CountryOfOriginResponse
ParagraphC3ForeignEndProducts



            NonDomesticProductDescription
            CountryOfOriginResponse
DFARS2522257003
CertIndication
DFARS2522257020
CertIndication
ParagraphC2ForeignEndProducts
            NonDomesticProductDescription
            CountryOfOriginResponse
DFARS2522257031
CertIndication
DFARS2522257035
CertIndication
ParagraphC2iForeignEndProducts




          NonDomesticProductDescription
          CountryOfOriginResponse
ParagraphC2iiForeignEndProducts



          NonDomesticProductDescription
          CountryOfOriginResponse
ParagraphC2iiiForeignEndProducts




            NonDomesticProductDescription
            CountryOfOriginResponse
DFARS2522257042
CertIndication
DFARS2522297003
CertIndication
DFARS2522297005
CertIndication
DFARS2522397011
CertIndication
DFARS2522477022
CertIndication
DFARS2522477023
CertIndication


**Missing Data Elements: FAR and DFARS Provisions**


HTMLURL


PDFURL
XML SimpleType Element                        XML SimpleType   XML SimpleType
(Lowest Level)                                DataType         Element Length




Name                                          string           60
Title                                         string           100

CertIndication                                string           ([ ]){0}|([0-3]){1}

TINHolderStatusCode                           string           ([ ]){0}|([1-5]){1}
TypeCode                                      string           ([ ]){0}|([0-9A-Z]){2}
TypeCodeOtherDescription                      string           100
CommonParentIndication                        string           ([ ]){0}|([0-1]){1}
CommonParentOrganizationLegalName             string           120
CommonParentOrganizationTINHolderStatusCode   string           30


WomenOwnedBusinessIndication                  string           ([ ]){0}|([0-1]){1}

CertIndication                                string           ([ ]){0}|([0-3]){1}

DebarmentIndication                           string           ([ ]){0}|([0-1]){1}
CivilJudgementIndication                      string           ([ ]){0}|([0-1]){1}
IndictedStatusIndication                      string           ([ ]){0}|([0-1]){1}
DelinquentFederalStatusIndication             string           ([ ]){0}|([0-1]){1}
TerminationForCauseIndication                 string           ([ ]){0}|([0-1]){1}

TINHolderStatusCode                           string           ([ ]){0}|([1-5]){1}
TypeCode                                      string           ([ ]){0}|([0-9A-Z]){2}
TypeCodeOtherDescription                      string           100
CommonParentIndication                        string           ([ ]){0}|([0-1]){1}
CommonParentOrganizationLegalName             string           120
CommonParentOrganizationTINHolderStatusCode   string           30
BusinessSizeCode                              string           ([ ]){0}|([0-2]){1}

NAICSCode                                     string           ([ ]){0}|([0-9]){6}
NAICSExceptionSizeCode                        string           ([ ]){0}|([1-4]){1}
NAICSSBCode                                   string           ([ ]){0}|([0-2]){1}
VeteranOwnedSmallBusinessIndication           string           ([ ]){0}|([0-2]){1}

NAICSCode                                     string           ([ ]){0}|([0-9]){6}
NAICSExceptionSizeCode                        string           ([ ]){0}|([1-4]){1}
VOSBStatusCode                                string           ([ ]){0}|([0-2]){1}
SDVOSBIndication                              string           ([ ]){0}|([0-2]){1}

NAICSCode                                     string           ([ ]){0}|([0-9]){6}
NAICSExceptionSizeCode                        string           ([ ]){0}|([1-4]){1}
SDVOSBStatusCode                              string           ([ ]){0}|([0-2]){1}
SDBIndication                                 string           ([ ]){0}|([0-1]){1}
WomenOwnedSmallBusinessIndication            string   ([ ]){0}|([0-1]){1}

NAICSCode                                    string   ([ ]){0}|([0-9]){6}
NAICSExceptionSizeCode                       string   ([ ]){0}|([1-4]){1}
WOSBStatusCode                               string   ([ ]){0}|([0-2]){1}

WOSBIndication                               string   ([ ]){0}|([0-1]){1
JVWOSBIndication                             string   ([ ]){0}|([0-1]){1}

JVWOSBLegalName                              string   120
EDWOSBIndication                             string   ([ ]){0}|([0-1]){1}
JVEDWOSBIndication                           string   ([ ]){0}|([0-1]){1}

JVEDWOSBLegalName                            string   120


USStateName                                  string   30
LaborSurplusCountyName                       string   100
LaborSurplusJurisdictionDescription          string   200

EmergingSmallBusinessConcernIndication       string   ([ ]){0}|([0-2]){1}

NAICSCode                                    string   ([ ]){0}|([0-9]){6}

NAICSExceptionSizeCode                       string   ([ ]){0}|([1-4]){1}

ESBStatusCode                                string   ([ ]){0}|([0-2]){1}


AverageEmployeeCountCode                     string   ([ ]){0}|([0-7]){1}

AverageRevenueAmountCode                     string   ([ ]){0}|([0-7]){1}
SDBCertIndication                            string   ([ ]){0}|([0-1]){1}
SDBApplicationSubmissionIndication           string   ([ ]){0}|([0-1]){1}


JointVentureIndication                       string   ([ ]){0}|([0-2]){1}

JointVentureBusinessLegalName                string   120
HUBZoneSBIndication                          string   ([ ]){0}|([0-1]){1}


HUBZoneJointVentureSBIndication              string   ([ ]){0}|([0-1]){1}

HUBZoneBusinessLegalName                     string   120
PriorUSFAR52AwardIndication                  string   ([ ]){0}|([0-1]){1}
EEOComplianceIndication                      string   ([ ]){0}|([0-1]){1
AffirmativeActionProgramIndication           string   ([ ]){0}|([0-1]){1}
AffirmativeActionProgramContractIndication   string   ([ ]){0}|([0-1]){1}
ParagraphFCertIndication                     string   ([ ]){0}|([0-3]){1}

Description                                  string   100
CountryOfOriginResponse                      string   100
NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100




NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100

NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100

NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100




NonDomesticProductDescription   string   100
CountryOfOriginResponse              string   100

CertIndication                       string   ([ ]){0}|([0-3]){1}
FSCCode                              string   ([ ]){0}|([0-9]){4}
PrimaryManufacturingCode             string   ([ ]){0}|([0-2]){1}
DebarmentIndication                  string   ([ ]){0}|([0-1]){1}
CivilJudgementIndication             string   ([ ]){0}|([0-1]){1}
IndictedStatusIndication             string   ([ ]){0}|([0-1]){1}
DelinquentFederalStatusIndication    string   ([ ]){0}|([0-1]){1}
ChildLaborIndication                 string   ([ ]){0}|([0-1]){1}
ForcedChildLaborUseIndication        string   ([ ]){0}|([0-1]){1}


CompensationPolicyIndication         string   ([ ]){0}|([0-2]){1}




ServiceContractExemptionIndication   string   ([ ]){0}|([0-2]){1}



EthncityCode                         string   ([ ]){0}|([0-6]){1}
SDBAuthorizedRegionIndication        string   ([ ]){0}|([0-1]){1}

AltPOPIndication                     string   ([ ]){0}|([0-1]){1}

AltPOPAddress                        string   300
OwnerName                            string   55
AltPOPOwnerAddress                   string   300

AltPOPIndication                     string   ([ ]){0}|([0-1]){1}

AltPOPAddress                        string   300
OwnerName                            string   55
AltPOPOwnerAddress                   string   300

BusinessSizeCode                     string   ([ ]){0}|([0-2]){1}

NAICSCode                            string   ([ ]){0}|([0-9]){6}
NAICSExceptionSizeCode               string   ([ ]){0}|([1-4]){1}
NAICSSBCode                          string   ([ ]){0}|([0-2]){1}
SDBIndication                        string   ([ ]){0}|([0-1]){1}
WomenOwnedSmallBusinessIndication    string   ([ ]){0}|([0-1]){1}

NAICSCode                            string   ([ ]){0}|([0-9]){6}
NAICSExceptionSizeCode               string   ([ ]){0}|([1-4]){1}
WOSBStatusCode                       string   ([ ]){0}|([0-2]){1}
WOSBIndication                       string   ([ ]){0}|([0-1]){1
JVWOSBIndication                     string   ([ ]){0}|([0-1]){1}

JVWOSBLegalName                      string   120
EDWOSBIndication                     string   ([ ]){0}|([0-1]){1}
JVEDWOSBIndication                    string   ([ ]){0}|([0-1]){1}

JVEDWOSBLegalName                     string   120
VeteranOwnedSmallBusinessIndication   string   ([ ]){0}|([0-2]){1}

NAICSCode                             string   ([ ]){0}|([0-9]){6}
NAICSExceptionSizeCode                string   ([ ]){0}|([1-4]){1}
VOSBStatusCode                        string   ([ ]){0}|([0-2]){1}
SDVOSBIndication                      string   ([ ]){0}|([0-2]){1}

NAICSCode                             string   ([ ]){0}|([0-9]){6}
NAICSExceptionSizeCode                string   ([ ]){0}|([1-4]){1}
SDVOSBStatusCode                      string   ([ ]){0}|([0-2]){1}
HUBZoneSBIndication                   string   ([ ]){0}|([0-1]){1}
HUBZoneJointVentureSBIndication       string   ([ ]){0}|([0-1]){1}

HUBZoneBusinessLegalName              string   120



EthncityCode                          string   ([ ]){0}|([0-6]){1}




USStateName                           string   30
LaborSurplusCountyName                string   100
LaborSurplusJurisdictionDescription   string   200

EmergingBusinessConcernIndication     string   ([ ]){0}|([0-2]){1}


NAICSCode                             string   ([ ]){0}|([0-9]){6}

NAICSExceptionSizeCode                string   ([ ]){0}|([1-4]){1}

ESBStatusCode                         string   ([ ]){0}|([0-2]){1}

AverageEmployeeCountCode              string   ([ ]){0}|([0-7]){1}

AverageRevenueAmountCode              string   ([ ]){0}|([0-7]){1}


AverageEmployeeCountCode              string   ([ ]){0}|([0-7]){1}

AverageRevenueAmountCode              string   ([ ]){0}|([0-7]){1}

SDBCertIndication                     string   ([ ]){0}|([0-1]){1}
SDBApplicationSubmissionIndication    string   ([ ]){0}|([0-1]){1}


JointVentureIndication                string   ([ ]){0}|([0-2]){1}

JointVentureBusinessLegalName         string   120
SDBAuthorizedRegionIndication         string   ([ ]){0}|([0-1]){1}
ChildLaborIndication                         string   ([ ]){0}|([0-1]){1}
ForcedChildLaborUseIndication                string   ([ ]){0}|([0-1]){1}

PriorUSFAR52AwardIndication                  string   ([ ]){0}|([0-1]){1}
EEOComplianceIndication                      string   ([ ]){0}|([0-1]){1

AffirmativeActionProgramIndication           string   ([ ]){0}|([0-1]){1}
AffirmativeActionProgramContractIndication   string   ([ ]){0}|([0-1]){1}

CertIndication                               string   ([ ]){0}|([0-3]){1}


CompensationPolicyIndication                 string   ([ ]){0}|([0-2]){1}




ServiceContractExemptionIndication           string   ([ ]){0}|([0-2]){1}

CertIndication                               string   ([ ]){0}|([0-3]){1}

CertIndication                               string   ([ ]){0}|([0-3]){1}

USEPAGuidanceComplianceCode                  string   ([ ]){0}|([0-2]){1}


USEPCRAToxicFacilityUsageIndication          string   ([ ]){0}|([0-2]){1}

USEPCRAEmployeesIndication                   string   ([ ]){0}|([0-1]){1}

USEPCRAReportThresholdIndication             string   ([ ]){0}|([0-1]){1}

NAICSSICToxicFacilityUsageIndication         string   ([ ]){0}|([0-1]){1}

ToxicFacilityUSLocationIndication            string   ([ ]){0}|([0-1]){1}

CertIndication                               string   ([ ]){0}|([0-3]){1}

NonDomesticProductDescription                string   100
CountryOfOriginResponse                      string   100

CertIndication                               string   ([ ]){0}|([0-3]){1}

NonDomesticProductDescription                string   100
CountryOfOriginResponse                      string   100

NonDomesticProductDescription                string   100
CountryOfOriginResponse                      string   100

NonDomesticProductDescription                string   100
CountryOfOriginResponse                      string   100
NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100

CertIndication                  string   ([ ]){0}|([0-3]){1}




NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100

CertIndication                  string   ([ ]){0}|([0-3]){1}


FSCCode                         string   ([ ]){0}|([0-9]){4}

PrimaryManufacturingCode        string   ([ ]){0}|([0-2]){1}

CertIndication                  string   ([ ]){0}|([0-3]){1}

CertIndication                  string   ([ ]){0}|([0-3]){1}

HBCUIndication                  string   ([ ]){0}|([0-1]){1}
MinorityInstitutionIndication   string   ([ ]){0}|([0-1]){1}

CertIndication                  string   ([ ]){0}|([0-3]){1}

FAR5222715ParagraphC            string   ([ ]){0}|([0-2]){1}

LimitedRightsProductName        string   100
CertIndication                       string   ([ ]){0}|([0-3]){1}

HTMLURL                              string   200


PDFURL                               string   200
ACASSNumber                          string   9

FirmName                             string   120
YearEstablished                      string   ([ ]){0}|([0-9]){4}
DUNSID                               string   ([ ]){0}|([0-9A-Z]){9}

Code                                 string   ([ ]){0}|([0-9]){1, 2}
Discipline                           string   100
FirmCount                            string   6
BranchCount                          string   6
EmployeesByDisciplineFirmTotal       string   6
EmployeesByDisciplineBranchTotal     string   6

Code                                 string   ([ ]){0}|([0-9]){1, 2}
Description                          string   100
RevenueIndexNumber                   string   ([ ]){0}|([0-9]){1,2}

Federal                              string   ([ ]){0}|([0-9]){1,2}
NonFederal                           string   ([ ]){0}|([0-9]){1,2}
Total                                string   ([ ]){0}|([0-9]){1,2}


SF330OwnerShipType                   string   100




SF330SmallBusinessStatus             string   30
SF330Block7FirmName                  string   120


SF330AuthorizedRepresentativeName    string   60
SF330AuthorizedRepresentativeTitle   string   50




CertIndication                       string   ([ ]){0}|([0-3]){1}

OwnedByForeignGovernmentIndicator    string   ([ ]){0}|([0-1]){1}
GivenName                           string   28
MiddleName                          string   1
FamilyName                          string   28
Telephone                           string   ([ ]){0}|([0-9]){10}
Extension                           string   ([0-9]){0,6}
NonUSTelephone                      string   30

LegalName                           string   120
Street                              string   55
AdditionalStreet                    string   55
CityName                            string   35
CountrySubEntityCode                string   ([ ]){0}|([A-Z]){2}
USZipCode                           string   5
USPostalZonePlus4                   string   4
PostalZone                          string   35
CountryIdentificationCode           string   ([ ]){0}|([A-Z]){3}
OwnershipDescription                string   1000
OwnershipPercentage                 string   22
ForeignGovernmentOwnerCountryName   string   3

CertIndication                      string   ([ ]){0}|([0-3]){1}

CertIndication                      string   ([ ]){0}|([0-3]){1}

CertIndication                      string   ([ ]){0}|([0-3]){1}
CountryIdentificationCode           string   ([ ]){0}|([A-Z]){3}

CertIndication                      string   ([ ]){0}|([0-3]){1}



NonDomesticProductDescription       string   100
CountryOfOriginResponse             string   100




NonDomesticProductDescription       string   100
CountryOfOriginResponse             string   100

CertIndication                      string   ([ ]){0}|([0-3]){1}

CertIndication                      string   ([ ]){0}|([0-3]){1}
NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100

CertIndication                  string   ([ ]){0}|([0-3]){1}

CertIndication                  string   ([ ]){0}|([0-3]){1}




NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100




NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100




NonDomesticProductDescription   string   100
CountryOfOriginResponse         string   100

CertIndication                  string   ([ ]){0}|([0-3]){1}
CertIndication   string   ([ ]){0}|([0-3]){1}

CertIndication   string   ([ ]){0}|([0-3]){1}

CertIndication   string   ([ ]){0}|([0-3]){1}

CertIndication   string   ([ ]){0}|([0-3]){1}

CertIndication   string   ([ ]){0}|([0-3]){1}




HTMLURL          string   200


PDFURL           string   200
ORCA Table Name   ORCA Column Name




BIDS_RESP_POC     Name
BIDS_RESP_POC     Title


ORCA_VENDOR       CERTFPAGE_RADIO_BUTTON1


ORCA_VENDOR       TIN_STATUS
ORCA_VENDOR       ORG_TYPE_CD
ORCA_VENDOR       OTHER_ORGTYPE_DESC
ORCA_VENDOR       PARENT_DUNS
ORCA_VENDOR       PARENT_COMPANYNAME
ORCA_VENDOR       PARENT_TIN



ORCA_VENDOR       WOMEN_BC


ORCA_VENDOR       CERTFPAGE_RADIO_BUTTON7


ORCA_VENDOR       DEBARRED_STATUS
ORCA_VENDOR       CONVICTED_STATUS
ORCA_VENDOR       INDICTED_STATUS
ORCA_VENDOR       DELINQUENT_FED_STATUS
ORCA_VENDOR       TERM_CAUSE_STATUS


ORCA_VENDOR       TIN_STATUS
ORCA_VENDOR       ORG_TYPE_CD
ORCA_VENDOR       OTHER_ORGTYPE_DESC
ORCA_VENDOR       PARENT_DUNS
ORCA_VENDOR       PARENT_COMPANYNAME
ORCA_VENDOR       PARENT_TIN



ORCA_SBA          NAICS
ORCA_SBA          NAICS_TYPE
ORCA_SBA          VET_SMALL_BC



ORCA_SBA          NAICS
ORCA_SBA          NAICS_TYPE
ORCA_SBA          SERDIS_VET_SMALL_BC



ORCA_SBA          NAICS
ORCA_SBA          NAICS_TYPE
ORCA_SBA          SMALL_BC
ORCA_VENDOR       sbacert_small_disad_bus
ORCA_SBA                    NAICS
ORCA_SBA                    NAICS_TYPE
ORCA_SBA                    WOMEN_SMALL_BC

ORCA_VENDOR                 WOMEN_OWNED_SMALL_BUS
ORCA_VENDOR                 JV_WOMEN_OWNED_SMALL_BUS


JOINT_VENTURE_WOSB          LEGAL_BUSNAME
ORCA_VENDOR                 ED_WOMEN_OWNED_SMALL_BUS
ORCA_VENDOR                 JV_ED_WOMEN_OWNED_SMALL_BUS


JOINT_VENTURE_EDWOSB        LEGAL_BUSNAME



ORCALABOR_SURPLUS_LOC       STATE
ORCALABOR_SURPLUS_LOC       SURPLUS_AREA
ORCALABOR_SURPLUS_LOC       JURISDICTION


                            Always Empty

ORCA_ESBC                   NAICS

ORCA_ESBC                   NAICS_TYPE

ORCA_ESBC                   SMALL_BC



ORCA_VENDOR                 AVG_NUM_EMPLOYEES

ORCA_VENDOR                 ANNUAL_REVENUE
ORCA_VENDOR                 sbacert_small_disad_bus
ORCA_VENDOR                 sbacert_small_disad_bus



joint_venture_business      LEGAL_BUSNAME


joint_venture_business      LEGAL_BUSNAME
ORCA_VENDOR                 sbacert_hub



hubjoint_venture_business   LEGAL_BUSNAME


hubjoint_venture_business   LEGAL_BUSNAME
ORCA_VENDOR                 PREV_CONTRACTS
ORCA_VENDOR                 EOE_COMPLIANCE
ORCA_VENDOR                 LABOR_AFFACTN_PROGRAM
ORCA_VENDOR                 PREV_CONTRACTS_AFFACTN_PROG
ORCA_VENDOR                 foreign_products_status


FOREIGN_PRODUCTS            DESCRIPTION
FOREIGN_PRODUCTS            COUNTRY
FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY




FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY


FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY


FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY




FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS     COUNTRY



ORCA_FSC             fsc
ORCA_FSC             manfac_country_status
ORCA_VENDOR          DEBARRED_STATUS
ORCA_VENDOR          CONVICTED_STATUS
ORCA_VENDOR          INDICTED_STATUS
ORCA_VENDOR          DELINQUENT_FED_STATUS
ORCA_VENDOR          child_labor_products
ORCA_VENDOR          forced_child_labor

                     itequip_supplier, equipment_trade, contract_price,
ORCA_VENDOR          compensation_policy



                     services_supplier, services_sold,
                     services_contract_price, services_contract_period,
ORCA_VENDOR          services_compensation_policy

                     ethnicity_blackamerican, ethnicity_hispanicamerican,
                     ethnicity_nativeamerican, ethnicity_asianamerican,
ORCA_VENDOR          ethnicity_asianIndian,ethnicity_other
ORCA_VENDOR          small_disad_proc_region


ORCA_VENDOR          OTHER_PLACE_PERF_STATUS


OTHER_PLACE_PERF     ADDRESS
OTHER_PLACE_PERF     OWNER_NAME
OTHER_PLACE_PERF     OWNER_ADDRESS


ORCA_VENDOR          OTHER_PLACE_PERF_STATUS


OTHER_PLACE_PERF     ADDRESS
OTHER_PLACE_PERF     OWNER_NAME
OTHER_PLACE_PERF     OWNER_ADDRESS




ORCA_SBA             NAICS
ORCA_SBA             NAICS_TYPE
ORCA_SBA             SMALL_BC
ORCA_VENDOR          sbacert_small_disad_bus



ORCA_SBA             NAICS
ORCA_SBA             NAICS_TYPE
ORCA_SBA             WOMEN_SMALL_BC
ORCA_VENDOR          WOMEN_OWNED_SMALL_BUS
ORCA_VENDOR          JV_WOMEN_OWNED_SMALL_BUS


JOINT_VENTURE_WOSB   LEGAL_BUSNAME
ORCA_VENDOR          ED_WOMEN_OWNED_SMALL_BUS
ORCA_VENDOR                 JV_ED_WOMEN_OWNED_SMALL_BUS


JOINT_VENTURE_EDWOSB        LEGAL_BUSNAME



ORCA_SBA                    NAICS
ORCA_SBA                    NAICS_TYPE
ORCA_SBA                    VET_SMALL_BC



ORCA_SBA                    NAICS
ORCA_SBA                    NAICS_TYPE
ORCA_SBA                    SERDIS_VET_SMALL_BC
ORCA_VENDOR                 sbacert_hub
hubjoint_venture_business   LEGAL_BUSNAME


hubjoint_venture_business   LEGAL_BUSNAME

                            ethnicity_blackamerican, ethnicity_hispanicamerican,
                            ethnicity_nativeamerican, ethnicity_asianamerican,
ORCA_VENDOR                 ethnicity_asianIndian,ethnicity_other




ORCALABOR_SURPLUS_LOC       STATE
ORCALABOR_SURPLUS_LOC       SURPLUS_AREA
ORCALABOR_SURPLUS_LOC       JURISDICTION




ORCA_ESBC                   NAICS

ORCA_ESBC                   NAICS_TYPE

ORCA_ESBC                   SMALL_BC

ORCA_VENDOR                 AVG_NUM_EMPLOYEES

ORCA_VENDOR                 ANNUAL_REVENUE



ORCA_VENDOR                 AVG_NUM_EMPLOYEES

ORCA_VENDOR                 ANNUAL_REVENUE


ORCA_VENDOR                 sbacert_small_disad_bus
ORCA_VENDOR                 sbacert_small_disad_bus



joint_venture_business      LEGAL_BUSNAME


joint_venture_business      LEGAL_BUSNAME
ORCA_VENDOR                 small_disad_proc_region
ORCA_VENDOR        CHILD_LABOR_PRODUCTS
ORCA_VENDOR        FORCED_CHILD_LABOR


ORCA_VENDOR        PREV_CONTRACTS
ORCA_VENDOR        EOE_COMPLIANCE


ORCA_VENDOR        LABOR_AFFACTN_PROGRAM
ORCA_VENDOR        PREV_CONTRACTS_AFFACTN_PROG


ORCA_VENDOR        CERTFPAGE_RADIO_BUTTON2


                   itequip_supplier, equipment_trade, contract_price,
ORCA_VENDOR        compensation_policy



                   services_supplier, services_sold,
                   services_contract_price, services_contract_period,
ORCA_VENDOR        services_compensation_policy


ORCA_VENDOR        CERTFPAGE_RADIO_BUTTON3


ORCA_VENDOR        epa_compliance


ORCA_VENDOR        epa_compliance



ORCA_VENDOR        epcra_status

ORCA_VENDOR        epcra_employees

ORCA_VENDOR        epcra_reporting

ORCA_VENDOR        epcra_naicssic_toxfacility

ORCA_VENDOR        epcra_naicssic_location


ORCA_VENDOR        foreign_products_status


FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY


ORCA_VENDOR        foreign_products_status


FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY


FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY


FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY
FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY


ORCA_VENDOR        foreign_products_status




FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY




ORCA_FSC           fsc

ORCA_FSC           manfac_country_status


ORCA_VENDOR        CERTFPAGE_RADIO_BUTTON4


ORCA_VENDOR        CERTFPAGE_RADIO_BUTTON6


ORCA_VENDOR        black_university
ORCA_VENDOR        minority_institution


ORCA_VENDOR        CERTFPAGE_RADIO_BUTTON5


ORCA_VENDOR        GOVT_REST_SFTWRE_STATUS

GOVT_REST_SFTWRE   NAME
ORCA_VENDOR             ARCH_ENG_APP_STATUS




ORCA_VENDOR             ACASS_NUMBER


ARCH_ENG_FORMER_NAME    LEGAL_BUSNAME
ARCH_ENG_FORMER_NAME    BUS_START_DATE
ARCH_ENG_FORMER_NAME    DUNS_STRING


ARCH_ENG_EMP_DISP       DISCIPLINE_CODE
ARCH_ENG_EMP_DISP       DESCRIPTION
ARCH_ENG_EMP_DISP       FIRM_EMP_COUNT
ARCH_ENG_EMP_DISP       BRANCH_EMP_COUNT
ARCH_ENG_EMP_DISP       FIRM_EMP_COUNT
ARCH_ENG_EMP_DISP       BRANCH_EMP_COUNT


ARCH_ENG_EXP_PROFILE    PROFILE_CODE
ARCH_ENG_EXP_PROFILE    DESCRIPTION
ARCH_ENG_EXP_PROFILE    REVENUE_INDEX_ID


ORCA_VENDOR             ARCH_ENG_FED_REVENUE_ID
ORCA_VENDOR             ARCH_ENG_NONFED_REVENUE_ID
ORCA_VENDOR             ARCH_ENG_TOTAL_REVENUE_ID



ORG_TYPE, ORCA_VENDOR   DESCRIPTION, OTHER_ORGTYPE_DESC




ORCA_VENDOR             arch_eng_small_bus_status
ORCA_VENDOR             PARENT_COMPANYNAME
                        ARCH_ENG_REP_FIRST_NAME,
                        ARCH_ENG_REP_MIDDLE_INIT,
ORCA_VENDOR             ARCH_ENG_REP_LAST_NAME
ORCA_VENDOR             ARCH_ENG_REP_TITLE




ORCA_VENDOR             DF2097001_STATUS


ORCA_VENDOR             DF2097002_STATUS
ORCA_VENDOR              DF2097002_poc_first_name
ORCA_VENDOR              DF2097002_poc_middle_init
ORCA_VENDOR              DF2097002_poc_last_name
ORCA_VENDOR              DF2097002_phone
ORCA_VENDOR              DF2097002_phone_ext
ORCA_VENDOR              DF2097002_nonus_phone


DF_ENTITY_FOREIGN_GOVT   legal_busname
DF_ENTITY_FOREIGN_GOVT   address1
DF_ENTITY_FOREIGN_GOVT   address2
DF_ENTITY_FOREIGN_GOVT   city
DF_ENTITY_FOREIGN_GOVT   STATE
DF_ENTITY_FOREIGN_GOVT   zip
DF_ENTITY_FOREIGN_GOVT   zip_plus4
DF_ENTITY_FOREIGN_GOVT   postal_code
DF_ENTITY_FOREIGN_GOVT   country_code
DF_ENTITY_FOREIGN_GOVT   INTEREST_DESC
DF_ENTITY_FOREIGN_GOVT   OWNERSHIP_PERC
DF_ENTITY_FOREIGN_GOVT   FOREIGNGOVT_COUNTRY_CODE


ORCA_VENDOR              DF2097005_STATUS


ORCA_VENDOR              DF2127000_SEA_SUPPLY_STATUS


ORCA_VENDOR              DF2167003_STATUS
ORCA_VENDOR              DF2167003_COUNTRY_CODE


ORCA_VENDOR              foreign_products_status




FOREIGN_PRODUCTS         DESCRIPTION
FOREIGN_PRODUCTS         COUNTRY




FOREIGN_PRODUCTS         DESCRIPTION
FOREIGN_PRODUCTS         COUNTRY


ORCA_VENDOR              DF2257003_STATUS


ORCA_VENDOR              foreign_products_status
FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY


ORCA_VENDOR        DF2257031_STATUS


ORCA_VENDOR        foreign_products_status




FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY




FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY




FOREIGN_PRODUCTS   DESCRIPTION
FOREIGN_PRODUCTS   COUNTRY


ORCA_VENDOR        DF2257042_STATUS
ORCA_VENDOR   DF2297003_STATUS


ORCA_VENDOR   DF2297005_STATUS


ORCA_VENDOR   DF2397011_STATUS


ORCA_VENDOR   DF2127000_SEA_SUPPLY_STATUS


ORCA_VENDOR   DF2477023_STATUS
ORCA Transformation Rule
(If Any)




If ORG_TYPE_CD is 'ZZ'
If PARENT_DUNS null then 0 else 1
If CommonParentIndication is 1 then send this element
If CommonParentIndication is 1 then send this element


vendor is small business for all the NAICS and it is women owned
then 1


Added on July 14, 2011 at 11pm




If ORG_TYPE_CD is 'ZZ'
If PARENT_DUNS null then 0 else 1
If CommonParentIndication is 1 then send this element
If CommonParentIndication is 1 then send this element
Always empty




Always empty




Always empty
Always empty




If WOMEN_SMALL_BC exists then 1 else 0; Added Apr 4, 2011
11pm
Added on Apr 4, 2011 at 11pm


Added on Apr 4, 2011 at 11pm
Added on Apr 4, 2011 at 11pm
Added on Apr 4, 2011 at 11pm


Added on Apr 4, 2011 at 11pm




Data is no longer sent for records submitted in ORCA after Feb 16,
2011
Data is no longer sent for records submitted in ORCA after Feb 16,
2011
Data is no longer sent for records submitted in ORCA after Feb 16,
2011

Data is no longer sent for records submitted in ORCA after Feb 16,
2011
Data is no longer sent for records submitted in ORCA after Feb 16,
2011




If record exists in
JOINT_VENTURE_BUSINESS.LEGAL_BUSNAME then 1 else 0




If record exists in hubjoint_venture_business.LEGAL_BUSNAME
exists then 1 else 0




if 0 then 0 elseif 1 then 1 elseif 5 then 2


List all the products entered.
List of products those are IN Free Trade countries (
Version 1 :
'AUSTRALIA','CANADA','ISRAEL','MEXICO','CHILE','SINGAPORE';
Between Version 2 and 16:
'AUSTRALIA','CANADA','ISRAEL','MEXICO','CHILE','SINGAPORE','
EL SALVADOR','HONDURAS','NICARAGUA'; Version 16 and up :
'AUSTRALIA','CANADA', 'CHILE','COSTA RICA', 'DOMINICAN
REPUBLIC','EL
SALVADOR','GUATEMALA','HONDURAS','ISRAEL','MEXICO','NIC
ARAGUA','SINGAPORE')




List of the products those are NOT IN Free Trade countries (
Version 1 :
'AUSTRALIA','CANADA','ISRAEL','MEXICO','CHILE','SINGAPORE';
Between Version 2 and 16 :
'AUSTRALIA','CANADA','ISRAEL','MEXICO','CHILE','SINGAPORE','
EL SALVADOR','HONDURAS','NICARAGUA';
Version 16 and up : 'AUSTRALIA','CANADA', 'CHILE','COSTA
RICA', 'DOMINICAN REPUBLIC','EL
SALVADOR','GUATEMALA','HONDURAS','ISRAEL','MEXICO','NIC
ARAGUA','SINGAPORE')



List of products those are IN CANADA



List of products those are IN CANADA and ISRAEL


List of products those are NOT IN the following countries (
Version 1 to 16 : 'CANADA','MEXICO','ISRAEL','ANTIGUA AND
BARBUDA','ARUBA','BAHAMAS','BARBADOS','BELIZE','BRITISH
VIRGIN ISLANDS','COSTA RICA','DOMINICA','EL
SALVADOR','GRENADA','GUATEMALA','GUYANA' 'HAITI'
'JAMAICA' ,'MONTSERRAT' ,'NETHERLANDS ANTILLES'
,'NICARAGUA','ST. KITTS AND NEVIS' ,'ST. LUCIA' ,'ST.
VINCENT AND THE GRENADINES' ,'TRINIDAD' ,'TOBAGO',
'ARUBA' ,'AUSTRIA' ,'BANGLADESH' ,'BELGIUM' ,'BENIN'
,'BHUTAN' ,'BOTSWANA', 'BURKINA FASO' ,'BURUNDI'
,'CANADA' ,'CAPE VERDE' ,'CENTRAL AFRICAN' ,'REPUBLIC'
,'CHAD' ,'COMOROS' ,'DENMARK' ,'DJIBOUTI' ,'EQUATORIAL
GUINEA' ,'FINLAND' ,'FRANCE' ,'GAMBIA' ,'GERMANY'
,'GREECE' ,'GUINEA' ,'GUINEA-BISSAU' ,'HAITI' ,'HONG KONG'
,'ICELAND' ,'IRELAND' ,'ISRAEL' ,'ITALY' ,'JAPAN' ,'KIRIBATI'
,'KOREA, REPUBLIC OF' ,'LESOTHO' ,'LIECHTENSTEIN'
,'LUXEMBOURG' ,'MALAWI' ,'MALDIVES' ,'MALI' ,'MOZAMBIQUE'
,'NEPAL' ,'NETHERLANDS' ,'NIGER' ,'NORWAY' ,'PORTUGAL'
,'RWANDA' ,'SAO TOME AND PRINCIPE' ,'SIERRA LEONE'
,'SINGAPORE' ,'SOMALIA' ,'SPAIN' ,'SWEDEN' ,'SWITZERLAND'
,'TANZANIA U.R.' ,'TOGO' ,'UVALU' ,'UGANDA' ,'UNITED
KINGDOM' ,'VANUATU' ,'WESTERN SAMOA';
Version 17 and up : 'AUSTRALIA','CANADA', 'CHILE','COSTA
RICA', 'DOMINICAN REPUBLIC','EL
SALVADOR','GUATEMALA','HONDURAS','ISRAEL','MEXICO','NIC
ARAGUA','SINGAPORE','ARUBA', 'AUSTRIA', 'BELGIUM',
'BULGARIA', 'CANADA', 'CYPRUS', 'CZECH REPUBLIC',
Always empty




If itequip_supplier is null then output is 2. If all of the field is 1 then
output is 1 else output is 0.




If service_supplier is null then output is 2. If all of the field is 1 then
output is 1 else output is 0.



if small_disad_bus is 0 and sbacert_small_disad_bus not equal to 1
then 0 else output the ethnicity code




Always empty




Always empty




Added on Apr 4, 2011 at 11pm
Added on Apr 4, 2011 at 11pm


Added on Apr 4, 2011 at 11pm
Added on Apr 4, 2011 at 11pm
Added on Apr 4, 2011 at 11pm


Added on Apr 4, 2011 at 11pm
Always empty




Always empty




If LEGAL_BUSNAME exists then 1 else 0




if small_disad_bus is 0 and sbacert_small_disad_bus not equal to 1
then 0 else output the ethnicity code




Always Empty

Data is no longer sent for records submitted in ORCA after Feb 16,
2011
Data is no longer sent for records submitted in ORCA after Feb 16,
2011
Data is no longer sent for records submitted in ORCA after Feb 16,
2011
Data is no longer sent for records submitted in ORCA after Feb 16,
2011
Data is no longer sent for records submitted in ORCA after Feb 16,
2011


Data is no longer sent for records submitted in ORCA after Feb 16,
2011
Data is no longer sent for records submitted in ORCA after Feb 16,
2011


if sbacert_small_disad_bus is 1 then 1 else 0
if sbacert_small_disad_bus is 2 then 1 else 0

If record exists in
JOINT_VENTURE_BUSINESS.LEGAL_BUSNAME then 1 else 0
If itequip_supplier is null then output is 2. If all of the field is 1 then
output is 1 else output is 0.




If service_supplier is null then output is 2. If all of the field is 1 then
output is 1 else output is 0.




Data is no longer sent for records submitted in ORCA after July 14,
2011 11pm
Data is no longer sent for records submitted in ORCA after July 14,
2011 11pm
Data is no longer sent for records submitted in ORCA after July 14,
2011 11pm
Data is no longer sent for records submitted in ORCA after July 14,
2011 11pm
Data is no longer sent for records submitted in ORCA after July 14,
2011 11pm
ist of products those are NOT IN the following countries(
Version 1 to 16 : 'CANADA','MEXICO','ISRAEL','ANTIGUA AND
BARBUDA','ARUBA','BAHAMAS','BARBADOS','BELIZE','BRITISH
VIRGIN ISLANDS','COSTA RICA','DOMINICA','EL
SALVADOR','GRENADA','GUATEMALA','GUYANA' 'HAITI'
'JAMAICA' ,'MONTSERRAT' ,'NETHERLANDS ANTILLES'
,'NICARAGUA','ST. KITTS AND NEVIS' ,'ST. LUCIA' ,'ST.
VINCENT AND THE GRENADINES' ,'TRINIDAD' ,'TOBAGO',
'ARUBA' ,'AUSTRIA' ,'BANGLADESH' ,'BELGIUM' ,'BENIN'
,'BHUTAN' ,'BOTSWANA', 'BURKINA FASO' ,'BURUNDI'
,'CANADA' ,'CAPE VERDE' ,'CENTRAL AFRICAN' ,'REPUBLIC'
,'CHAD' ,'COMOROS' ,'DENMARK' ,'DJIBOUTI' ,'EQUATORIAL
GUINEA' ,'FINLAND' ,'FRANCE' ,'GAMBIA' ,'GERMANY'
,'GREECE' ,'GUINEA' ,'GUINEA-BISSAU' ,'HAITI' ,'HONG KONG'
,'ICELAND' ,'IRELAND' ,'ISRAEL' ,'ITALY' ,'JAPAN' ,'KIRIBATI'
,'KOREA, REPUBLIC OF' ,'LESOTHO' ,'LIECHTENSTEIN'
,'LUXEMBOURG' ,'MALAWI' ,'MALDIVES' ,'MALI' ,'MOZAMBIQUE'
,'NEPAL' ,'NETHERLANDS' ,'NIGER' ,'NORWAY' ,'PORTUGAL'
,'RWANDA' ,'SAO TOME AND PRINCIPE' ,'SIERRA LEONE'
,'SINGAPORE' ,'SOMALIA' ,'SPAIN' ,'SWEDEN' ,'SWITZERLAND'
,'TANZANIA U.R.' ,'TOGO' ,'UVALU' ,'UGANDA' ,'UNITED
KINGDOM' ,'VANUATU' ,'WESTERN SAMOA';
Version 17 and up : 'AUSTRALIA','CANADA', 'CHILE','COSTA
RICA', 'DOMINICAN REPUBLIC','EL
SALVADOR','GUATEMALA','HONDURAS','ISRAEL','MEXICO','NIC
ARAGUA','SINGAPORE','ARUBA', 'AUSTRIA', 'BELGIUM',
'BULGARIA', 'CANADA', 'CYPRUS', 'CZECH REPUBLIC',



Always Empty

Data is no longer sent for records submitted in ORCA after July 14,
2011 11pm
Data is no longer sent for records submitted in ORCA after July 14,
2011 11pm
Display a URL by passing DUNS, objectid and link id parameters.
The page lists the data entered for the SF330.
Display a URL by passing DUNS, objectid and link id parameters
where user can download the pdf version. The page lists the data
entered for the SF330.




Sum(firm_emp_count)
sum(branch_emp_count)




If ORG_TYPE code is not 'ZZ' then get the description from
ORG_TYPE else get the description from
OTHER_ORGTYPE_DESC


check small business status of the vendor for service
disabled veteran owned, veteran owend and women
owned and if the arch_eng_small_bus_status is 1 then
concatenate the type of business to it (eg. If
arch_eng_small_bus_status is 1 and if it is Women
Owned then sba_status = Yes, WO)**



Concatenate First Name, MI and Last Name
List of products those are IN the following country codes
('AUS','CAN','BEL','DNK','EGY','TUR','DEU','FRA','GRC','ISR','ITA','L
UX','NLD','NOR', 'PRT','ESP','SWE','CHE','GBR')




List of products those are NOT IN the following country codes
('AUS','CAN','BEL','DNK','EGY','TUR','DEU','FRA','GRC','ISR','ITA','L
UX','NLD','NOR', 'PRT','ESP','SWE','CHE','GBR')
List of products those are NOT IN the following country codes(
Version 1 :
'ZMB','YEM','VUT','GBR','UGA','TGA','TGO','TUV','TTO','SGP','SVK',
'SVN','ESP','SWE','CHE',
'SMR','STP','SEN','SLE','SLB','SOM','KNA','LCA','VCT','RWA','POL','
PRT','ANT','NER','NPL','NIC',
'NOR','NLD','MLT','MEX','MAR','MDG','MWI','MDV','MLI','MRT','MOZ'
,'MSR','LVA','LIE','LTU','LUX',
'LAO','LSO','KOR','KIR','JPN','JAM','ISL','IRL','ISR','ITA','HTI','HND','
HKG','HUN','DEU','GRC',
'GMB','GIN','GNB','GUY','GTM','GRD','FRA','FIN','EST','SLV','TMP','
GNQ','ERI','ETH','DNK','COG',
'DJI','DMA','DOM','CAN','CYP','CZE','CHL','KHM','CPV','CAF','COM','
CRI','BEL','BGD','BEN','BTN',
'BFA','BDI','BHS','BRB','BLZ','VGB','ABW','AUT','AUS','AFG','AGO','
ATG','ABW','EGY','TUR';
Version 2 and up:
'ZMB','YEM','VUT','GBR','UGA','TGA','TGO','TUV','TTO','SGP','SVK',
'SVN','ESP','SWE','CHE',
'SMR','STP','SEN','SLE','SLB','SOM','KNA','LCA','VCT','RWA','POL','
PRT','ANT','NER','NPL','NIC',
'NOR','NLD','MLT','MEX','MAR','MDG','MWI','MDV','MLI','MRT','MOZ'
,'MSR','LVA','LIE','LTU','LUX',
'LAO','LSO','KOR','KIR','JPN','JAM','ISL','IRL','ISR','ITA','HTI','HND','
HKG','HUN','DEU','GRC',
'GMB','GIN','GNB','GUY','GTM','GRD','FRA','FIN','EST','SLV','TMP','
GNQ','ERI','ETH','DNK','COG','DJI','DMA','DOM','CAN','CYP','CZE','
CHL','KHM','CPV','CAF','COM','CRI','BEL','BGD','BEN','BTN',
'BFA','BDI','BHS','BRB','BLZ','VGB','ABW','AUT','AUS','AFG','AGO','




List of ptoducts those are IN the following country codes (
Version 1 :
'BEL','DNK','EGY','TUR','DEU','FRA','GRC','ISR','ITA','LUX','NLD','N
OR','PRT','ESP', 'SWE','CHE','GBR';
Version 2 and up:
'BEL','DNK','EGY','TUR','DEU','FRA','GRC','ISR','ITA','LUX','NLD','N
OR','PRT','ESP', 'SWE','CHE','GBR')



List of products those are IN the following country codes (
Version 1: 'AUS','CAN','CHL','ISR','MEX','SGP'
Version 2 and up:
'AUS','CAN','CHL','ISR','HND','MEX','NIC','SLV','SGP')




List of products those ar NOT IN the following country codes
('BEL','DNK','EGY','TUR','DEU','FRA','GRC','ISR','ITA','LUX','NLD','N
OR','PRT','ESP','SWE','CHE','GBR','AUS','CAN','CHL','SLV','HND','M
EX','NIC','SGP')
Display a URL by passing DUNS, objectid and link id as
parameters. The page is same as result(certification) page when
user searches for the DUNS
Display a URL by passing DUNS, objectid and link id as
parameters. The page is same as result(certification) page when
user searches for the DUNS
                                         Legacy Data Element List
                                          Legacy As-Is Extract Element Details
                                 # of Elements =

  #             As-Is Extract Element                 Datatype                   Data Format

210   ABA ROUTING ID                             STRING              Numeric
209   ACCOUNT NUMBER                             STRING              STRING
231   ACCOUNTS REC EMAIL                         STRING              STRING
230   ACCOUNTS REC FAX U.S. ONLY                 STRING              STRING
229   ACCOUNTS REC NON-U.S. PHONE                STRING              STRING
226   ACCOUNTS REC POC (AF)                      STRING              STRING
227   ACCOUNTS REC U.S. PHONE                    STRING              STRING
228   ACCOUNTS REC U.S. PHONE EXT                STRING              STRING
218   ACH EMAIL                                  STRING              STRING
217   ACH FAX                                    STRING              STRING
216   ACH NON-U.S. PHONE                         STRING              STRING
215   ACH U.S. PHONE                             STRING              STRING
247   ALT CCR EMAIL                              STRING              STRING

248   ALT CCR NON-U.S. PHONE                     STRING              STRING

249   ALT CCR POC (IC)                           STRING              STRING

250   ALT CCR U.S. PHONE                         STRING              STRING

251   ALT CCR U.S. PHONE EXT                     STRING              STRING

149   ALT CERTIFIER EMAIL                        STRING              STRING

148   ALT CERTIFIER FAX U.S. ONLY                STRING              STRING

147   ALT CERTIFIER NON-U.S. PHONE               STRING              STRING

144   ALT CERTIFIER POC (IC)                     STRING              STRING

145   ALT CERTIFIER U.S. PHONE                   STRING              STRING

146   ALT CERTIFIER U.S. PHONE EXT               STRING              STRING

129   ALT ELEC BUS CITY                          STRING              STRING
131   ALT ELEC BUS COUNTRY CODE                  STRING              STRING
137   ALT ELEC BUS EMAIL                         STRING              STRING
136   ALT ELEC BUS FAX U.S. ONLY                 STRING              STRING
135   ALT ELEC BUS NON-U.S. PHONE                STRING              STRING
126   ALT ELEC BUS POC (ZR)                      STRING              STRING
130   ALT ELEC BUS POSTAL CODE                   STRING              STRING
127   ALT ELEC BUS ST ADD (1)                    STRING              STRING
128   ALT ELEC BUS ST ADD (2)                    STRING              STRING
132   ALT ELEC BUS STATE OR PROVINCE             STRING              STRING
133   ALT ELEC BUS U.S. PHONE           STRING   STRING
134   ALT ELEC BUS U.S. PHONE EXT       STRING   STRING
81    ALT GOVT BUS CITY                 STRING   STRING
83    ALT GOVT BUS COUNTRY CODE         STRING   STRING
89    ALT GOVT BUS EMAIL                STRING   STRING
88    ALT GOVT BUS FAX U.S. ONLY        STRING   STRING
87    ALT GOVT BUS NON-U.S. PHONE       STRING   STRING
78    ALT GOVT BUS POC (60)             STRING   STRING
82    ALT GOVT BUS POSTAL CODE          STRING   STRING
79    ALT GOVT BUS ST ADD (1)           STRING   STRING
80    ALT GOVT BUS ST ADD (2)           STRING   STRING
84    ALT GOVT BUS STATE OR PROVINCE    STRING   STRING
85    ALT GOVT BUS U.S. PHONE           STRING   STRING
86    ALT GOVT BUS U.S. PHONE EXT       STRING   STRING
105   ALT PAST PERF CITY                STRING   STRING
107   ALT PAST PERF COUNTRY CODE        STRING   STRING
113   ALT PAST PERF EMAIL               STRING   STRING
112   ALT PAST PERF FAX U.S. ONLY       STRING   STRING
111   ALT PAST PERF NON-U.S. PHONE      STRING   STRING
102   ALT PAST PERF POC (R2)            STRING   STRING
106   ALT PAST PERF POSTAL CODE         STRING   STRING
103   ALT PAST PERF ST ADD (1)          STRING   STRING
104   ALT PAST PERF ST ADD (2)          STRING   STRING
108   ALT PAST PERF STATE OR PROVINCE   STRING   STRING
109   ALT PAST PERF U.S. PHONE          STRING   STRING
110   ALT PAST PERF U.S. PHONE EXT      STRING   STRING
202   ANNUAL RECEIPTS                   STRING   NUMBER
204   AUSTIN TETRA NUMBER               NUMBER   NUMBER

205   AUSTIN TETRA PARENT NUMBER        NUMBER   NUMBER

207   AUSTIN TETRA PCARD FLAG           CHAR     CHAR

206   AUSTIN TETRA ULTIMATE NUMBER      NUMBER   NUMBER

213   AUTHORIZATION DATE                STRING   MMDDYYYY
201   AVG NUMBER OF EMPLOYEES           STRING   Numeric
17    BUS START DATE                    STRING   MMDDYYYY
25    BUS TYPE COUNTER                  NUMBER

26    BUS TYPE STRING                   STRING   CHAR




3     CAGE CODE                         STRING   STRING
252   CCR EMAIL                         STRING   STRING

4     CCR EXTRACT CODE                  STRING   Number
253   CCR FAX U.S. ONLY                 STRING   STRING
254   CCR NON-U.S. PHONE          STRING   STRING

240   CCR NUMERICS CODE STRING    STRING   CHAR




239   CCR NUMERICS COUNTER        NUMBER

255   CCR POC (CE)                STRING   STRING

256   CCR U.S. PHONE              STRING   STRING

257   CCR U.S. PHONE EXT          STRING   STRING

143   CERTIFIER EMAIL             STRING   STRING

142   CERTIFIER FAX U.S. ONLY     STRING   STRING

141   CERTIFIER NON-U.S. PHONE    STRING   STRING

138   CERTIFIER POC (CE)          STRING   STRING

139   CERTIFIER U.S. PHONE        STRING   STRING

140   CERTIFIER U.S. PHONE EXT    STRING   STRING

13    CITY                        STRING   STRING
19    CO SECURITY LEVEL           STRING   STRING
9     COMPANY DIVISION            STRING   STRING
155   CORP INFO EMAIL             STRING   STRING

154   CORP INFO FAX U.S. ONLY     STRING   STRING

153   CORP INFO NON-U.S. PHONE    STRING   STRING

150   CORP INFO POC (CN)          STRING   STRING

151   CORP INFO U.S. PHONE        STRING   STRING

152   CORP INFO U.S. PHONE EXT    STRING   STRING

21    CORPORATE URL               STRING   STRING
36    CORRESPONDENCE FLAG         STRING   0 or 1
16    COUNTRY CODE                STRING   STRING
24    COUNTRY OF INC              STRING   STRING
35    CREDIT CARD                 STRING   Y or N
8     DBA NAME                    STRING   STRING
258   DELINQUENT FEDERAL DEBT     STRING   STRING
243   DISASTER RESPONSE COUNTER   NUMBER

244   DISASTER RESPONSE STRING    STRING   CHAR
244   DISASTER RESPONSE STRING            STRING   CHAR



10    DIVISION NUMBER                     STRING   STRING
259   DNB CURRENT BUSINESS STATUS         CHAR     STRING
195   DNB MONITORING CITY                 STRING   STRING
191   DNB MONITORING CORP NAME            STRING   STRING
197   DNB MONITORING COUNTRY CODE         STRING   STRING
192   DNB MONITORING DBA                  STRING   STRING
189   DNB MONITORING LAST UPDATED         STRING   MMDDYYYY
196   DNB MONITORING POSTAL CODE          STRING   STRING
193   DNB MONITORING ST ADD (1)           STRING   STRING
194   DNB MONITORING ST ADD (2)           STRING   STRING
198   DNB MONITORING STATE OR PROVINCE    STRING   STRING
190   DNB MONITORING STATUS               STRING   STRING
175   DOMESTIC PARENT CITY                STRING   STRING
177   DOMESTIC PARENT COUNTRY CODE        STRING   STRING
172   DOMESTIC PARENT DUNS NUMBER         STRING   STRING
179   DOMESTIC PARENT PHONE               NUMBER   Number
171   DOMESTIC PARENT POC (DM)            STRING   STRING
176   DOMESTIC PARENT POSTAL CODE         STRING   STRING
260   DOMESTIC PARENT RECORD DATE         STRING   MMDDYYYY
173   DOMESTIC PARENT ST ADD (1)          STRING   STRING
174   DOMESTIC PARENT ST ADD (2)          STRING   STRING
178   DOMESTIC PARENT STATE OR PROVINCE   STRING   STRING
1     DUNS                                STRING   STRING
2     DUNS-PLUS4                          STRING   STRING
199   EDI                                 STRING   Y or N
261   EDI POC                             STRING   STRING
262   EDI POC EMAIL                       STRING   STRING
263   EDI POC FAX                         STRING   STRING
264   EDI POC INTERNATIONAL PHONE         STRING   STRING
265   EDI POC PHONE                       STRING   STRING
266   EDI POC PHONE EXTENSION             STRING   STRING
214   EFT WAIVER                          STRING   STRING
117   ELEC BUS CITY                       STRING   STRING
119   ELEC BUS COUNTRY CODE               STRING   STRING
125   ELEC BUS EMAIL                      STRING   STRING
124   ELEC BUS FAX U.S. ONLY              STRING   STRING
123   ELEC BUS NON-U.S. PHONE             STRING   STRING
114   ELEC BUS POC (ZR)                   STRING   STRING
118   ELEC BUS POSTAL CODE                STRING   STRING
115   ELEC BUS ST ADD (1)                 STRING   STRING
116   ELEC BUS ST ADD (2)                 STRING   STRING
120   ELEC BUS STATE OR PROVINCE          STRING   STRING
121   ELEC BUS U.S. PHONE                 STRING   STRING
122   ELEC BUS U.S. PHONE EXT             STRING   STRING
20    EMPLOYEE SECURITY LEVEL             STRING   STRING
245   END-OF-RECORD FLAG                  CHAR     CHAR
246   END-OF-RECORD INDICATOR             CHAR     CHAR
235   EXTERNAL CERTIFICATION COUNTER
236   EXTERNAL CERTIFICATION STRING     STRING   STRING

208   FINANCIAL INSTUTE                 STRING   STRING
18    FISCAL YEAR END CLOSE DATE        STRING   STRING
241   FLAGS COUNTER

242   FLAGS STRING                      STRING   STRING

31    FSC CODE COUNTER

32    FSC CODE STRING                   STRING   STRING
184   GLOBAL PARENT CITY                STRING   STRING
186   GLOBAL PARENT COUNTRY CODE        STRING   STRING
181   GLOBAL PARENT DUNS NUMBER         STRING   STRING
188   GLOBAL PARENT PHONE               NUMBER   Number
180   GLOBAL PARENT POC (GL)            STRING   STRING
185   GLOBAL PARENT POSTAL CODE         STRING   STRING
267   GLOBAL PARENT RECORD DATE         STRING   MMDDYYYY
182   GLOBAL PARENT ST ADD (1)          STRING   STRING
183   GLOBAL PARENT ST ADD (2)          STRING   STRING
187   GLOBAL PARENT STATE OR PROVINCE   STRING   STRING
69    GOVT BUS CITY                     STRING   STRING
71    GOVT BUS COUNTRY CODE             STRING   STRING
77    GOVT BUS EMAIL                    STRING   STRING
76    GOVT BUS FAX U.S. ONLY            STRING   STRING
75    GOVT BUS NON-U.S. PHONE           STRING   STRING
66    GOVT BUS POC (60)                 STRING   STRING
70    GOVT BUS POSTAL CODE              STRING   STRING
67    GOVT BUS ST ADD (1)               STRING   STRING
68    GOVT BUS ST ADD (2)               STRING   STRING
72    GOVT BUS STATE OR PROVINCE        STRING   STRING
73    GOVT BUS U.S. PHONE               STRING   STRING
74    GOVT BUS U.S. PHONE EXT           STRING   STRING
62    GOVT PARENT CITY                  STRING   STRING
64    GOVT PARENT COUNTRY CODE          STRING   STRING
59    GOVT PARENT POC (QW)              STRING   STRING


63    GOVT PARENT POSTAL CODE           STRING   STRING
60    GOVT PARENT ST ADD (1)            STRING   STRING
61    GOVT PARENT ST ADD (2)            STRING   STRING
65    GOVT PARENT STATE OR PROVINCE     STRING   STRING
268   GS02 IDENTIFIER                   STRING   STRING
162   HEADQUARTER PARENT POC (HQ)       STRING   STRING
166   HQ PARENT CITY                    STRING   STRING
168   HQ PARENT COUNTRY CODE            STRING   STRING
163   HQ PARENT DUNS NUMBER             STRING   STRING
170   HQ PARENT PHONE                   NUMBER   Number
167   HQ PARENT POSTAL CODE             STRING   STRING
269   HQ PARENT RECORD DATE             STRING   MMDDYYYY
164   HQ PARENT ST ADD (1)              STRING   STRING
165   HQ PARENT ST ADD (2)              STRING   STRING
169   HQ PARENT STATE OR PROVINCE          STRING   STRING
270   ISA QUALIFIER                        STRING   STRING
271   ISA SENDER QUALIFIER                 STRING   STRING
7     LEGAL BUS NAME                       STRING   STRING
272   LOCATION EMPLOYEES                   STRING   Numeric


273   LOCATION RECEIPTS                    STRING   Numeric


212   LOCKBOX NUMBER                       STRING   STRING
40    MAILING ADD CITY                     STRING   STRING
42    MAILING ADD COUNTRY CODE             STRING   STRING
37    MAILING ADD POC (FE)                 STRING   STRING
41    MAILING ADD POSTAL CODE              STRING   STRING
38    MAILING ADD ST ADD (1)               STRING   STRING
39    MAILING ADD ST ADD (2)               STRING   STRING
43    MAILING ADD STATE OR PROVINCE        STRING   STRING
232   MARKETING PARTNER ID NUMBER (MPIN)   STRING   STRING
29    NAICS CODE COUNTER                   NUMBER

30    NAICS CODE STRING                    STRING   CHAR
274   NAICS CODES AND EXCEPTIONS           CHAR     CHAR


233   NAICS EXCEPTIONS COUNTER             NUMBER

234   NAICS EXCEPTIONS STRING              STRING   CHAR
275   NO PUBLIC DISPLAY FLAG               STRING   Y or null
22    ORGANIZATIONAL TYPE                  STRING   STRING
161   OWNER INFO EMAIL                     STRING   STRING

160   OWNER INFO FAX U.S. ONLY             STRING   STRING

159   OWNER INFO NON-U.S. PHONE            STRING   STRING

156   OWNER INFO POC (OW)                  STRING   STRING

157   OWNER INFO U.S. PHONE                STRING   STRING

158   OWNER INFO U.S. PHONE EXT            STRING   STRING

55    PARENT CITY                          STRING   STRING
57    PARENT COUNTRY CODE                  STRING   STRING
52    PARENT DUNS NUMBER                   STRING   STRING
51    PARENT POC (GL)                      STRING   STRING
56    PARENT POSTAL CODE                   STRING   STRING
53    PARENT ST ADD (1)                    STRING   STRING
54    PARENT ST ADD (2)                    STRING   STRING
58    PARENT STATE OR PROVINCE             STRING   STRING
93    PAST PERF CITY                       STRING   STRING
95    PAST PERF COUNTRY CODE               STRING   STRING
101   PAST PERF EMAIL                  STRING   STRING
100   PAST PERF FAX U.S. ONLY          STRING   STRING
99    PAST PERF NON-U.S. PHONE         STRING   STRING
90    PAST PERF POC (R2)               STRING   STRING
94    PAST PERF POSTAL CODE            STRING   STRING
91    PAST PERF ST ADD (1)             STRING   STRING
92    PAST PERF ST ADD (2)             STRING   STRING
96    PAST PERF STATE OR PROVINCE      STRING   STRING
97    PAST PERF U.S. PHONE             STRING   STRING
98    PAST PERF U.S. PHONE EXT         STRING   STRING
211   PAYMENT TYPE                     STRING   C or S
15    POSTAL CODE                      STRING   STRING
47    PREVIOUS BUS CITY                STRING   STRING

49    PREVIOUS BUS COUNTRY CODE        STRING   STRING

44    PREVIOUS BUS POC (B3)            STRING   STRING

48    PREVIOUS BUS POSTAL CODE         STRING   STRING

45    PREVIOUS BUS ST ADD (1)          STRING   STRING

46    PREVIOUS BUS ST ADD (2)          STRING   STRING

50    PREVIOUS BUS STATE OR PROVINCE   STRING   STRING

34    PSC CODE                         STRING   STRING
33    PSC CODE COUNTER                 NUMBER

276   RECEIVE 820?                     STRING   STRING
5     REGISTRATION DATE                STRING   MMDDYYYY
277   REGISTRATION STATUS              CHAR     CHAR
222   REMIT INFO CITY                  STRING   STRING
225   REMIT INFO COUNTRY CODE          STRING   STRING
219   REMIT INFO POC (RI)              STRING   STRING
224   REMIT INFO POSTAL CODE           STRING   STRING
220   REMIT INFO ST ADD (1)            STRING   STRING
221   REMIT INFO ST ADD (2)            STRING   STRING
223   REMIT INFO STATE OR PROVINCE     STRING   STRING
6     RENEWAL DATE                     STRING   MMDDYYYY
237   SBA CERTIFICATION COUNTER        NUMBER

238   SBA CERTIFICATION STRING         STRING   CHAR

27    SIC CODE COUNTER                 NUMBER

28    SIC CODE STRING                  STRING   CHAR

203   SOCIAL SECURITY NUMBER           STRING   STRING
278   SOLE PROP EMAIL                  STRING   STRING
279   SOLE PROP FAX U.S. ONLY          STRING   STRING
280   SOLE PROP NON-U.S. PHONE         STRING   STRING
281   SOLE PROP POC              STRING   STRING
282   SOLE PROP U.S. PHONE       STRING   STRING
283   SOLE PROP U.S. PHONE EXT   STRING   STRING
11    ST ADD (1)                 STRING   STRING

12    ST ADD (2)                 STRING   STRING
23    STATE OF INC               STRING   STRING
14    STATE OR PROVINCE          STRING   STRING
200   TAX PAYER ID NUMBER        STRING   STRING
                  SAM Extract Data Element Equivalent
                                   SAM Element Mapping



     Length                    SAM TO-BE Element Mapping

50            ABA Routing ID
20            Account Number
80            SAM FOUO POC String
30            SAM FOUO POC String
30            SAM FOUO POC String
60            SAM FOUO POC String
30            SAM FOUO POC String
28            SAM FOUO POC String
80            ACH Email
30            ACH Fax
30            ACH Non-U.S. Phone
30            ACH U.S. Phone
80            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
30            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
60            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
30            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
28            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
80            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
30            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
30            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
60            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
30            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
28            This POC type will be sunset and will no longer be available in
              the SAM To-Be Extracts
40            SAM Public POC String
3             SAM Public POC String
80            SAM Public POC String
30            SAM Public POC String
30            SAM Public POC String
60            SAM Public POC String
35            SAM Public POC String
55            SAM Public POC String
55            SAM Public POC String
50            SAM Public POC String
30    SAM Public POC String
28    SAM Public POC String
40    SAM Public POC String
3     SAM Public POC String
80    SAM Public POC String
30    SAM Public POC String
30    SAM Public POC String
60    SAM Public POC String
35    SAM Public POC String
55    SAM Public POC String
55    SAM Public POC String
50    SAM Public POC String
30    SAM Public POC String
28    SAM Public POC String
40    SAM Public POC String
3     SAM Public POC String
80    SAM Public POC String
30    SAM Public POC String
30    SAM Public POC String
60    SAM Public POC String
35    SAM Public POC String
55    SAM Public POC String
55    SAM Public POC String
50    SAM Public POC String
30    SAM Public POC String
28    SAM Public POC String
15    Average Annual Revenue
10    Austin Tetra will no longer be carried forward and will not be
      available in the SAM To-Be Extracts
10    Austin Tetra will no longer be carried forward and will not be
      available in the SAM To-Be Extracts
1     Austin Tetra will no longer be carried forward and will not be
      available in the SAM To-Be Extracts
10    Austin Tetra will no longer be carried forward and will not be
      available in the SAM To-Be Extracts
8     Authorization Date
15    Average Number of Employees
8     Business Start Date
4     Counters will no longer be carried forward and will not be
      available in the SAM To-Be Extracts
300   Bus Type String




5     CAGE Code
80    This POC type will be sunset and will no longer be available in
      the SAM To-Be Extracts
1     SAM Extract Code
30    This POC type will be sunset and will no longer be available in
      the SAM To-Be Extracts
30     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
1589   SAM Numerics Code String




4      Counters will no longer be carried forward and will not be
       available in the SAM To-Be Extracts
60     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
30     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
28     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
80     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
30     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
30     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
60     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
30     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
28     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
40     SAM City
2      Company Security Level
60     Company Division
80     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
30     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
30     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
60     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
30     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
28     This POC type will be sunset and will no longer be available in
       the SAM To-Be Extracts
200    Corporate URL
1      Correspondence Flag
3      SAM Country Code
3      Country of Incorporation
1      Credit Card Usage
60     DBA Name
1      Delinquent Federal Debt Flag
4      Counters will no longer be carried forward and will not be
       available in the SAM To-Be Extracts
70     Disaster Response String
70    Disaster Response String



10    Division Number
1     D&B Out of Business Indicator
35    D&B Monitoring City
120   D&B Monitoring Corporation Name
3     D&B Monitoring Country Code
60    D&B Monitoring DBA
10    D&B Monitoring Last Updated
35    D&B Monitoring Postal Code
55    D&B Monitoring Address 1
55    D&B Monitoring Address 2
50    D&B Monitoring State or Province
1     D&B Monitoring Status
35    DNB Linkage String
3     DNB Linkage String
13    DNB Linkage String
30    DNB Linkage String
60    DNB Linkage String
35    DNB Linkage String
8     DNB Linkage String
55    DNB Linkage String
55    DNB Linkage String
50    DNB Linkage String
9     DUNS
4     DUNS+4
1
60    SAM FOUO POC String
80    SAM FOUO POC String
30    SAM FOUO POC String
30    SAM FOUO POC String
30    SAM FOUO POC String
28    SAM FOUO POC String
1     EFT Waiver
40    SAM Public POC String
3     SAM Public POC String
80    SAM Public POC String
30    SAM Public POC String
30    SAM Public POC String
60    SAM Public POC String
35    SAM Public POC String
55    SAM Public POC String
55    SAM Public POC String
50    SAM Public POC String
30    SAM Public POC String
28    SAM Public POC String
15    Highest Employee Security Level
4     End of Record Flag will no longer be carried forward
4     End of Record Flag will no longer be carried forward
      Counters will no longer be carried forward and will not be
      available in the SAM To-Be Extracts
50     Delinquent Federal Debt Flag
       Exclusion Status String
30     Financial Institute
4      Fiscal Year End Close Date
       Counters will no longer be carried forward and will not be
       available in the SAM To-Be Extracts
4      No Public Display Flag

       Counters will no longer be carried forward and will not be
       available in the SAM To-Be Extracts
3500   PSC Code String
35     DNB Linkage String
50     DNB Linkage String
13     DNB Linkage String
30     DNB Linkage String
60     DNB Linkage String
35     DNB Linkage String
8      DNB Linkage String
55     DNB Linkage String
55     DNB Linkage String
50     DNB Linkage String
40     SAM Public POC String
3      SAM Public POC String
80     SAM Public POC String
30     SAM Public POC String
30     SAM Public POC String
60     SAM Public POC String
35     SAM Public POC String
55     SAM Public POC String
55     SAM Public POC String
50     SAM Public POC String
30     SAM Public POC String
28     SAM Public POC String
40     Agency Parent City
3      Agency Parent Country
60     Parent Legal Business Name


35     Agency Parent Zip Code
55     Agency Parent Address Line 1
55     Agency Parent Address Line 2
50     Agency Parent State or Province
15     Functional Group Identifier
60     DNB Linkage String
35     DNB Linkage String
50     DNB Linkage String
13     DNB Linkage String
30     DNB Linkage String
35     DNB Linkage String
8      DNB Linkage String
55     DNB Linkage String
55     DNB Linkage String
50      DNB Linkage String
2       ISA Qualifier
15      ISA Identifier
120     Legal Business Name
15      SAM Numerics Code String


15      SAM Numerics Code String


20      Lockbox Number
35      Mailing City
50      Mailing Country
60      Mailing Name
35      Mailing Zip Code
55      Mailing Address Line 1
55      Mailing Address Line 2
50      Mailing State or Province
9       MPIN
4       Counters will no longer be carried forward and will not be
        available in the SAM To-Be Extracts
12000   NAICS Code String
1100    NAICS Codes and Exceptions will no longer be carried forward
        and will not be available in the SAM To-Be Extracts (See NAICS
        Code String and NAICS Exception String)
4       Counters will no longer be carried forward and will not be
        available in the SAM To-Be Extracts
1100    NAICS Exception String
1       No Public Display Flag
2       Entity Structure
80      SAM FOUO POC String

30      SAM FOUO POC String

30      SAM FOUO POC String

60      SAM FOUO POC String

30      SAM FOUO POC String

28      SAM FOUO POC String

35      DNB Linkage String
50      DNB Linkage String
13      DNB Linkage String
60      DNB Linkage String
35      DNB Linkage String
55      DNB Linkage String
55      DNB Linkage String
50      DNB Linkage String
35      SAM Public POC String
3       SAM Public POC String
80      SAM Public POC String
30      SAM Public POC String
30      SAM Public POC String
60      SAM Public POC String
35      SAM Public POC String
55      SAM Public POC String
55      SAM Public POC String
50      SAM Public POC String
30      SAM Public POC String
28      SAM Public POC String
1       Account Type
35      SAM Zip Code
35      This POC type will be sunset and will no longer be available in
        the SAM To-Be Extracts
3       This POC type will be sunset and will no longer be available in
        the SAM To-Be Extracts
60      This POC type will be sunset and will no longer be available in
        the SAM To-Be Extracts
35      This POC type will be sunset and will no longer be available in
        the SAM To-Be Extracts
55      This POC type will be sunset and will no longer be available in
        the SAM To-Be Extracts
55      This POC type will be sunset and will no longer be available in
        the SAM To-Be Extracts
50      This POC type will be sunset and will no longer be available in
        the SAM To-Be Extracts
3500    PSC Code String
4       Counters will no longer be carried forward and will not be
        available in the SAM To-Be Extracts
3       820s Request Flag
8       Registration Date
1       Registration Status
35      Remittance City
3       Remittance Country
60      Remittance Name
35      Remittance Zip Code
55      Remittance Address Line 1
55      Remittance Address Line 2
50      Remittance State or Province
8       Renewal Date
4       Counters will no longer be carried forward and will not be
        available in the SAM To-Be Extracts
110     SBA Business Types String

4       Counters will no longer be carried forward and will not be
        available in the SAM To-Be Extracts
50000   SIC Codes will no longer be carried forward and will not be
        available in the SAM To-Be Extracts
9       Tax Identifier Number
80      SAM FOUO POC String
30      SAM FOUO POC String
30      SAM FOUO POC String
60   SAM FOUO POC String
30   SAM FOUO POC String
28   SAM FOUO POC String
55   SAM Address 1

55   SAM Address 2
2    State of Incorporation
50   SAM Province or State
9    Tax Identifier Number
   SAM Extract Data Mapping Comments              Which CCR Extract is the el
                SAM Mapping Comments                              Extract Type
                                         243        148     210

                SAM Mapping Comments   Complete     FOIA   FOUO

                                          X
                                          X
POC_Type = AR                             X
POC_Type = AR                             X
POC_Type = AR                             X
POC_Type = AR                             X
POC_Type = AR                             X
POC_Type = AR                             X
                                          X
                                          X
                                          X
                                          X




                                                     X

                                                     X

                                          X          X       X

                                          X          X       X

                                          X          X       X

                                          X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2                             X          X       X
POC_Type = E2   X   X   X
POC_Type = E2   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = GA   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
POC_Type = P2   X   X   X
                X   X
                X

                X

                X

                X
                X   X
                X   X
                X   X   X
                X   X   X



                X   X   X


                X   X   X


                X   X   X
(Bonding Level Value + Local # Employee + Local Ann. Revenue
+ Total Assets + Megawatt Hours + Barrels Capacity)
                                                                 X       X



                                                                 X       X




                                                                 X   X   X

                                                                 X   X   X

                                                                 X   X   X

                                                                 X   X   X

                                                                 X   X   X

                                                                 X   X   X
                                                                 X   X   X
                                                                 X       X
                                                                 X   X   X
                                                                 X   X   X

                                                                 X   X   X

                                                                 X   X   X

                                                                 X   X   X

                                                                 X   X   X

                                                                 X   X   X
                                                                 X   X   X
                                                                 X   X   X
                                                                 X   X   X
                                                                 X   X   X
                                                                 X   X   X
                                                                 X   X   X


                                                                 X       X
(Geographic Area Served: County + Geographic Area Served:
Metropolitan Statistical Area + Geographic Area Served: State)
                                                                 X       X
(Geographic Area Served: County + Geographic Area Served:
Metropolitan Statistical Area + Geographic Area Served: State)
                                                                 X       X


                                                                 X   X   X

                                                                 X       X
                                                                 X       X
                                                                 X       X
                                                                 X       X
                                                                 X       X
                                                                 X       X
                                                                 X       X
                                                                 X       X
                                                                 X       X
                                                                 X       X
ADDRESS_TYPE = DM                                                X       X
ADDRESS_TYPE = DM                                                X       X
ADDRESS_TYPE = DM                                                X       X
ADDRESS_TYPE = DM                                                X       X
ADDRESS_TYPE = DM                                                X       X
ADDRESS_TYPE = DM                                                X       X
ADDRESS_TYPE = DM
ADDRESS_TYPE = DM                                                X       X
ADDRESS_TYPE = DM                                                X       X
ADDRESS_TYPE = DM                                                X       X
                                                                 X       X
                                                                 X       X
                                                                 X   X   X
POC_Type = EA
POC_Type = EA
POC_Type = EA
POC_Type = EA
POC_Type = EA
POC_Type = EA
                                                                 X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
POC_Type = EB                                                    X   X   X
                                                                 X       X
                                                                 X   X   X
                                                                 X
                                                                 X       X
                                                                    X       X
                                                                    X
                                                                    X   X   X
                                                                    X       X
The Flags String is now just one element "No Public Display Flag"
                                                                    X       X

                                                                    X   X   X
                                                                    X   X   X
ADDRESS_TYPE = GL                                                   X       X
ADDRESS_TYPE = GL                                                   X       X
ADDRESS_TYPE = GL                                                   X       X
ADDRESS_TYPE = GL                                                   X       X
ADDRESS_TYPE = GL                                                   X       X
ADDRESS_TYPE = GL                                                   X       X
ADDRESS_TYPE = GL
ADDRESS_TYPE = GL                                                   X       X
ADDRESS_TYPE = GL                                                   X       X
ADDRESS_TYPE = GL                                                   X       X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
POC_Type = GB                                                       X   X   X
                                                                    X       X
                                                                    X       X
The Government Parent POC Name will no longer be
disseminated but the Name of the Agency/Department, etc. will       X       X
be provided (where applicable)
                                                                    X       X
                                                                    X       X
                                                                    X       X
                                                                    X       X

                                                                    X       X
ADDRESS_TYPE = HQ                                                   X       X
ADDRESS_TYPE = HQ                                                   X       X
ADDRESS_TYPE = HQ                                                   X       X
ADDRESS_TYPE = HQ                                                   X       X
ADDRESS_TYPE = HQ                                                   X       X
ADDRESS_TYPE = HQ
ADDRESS_TYPE = HQ                                                   X       X
ADDRESS_TYPE = HQ                                                   X       X
ADDRESS_TYPE = HQ                                              X       X


                                                               X   X   X
(Bonding Level Value + Local # Employee + Local Ann. Revenue
+ Total Assets + Megawatt Hours + Barrels Capacity)

(Bonding Level Value + Local # Employee + Local Ann. Revenue
+ Total Assets + Megawatt Hours + Barrels Capacity)

                                                               X
                                                               X   X   X
                                                               X   X   X
                                                               X   X   X
                                                               X   X   X
                                                               X   X   X
                                                               X   X   X
                                                               X   X   X
                                                               X
                                                               X   X   X
                                                               X   X   X




                                                               X       X
                                                               X       X

                                                               X   X   X
"OWNER INFO" has been changed to "Sole Proprietor POC" in
                                                               X   X   X
the SAM FOUO POC String
"OWNER INFO" has been changed to "Sole Proprietor POC" in
                                                               X   X   X
the SAM FOUO POC String
"OWNER INFO" has been changed to "Sole Proprietor POC" in
                                                               X   X   X
the SAM FOUO POC String
"OWNER INFO" has been changed to "Sole Proprietor POC" in
                                                               X   X   X
the SAM FOUO POC String
"OWNER INFO" has been changed to "Sole Proprietor POC" in
                                                               X   X   X
the SAM FOUO POC String
"OWNER INFO" has been changed to "Sole Proprietor POC" in
                                                               X   X   X
the SAM FOUO POC String
ADDRESS_TYPE = GL                                              X       X
ADDRESS_TYPE = GL                                              X       X
ADDRESS_TYPE = GL                                              X       X
ADDRESS_TYPE = GL                                              X       X
ADDRESS_TYPE = GL                                              X       X
ADDRESS_TYPE = GL                                              X       X
ADDRESS_TYPE = GL                                              X       X
ADDRESS_TYPE = GL                                              X       X
POC_Type = PP                                                  X   X   X
POC_Type = PP                                                  X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
POC_Type = PP   X   X   X
                X
                X   X   X
                X   X   X

                X   X   X

                X   X   X

                X   X   X

                X   X   X

                X   X   X

                X   X   X
                X   X   X
                X   X   X


                X   X   X

                X
                X
                X
                X
                X
                X
                X
                X   X   X
                X       X

                X       X

                X   X   X

                X   X   X
                X
POC_Type = SP
POC_Type = SP
POC_Type = SP
POC_Type = SP
POC_Type = SP
POC_Type = SP
                X   X   X
                X   X   X
                X   X   X
                X   X   X
                X
CCR Extract is the element in?                   Which CCR XML is the element in?
       Extract Type                                             XML Type
                6        218          242         227          204              185

             MPIN     Proprietary   Sensitive   Sensitive   Proprietary    Non-Proprietary

                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                       X           X
                                                   X            X                X

                                                   X            X                X

                                                   X            X                X

                                                   X            X                X

                                                   X            X                X




                          X            X

                          X            X

                          X            X

                          X            X
                          X            X           X            X                X
                          X            X           X            X                X
                          X            X           X            X                X
                          X            X           X            X                X
                          X            X           X            X                X
                          X            X           X            X                X
                          X            X           X            X                X
                          X            X           X            X                X
                          X            X           X            X                X
                          X            X           X            X                X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X
    X   X

    X   X

    X   X

    X   X
        X   X
    X   X   X   X
    X   X   X   X   X
    X   X



    X   X   X   X   X


X   X   X   X   X   X
            X   X   X
X   X   X
            X   X   X
        X   X   X



X   X



X   X

        X   X   X

        X   X   X

        X   X   X

X   X

X   X

X   X

X   X

X   X

X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X

X   X   X   X   X

X   X   X   X   X

X   X   X   X   X

X   X   X   X   X

X   X   X   X   X
X   X   X   X   X
X   X
X   X   X   X   X
X   X
X   X
X   X   X   X   X
        X   X
X   X


X   X
    X   X


    X   X   X   X   X
            X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
            X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
X   X   X   X   X   X
X   X   X   X   X   X
    X   X   X   X
            X   X
            X   X
            X   X
            X   X
            X   X
            X   X
        X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
X   X   X


    X   X
X   X
    X   X
X   X   X   X   X
X   X

X   X

X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
        X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X

X   X   X   X   X

X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
        X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
        X   X   X
X   X   X   X   X
X   X   X   X   X
    X   X   X   X   X
            X   X
            X   X
    X   X   X   X   X

            X   X


            X   X

        X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
    X   X   X   X   X
X           X   X
    X   X
    X   X

            X   X   X


    X   X
    X   X
            X   X   X
    X   X   X   X   X
    X   X

    X   X

    X   X

    X   X

    X   X

    X   X
    X   X
    X   X
    X   X
    X   X
    X   X
    X   X
    X   X
    X   X
    X   X   X   X   X
    X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
X   X   X   X   X
    X   X
X   X   X   X   X
X   X   X   X   X

X   X   X   X   X

X   X   X   X   X

X   X   X   X   X

X   X   X   X   X

X   X   X   X   X

X   X   X   X   X
X   X   X   X   X
X   X
        X   X
X   X
        X   X   X
    X   X
    X   X
    X   X
    X   X
    X   X
    X   X
    X   X
X   X   X   X   X
X   X

X   X   X   X   X

X   X

X   X   X   X   X
X   X   X   X
        X   X   X
        X   X   X
        X   X   X
        X   X   X
        X   X   X
        X   X   X
X   X   X   X   X
X   X   X   X   X
X   X
X   X   X   X   X
X   X   X   X
This is a business type = "Entity Structure" in SAM. Only one type can be selected by user.
CCR Numerics Code String
CODE_TYPE            SEQ_NBR_             CCR_CD_DISP_
LS                                    0   Local Size numbers, uses CCR_NBRs 01 and 02 only
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
AA                                    0   List CCR_NUMBER table codes, zero for hdg or notes
AA                                    1   Verbiage for CCR_NBR_01_20614, if any
AA                                    2   Verbiage for CCR_NBR_02_20615, if any
AA                                    3   Verbiage for CCR_NBR_03_20616, if any
AA                                    4   Verbiage for CCR_NBR_04_20617, if any
BK                                    0   SBA NAICS Banking Size Addl data, use NBR 01 only
BK                                    1   Total Assets from 4th qtr, preceding year
BK                                    2   Not Used
BK                                    3   Not Used
BK                                    4   Not Used
PG                                    0   SBA NAICS Power Gen. Addl data, use NBR 01 only
PG                                    1   Total MWH, preceding fiscal year, all affiliates
PG                                    2   Not Used
PG                                    3   Not Used
PG                                    4   Not Used
PT                                    0   SBA NAICS Petroleum Addl data,use NBR 01 only
PT                                    1   Bbl/day, Oper. Atmos. Crude Oil Distil. capacity
PT                                    2   Not Used
PT                                    3   Not Used
PT                                    4   Not Used
BL                                    0   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)


External Certification String
CTRL_CD              EXT_CERT_FLG         CCR_DISPLAY
DFD                  0                    Delinquent Federal Debt
DFD                  N                    No
DFD                  U                    Unknown
DFD                  Y                    Yes
EPL                  0                    Excluded Parties List
EPL                  D                    Debarred CCR Registrant

DFD - Delinquent Debt Flag. The vendor has delinquent federal debt, according to the IRS.
                   Possible values are "Y", "N" or blank. If the value is blank, no determination has been made.

EPL - EPLS debarred status. This vendor has been debarred in the Excluded Parties List System.
                    Possible values are "D" or nothing


Disaster Response String
The possible Disaster Response Serviced Area Codes are:
ANY - Any area
STA - State
CTY - County
MSA - Metropolitan Service Area




Bus Type String
CCR_TYP_BUS_        CCR_TYP_DEF_
8A                  Women-Owned Small Business
8E                  Economically Disadvantaged Women-Owned Small Business
8C                  Joint Venture Women-Owned Small Business
8D                  Joint Venture Economically Disadvantaged Women-Owned Small Business
12                  U.S. Local Government
1A                  Minority Institutions
20                  Foreign Owned and Located
G3                  Alaskan Native Servicing Institution (ANSI)
23                  Minority Owned Business
27                  Self Certified Small Disadvantaged Business
2F                  U.S. State Government
2R                  U.S. Federal Government
3I                  Tribal Government
A2                  Woman Owned Business
A3                  Labor Surplus Area Firm
A5                  Veteran Owned Business
A7                  AbilityOne (formerly JWOD) Non-Profit Agency
A8                  Nonprofit Organization
G5   Native Hawaiian Servicing Institution (NHSI)
C6   Municipality
FR   Asian-Pacific American Owned
HB   Historically Black College or University (HBCU)
G9   Other than one of the preceding
LJ   Limited Liability Company
M8   Educational Institution
MF   Manufacturer of Goods
NB   Native American Owned
OW   American Indian Owned
OY   Black American Owned
PI   Hispanic American Owned
QF   Service Disabled Veteran Owned Business
QZ   Subcontinent Asian (Asian-Indian) American Owned
XS   S Corporation
VN   Contracts
V2   Grants
VW   Contracts and Grants
TR   Airport Authority
UD   Council of Governments
BZ   Foundation
GW   Hispanic Servicing Institution
80   Hospital
KM   Planning Commission
T4   Port Authority
H6   School District
ZW   School of Forestry
TW   Transit Authority
QU   Veterinary College
FY   Veterinary Hospital
H2   Community Development Corporation
6D   Domestic Shelter
2X   For-Profit Organization
2U   Other Not for Profit Organization
G6   1862 Land Grant College
G7   1890 Land Grant College
G8   1994 Land Grant College
1R   Private University or College
OH   State Controlled Institution of Higher Learning
HS   Tribal College
NG   Federal Agency
QW   Federally Funded Research and Development Corp
C8   City
C7   County
ZR   Inter-municipal
MG   Local Government Owned
FO   Township
8B   Housing Authorities Public/Tribal
86   Interstate Entity
5    Alaskan Native Corporation Owned Firm
1B   Tribally Owned Firm
HK   Community Development Corporation Owned Firm
XY                   Indian Tribe (Federally Recognized)
8U                   Native Hawaiian Organization Owned Firm
HQ                   DoT Certified Disadvantaged Business Enterprise
1D                   Small Agricultural Cooperative




SBA CERTIFICATION String
CCR_TYP_BUS_         SBA_CERT_
A4                   SBA Certified Small Disadvantaged Business
A6                   SBA Certified 8A Program Participant
XX                   SBA Certified Hub Zone Firm
JT                   SBA Certified 8A Joint Venture




NAICS Size Exceptions String
There will always be a NAICS Exception counter field for the number of NAICS exceptions in each record and addit

There are 12 NAICS codes with possible size exceptions. And there are from two to four exceptions for each of the

NAICS EXCEPTIONS COUNTER
CHAR
4
de String
Size numbers, uses CCR_NBRs 01 and 02 only
Avg. Number of Employees (max. 999,999)
Avg. Annual Revenue (max. 999,999,999,999)


CR_NUMBER table codes, zero for hdg or notes
 ge for CCR_NBR_01_20614, if any
 ge for CCR_NBR_02_20615, if any
 ge for CCR_NBR_03_20616, if any
 ge for CCR_NBR_04_20617, if any
NAICS Banking Size Addl data, use NBR 01 only
Assets from 4th qtr, preceding year



NAICS Power Gen. Addl data, use NBR 01 only
MWH, preceding fiscal year, all affiliates



NAICS Petroleum Addl data,use NBR 01 only
 y, Oper. Atmos. Crude Oil Distil. capacity



ng Levels for Disaster Relief Registry
 uction Bonding Level, Per Contract (dollars)
 uction Bonding Level, Aggregate (dollars)
e Bonding Level, Per Contract (dollars)
e Bonding Level, Aggregate (dollars)


ion String
 uent Federal Debt



ded Parties List
 red CCR Registrant

elinquent federal debt, according to the IRS.
 " or blank. If the value is blank, no determination has been made.

 een debarred in the Excluded Parties List System.
e String




                                             0.479201389
                                                      ◄
ed Women-Owned Small Business
ned Small Business
y Disadvantaged Women-Owned Small Business



nstitution (ANSI)

 antaged Business




D) Non-Profit Agency
Institution (NHSI)


or University (HBCU)




Owned Business
-Indian) American Owned




 of Higher Learning


h and Development Corp




n Owned Firm

Corporation Owned Firm
ion Owned Firm
ed Business Enterprise




ON String
vantaged Business




tions String
 field for the number of NAICS exceptions in each record and additional fields for each NAICS exception the profile has.

ceptions. And there are from two to four exceptions for each of these NAICS codes. The first 6 positions of NAICS EXCEPTIONS is the NA

             NAICS EXCEPTIONS: Repeat X times to correspond with counter.
             CHAR
             10
*CCR Numerics explanation:
CCR Numerics are various CCR values that are further defined as noted below. There will always
be a CCR Numerics counter field for the number of CCR Numerics in each record and additional
fields for each numeric set the profile has.

The first 2 positions of CCR Numerics is a numeric identification code, followed by a set of '^'
delimited numbers. The entire field of code, numbers, and delimiters may
reach 158 characters as shown below. The internal maximum is 38 characters for each number
although this will seldom occur.

CCR_NUMERICS COUNTER CHAR 4
CCR NUMERICS CODE STRING: Holds X related "Numbers" groups to correspond with counter. See **Counter Examples
CHAR 1589


Breakdown of the example CCR Numbers portion show in the example below:

. . . "0002","LS^1239^183545000^0^0. BK^ 220000^0^0^0". . .

0002 = Two occurrences
LS = Location Size (Per CCRNumerics.csv)
1239 = Location Employees (Per CCRNumerics.csv)
183545000 = Location Receipts (Per CCRNumerics.csv)
0 = Unused (Per CCRNumerics.csv)
0 = Unused (Per CCRNumerics.csv)
BK = SBA NAICS Banking Size (Per CCRNumerics.csv)
2200001239 = Total Assets from 4th qtr, preceding year (Per CCRNumerics.csv)
0 = Unused (Per CCRNumerics.csv)
0 = Unused (Per CCRNumerics.csv)
0 = Unused (Per CCRNumerics.csv)




CCR_CODE_DEFINITION
Delinquent Federal Debt Flag is set through interface with Treasury (FMS) and updated on a weekly basis.
EIN/SSN from this record has been processed by Treasury (FMS), and no delinquent U. S. Federal Debt was found.
EIN/SSN from this record has been selected for processing by Treasury (FMS), but no response has yet been received from FM
EIN/SSN from this record has been processed by Treasury (FMS), and this EIN/SSN has a delinquent debt to the U. S. Federa
EPLS is interrogated for Debarred Status. This can be updated as often as daily with an interface to EPLS.
This registrant's DUNS is listed as Debarred at the EPLS database.
*CCR Disaster Response explanation:
CCR Disaster Response contains various CCR values that are further defined as noted below.
There will always be a Disaster Response counter field for the number of Disaster Responses in
each record and an additional field for each Disaster Response location set the profile has.
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. Reference "CCR Extract Support Files" at
http://www.ccr.gov/ccrextracts.aspx for a complete list of possible Disaster Response codes. The
entire field of code, numbers, and delimiters may reach 70 characters as shown below.

Breakdown of the example Disaster Response portion shown in the example below:

. . . "0003","CTYAL058.MSA1000.STAAL ". . .

0003= Three occurrences
CTY = County code
AL058 = Saint Clair (Per ST_County.csv)
MSA = Metropolitan Service Area code
1000 = Birmingham, AL (Per MSA_List.csv)
STA = State code
AL = Alabama (Per STATE_List.csv)
 fields for each NAICS exception the profile has.

NAICS codes. The first 6 positions of NAICS EXCEPTIONS is the NAICS code, followed by a ‘Y’, ‘N’ or space in each of the next four spaces




                                                                                                                                   54133
                                                                                                                                   54133
                                                                                                                                   54133
                                                                                                                                   23799
                        Other Samples:

                       LS^1^350000^0^0
                       LS^62^4292583^0^0
                       LS^7^750000^0^0
                       LS^12^1000000^0^0
                       BL^0^0^0^0.LS^25^1500000^0^0
                       BL^0^0^0^0.LS^0^0^0^0
                       LS^45^4000000^0^0
                       LS^23^5000000^0^0
                       BL^0^0^0^0.LS^18^5000000^0^0
                       BL^0^0^0^0.LS^14^2600000^0^0
r. See **Counter Examples
                       LS^3^300000^0^0
                       BL^0^0^0^0.LS^0^0^0^0
                       LS^307^400000^0^0
                       LS^175^20000000^0^0
                       LS^7^480000^0^0
                       LS^200^102000000^0^0
                       LS^60^9000000^0^0
                       BL^0^0^0^0.LS^62^18000000^0^0
                       BL^0^0^0^0.LS^0^0^0^0
                       LS^28^11370000^0^0
                       LS^430^12693136^0^0
                       LS^25^4100000^0^0
                       LS^170^38000000^0^0
                       LS^43^3100000^0^0
                       BL^0^0^0^0.LS^0^0^0^0
                       LS^160^35118000^0^0
                       BL^0^0^0^0.LS^100^1000000^0^0
                       BL^0^0^0^0.LS^0^0^0^0
                       LS^30^4000000^0^0




                        Other Samples:

ral Debt was found.      DFDN
                         DFDY
has yet been received from FMS.
                         DFDN.EPLD
quent debt to the U. S. Federal Government.
                         EPLD
                         DFDY.EPLD
Other Samples:

ANY
CTYTX101.MSA3360.STATX
ANY
CTYIL081.MSA1960.STAIL
CTYFL028.CTYFL051.CTYFL052.MSA8280.STAFL
ANY
CTYOH005.CTYOH037.CTYOH082.MSA1840.MSA3200.STAOH
CTYME003.CTYME008.CTYME012.MSA6400.STAME
CTYMA014.MSA9240.STACT.STAMA
ANY
CTYCA019.CTYCA030.CTYCA036.STACA
CTYIL016.CTYIL022.CTYIL045.STAIL
CTYAZ013.MSA8520.STAAZ
ANY
CTYWA003.CTYWA011.CTYWA036.MSA6740.MSA7840.MSA9260.STAWA
CTYNY052.STANY
STAMD.STAPA.STAVA
CTYNJ012.CTYNJ013.CTYNJ015.MSA5015.MSA5190.STANJ
CTYCA037.MSA7320.STACA
ANY




Other Samples:

23.2X.A2.B1.HQ.PI.VW
27.2X.A2.HQ.VN.XS
2X.VW
27.2X.A2.VN
27.2X.A2.LJ.VW
2X.VN
A8.V2
2X.VN
2X.77.B1.VN
2X.MF.VN
2U.B1.VN
27.2X.77.A2.B1.E6.HQ.VN.XS
23.2X.LJ.PI.VW
2X.MF.VN
27.2X.77.95.A2.LJ.VW
2X.LJ.VN
2X.VN
2X.A5.B1.VN
12.C8.VW.ZR
2X.VN
27.2X.77.B1.LJ.MF.VW
2X.MF.VW.XS
27.2X.A2.B1.VW
27.2X.VN
27.2X.A2.B1.HQ.VW
2X.LJ.VN
2X.MF.VN
2X.MF.VN
2X.VN
23.2X.B1.E6.QZ.VN.XS
23.2X.77.A2.B1.HQ.NB.OW.VN.XS
2X.B1.LJ.VW
A8.VW
2X.A5.VN
2X.A3.VW
2X.A3.VN.XS
2X.E6.LJ.VN
2X.77.VN
2X.B1.VN.XS
23.2X.A5.E6.PI.VW
23.27.2X.A5.OY.VW.XS
2X.A2.VN.XS
2X.77.A2.B1.VN
12.77.C8.UD.V2
2X.77.B1.VW
2X.B1.VN.XS
20.2X.MF.VW
2X.VW
2X.VN.XS
23.27.2X.A5.OY.QF.VW
23.27.2X.A5.OY.QF.VW
23.27.2X.A5.OY.QF.VW
2X.VN.XS
23.2X.HQ.OY.VN
27.2X.77.B1.MF.VW
2X.77.A2.VN.XS
2X.77.A2.B1.VN
2X.VN.XS
23.27.2X.B1.HQ.PI.VN
2X.77.95.MF.VN.XS
2X.A2.VN
2X.MF.VN
2X.HK.VN
2X.MF.VN
2X.LJ.VW
2X.77.A5.VW
2X.77.MF.VW.XS
2X.A2.VN.XS
2X.VN.XS
                      27.2X.77.A2.E6.HQ.VW
                      2X.A2.HQ.MF.VN
                      2X.LJ.VN
                      2X.A5.VW




                      Other Samples:

                      A420150531.A620150601
                      A420120725.A620120725
                      A420150627.A620150627.XX
                      XX
                      A420161209.A620161209




                      Other Samples:

in each of the next four spaces
                          541330NYYY
                          541330NNYY
                          541330NYYY
                          562910NY
                          562910NY
                          541330NYYY
                          541330NYYY
                          541330NYYY.541340YN
                          541330NYYY
                          237990YN .562910NY
                                                     Legacy Data Element List
                                                     Legacy As-Is Extract Element Details

#                            As-Is Extract Element                             Datatype

284   DUNS NUMBER                                                         STRING
285   DUNS PLUS4                                                          STRING
286   BUSINESS NAME                                                       STRING
287   TRADESTYLE NAME (PRIMARY)                                           STRING

288 ADDRESS LINE 1 (PHYSICAL)                                             STRING
289 ADDRESS LINE 2 (PHYSICAL)                                             STRING
290 CITY (PHYSICAL)                                                       STRING



291   STATE (PHYSICAL)                                                    STRING
292   ZIP (PHYSICAL)                                                      STRING
293   ZIP PLUS4 (PHYSICAL)                                                STRING
294   COUNTRY CODE (PHYSICAL)                                             STRING
295   POSTAL CODE (PHYSICAL)                                              STRING
296   MAIL ADDRESS 1                                                      STRING
297   MAIL ADDRESS 2                                                      STRING
298   MAIL CITY                                                           STRING
299   MAIL STATE                                                          STRING
300   MAIL ZIP                                                            STRING
301   PARENT DUNS                                                         STRING
302   PARENT NAME                                                         STRING
303   HEADQUARTERS DUNS NUMBER                                            STRING
304   HEADQUARTERS NAME                                                   STRING
305   AGENCY DUNS NUMBER                                                  STRING
306   AGENCY NAME                                                         STRING



307 HIERARCHY CODE                                                        STRING



308 STATUS CODE                                                           STRING



309 SUBSIDIARY INDICATOR                                                  STRING

310   SOURCE (Default Value is “Federal”)                                 STRING
311   TREASURY INDEX                                                      STRING
312   EMPLOYER IDENTIFICATION NUMBER (EIN)                                STRING
313   AGENCY LOCATION CODE (ALC)                                          STRING
314   DISBURSING OFFICE (DO)                                              STRING
315   BUSINESS TYPE                                                       STRING

316 REGISTRATION POC EMAIL                                                STRING
317 REGISTRATION POC FIRST NAME                              STRING

318 REGISTRATION POC LAST NAME                               STRING

319 REGISTRATION POC MIDDLE INITIAL                          STRING

320 REGISTRATION POC PHONE                                   STRING

321 REGISTRATION POC PHONE EXTENSION                         STRING

322 REGISTRATION POC PHONE INTL                              STRING

323 REGISTRATION POC FAX                                     STRING

324 REGISTRATION POC ADDRESS1                                STRING

325 REGISTRATION POC ADDRESS2                                STRING

326 REGISTRATION POC CITY                                    STRING

327 REGISTRATION POC COUNTRY CODE                            STRING

328 REGISTRATION POC STATE                                   STRING

329 REGISTRATION POC ZIP                                     STRING

330 REGISTRATION POC ZIP PLUS4                               STRING

331   REGISTRATION POC POSTAL CODE (FOR INTL ADDRESS ONLY)   STRING
332   ELIMINATIONS POC EMAIL                                 STRING
333   ELIMINATIONS POC FIRST NAME                            STRING
334   ELIMINATIONS POC LAST NAME                             STRING
335   ELIMINATIONS POC MIDDLE INITIAL                        STRING
336   ELIMINATIONS POC PHONE                                 STRING
337   ELIMINATIONS POC PHONE EXTENSION                       STRING
338   ELIMINATIONS POC PHONE INTL                            STRING
339   ELIMINATIONS POC FAX                                   STRING
340   ELIMINATIONS POC ADDRESS1                              STRING
341   ELIMINATIONS POC ADDRESS2                              STRING
342   ELIMINATIONS POC CITY                                  STRING
343   ELIMINATIONS POC COUNTRY CODE                          STRING
344   ELIMINATIONS POC STATE                                 STRING
345   ELIMINATIONS POC ZIP                                   STRING
346   ELIMINATIONS POC ZIP PLUS4                             STRING
347   ELIMINATIONS POC POSTAL CODE (FOR INTL ADDRESS ONLY)   STRING
348   SALES POC EMAIL                                        STRING
349   SALES POC FIRST NAME                                   STRING
350   SALES POC LAST NAME                                    STRING
351   SALES POC MIDDLE INITIAL                               STRING
352   SALES POC PHONE                                        STRING
353   SALES POC PHONE EXTENSION                              STRING
354   SALES POC PHONE INTL                                     STRING
355   SALES POC FAX                                            STRING
356   SALES POC ADDRESS1                                       STRING
357   SALES POC ADDRESS2                                       STRING
358   SALES POC CITY                                           STRING
359   SALES POC COUNTRY CODE                                   STRING
360   SALES POC STATE                                          STRING
361   SALES POC ZIP                                            STRING
362   SALES POC ZIP PLUS4                                      STRING
363   SALES POC POSTAL CODE (FOR INTL ADDRESS ONLY)            STRING
364   ACCOUNTS RECEIVABLE POC EMAIL                            STRING
365   ACCOUNTS RECEIVABLE POC FIRST NAME                       STRING
366   ACCOUNTS RECEIVABLE POC LAST NAME                        STRING
367   ACCOUNTS RECEIVABLE POC MIDDLE INITIAL                   STRING
368   ACCOUNTS RECEIVABLE POC PHONE                            STRING
369   ACCOUNTS RECEIVABLE POC PHONE EXT                        STRING
370   ACCOUNTS RECEIVABLE POC PHONE INTL                       STRING
371   ACCOUNTS RECEIVABLE POC FAX                              STRING
372   ACCOUNTS RECEIVABLE POC ADDRESS 1                        STRING
373   ACCOUNTS RECEIVABLE POC ADDRESS 2                        STRING
374   ACCOUNTS RECEIVABLE POC CITY                             STRING
375   ACCOUNTS RECEIVABLE POC COUNTRY CODE                     STRING
376   ACCOUNTS RECEIVABLE POC STATE                            STRING
377   ACCOUNTS RECEIVABLE POC ZIP                              STRING
378   ACCOUNTS RECEIVABLE POC ZIP PLUS4                        STRING
379   ACCOUNTS RECEIVABLE POC POSTAL (INTL ADDRESS ONLY)       STRING
380   ACCOUNTS PAYABLE POC EMAIL                               STRING
381   ACCOUNTS PAYABLE POC FIRST NAME                          STRING
382   ACCOUNTS PAYABLE POC LAST NAME                           STRING
383   ACCOUNTS PAYABLE POC MIDDLE INITIAL                      STRING
384   ACCOUNTS PAYABLE POC PHONE                               STRING
385   ACCOUNTS PAYABLE POC PHONE EXT                           STRING
386   ACCOUNTS PAYABLE POC PHONE INTL                          STRING
387   ACCOUNTS PAYABLE POC FAX                                 STRING
388   ACCOUNTS PAYABLE POC ADDRESS 1                           STRING
389   ACCOUNTS PAYABLE POC ADDRESS 2                           STRING
390   ACCOUNTS PAYABLE POC CITY                                STRING
391   ACCOUNTS PAYABLE POC COUNTRY CODE                        STRING
392   ACCOUNTS PAYABLE POC STATE                               STRING
393   ACCOUNTS PAYABLE POC ZIP                                 STRING
394   ACCOUNTS PAYABLE POC ZIP PLUS4                           STRING
395   ACCOUNTS PAYABLE POC POSTAL CODE (INTL ADDRESSES ONLY)   STRING
396   ANNUAL REVENUE                                           STRING
397   MERCHANT ID1                                             STRING
398   MERCHANT ID2                                             STRING
399   CREDIT CARD                                              STRING
400   REGISTRATION STATUS                                      STRING


401   NAICS (space for 20, fixed)                              STRING
402   FSC (space for 20, fixed)                                STRING
403   PSC (space for 20, fixed)                                STRING
404   REGISTRATION DATE (MMDDCCYY)                             STRING
405 DATE LAST UPDATED (MMDDCCYY)            STRING

406 DATE D&B DATA LAST UPDATED (MMDDCCYY)   STRING
407 EXPIRATION DATE (MMDDCCYY)              STRING
t List
t Details

                            Data Format         Length

            String                        9
            String                        4
            String                        120
            String                        120

            String                        55
            String                        55
            String                        40



            String                        50
            String                        5
            String                        4
            String                        3
            String                        35
            String                        55
            String                        55
            String                        60
            String                        50
            String                        9
            String                        9
            String                        120
            String                        9
            String                        120
            String                        9
            String                        120



            String                        9



            0, 1, 2 or 4                  1



            0 or 3                        1

            String                        7
            String                        2
            String                        9
            String                        8
            String                        5
            1, 2, 3, or 0                 9

            String                        80
String   28

String   28

String   1

String   10

String   6

String   30

String   10

String   55

String   55

String   35

String   3

String   2

String   5

String   4

String   35
String   80
String   28
String   28
String   1
String   10
String   6
String   30
String   10
String   55
String   55
String   35
String   3
String   2
String   5
String   4
String   35
String   80
String   28
String   28
String   1
String   10
String   6
String       30
String       10
String       55
String       55
String       35
String       3
String       2
String       5
String       4
String       35
String       80
String       28
String       28
String       1
String       10
String       6
String       30
String       10
String       55
String       55
String       35
String       3
String       2
String       5
String       4
String       35
String       80
String       28
String       28
String       1
String       10
String       6
String       30
String       10
String       55
String       55
String       35
String       3
String       2
String       5
String       4
String       35
String       15
String       120
String       120
1 or 2       1
1, 0, or 2   1


String       120
String       80
String       80
MMDDYYYY     8
MMDDYYYY   8

MMDDYYYY   8
MMDDYYYY   8
     SAM Extract Data Element Equivalent
                     SAM Element Mapping

                 SAM TO-BE Element Mapping

DUNS
DUNS+4
Legal Business Name
DBA Name
SAM Address 1

SAM Address 2
SAM City



SAM Province or State
SAM Zip Code
SAM Zip Code +4
SAM Country Code
SAM Zip Code
Mailing Address Line 1
Mailing Address Line 2
Mailing City
Mailing State or Province
Mailing Zip Code
Agency Parent DUNS
Parent Legal Business Name




DnB Government Parent information will no longer come from
DnB, SAM will have an internal hierarchy to accommodate this

DnB Government Parent information will no longer come from
DnB, SAM will have an internal hierarchy to accommodate this

DnB Government Parent information will no longer come from
DnB, SAM will have an internal hierarchy to accommodate this
This element will no longer be carried forward and will not be
available in the SAM To-Be Extracts
Department Codes
Tax Identifier Number
Agency Location Code
Disbursing Office Symbol
Agency Business Purpose
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
This POC type will be sunset and will no longer be available in
the SAM To-Be Extracts
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
SAM FOUO POC String
Annual Revenue
Merchant ID 1
Merchant ID 2
Credit Card Usage
Registration Status

NAICS Code String
PSC Code String
PSC Code String
Registration Date
This element will no longer be carried forward and will not be
available in the SAM To-Be Extracts
Expiration Date
SAM Extract Data Mapping Comments
        SAM Mapping Comments

        SAM Mapping Comments
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = EP
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = SL
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AR
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP
POC_Type = AP

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:8/4/2012
language:
pages:153