Credit Card Analysis of Czech Bank

ITCS6265 : Fall Semester of 2002
Instructor: Dr. Mirsad Hadzikadic

UNC-Charlotte  |  College of IT  |  Dr. Mirsad Hadzikadic  |  ITCS6265   


Site Index   Domain - Transactions
· Goal
· Domain
· Accounts
· Clients
· Disposition
· Loans
· Permanent Orders
· Transactions
· Demographics
· Credit Cards
· Pre-Processing
· Methodology
· Results
· Next Steps
· References
· Authors

TRANSACTION Schema
Column Description Notes
trans_id Record Identifier  
account_id Account the transaction is issued on  
date Date of transaction In the form: YYMMDD
type debit/credit transaction 'PRIJEM' stands for Credit

'VYDAJ' stands for Debit (withdrawal)

operation Mode of Transaction 'VYBER KARTOU' stands for Credit Card Withdrawal

'VKLAD' stands for Credit in Cash

'PREVOD Z UCTU' stands for Collection from Another Bank

'VYBER' stands for Withdrawal in Cash

'PREVOD NA UCET' stands for Remittance to Another Bank

amount Amount of Transaction  
balance Balance of Account after Transaction  
K_Symbol Characterization of Transaction 'POJISTNE' stands for Insurance Payment

'SLUZBY' stands for Payment of Statement

'UROK' stands for Interest Credited

'SANKC. UROK' stands for Sanction Interest if Negative Balance

'SIPO' stands for Household Payment

'DUCHOD' stands for Old-age Pension Payment

'UVER' stands for Loan Payment

bank Bank of the partner Each bank has unique two-letter code
account Account of the partner