SEQNOPAY_WEB_CODE1=Regular Hourly
2=Regular Salary
3=Overtime
4=Other Earns
5=Other Hours
PY_IC_PC_ER2_FL(SQL Table) |
Index Back |
|---|---|
Additional Earnings PageMobile Paycheck: Record created to support Mobile Paycheck .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 'Additional Earnings section of the. |
| # | 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(15,2) | DECIMAL(13,2) NOT NULL | YTD Amount |
| 8 | PAY_WEB_YTD_HRS | Signed Number(10,2) | DECIMAL(8,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 |
| 13 | PAY_FLSA_RULE | Character(35) | VARCHAR2(35) NOT NULL | State OT Rate Rule |
| 14 | PAY_FLSA_OT_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | FLSA Overtime Rate |
| 15 | PAY_FLSA_DEOT_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Derived OT Rate |