PROCESS_INSTANCEEARNS_TYPE1=Regular Hourly
2=Regular Salary
3=Overtime
4=Other Earns
5=Other Hours
ERNCDEARNS_BEGIN_DTEARNS_END_DTCOMP_RATECDHOURLY_RTPY_EARNS_WRK(SQL Table) |
Index Back |
|---|---|
Paycheck EarningsRecord created to support Paycheck Review.It contains the Earning details for a check. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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 |
| 3 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 4 | EARNS_BEGIN_DT |
Date(10) | DATE | Earnings Begin Date |
| 5 | EARNS_END_DT |
Date(10) | DATE | Earnings End Date |
| 6 | COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 7 | HOURLY_RT |
Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | EARNS_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Earnings Hours |
| 10 | EARNS_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Earnings Amount |
| 11 | HRS_YTD | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Hours YTD |
| 12 | GRS_YTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Gross Earnings YTD |
| 13 | PY_NY_IND | Character(1) | VARCHAR2(1) NOT NULL | This field is used to store the indicator on whether the earnings has NY derived rate or not |
| 14 | PY_NY_DERIVED_RATE | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | This field stores the NY derived rate |