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.

  • 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