TRANSIT_NUMACCOUNT_NUMFORM_IDPAYCHECK_NBRCHECK_DTB=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
PAY_CHECK_DUE(SQL Table) |
Index Back |
|---|---|
Payment RecordThis table contains bank deposit advice information for employee paychecks. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSIT_NUM |
Character(9) | VARCHAR2(9) NOT NULL | Bank Transit # |
| 2 | ACCOUNT_NUM |
Character(17) | VARCHAR2(17) NOT NULL | Account Number |
| 3 | FORM_ID |
Character(6) | VARCHAR2(6) NOT NULL | Form Identification |
| 4 | PAYCHECK_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 5 | CHECK_DT |
Date(10) | DATE NOT NULL | Check date. |
| 6 | NET_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Net Pay |
| 7 | 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 |