We have a requirement to read the waterline view data under portfolio management and update an attribute in the corresponding investment with the ranking.
I looked into the PFM tables. Looks like the RANK_EDITS stores temporary edited ranking but once they are saved, the data disappears. Yet, when the user logs out and logs in, the ranking appears as modified. Not sure where it is reading the modified rankings from.
Also, if I move the waterline up or down, it stays in place upon subsequent logins - which means it is also being saved somewhere.
Any idea on which PFM tables store this data? Has anyone played with this?