BEN_BI_PAY_VW (SQL View)	Index Back
Payments with Accounting BEN_BI_PAY_VW ties the payment accounting information on BEN_BI_DETAIL to the other payment information on BEN_BI_PAYMENT. This view eliminates the need for accounting fields on BEN_BI_PAYMENT that must be updated and kept in balance with the detail. This record is the best source of total information about payments and in most cases should be used in place of BEN_BI_PAYMENT.

BEN_BI_PAY_VW

(SQL View)

Payments with Accounting

BEN_BI_PAY_VW ties the payment accounting information on BEN_BI_DETAIL to the other payment information on BEN_BI_PAYMENT. This view eliminates the need for accounting fields on BEN_BI_PAYMENT that must be updated and kept in balance with the detail. This record is the best source of total information about payments and in most cases should be used in place of BEN_BI_PAYMENT.

SELECT A.EMPLID ,A.POSTING_DATE ,A.POSTING_SEQUENCE ,A.BILL_PAY_ID ,MIN(A.PRINT_PERIOD) ,MIN(A.PAYMENT_ENTRY_DT) ,MIN(A.PAYMENT_SOURCE) ,MIN(A.PAYMENT_FORM) ,SUM(D.PAY_AMT) ,SUM(D.PMT_ADJUST) ,SUM(D.PAY_AMT + D.PMT_ADJUST) FROM PS_BEN_BI_PAYMENT A ,PS_BEN_BI_DETAIL D WHERE A.EMPLID = D.EMPLID AND A.BILL_PAY_ID = D.BILL_PAY_ID GROUP BY A.EMPLID ,A.BILL_PAY_ID ,A.POSTING_DATE ,A.POSTING_SEQUENCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

2 POSTING_DATE Date(10) DATE NOT NULL Posting Date
Default Value: %date

3 POSTING_SEQUENCE Number(2,0) SMALLINT NOT NULL Posting Sequence

4 BILL_PAY_ID Number(7,0) INTEGER NOT NULL Payment ID

5 PRINT_PERIOD Character(4) VARCHAR2(4) NOT NULL Print Period
Prompt Table: BEN_BI_CALENDAR

6 PAYMENT_ENTRY_DT Date(10) DATE Payment Entry Date
Default Value: %date

7 PAYMENT_SOURCE Character(1) VARCHAR2(1) NOT NULL Payment Source
A=Automated
M=Manual
Default Value: M

8 PAYMENT_FORM Character(3) VARCHAR2(3) NOT NULL Form of Payment
CHK=Check
CSH=Cash
INT=Interface
Default Value: CHK

9 AMOUNT_PAID Signed Number(9,2) DECIMAL(7,2) NOT NULL Total Payments For Charge

10 PMT_ADJUST Signed Number(9,2) DECIMAL(7,2) NOT NULL Payment Adjustments

11 ACTUAL_PAYMENT Signed Number(9,2) DECIMAL(7,2) NOT NULL Actual Payment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	POSTING_DATE	Date(10)	DATE NOT NULL	Posting Date Default Value: %date
3	POSTING_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Posting Sequence
4	BILL_PAY_ID	Number(7,0)	INTEGER NOT NULL	Payment ID
5	PRINT_PERIOD	Character(4)	VARCHAR2(4) NOT NULL	Print Period Prompt Table: BEN_BI_CALENDAR
6	PAYMENT_ENTRY_DT	Date(10)	DATE	Payment Entry Date Default Value: %date
7	PAYMENT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Payment Source A=Automated M=Manual Default Value: M
8	PAYMENT_FORM	Character(3)	VARCHAR2(3) NOT NULL	Form of Payment CHK=Check CSH=Cash INT=Interface Default Value: CHK
9	AMOUNT_PAID	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Total Payments For Charge
10	PMT_ADJUST	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Payment Adjustments
11	ACTUAL_PAYMENT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Actual Payment