PSOPTSYNC (SQL Table)	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.

PSOPTSYNC

(SQL Table)

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 Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
Prompt Table: PSOPTPRBINST

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance Prompt Table: PSOPTPRBINST
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
3	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference