ATM Transaction Anayzer User and Installation Guide

Appendix C 154
Appendix C
Database Mapping with TLF File
This section provides a list of fields in the ATM database and the mapped fields in the TLF file. A sample
USRTLFC file to populate transaction date/time and card number in user-defined fields from the TLF record is also
described in this section.
Table 3 Mapping of TLF File with Transaction Table
Fields in ATM Database Fields in TLF File Description
transID Unique number for a transaction. It can be treated as the
primary key.
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.
termLN head.term.ln The logical network associated with the terminal.
termFIID head.term.fiid The FIID of the financial institution owning the terminal.
termID 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.
transModeType tlf_auth.typ_cde A code used to determine whether an envelope or a check was
involved in the transaction. The value in this field is set by
Authorization at the time the record is logged.
transCode tlf_auth.typ The type of message associated with this record.
msgRTEStatus tlf_auth.rte_stat A code used to determine the status of a message at the system
level.
originator tlf_auth.originator An indicator identifying where the transaction originated.
responder tlf_auth.responder An indicator identifying where the response message (0210)
was generated.
seqNum tlf_auth.seq_num The sequence number associated with this transaction.
termType tlf_auth.term_typ The type of terminal at which this transaction was initiated.
acquirerRoutingNum tlf_auth.acq_inst_id_num The routing or transit number of the terminal owner.
issuerRoutingNum tlf_auth.rcv_inst_id_num The card-issuer routing or identification number.
transTypeCode tlf_auth.u_tran_cde.tran_cde_r
.t_cde
The type of transaction.
transFromAccType tlf_auth.u_tran_cde.tran_cde_r
.t_from
The type of ‘from’ account.
transToAccType tlf_auth.u_tran_cde.tran_cde_r
.t_to
The type of ‘to’ account.