PSOPTREC (SQL Table)	Index Back
Optmz. Application Records This table stores information on what application records are used by the optimization application represented by the problem type.

PSOPTREC

(SQL Table)

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

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

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

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

4 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

5 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

6 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

7 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

8 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.

9 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBTYPE	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Type (see PSOPTPRBTYPE). Prompt Table: PSOPTPRBTYPE
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
3	SYNCORDER	Number(3,0)	SMALLINT NOT NULL	Synchronization Order for Records. Used in Optimization.
4	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
5	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
6	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
7	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
8	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.
9	DESCRLONG	Long Character	CLOB	Long Description