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 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19