PSOPTTRN

(SQL Table)
Index Back

Optimization Transactions

This table consists of all the transactions and their attributes supported by a problem type and optimization solver plug-in.

  • Related Language Record: PSOPTTRNLNG
  • # 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 TRANNAME Character(30) VARCHAR2(30) NOT NULL Transaction Name
    3 LOCKALLFLAG Character(1) VARCHAR2(1) NOT NULL Lock Entire Transaction?

    Y/N Table Edit

    Default Value: N

    4 DESCRLONG Long Character CLOB Long Description