1. Tables and Views for Financials
  2. FV_SAM_TRADING_PARTNER_INT

FV_SAM_TRADING_PARTNER_INT

This table stores information about SAM Trading Partners.

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

FV_SAM_TRADING_PARTNER_INT_PK

UNIQUE_ENTITY_IDENTIFIER_SAM, ENTITY_EFT_INDICATOR, LOAD_REQUEST_ID

Columns

Name Datatype Length Not-null Comments
UNIQUE_ENTITY_IDENTIFIER_SAM VARCHAR2 12 Yes The Unique Entity Identifier (SAM) for the entity.
UNIQUE_ENTITY_IDENTIFIER_DUNS VARCHAR2 15 The Dun and Bradstreet Data Universal Numbering System (DUNS) number for the entity.
ENTITY_EFT_INDICATOR VARCHAR2 10 Yes This field is used to make EFT payments at multiple remittance locations for the entity.
CAGE_CODE VARCHAR2 5 Commercial and government entity (CAGE) code is a unique identifier assigned to an entity which provides a standardized method of identifying a given facility at a specific location. All US entities must meet a CAGE code validation process, or will be assigned one by the defense logistics information service (DLIS).
DODAAC_CODE VARCHAR2 9 The department of defense activity address code (DODAAC) for non-civilian government agencies (DoD). This is filled with the letters "DOD" followed by the agency's 6 digit DoDAAC number.
SAM_EXTRACT_CODE VARCHAR2 1 Single character code that defines the status of the record being sent in the extract. The monthly file contains the complete record whether active or expired. For the daily files, the SAM extract code further specifies which data elements are sent for the record.
PURPOSE_OF_REGISTRATION_CODE VARCHAR2 2 The purpose of an entity’s registration in entity management.
INITIAL_REGISTRATION_DATE DATE The date the initial entity registration was submitted.
REGISTRATION_EXPIRATION_DATE DATE The date this current registration will expire or has already expired. This date is 365 days after the user submitted the registration.
SAM_TRD_PARTNER_UPDATED_DATE DATE The date this registration was last updated. This can change while the activation date remains the same for many reasons, such as POC changes, reference data changes, or SAM Technical Team database changes.
ACTIVATION_DATE DATE The date this registration record was made active. This can differ from the date that the registration was submitted due to the time it takes for TIN Validation and CAGE code assignment/validation.
LEGAL_BUSINESS_NAME VARCHAR2 120 The legal business name of the entity.
DBA_NAME VARCHAR2 120 The 'doing business as' name of the entity. This name must be different from the legal business name.
ENTITY_DIVISION_NAME VARCHAR2 60 This field is the division name provided by the entity.
ENTITY_DIVISION_NUMBER VARCHAR2 10 This field is the division number provided by the entity.
PHYS_ADDR_LINE_1 VARCHAR2 150 This is the street address line 1 of the physical address.
PHYS_ADDR_LINE_2 VARCHAR2 150 This is the street address line 2 of the physical address.
PHYS_ADDR_CITY VARCHAR2 40 This is the city of the physical address.
PHYS_ADDR_PROVINCE_OR_STATE VARCHAR2 55 This is the state or province of the physical address.
PHYS_ADDR_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the physical address.
PHYS_ADDR_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the physical address.
PHYS_ADDR_COUNTRY_CODE VARCHAR2 3 This is the country code of the physical address.
CONGRESSIONAL_DISTRICT NUMBER 10 This is the congressional district of the physical address.
D_AND_B_OPEN_DATA_FLAG VARCHAR2 1 This flag indicates whether the business name and physical address sourced from Dun and Bradstreet.
ENTITY_START_DATE DATE The date the entity was started or acquired.
FISCAL_YEAR_CLOSE_DATE VARCHAR2 4 The date the entity's accounting period closes.
COMPANY_SECURITY_LEVEL VARCHAR2 2 The company security level on a facility level for the entity.
TOP_EMPLOYEE_SECURITY_LEVEL VARCHAR2 2 The top level of security clearance for employees in an entity.
ENTITY_URL VARCHAR2 200 The entity's webpage Universal Resource Locator (URL).
ENTITY_STRUCTURE_CODE VARCHAR2 2 The structure of the entity as defined by the IRS.
STATE_OF_INCORPORATION VARCHAR2 2 The state code where the entity was incorporated.
COUNTRY_OF_INCORPORATION VARCHAR2 3 The country code where the entity was incorporated.
BUSINESS_TYPE_COUNT NUMBER 4 Four digit identifier that provides the number of business types to be provided in the business type String.
BUSINESS_TYPES_INFORMATION CLOB Tilde (~) delimited string that includes all of the entity's business type information.
AGENCY_BUSINESS_PURPOSE_CODE VARCHAR2 1 This data element identifies what business purpose that the IGT registration (Purpose of Registration Z3, Z4, Z5) has registered for. The potential values represent Buyer, Seller, Buyer and Seller.
PRIMARY_NAICS_CODE VARCHAR2 6 Four digit identifier that provides the number of primary NAICS code.
NAICS_CODE_COUNT NUMBER 4 Four digit identifier that provides the number of NAICS codes to be provided in the NAICS code string.
NAICS_CODES_INFORMATION CLOB Tilde (~) delimited string that includes all of the entity's NAICS information.
PSC_CODE_COUNT NUMBER 4 Four digit identifier that provides the number of PSC codes to be provided in the PSC code string.
PSC_CODES_INFORMATION CLOB Tilde (~) delimited string that includes all of the entity's PSC information.
CREDIT_CARD_USAGE_CODE VARCHAR2 1 This field indicates whether an entity is willing to be paid by government credit card.
CORRESPONDENCE_CODE VARCHAR2 1 This field is used to identify an entity's preferred correspondence type.
MAIL_ADDR_LINE_1 VARCHAR2 150 This is the street address line 1 of the mailing address.
MAIL_ADDR_LINE_2 VARCHAR2 150 This is the street address line 2 of the mailing address.
MAIL_ADDR_CITY VARCHAR2 40 This is the city of the mailing address.
MAIL_ADDR_ZIP_POSTAL_CODE VARCHAR2 50 This is the postal code of the mailing address.
MAIL_ADDR_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the mailing address.
MAIL_ADDR_COUNTRY VARCHAR2 3 This is the country code of the mailing address.
MAIL_ADDR_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the mailing address.
GOV_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of government business POC.
GOV_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of government business POC.
GOV_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of government business POC.
GOV_POC_TITLE VARCHAR2 50 This field indicates the title of government business POC.
GOV_POC_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the government business POC.
GOV_POC_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the government business POC.
GOV_POC_CITY VARCHAR2 40 This is the city of the government business POC.
GOV_POC_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the government business POC.
GOV_POC_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the government business POC.
GOV_POC_COUNTRY_CODE VARCHAR2 3 This is the country code of the government business POC.
GOV_POC_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the government business POC.
GOV_POC_US_PHONE VARCHAR2 30 The phone number of the government business POC if located in the US.
GOV_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the government business POC if located in the US.
GOV_POC_NON_US_PHONE VARCHAR2 30 The phone number of the government business POC if located outside of the US.
GOV_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the government business POC.
GOV_POC_EMAIL VARCHAR2 80 The contact email address of the government business POC.
ALT_GOV_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of government business alternate POC.
ALT_GOV_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of government business alternate POC.
ALT_GOV_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of government business alternate POC.
ALT_GOV_POC_TITLE VARCHAR2 50 This field indicates the title of government business alternate POC.
ALT_GOV_POC_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the government business alternate POC.
ALT_GOV_POC_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the government business alternate POC.
ALT_GOV_POC_CITY VARCHAR2 40 This is the city of the government business alternate POC.
ALT_GOV_POC_ZIP_POSTAL_CODE VARCHAR2 50 This is the postal code of the government business alternate POC.
ALT_GOV_POC_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the government business alternate POC.
ALT_GOV_POC_COUNTRY_CODE VARCHAR2 3 This is the country code of the government business alternate POC.
ALT_GOV_POC_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the government business alternate POC.
ALT_GOV_POC_US_PHONE VARCHAR2 30 The phone number of the government business alternate POC if located in the US.
ALT_GOV_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the government business alternate POC if located in the US.
ALT_GOV_POC_NON_US_PHONE VARCHAR2 30 The phone number of the government business alternate POC if located outside of the US.
ALT_GOV_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the government business alternate POC.
ALT_GOV_POC_EMAIL VARCHAR2 80 The contact email address of the government business alternate POC.
PAST_PERF_FIRST_NAME VARCHAR2 65 This field indicates the first name of past performance POC.
PAST_PERF_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of past performance POC.
PAST_PERF_LAST_NAME VARCHAR2 65 This field indicates the last name of past performance POC.
PAST_PERF_TITLE VARCHAR2 50 This field indicates the title of past performance POC.
PAST_PERF_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the past performance POC.
PAST_PERF_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the past performance POC.
PAST_PERF_CITY VARCHAR2 40 This is the city of the past performance POC.
PAST_PERF_ZIP_POSTAL_CODE VARCHAR2 50 This is the postal code of the past performance POC.
PAST_PERF_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the past performance POC.
PAST_PERF_COUNTRY_CODE VARCHAR2 3 This is the country code of the past performance POC.
PAST_PERF_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the past performance POC.
PAST_PERF_US_PHONE VARCHAR2 30 The phone number of the past performance POC if located in the US.
PAST_PERF_US_PHONE_EXT VARCHAR2 25 The phone number extension of the past performance POC if located in the US.
PAST_PERF_NON_US_PHONE VARCHAR2 30 The phone number of the past performance POC if located outside of the US.
PAST_PERF_FAX_US_ONLY VARCHAR2 30 The fax number of the past performance POC.
PAST_PERF_EMAIL VARCHAR2 80 The contact email address of the past performance POC.
ALT_PAST_FIRST_NAME VARCHAR2 65 This field indicates the first name of past performance alternate POC.
ALT_PAST_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of past performance alternate POC.
ALT_PAST_LAST_NAME VARCHAR2 65 This field indicates the last name of past performance alternate POC.
ALT_PAST_TITLE VARCHAR2 50 This field indicates the title of past performance alternate POC.
ALT_PAST_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the past performance alternate POC.
ALT_PAST_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the past performance alternate POC.
ALT_PAST_CITY VARCHAR2 40 This is the city of the past performance alternate POC.
ALT_PAST_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the past performance alternate POC.
ALT_PAST_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the past performance alternate POC.
ALT_PAST_COUNTRY_CODE VARCHAR2 3 This is the country code of the past performance alternate POC.
ALT_PAST_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the past performance alternate POC.
ALT_PAST_US_PHONE VARCHAR2 30 The phone number of the past performance alternate POC if located in the US.
ALT_PAST_US_PHONE_EXT VARCHAR2 25 The phone number extension of the past performance alternate POC if located in the US.
ALT_PAST_NON_US_PHONE VARCHAR2 30 The phone number of the past performance alternate POC if located outside of the US.
ALT_PAST_FAX_US_ONLY VARCHAR2 30 The fax number of the past performance alternate POC.
ALT_PAST_EMAIL VARCHAR2 80 The contact email address of the past performance alternate POC.
E_BIZ_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of electronic business POC.
E_BIZ_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of electronic business POC.
E_BIZ_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of electronic business POC.
E_BIZ_POC_TITLE VARCHAR2 50 This field indicates the title of electronic business POC.
E_BIZ_POC_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the electronic business POC.
E_BIZ_POC_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the electronic business POC.
E_BIZ_POC_CITY VARCHAR2 40 This is the city of the electronic business POC.
E_BIZ_POC_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the electronic business POC.
E_BIZ_POC_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the electronic business POC.
E_BIZ_POC_COUNTRY_CODE VARCHAR2 3 This is the country code of the electronic business POC.
E_BIZ_POC_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the electronic business POC.
E_BIZ_POC_US_PHONE VARCHAR2 30 The phone number of the electronic business POC if located in the US.
E_BIZ_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the electronic business POC if located in the US.
E_BIZ_POC_NON_US_PHONE VARCHAR2 30 The phone number of the electronic business POC if located outside of the US.
E_BIZ_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the electronic business POC.
E_BIZ_POC_EMAIL VARCHAR2 80 The contact email address of the electronic business POC.
ALT_E_BIZ_FIRST_NAME VARCHAR2 65 This field indicates the first name of electronic business alternate POC.
ALT_E_BIZ_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of electronic business alternate POC.
ALT_E_BIZ_LAST_NAME VARCHAR2 65 This field indicates the last name of electronic business alternate POC.
ALT_E_BIZ_TITLE VARCHAR2 50 This field indicates the title of electronic business alternate POC.
ALT_E_BIZ_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the electronic business alternate POC.
ALT_E_BIZ_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the electronic business alternate POC.
ALT_E_BIZ_CITY VARCHAR2 40 This is the city of the electronic business alternate POC.
ALT_E_BIZ_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the electronic business alternate POC.
ALT_E_BIZ_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the electronic business alternate POC.
ALT_E_BIZ_COUNTRY_CODE VARCHAR2 3 This is the country code of the electronic business alternate POC.
ALT_E_BIZ_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the electronic business alternate POC.
ALT_E_BIZ_US_PHONE VARCHAR2 30 The phone number of the electronic business alternate POC if located in the US.
ALT_E_BIZ_US_PHONE_EXT VARCHAR2 25 The phone number extension of the electronic business alternate POC if located in the US.
ALT_E_BIZ_NON_US_PHONE VARCHAR2 30 The phone number of the electronic business alternate POC if located outside of the US.
ALT_E_BIZ_FAX_US_ONLY VARCHAR2 30 The fax number of the electronic business alternate POC.
ALT_E_BIZ_EMAIL VARCHAR2 80 The contact email address of the electronic business alternate POC.
CERT_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of party performing certification POC.
CERT_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of party performing certification POC.
CERT_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of party performing certification POC.
CERT_POC_TITLE VARCHAR2 50 This field indicates the title of party performing certification POC.
CERT_POC_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the party performing certification POC.
CERT_POC_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the party performing certification POC.
CERT_POC_CITY VARCHAR2 40 This is the city of the party performing certification POC.
CERT_POC_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the party performing certification POC.
CERT_POC_ZIP_CODE_PLUS_4 NUMBER 4 This is the ZIP code plus 4 of the party performing certification POC.
CERT_POC_COUNTRY_CODE VARCHAR2 3 This is the country code of the party performing certification POC.
CERT_POC_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the party performing certification POC.
CERT_POC_US_PHONE VARCHAR2 30 The phone number of the party performing certification POC if located in the US.
CERT_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the party performing certification POC if located in the US.
CERT_POC_NON_US_PHONE VARCHAR2 30 The phone number of the party performing certification POC if located outside of the US.
CERT_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the party performing certification POC.
CERT_POC_EMAIL VARCHAR2 80 The contact email address of the party performing certification POC.
SOLE_PROP_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of sole proprietorship POC.
SOLE_PROP_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of sole proprietorship POC.
SOLE_PROP_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of sole proprietorship POC.
SOLE_PROP_POC_TITLE VARCHAR2 50 This field indicates the title of sole proprietorship POC.
SOLE_PROP_POC_US_PHONE VARCHAR2 30 The phone number of the sole proprietorship POC if located in the US.
SOLE_PROP_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the sole proprietorship POC if located in the US.
SOLE_PROP_POC_NON_US_PHONE VARCHAR2 30 The phone number of the sole proprietorship POC if located outside of the US.
SOLE_PROP_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the sole proprietorship POC.
SOLE_PROP_POC_EMAIL VARCHAR2 80 The contact email address of the sole proprietorship POC.
IMMED_PARENT_LEGAL_BIZ_NAME VARCHAR2 150 This is the legal business name of the immediate parent entity of the registrant.
IMMED_PARENT_UEI_SAM VARCHAR2 12 This is the UEI number of the immediate parent entity of the registrant.
IMMED_PARENT_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the immediate parent entity of the registrant.
IMMED_PARENT_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the immediate parent entity of the registrant.
IMMED_PARENT_CITY VARCHAR2 40 This is the city of the immediate parent entity of the registrant.
IMMED_PARENT_POSTAL_CODE VARCHAR2 50 This is the postal code of the immediate parent entity of the registrant.
IMMED_PARENT_COUNTRY_CODE VARCHAR2 3 This is the country code of the immediate parent entity of the registrant.
IMMED_PARENT_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the immediate parent entity of the registrant.
IMMED_PARENT_PHONE VARCHAR2 30 This is the phone number of the immediate parent entity of the registrant.
HQ_PARENT_LEGAL_BIZ_NAME VARCHAR2 150 This is the legal business name of the headquarter parent entity of the registrant.
HQ_PARENT_UEI_SAM VARCHAR2 12 This is the UEI number of the headquarter parent entity of the registrant.
HQ_PARENT_UEI_DUNS VARCHAR2 15 The Dun and Bradstreet Data Universal Numbering System (DUNS) number for the headquarter parent entity of the registrant.
HQ_PARENT_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the headquarter parent entity of the registrant.
HQ_PARENT_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the headquarter parent entity of the registrant.
HQ_PARENT_CITY VARCHAR2 40 This is the city of the headquarter parent entity of the registrant.
HQ_PARENT_POSTAL_CODE VARCHAR2 50 This is the postal code of the headquarter parent entity of the registrant.
HQ_PARENT_COUNTRY_CODE VARCHAR2 3 This is the country code of the headquarter parent entity of the registrant.
HQ_PARENT_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the headquarter parent entity of the registrant.
HQ_PARENT_PHONE VARCHAR2 30 This is the phone number of the headquarter parent entity of the registrant.
ULT_DPARENT_LEGAL_BIZ_NAME VARCHAR2 150 This is the legal business name of the ultimate domestic parent entity of the registrant.
ULT_DPARENT_UEI_SAM VARCHAR2 12 This is the UEI number of the ultimate domestic parent entity of the registrant.
ULT_DPARENT_UEI_DUNS VARCHAR2 15 The Dun and Bradstreet Data Universal Numbering System (DUNS) number for the ultimate domestic parent entity of the registrant.
ULT_DPARENT_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the ultimate domestic parent entity of the registrant.
ULT_DPARENT_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the ultimate domestic parent entity of the registrant.
ULT_DPARENT_CITY VARCHAR2 40 This is the city of the ultimate domestic parent entity of the registrant.
ULT_DPARENT_POSTAL_CODE VARCHAR2 50 This is the postal code of the ultimate domestic parent entity of the registrant.
ULT_DPARENT_COUNTRY_CODE VARCHAR2 3 This is the country code of the ultimate domestic parent entity of the registrant.
ULT_DPARENT_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the ultimate domestic parent entity of the registrant.
ULT_DPARENT_PHONE VARCHAR2 30 This is the phone number of the ultimate domestic parent entity of the registrant.
ULT_PARENT_LEGAL_BIZ_NAME VARCHAR2 150 This is the legal business name of the ultimate parent entity of the registrant.
ULT_PARENT_UEI_SAM VARCHAR2 12 This is the UEI number of the ultimate parent entity of the registrant.
ULT_PARENT_UEI_DUNS VARCHAR2 15 The Dun and Bradstreet Data Universal Numbering System (DUNS) number for the ultimate parent entity of the registrant.
ULT_PARENT_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the ultimate parent entity of the registrant.
ULT_PARENT_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the ultimate parent entity of the registrant.
ULT_PARENT_CITY VARCHAR2 40 This is the city of the ultimate parent entity of the registrant.
ULT_PARENT_POSTAL_CODE VARCHAR2 50 This is the postal code of the ultimate parent entity of the registrant.
ULT_PARENT_COUNTRY_CODE VARCHAR2 3 This is the country code of the ultimate parent entity of the registrant.
ULT_PARENT_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the ultimate parent entity of the registrant.
ULT_PARENT_PHONE VARCHAR2 30 This is the phone number of the ultimate parent entity of the registrant.
EVS_OUT_OF_BIZ_FLAG VARCHAR2 1 Indicates whether D and B monitoring has marked the entity out of business, 0 for no and 1 for yes.
EVS_MONITOR_LAST_UPDATE_DATE DATE The date EVS monitoring was last updated for the entity.
EVS_MONITOR_STATUS_FLAG VARCHAR2 1 This field indicates whether EVS monitoring is turned on for the entity.
EVS_MONITOR_LEGAL_BIZ_NAME VARCHAR2 120 This is the legal business name of the EVS monitoring of the registrant.
EVS_MONITOR_DBA_NAME VARCHAR2 120 The doing business as (DBA) name of the entity provided by EVS monitoring.
EVS_MONITOR_ADDRESS_1 VARCHAR2 150 The first line of the address as provided by EVS monitoring.
EVS_MONITOR_ADDRESS_2 VARCHAR2 150 The second line of the address as provided by EVS monitoring.
EVS_MONITOR_CITY VARCHAR2 40 The name of the city in which the entity is located as provided by EVS monitoring.
EVS_MONITOR_POSTAL_CODE VARCHAR2 50 The zip code in which the entity is located as provided by EVS monitoring.
EVS_MONITOR_COUNTRY_CODE VARCHAR2 3 The country code in which the entity is located as provided by EVS monitoring.
EVS_MONITOR_STATE_OR_PROVINCE VARCHAR2 55 The state or province code in which the entity is located as provided by EVS monitoring.
PROVIDE_EDI_FLAG VARCHAR2 1 This is the flag that determines whether the entity wants to enter EDI Information.
EDI_VAN_PROVIDER VARCHAR2 20 The Value Added Network (VAN) provider.
ISA_QUALIFIER VARCHAR2 2 The Interchange Sender (ISA) qualifier.
ISA_IDENTIFIER VARCHAR2 15 The Interchange Sender (ISA) identifier.
FUNCTIONAL_GROUP_IDENTIFIER VARCHAR2 15 This field indicates the Functional Group (GS02) identifier.
REQUEST_820S_FLAG VARCHAR2 1 This is the flag that determines whether the entity wants to receive remittance advice notices (820s) through the VAN provider.
EDI_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of EDI POC.
EDI_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of EDI POC.
EDI_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of EDI POC.
EDI_POC_TITLE VARCHAR2 50 This field indicates the title of EDI POC.
EDI_POC_US_PHONE VARCHAR2 30 The phone number of the EDI POC if located in the US.
EDI_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the EDI POC if located in the US.
EDI_POC_NON_US_PHONE VARCHAR2 30 The phone number of the EDI POC if located outside of the US.
EDI_POC_FAX_US_ONLY VARCHAR2 30 This field indicates fax number of the EDI POC.
EDI_POC_EMAIL VARCHAR2 80 The contact email address of the EDI POC.
TAX_IDENTIFIER_TYPE_CODE VARCHAR2 1 This data element identifies whether the tax identifier provided in the "Tax Identifier Number" column is either an SSN (1) or a TIN (2).
TAX_IDENTIFIER_NUMBER VARCHAR2 25 The taxpayer identification number (TIN) for an entity, either social security number for sole proprietors, or employer identification number (EIN). The EIN will be validated by the Internal Revenue Service (IRS).
AVERAGE_NUMBER_OF_EMPLOYEES VARCHAR2 25 The average number of employees at the location being registered. This must be less than or equal to the number of employees.
AVERAGE_ANNUAL_REVENUE VARCHAR2 25 This field indicates average annual revenue of the entity.
FINANCIAL_INSTITUTE_NAME VARCHAR2 50 The name of an entity's bank or other financial institution. This name must correspond to the routing number and will be pre-populated after the routing number is entered.
ENTITY_ACCOUNT_NUMBER VARCHAR2 30 The entity's financial account number.
ABA_ROUTING_ID NUMBER 30 The entity's American Banker's Association (ABA) routing number. This number must correspond to the name of the financial institute.
ACCOUNT_TYPE_CODE VARCHAR2 1 The entity's financial account type. "C" indicates checking and "S" indicates savings.
LOCKBOX_NUMBER VARCHAR2 20 An entity's lockbox number. This number is assigned by the financial institute.
AUTHORIZATION_DATE DATE This is the effective date of an entity's EFT account authorization. The authorization date will be pre-filled by the system as the date a registration was added/updated. The authorization date must be present if an ABA routing number/financial institute was entered.
EFT_WAIVER_FLAG VARCHAR2 1 The EFT waiver flag indicates whether banking information is required for the entity. “Y” indicates yes, “N” indicates no.
ACH_US_PHONE VARCHAR2 30 The phone number of the ACH if located in the US.
ACH_NON_US_PHONE VARCHAR2 30 The phone number of the ACH if located outside of the US.
ACH_FAX VARCHAR2 30 This field indicates fax number of the ACH.
ACH_EMAIL VARCHAR2 80 The contact email address of the Automated Clearing House (ACH).
REMITTANCE_NAME VARCHAR2 120 The name of the remittance location.
REMITTANCE_ADDRESS_LINE_1 VARCHAR2 150 This field indicates the first line address of remittance location.
REMITTANCE_ADDRESS_LINE_2 VARCHAR2 150 This field indicates the second line address of remittance location.
REMITTANCE_CITY VARCHAR2 40 This field indicates the city of remittance location.
REMITTANCE_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the remittance location.
REMITTANCE_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the remittance location.
REMITTANCE_ZIP_CODE_PLUS_4 NUMBER 4 The zip code plus 4 in which the remittance location is located.
REMITTANCE_COUNTRY_CODE VARCHAR2 3 This is the country code of the remittance location.
AR_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of accounts receivable POC.
AR_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of accounts receivable POC.
AR_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of accounts receivable POC.
AR_POC_TITLE VARCHAR2 50 This field indicates the title of accounts receivable POC.
AR_POC_US_PHONE VARCHAR2 30 The phone number of the accounts receivable POC if located in the US.
AR_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the accounts receivable POC if located in the US.
AR_POC_NON_US_PHONE VARCHAR2 30 The phone number of the accounts receivable POC if located outside of the US.
AR_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the accounts receivable POC in the US.
AR_POC_EMAIL VARCHAR2 80 The contact email address of the accounts receivable POC.
AP_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of accounts payable POC.
AP_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of accounts payable POC.
AP_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of accounts payable POC.
AP_POC_TITLE VARCHAR2 50 This field indicates the title of accounts payable POC.
AP_POC_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the accounts payable POC.
AP_POC_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the accounts payable POC.
AP_POC_CITY VARCHAR2 40 This is the city of the accounts payable POC.
AP_POC_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the accounts payable POC.
AP_POC_ZIP_CODE_PLUS_4 NUMBER 4 The zip code plus 4 in which the accounts payable POC is located.
AP_POC_COUNTRY_CODE VARCHAR2 3 This is the country code of the accounts payable POC.
AP_POC_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the accounts payable POC.
AP_POC_US_PHONE VARCHAR2 30 The phone number of the accounts payable POC if located in the US.
AP_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the accounts payable POC if located in the US.
AP_POC_NON_US_PHONE VARCHAR2 30 The phone number of the accounts payable POC if located outside of the US.
AP_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the accounts payable POC in the US.
AP_POC_EMAIL VARCHAR2 80 The contact email address of the accounts payable POC.
MPI_NUMBER VARCHAR2 9 The marketing partner identification number (MPIN) entered by the registrant.
NAICS_EXCEPTION_COUNT NUMBER 4 Four digit identifier that provides the number of NAICS exceptions to be provided in the NAICS exception string.
NAICS_EXCEPTIONS_INFORMATION CLOB Tilde (~) delimited string that includes exception information for any NAICS codes that the user has selected that has exceptions.
DEBT_SUBJECT_TO_OFFSET_FLAG VARCHAR2 1 The delinquent federal debt (DFD) certification (flag) tracks status of an outstanding delinquent federal debt owed by the registrant.
EXCLUSION_STATUS_CODE VARCHAR2 1 This flag indicates whether the entity has an active exclusion record. If this flag is set to “D”, this will indicate that the registrant has an exclusion record. A null value indicates that this entity does not have an active exclusion record.
SBA_BIZ_TYPES_COUNT NUMBER 4 Four digit identifier that provides the number of SBA business types to be provided in the SBA business types string.
SBA_BIZ_TYPES_INFORMATION CLOB Tilde (~) delimited string that includes SBA business type and expiration information as provided to SAM by SBA. For more information on the SBA business types string.
SAM_NUMERIC_TYPES_COUNT NUMBER 4 Four digit identifier that provides the number of numeric types to be provided in the SAM numerics code string.
SAM_NUMERIC_TYPES_INFORMATION CLOB Tilde (~) and caret (^) delimited string that includes numerics data as collected in the assertions page of the SAM Registration.
NO_PUBLIC_DISPLAY_CODE VARCHAR2 4 The field indicates whether an entity has chosen to opt-out of being displayed in public search results. You can chose to opt-out of being displayed in public search results via the website. Opting out may result in a reduction in federal government business opportunities, and subcontractors choosing this option will not be visible to prime contractors.
DISASTER_RESPONSE_COUNT NUMBER 4 Four digit identifier that provides the number of disaster response types to be provided in the disaster response string.
DISASTER_RESPONSES_INFORMATION CLOB Tilde (~) and caret (^) delimited string that includes disaster response data as collected in the assertions page of the SAM Registration.
ANNUAL_IGT_REVENUE VARCHAR2 25 The annual IGT revenue details the amount of revenue the intra-governmental transfer (IGT) entity receives via IGT transactions in a given year.
AGENCY_LOCATION_CODE VARCHAR2 8 The agency location code is used to identify accounting reports and documents prepared by or for agency accounting stations and disbursing offices.
DISBURSING_OFFICE_SYMBOL VARCHAR2 5 This is the unique symbol assigned by the Treasury IPAC system for the disbursing office.
MERCHANT_ID_1 VARCHAR2 130 The number assigned to an entity by the bank that processes their credit card receipts. The merchant ID number is similar to a routing number.
MERCHANT_ID_2 VARCHAR2 130 This is an alternate ID to merchant ID 1 and is used if the registering entity has two routing numbers (uses both banks).
ACCOUNTING_STATION VARCHAR2 6 Accounting station (fiscal station number) is a six-digit number that identifies the activity which is responsible for performing the official accounting and reporting for the funds.
SOURCE_ENTITY_CODE VARCHAR2 7 This data element identifies a federal government entity as either a 'DoD' entity or a 'federal' entity.
DEPARTMENT_CODE VARCHAR2 2 The two-digit agency/department code derived from the Treasury index.
HIERARCHY_DEPARTMENT_CODE VARCHAR2 4 The four digit code that identifies the department ID for the federal government entity. The department codes were originally sourced from FPDS and the NIST/FIPS 800-87 document.
HIERARCHY_DEPARTMENT_NAME VARCHAR2 150 The functional name that corresponds with the department code.
HIERARCHY_AGENCY_CODE VARCHAR2 4 The four digit code that identifies the agency ID for the federal government entity. The agency codes were originally sourced from FPDS and the NIST/FIPS 800-87 document.
HIERARCHY_AGENCY_NAME VARCHAR2 150 The functional name that corresponds with the Agency Code.
HIERARCHY_OFFICE_CODE VARCHAR2 6 The office code is an up-to six character identifier representing a U.S. government office in the SAM federal hierarchy. This code exists independently of the unique entity identifier used for registration purposes, i.e. UEI (DUNS), DoDAAC, or CAGE Code.
ELIM_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of eliminations POC.
ELIM_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of eliminations POC.
ELIM_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of eliminations POC.
ELIM_POC_TITLE VARCHAR2 50 This field indicates the title of eliminations POC.
ELIM_POC_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the eliminations POC.
ELIM_POC_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the eliminations POC.
ELIM_POC_CITY VARCHAR2 40 This is the city of the eliminations POC.
ELIM_POC_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the eliminations POC.
ELIM_POC_ZIP_CODE_PLUS_4 NUMBER 4 The zip code plus 4 in which the eliminations POC is located.
ELIM_POC_COUNTRY_CODE VARCHAR2 3 This is the country code of the eliminations POC.
ELIM_POC_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the eliminations POC.
ELIM_POC_US_PHONE VARCHAR2 30 The phone number of the eliminations POC if located in the US.
ELIM_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the eliminations POC if located in the US.
ELIM_POC_NON_US_PHONE VARCHAR2 30 The phone number of the eliminations POC if located outside of the US.
ELIM_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the eliminations POC.
ELIM_POC_EMAIL VARCHAR2 80 The contact email address of the eliminations POC.
SALES_POC_FIRST_NAME VARCHAR2 65 This field indicates the first name of Sales POC.
SALES_POC_MIDDLE_INITIAL VARCHAR2 3 This field indicates the middle name of sales POC.
SALES_POC_LAST_NAME VARCHAR2 65 This field indicates the last name of sales POC.
SALES_POC_TITLE VARCHAR2 50 This field indicates the title of sales POC.
SALES_POC_ST_ADDR_1 VARCHAR2 150 This is the street address line 1 of the sales POC.
SALES_POC_ST_ADDR_2 VARCHAR2 150 This is the street address line 2 of the sales POC.
SALES_POC_CITY VARCHAR2 40 This is the city of the sales POC.
SALES_POC_ZIP_OR_POSTAL_CODE VARCHAR2 50 This is the postal code of the sales POC.
SALES_POC_ZIP_CODE_PLUS_4 NUMBER 4 The zip code plus 4 in which the sales POC is located.
SALES_POC_COUNTRY_CODE VARCHAR2 3 This is the country code of the sales POC.
SALES_POC_STATE_OR_PROVINCE VARCHAR2 55 This is the state or province of the sales POC.
SALES_POC_US_PHONE VARCHAR2 30 The phone number of the sales POC if located in the US.
SALES_POC_US_PHONE_EXT VARCHAR2 25 The phone number extension of the sales POC if located in the US.
SALES_POC_NON_US_PHONE VARCHAR2 30 The phone number of the sales POC if located outside of the US.
SALES_POC_FAX_US_ONLY VARCHAR2 30 The fax number of the sales POC.
SALES_POC_EMAIL VARCHAR2 80 The contact email address of the sales POC.
TAXPAYER_NAME VARCHAR2 120 The name of the entity used for TIN validation. This name must match exactly to what the IRS has on file and may be different than the legal business name.
SAM_REC_STATUS VARCHAR2 30 Yes Single character code that defines the status of the record. i.e. New-N, In-Progress(I), Successfully Enriched(S) or Error(E).
LOAD_REQUEST_ID NUMBER 18 Yes Enterprise Service Scheduler: Indicates the request ID of the interface load job that created the row.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
FV_SAM_TRADING_PARTNER_INT_N1 Non Unique FUSION_TS_INTERFACE UNIQUE_ENTITY_IDENTIFIER_SAM, ENTITY_EFT_INDICATOR, SAM_REC_STATUS
FV_SAM_TRADING_PARTNER_INT_U1 Unique FUSION_TS_INTERFACE UNIQUE_ENTITY_IDENTIFIER_SAM, ENTITY_EFT_INDICATOR, LOAD_REQUEST_ID