PSOPTREC - Optmz. Application Records - PeopleTools Table Reference

PSOPTREC	index back
Optmz. Application Records

This table stores information on what application records are used by the optimization application represented by the problem type.

Related language record: PSOPTRECLNG

PeopleSoft Field Name Field Type Column Type Description

PROBTYPE Character(20) VARCHAR2(20) NOT NULL Optimization Problem Type (see PSOPTPRBTYPE).
Prompt Table: PSOPTPRBTYPE

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

SYNCORDER Number(3,0) SMALLINT NOT NULL Synchronization Order for Records. Used in Optimization.

READABLE Character(1) VARCHAR2(1) NOT NULL This field tells the optimization server if a particular application table should be read into memory. The Optimization server synchronizes any changes that are made to the application table by other processes.
Y/N Table Edit

READONCE Character(1) VARCHAR2(1) NOT NULL This field tells the optimization server if a particular application table after being read into memory does not need to be refreshed afterwards to get the changes.
Y/N Table Edit

WRITABLE Character(1) VARCHAR2(1) NOT NULL This field tells the optimization server if a particular application table is writable by the optimization server.
Y/N Table Edit

SCENMGMT Character(1) VARCHAR2(1) NOT NULL This field tells the optimization server if a particular application table is scenario managed meaning, if this table holds data belonging to multiple problem instances and whether scenario management algorithm should be applied to merge data from different problem instances into the special System problem instance.
Y/N Table Edit

CALLBACK Character(1) VARCHAR2(1) NOT NULL This field tells the optimization server if a particular application table should be read into memory. The Optimization server synchronizes any changes that are made to the application table by other processes.

DESCRLONG Long Character CLOB Long Description

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
PROBTYPE	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Type (see PSOPTPRBTYPE). Prompt Table: PSOPTPRBTYPE
RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
SYNCORDER	Number(3,0)	SMALLINT NOT NULL	Synchronization Order for Records. Used in Optimization.
READABLE	Character(1)	VARCHAR2(1) NOT NULL	This field tells the optimization server if a particular application table should be read into memory. The Optimization server synchronizes any changes that are made to the application table by other processes. Y/N Table Edit
READONCE	Character(1)	VARCHAR2(1) NOT NULL	This field tells the optimization server if a particular application table after being read into memory does not need to be refreshed afterwards to get the changes. Y/N Table Edit
WRITABLE	Character(1)	VARCHAR2(1) NOT NULL	This field tells the optimization server if a particular application table is writable by the optimization server. Y/N Table Edit
SCENMGMT	Character(1)	VARCHAR2(1) NOT NULL	This field tells the optimization server if a particular application table is scenario managed meaning, if this table holds data belonging to multiple problem instances and whether scenario management algorithm should be applied to merge data from different problem instances into the special System problem instance. Y/N Table Edit
CALLBACK	Character(1)	VARCHAR2(1) NOT NULL	This field tells the optimization server if a particular application table should be read into memory. The Optimization server synchronizes any changes that are made to the application table by other processes.
DESCRLONG	Long Character	CLOB	Long Description