AP_STEPACT_SQL

(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 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 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

5 AP_SQLTYPE Character(1) VARCHAR2(1) NOT NULL SQL Type
L=Do-While
S=Stand Alone
U=Do-Until
W=Do-When

#	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	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
5	AP_SQLTYPE	Character(1)	VARCHAR2(1) NOT NULL	SQL Type L=Do-While S=Stand Alone U=Do-Until W=Do-When