PYCYCL_STEP_TBL(SQL Table) |
Index Back |
---|---|
Pay Cycle Steps |
# | 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_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
Prompt Table: PRCSRUNCNTL |