Download System Administrator`s Manual 5.4

7 Reference Information
7.6.4
Page 199/245
Portfolio Calculations
The PORTFOLIO CALCULATIONS tables use a LIST partition on the PFCMIK field on
PFCDATES. All children and grandchildren referencing PFCDATES are partitioned by
Reference. Initial partitioning is done as a partition for each “original” PFCMIK’s that is
calculations that are not copies of other calculations, whereas copies will reside in the
default partition.
The Portfolio calculations are partitioned due to the performance gains in deleting data
during calculations, rather than for archiving purposes. This also implies that there is no
maintenance operations required for this set of tables:
Table
Description
PFCDATES
Partitioned by PFCMIK.
PFCHOLDINGS
PFCKEYRATIOS
PFCPERIODS
PFCHOLDINGMATCH
PFCSTRUCTCOMPS
PFCIMPKEYRATIOS
PFCHEDGEHOLD
PFCHEDGEPER
PFCCOSTS
PFCPERTAXSPECIALITY
PFCFORMULASFLDS
PFCDELTAVEC
PFCBUSINESSCLASSES
Partitioned by reference
PFCHOLDFRCREDMATCH
PFCFORMULASRES
PFCSUBLUNRFXGAINLOSS
PFCFIFOFORMULASFLDS
PFCHOLDWSADJ
PFCPROCEEDREINVESTS
CALCEXPL
PFCHOLDRESTIMATCH
PFCCASHFLOWS
PFCCONTRACTHOLD
PFCHEDGEPRICESRCH
Copyright © SimCorp
Release Document for 5.4 - System Administrator’s Manual