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.

Status	Name	Definition	Prior Definition	Type Name	Prior Type Name	Restriction Base	Prior Restriction Base	String Min	Prior String Min	String Max	Prior String Max	Total Digits	Prior Total Digits	Fraction Digits	Prior Fraction Digits	Pattern	Prior Pattern	Union Members	Prior Union Members	Enumeration Values	Prior Enumeration Values
New	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.		AgencyIdentifier_SimpleType		String_SimpleType										[0-9]{3}
New	AgencyLocationCode	Identifies the accounting office within an agency that reports disbursements and collections to Treasury.		AgencyLocationCode_SimpleType		String_SimpleType										[0-9]{8}
New	AllocationTransferAgencyIdentifier	Represents the agency receiving funds through an allocation transfer.		AllocationTransferAgencyIdentifier_SimpleType		String_SimpleType										[0-9]{3}
New	Amount	The transaction amount.		AmountLength_SimpleType		xsd:decimal						20		2
New	AvailabilityTypeCode	Identifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M).		AvailabilityIndicator_SimpleType		xsd:token														X [No Year account.], F [Clearing/Suspense account], A [Treasury Central Summary General Ledger account], M [Merged Surplus account]
New	BeginningPeriodOfAvailability	In annual and multiyear accounts, identifies the first year of availability under law that an account may incur new obligations.		BeginningPeriodOfAvailability_SimpleType		String_SimpleType										[0-9]{4}
New	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.		BusinessEventTypeCode_SimpleType		String_SimpleType										[A-Z0-9]{1,8}
New	BusinessEventTypeName	Identifies the name of the Business Event Type Code.		StringLength_0to100_SimpleType		String_SimpleType				100
New	ClassName	The 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_SimpleType		String_SimpleType				25
New	ClassValue	The 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_SimpleType		String_SimpleType				50
New	EndingPeriodOfAvailability	In annual and multiyear accounts, identifies the last year of availability under law that an account may incur new obligations.		EndingPeriodOfAvailability_SimpleType		String_SimpleType										[0-9]{4}
New	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.		Identifier_SimpleType		String_SimpleType				80
New	InputSystem	Identifies the sending trading partner.		StringLength_0to40_SimpleType		String_SimpleType				40
New	IsCredit	Indicates if the item is a debit or credit so it can be interpreted as a positive or negative value.		Boolean_SimpleType		xsd:boolean										1|0
New	IsDepositTicket	Indicates whether this record is a deposit ticket or debit voucher.		Boolean_SimpleType		xsd:boolean										1|0
New	IsEndOfDay	Indicates if this transmission is the last transmission for the day.		Boolean_SimpleType		xsd:boolean										1|0
New	MainAccountCode	Identifies the type and purpose of the fund.		MainAccountCode_SimpleType		String_SimpleType										[0-9]{4}
New	PublicMoneySymbolNumber	An 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_SimpleType		String_SimpleType										[0-9]{8}
New	RedundancyCheckNumber	A form of redundancy check used for error detection and consists of a single digit computed from the other digits in the amount field.		CheckDigitNumber_SimpleType		String_SimpleType										[0-9]
New	RoutingNumber	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]		ABA_RoutingNumber_SimpleType		String_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}
New	Sub-accountCode	Identifies an available receipt or other Treasury-defined subdivision of the main account.		SubAccountCode_SimpleType		String_SimpleType										[0-9]{3}
New	Sub-levelPrefixCode	When populated, represents a programmatic breakdown of the account for Treasury publication purposes.		Sub-levelPrefix_SimpleType		String_SimpleType										[0-9]{2}
New	SummariesTimestamp	The date and time of the ReportingSummaries container.		TimeStamp_SimpleType		xsd:dateTime
New	SummaryAccountingDate	Indicates a specific date related to a business line within a Reported Summaries container.		Date_SimpleType		xsd:date
New	SummaryDate	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.		Date_SimpleType		xsd:date
New	SummaryNumber	The number of the summary record, for example the deposit ticket number or the debit voucher number.		StringLength_0to80_SimpleType		String_SimpleType				80
New	SummaryReportLocation	Indicates the location of the report.		NumericLength3_SimpleType		String_SimpleType										[0-9]{3}
New	TotalAmount	Indicates the total absolute dollar amount of items.		AmountLength_SimpleType		xsd:decimal						20		2
New	TotalCount	Indicates the total number of items.		Count_SimpleType		xsd:nonNegativeInteger
New	TransmissionTimestamp	Indicates the date and time of a transmission.		TimeStamp_SimpleType		xsd:dateTime
New	VersionIdentifier	Indicates an identifier assigned to a version for this transmission.		StringLength_0to80_SimpleType		String_SimpleType				80

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.