ERNCDC=Change
D=Delete
I=Initial Load
N=New
A=Amounts Only
B=Both Hours and Amount OK
E=Either Hours or Amount OK
F=Flat Amount
H=Hours Only
S=Defined by Salary System
U=Unit/Override Rate
PY_MOD_ECHNG_VW(SQL View) |
Index Back |
|---|---|
Payroll Earnings ChangesPaycheck Modeling other earnings changes vw |
| SELECT ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 2 | PY_MOD_DESCR_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Earnings Type |
| 3 | CHANGE_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Whether this record represents an New, Change, Delete or initial load. Used in discounts and perks eligibility file.
C=Change D=Delete I=Initial Load N=New |
| 4 | COMPRATE_USED | Number(19,6) | DECIMAL(18,6) NOT NULL | Comp Rate Used |
| 5 | OTH_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Other hours. |
| 6 | OTH_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Earnings |
| 7 | COMPRATE_USED_REG | Number(19,6) | DECIMAL(18,6) NOT NULL | Comp Rate Used for Regular |
| 8 | HRS_ADJ | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Hours Adjustment |
| 9 | EARNS_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Earnings Amount |
| 10 | PY_MOD_EARNSCE_TYP | Character(2) | VARCHAR2(2) NOT NULL | Paycheck Modeling Earning Source Type: RE - Regular OT - Overtime OE - Others |
| 11 | PAYMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
A=Amounts Only B=Both Hours and Amount OK E=Either Hours or Amount OK F=Flat Amount H=Hours Only S=Defined by Salary System U=Unit/Override Rate |