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	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	AccountEffectiveDate	Indicates the date when the Treasury Account Symbol (TAS) and Business Event Type Code (BETC) became available for use.		Date_SimpleType		xsd:date
New	AccountEndDate	Indicates the date when the Treasury Account Symbol (TAS) and Business Event Type Code (BETC) became completely inactive.		Date_SimpleType		xsd:date
New	AccountSuspendDate	Only populated if the Treasury Account Symbol (TAS) and Business Event Type Code (BETC) combination is suspended.		Date_SimpleType		xsd:date
New	AccountSymbolEndDate	The date the Treasury Account Symbol (TAS) was inactivated.		Date_SimpleType		xsd:date
New	AccountSymbolEvaluatedDate	Denotes the date on which the IsValidAccountSymbol value last changed.		Date_SimpleType		xsd:date
New	AccountSymbolName	The full name of the Treasury Account Symbol (TAS).		StringLength_0to240_SimpleType		xsd:string				240
New	AccountSymbolStartDate	The date the Treasury Account Symbol (TAS) was created.		Date_SimpleType		xsd:date
New	AccountSymbolText	Treasury Account Symbol (i.e., "string TAS")		StringLength_0to36_SimpleType		xsd:string				36
New	AccountTypeCode	Establishes the characteristics for the use of a Treasury account and includes primarily the Receipt and Expenditure accounts.		StringLength_0to40_SimpleType		String_SimpleType				40
New	AccountTypeDescription	The description for the code that establishes the characteristics for the use of a Treasury account and includes primarily the Receipt and Expenditure accounts.		StringLength_0to100_SimpleType		String_SimpleType				100
Updated	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.	Used in conjunction with the main account code, represents the department, agency, or establishment of the U.S. government that is responsible for the TAS.	AgencyIdentifier_SimpleType	AgencyIdentifier_SimpleType	String_SimpleType	String_SimpleType									[0-9]{3}	[0-9]{3}
New	AgencyName	Name of the agency.		StringLength_0to80_SimpleType		String_SimpleType				80
No Change	AllocationTransferAgencyIdentifier	Represents the agency receiving funds through an allocation transfer.	Represents the agency receiving funds through an allocation transfer.	AllocationTransferAgencyIdentifier_SimpleType	AllocationTransferAgencyIdentifier_SimpleType	String_SimpleType	String_SimpleType									[0-9]{3}	[0-9]{3}
No Change	AvailabilityTypeCode	Identifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M).	Identifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M).	AvailabilityIndicator_SimpleType	AvailabilityIndicator_SimpleType	xsd:token	xsd:token													X [No Year account.], F [Clearing/Suspense account], A [Treasury Central Summary General Ledger account], M [Merged Surplus account]	X [No Year account.], F [Clearing/Suspense account], A [Treasury Central Summary General Ledger account], M [Merged Surplus account]
No Change	BeginningPeriodOfAvailability	In annual and multiyear accounts, identifies the first year of availability under law that an account may incur new obligations.	In annual and multiyear accounts, identifies the first year of availability under law that an account may incur new obligations.	BeginningPeriodOfAvailability_SimpleType	BeginningPeriodOfAvailability_SimpleType	String_SimpleType	String_SimpleType									[0-9]{4}	[0-9]{4}
New	BudgetBureauCode	The Office of Management and Budget code that identifies a major sub-organization of the agency, sometimes called an administration, service, or agency. (Not all agencies have bureaus.)		BureauIdentifier_SimpleType		String_SimpleType										[0-9]{2,3}
No Change	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.	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	BusinessEventTypeCode_SimpleType	String_SimpleType	String_SimpleType									[A-Z0-9]{1,8}	[A-Z0-9]{1,8}
No Change	BusinessEventTypeName	Identifies the name of the Business Event Type Code.	Identifies the name of the Business Event Type Code.	StringLength_0to100_SimpleType	StringLength_0to100_SimpleType	String_SimpleType	String_SimpleType			100	100
New	BusinessTransactionTypeCode	Indicates whether this record is either a Payment, Collection, Intragovernmental Payment and Collection (IPC), or Non-Treasury Disbursing Office (NTDO) Payment.		BusinessTransactionType_SimpleType		xsd:string														Payment [Payment], Collection [Collection], IPC [Intragovernmental Payments and Collections], NTDOPMT [Non-Treasury Disbursing Office (NTDO) Payment]
New	CoOwningAgencyCode	Co-owning agency of a STAR Treasury Account Symbol (TAS).		StringLength_0to2_SimpleType		String_SimpleType				2
No Change	EndingPeriodOfAvailability	In annual and multiyear accounts, identifies the last year of availability under law that an account may incur new obligations.	In annual and multiyear accounts, identifies the last year of availability under law that an account may incur new obligations.	EndingPeriodOfAvailability_SimpleType	EndingPeriodOfAvailability_SimpleType	String_SimpleType	String_SimpleType									[0-9]{4}	[0-9]{4}
New	FiscalYearText	The fiscal year for the STAR Treasury Account Symbol (TAS).		StringLength_0to4_SimpleType		String_SimpleType				4
New	FundTypeCode	Establishes how the Treasury Account Symbol (TAS) will be funded.		StringLength_0to40_SimpleType		String_SimpleType				40
New	FundTypeDescription	The description for the code that establishes how the Treasury Account Symbol (TAS) will be funded.		StringLength_0to100_SimpleType		String_SimpleType				100
No Change	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.	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	Identifier_SimpleType	String_SimpleType	String_SimpleType			80	80
New	InternalAccountSymbolText	The STAR Treasury Account Symbol (TAS).		StringLength_0to22_SimpleType		String_SimpleType				22
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	IsValidAccountSymbol	Indicates whether or not a Treasury Account is considered valid. Valid accounts are active and pass all classification rules.		Boolean_SimpleType		xsd:boolean										1|0
New	LegislativeBureauCode	The Treasury code that identifies a major sub-organization of the agency, sometimes called an administration, service, or agency. (Not all agencies have bureaus.)		BureauIdentifier_SimpleType		String_SimpleType										[0-9]{2,3}
New	MainAccount	Main account of a STAR Treasury Account Symbol (TAS).		StringLength_0to4_SimpleType		String_SimpleType				4
No Change	MainAccountCode	Identifies the type and purpose of the fund.	Identifies the type and purpose of the fund.	MainAccountCode_SimpleType	MainAccountCode_SimpleType	String_SimpleType	String_SimpleType									[0-9]{4}	[0-9]{4}
New	OwningAgencyCode	Owning agency of a STAR Treasury Account Symbol (TAS).		StringLength_0to2_SimpleType		String_SimpleType				2
No Change	Sub-accountCode	Identifies an available receipt or other Treasury-defined subdivision of the main account.	Identifies an available receipt or other Treasury-defined subdivision of the main account.	SubAccountCode_SimpleType	SubAccountCode_SimpleType	String_SimpleType	String_SimpleType									[0-9]{3}	[0-9]{3}
New	SubAccountSymbol	Sub account symbol of a STAR Treasury Account Symbol (TAS).		StringLength_0to3_SimpleType		String_SimpleType				3
New	SubClassificationSymbol	Sub-classification of a STAR Treasury Account Symbol (TAS).		StringLength_0to2_SimpleType		String_SimpleType				2
No Change	Sub-levelPrefixCode	When populated, represents a programmatic breakdown of the account for Treasury publication purposes.	When populated, represents a programmatic breakdown of the account for Treasury publication purposes.	Sub-levelPrefix_SimpleType	Sub-levelPrefix_SimpleType	String_SimpleType	String_SimpleType									[0-9]{2}	[0-9]{2}
No Change	TotalCount	Indicates the total number of items.	Indicates the total number of items.	Count_SimpleType	Count_SimpleType	xsd:nonNegativeInteger	xsd:nonNegativeInteger
New	VersionIdentifier	Indicates an identifier assigned to a version for this transmission.		StringLength_0to80_SimpleType		String_SimpleType				80
Dropped	AccountEffectiveDate		Indicates the date when the TAS-BETC became available for use.		xsd:date
Dropped	AccountEndDate		Indicates the date when the TAS-BETC became completely inactive.		xsd:date
Dropped	AccountSuspendDate		Only populated if the TAS-BETC combination is suspended.		xsd:date
Dropped	AccountSymbolEndDate		The date the TAS was inactivated.		xsd:date
Dropped	AccountSymbolEvaluatedDate		Denotes the date on which the IsValidAccountSymbol value last changed.		xsd:date
Dropped	AccountSymbolName		The full name of the TAS.		sam:StringLength_0to240_SimpleType		xsd:string				240
Dropped	AccountSymbolStartDate		The date the TAS was created.		xsd:date
Dropped	AccountSymbolText		Treasury Account Symbol (i.e., "string TAS")		sam:StringLength_0to36_SimpleType		xsd:string				36
Dropped	AgencyName		Name of the agency.		fms:StringLength_0to80_SimpleType		String_SimpleType				80
Dropped	BudgetBureauCode		The Office of Management and Budget code that identifies a major sub-organization of the agency, sometimes called an administration, service, or agency. (Not all agencies have bureaus.)		fms:BureauIdentifier_SimpleType		String_SimpleType										[0-9]{2,3}
Dropped	BusinessTransactionTypeCode		Indicates whether this record is either a Payment, Collection, or IPC.		sam:BusinessTransactionType_SimpleType		xsd:string														Payment, Collection, IPC
Dropped	CoOwningAgencyCode		Co-owning agency of a STAR TAS.		sam:StringLength_0to2_SimpleType		xsd:string				2
Dropped	FiscalYearText		The fiscal year for the STAR TAS.		sam:StringLength_0to4_SimpleType		xsd:string				4
Dropped	InternalAccountSymbolText		The STAR TAS.		sam:StringLength_0to22_SimpleType		xsd:string				22
Dropped	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".		fms:Boolean_SimpleType		xsd:boolean										1|0
Dropped	IsValidAccountSymbol		Indicates whether or not a Treasury Account is considered valid by SAM. Valid accounts are active and pass all classification rules.		fms:Boolean_SimpleType		xsd:boolean										1|0
Dropped	LegislativeBureauCode		The Treasury code that identifies a major sub-organization of the agency, sometimes called an administration, service, or agency. (Not all agencies have bureaus.)		fms:BureauIdentifier_SimpleType		String_SimpleType										[0-9]{2,3}
Dropped	MainAccount		Main account of a STAR TAS.		sam:StringLength_0to4_SimpleType		xsd:string				4
Dropped	OwningAgencyCode		Owning agency of a STAR TAS.		sam:StringLength_0to2_SimpleType		xsd:string				2
Dropped	SubAccountSymbol		Sub account symbol of a STAR TAS.		sam:StringLength_0to3_SimpleType		xsd:string				3
Dropped	SubClassificationSymbol		Sub-classification of a STAR TAS.		sam:StringLength_0to2_SimpleType		xsd:string				2

For help, please contact the Treasury Bureau of the Fiscal Service Data Registry team.

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