EX_EE_S_PYMT_VW

(SQL View)
 Index Back

Expense Sheet Employee Pymt Vw

Returns a row for each sheet that has an employee payment associated with it.

SELECT DISTINCT A.SHEET_ID , B.BANK_SETID , B.BANK_CD , B.BANK_ACCT_KEY , B.PYMNT_ID , C.PYMNT_ID_REF , C.PYMNT_STATUS FROM PS_EX_SHEET_HDR A , PS_EX_SHEET_PYMNT B , PS_PAYMENT_TBL C WHERE A.SHEET_ID = B.SHEET_ID AND B.EX_PYMNT_TYPE = 'E' AND B.SEQ_NBR = ( SELECT MAX(X.SEQ_NBR) FROM PS_EX_SHEET_PYMNT X WHERE X.SHEET_ID = A.SHEET_ID AND X.EX_PYMNT_TYPE = 'E') AND C.BANK_SETID = B.BANK_SETID AND C.BANK_CD = B.BANK_CD AND C.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND C.PYMNT_ID = B.PYMNT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
4 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
5 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
6 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
7 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted