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 NameField TypeColumn TypeDescription
    PROBTYPECharacter(20)VARCHAR2(20) NOT NULLOptimization Problem Type (see PSOPTPRBTYPE).

    Prompt Table: PSOPTPRBTYPE

    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    SYNCORDERNumber(3,0)SMALLINT NOT NULLSynchronization Order for Records. Used in Optimization.
    READABLECharacter(1)VARCHAR2(1) NOT NULLThis 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

    READONCECharacter(1)VARCHAR2(1) NOT NULLThis 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

    WRITABLECharacter(1)VARCHAR2(1) NOT NULLThis field tells the optimization server if a particular application table is writable by the optimization server.

    Y/N Table Edit

    SCENMGMTCharacter(1)VARCHAR2(1) NOT NULLThis 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

    CALLBACKCharacter(1)VARCHAR2(1) NOT NULLThis 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.
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19