Database Reference
In-Depth Information
Table 4.9 A typical list of
transaction channels in retail banking.
Transaction channels
Branch
ATM
APS (Automatic Payment System)
Internet
Phone
SMS
Standing order
Other
Table 4.10 A lookup table for transaction codes.
Field name
Field type
Field description
Transaction_Code
Int
The transaction code
Transaction_Desc
Char
The transaction description
Debit_Credit
Bit
Debit/credit transaction flag
Transaction_Type
Char
The basic transaction type (see the categoriza-
tion of table 4.11, first level)
Transaction_Group
Char
The transaction group (see the categoriza-
tion of table 4.11, second level)
Transaction_Subgroup
Char
The transaction subgroup (see the categoriza-
tion of table 4.11, third level)
Transaction_Code is the primary key (PK) of this table.
Grouping Transactions with Other Criteria
Obviously, the transactional data can also be aggregated according to any
other grouping criteria to address other mining objectives. For instance,
the summarization of credit card purchase transactions by merchant type,
provided of course the merchant code and type are recorded, can reveal the
general purchasing habits of customers and facilitate the profiling of credit
card holders by their purchase preferences.
Search WWH ::




Custom Search