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.
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}
NewAgencyLocationTypeCodeA code that distinguishes the type of Agency Location (e.g., Regional Finance Center, Non-Treasury Disbursing Office subject to Audit).AgencyLocationTypeCode_SimpleTypexsd:string10
NewAgencyNameName of the agency.StringLength_0to80_SimpleTypeString_SimpleType80
NewBureauNameThe name of the Bureau.StringLength_0to100_SimpleTypeString_SimpleType100
NewBusinessTransactionTypeCodeIndicates whether this record is either a Payment, Collection, Intragovernmental Payment and Collection (IPC), or Non-Treasury Disbursing Office (NTDO) Payment.BusinessTransactionType_SimpleTypexsd:stringPayment [Payment], Collection [Collection], IPC [Intragovernmental Payments and Collections], NTDOPMT [Non-Treasury Disbursing Office (NTDO) Payment]
NewChangeTypePopulated only for Partner Profiles requesting Reference Data changes to be distributed, Action is the reason for the change (e.g., new, modify).ChangeType_SimpleTypexsd:stringNew, Modified, Deleted, Expired
NewCityNameContains a city name.StringLength_0to50_SimpleTypeString_SimpleType50
NewContactTitleOfficial title of the individual identified as the point-of-contact. (Contact for the Agency Location)StringLength_0to50_SimpleTypeString_SimpleType50
NewDepartmentRegularCodeThis 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_SimpleTypeString_SimpleType[0-9]{2}
NewFullNameContains the full name of a person.StringLength_0to160_SimpleTypeString_SimpleType160
NewIsBusinessTransactionTypeReporterIndicates 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_SimpleTypexsd:boolean1|0
NewLastUpdatedTimestampDate 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_SimpleTypexsd:dateTime
NewLastUpdatedUserNameThe 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_SimpleTypexsd:string255
NewLegacyBureauCodeThis 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 CodeBureauIdentifier_SimpleTypeString_SimpleType[0-9]{2,3}
NewLegislativeBureauCodeThe Treasury code that identifies a major sub-organization of the agency, sometimes called an administration, service, or agency. (Not all agencies have bureaus.)BureauIdentifier_SimpleTypeString_SimpleType[0-9]{2,3}
NewOrganizationalDisplayNameA short or abbreviated name for the Organizational Unit. (Display Name of the Agency Location)OrganizationalDisplayName_SimpleTypexsd:string45
NewOrganizationalIdentifierA number that uniquely identifies an Organizational Unit of the United States Federal Government. (Organization Identifier of the Agency Location)OrganizationalIdentifier_SimpleTypexsd:integer8
NewOrganizationalTitleThe official name by which an Organization Unit of the United States Federal Government is referred. (Title of the Agency Location)StringLength_0to100_SimpleTypeString_SimpleType100
NewOrganizationDissolvedDateThe date on which the Organizational Unit ceased to exist. (Dissolved Date of the Agency Location)Date_SimpleTypexsd:date
NewOrganizationEstablishedDateThe date on which the Organizational Unit came into being. (Established Date of the Agency Location)Date_SimpleTypexsd:date
No ChangePhoneNumberA 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_SimpleTypeStringLength_0to20_SimpleTypeString_SimpleTypeString_SimpleType2020
NewPostalCodeA code added to an address line, typically for the purpose of sorting mail.StringLength_0to10_SimpleTypeString_SimpleType10
NewReportingCodeAn 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_SimpleTypeString_SimpleType[0-9]{8}
NewReportingStatusTimestampThe date and time at which point the Reporting Status (Payment, Collection, or Intragovernmental Payments and Collections) record was created.TimeStamp_SimpleTypexsd:dateTime
UpdatedReportingTransactionEffectiveDateThe 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:datexsd:date
NewSourceDocumentReferenceNumberThe reference number of the document authorizing changes to the Agency Location Code.SourceDocumentReferenceNumber_SimpleTypexsd:string9
UpdatedStateCodeUS state codes and Canadian province codes.US state code and Canadian province code.StateCode_SimpleTypeStateCode_SimpleTypeUSPS_StateCode_SimpleType CanadianProvinces_SimpleType
NewSuccessorCodeAn Agency Location Code defined as the valid replacement for an existing Agency Location Code upon its dissolution.AgencyLocationCode_SimpleTypeString_SimpleType[0-9]{8}
No ChangeTotalCountIndicates the total number of items.Indicates the total number of items.Count_SimpleTypeCount_SimpleTypexsd:nonNegativeIntegerxsd:nonNegativeInteger
NewVersionIdentifierIndicates an identifier assigned to a version for this transmission.StringLength_0to80_SimpleTypeString_SimpleType80
DroppedAgencyIdentifierIdentifies 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_SimpleTypeString_SimpleType[0-9]{3}
DroppedAgencyLocationCodeIdentifies the accounting office within an agency that reports disbursements and collections to Treasury.fms:AgencyLocationCode_SimpleTypeString_SimpleType[0-9]{8}
DroppedAgencyLocationTypeCodeA code that distinguishes the type of Agency Location (e.g., Regional Finance Center, Non-Treasury Dispersing Office subject to Audit).alc:AgencyLocationTypeCode_SimpleTypexsd:string10
DroppedAgencyNameName of the agency.fms:StringLength_0to80_SimpleTypeString_SimpleType80
DroppedBudgetBureauCodeThe 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_SimpleTypeString_SimpleType[0-9]{2,3}
DroppedBureauNameThe name of the Bureau.fms:StringLength_0to100_SimpleTypeString_SimpleType100
DroppedBusinessTransactionTypeCodeIndicates whether this record is either a Payment, Collection, or IPC.sam:BusinessTransactionType_SimpleTypexsd:stringPayment, Collection, IPC
DroppedChangeTypePopulated only for Partner Profiles requesting ERD changes to be distributed, Action is the reason for the change (e.g., new, modify).sam:ChangeType_SimpleTypexsd:stringNew, Modified, Deleted, Expired
DroppedCityNameContains the name of the city.StringLength_0to40_SimpleTypeString_SimpleType40
DroppedContactTitleOfficial title of the individual identified as the point-of-contact. (Contact for the Agency Location)sam:StringLength_0to50_SimpleTypexsd:string50
DroppedFullNameContains the full name of a person.StringLength_0to80_SimpleTypeString_SimpleType80
DroppedIsBusinessTransactionTypeReporterIndicates whether this ALC is or will be a Payment reporter "1", or if this ALC is not a reporter "0".fms:Boolean_SimpleTypexsd:boolean1|0
DroppedLastUpdatedTimestampDate 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
DroppedLastUpdatedUserNameThe 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_SimpleTypexsd:string255
DroppedLegacyAgencyCodeThis 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_SimpleTypeString_SimpleType[0-9]{2}
DroppedLegacyBureauCodeThis 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 Codefms:BureauIdentifier_SimpleTypeString_SimpleType[0-9]{2,3}
DroppedLegislativeBureauCodeThe 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_SimpleTypeString_SimpleType[0-9]{2,3}
DroppedOrganizationalDisplayNameA short or abbreviated name for the Organizational Unit. (Display Name of the Agency Location.)alc:OrganizationalDisplayName_SimpleTypexsd:string45
DroppedOrganizationalIdentifierA number that uniquely identifies an Organizational Unit of the United States Federal Government. (Organization Identifier of the Agency Location)alc:OrganizationalIdentifier_SimpleTypexsd:integer8
DroppedOrganizationalTitleThe official name by which an Organization Unit of the United States Federal Government is referred. (Title of the Agency Location.)sam:StringLength_0to100_SimpleTypexsd:string100
DroppedOrganizationDissolvedDateThe date on which the Organizational Unit ceased to exist. (Dissolved Date of the Agency Location)xsd:date
DroppedOrganizationEstablishedDateThe date on which the Organizational Unit came into being. (Established Date of the Agency Location.)xsd:date
DroppedPostalCodeExtensionThe 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_SimpleTypeString_SimpleType5
DroppedReportingCodeAn 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_SimpleTypeString_SimpleType[0-9]{8}
DroppedReportingStatusTimestampThe date and time at which point the Reporting Status (Payment, Collection, or IPC) record was created in GWA.xsd:dateTime
DroppedSourceDocumentReferenceNumberThe reference number of the document authorizing changes to the ALC.alc:SourceDocumentReferenceNumber_SimpleTypexsd:string9
DroppedSuccessorCodeAn Agency Location Code defined as the valid replacement for an existing ALC upon its dissolution.fms:AgencyLocationCode_SimpleTypeString_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.