Download System Operations User Manual

Data Purging
Table Name
Purpose
Recommended
Purge
Frequency
Recommended
Purge
Handling
(Months)
st_inwtxn_rej_bkup
Stores records
rejected by
Inward
Clearing
process
Daily
60
st_inwtxn_rej_hist
Stores records
rejected by
Inward
Clearing
process
Monthly
12
fct_all_fcr_txns_mmdd
Stores log of
all transactions
on GL
accounts.
Monthly
12
ba_cheque_issue
Stores the
details of
MC/DD/TT
Issued
Bi-monthly
The MC/DD/TT
which are
issued to the
customer and
for which issue
date is 7 days
earlier from
today’s posting
date are
purged.
ch_acct_ledg
Ledger for the
transactions on
CASA
accounts
Monthly
The data in
CASA account
ledger is
retained for the
period specified
at the product
level. All
records in the
ledger which
are older than
the data
retention period
specified at the
product level
from today’s
posting date
are purged.
51