ATM Transaction Anayzer User and Installation Guide

Appendix C 160
Table 5 Mapping of TLF File with TermCashAdj Table
Fields in ATM Database Fields in TLF File Description
transID Unique number for transaction. It can be treated as primary key.
transactionTime head.dat_tim The date and time on which the record was logged.
recordType head.rec_typ The type of TLF record logged. The value in this field is set by
the process that creates the TLF record (i.e. Authorization, Device
Handler or Settlement).
authprocess head.auth_ppd The PPD name (without the initial "$") of the Authorization
process that logged the record to the TLF.
terminalLN head.term.ln The logical network associated with the terminal.
terminalFIID head.term.fiid The FIID of the financial institution owning the terminal.
terminalID head.term.term_id The terminal ID of the terminal originating the transaction.
cardIssuerLN head.crd.ln The logical network associated with the card issuer.
cardIssuerFIID head.crd.fiid The FIID of the card issuer.
cardHoldPAN ead.crd.pan.num The cardholder's Primary Account Number (PAN) for card
initiated transactions. This field will contain an AFT group
number and user number for DCT initiated transactions.
cardHoldMemNum head.crd.mbr_num The member number associated with the account number.
termBranchID head.brch_id The branch ID associated with the terminal originating the
transaction.
termRegionID head.regn_id The region ID associated with the terminal originating the
transaction.
adminTime term_setl.admin_tim The time the administrative transaction occurred.
adminCode term_setl.admin_cde A code indicating a transaction type that involves increases and
decreases of currency. This code also identifies whether the
transaction was performed by Device Handler or at a CRT.
hoprContents term_cash.hopr_contents The contents contained in the hopper. Valid values are:
00 = Cash
01 = Coin
amount term_cash.amt The amount of increase or decrease to the hopper because of the
administrative transaction.
crncyCode term_cash.crncy_cde A code identifying the type of currency used for the
administrative transaction. Valid values are listed in the "ISO
Codes for the Representation of Currencies and Funds", 4217-
1990.
timeOffset term_cash.tim_ofst The time difference (plus or minus in minutes) between the
terminal location and the Tandem processor location. This field
is filled with the TIM-OFST from the TDF.
cashArea term_cash.cash_area This field is not used.