PY_PAYCHECK_DUE (SQL Table)	Index Back
Payment Record (New) This table contains bank deposit advice information for employee paychecks.

PY_PAYCHECK_DUE

(SQL Table)

Payment Record (New)

This table contains bank deposit advice information for employee paychecks.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PY_BNKACCT_ID Character(7) VARCHAR2(7) NOT NULL Identification Number to identify transit number and account number

2 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

3 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.

4 CHECK_DT Date(10) DATE NOT NULL Check date.

5 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay

6 PAY_SHEET_SRC Character(1) VARCHAR2(1) NOT NULL Source of Paysheet
B=Flat Sum Bonus Calculation
F=FLSA Paysheet
K=Batch Final Check
L=Online Final Check
O=On-line Paysheet
P=Paysheet Load
S=Regular Paysheet
Default Value: S

7 PY_CHK_MATCHED Character(1) VARCHAR2(1) NOT NULL Pay Check number and details cross checked between the system and bank file.
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PY_BNKACCT_ID	Character(7)	VARCHAR2(7) NOT NULL	Identification Number to identify transit number and account number
2	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
3	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
4	CHECK_DT	Date(10)	DATE NOT NULL	Check date.
5	NET_PAY	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Net Pay
6	PAY_SHEET_SRC	Character(1)	VARCHAR2(1) NOT NULL	Source of Paysheet B=Flat Sum Bonus Calculation F=FLSA Paysheet K=Batch Final Check L=Online Final Check O=On-line Paysheet P=Paysheet Load S=Regular Paysheet Default Value: S
7	PY_CHK_MATCHED	Character(1)	VARCHAR2(1) NOT NULL	Pay Check number and details cross checked between the system and bank file. Y/N Table Edit Default Value: N