How Campaign uses the TempFlag column
Problem or error: What is the TempFlag column used for in the Campaign system tables?
Solution: The TempFlag column is the mechanism for allowing the user to cancel without saving changes. Depending on the version of Campaign, this column is found in different Campaign system tables (for example, the UA_flowchart, UA_Segment, and UA_SummaryCube tables). Values used in these fields are as follows.
*
*
When you create a Campaign object and you begin configuring it, a new row is created with TempFlag = 1. At this point there is no row with TempFlag = 0.
When you save the object, a new row is created with TempFlag=0. Now there are two rows for the same record. The system uses these rows as follows:
*
*
*
If the operation is saved, then the changes are first copied to the TempFlag=0 row. The TempFlag=1 row is deleted.