Federal Procurement Data System – Next Generation (FPDS-NG)
Purchase Card Transactions
Validation Rules
General Services Administration
Office of Acquisition Policy
1800 F Street, Room 4020, NW
Washington, DC 20405
Prepared by:
Global Computer Enterprises, Inc.
10780 Parkridge Blvd., Suite 300
Reston, VA 20191
January 17, 2006
FPDS-NG Purchase Card Validation Rules
Table of Contents
1Overview of validations
2VALIDATIONS FOR DATA ELEMENTS
1FAgency Code
2GPeriod of Report
8GNAICS Code
9ADun & Bradstreet Number
13AMerchant TIN
13UWoman Owned
13VVeteran Owned
13WService Disabled Veteran Owned
13XOther Disadvantaged Business
13YSBA Certified HUBZone Small Business
13ZSBA 8(a) Certified
13AA SBA 8(a) Certified Small Disadvantaged
13GG Merchant’s Name
13HH Doing Business As
13JJStreet Address
13MMCity
13NN State Code
13PP Postal Code
13QQ Country Code
13AAAMerchant Austin Tetra Number
13AABMerchant Category Code
13AACMerchant Type
13AADFor Profit Business Size
13AAEFor Profit Business Ownership
13AAFParent Austin Tetra Number
13AAGParent Name
30AGSA SmartPay® Bank Name
30BCard Brand
31ANumber of Trans <= $2.5k
31BDollars <= $2.5k
31CNumber of Trans >= $2.5k
31DDollars >= $2.5k
1
FPDS-NG Purchase Card Validation Rules
Document History
Number / Date / Author / Description1.0 / 01/17/2006 / Sai Kosaraju / Draft
1
FPDS-NG Purchase Card Validation Rules
1Overview of validations
GSA SmartPay®Banks transmit the purchase card transaction data to FPDS-NG via FTP. FPDS-NG validates the data submitted to it. Types of validation include:
1)Code validation such as verifying that an “Agency Code” is a valid code in the FIPS 95 table.
2)Formatting of the data elements such as “Merchants Name” should be left justified and must not be blank.
2VALIDATIONS FOR DATA ELEMENTS
1FAgency Code
Serial Number / Element / Characteristics / Rule1 / Format / Agency Code must not be blank
2 / FIPS 95 Look-up Table / Agency Codemust be in the FPDS-NG FIPS 95 Agencies/Sub-agency look-up table.
2GPeriod of Report
Serial Number / Element / Characteristics / Rule1 / Format / Period of Report must be numeric.
2 / Format / Period of Report must not be greater than current fiscal year
3 / Format / Period of Report must not be greater than current quarter
4 / Format / Period of Report must be the Federal Government fiscal year quarter. (Valid values are 1, 2, 3, and 4) First 4 characters must be the current fiscal year or a prior fiscal year. Fifth character must be 1, 2, 3, or 4.
8GNAICS Code
Serial Number / Element / Characteristics / Rule1 / NAICS Table / NAICS Code must be a valid value from NAICS table (
9ADun & Bradstreet Number
Serial Number / Element / Characteristics / Rule1 / CCR / Dun & Bradstreet Number must be validated using CCR. If not found in CCR then Check Digit Algorithm is used
13AMerchant TIN
Serial Number / Element / Characteristics / Rule1 / Format / Merchant TIN must not include hyphens
2 / Format / Merchant TIN must not be all 9s or other string of same numbers (all 1s, all 2s, etc.)
3 / State Code / Merchant TIN must be 9 digit numeric code if the state code has an entry, otherwise may be blank
13UWoman Owned
Serial Number / Element / Characteristics / Rule1 / Merchant Type / Woman Owned must be Y,N or X if Merchant Type is F
2 / Merchant Type / Woman Owned must be X if merchant type is N, U, S, O.
13VVeteran Owned
Serial Number / Element / Characteristics / Rule1 / Merchant Type / Veteran Owned must be Y,N or X if Merchant Type is F
2 / Merchant Type / Veteran Owned must be X if merchant type is N, U, S, O.
13WService DisabledVeteran Owned
Serial Number / Element / Characteristics / Rule1 / Merchant Type / Service Disabled Veteran Owned must be Y,N or X if Merchant Type is F
2 / Merchant Type / Service Disabled Veteran Owned must be X if merchant type is N, U, S, O.
13XOther Disadvantaged Business
Serial Number / Element / Characteristics / Rule1 / Merchant Type / Other Disadvantaged Business must be Y,S or X if Merchant Type is F
2 / Merchant Type / Other Disadvantaged Business must be X if merchant type is N, U, S, O.
13YSBA Certified HUBZone Small Business
Serial Number / Element / Characteristics / Rule1 / Merchant Type / SBA Certified HUBZone Small Business must be Y,N or X if Merchant Type is F
2 / For Profit Business Size / SBA Certified HUBZone Small Business has a value then For Profit Business Size must be “S”
3 / Merchant Type / SBA Certified HUBZone Small Businessmust be X if merchant type is N, U, O.
13ZSBA 8(a) Certified
Serial Number / Element / Characteristics / Rule1 / Merchant Type / SBA 8(a) Certified must be Y,N or X if Merchant Type is F
2 / For Profit Business Size / SBA 8(a) Certified has a value then For Profit Business Size must be “S”
3 / Merchant Type / SBA 8(a) Certified must be X if merchant type is N, U, O.
13AASBA 8(a) Certified Small Disadvantaged
Serial Number / Element / Characteristics / Rule1 / Merchant Type / SBA 8(a) Certified Small Disadvantaged must be Y,N or X if Merchant Type is F
2 / For Profit Business Size / SBA 8(a) Certified Small Disadvantaged has a value then For Profit Business Size must be “S”
3 / Merchant Type / SBA 8(a) Certified Small Disadvantaged must be X if merchant type is N, U, O.
13GGMerchant’s Name
Serial Number / Element / Characteristics / Rule1 / Format / Merchant’s Name must not be blank
13HHDoing Business As
13JJStreet Address
13MMCity
Serial Number / Element / Characteristics / Rule1 / Format / City must not be blank
2 / Format / City must contain only characters and special characters commonly used in city names such as dashes and periods
13NNState Code
Serial Number / Element / Characteristics / Rule1 / Format / State Code must not be blank if the business is in the US or a US outlying area
2 / FIPS 55 Look-up Table / StateCodemust be in the FPDS-NG FIPS 55 look-up table.
3 / Country Code / State Code must be blank if Country Code has an entry and is not in US
13PPPostal Code
Serial Number / Element / Characteristics / Rule1 / State Code / Postal Code must be a valid 5 or 9 numeric character U.S. zip code if State Code has an entry
13QQCountry Code
Serial Number / Element / Characteristics / Rule1 / ISO / Country Code must be 3 character alpha code from ISO
2 / State Code / Country Codemust not be blank if State Code is blank
3 / State Code / Country Code must be USA if State Code has a value.
13AAAMerchant Austin Tetra Number
Serial Number / Element / Characteristics / Rule1 / Format / Merchant Austin Tetra Number must be numeric.
13AABMerchant Category Code
Serial Number / Element / Characteristics / Rule1 / Format / Merchant Category Code must not be blank
2 / Format / Merchant Category code must be a valid X9 (9 position) code.
3 / Merchant Category Code Table / Merchant Category Code must be a valid value provided by the association (VISA/MasterCard) at
13AACMerchant Type
Serial Number / Element / Characteristics / Rule1 / Merchant Type / Merchant Type must be one of the following codes:
F = For Profit Business
N = Non Profit Organization
U = US Government
S = State/Local Government
O = other (e.g., foreign government/international
organization)
13AADFor Profit Business Size
Serial Number / Element / Characteristics / Rule1 / For Profit Business Size / For Profit Business Size must be one of the following codes:
L = Large Business
S = Small Business
X = Unknown
2 / Merchant Type / For Profit Business Size must be L,S or X if Merchant Type is F
3 / Merchant Type / For Profit Business Size must be blank if merchant type is N, U, S, O.
4 / Merchant Type / An error message must be logged if merchant type is not “F” and a value is listed for this For Profit Business Size
13AAEFor Profit Business Ownership
13AAFParent Austin Tetra Number
Serial Number / Element / Characteristics / Rule1 / Format / Parent Austin Tetra Number must be numeric.
13AAGParent Name
Serial Number / Element / Characteristics / Rule1 / Parent Austin Tetra Number / Parent Name must not be blank if Parent Austin Tetra Number is entered.
30AGSA SmartPay® Bank Name
Serial Number / Element / Characteristics / Rule1 / Format / GSA SmartPay® Bank Name must have one of the following valid values:
- BOA = Bank of America
- CIT = Citibank
- JPM = J P Morgan Chase
- MEL = Mellon
- USB = US Bank
30BCard Brand
Serial Number / Element / Characteristics / Rule1 / Format / Card Brand must have one of the following valid values:
- MC = MasterCard
- VI = Visa
31ANumber of Trans <= $2.5k
Serial Number / Element / Characteristics / Rule1 / Format / Number of Trans <= $2.5k must be numeric
2 / Format / Number of Trans <= $2.5k must not have spaces or special characters if not blank
31BDollars <= $2.5k
Serial Number / Element / Characteristics / Rule1 / Format / Dollars < $2.5k must be numeric.
2 / Format / Dollars < $2.5k must have a decimal at Third position from right.
3 / Format / Dollars < $2.5k must have minus sign in front of negative values
4 / Number of Trans <= $2.5k / Dollars < $2.5kmust not equal zero if “Number of Trans < $2.5K” is greater than zero.
31CNumber of Trans >= $2.5k
Serial Number / Element / Characteristics / Rule1 / Format / Number of Trans >= $2.5k must be numeric
2 / Format / Number of Trans >= $2.5k must not have spaces or special characters if not blank
31DDollars >= $2.5k
Serial Number / Element / Characteristics / Rule1 / Format / Dollars > $2.5k must be numeric.
2 / Format / Dollars >$2.5k must have a decimal at Third position from right.
3 / Format / Dollars > $2.5k must have minus sign in front of negative values
4 / Number of Trans >= $2.5k / Dollars $2.5kmust not equal zero if “Number of Trans > $2.5K” is greater than zero.
1