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	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	AgencyLocationTypeCode	A code that distinguishes the type of Agency Location (e.g., Regional Finance Center, Non-Treasury Disbursing Office subject to Audit).		AgencyLocationTypeCode_SimpleType		xsd:string				10
New	AgencyName	Name of the agency.		StringLength_0to80_SimpleType		String_SimpleType				80
New	BureauName	The name of the Bureau.		StringLength_0to100_SimpleType		String_SimpleType				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	ChangeType	Populated only for Partner Profiles requesting Reference Data changes to be distributed, Action is the reason for the change (e.g., new, modify).		ChangeType_SimpleType		xsd:string														New, Modified, Deleted, Expired
New	CityName	Contains a city name.		StringLength_0to50_SimpleType		String_SimpleType				50
New	ContactTitle	Official title of the individual identified as the point-of-contact. (Contact for the Agency Location)		StringLength_0to50_SimpleType		String_SimpleType				50
New	DepartmentRegularCode	This is Treasury's legacy 2-digit code that 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 Code represents the department, agency or establishment of the U.S. Government that is responsible for the Treasury Account Symbol. This attribute will be replaced by AgencyIdentifier.		AgencyCode_SimpleType		String_SimpleType										[0-9]{2}
New	FullName	Contains the full name of a person.		StringLength_0to160_SimpleType		String_SimpleType				160
New	IsBusinessTransactionTypeReporter	Indicates whether this Agency Location Code is or will be a Payment reporter "1", or if this Agency Location Code is not a reporter "0".		Boolean_SimpleType		xsd:boolean										1|0
New	LastUpdatedTimestamp	Date and time on which the Organizational Unit was created or last modified in the system of record for Agency organization reference data. (Last Updated Timestamp of the Agency Location)		TimeStamp_SimpleType		xsd:dateTime
New	LastUpdatedUserName	The identier of the user that created or last modified the Organizational Unit in the system of record for Agency organization reference data. (Last Updated User of the Agency Location)		StringLength_0to255_SimpleType		xsd:string				255
New	LegacyBureauCode	This is the Treasury's legacy code that identifies an organizational level of the Federal government falling under an agency, to which agency locations may be assigned. This will be replaced by Legislative Bureau Code		BureauIdentifier_SimpleType		String_SimpleType										[0-9]{2,3}
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	OrganizationalDisplayName	A short or abbreviated name for the Organizational Unit. (Display Name of the Agency Location)		OrganizationalDisplayName_SimpleType		xsd:string				45
New	OrganizationalIdentifier	A number that uniquely identifies an Organizational Unit of the United States Federal Government. (Organization Identifier of the Agency Location)		OrganizationalIdentifier_SimpleType		xsd:integer						8
New	OrganizationalTitle	The official name by which an Organization Unit of the United States Federal Government is referred. (Title of the Agency Location)		StringLength_0to100_SimpleType		String_SimpleType				100
New	OrganizationDissolvedDate	The date on which the Organizational Unit ceased to exist. (Dissolved Date of the Agency Location)		Date_SimpleType		xsd:date
New	OrganizationEstablishedDate	The date on which the Organizational Unit came into being. (Established Date of the Agency Location)		Date_SimpleType		xsd:date
No Change	PhoneNumber	A number assigned to a telephone line for a specific location that is used to call that location.	A number assigned to a telephone line for a specific location that is used to call that location.	StringLength_0to20_SimpleType	StringLength_0to20_SimpleType	String_SimpleType	String_SimpleType			20	20
New	PostalCode	A code added to an address line, typically for the purpose of sorting mail.		StringLength_0to10_SimpleType		String_SimpleType				10
New	ReportingCode	An Agency Location Code that is designated as the parent for one of more children Agency Location Codes, responsible for reporting accounting transactions for those children.		AgencyLocationCode_SimpleType		String_SimpleType										[0-9]{8}
New	ReportingStatusTimestamp	The date and time at which point the Reporting Status (Payment, Collection, or Intragovernmental Payments and Collections) record was created.		TimeStamp_SimpleType		xsd:dateTime
Updated	ReportingTransactionEffectiveDate	The date upon which the Agency Location Code actually began (or will begin) reporting Payment transactions.	The date upon which the ALC actually began reporting Payment transactions to GWA.	xsd:date	xsd:date
New	SourceDocumentReferenceNumber	The reference number of the document authorizing changes to the Agency Location Code.		SourceDocumentReferenceNumber_SimpleType		xsd:string				9
Updated	StateCode	US state codes and Canadian province codes.	US state code and Canadian province code.	StateCode_SimpleType	StateCode_SimpleType													USPS_StateCode_SimpleType CanadianProvinces_SimpleType
New	SuccessorCode	An Agency Location Code defined as the valid replacement for an existing Agency Location Code upon its dissolution.		AgencyLocationCode_SimpleType		String_SimpleType										[0-9]{8}
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	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.		fms:AgencyIdentifier_SimpleType		String_SimpleType										[0-9]{3}
Dropped	AgencyLocationCode		Identifies the accounting office within an agency that reports disbursements and collections to Treasury.		fms:AgencyLocationCode_SimpleType		String_SimpleType										[0-9]{8}
Dropped	AgencyLocationTypeCode		A code that distinguishes the type of Agency Location (e.g., Regional Finance Center, Non-Treasury Dispersing Office subject to Audit).		alc:AgencyLocationTypeCode_SimpleType		xsd:string				10
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	BureauName		The name of the Bureau.		fms:StringLength_0to100_SimpleType		String_SimpleType				100
Dropped	BusinessTransactionTypeCode		Indicates whether this record is either a Payment, Collection, or IPC.		sam:BusinessTransactionType_SimpleType		xsd:string														Payment, Collection, IPC
Dropped	ChangeType		Populated only for Partner Profiles requesting ERD changes to be distributed, Action is the reason for the change (e.g., new, modify).		sam:ChangeType_SimpleType		xsd:string														New, Modified, Deleted, Expired
Dropped	CityName		Contains the name of the city.		StringLength_0to40_SimpleType		String_SimpleType				40
Dropped	ContactTitle		Official title of the individual identified as the point-of-contact. (Contact for the Agency Location)		sam:StringLength_0to50_SimpleType		xsd:string				50
Dropped	FullName		Contains the full name of a person.		StringLength_0to80_SimpleType		String_SimpleType				80
Dropped	IsBusinessTransactionTypeReporter		Indicates whether this ALC is or will be a Payment reporter "1", or if this ALC is not a reporter "0".		fms:Boolean_SimpleType		xsd:boolean										1|0
Dropped	LastUpdatedTimestamp		Date and time on which the Organizational Unit was created or last modified in the system of record for Agency organization reference data. (Last Updated Timestamp of the Agency Location)		xsd:dateTime
Dropped	LastUpdatedUserName		The id of the user that created or last modified the Organizational Unit in the system of record for Agency organization reference data. (Last Updated User of the Agency Location)		sam:StringLength_0to255_SimpleType		xsd:string				255
Dropped	LegacyAgencyCode		This is Treasury's legacy 2-digit code that 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 Code represents the department, agency or establishment of the U.S. Government that is responsible for the Treasury Account Symbol. This attribute will be replaced by AgencyIdentifier.		fms:AgencyCode_SimpleType		String_SimpleType										[0-9]{2}
Dropped	LegacyBureauCode		This is the Treasury's legacy code that identifies an organizational level of the Federal government falling under an agency, to which agency locations may be assigned. This will be replaced by Legislative Bureau Code		fms:BureauIdentifier_SimpleType		String_SimpleType										[0-9]{2,3}
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	OrganizationalDisplayName		A short or abbreviated name for the Organizational Unit. (Display Name of the Agency Location.)		alc:OrganizationalDisplayName_SimpleType		xsd:string				45
Dropped	OrganizationalIdentifier		A number that uniquely identifies an Organizational Unit of the United States Federal Government. (Organization Identifier of the Agency Location)		alc:OrganizationalIdentifier_SimpleType		xsd:integer						8
Dropped	OrganizationalTitle		The official name by which an Organization Unit of the United States Federal Government is referred. (Title of the Agency Location.)		sam:StringLength_0to100_SimpleType		xsd:string				100
Dropped	OrganizationDissolvedDate		The date on which the Organizational Unit ceased to exist. (Dissolved Date of the Agency Location)		xsd:date
Dropped	OrganizationEstablishedDate		The date on which the Organizational Unit came into being. (Established Date of the Agency Location.)		xsd:date
Dropped	PostalCodeExtension		The purpose of +4 codes is to aid efficient mail sorting and delivery. Business mailers are the primary users of ZIP+4’s, because mailers who mail in bulk on the ZIP+4 or carrier route level can receive rate discounts. (ref: http://www.carrierroutes.com/ZIPCodes.html)		PostalCodePlusDelimeter_SimpleType		String_SimpleType				5
Dropped	ReportingCode		An Agency Location Code that is designated as the parent for one of more children ALCs, responsible for reporting accounting transactions for those children.		fms:AgencyLocationCode_SimpleType		String_SimpleType										[0-9]{8}
Dropped	ReportingStatusTimestamp		The date and time at which point the Reporting Status (Payment, Collection, or IPC) record was created in GWA.		xsd:dateTime
Dropped	SourceDocumentReferenceNumber		The reference number of the document authorizing changes to the ALC.		alc:SourceDocumentReferenceNumber_SimpleType		xsd:string				9
Dropped	SuccessorCode		An Agency Location Code defined as the valid replacement for an existing ALC upon its dissolution.		fms:AgencyLocationCode_SimpleType		String_SimpleType										[0-9]{8}

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

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