PSOPTPRED

(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_PRED_ID Character(30) VARCHAR2(30) NOT NULL Optimization Predicate ID
3 PAMS_PRED_TYPE Character(30) VARCHAR2(30) NOT NULL Optimization Predicate Type
4 PAMS_OBJ1_ID Character(30) VARCHAR2(30) NOT NULL Optimization Object 1 ID
5 PAMS_OBJ2_ID Character(30) VARCHAR2(30) NOT NULL Optimization Object 2 ID
6 PAMS_VAL Signed Number(26,8) DECIMAL(24,8) NOT NULL Optimization PAMS Value
7 PAMS_COMPARISON Character(30) VARCHAR2(30) NOT NULL Opt. PAMS Comparison Operator