AP_STEP_SQLPARM

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STEP_NAME Character(40) VARCHAR2(40) NOT NULL Step Name
2 ALGTHM_BEHAVIOR Character(4) VARCHAR2(4) NOT NULL Rule
CAIF=Select All
EQSM=Equal Sum
EXCT=Equal
MTVQ=Sum Up To
SLON=Select If One
USER=User Criteria
3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN_VW3

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

Prompt Table: PSRECFIELD_VW