Treasury :: Financial Management Service
Enterprise Data Architecture
Data Dictionary/Change Log


Home :: Go Back
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 DefinitionDataTypePrior DataTypeRestriction BasePrior Restriction BaseString MinPrior String MinString MaxPrior String MaxTotal DigitsPrior Total DigitsFraction DigitsPrior Fraction DigitsPatternPrior PatternUnion MembersPrior Union MembersEnumeration ValuesPrior Enumeration Values
No ChangeAgencyIdentifierIdentifies 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.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_SimpleTypefms:AgencyIdentifier_SimpleTypeString_SimpleTypeString_SimpleType[0-9]{3}[0-9]{3}
No ChangeAgencyLocationCodeIdentifies the accounting office within an agency that reports disbursements and collections to Treasury.Identifies the accounting office within an agency that reports disbursements and collections to Treasury.fms:AgencyLocationCode_SimpleTypefms:AgencyLocationCode_SimpleTypeString_SimpleTypeString_SimpleType[0-9]{8}[0-9]{8}
No ChangeAgencyLocationTypeCodeA code that distinguishes the type of Agency Location (e.g., Regional Finance Center, Non-Treasury Dispersing Office subject to Audit).A code that distinguishes the type of Agency Location (e.g., Regional Finance Center, Non-Treasury Dispersing Office subject to Audit).alc:AgencyLocationTypeCode_SimpleTypealc:AgencyLocationTypeCode_SimpleTypexsd:stringxsd:string1010
No ChangeAgencyNameName of the agency.Name of the agency.fms:StringLength_0to80_SimpleTypefms:StringLength_0to80_SimpleTypeString_SimpleTypeString_SimpleType8080
No ChangeBudgetBureauCodeThe 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.)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_SimpleTypefms:BureauIdentifier_SimpleTypeString_SimpleTypeString_SimpleType[0-9]{2,3}[0-9]{2,3}
No ChangeBureauNameThe name of the Bureau.The name of the Bureau.fms:StringLength_0to100_SimpleTypefms:StringLength_0to100_SimpleTypeString_SimpleTypeString_SimpleType100100
No ChangeBusinessTransactionTypeCodeIndicates whether this record is either a Payment, Collection, or IPC.Indicates whether this record is either a Payment, Collection, or IPC.sam:BusinessTransactionType_SimpleTypesam:BusinessTransactionType_SimpleTypexsd:stringxsd:stringPayment, Collection, IPCPayment, Collection, IPC
No ChangeChangeTypePopulated only for Partner Profiles requesting ERD changes to be distributed, Action is the reason for the change (e.g., new, modify).Populated only for Partner Profiles requesting ERD changes to be distributed, Action is the reason for the change (e.g., new, modify).sam:ChangeType_SimpleTypesam:ChangeType_SimpleTypexsd:stringxsd:stringNew, Modified, Deleted, ExpiredNew, Modified, Deleted, Expired
NewCityNameContains the name of the city.StringLength_0to40_SimpleTypeString_SimpleType40
No ChangeContactTitleOfficial title of the individual identified as the point-of-contact. (Contact for the Agency Location)Official title of the individual identified as the point-of-contact. (Contact for the Agency Location)sam:StringLength_0to50_SimpleTypesam:StringLength_0to50_SimpleTypexsd:stringxsd:string5050
NewCountryCodeContains the code for a country.ISO_3166_CountryCode_Alpha2_SimpleTypexsd:tokenAF [AFGHANISTAN], AL [ALBANIA], AX [ALAND ISLANDS], DZ [ALGERIA], AS [AMERICAN SAMOA], AD [ANDORRA], AO [ANGOLA], AI [ANGUILLA], AQ [ANTARCTICA], AG [ANTIGUA AND BARBUDA], AR [ARGENTINA], AM [ARMENIA], AW [ARUBA], AU [AUSTRALIA], AT [AUSTRIA], AZ [AZERBAIJAN], BS [BAHAMAS], BH [BAHRAIN], BD [BANGLADESH], BB [BARBADOS], BY [BELARUS], BE [BELGIUM], BZ [BELIZE], BJ [BENIN], BM [BERMUDA], BT [BHUTAN], BO [BOLIVIA], BA [BOSNIA AND HERZEGOWINA], BW [BOTSWANA], BV [BOUVET ISLAND], BR [BRAZIL], IO [BRITISH INDIAN OCEAN TERRITORY], BN [BRUNEI DARUSSALAM], BG [BULGARIA], BF [BURKINA FASO], BI [BURUNDI], KH [CAMBODIA], CM [CAMEROON], CA [CANADA], CV [CAPE VERDE], KY [CAYMAN ISLANDS], CF [CENTRAL AFRICAN REPUBLIC], TD [CHAD], CL [CHILE], CN [CHINA], CX [CHRISTMAS ISLAND], CC [COCOS (KEELING) ISLANDS], CO [COLOMBIA], KM [COMOROS], CD [CONGO, THE DEMOCRATIC REPUBLIC OF THE], CG [CONGO], CK [COOK ISLANDS], CR [COSTA RICA], CI [COTE D'IVOIRE], HR [CROATIA (local name: Hrvatska)], CU [CUBA], CY [CYPRUS], CZ [CZECH REPUBLIC], DK [DENMARK], DJ [DJIBOUTI], DM [DOMINICA], DO [DOMINICAN REPUBLIC], TP [EAST TIMOR], EC [ECUADOR], EG [EGYPT], SV [EL SALVADOR], GQ [EQUATORIAL GUINEA], ER [ERITREA], EE [ESTONIA], ET [ETHIOPIA], FK [FALKLAND ISLANDS (MALVINAS)], FO [FAROE ISLANDS], FJ [FIJI], FI [FINLAND], FR [FRANCE], FX ["FRANCE, METROPOLITAN"], GF [FRENCH GUIANA], PF [FRENCH POLYNESIA], TF [FRENCH SOUTHERN TERRITORIES], GA [GABON], GM [GAMBIA], GE [GEORGIA], DE [GERMANY], GH [GHANA], GI [GIBRALTAR], GR [GREECE], GL [GREENLAND], GD [GRENADA], GP [GUADELOUPE], GU [GUAM], GT [GUATEMALA], GG [GUERNSEY], GN [GUINEA], GW [GUINEA-BISSAU], GY [GUYANA], HT [HAITI], HM [HEARD AND MC DONALD ISLANDS], HN [HONDURAS], HK [HONG KONG], HU [HUNGARY], IS [ICELAND], IM [ISLE OF MAN], IN [INDIA], ID [INDONESIA], IR [IRAN (ISLAMIC REPUBLIC OF)], IQ [IRAQ], IE [IRELAND], IL [ISRAEL], IT [ITALY], JM [JAMAICA], JP [JAPAN], JE [JERSEY], JO [JORDAN], KZ [KAZAKHSTAN], KE [KENYA], KI [KIRIBATI], KP ["KOREA, DEMOCRATIC PEOPLES REPUBLIC OF"], KR ["KOREA, REPUBLIC OF"], KW [KUWAIT], KG [KYRGYZSTAN], LA [LAO PEOPLE'S DEMOCRATIC REPUBLIC], LV [LATVIA], LB [LEBANON], LS [LESOTHO], LR [LIBERIA], LY [LIBYAN ARAB JAMAHIRIYA], LI [LIECHTENSTEIN], LT [LITHUANIA], LU [LUXEMBOURG], MO [MACAU], MK [MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF], MG [MADAGASCAR], MW [MALAWI], MY [MALAYSIA], MV [MALDIVES], ML [MALI], MT [MALTA], MH [MARSHALL ISLANDS], MQ [MARTINIQUE], MR [MAURITANIA], MU [MAURITIUS], YT [MAYOTTE], MX [MEXICO], FM [MICRONESIA, FEDERATED STATES OF], MD ["MOLDOVA, REPUBLIC OF"], MC [MONACO], MN [MONGOLIA], ME [MONTENEGRO], MS [MONTSERRAT], MA [MOROCCO], MZ [MOZAMBIQUE], MM [MYANMAR], NA [NAMIBIA], NR [NAURU], NP [NEPAL], NL [NETHERLANDS], AN [NETHERLANDS ANTILLES], NC [NEW CALEDONIA], NZ [NEW ZEALAND], NI [NICARAGUA], NE [NIGER], NG [NIGERIA], NU [NIUE], NF [NORFOLK ISLAND], MP [NORTHERN MARIANA ISLANDS], NO [NORWAY], OM [OMAN], PK [PAKISTAN], PS [PALESTINIAN TERRITORY, OCCUPIED], PW [PALAU], PA [PANAMA], PG [PAPUA NEW GUINEA], PY [PARAGUAY], PE [PERU], PH [PHILIPPINES], PN [PITCAIRN], PL [POLAND], PT [PORTUGAL], PR [PUERTO RICO], QA [QATAR], RE [REUNION], RO [ROMANIA], RU [RUSSIAN FEDERATION], RW [RWANDA], BL [SAINT BARTHELEMY], KN [SAINT KITTS AND NEVIS], LC [SAINT LUCIA], MF [SAINT MARTIN], VC [SAINT VINCENT AND THE GRENADINES], WS [SAMOA], SM [SAN MARINO], ST [SAO TOME AND PRINCIPE], SA [SAUDI ARABIA], SN [SENEGAL], RS [SERBIA], SC [SEYCHELLES], SL [SIERRA LEONE], SG [SINGAPORE], SK [SLOVAKIA (Slovak Republic)], SI [SLOVENIA], SB [SOLOMON ISLANDS], SO [SOMALIA], ZA [SOUTH AFRICA], GS [SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS], ES [SPAIN], LK [SRI LANKA], SH [ST. HELENA], PM [ST. PIERRE AND MIQUELON], SD [SUDAN], SR [SURINAME], SJ [SVALBARD AND JAN MAYEN ISLANDS], SZ [SWAZILAND], SE [SWEDEN], CH [SWITZERLAND], SY [SYRIAN ARAB REPUBLIC], TW ["TAIWAN, PROVINCE OF CHINA"], TJ [TAJIKISTAN], TZ ["TANZANIA, UNITED REPUBLIC OF"], TH [THAILAND], TL [TIMOR-LESTE], TG [TOGO], TK [TOKELAU], TO [TONGA], TT [TRINIDAD AND TOBAGO], TN [TUNISIA], TR [TURKEY], TM [TURKMENISTAN], TC [TURKS AND CAICOS ISLANDS], TV [TUVALU], UG [UGANDA], UA [UKRAINE], AE [UNITED ARAB EMIRATES], GB [UNITED KINGDOM], US [UNITED STATES], UM [UNITED STATES MINOR OUTLYING ISLANDS], UY [URUGUAY], UZ [UZBEKISTAN], VU [VANUATU], VA [VATICAN CITY STATE (HOLY SEE)], VE [VENEZUELA], VN [VIET NAM], VG [VIRGIN ISLANDS (BRITISH)], VI [VIRGIN ISLANDS (U.S.)], WF [WALLIS AND FUTUNA ISLANDS], EH [WESTERN SAHARA], YE [YEMEN], YU [YUGOSLAVIA], ZR [ZAIRE], ZM [ZAMBIA], ZW [ZIMBABWE]
No ChangeFullNameContains the full name of a person.Contains the full name of a person.StringLength_0to80_SimpleTypeStringLength_0to80_SimpleTypeString_SimpleTypeString_SimpleType8080
No ChangeIsBusinessTransactionTypeReporterIndicates whether this ALC is or will be a Payment reporter "1", or if this ALC is not a reporter "0".Indicates whether this ALC is or will be a Payment reporter "1", or if this ALC is not a reporter "0".fms:Boolean_SimpleTypefms:Boolean_SimpleTypexsd:booleanxsd:boolean1|01|0
Updated-MultipleIsNonDomesticIndicates whether this entity is a US domestic entity, for example, this value would be '1' if the address was an international address. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be '0'.Indicates whether this entity is a US domestic entity, for example, this value would be '1' if the address was an international address or the clearing financial institution was a non-US financial institution. If the attribute is not populated or not present in the XML instance document, then the default value is understood to be '0'.Boolean_SimpleTypeBoolean_SimpleTypexsd:booleanxsd:boolean1|01|0
No ChangeLastUpdatedTimestampDate 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)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:dateTimexsd:dateTime
No ChangeLastUpdatedUserNameThe 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)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_SimpleTypesam:StringLength_0to255_SimpleTypexsd:stringxsd:string255255
No ChangeLegacyAgencyCodeThis 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.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_SimpleTypefms:AgencyCode_SimpleTypeString_SimpleTypeString_SimpleType[0-9]{2}[0-9]{2}
No ChangeLegacyBureauCodeThis 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 CodeThis 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_SimpleTypefms:BureauIdentifier_SimpleTypeString_SimpleTypeString_SimpleType[0-9]{2,3}[0-9]{2,3}
No ChangeLegislativeBureauCodeThe Treausry code that identifies a major sub-organization of the agency, sometimes called an administration, service, or agency. (Not all agencies have bureaus.)The Treausry code that identifies a major sub-organization of the agency, sometimes called an administration, service, or agency. (Not all agencies have bureaus.)fms:BureauIdentifier_SimpleTypefms:BureauIdentifier_SimpleTypeString_SimpleTypeString_SimpleType[0-9]{2,3}[0-9]{2,3}
No ChangeOrganizationalDisplayNameA short or abbreviated name for the Organizational Unit. (Display Name of the Agency Location.)A short or abbreviated name for the Organizational Unit. (Display Name of the Agency Location.)alc:OrganizationalDisplayName_SimpleTypealc:OrganizationalDisplayName_SimpleTypexsd:stringxsd:string4545
No ChangeOrganizationalIdentifierA number that uniquely identifies an Organizational Unit of the United States Federal Government. (Organization Identifier of the Agency Location)A number that uniquely identifies an Organizational Unit of the United States Federal Government. (Organization Identifier of the Agency Location)alc:OrganizationalIdentifier_SimpleTypealc:OrganizationalIdentifier_SimpleTypexsd:integerxsd:integer88
No ChangeOrganizationalTitleThe official name by which an Organization Unit of the United States Federal Government is referred. (Title of the Agency Location.)The official name by which an Organization Unit of the United States Federal Government is referred. (Title of the Agency Location.)sam:StringLength_0to100_SimpleTypesam:StringLength_0to100_SimpleTypexsd:stringxsd:string100100
No ChangeOrganizationDissolvedDateThe date on which the Organizational Unit ceased to exist. (Dissolved Date of the Agency Location)The date on which the Organizational Unit ceased to exist. (Dissolved Date of the Agency Location)xsd:datexsd:date
No ChangeOrganizationEstablishedDateThe date on which the Organizational Unit came into being. (Established Date of the Agency Location.)The date on which the Organizational Unit came into being. (Established Date of the Agency Location.)xsd:datexsd: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 of letters and/or digits added to an address line.PostalCode_SimpleTypeString_SimpleType10
NewPostalCodeExtensionThe 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
No ChangeReportingCodeAn Agency Location Code that is designated as the parent for one of more children ALCs, responsible for reporting accounting transactions for those children.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_SimpleTypefms:AgencyLocationCode_SimpleTypeString_SimpleTypeString_SimpleType[0-9]{8}[0-9]{8}
No ChangeReportingStatusTimestampThe date and time at which point the Reporting Status (Payment, Collection, or IPC) record was created in GWA.The date and time at which point the Reporting Status (Payment, Collection, or IPC) record was created in GWA.xsd:dateTimexsd:dateTime
No ChangeReportingTransactionEffectiveDateThe date upon which the ALC actually began reporting Payment transactions to GWA.The date upon which the ALC actually began reporting Payment transactions to GWA.xsd:datexsd:date
No ChangeSourceDocumentReferenceNumberThe reference number of the document authorizing changes to the ALC.The reference number of the document authorizing changes to the ALC.alc:SourceDocumentReferenceNumber_SimpleTypealc:SourceDocumentReferenceNumber_SimpleTypexsd:stringxsd:string99
NewStateCodeUS state code and Canadian province code.StateCode_SimpleType
No ChangeSuccessorCodeAn Agency Location Code defined as the valid replacement for an existing ALC upon its dissolution.An Agency Location Code defined as the valid replacement for an existing ALC upon its dissolution.fms:AgencyLocationCode_SimpleTypefms:AgencyLocationCode_SimpleTypeString_SimpleTypeString_SimpleType[0-9]{8}[0-9]{8}
No ChangeTotalCountIndicates the total number of items.Indicates the total number of items.Count_SimpleTypeCount_SimpleTypexsd:nonNegativeIntegerxsd:nonNegativeInteger

For help, please contact the Treasury FMS Enterprise Data Architecture team.
Last Updated: 2010-12-16T07:17:32.984-05: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.