BEN_BI_PAYMENT (SQL Table)	Index Back
Payments BEN_BI_PAYMENT holds non-accounting information about payments. This table has equivalent status with BEN_BI_CHARGE and BEN_BI_ADJSTMNT. These three tables together hold all the information on accounting entries and are joined through BEN_BI_DETAIL. BEN_BI_PAYMENT does not hold any payment accounting information. This information is held on BEN_BI_DETAIL. BEN_BI_PAY_VW totals the accounting information and ties it to the payment.

BEN_BI_PAYMENT

(SQL Table)

Payments

BEN_BI_PAYMENT holds non-accounting information about payments. This table has equivalent status with BEN_BI_CHARGE and BEN_BI_ADJSTMNT. These three tables together hold all the information on accounting entries and are joined through BEN_BI_DETAIL. BEN_BI_PAYMENT does not hold any payment accounting information. This information is held on BEN_BI_DETAIL. BEN_BI_PAY_VW totals the accounting information and ties it to the payment.

Parent record: BEN_BI_DETAIL

# 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

#	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