PY_BNKACCT_IDTRANSIT_NUMACCOUNT_NUMSORT_FLDPAYCHECK_NBRFORM_IDCHECK_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
R_PAY015(SQL Table) |
Index Back |
|---|---|
Temp Table - SQR PAY015This temporary table contains data used when running SQR PAY015. |
| # | 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 | TRANSIT_NUM |
Character(9) | VARCHAR2(9) NOT NULL | Bank Transit # |
| 3 | ACCOUNT_NUM |
Character(17) | VARCHAR2(17) NOT NULL | Account Number |
| 4 | SORT_FLD |
Character(1) | VARCHAR2(1) NOT NULL | Sort Field |
| 5 | PAYCHECK_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 6 | FORM_ID |
Character(6) | VARCHAR2(6) NOT NULL | Form Identification |
| 7 | CHECK_DT |
Date(10) | DATE | Check date. |
| 8 | NET_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Net Pay |
| 9 | 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 |