PYCYCL_RPT_VW (SQL View)	Index Back
Output Info - Current Payrun

PYCYCL_RPT_VW

(SQL View)

Output Info - Current Payrun

select a.pay_cycle ,a.pay_cycle_seq_num ,a.bank_setid ,a.bank_cd ,a.bank_acct_key ,a.pymnt_method ,a.pymnt_filename ,a.form_type ,a.print_switch ,a.first_pymnt_ref_id ,a.pay_run_ap_status from PS_PYCYCL_STATRPT a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

3 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

5 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

6 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

7 PYMNT_FILENAME Character(18) VARCHAR2(18) NOT NULL Report ID

8 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
ADV=Remittance Advice Only
CAV=Check with Separate Advice
CRA=Crystal Check w/Advice
CRW=Crystal Check
CSA=Check over Stub with Advice
CSO=Check over Stub with Overflow
EFA=EFT File with Advice
EFT=EFT File
SCA=Stub over Check with Advice
SCO=Stub over Check with Overflow

9 PRINT_SWITCH Character(1) VARCHAR2(1) NOT NULL Print Switch
Y/N Table Edit
Default Value: N

10 FIRST_PYMNT_REF_ID Character(12) VARCHAR2(12) NOT NULL First Payment

11 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
2	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
3	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
4	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
5	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
6	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
7	PYMNT_FILENAME	Character(18)	VARCHAR2(18) NOT NULL	Report ID
8	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow
9	PRINT_SWITCH	Character(1)	VARCHAR2(1) NOT NULL	Print Switch Y/N Table Edit Default Value: N
10	FIRST_PYMNT_REF_ID	Character(12)	VARCHAR2(12) NOT NULL	First Payment
11	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