Treasury :: Bureau of the Fiscal Service

Enterprise Data Architecture

CollectionsReport Data Exchange

Data Exchange Listing CollRpt Sumry [0..unbounded] BT [0..unbounded] Vchr [0..1] Tot [1..1] TrdgPartnExts [0..1] Library Resource Documentation Data Dictionary and Change Log Data Dictionary Attribute DataDictionary Element DataDictionary Sumry Data Documents Browse the Mind Map Data Listing Help Basic Help Generic Help Downloads Published Releases Current 5.0.2 Release Archived Releases Release 4.8 Release 4.7 Release 4.6 Release 4.5 Release 4.4 Release 4.3 Release 4.2.1 Release 4.2 Release 4.1 Release 4.0 Release 3.0 Release 2.2 Release 2.1 Expand All Collapse All

Element Information Name Sumry Definition The container for all summarized and detail level information. DataType Container Attribute Information Attribute Name Use DataType Definition AcctbBusLnCd optional Collections [Collections], DebtCollection [Debt Collection], Payments [Payments], Intragovernmental [Intragovernmental], Securities [Securities], Investments [Investments], Miscellaneous [Miscellaneous] The business line of a transaction's content (as opposed to the business line of the program that processes the transaction, which is not always the same). ALC optional [0-9]{8} The identifier for an accounting office within an agency that reports disbursements and collections to Treasury. OrgNm optional String [0, 100] The official name by which an Organization Unit of the United States Federal Government is referred. (Title of the Agency Location) AgcySiteID optional String [0, 80] The identifier for the agency site that processes a transaction. AgcySiteNm optional String [0, 80] The name of the agency site that processes a transaction. AgtBnkAcctNr optional String [0, 50] The account number of a deposit account at a financial agent or depositary that the bank uses for transactions involving public money. AgtBnkNm optional String [0, 80] The name of the agent or depositary. AgtRTN required [exact length: 9] (([0][0-9])|[1][0-2]|[2][1-9]|[3][0-2]|[6][1-9]|[7][0-2]|[8][0]|[9][0-1])[0-9]{7} The routing number (RTN) associated with an agent or depositary. BnkBrnchID optional String [0, 64] The identifier for a financial institution branch. BnkPostDt optional YYYY-MM-DD The date that an agent or depositary credits or debits funds to or from a Treasury account (either a deposit account or routing number (RTN)). BulkPrvrNm optional String [0, 30] The name of a payroll provider that makes tax payments through an Electronic Data Interchange (EDI) compatible system. BurNm optional String [0, 100] The name of a bureau. CshFlwID optional String [0, 80] The identifier for a class of agency transactions that share the same purpose, assigned on a program-specific basis. For example, collections associated with an agency form constitute a cash flow. CshFlwNm optional String [0, 80] The name for the class of agency transactions that share the same purpose, assigned on a program-specific basis. For example, collections associated with an agency form constitute a cash flow. ChnID optional String [0, 80] The identifier assigned to each account by a plastic card provider. Some agencies have more than one Chain to differentiate between major lines of business; ChainIdentifer is associated to DivisionIdentifier. ChnlEInd optional 1|0 The indicator denoting whether the Fiscal Service program received the transactions electronically. ChnlTypCd optional OTC [Indicates a transaction was received Over The Counter (OTC)], Mail [Indicates a transaction was received by mail], Internet [Indicates a transaction was received through a web-based portal], Phone [Indicates a transaction was received by phone], Bank [Indicates a transaction was received by a bank], Mobile [Indicates a transaction was received through a mobile application] The code that identifies the channel through which an agent or depositary receives a transaction. CAN required [0-9]{6} The six-digit identifier representing a Central Accounts Receivable System (CARS) account profile that includes a legacy CA CollBusDt optional YYYY-MM-DD The date that collections information is centralized in a data repository prior to subsequent reporting. CollStatCd required Cancelled [The financial transaction has been cancelled before submission to the settlement mechanism.], Rejected [The financial transaction has been rejected by the settlement mechanism.], Retired [No more collection efforts will be initiated on the financial item and the agency is debited for the uncollected funds.], Settled [The financial transaction has been settled.], In-Process [The financial transaction has been delivered to the settlement mechanism but has not settled.], Received [The financial transaction has been submitted to the channel.], Unknown [The status of the financial transaction is not known.] The code that denotes the status of a transaction; i.e., where it is in its lifecycle. CostCtrWrkUnitCd optional String [4, 4] The cost center work unit associated with FRB vouchers and transactions. ComlBnkInd required 1|0 The indicator denoting whether the item was settled through a commercial depositary. CrInd required 1|0 The indicator denoting whether an item is a debit or credit. DivID optional String [0, 100] The identifier assigned to each account by a plastic card provider that represents a deposit into the Collections Information Repository (CIR), when combined with a Chain. FRB_AcctKeyCd optional String [3, 3] The identifier for a program assigned within FRB CA FRB_DistCd optional 01 [FRB Boston], 02 [FRB New York], 03 [FRB Philadelphia], 04 [FRB Cleveland], 05 [FRB Richmond], 06 [FRB Atlanta], 07 [FRB Chicago], 08 [FRB St. Louis], 09 [FRB Minneapolis], 10 [FRB Kansas City], 11 [FRB Dallas], 12 [FRB San Francisco] The code denoting the general area of coverage for a Federal Reserve Bank. The Federal Reserve System assigns district codes. FRB_OfcCd optional String [0, 1] The code denoting a particular Federal Reserve Bank location within a given Federal Reserve Bank district. InitProcgSiteID optional String [0, 80] The identifier for initial agent or depositary site that receives a transaction. For example, each lockbox processing site can have its own identifier. IptSysTxt optional String [0, 40] The sending trading partner that provides information to a receiving trading partner. IRS_TaxInd required 1|0 The indicator denoting whether an item is an IRS tax transaction. LkbxAcctID optional String [0, 80] The identifier for the lockbox activity received by a lockbox processing site. MnlEntyInd optional 1|0 The indicator denoting whether an entry was captured through manual entry by an agent. NonDomBnkInd optional 1|0 The identifier denoting whether the Fiscal Service considers an entity to be non-domestic. NonTreasCollCd optional NGAF [Non Government Agency Fund], CIHO [Cash and Investments Held Outside of Treasury] The identifier that indicates whether a collection is the responsibility of a non-governmental agency or a government agency that holds cash outside of Treasury. OthScndryRTN optional [exact length: 9] (([0][0-9])|[1][0-2]|[2][1-9]|[3][0-2]|[6][1-9]|[7][0-2]|[8][0]|[9][0-1])[0-9]{7} The routing number (RTN) used to segregate transaction activity, that is reported to the Treasury's Master Account through a Subaccount RTN, to accommodate reporting and operational needs. It is also referred to as an Other Secondary Customer Identification Number (CIN) by the Federal Reserve or as a Tier 3 RTN by Treasury. ProcgPgmNm optional String [0, 40] The name of a source processing program; i.e., the name of a Fiscal Service program that first processes a transaction. ProcgSbprgNm optional String [0, 40] The name of a subprogram or component of a source processing program. ScndryProcgPgmNm optional String [0, 40] The name of an additional processing program; i.e., the name of a Fiscal Service program that is involved in processing a transaction. ScndryProcgSbprgNm optional String [0, 40] The name of a subprogram or component of an additional processing program. PgmTrcID optional String [0, 80] The identifier a financial agent provides to support traceability throughout a collection lifecycle. RcptMchsmCd optional Cash [Indicates receipt of coin or paper currency.], Cash/Und Check [Indicates receipt of either cash and/or checks.], Book Entry [Indicates a transaction occurred through an electronic general ledger entry.], Paper Check [Indicates a paper check was received.], Check Image [Indicates a check image was received.], ACH [Indicates a transaction that takes place across the Automated Clearing House (ACH) Network.], Wire [Indicates a transaction through a real-time electronic funds transfers.], Card [Indicates a transaction through a plastic card service provider.], SVC [Indicates a transaction using a Stored Value Card (SVC).], NSS [Indicates a transaction was received through the Enterprise Accounting System (EASy).], EASy [Indicates a settlement through the Enterprise Accounting System (EASy).], Digital Wallet [Indicates a transaction using a digital wallet.], Intrabank [Indicates a transaction took place through an intrabank funds transfer.], Other [Indicates a receipt mechanism used other than Cash, Cash/Und Check, Paper Check, Check Image, Book Entry, ACH, Wire, Card, SVC, NSS, EASy, Digital Wallet, or Intrabank.] The code that identifies the format of a financial instrument when a collections channel program receives it. RptBusLnCd optional Collections [Collections], DebtCollection [Debt Collection], Payments [Payments], Intragovernmental [Intragovernmental], Securities [Securities], Investments [Investments], Miscellaneous [Miscellaneous] The business line of the program that processes the transaction (as opposed to the business line of a transaction's content, which is not always the same). RptPgmNm required String [0, 40] The name of a reporting program; i.e., the name of a Fiscal Service program that reports transactions to a central repository. RptSbprgNm optional String [0, 40] The name of a subprogram or component of a reporting program. SvcngALC optional [0-9]{8} The Agency Location Code (ALC) of the agency that provides services to another agency. SttlMchsmCd optional Cash [Indicates settlement by deposit of coin or paper currency.], Cash/Und Check [Indicates settlement that is either cash and/or checks settled by Check21 or paper method.], Book Entry [Indicates a settlement using an electronic general ledger entry.], Paper Check [Indicates a settlement using a paper check method.], Check Image [Indicates a settlement using Check21.], ACH [Indicates a settlement that takes place across the Automated Clearing House (ACH) Network.], Wire [Indicates a settlement through a real-time electronic funds transfers.], Card [Indicates a settlement through a plastic card settlement service.], SVC [Indicates a settlement using a Stored Value Card (SVC).], NSS [Indicates that a settlement occurred through the Net Settlement Service (NSS).], EASy [Indicates a settlement through the Enterprise Accounting System (EASy).], Digital Wallet [Indicates a settlement using a digital wallet.], Intrabank [Indicates a settlement through an intrabank funds transfer.], Other [Indicates a settlement used other than Cash, Cash/Und Check, Paper Check, Check Image, Book Entry, ACH, Wire, Card, SVC, NSS, EASy, Digital Wallet, or Intrabank.] The mechanism by which a financial institution settles a transaction. SttlRcptDt optional YYYY-MM-DD The date that a settlement gateway or provider receives financial data for processing. ID required String [0, 80] The identifier for the summary record. A receiving system can use this value to reconcile updates to an existing record and qualify new records. A sending system can use this value to reconcile acknowledgements for the submitted records. SubAcctRTN optional [exact length: 9] (([0][0-9])|[1][0-2]|[2][1-9]|[3][0-2]|[6][1-9]|[7][0-2]|[8][0]|[9][0-1])[0-9]{7} The routing number (RTN) used to segregate transaction activity, that is reported directly to the Treasury Master Account, to accommodate reporting and operational needs. It is also referred to as a SubAccount Customer Identification Number (CIN) by the Federal Reserve or as a Tier 2 RTN by Treasury. Technical Information Schema version urn:us:gov:treasury Cardinality [0..unbounded] Content Model The <Sumry> element contains 4 children elements and has a sequence content model. The sequence content model means that there is a particular order to the children elements of the parent element - in this case, the <Sumry> element has a particular order of elements that must be followed.

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

Last Updated: 2017-05-02T13:15:17.047-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.