Download System Operations User Manual

Transcript
Data Purging
Table Name
Purpose
Recommended
Purge
Frequency
Recommended
Purge
Handling
(Months)
ch_acct_mast
CASA Account
Master
None
No system
purge set up on
this table.
td_acct_mast
TD Account
Master
None
No system
purge set up on
this table.
ln_acct_mast
Loans Account
Master
None
No system
purge set up on
this table.
ln_acct_ledg
Ledger for
transactions on
Loan accounts
None
No system
purge set up on
this table
ch_acct_statistics
Stores the
CASA account
balances to be
used for ADB
computation
None
At the
beginning of
financial year
the balances
from this table
get initialized by
the system.
When ever
CASA account
is closed,
corresponding
record from this
table is deleted
by the system.
ch_si_table
Stores the
information of
Standing
Instructions on
CASA
accounts to be
executed
Monthly
Records
pertaining to
the standing
instructions for
which execution
period has
expired three
months before
the today’s
posting date
are purged by
the system
51