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.
StatusNameDefinitionPrior DefinitionType NamePrior Type NameRestriction BasePrior Restriction BaseString MinPrior String MinString MaxPrior String MaxTotal DigitsPrior Total DigitsFraction DigitsPrior Fraction DigitsPatternPrior PatternUnion MembersPrior Union MembersEnumeration ValuesPrior Enumeration Values
NewAgencyIdentifierIdentifies 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.AgencyIdentifier_SimpleTypeString_SimpleType[0-9]{3}
NewAgencyLocationCodeIdentifies the accounting office within an agency that reports disbursements and collections to Treasury.AgencyLocationCode_SimpleTypeString_SimpleType[0-9]{8}
NewAllocationTransferAgencyIdentifierRepresents the agency receiving funds through an allocation transfer.AllocationTransferAgencyIdentifier_SimpleTypeString_SimpleType[0-9]{3}
NewAmountThe transaction amount.AmountLength_SimpleTypexsd:decimal202
NewAvailabilityTypeCodeIdentifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M).AvailabilityIndicator_SimpleTypexsd:tokenX [No Year account.], F [Clearing/Suspense account], A [Treasury Central Summary General Ledger account], M [Merged Surplus account]
NewBeginningPeriodOfAvailabilityIn annual and multiyear accounts, identifies the first year of availability under law that an account may incur new obligations.BeginningPeriodOfAvailability_SimpleTypeString_SimpleType[0-9]{4}
NewBusinessEventTypeCodeIdentifies 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.BusinessEventTypeCode_SimpleTypeString_SimpleType[A-Z0-9]{1,8}
NewBusinessEventTypeNameIdentifies the name of the Business Event Type Code.StringLength_0to100_SimpleTypeString_SimpleType100
NewClassNameThe string that contains the actual C-Key Name. For example, the C-Key Name could be 'Tax Class', and the C-Key Values could be '01', '02', etc. Also, non case-sensitive uniqueness will be enforced. (Aa would be a duplicate of aA.)StringLength_0to25_SimpleTypeString_SimpleType25
NewClassValueThe string that contains the actual C-Key Value. Also, non case-sensitive uniqueness will be enforced. (Aa would be a duplicate of aA.)StringLength_0to50_SimpleTypeString_SimpleType50
NewEndingPeriodOfAvailabilityIn annual and multiyear accounts, identifies the last year of availability under law that an account may incur new obligations.EndingPeriodOfAvailability_SimpleTypeString_SimpleType[0-9]{4}
NewIDAn 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.Identifier_SimpleTypeString_SimpleType80
NewInputSystemIdentifies the sending trading partner.StringLength_0to40_SimpleTypeString_SimpleType40
NewIsCreditIndicates if the item is a debit or credit so it can be interpreted as a positive or negative value.Boolean_SimpleTypexsd:boolean1|0
NewIsDepositTicketIndicates whether this record is a deposit ticket or debit voucher.Boolean_SimpleTypexsd:boolean1|0
NewIsEndOfDayIndicates if this transmission is the last transmission for the day. Boolean_SimpleTypexsd:boolean1|0
NewMainAccountCodeIdentifies the type and purpose of the fund.MainAccountCode_SimpleTypeString_SimpleType[0-9]{4}
NewPublicMoneySymbolNumberAn 8-digit number used to identify bank activity reported by commercial banks, Federal Reserve Banks (FRBs) and Treasury offices. The activity represents deposits of tax collections, customs duties, miscellaneous receipts, public debt receipts, other revenues, Treasury checks paid, etc.PublicMoneySymbolNumber_SimpleTypeString_SimpleType[0-9]{8}
NewRedundancyCheckNumberA form of redundancy check used for error detection and consists of a single digit computed from the other digits in the amount field.CheckDigitNumber_SimpleTypeString_SimpleType[0-9]
NewRoutingNumberThe 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:]ABA_RoutingNumber_SimpleTypeString_SimpleType(([0][0-9])|[1][0-2]|[2][1-9]|[3][0-2]|[6][1-9]|[7][0-2]|[8][0]|[9][0-1])[0-9]{7}
NewSub-accountCodeIdentifies an available receipt or other Treasury-defined subdivision of the main account.SubAccountCode_SimpleTypeString_SimpleType[0-9]{3}
NewSub-levelPrefixCodeWhen populated, represents a programmatic breakdown of the account for Treasury publication purposes.Sub-levelPrefix_SimpleTypeString_SimpleType[0-9]{2}
NewSummariesTimestampThe date and time of the ReportingSummaries container.TimeStamp_SimpleTypexsd:dateTime
NewSummaryAccountingDateIndicates a specific date related to a business line within a Reported Summaries container.Date_SimpleTypexsd:date
NewSummaryDateThe 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. Date_SimpleTypexsd:date
NewSummaryNumberThe number of the summary record, for example the deposit ticket number or the debit voucher number.StringLength_0to80_SimpleTypeString_SimpleType80
NewSummaryReportLocationIndicates the location of the report.NumericLength3_SimpleTypeString_SimpleType[0-9]{3}
NewTotalAmountIndicates the total absolute dollar amount of items.AmountLength_SimpleTypexsd:decimal202
NewTotalCountIndicates the total number of items.Count_SimpleTypexsd:nonNegativeInteger
NewTransmissionTimestampIndicates the date and time of a transmission.TimeStamp_SimpleTypexsd:dateTime
NewVersionIdentifierIndicates an identifier assigned to a version for this transmission.StringLength_0to80_SimpleTypeString_SimpleType80
For help, please contact the Treasury FMS Enterprise Data Architecture team.
Last Updated: 2012-06-28T18:59:08.187-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.