PSOPTFIELD

(SQL Table)
 Index Back

Optmz. Application Rec. Fields

This table stores which fields in the application records defined in OPTRECS table are used by the optimization server. Only these fields are either read or written to by the optimization server.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBTYPE Character(20) VARCHAR2(20) NOT NULL Optimization Problem Type (see PSOPTPRBTYPE).
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECFIELD

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSRECFIELD