EMPLIDPrompt Table: PERS_SRCH_GBL
POSTING_DATEPOSTING_SEQUENCEPrompt Table: BEN_BI_CALENDAR
A=Automated
M=Manual
CHK=Check
CSH=Cash
INT=Interface
BEN_BI_PYS_VW(SQL View) |
Index Back |
|---|---|
Pmnt Summary by Posting DateBEN_BI_PYS_VW is a view of payments. It is used on the Payments by Posting Date summary panel. |
| 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 |
| 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 |
| 7 | PAYMENT_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Payment Source
A=Automated M=Manual |
| 8 | PAYMENT_FORM | Character(3) | VARCHAR2(3) NOT NULL |
Form of Payment
CHK=Check CSH=Cash INT=Interface |
| 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 |