PSOPTPARARRAY

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAMS_MODEL_NAME Character(30) VARCHAR2(30) NOT NULL Optimizaiton Model Name (see PSOPTMODEL).
2 PAMS_PARARRAY_NAME Character(30) VARCHAR2(30) NOT NULL Optimization Parameter Array
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 PAMS_NUM_DIM Number(1,0) SMALLINT NOT NULL Number of Dimension
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 PAMS_PARADEF Character(30) VARCHAR2(30) NOT NULL Parameter Default Behavior
8 PAMS_VAL Signed Number(26,8) DECIMAL(24,8) NOT NULL Optimization PAMS Value