index back

Optmz. Prob. Inst. Sync.

This table is used by the optimization server to reduce performance overhead in synchronizing in-memory data with the database. Application changes the versions in this table whenever changes are made application data in a problem instance. The RECNAME must be defined for the problem type associated with problem instance in OPTRECS table.

PeopleSoft Field NameField TypeColumn TypeDescription
PROBINSTCharacter(20)VARCHAR2(20) NOT NULLOptimization Problem Instance


RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
index back(c)David Kurtz 2019, 8.54
PTRef generated on 09-JUN-19