PMT_BTCHNAME_VW (SQL View)	Index Back
Payment Batch VW Payment Batch VW

PMT_BTCHNAME_VW

(SQL View)

Payment Batch VW

SELECT DISTINCT A.BATCH_NAME ,A.PMT_SOURCE ,A.BUSINESS_UNIT ,A.PMT_STATUS ,A.PMT_TYPE ,%Substring(B.XLATLONGNAME, 1, 30) FROM PS_PMT_DETAIL_TBL A , PSXLATITEM B WHERE A.BATCH_NAME <> ' ' AND B.EFF_STATUS = 'A' AND B.FIELDNAME = 'PMT_TYPE' AND A.PMT_TYPE = B.FIELDVALUE AND B.EFFDT =( SELECT MAX(Z.EFFDT) FROM PSXLATITEM Z WHERE B.FIELDNAME = Z.FIELDNAME AND B.FIELDVALUE = Z.FIELDVALUE AND Z.EFF_STATUS = 'A' AND Z.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BATCH_NAME Character(30) VARCHAR2(30) NOT NULL Batch Name

2 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name
Prompt Table: PMT_SRC_DEFN

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_FS_NONVW

4 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process

5 PMT_TYPE Character(4) VARCHAR2(4) NOT NULL Payment type
BAX=Bank Transfer
BON=Bonus
COLL=Collection
DEAL=Deal Cash Flow
EFTR=EFT Request
EXAD=Exp Advance
EXPN=Expense Sheet
FEE=Fee
GR=General Recipient Deduction
IR=Individual Recipient Deduction
NP=Net Pay Distribution
OTHR=Other
SAL=Salary
VCHR=Voucher

6 PMT_TYPE_NAME Character(30) VARCHAR2(30) NOT NULL Payment Type

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BATCH_NAME	Character(30)	VARCHAR2(30) NOT NULL	Batch Name
2	PMT_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Source System Name Prompt Table: PMT_SRC_DEFN
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_FS_NONVW
4	PMT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payment status C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process
5	PMT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Payment type BAX=Bank Transfer BON=Bonus COLL=Collection DEAL=Deal Cash Flow EFTR=EFT Request EXAD=Exp Advance EXPN=Expense Sheet FEE=Fee GR=General Recipient Deduction IR=Individual Recipient Deduction NP=Net Pay Distribution OTHR=Other SAL=Salary VCHR=Voucher
6	PMT_TYPE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Payment Type