PYCYCL_STEP_TMP (SQL Table)	Index Back
Pay Cycle Steps tmp tbl

PYCYCL_STEP_TMP

(SQL Table)

Pay Cycle Steps tmp tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STEP_TBL_NAME Character(15) VARCHAR2(15) NOT NULL Step Group Name

2 STEP_NAME Character(40) VARCHAR2(40) NOT NULL Step Name
Prompt Table: PYCYCL_STEP_VW1

3 PAY_RUN_AP_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Run Status
1=Exceptions found
2=Nothing to process
3=Process running
6=Rejected
7=Selected/Staged
8=Waiting for Certification
C=Completed
D=Reset
E=Error
K=Restarted
N=New
R=Selected
U=Created
V=Trial Register Approved
X=Printed
Y=Confirmed
Z=Positive Payment Formatted

4 RUN_LEVEL Character(1) VARCHAR2(1) NOT NULL Run Level
B=Bank Account
P=Pay Cycle

5 PYMNT_TYPE Character(1) VARCHAR2(1) NOT NULL Document Type
E=Express Payment
M=Manual Payment
R=Regular payment
W=Withholding Payment
Z=Zero Payment Check

6 SAVE_OPRID Character(8) VARCHAR2(8) NOT NULL Operator

7 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Prompt Table: PRCSRUNCNTL_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STEP_TBL_NAME	Character(15)	VARCHAR2(15) NOT NULL	Step Group Name
2	STEP_NAME	Character(40)	VARCHAR2(40) NOT NULL	Step Name Prompt Table: PYCYCL_STEP_VW1
3	PAY_RUN_AP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Run Status 1=Exceptions found 2=Nothing to process 3=Process running 6=Rejected 7=Selected/Staged 8=Waiting for Certification C=Completed D=Reset E=Error K=Restarted N=New R=Selected U=Created V=Trial Register Approved X=Printed Y=Confirmed Z=Positive Payment Formatted
4	RUN_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Run Level B=Bank Account P=Pay Cycle
5	PYMNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Document Type E=Express Payment M=Manual Payment R=Regular payment W=Withholding Payment Z=Zero Payment Check
6	SAVE_OPRID	Character(8)	VARCHAR2(8) NOT NULL	Operator
7	RUNCNTLID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Prompt Table: PRCSRUNCNTL_VW