Trying to modify and improve the speed of the scripts that are generated.
Customer had removed this in a few spots and put in some others (I think a direct pointer to a column in another derived/shredded table.) As we did this, we figured out it was affecting publish to FD in portal. How does variable know what the parent is for say ~(Parent(!)~?
The ~PARENT(1)~ variable is used alongside the foreign key relationship. So the portal knows to which parent column it should reference to by checking the FK relationship then picking up the corresponding row, in this case row 1.