Treasury :: Financial Management Service
Enterprise Data Architecture
Data Dictionary/Change Log


Home :: Go Back :: Generate Excel (IE Only)
Please note that some of the metadata columns might not appear within the browser window - so please use the scroll bar to navigate horizontally. Depending on the filtering/sort criteria, you may experience a noticeable processing delay, please be patient.
StatusSchema Type NameUsed-InDefinition
NewelementACH_BatchReference/PaymentReporting/PaymentReportingBatchContains pertinent information about a set of ACH payments.
NewattributeACH_OriginalTraceNumber/PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_ReportingContains the Trace Number as originally included on the Entry being returned or acknowledged or on the Prenotification being rejected or corrected.
NewelementACH_PayeeBankInfo/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the payee bank information for ACH.
NewelementACH_Reporting/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the reporting ACH payment information.
NewelementACH_ReportingReturns/PaymentReporting/PaymentReportingBatch/ReportingDetailContains pertinent information about an ACH return record.
NewattributeACH_ReturnReasonCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_ReportingReturnsThe NACHA code provided by the Receiving DFI with the ACH return item to indicate the category of the return.
NewattributeACH_TraceNumber/PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_ReportingIdentifies each entry within a batch in an ACH input file.
NewattributeACH_TransactionCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_ReportingA code that identifies various types of debit and credit transactions. Portions of the code value can also be used to identify the account type associated with the transaction.
NewelementAddress/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the address information.
NewelementAddressLine/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressIndividual line of an address whose string length is limited by FMS systems.
NewattributeAgencyIdentifier/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbolIdentifies a major department or independent agency of the Federal government. Within the Treasury Account Symbol, this is used in conjunction with the main account code. The Agency Identifier represents the department, agency or establishment of the U.S. Government that is responsible for the Treasury Account Symbol.
NewattributeAgencyLocationCode/PaymentReporting/PaymentReportingBatch/OriginatingAgency,

/PaymentReporting/PaymentReportingBatch/ReportingDetail/OriginatingAgency
Identifies the accounting office within an agency that reports disbursements and collections to Treasury.
NewattributeAgencyPaymentTypeCode/PaymentReporting/PaymentReportingBatch/ReportingDetailInternal agency code used to identify the type of payment within the specific agency.
NewattributeAllocationTransferAgencyIdentifier/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbolRepresents the agency receiving funds through an allocation transfer.
NewattributeAmount/PaymentReporting/PaymentReportingBatch/ReportingDetail,

/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification,

/PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetail
The transaction amount.
NewattributeAvailabilityTypeCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbolIdentifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M).
NewattributeBeginningPeriodOfAvailability/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbolIn annual and multiyear accounts, identifies the first year of availability under law that an account may incur new obligations.
NewelementBusinessEventType/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassificationThe container for the BusinessEventTypeCode which is used in combination with the Treasury Account Symbol to classify transactions reported to Treasury.
NewattributeBusinessEventTypeCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/BusinessEventTypeIdentifies the type of activity (gross disbursement, offsetting collection, investment in Treasury securities, etc.) and the effect of a transaction on the Fund Balance With Treasury (FBWT). Is used in combination with the Treasury Account Symbol to classify transactions reported to Treasury through all Governmentwide Accounting (GWA-compliant) Financial Management Systems.
NewattributeBusinessEventTypeName/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/BusinessEventTypeIdentifies the name of the Business Event Type Code.
NewattributeBusinessFunctionCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/WireReportingA code that identifies the type of business the Fedwire Message represents.
NewattributeBusinessIdentifierCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/SWIFT_ReportingDetailThe Business Identifier Code (BIC) is an established international standard (ISO 9362). It provides an identifier for institutions within the financial services industry to facilitate automated processing of telecommunication messages in banking and related financial transaction environments.
NewattributeCheckAccountingMonthAndYear/PaymentReporting/PaymentReportingBatch/CheckReportingBatchThe accounting month under which the check issues in the batch will be reported to Governmentwide Accounting (GWA).
NewattributeCheckBatchCreationDate/PaymentReporting/PaymentReportingBatch/CheckReportingBatchThe date the set of checks was printed.
NewattributeCheckFirstSerialNumber/PaymentReporting/PaymentReportingBatch/CheckReportingBatchThe first serial number in a set of checks.
NewattributeCheckIssueDate/PaymentReporting/PaymentReportingBatch/ReportingDetail/CheckReportingDetailThe date of payment inscribed on the check.
NewelementCheckReportingBatch/PaymentReporting/PaymentReportingBatchContains pertinent information about a set of Check payments.
NewelementCheckReportingDetail/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the reporting check payment information.
NewattributeCheckSerialNumber/PaymentReporting/PaymentReportingBatch/ReportingDetail/CheckReportingDetailContains the serial number of a check; i.e., the number that typically resides in the top right-hand corner of a check.
NewattributeCheckSymbolNumber/PaymentReporting/PaymentReportingBatch/CheckReportingBatchA number within the range of 1000 and 9998 which uniquely identifies the agency issuing the US Treasury Check.
NewattributeCityName/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressContains a city name.
NewattributeConsularCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressA predefined code used between Treasury and USPS. Indicates the code for mailing bulk check shipments to non-US countries via the consulate.
NewattributeCountryCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressContains the code for a country.
NewattributeDFI_AccountNumber/PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_PayeeBankInfoThe account number of the payment recipient at the receiving bank.
NewattributeDisbursingOfficeSymbol/PaymentReporting/PaymentReportingBatch/CheckReportingBatchA number assigned to the agency which is disbursing funds from the Treasury General Account (TGA).
NewattributeDUNS_Number/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetailThe Dunn and Bradstreet Identification Number is a unique nine-character number that identifies an organization.
NewattributeEndingPeriodOfAvailability/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbolIn annual and multiyear accounts, identifies the last year of availability under law that an account may incur new obligations.
NewelementFirstName/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonNameA name that precedes one's surname.
NewelementForeignCurrencyDetail/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the original currency code of this transaction.
NewattributeForeignPostalCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressA code added to a foreign address line, typically for the purpose of sorting mail.
NewattributeFullName/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonNameContains the full name of a person.
NewattributeIDV_ProcurementAgencyIdentifier/PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetailThis is a code for an agency, but it does not necessarily represent the agency that issued the contract. Instead, it serves as part of the unique identification for Federal Procurement Data System IDV records. For awards records, it partially identifies a linked IDV record.
NewattributeIDV_ProcurementInstrumentIdentifier/PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetailWhen reporting orders under Indefinite Delivery Vehicles (IDV) such as a GWAC, IDC, FSS, BOA, or BPA, report the Procurement Instrument Identifier (Contract Number or Agreement Number) of the IDV. For the initial load of a BPA under a FSS, this is the FSS contract number. Note: BOAs and BPAs are with industry and not with other Federal Agencies.
NewattributeIMAD/PaymentReporting/PaymentReportingBatch/ReportingDetail/WireReportingInput Messaging Accountability Data: A combination of a date, source identifier, and sequence number assigned to a Fedwire message when it is processed by the Federal Reserve Bank Funds Transfer application.
NewattributeInputSystem/PaymentReportingIdentifies the sending trading partner.
NewattributeIsCourtesyCheck/PaymentReporting/PaymentReportingBatch/CheckReportingBatchA code that indicates whether the check is a regular check or a check that is reissued as a special service to certain agencies by a Regional Financial Center (RFC).
NewattributeIsCredit/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassificationIndicates if the item is a debit or credit so it can be interpreted as a positive or negative value.
NewattributeIsNonDomestic/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressIndicates whether the entity or transaction is considered non domestic.
NewattributeIsRepresentativePayee/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetailIdentifies whether the recipient is a representative for the beneficiary.
NewattributeIsVoidedCheck/PaymentReporting/PaymentReportingBatch/ReportingDetail/CheckReportingDetailIndicates whether the check has been voided in the process of printing.
NewattributeMainAccountCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbolIdentifies the type and purpose of the fund.
NewelementMiddleName/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonNameA person's name after the first name and before the surname.
NewelementNameSuffix/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonNameA part of a name that follows the last name.
NewattributeOMAD/PaymentReporting/PaymentReportingBatch/ReportingDetail/WireReportingOutput Messaging Accountability Data: A combination of a date, destination identifier, and sequence number assigned to a Fedwire message when it is processed by the Federal Reserve Bank Funds Transfer application.
NewattributeOriginalCurrencyCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/ForeignCurrencyDetailThis code list defines the enumerated types of standard 3-letter ISO 4217 currency codes. See the ISO site for an explanation of each code: http://www.iso.ch/iso/en/catsupport/maralist.html#4217. If the attribute is not populated and does not exist in the XML instance document, then the default will be understood to be 'USD'.
NewelementOriginalPaymentReference/PaymentReporting/PaymentReportingBatch/ReportingDetailProvides an identifier to link to the original payment.
NewelementOriginalScheduleReference/PaymentReporting/PaymentReportingBatch/ReportingDetailIndicates a reference to an original Schedule transaction.
NewelementOriginalSummary/PaymentReporting/PaymentReportingBatch/ReportingDetailContains a reference to the original summary record.
NewelementOriginatingAgency/PaymentReporting/PaymentReportingBatch,

/PaymentReporting/PaymentReportingBatch/ReportingDetail
Identifies the originating agency of a record.
NewelementOriginatingDFI/PaymentReporting/PaymentReportingBatchThe agency from which an ACH transaction is paid.
NewelementOriginatingDI/PaymentReporting/PaymentReportingBatchThe agency from which a wire transaction is paid.
NewelementPartyDetail/PaymentReporting/PaymentReportingBatch/ReportingDetailContains party detail information.
NewattributePartyName/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetailContains the full name of a party.
NewattributePayeeIdentifier/PaymentReporting/PaymentReportingBatch/ReportingDetailAccount number used internally by an agency to identify a payee.
NewattributePayeeName/PaymentReporting/PaymentReportingBatch/ReportingDetailThe person to which the payment instrument is made payable.
NewattributePayerMechanismCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentMethodIdentifies the payment medium for the transaction.
NewelementPaymentClassification/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the account classification of a payment.
NewattributePaymentID/PaymentReporting/PaymentReportingBatch/ReportingDetail,

/PaymentReporting/PaymentReportingBatch/ReportingDetail/OriginalPaymentReference
Identifier assigned by the agency that is unique within the Schedule. When combined with the Schedule Number, AgencyLocationCode, and Fiscal Year, this makes a globally unique identifier for the payment.
NewelementPaymentMethod/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the mechanism of the payment.
NewelementPaymentReportingStandard Payment Report format
NewelementPaymentReportingBatch/PaymentReportingSet of payments that are reported to FMS after issuance by an agency.
NewattributePaymentTypeCode/PaymentReporting/PaymentReportingBatch/ReportingDetailCode denoting the type of sub-payment.
NewelementPersonName/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetailContains the name of a person.
NewattributePostalCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressA code added to an address line, typically for the purpose of sorting mail.
NewattributePostalCodeExtension/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressThe purpose of +4 codes is to aid efficient mail sorting and delivery. Business mailers are the primary users of ZIP+4’s, because mailers who mail in bulk on the ZIP+4 or carrier route level can receive rate discounts. (ref: http://www.carrierroutes.com/ZIPCodes.html)
NewattributePostNetBarcodeDeliveryPoint/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressPostNet barcode that is applied to the check for obtaining postage discounts.
NewattributeProcurementAgencyIdentifier/PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetailThis is a code for a governmental agency, but it does not necessarily represent the agency that issued the contract. Instead, it serves only as part of the unique identification for Federal Procurement Data System awards records.
NewelementProcurementDetail/PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetailsContains the fields necessary to connect to a Federal Procurement Data System (FPDS) record set at USAspending.gov.
NewelementProcurementDetails/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the individual Procurement Detail records.
NewattributeProcurementInstrumentIdentifier/PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetailThe unique identifier for each contract, agreement or order.
NewelementReceiverDI/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the routing number of the bank to which a wire transaction is sent.
NewelementReceivingDFI/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the routing number of the bank to which an ACH transaction is sent.
NewattributeRegionName/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressIndicates the foreign state, territory, or province name.
NewelementReportingDetail/PaymentReporting/PaymentReportingBatchContains information about a specific reporting payment record.
NewattributeRoutingNumber/PaymentReporting/PaymentReportingBatch/OriginatingDI,

/PaymentReporting/PaymentReportingBatch/OriginatingDFI,

/PaymentReporting/PaymentReportingBatch/ReportingDetail/ReceivingDFI,

/PaymentReporting/PaymentReportingBatch/ReportingDetail/ReceiverDI
The routing number is used synonymously as ABA routing number and routing transit number. The routing number consists of 9 digits, for example XXXXYYYYC where XXXX is Federal Reserve Routing Symbol, YYYY is ABA Institution Identifier, and C is the Check Digit. The first two digits of the nine digit routing number must be in the ranges 00 through 12, 21 through 32, 61 through 72, or 80. The digits are assigned as follows: 00 is used by the United States Government; 01 through 12 are the normal routing numbers; 21 through 32 were assigned only to thrift institutions (e.g. credit unions and savings banks) through 1985, currently are still used by the thrift institutions, or their successors; 61 through 72 are used for electronic transactions; 80 is used for traveler's checks. The first two digits correspond to the 12 Federal Reserve Banks. [reference: http://www.tfp.com/text/aba_policy.pdf]
NewattributeScheduleNumber/PaymentReporting/PaymentReportingBatch,

/PaymentReporting/PaymentReportingBatch/ReportingDetail/OriginalScheduleReference
The schedule number assigned by the agency to identify this set of payments .
NewattributeStandardEntryClassCode/PaymentReporting/PaymentReportingBatch/ACH_BatchReferenceIdentifies the NACHA payment type.
NewattributeStateCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressUS state codes and Canadian province codes.
NewattributeSub-accountCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbolIdentifies an available receipt or other Treasury-defined subdivision of the main account.
NewattributeSub-levelPrefixCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbolWhen populated, represents a programmatic breakdown of the account for Treasury publication purposes.
NewattributeSummaryDate/PaymentReporting/PaymentReportingBatch/VoucherDetail,

/PaymentReporting/PaymentReportingBatch/ReportingDetail/OriginalSummary
The date for the summary record. The date that is represented can vary depending on the value of Summary Type. For example, if the Summary Type value is 'Voucher', then this date would represent the Voucher Date. If the Summary Type value is 'Transfer', then this date would represent the Transfer Date.
NewattributeSummaryNumber/PaymentReporting/PaymentReportingBatch/VoucherDetailThe number of the summary record, for example the deposit ticket number or the debit voucher number.
NewelementSurname/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonNameThe name borne in common by members of a family.
NewelementSWIFT_ReportingDetail/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the SWIFT detail for a payment.
NewattributeTIN/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetailA Taxpayer Identification Number (TIN) is an identification number used by the Internal Revenue Service (IRS) in the administration of tax laws. It is issued either by the Social Security Administration (SSA) or by the IRS. A Social Security number (SSN) is issued by the SSA whereas all other TINs are issued by the IRS.
NewattributeTIN_Code/PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetailIndicates the type of Tax Identification Number.
NewattributeTotalAmount/PaymentReporting/PaymentReportingBatch/VoucherDetailIndicates the total absolute dollar amount of items.
NewelementTreasuryAccountSymbol/PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassificationThe Treasury Account Symbol is an identification code assigned by Treasury, in collaboration with OMB and the owner agency, to an individual appropriation, receipt, or other fund account. (These accounts are defined in I TFM 2-1500.)
NewattributeUSPS_IntelligentMailBarCode/PaymentReporting/PaymentReportingBatch/ReportingDetail/AddressField used for all intelligent barcode data elements. An agency must work with their Treasury payment servicing center and the US Postal Service to arrange for this service.
NewattributeVersionIdentifier/PaymentReportingIndicates an identifier assigned to a version for this transmission.
NewelementVoucherDetail/PaymentReporting/PaymentReportingBatchContains referenced summary data.
NewattributeVoucherFormCode/PaymentReporting/PaymentReportingBatch/VoucherDetailIdentifies the type of voucher record, i.e., 215, 215A, 5515, etc.)
NewelementWireReporting/PaymentReporting/PaymentReportingBatch/ReportingDetailContains the reporting wire payment information.
For help, please contact the Treasury FMS Enterprise Data Architecture team.
Last Updated: 2012-06-28T18:59:04.562-04:00

This web site is informative only and may contain publishing errors/inconsistencies - please carefully review the appropriate XML Schema documents in the Download section.