SEQNOPAY_WEB_CODE1=Regular Hourly
2=Regular Salary
3=Overtime
4=Other Earns
5=Other Hours
PY_IC_PI_ERN_MX(SQL Table) |
Index Back |
|---|---|
WEB-PayChk Rvw EarningsRecord created to support WEB-enabled Paycheck Review.It contains the Earning details for a check. The structure has been designed so that the panel created using this record will look like the 'Earnings' section of the 'paystub' created using the 'check SQRs'. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 2 | PAY_WEB_CODE |
Character(17) | VARCHAR2(17) NOT NULL | Code created for Payroll WEB |
| 3 | PAY_WEB_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Description |
| 4 | PAY_WEB_AMT | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Current Amount |
| 5 | PAY_WEB_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 6 | PAY_WEB_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Current Hours |
| 7 | PAY_WEB_YTD_AMT | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | YTD Amount |
| 8 | PAY_WEB_YTD_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | YTD Hours |
| 9 | PAY_WEB_COMPRATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 10 | EARNS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Earning
1=Regular Hourly 2=Regular Salary 3=Overtime 4=Other Earns 5=Other Hours |
| 11 | EARNS_BEGIN_DT | Date(10) | DATE | Earnings Begin Date |
| 12 | EARNS_END_DT | Date(10) | DATE | Earnings End Date |