Treasury :: Financial Management Service

Enterprise Data Architecture

Data Dictionary/Change Log

Home :: Go Back

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	Definition
No-Change	attribute	ABA_Number	The ABA 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 ABA 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 cheques. The first two digits correspond to the 12 Federal Reserve Banks. [reference: http://www.tfp.com/text/aba_policy.pdf]
Updated	element	AccountClassification	Identifies the Treasury Account information, for example, this would contain the TAS/BETC or CKey Name/Value.
No-Change	attribute	AccountKeyCode	Identifies the FRB Account Key that is used within the Federal Reserve. The FRB Account Key is used by FRB Cashlink in combination with the RTN to determine the appropriate CA$HLINK II CAN. The FRB Account Key is similar to the CAN, but is only used for FRB financial activity.
No-Change	attribute	AccountNumber	The bank account number.
New	attribute	AccountPartyType	Indicates whether the party is an Individual, Business or Government.
Updated	element	Addenda	Container for addendum records.
Updated	element	Addendum	These records will be used by the Originator to supply additional information about entry detail records.
Updated	element	Address	Contains the address information.
No-Change	element	AddressLine	Location for the address line.
Updated	attribute	AdjustmentReasonText	Description of the reason for an adjustment.
Updated	element	Agency	Identifies a federal program agency and sub units within.
New	attribute	AgencyAccountIdentifier	An identifier used by the agency for an account, for example, a Lockbox Number.
No-Change	attribute	AgencyIdentifier	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.
No-Change	attribute	AgencyLocationCode	Identifies the accounting office within an agency that reports disbursements and collections to Treasury.
Updated	attribute	AgencyName	Name of the agency.
Updated	attribute	AgencyName	Name of the agency.
No-Change	attribute	AllocationTransferAgencyIdentifier	The Agency Identifier of the agency receiving funds through an allocation transfer.
No-Change	attribute	Amount	The transaction amount.
No-Change	attribute	AvailabilityTypeCode	Identifies no-year accounts "X", clearing/suspense accounts "F", Treasury's central summary general ledger accounts "A", and merged-surplus accounts "M".
New	attribute	BankAccountType	Indicates whether the bank account is a checking account, savings account or general ledger account.
Updated	element	BankInfo	Contains bank information.
No-Change	attribute	BankName	The name of the financial institution.
Updated	element	Batch	Contains one or many Business Transactions.
No-Change	attribute	BeginningPeriodOfAvailability	In annual and multi-year funds, identifies the first year of availability under law that an appropriation account may incur new obligations. - 4 digit year shall be (0000-9999). - If single/annual year account, it shall be the same value as the Ending Period of Availability. - Value not applicable for no-year "X" accounts, clearing/suspense "F" accounts, merged surplus "M" accounts, central summary general ledger "A" accounts, and unavailable receipt accounts, it shall be blank/spaces/empty. - if the BPOA is not blank then the EPOA cannot be blank. - if the EPOA is not blank then the BPOA cannot be blank. - if the BPOA is not blank, the BPOA must be equal to or less than the EPOA. (if the EPOA is not blank, the EPOA must be equal to or greater than the BPOA.) - if the BPOA and EPOA are blank, the AI must not be blank. - if the AI is not blank the BPOA and EPOA must be blank.
New	attribute	BeginSerialNumber	Lower limit of a range of check numbers.
New	element	BillingAgency	The agency name of the billing address .
New	element	BillingAgencyAddressLine	The agency billing address line.
New	element	BillingAgencyAddressLines	The container for the billing agency address lines.
New	element	BillingAgencyDetails	Agency billing address information associated with the schedule, and possibly printed to check stubs.
No-Change	attribute	BureauIdentifier	Identifies a major sub-organization of the agency, sometimes called an administration, service, or agency. (Not all agencies have bureaus.)
Updated	attribute	BureauName	The name of the Bureau.
Updated	element	BusinessEventType	The container for the BusinessEventTypeCode which is used in combination with the Treasury Account Symbol to classify transactions reported to Treasury.
Updated	attribute	BusinessEventTypeCode	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.
No-Change	attribute	BusinessEventTypeName	Identifies the name of the Business Event Type Code.
Updated	element	BusinessTransaction	A set of financial or non-financial transactions for a specific business event.
New	attribute	BusinessTransmissionCategory	Indicates the financial management category of the transmission.
No-Change	attribute	CardNumber	Contains the credit card or debit card number.
New	attribute	CardSecurityCode	The 3 or 4 digit value printed on the card or signature strip but not available on the magnetic strip.
Updated	attribute	CardType	The type of card used, for example: MC for MasterCard, VI for Visa, etc.
New	attribute	CashFlowIdentifier	Identifies the cash flow channel and type of income, for example ALC+2.
No-Change	attribute	CashFlowName	The CashFlow name assigned to the CashFlowID.
New	element	CashFlowReference	Contains the cash flow reference information.
No-Change	attribute	CashlinkAccountNumber	A CashLink assigned number identifying an account.
New	element	CertificationDetails	Certification data related to a payment schedule.
New	element	CertifyingOfficer	Information about the certifying officer for a payment schedule.
No-Change	attribute	ChannelType	Identifies the source channel application.
New	attribute	CheckDigitNumber	A form of redundancy check used for error detection and consists of a single digit computed from the other digits in the amount field.
No-Change	attribute	CheckMediumType	Identifies the type of check.
Updated	attribute	CheckSerialNumber	Contains the serial number of a check.
New	attribute	CheckSymbol	Part of the unique identifier of a check.
No-Change	element	City	Contains the name of the city.
Updated	element	Ckey	A C-KEY is an acronym for classification key which is a unique agency accounting code assigned to a transaction. Agencies will establish C-Keys in SAM for collection transactions that will be used to derive the appropriate values of TAS-BETC(s).
Updated	element	Classification	Contains the classification transaction amount.
No-Change	attribute	ClassName	The string that contains the actual CKey Name. For example, the CKey Name could be "Tax Class", and the CKey Values could be "01", "02", etc. Also, non case-sensitive uniqueness will be enforced. (Aa would be a duplicate of aA.)
No-Change	attribute	ClassValue	The string that contains the actual CKey Value. Also, non case-sensitive uniqueness will be enforced. (Aa would be a duplicate of aA.)
Updated	attribute	Code	The transaction code, for example, indicates the standard entry class codes in an ACH transaction.
New	element	CollectionReportingClassification	Contains the capability to capture deposit reporting information for Collection transactions which contain GWA Classification Data identified as valid Treasury Account Symbols and Business Event Type Codes (TAS/BETC) and/or Classification Keys (Ckey), which impact the Fund Balance with Treasury (FBWT).
New	element	CollectionReportingClassifications	Contains one or more CollectionReportingClassification items.
New	element	Comment	A note explaining or illustrating the meaning of a record.
New	attribute	ControlNumber	Provides a reference to the Payment Request File.
No-Change	attribute	CostCenterWorkUnitCode	Identifies the Cost Center Work Unit for FRB deposits and adjustments.
Updated	element	Country	This code list module defines the enumerated types of standard 2-letter ISO 3166 country codes. For more information on ISO 3166 country codes, see the ISO site: http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html.
No-Change	attribute	Deferred1DayAmount	A decimal value representing the amount of the deposit that is deferred for one day.
No-Change	attribute	Deferred2DayAmount	A decimal value representing the amount of the deposit that is deferred for two days.
No-Change	attribute	DepositDate	The business date that the payment instruction was received by a business channel. The date that the deposit is presented to a financial institution, for example TGANET. The date that an ACH or Check-21 item is physically entered in the payment stream.
New	attribute	DirectoryAccessDistinguishedName	The X500 Distinguished name contained in the digital certificate used to sign the schedule certification.
No-Change	attribute	DocumentLink	This URI refers to an online description of the error or warning that occurred.
No-Change	attribute	EchoID	Identifies the unique original Transmission message level identifier.
No-Change	attribute	EndingPeriodOfAvailability	In annual and multi-year funds, identifies the last year of funds availability under law that an appropriation account may incur new obligations.
New	attribute	EndSerialNumber	Upper limit of a range of check numbers.
New	attribute	EntryIdentifier	This field contains the ascending sequence number section of the Entry Detail or Corporate Entry Detail Record's trace number. This number is the same as the last seven digits of the trace number of the related Entry Detail Record or Corporate Entry Detail Record.
Updated	element	Error	Contains the error metadata fields.
No-Change	attribute	ErrorCode	If present, this refers to a table of coded values exchanged between applications to identify errors or warnings.
No-Change	attribute	ErrorNode	The XPath notation to identify the location of the error/warning present in the instance document referenced by the EchoID attribute.
Updated	element	Errors	Container for each Error item
No-Change	attribute	ErrorText	Provides a short text description of the error or warning.
No-Change	attribute	ExchangeRate	An exchange rate is the market price for which one currency can be exchanged for another.
New	attribute	FederalProgramAgencyIdentifier	This is an organizational identifier to identify agency payment offices.
No-Change	attribute	FileName	The file name reference for the image.
No-Change	attribute	FinancialInstitutionText	The text supplied by the financial institution, in addition to the agency supplied text.
New	element	FinancialReportingDetails	Contains debit voucher or deposit ticket specific details.
Updated	element	FinancialTransaction	The transfer of funds between a payer and a payee for a specific business event.
New	element	FirstName	A name that precedes one's surname.
No-Change	attribute	FiscalYear	Fiscal Year is a term that is used to differentiate a budget or financial year from the calendar year. The U.S. Government's Fiscal Year runs from October 1 of the prior year through September 30 of the next year. For example, FY 2006 was from October 2005 through September 2006; FY 2007 runs from October 2006 through September 2007, and; FY 2008 is from October 2007 through September 2008.
Updated	element	ForeignCurrency	The container for describing foreign currency and associated metadata.
Updated	attribute	FullName	Contains the full name of a person.
New	element	GovernmentDepositAccount	Information about the deposit account for the government agency.
No-Change	attribute	HasPrivacyData	User data contains Personally Identifying Information (PII). If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
Updated	attribute	ID	An identifier for the record. For a receiving system, this value can be used to reconcile updates to an existing record and qualify new records. For a sending system, this value can be used to reconcile acknowledgements for the submitted records.
Updated	element	Image	Contains a reference to an image file.
No-Change	attribute	InitialLocation	Initial location of the point of deposit.
Updated	attribute	InitiationDate	The date that the transaction was initiated, for example, the date that the lockbox opened up the payment.
Updated	attribute	InputSystem	Identifies the sending trading partner.
New	element	InterGovernmentalReportingClassification	Contains the capability to process a summary intergovernmental transaction
New	element	InterGovernmentalReportingClassifications	Contains one or more InterGovernmentalReportingClassification items.
No-Change	attribute	InternalOrganizationCode	Identifies an entity that manages resources below the agency and bureau level. An example of an internal organization is an office or a division.
No-Change	attribute	IsAdjustment	Indicates if the item is an adjustment, for example, a value of "1" would mean that it this record is an adjustment. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
No-Change	attribute	IsCommercialVoucher	Indicates if the item is a commercial voucher or not, for example, a value of "1" would mean that it is a commercial voucher. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
No-Change	attribute	IsCredit	Indicates if the item is a debit or credit, for example, a value of "1" would mean that it is a "credit". If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
New	attribute	IsDepositTicket	Indicates whether this record is a deposit ticket or debit voucher, for example, a value of "1" would mean that this is a deposit ticket. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
No-Change	attribute	IsEndOfDay	Indicates if this transmission is the last transmission for the day. If the value is "1", then this transmission is the last transmission for the day. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
No-Change	attribute	IsForeignCheck	Indicates if the item is a foreign check or not, for example, a value of "1" would mean that it is a foreign check. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
Updated	attribute	IsNonDomestic	Indicates whether this entity is a US domestic entity, for example, this value would be "1" if the address was an international address or the clearing financial institution was a non-US financial institution. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
New	attribute	IsProgramData	Indicates whether this record is program data. A value of "1" indicates that this record is program data. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
Updated	attribute	IsRecurring	Indicates if the item is a recurring transaction. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
No-Change	attribute	IsTax	Indicates if the item is a tax collection transaction. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
New	attribute	IsTopOffset	Indicates the payment eligibility for payment offset, for example, this value would be "1" if the payment was eligible. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
No-Change	attribute	IsUpdate	Indicates if the item is an origination transaction or an update, for example, a value of "1" would mean that this is an update. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be "0".
No-Change	attribute	MainAccountCode	Identifies the type and purpose of the fund.
No-Change	attribute	MonthYearExpire	Indicates the month/year value of the expiration date.
No-Change	attribute	OfficeLocationCode	A code assigned by the agency and will hold the ALC+2, ALC+4 data.
Updated	element	OrganizationLevel	Identifies the particular level within an organization.
Updated	element	OrganizationLevels	The container for an Organization Level item.
New	element	OrganizationName	Contains the name of the organization.
Updated	attribute	OriginalCurrencyCode	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".
No-Change	attribute	OriginalSummaryDate	Indicates the date of the original summary record.
New	element	OriginatingAgency	Identifies the originating agency of this record.
Updated	element	Payee	Person or organization receiving payment. For example, in a general collection, the payee is a federal government entity.
Updated	element	Payer	Identifies the point of first deposit in a debit transaction and identifies the person or organization submitting payment.
Updated	element	Payment	The financial amount of a transaction.
New	attribute	PaymentDocumentTypeCode	Indicates the type of payment in the payment schedule.
Updated	attribute	PaymentMedium	Identifies the payment medium for the transaction.
New	element	PaymentReportingClassification	Contains the capability to process Treasury Disbursing Office (TDO) payments and aftermath transactions containing valid Treasury Account Symbols, Business Event Type Codes, Classification Key Name, and Classification Key Value at the summary schedule level impacting Fund Balance with Treasury (FBWT).
New	element	PaymentReportingClassifications	Contains one or more PaymentReportingClassification items.
New	attribute	PaymentTypeB_Code	Type B Schedule Payment Type Code.
Updated	element	PersonName	Contains the name of a person.
Updated	element	Phone	Contains the telephone number.
Updated	attribute	PhoneNumber	A number assigned to a telephone line for a specific location that is used to call that location.
Updated	element	Plastic	Contains plastic card information.
Updated	element	PostalCode	A code of letters and/or digits added to an address line.
New	element	ReceiverAgency	Indicates the Agency Location Code of the receiving agency.
No-Change	attribute	ReferenceCode	The reference code for the data record.
No-Change	attribute	ReferenceIdentifier	The reference identifier for the data record.
No-Change	attribute	ReferenceName	The reference name for the data record.
No-Change	attribute	ReferenceNumber	The reference number for the data record.
No-Change	attribute	ReferenceText	The reference description for the data record.
New	attribute	RegionalFinancialCenterCode	Identifies a regional financial center.
New	element	ReportingSummaries	Container for Reporting Summary items.
New	element	ReportingSummary	Contains the fields to support the GWA System to become the system of record, to have one central point to retrieve all financial information, and to streamline reporting and reconciliation of Fund Balance with Treasury (FBWT) information for the Federal Program Agencies.
New	attribute	RequestedPaymentDate	Requested date of payment for this schedule.
Updated	attribute	RunningDailyAmount	The cumulative absolute amount, including the items within this transmission, within a given day, for example a day is determined from the end of day indicator of prior day to current end of day.
No-Change	attribute	RunningDailyCount	The running TotalCount for a given day, for example a day is determined from the end of day indicator of prior day to current end of day.
New	element	Schedule	Payment certification data (ALC, CO name, total amount, total payments, etc.)
New	attribute	ScheduleNumber	The schedule number assigned by the agency to identify this schedule of payments .
New	attribute	SendingTradingPartnerIdentifier	Identifies the system that transmitted the original detail message.
Updated	attribute	SequenceNumber	Indicates the number of transmissions submitted.
No-Change	attribute	SettlementDate	The anticipated date the funds will transfer (pre-settlement) or the date that the funds have been transferred (post-settlement).
No-Change	attribute	SettlementMechanism	Identifies the settlement system that was used to complete this transaction.
No-Change	attribute	SeverityLevel	This value represents the degree of error where the lowest number "1" is the highest degree of error (i.e. a fatal error) and "9" is the lowest degree of error.
Updated	element	State	The US state code as managed by the USPS (United States Postal Service) and the Canadian province.
No-Change	attribute	Status	Identifies the transaction status.
No-Change	attribute	Sub-accountCode	Identifies an available receipt or other Treasury-defined subdivision of the main account.
No-Change	attribute	Sub-levelPrefixCode	The Sub-level Prefix (if populated) is a programmatic breakdown of the account for Treasury publication purposes.
No-Change	attribute	SubType	The sub type of transaction, for example, indicates the sub type in a FedWire transaction.
Updated	element	Success	Conveys the successful receipt or validation of the inbound Transmission.
Updated	element	Successes	Container for each Success item
No-Change	attribute	SuccessType	Indicates whether the successful result of the inbound document was received or was validated. "Received" means that the server received the inbound document (no schema-validation or business-rules validation); "Validated" means that the server received the inbound document and that it passed schema-validation. The server relays a successful business-rules validation by the absence of Warning items or Error items.
New	attribute	SummariesTimestamp	The date and time of the ReportingSummaries container.
New	element	Summary	Contains either summary level information or can contain both summary and detailed level of information. For example, a sending trading partner can submit debit voucher or deposit ticket data.
New	attribute	SummaryAccountingDate	Indicates the specific date related to a business line within the Reported Summaries container.
New	element	SummaryBankInfo	Contains the ABA Number for an account.
Updated	attribute	SummaryDate	The date for the summary record, for example the deposit ticket date or the debit voucher date.
Updated	attribute	SummaryNumber	The number of the summary record, for example the deposit ticket number or the debit voucher number.
New	element	SummaryReference	Contains the referenced summary date and summary number.
New	attribute	SummaryReportLocation	Indicates the location of the report.
New	element	SummarySchedule	Contains the schedule number of a payment schedule.
New	attribute	SummaryType	Indicates the type of summary record.
New	element	Surname	The name borne in common by members of a family.
No-Change	attribute	TaxClassCode	Identifies the specific tax class from a specific set of values, as determined by FMS.
No-Change	attribute	TotalAmount	Indicates the total absolute dollar amount of items.
No-Change	attribute	TotalCount	Indicates the total number of items.
No-Change	attribute	TraceNumber	The trace number for the transaction.
Updated	element	TradingPartnerExtension	A single record of non-financial data, for example, a single user-defined data record.
New	element	TradingPartnerExtensions	Container for non-financial data, for example, program data.
No-Change	attribute	TransactionDate	The date that the customer either authorized or approved the payment to satisfy debt or pay for purchase or pay down from an appropriation account.
New	element	TransactionPartner	Contains the identification of the partner agency and the account classification.
Updated	element	Transmission	A collection of financial transaction records for the purpose of creating or updating detail or summary information.
Updated	element	TransmissionRs	Used to identify an application error by either text, code, or by an online description and also to give the status, tag, and/or identification of the record that may have caused the error.
Updated	attribute	TransmissionTimestamp	Indicates the date and time of the transmission.
Updated	element	TreasuryAccountSymbol	The TAS 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.) The term "Treasury Account Symbol" is a generic term used to describe any one of the account identification codes assigned by Treasury. The term "Treasury Appropriation/Fund Symbol" (TAFS) is used to describe a particular type of TAS - one with budget authority. The terms TAS and TAFS are sometimes used synonymously. All financial transactions of the Federal government are classified by TAS for reporting to Treasury and OMB. The TAS should be derived from the internal fund code at the time of reporting. - Sub-level Prefix Code: a 2-character code that represents an account breakdown requested by an agency and approved and implemented by Treasury - Allocation transfer agency identifier: a 3-character code that identifies the agency receiving funds through an allocation transfer (if any) - Agency identifier: a 3-character code that identifies the agency that is responsible for the TAS - Beginning Period of Availability: a 4-character year that, in annual and multiyear accounts, identifies the first year of availability under law that an account may incur new obligations. - Ending Period of Availability: a 4-character year that, in annual and multiyear accounts, identifies the last year of availability under law that an account may incur new obligations. - Availability Type Code: Identifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M). - Main account code: a 4-character code that identifies the type and purpose of the fund - Sub-account code: a 3-character code that identifies a Treasury-defined subdivision of a TAS. Not all TAS elements contain all eight component elements. Receipt accounts, for example, generally consist of the owner agency identifier, the main account code, and a sub-account code. Appropriation and other fund accounts (expenditure accounts) consist of the owner agency identifier, the period of availability codes (beginning fiscal year and ending fiscal year), and the main account code. The Sub-level Prefix Code is used only when there is a unique need (requested by the agency) for a subclassification below the TAS.
Updated	attribute	TreasuryAccountSymbolText	Contains the concatenated version of the Treasury Account Symbol.
No-Change	attribute	Type	The type of transaction, for example, indicates the FedWire type for this record.
New	element	TypeB_ACH_Schedule	Summary and summary prenote schedule information for Automated Clearing House (ACH) payment requests for Type B schedules.
New	element	TypeB_CheckSchedule	Summary schedule information for Check payment requests for Type B schedules.
New	element	TypeB_Details	Data regarding type "B" schedules which have payment detail contained within a separate bulk Payment Request File.
Updated	attribute	TypeCode	Defines the specific interpretation and format for the Addenda Information contained in the same record.
Updated	element	Warning	Contains the warning metadata fields.
Updated	element	Warnings	Container for each Warning item

For help, please contact the Treasury FMS Enterprise Data Architecture team.

Last Updated: 2009-02-27T10:34:07.562-05:00