| Treasury :: Bureau of the Fiscal 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. |
| Status | Schema Type | Name | Used-In | Definition |
|---|---|---|---|---|
| New | element | ACH_BatchReference | /PaymentReporting/PaymentReportingBatch | Contains pertinent information about a set of ACH payments. |
| New | attribute | ACH_OriginalTraceNumber | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_Reporting | Contains the Trace Number as originally included on the Entry being returned or acknowledged or on the Prenotification being rejected or corrected. |
| New | element | ACH_PayeeBankInfo | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the payee bank information for ACH. |
| New | element | ACH_Reporting | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the reporting ACH payment information. |
| New | element | ACH_ReportingReturns | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains pertinent information about an ACH return record. |
| New | attribute | ACH_ReturnReasonCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_ReportingReturns | The NACHA code provided by the Receiving DFI with the ACH return item to indicate the category of the return. |
| New | attribute | ACH_TraceNumber | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_Reporting | Identifies each entry within a batch in an ACH input file. |
| New | attribute | ACH_TransactionCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_Reporting | A 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. |
| New | element | Address | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the address information. |
| New | element | AddressLine | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | Individual line of an address whose string length is limited by FMS systems. |
| New | attribute | AgencyIdentifier | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbol | Identifies 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. |
| New | attribute | AgencyLocationCode | /PaymentReporting/PaymentReportingBatch/OriginatingAgency, /PaymentReporting/PaymentReportingBatch/ReportingDetail/OriginatingAgency | Identifies the accounting office within an agency that reports disbursements and collections to Treasury. |
| New | attribute | AgencyPaymentTypeCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Internal agency code used to identify the type of payment within the specific agency. |
| New | attribute | AllocationTransferAgencyIdentifier | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbol | Represents the agency receiving funds through an allocation transfer. |
| New | attribute | Amount | /PaymentReporting/PaymentReportingBatch/ReportingDetail, /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification, /PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetail | The transaction amount. |
| New | attribute | AvailabilityTypeCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbol | Identifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M). |
| New | attribute | BeginningPeriodOfAvailability | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbol | In annual and multiyear accounts, identifies the first year of availability under law that an account may incur new obligations. |
| New | element | BusinessEventType | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification | The container for the BusinessEventTypeCode which is used in combination with the Treasury Account Symbol to classify transactions reported to Treasury. |
| New | attribute | BusinessEventTypeCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/BusinessEventType | Identifies 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. |
| New | attribute | BusinessEventTypeName | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/BusinessEventType | Identifies the name of the Business Event Type Code. |
| New | attribute | BusinessFunctionCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/WireReporting | A code that identifies the type of business the Fedwire Message represents. |
| New | attribute | BusinessIdentifierCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/SWIFT_ReportingDetail | The 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. |
| New | attribute | CheckAccountingMonthAndYear | /PaymentReporting/PaymentReportingBatch/CheckReportingBatch | The accounting month under which the check issues in the batch will be reported to Governmentwide Accounting (GWA). |
| New | attribute | CheckBatchCreationDate | /PaymentReporting/PaymentReportingBatch/CheckReportingBatch | The date the set of checks was printed. |
| New | attribute | CheckFirstSerialNumber | /PaymentReporting/PaymentReportingBatch/CheckReportingBatch | The first serial number in a set of checks. |
| New | attribute | CheckIssueDate | /PaymentReporting/PaymentReportingBatch/ReportingDetail/CheckReportingDetail | The date of payment inscribed on the check. |
| New | element | CheckReportingBatch | /PaymentReporting/PaymentReportingBatch | Contains pertinent information about a set of Check payments. |
| New | element | CheckReportingDetail | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the reporting check payment information. |
| New | attribute | CheckSerialNumber | /PaymentReporting/PaymentReportingBatch/ReportingDetail/CheckReportingDetail | Contains the serial number of a check; i.e., the number that typically resides in the top right-hand corner of a check. |
| New | attribute | CheckSymbolNumber | /PaymentReporting/PaymentReportingBatch/CheckReportingBatch | A number within the range of 1000 and 9998 which uniquely identifies the agency issuing the US Treasury Check. |
| New | attribute | CityName | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | Contains a city name. |
| New | attribute | ConsularCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | A predefined code used between Treasury and USPS. Indicates the code for mailing bulk check shipments to non-US countries via the consulate. |
| New | attribute | CountryCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | Contains the code for a country. |
| New | attribute | DFI_AccountNumber | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ACH_PayeeBankInfo | The account number of the payment recipient at the receiving bank. |
| New | attribute | DisbursingOfficeSymbol | /PaymentReporting/PaymentReportingBatch/CheckReportingBatch | A number assigned to the agency which is disbursing funds from the Treasury General Account (TGA). |
| New | attribute | DUNS_Number | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail | The Dunn and Bradstreet Identification Number is a unique nine-character number that identifies an organization. |
| New | attribute | EndingPeriodOfAvailability | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbol | In annual and multiyear accounts, identifies the last year of availability under law that an account may incur new obligations. |
| New | element | FirstName | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonName | A name that precedes one's surname. |
| New | element | ForeignCurrencyDetail | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the original currency code of this transaction. |
| New | attribute | ForeignPostalCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | A code added to a foreign address line, typically for the purpose of sorting mail. |
| New | attribute | FullName | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonName | Contains the full name of a person. |
| New | attribute | IDV_ProcurementAgencyIdentifier | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetail | This 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. |
| New | attribute | IDV_ProcurementInstrumentIdentifier | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetail | When 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. |
| New | attribute | IMAD | /PaymentReporting/PaymentReportingBatch/ReportingDetail/WireReporting | Input 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. |
| New | attribute | InputSystem | /PaymentReporting | Identifies the sending trading partner. |
| New | attribute | IsCourtesyCheck | /PaymentReporting/PaymentReportingBatch/CheckReportingBatch | A 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). |
| New | attribute | IsCredit | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification | Indicates if the item is a debit or credit so it can be interpreted as a positive or negative value. |
| New | attribute | IsNonDomestic | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | Indicates whether the entity or transaction is considered non domestic. |
| New | attribute | IsRepresentativePayee | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail | Identifies whether the recipient is a representative for the beneficiary. |
| New | attribute | IsVoidedCheck | /PaymentReporting/PaymentReportingBatch/ReportingDetail/CheckReportingDetail | Indicates whether the check has been voided in the process of printing. |
| New | attribute | MainAccountCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbol | Identifies the type and purpose of the fund. |
| New | element | MiddleName | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonName | A person's name after the first name and before the surname. |
| New | element | NameSuffix | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonName | A part of a name that follows the last name. |
| New | attribute | OMAD | /PaymentReporting/PaymentReportingBatch/ReportingDetail/WireReporting | Output 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. |
| New | attribute | OriginalCurrencyCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ForeignCurrencyDetail | This 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'. |
| New | element | OriginalPaymentReference | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Provides an identifier to link to the original payment. |
| New | element | OriginalScheduleReference | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Indicates a reference to an original Schedule transaction. |
| New | element | OriginalSummary | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains a reference to the original summary record. |
| New | element | OriginatingAgency | /PaymentReporting/PaymentReportingBatch, /PaymentReporting/PaymentReportingBatch/ReportingDetail | Identifies the originating agency of a record. |
| New | element | OriginatingDFI | /PaymentReporting/PaymentReportingBatch | The agency from which an ACH transaction is paid. |
| New | element | OriginatingDI | /PaymentReporting/PaymentReportingBatch | The agency from which a wire transaction is paid. |
| New | element | PartyDetail | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains party detail information. |
| New | attribute | PartyName | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail | Contains the full name of a party. |
| New | attribute | PayeeIdentifier | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Account number used internally by an agency to identify a payee. |
| New | attribute | PayeeName | /PaymentReporting/PaymentReportingBatch/ReportingDetail | The person to which the payment instrument is made payable. |
| New | attribute | PayerMechanismCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentMethod | Identifies the payment medium for the transaction. |
| New | element | PaymentClassification | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the account classification of a payment. |
| New | attribute | PaymentID | /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. |
| New | element | PaymentMethod | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the mechanism of the payment. |
| New | element | PaymentReporting | /PaymentReporting | Standard Payment Report format |
| New | element | PaymentReportingBatch | /PaymentReporting | Set of payments that are reported to FMS after issuance by an agency. |
| New | attribute | PaymentTypeCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Code denoting the type of sub-payment. |
| New | element | PersonName | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail | Contains the name of a person. |
| New | attribute | PostalCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | A code added to an address line, typically for the purpose of sorting mail. |
| New | attribute | PostalCodeExtension | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | The 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) |
| New | attribute | PostNetBarcodeDeliveryPoint | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | PostNet barcode that is applied to the check for obtaining postage discounts. |
| New | attribute | ProcurementAgencyIdentifier | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetail | This 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. |
| New | element | ProcurementDetail | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails | Contains the fields necessary to connect to a Federal Procurement Data System (FPDS) record set at USAspending.gov. |
| New | element | ProcurementDetails | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the individual Procurement Detail records. |
| New | attribute | ProcurementInstrumentIdentifier | /PaymentReporting/PaymentReportingBatch/ReportingDetail/ProcurementDetails/ProcurementDetail | The unique identifier for each contract, agreement or order. |
| New | element | ReceiverDI | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the routing number of the bank to which a wire transaction is sent. |
| New | element | ReceivingDFI | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the routing number of the bank to which an ACH transaction is sent. |
| New | attribute | RegionName | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | Indicates the foreign state, territory, or province name. |
| New | element | ReportingDetail | /PaymentReporting/PaymentReportingBatch | Contains information about a specific reporting payment record. |
| New | attribute | RoutingNumber | /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] |
| New | attribute | ScheduleNumber | /PaymentReporting/PaymentReportingBatch, /PaymentReporting/PaymentReportingBatch/ReportingDetail/OriginalScheduleReference | The schedule number assigned by the agency to identify this set of payments . |
| New | attribute | StandardEntryClassCode | /PaymentReporting/PaymentReportingBatch/ACH_BatchReference | Identifies the NACHA payment type. |
| New | attribute | StateCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | US state codes and Canadian province codes. |
| New | attribute | Sub-accountCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbol | Identifies an available receipt or other Treasury-defined subdivision of the main account. |
| New | attribute | Sub-levelPrefixCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification/TreasuryAccountSymbol | When populated, represents a programmatic breakdown of the account for Treasury publication purposes. |
| New | attribute | SummaryDate | /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. |
| New | attribute | SummaryNumber | /PaymentReporting/PaymentReportingBatch/VoucherDetail | The number of the summary record, for example the deposit ticket number or the debit voucher number. |
| New | element | Surname | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail/PersonName | The name borne in common by members of a family. |
| New | element | SWIFT_ReportingDetail | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the SWIFT detail for a payment. |
| New | attribute | TIN | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail | A 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. |
| New | attribute | TIN_Code | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PartyDetail | Indicates the type of Tax Identification Number. |
| New | attribute | TotalAmount | /PaymentReporting/PaymentReportingBatch/VoucherDetail | Indicates the total absolute dollar amount of items. |
| New | element | TreasuryAccountSymbol | /PaymentReporting/PaymentReportingBatch/ReportingDetail/PaymentClassification | The 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.) |
| New | attribute | USPS_IntelligentMailBarCode | /PaymentReporting/PaymentReportingBatch/ReportingDetail/Address | Field 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. |
| New | attribute | VersionIdentifier | /PaymentReporting | Indicates an identifier assigned to a version for this transmission. |
| New | element | VoucherDetail | /PaymentReporting/PaymentReportingBatch | Contains referenced summary data. |
| New | attribute | VoucherFormCode | /PaymentReporting/PaymentReportingBatch/VoucherDetail | Identifies the type of voucher record, i.e., 215, 215A, 5515, etc.) |
| New | element | WireReporting | /PaymentReporting/PaymentReportingBatch/ReportingDetail | Contains the reporting wire payment information. |
| For help, please contact the Treasury Bureau of the Fiscal Service Data Registry 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. |