PSOPTSETDIM

(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_INDEXSET_NAME Character(30) VARCHAR2(30) NOT NULL Optimization Index Set Name
3 PAMS_DIM Number(1,0) SMALLINT NOT NULL Optimization PAMS Dimension
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
6 PAMS_OBJ_ID Character(30) VARCHAR2(30) NOT NULL Optimization Object ID