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	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	Anticipated	Indicates that the transaction is expected or antipated to occur in the current fiscal year.		YesNo_SimpleType		xsd:token														Y [Yes], N [No]
New	ApportionmentCategoryB_ProgramCode	The code representing the category A/B and B program used on the SF 132 apportionment schedule. Apportionment Category B Program Code is the four digit number from 6011-6159 that represents a line on the apportionment schedule. The category B program code is required if the apportionment category is A/B or B. Category B programs are subject to the Anti-Deficiency Act.		ApportionmentCategory_B_Code_SimpleType		String_SimpleType				4
New	ApportionmentCategoryCode	Identifies OMB apportionments by quarters (Category A) or by other specified time periods, programs, activities, projects, objects, or combinations of these (Category B), or are not subject to apportionment (Category E).		ApportionmentCategoryCode_SimpleType		xsd:token														A [Category A - Quarterly Apportionments], B [Category B - Apportionments other than quarterly], E [Exempt from Apportionment]
New	AuthorityDurationCode	Indicates whether a TAS is an annual year account (A), multiyear account (M), receipt account (R), clearing/suspense account (F), no-year account (X), or canceled account (C).		AuthorityDurationCode_SimpleType		xsd:token														A [Annual Year Account], M [Multiyear Account], R [Receipt Account], F [Clearing/Suspense Account], X [No-year Account], C [Canceled Account]
New	AuthorityTypeCode	Distinguishes among the types of budgetary resources, where it is not possible to do so by the USSGL Account Number Code. For example, the USSGL rescission accounts (USSGL accounts 4392 and 4393) do not distinguish between rescissions of appropriations or contract authority.		AuthorityType_SimpleType		xsd:token														B [Borrowing Authority], C [Contract Authority], D [Advance Appropriation], E [Appropriation (Advance Funding) available in Prior Year], F [Appropriation (Advance Funding) available from Subsequent Year], P [Appropriation (excluding Advance Funding)], R [Reappropriation], S [Spending Authority from Offsetting Collections]
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	AvailableTimeIndicator	Indicates whether a budgetary resource is available for new obligations in the current period, or in a subsequent period within the current fiscal year or after being reapportioned in a future fiscal year.		AvailableTimeIndicator_SimpleType		xsd:token														A [Available in current period], S [Available in subsequent period]
New	BEA_CategoryIndicator	Indicates whether the Budget Enforcement Act (BEA) category is mandatory or discretionary.		GTAS_BEA_CategoryIndicator_SimpleType		BEA_CategoryIndicator_SimpleType														D [Discretionary], M [Mandatory]
New	BeginEndIndicator	Indicates whether the balance or an USSGL account/attribute combination is at the start of the fiscal year or at the end of a period.		BeginEndIndicator_SimpleType		xsd:token														B [Begining Balance], E [Ending Balance]
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	BorrowingSourceCode	Indicates whether borrowing took place from the public, Treasury, or a Federal financing bank. Required if authority type code is B (borrowing).		BorrowingSourceIndicator_SimpleType		xsd:token														F [Federal Financing Bank], P [Public], T [Treasury]
New	BudgetaryProprietary	Indicates the the type of USSGL account being reported.		BudgetProprietary_SimpleType		xsd:token														A [Both], B [Budget], P [Proprietary]
New	BudgetImpactIndicator	Indicates whether financing resources and non-exchange revenue have an impact on the budget.		BudgetImpactIndicator_SimpleType		xsd:token														D [Budgetary Impact], E [Non-Budgetary Impact]
New	CreditCohortYear	Fiscal year when direct loans are obligated or guarantees committed by a program, even if disbursements occur in subsequent fiscal years.		Year_SimpleType		xsd:gYear
New	CustodialNonCustodialIndicator	Custodial amounts are reported on the Statement of Custodial Activity (SCA) or on the custodial footnote. Noncustodial amounts are not reported on the SCA nor on the custodial footnote.		CustodialIndicator_SimpleType		xsd:token														A [Non-custodial], S [Custodial]
New	DebitCreditIndicator	Indicates whether the amount reported is debited or credited to the USSGL account.		DebitCreditIndicator_SimpleType		xsd:token														D [Debit], C [Credit]
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	ExchangeOrNonExchangeCode	Indicates whether the revenue, gains or losses balances being reported is exchange (X), nonexchange (T) or (E) exchange revenue with little or no associated costs.		ExchangeCodeIndicator_SimpleType		xsd:token														E [Exchange without associated costs], T [Nonexchange], X [Exchange]
New	FederalNonFederalCode	Indicates the type of entity involved in transactions with the reporting entity: other Federal entities (F); non-Federal entities such as private/local/state/tribal/foreign governments (N), exceptions for other non-Federal partners (E), or General Fund only, G.		FederalNonFederalCode_SimpleType		xsd:token														E [Non-Federal Exception], F [Federal], G [Feneral Fund Only], N [Non Federal]
New	FinancialReceiptCode	Indicates at the Treasury Account Symbol (TAS) level activity related to non-Federal ownership interest or statutory dedication of specifically identified revenues to designated activities.		FinancingReceiptCode_SimpleType		xsd:token														E [Earmarked], F [Fiduciary], U [Undesignated]
New	FinancingAccountCode	Indicates whether the Federal account symbol is a Direct Loan Financing Account, a Guaranteed Loan Financing Account, or is not a financing account as defined by the Federal Credit Reform Act of 1990.		FinancingAccountCode_SimpleType		xsd:token														D [Direct], G [Guaranteed], N [Non-financing]
New	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.		Year_SimpleType		xsd:gYear
New	FundType	A classification established in law that describes an OMB account's relationship to the Government, and the source of the receipts that the account is provided. The first digit (and sometimes second digit, as well) of the Treasury Account Main Code is also used to designate fund category (ITFM 2-1500). Additionally Deposit Funds are also included in this classification.		FundType_SimpleType		xsd:token														EG [General Fund (0000 - 3899)], UG [Unavailable General Fund Receipt (0000 - 3499)], EC [Consolidated Working Fund (3900 - 3959)], EG [Management Fund (3960 - 3999)], EP [Public Enterprise Revolving (4000 - 4499)], ER [Intragovernmental Revolving (4500 - 4999)], ES [Special Fund (5000 - 5999)], US [Unavailable Special Fund Receipt (5000 - 5999)], DF [Deposit Fund (6000 - 6999)], ET [Trust Non-revolving Fund (8000 - 8399 and 8500 - 8999)], UT [Trust Non-revolving Fund Receipt (8000 - 8399 and 8500 - 8999)], TR [Trust Revolving Fund (8400 - 8499)], CF [Clearing Account (F3500 - F3885)]
New	MainAccountCode	Identifies the type and purpose of the fund.		MainAccountCode_SimpleType		String_SimpleType										[0-9]{4}
New	NormalBalanceIndicator	Identifies the type of balance expected for a particular USSGL account based on classification.		DebitCreditIndicator_SimpleType		xsd:token														D [Debit], C [Credit]
New	PriorYearAdjustmentCode	Changes to obligated or unobligated balances that occurred in the previous fiscal year but were not recorded in the appropriate TAFS as of October 1 of the current fiscal year. Exclude upward and downward adjustments to current-year/prior-year obligations and most reclassifications from clearing accounts.		PriorYearAdjustmentCode_SimpleType		xsd:token														B [Adjustment to prior-year reporting - backdated in Treasury's central accounting system], P [Adjustment to prior-year reporting - not backdated in Treasury's central accounting system], X [Not an adjustment to prior-year reporting]
New	ProgramIndicator	The amount of cost or revenue directly or indirectly traceable to programs		ProgramIndicator_SimpleType		xsd:token														P [Assigned to programs], Q [Not assigned to programs]
New	ProgramReportCategoryCode	Identifies a program report category that agencies use when reporting their obligations in their detailed financial information. Agencies may use this code when reporting either Category A or Category B obligations. Unlike the Apportionment Category B Program, this code is NOT subject to the Anti-Deficiency Act.		ProgramReportCategoryCode_SimpleType		String_SimpleType				2
New	ReimbursableFlagIndicator	Indicates whether amounts for goods, services, and joint project support are financed by offsetting collections.		ReimbursableIndicator_SimpleType		xsd:token														D [Direct], R [Reimbursable]
New	ReportingPeriod	Designates the month for which the data is being submitted. This is is a 2 digit numer that starts with 01 for October and goes through 12 for September.		Month_SimpleType		String_SimpleType										(([0][1-9])|([1][0-2]))
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	TotalCount	Indicates the total number of items.		Count_SimpleType		xsd:nonNegativeInteger
New	TradingPartnerAgencyIdentifier	Represents the agency identifier of the other department, agency, or establishment of the U. S. government involved in transactions with the reporting entity. Required with the proprietary USSGLs if the Fed/Non-Federal Indicator = F or G.		TradingPartnerAgencyIdentifier_SimpleType		String_SimpleType				3
New	TradingPartnerMainAccountCode	Represents the treasury main account code of the other department, agency, or establishment of the U. S. Government involved in transactions with the reporting entity.		TradingPartnerMainAccountCode_SimpleType		String_SimpleType				4
New	TransitioningCode	The Treasury Account Symbol transition code set for expiring or canceling.		TransitioningCode_SimpleType		xsd:token														C [Applies to annual, multi and no-year accounts. For annual and multi year accounts, the TAS Status Transitioning Flag is set to canceling in period 12 of the 5th expired year. For no-year accounts, the TAS Status Transitioning Flag is set to canceling when the account has been discontinued.], E [Applies to annual and multi year accounts only. TAS Status Transitioning Flag is set to expiring in period 12 of the ending year of availability.], N [Not Applicable ]
New	TreasuryAccountSymbolStatus	Determines if time period of budget authority set for canceled, expired or unexpired.		TreasuryAccountSymbolStatus_SimpleType		xsd:token														C [Time period after the last expired year, the account is closed, and the balances are canceled. The authority to disburse is canceled and is no longer available for any purpose], E [Time period the budget authority is no longer available for new obligations but is still available for disbursement], U [Time period the budget authority is available for incurring 'new' obligations. Annual budget authority lasts for up to one fiscal year. Multi-year authority lasts for longer periods. No-year authority last indefinitely.]
New	USSGL_AccountNumber	Identifies the USSGL account. The USSGL account must be in the USSGL chart of accounts.		USSGL_Account_SimpleType		String_SimpleType										[0-9]{6}
New	YearOfBudgetAuthorityIndicator	Identifies whether outlays are from the new budget authority (NEW) or from budget authority carried forward from the prior year (BAL). Used for expenditure TAS that are not credit financing TAS.		BudgetAuthorityYearIndicator_SimpleType		xsd:token														BAL [Outlays from balances brought forward], NEW [Outlays from new budget authority]

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

Last Updated: 2012-06-28T18:59:11.687-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.