ATM Transaction Anayzer User and Installation Guide

Appendix C 161
Table 6 Mapping of TLF File with Termsetelment 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 time 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 head.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.
adminCode admin_cde An indicator used to determine the type of settlement transaction
and originator of the transaction. Valid values: 20,21 and 22.
termDB setl_ttl.term_db The unverified amount of terminal debits since the terminal was
last balanced. The amount in this field consists of debits from the
institution's point of view
termCr setl_ttl.term_cr The total amount of terminal credits since the terminal was last
balanced. The amount in this field consists of credits from the
institution's point of view.
OnUsDb on_us_db The total amount of on-us debits since the terminal was last
balanced. The amount in this field consists of debits from the
customer's point of view.
OnUsCr setl_ttl.on_us_cr The total amount of on-us credits since the terminal was last
balanced. The amount in this field consists of credits from the
customer's point of view.
crncyCode setl_ttl.crncy_cde A code indicating the type of currency used during settlement.
Valid values are listed in the "ISO Codes for the Representation
of Currencies and Funds", 4217-1990.
userField9 setl_ttl.user_fld9 This field is not used.
timeOffset setl_ttl.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.
ttlArea setl_ttl.ttl_area This field is not used.
adminTime setl_ttl.admin_tim The time the administrative transaction occurred.
bin head.crd.pan.num Issuer BIN for specified length
Appendix C