USF_VNDR_HDR

(SQL Table)
 Index Back

USF Vendor Header Info

System for Award Management (SAM) Vendor Data 01/02/2018 -- Added USF_TAXPAYER_NAME to SBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USF_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity Identifier
2 USF_EFT_IND Character(4) VARCHAR2(4) NOT NULL Entity EFT Indicator

Default Value: 0000

3 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
6 USF_CAGE_CD Character(5) VARCHAR2(5) NOT NULL Cage Code
7 USF_DODAAC Character(9) VARCHAR2(9) NOT NULL Department of Defense Activity Address Code
8 USF_EXTRACT_CD Character(1) VARCHAR2(1) NOT NULL Extract Code
1=Delete send DUNS and CAGE
2=New - send complete record
3=Update - send complete record
4=Expired send DUNS and CAGE
A=Active
E=Expired
9 USF_REG_PURPOSE Character(2) VARCHAR2(2) NOT NULL Registration Purpose
Z1=Federal Assistance Awards
Z2=All Awards
Z3=IGT Only
Z4=Federal and IGT Awards
Z5=All Awards / IGT
10 REGISTRATION_DT Date(10) DATE Registration Date
11 EXPIRATION_DATE Date(10) DATE Expiration Date
12 LAST_UPDATE_DT Date(10) DATE Last Updated
13 USF_ACTIVATE_DT Date(10) DATE Activation Date
14 LEGAL_BUS_NAME Character(120) VARCHAR2(120) NOT NULL Legal Business Name
15 DBANAME Character(120) VARCHAR2(120) NOT NULL Doing Business As
16 USF_CO_DIVISION Character(60) VARCHAR2(60) NOT NULL Company Division
17 DIVISION_AREA_CD Character(10) VARCHAR2(10) NOT NULL Division/Area Code
18 USF_CONG_DIST Number(10,0) DECIMAL(10) NOT NULL Congressional District
19 START_DT Date(10) DATE Start Date
20 TRANS_FY Number(4,0) SMALLINT NOT NULL TRANS FISCAL YEAR
21 USF_SECURITY_LEVEL Character(2) VARCHAR2(2) NOT NULL Security Level
90=Non-Classified
92=Confidential
93=Secret
94=Top Secret
22 USF_EMPL_SEC_LVL Character(2) VARCHAR2(2) NOT NULL Security Level
90=Non-Classified
92=Confidential
93=Secret
94=Top Secret
23 USF_URL Character(200) VARCHAR2(200) NOT NULL Internet URL (Universal Resource Locator)
24 USF_ENTITY_TYPE Character(2) VARCHAR2(2) NOT NULL Entity Structure
2A=U.S. Government Entity
2J=Sole Proprietorship
2K=Partnership
2L=Corporate Entity
8H=Tax Exempt Corporate
CY=Foriegn Government
X6=International Organization
ZZ=Other
25 STATE_OF_INCORP Character(2) VARCHAR2(2) NOT NULL State of Incorporation
26 COUNTRY_OF_INC Character(3) VARCHAR2(3) NOT NULL Country of Incorporation
27 USF_AGENCY_BUS_PUR Character(1) VARCHAR2(1) NOT NULL Business Type
1=Buyer
2=Seller
3=Buyer / Seller
28 CREDIT_CARD_SELECT Character(1) VARCHAR2(1) NOT NULL Credit Card Selection
29 USF_CORRESP_FLG Character(1) VARCHAR2(1) NOT NULL Correspondence
30 EDI_OPTION Character(1) VARCHAR2(1) NOT NULL EDI Invoice Options
1=EDI Only
2=EDI and Print
3=Print Only
31 USF_EDI_VAN_PRVDR Character(20) VARCHAR2(20) NOT NULL EDI VAN Provider
32 USF_ISA_QUAL Character(2) VARCHAR2(2) NOT NULL ISA Qualifier
33 USF_ISA_ID Character(15) VARCHAR2(15) NOT NULL ISA Identifier
34 USF_FUNC_GRP_IDENT Character(15) VARCHAR2(15) NOT NULL Functional Group Identifier
35 USF_820_FLAG Character(3) VARCHAR2(3) NOT NULL Receive 820
NO=No
YES=Yes
36 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
37 USF_STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
38 USF_EOTP_EMPLCOUNT Number(25,0) DECIMAL(25) NOT NULL Employee Count
39 USF_ANNUAL_REVENUE Number(29,3) DECIMAL(28,3) NOT NULL Annual Revenue
40 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
41 USF_BANK_NAME Character(50) VARCHAR2(50) NOT NULL Bank Name
42 USF_BANK_ACCT_NBR Character(30) VARCHAR2(30) NOT NULL Bank Account Nbr
43 USF_DFI_ID_NUM Character(50) VARCHAR2(50) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/country. SAM specific field that needed 50 characters instead of the std 12 for DFI_ID_NUM
44 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit
03=Checking Account
05=Stock
06=Bond
07=Life Insurance Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined
45 LOCKBOX_NBR Character(20) VARCHAR2(20) NOT NULL LockBox Number
46 AUTHORIZATION_DT Date(10) DATE Date Authorized
47 EFT_WAIVER Character(1) VARCHAR2(1) NOT NULL EFT Waiver
F=Foriegn
N=No
Y=Yes
48 MPIN Character(9) VARCHAR2(9) NOT NULL Marketing Partner Id
49 USF_DELFED_DBT_FLG Character(1) VARCHAR2(1) NOT NULL Delinquent Federal Debt
N=No
Y=Yes
50 USF_EXCLUS_STATUS Character(1) VARCHAR2(1) NOT NULL Exclusion Status
51 USF_PUB_FLAG Character(1) VARCHAR2(1) NOT NULL No Public Display. This field has valid values of Y or null. This is from the SAM extract definition.
N=No
Y=Yes
52 USF_IGT_ANN_REV Number(29,3) DECIMAL(28,3) NOT NULL Annual Revenue
53 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code
54 DISBURSING_OFFICE Character(5) VARCHAR2(5) NOT NULL Field used by Payables
55 USF_MERCHANTID1 Character(130) VARCHAR2(130) NOT NULL Merchant ID
56 USF_MERCHANTID2 Character(130) VARCHAR2(130) NOT NULL Merchant ID
57 USF_ACCTG_STATION Character(6) VARCHAR2(6) NOT NULL Accounting Station
58 USF_SOURCE Character(7) VARCHAR2(7) NOT NULL Accounting Station
59 USF_DEPT_CODE Character(2) VARCHAR2(2) NOT NULL Department Code
60 USF_HIER_DEPTCD Character(4) VARCHAR2(4) NOT NULL Department Code
61 USF_HIER_DEPTNAME Character(150) VARCHAR2(150) NOT NULL Department Code
62 USF_HIER_AGCYCD Character(4) VARCHAR2(4) NOT NULL Department Code
63 USF_HIER_AGCYNAME Character(150) VARCHAR2(150) NOT NULL Department Code
64 USF_HIER_OFFCD Character(6) VARCHAR2(6) NOT NULL Department Code
65 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL File Path
66 FILE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL File Layout ID
67 FILE_CREATE_DT Date(10) DATE File Creation Date
68 AP_COMPLETE Character(1) VARCHAR2(1) NOT NULL AP Processing Flag
69 OM_COMPLETE Character(1) VARCHAR2(1) NOT NULL OM Processing Flag
70 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
71 USF_TAXPAYER_NAME Character(120) VARCHAR2(120) NOT NULL USF Taxpayer Name
72 USF_DBOPENDATA_FLG Character(1) VARCHAR2(1) NOT NULL D&B Open Data Flag

Default Value: Y

73 USF_EVS_OOB_IND Character(1) VARCHAR2(1) NOT NULL EVS Out of Business Indicator
74 USF_EVS_DT_OF_DATA Date(10) DATE EVS Monitoring Last Updated
75 USF_EVS_MON_STAT Character(1) VARCHAR2(1) NOT NULL EVS Monitoring Status
76 USF_DNB_OOB_IND Character(1) VARCHAR2(1) NOT NULL Dun and Bradstreet Out of Business Indicator
77 DB_DATE_OF_DATA Date(10) DATE Date of Data
78 USF_DNB_MON_STAT Character(1) VARCHAR2(1) NOT NULL DNB Monitoring Status
79 USF_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix