STEP_NAMEJOB_TYPEI=Informational
P=Process
W=Workflow
Prompt Table: PRCSTYPE_VW
Prompt Table: PRCSDEFN
Y/N Table Edit
Default Value: N
Prompt Table: BUSPROCNAME_VW
Prompt Table: PSACTIVITYDEFN
Prompt Table: PSEVENTDEFN
PYCYCL_STEP_DFN(SQL Table) |
Index Back |
|---|---|
Pay Cycle Step Definitions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STEP_NAME |
Character(40) | VARCHAR2(40) NOT NULL | Step Name |
| 2 | STEP_NAME_DSCR | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 3 | JOB_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Job Type
I=Informational P=Process W=Workflow |
| 4 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PRCSTYPE_VW |
| 5 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL |
Process Name
Prompt Table: PRCSDEFN |
| 6 | MULTIPLE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Multiple Values per Attr
Y/N Table Edit Default Value: N |
| 7 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: BUSPROCNAME_VW |
| 8 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: PSACTIVITYDEFN |
| 9 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table: PSEVENTDEFN |
| 10 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 11 | MESSAGE_CD | Character(6) | VARCHAR2(6) NOT NULL | Message Code |