Treasury :: Bureau of the Fiscal Service

Enterprise Data Architecture

CollectionsReport Data Exchange

Data Exchange Listing CollRpt Sumry BT FT PlstcCrdDtl [0..1] OrdLvl_III_Dta [0..1] DtaElmt [0..unbounded] Library Resource Documentation Data Dictionary and Change Log Data Dictionary Attribute DataDictionary Element DataDictionary PlstcCrdDtl 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 PlstcCrdDtl Definition The container for plastic card information. DataType Container Attribute Information Attribute Name Use DataType Definition ID required String [0, 80] 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. MthYrExpirDt optional (([0][1-9])|([1][0-2]))[0-9]{2} Indicates the month/year value of a card's expiration date. CrdNr optional [0-9]{15,16}|[0-9]{4,4} The credit card or debit card number. MskdCrdNr required String [0, 19] The masked credit card or debit card number. CrdSctyCd optional [0-9]{3,4} The 3 or 4 digit value printed on the card or signature strip but not available on the magnetic strip. OrigIntchgCd optional String [0, 2] The code assigned by the plastic card service provider that provides the business type for the transaction. IntchgCd optional String [0, 9] The code that identifies the type of transaction that the interchange fee applies to and dictates the interchange fee amount applied to the transaction. IntchgRembrsFeeAmt optional Decimal [15, 9] The amount that the merchant must pay to the network carrier (i.e. Visa, MasterCard, AMEX, Discover) representing the true cost of a plastic card transaction. IntchgRembrsFeeAmtSgnInd optional - [Indicates the amount is negative.], + [Indicates the amount is positive.] The sign of the Interchange Reimbursement Fee Amount. IntchgAdjResnCd optional String [0, 3] The one character code that defines why the surcharge, downgrade or adjustment was done. IntchgAdjAmt optional Decimal [15, 9] The amount over paid or under paid for each transaction based on the base qualification rate. If the base rate is 1.43% + IntchgAdjAmtSgnInd optional - [Indicates the amount is negative.], + [Indicates the amount is positive.] The sign of the Interchange Adjustment Amount. AuthChrsCd optional String [0, 2] The code that defines if the card was presented for authorization, whether the merchant name and location were provided, or what authorization was used when the card was not provided. AuthCd optional String [0, 6] The code assigned by the plastic card issuer to identify the approval for a specific authorization request. AuthSrcCd optional String [0, 1] The code that identifies the authorization source for the card transaction, such as 'Automated Referral Service Response.' AVS_RspCd optional String [0, 2] The Address Verification Service (AVS) response code is the code that the merchant received when processing the transaction that is related to the processing of the address information. MrchntStrNr optional String [0, 9] The nine digit number assigned by the plastic card settlement provider to identify a merchant's store. MrchntCatCd optional String [0, 25] The code that designates the type of merchant business (food, department store, etc.) for a plastic card transaction. MrchntNr required String [0, 18] The unique identifier of the plastic card merchant, as assigned by the settlement provider. For collections activities this identifier currently uniquely represents an Agency within the plastic card settlement provider. CrdPrdctTypCd optional String [0, 3] The three character code that provides information on the type of plastic card, valid only for Visa, Discover and MasterCard, e.g., 'MDG' refers to a Gold MasterCard Debit Card. ClntBtchNr optional String [0, 6] The number which identifies the sequential position of a batch within a file. CshBckAmt optional Decimal [20, 2]Min Inclusive: 0.00 The amount of money that is added to the total purchase price of a transaction (paid by debit card), which the customer receives in cash along with their goods. CrdNtwrkTypCd optional String [0, 20] The type of network the plastic card used for a payment, e.g., VISA, MCRD, AMEX, etc. CrdPrdctCd optional String [0, 2] The type of card used for the transaction, e.g., AX (American Express). NtwrkRspCd optional String [0, 25] The code detailing the card provider's response, which is formatted based on the card network. CrgbkRefNr optional String [0, 12] The network reference number related to the chargeback. CrdRspCd optional String [0, 2] The code used for credit and gift cards that specifies how and if the card security code was processed. CrgbkRecNr optional String [0, 12] The number assigned to any single customer transaction that is questioned, used to relate all disputes and subsequent records. DrftLoctNr optional String [0, 11] The number associated with data matching, supplied by the customer. CAT_Cd optional String [0, 2] The code that provides the type of Cardholder Activated Terminal (CAT) used in the transaction. OrdID optional String [0, 80] The identifier for plastic card order-level data. POS_EntyMde optional String [0, 3] The code that defines how the authorization for the card was read. The first two positions refer to how the card was read and the third position refers to the capture of the PIN. RgstrNr optional String [0, 4] The number which identifies the register where the plastic card transaction occurred. StrPrsnID optional String [0, 9] The idenitifier, supplied by the merchant, that represents the person who originated the transaction. TrmNr optional String [0, 15] The number which identifies the terminal where the plastic card transaction occurred. TaxblAmt optional Decimal [20, 2]Min Inclusive: 0.00 The taxable amount of the transaction. TxnTmZnCd optional String [0, 3] The code representing the time zone of the merchant. For example, 'EST' represents 'Eastern Standard Time'. TxnTm optional HH:MM:SS or may end in 'Z' to reflect UTC (Coordinated Universal Time) The date and time the transaction occurred. ChnlCtffTm optional HH:MM:SS or may end in 'Z' to reflect UTC (Coordinated Universal Time) The time that determines the end of a 24 hour day for plastic card payments, when a transaction will be sent for settlement, as defined by the agency. CrdEvnTypCd optional String [0, 15] The event type of the plastic card transaction, e.g., Sale, Authorization, Void Sale, etc. AuthRqstRspCd optional String [0, 2] The code that indicates whether the transaction is approved or declined. If declined, it will indicate why it was declined. PlstcTypCd optional CRT [Credit Card], DBT [Debit Card], EBT [Electronic Benefit Card], GFT [Gift Card], WIC [WIC] The code that identifies the type of plastic card medium used, e.g., credit card, gift card, etc. AdjTypCd optional String [0, 10] The code identifying the type of change to a previous transaction. Technical Information Schema version urn:us:gov:treasury Cardinality [0..1] Content Model The <PlstcCrdDtl> element contains 2 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 <PlstcCrdDtl> 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.