AP_STEP_ACTION

(SQL Table)

# 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 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
Prompt Table: SQLID_VW

#	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	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition) Prompt Table: SQLID_VW