PYCYCL_STEP_VW

(SQL View)
 Index Back

Pay Cycle Steps


select step_tbl_name, pay_run_ap_status, step_name, run_level, pymnt_doc_type, save_oprid, runcntlid from PS_PYCYCL_STEP_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 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
3 STEP_NAME Character(40) VARCHAR2(40) NOT NULL Step Name

Prompt Table: PYCYCL_STEP_VW1

4 RUN_LEVEL Character(1) VARCHAR2(1) NOT NULL Run Level
B=Bank Account
P=Pay Cycle
5 PYMNT_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Document Type
A=Check Advice
C=Check
D=Draft
E=EFT
F=EFT Advice
G=Giro EFT
H=ACH
K=Giro EFT Advice
L=LC Advice
M=Draft EFT Advice
N=Draft EFT
P=Check Copy
R=ACH Advice
T=Draft Advice
W=Wire Advice
X=All
Y=Financial Gateway payment
Z=Email Payment Advice
6 SAVE_OPRID Character(8) VARCHAR2(8) NOT NULL Operator
7 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID