PYCYCL_STEP_VW1

(SQL View)
 Index Back

Pay Cycle Step Definitions


select step_name, job_type, prcstype, prcsname, multiple_flg, busprocname, activityname, eventname, message_set_nbr, message_cd from PS_PYCYCL_STEP_DFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STEP_NAME Character(40) VARCHAR2(40) NOT NULL Step Name
2 JOB_TYPE Character(1) VARCHAR2(1) NOT NULL Job Type
I=Informational
P=Process
W=Workflow
3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
5 MULTIPLE_FLG Character(1) VARCHAR2(1) NOT NULL Allow Multiple Values per Attr
6 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
7 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
8 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10 MESSAGE_CD Character(6) VARCHAR2(6) NOT NULL Message Code