| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
ERN_SEQUENCE |
Number(3,0) |
SMALLINT NOT NULL |
Earnings Calculation Sequence
Default Value: 500
|
| 7 |
MAINTAIN_BALANCES |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintain Earnings Balances
Y/N Table Edit
Default Value: Y
|
| 8 |
BUDGET_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Effect
N=Nonproductive
O=Overtime
R=Regular
X=No Effect
Default Value: R
|
| 9 |
ALLOW_EMPLTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allowable Employee Types
A=All Types Allowable
H=Hourly and Exception Hourly
S=Salaried
Default Value: A
|
| 10 |
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
Default Value: E
|
| 11 |
HRLY_RT_MAXIMUM |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Maximum Hourly Rate
|
| 12 |
PERUNIT_OVR_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Unit/Override Rate
|
| 13 |
EARN_FLAT_AMT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Flat Amount
|
| 14 |
ADD_GROSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to Gross Pay
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 15 |
SUBJECT_FWT |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to FWT.
Y/N Table Edit
Default Value: Y
|
| 16 |
SUBJECT_FICA |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to FICA.
Y/N Table Edit
Default Value: Y
|
| 17 |
SUBJECT_FUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to FUT
Y/N Table Edit
Default Value: Y
|
| 18 |
SUBJECT_CIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to CIT indicator.
Y/N Table Edit
Default Value: Y
|
| 19 |
SUBJECT_CUI |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to EI earnings indicator.
Y/N Table Edit
Default Value: Y
|
| 20 |
SUBJECT_CUI_HOURS |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to EI hours indicator.
Y/N Table Edit
Default Value: Y
|
| 21 |
SUBJECT_CPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to CPP indicator.
Y/N Table Edit
Default Value: Y
|
| 22 |
SUBJECT_QIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to QIT indicator.
Y/N Table Edit
Default Value: Y
|
| 23 |
SUBJECT_QPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to QPP indicator.
Y/N Table Edit
Default Value: Y
|
| 24 |
SUBJECT_TRUE_T4GRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to true T4 indicator.
Y/N Table Edit
Default Value: Y
|
| 25 |
SUBJECT_TRUE_RVGRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to true RL indicator.
Y/N Table Edit
Default Value: Y
|
| 26 |
SUBJECT_PAY_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to Payroll Tax
Y/N Table Edit
Default Value: Y
|
| 27 |
SUBJECT_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to Regular Rate
Y/N Table Edit
Default Value: Y
|
| 28 |
WITHHOLD_FWT |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold FWT
Y/N Table Edit
Default Value: Y
|
| 29 |
HRS_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Only
Y/N Table Edit
Default Value: N
|
| 30 |
SHIFT_DIFF_ELIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Elig. for Shift Differential
Y/N Table Edit
Default Value: Y
|
| 31 |
TAX_GRS_COMPNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Taxable gross component ID.
Prompt Table:
TAXGR_CMPNT_VW
|
| 32 |
SPEC_CALC_RTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Calculation Routine
Y/N Table Edit
|
| 33 |
FACTOR_MULT |
Signed Number(11,4) |
DECIMAL(9,4) NOT NULL |
Multiplication Factor
|
| 34 |
FACTOR_RATE_ADJ |
Signed Number(11,4) |
DECIMAL(9,4) NOT NULL |
Rate Adjustment Factor
|
| 35 |
FACTOR_HRS_ADJ |
Signed Number(11,4) |
DECIMAL(9,4) NOT NULL |
Hours Adjustment Factor
|
| 36 |
FACTOR_ERN_ADJ |
Signed Number(11,4) |
DECIMAL(9,4) NOT NULL |
Earnings Adjustment Factor
|
| 37 |
GL_EXPENSE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-Expense
|
| 38 |
SUBTRACT_EARNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Subtract from this Draw
Y/N Table Edit
Default Value: N
|
| 39 |
DEDCD_PAYBACK |
Character(6) |
VARCHAR2(6) NOT NULL |
Payback Deduction Code
Prompt Table:
DED_TBL_GENL_VW
|
| 40 |
TAX_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax method.
A=Annualized
B=Bonus
C=Cumulative
G=Aggregate
L=Lump Sum
M=Commission
P=Specified on Paysheet
S=Supplemental
X=Special Supplemental
Default Value: P
|
| 41 |
EARN_YTD_MAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Maximum Yearly Earnings
|
| 42 |
BASED_ON_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Based on Type
A=Special Accumulator
N=Not Based On Another Earnings
S=Single Earnings
Default Value: N
|
| 43 |
BASED_ON_ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Based On Single Earnings Code
Prompt Table:
EARNINGS_TBL
|
| 44 |
BASED_ON_ACC_ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table:
SPCL_EARNS_TBL
|
| 45 |
AMT_OR_HOURS |
Character(1) |
VARCHAR2(1) NOT NULL |
Based On Amount or Hours
E=Amount
H=Hours
N=None
Default Value: N
|
| 46 |
PNA_USE_SGL_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field determines whether to accumulate earnings based on single empl record or multiple jobs.
Y/N Table Edit
Default Value: N
|
| 47 |
ELIG_FOR_RETROPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible for Retro Pay
Y/N Table Edit
Default Value: N
|
| 48 |
USED_TO_PAY_RETRO |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to Pay Retro
Y/N Table Edit
Default Value: N
|
| 49 |
EFFECT_ON_FLSA |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on FLSA
A=Amounts Only
B=Both Hours and Amount
H=Hours Only
N=None
Default Value: N
|
| 50 |
FLSA_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Category
O=Overtime
R=Regular
X=Excluded
Default Value: X
|
| 51 |
REG_PAY_INCLUDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular Pay Included?
Y/N Table Edit
Default Value: N
|
| 52 |
TIPS_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Tips Category
A=Tip Allocation
C=Tip Credit
G=Compulsory Gratuity
N=Not Tips
R=Reported Tips
S=Other Sys Calc'd Tips
T=Tippable
Default Value: N
|
| 53 |
ADD_DE |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to Garnishments
Y/N Table Edit
Default Value: Y
|
| 54 |
SUBJECT_T4A |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to T4A indicator.
Y/N Table Edit
Default Value: N
|
| 55 |
SUBJECT_RV2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to RL-2 indicator.
Y/N Table Edit
Default Value: N
|
| 56 |
GVT_BENEFITS_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to FEGLI Base Rate
Y/N Table Edit
Default Value: N
|
| 57 |
GVT_CPDF_ERNCD |
Character(1) |
VARCHAR2(1) NOT NULL |
CPDF Earnings Report Type
N=Not Reported
R=Retention Allowance
S=Supervisory Differential
T=Staffing Differential
|
| 58 |
GVT_OTH_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to Other Pay
Y/N Table Edit
Default Value: N
|
| 59 |
GVT_PAY_CAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to Pay Cap Calculations
Y/N Table Edit
Default Value: N
|
| 60 |
GVT_PREM_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to Premium Pay
Y/N Table Edit
Default Value: N
|
| 61 |
GVT_OT_PAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Overtime Indicator
Y/N Table Edit
Default Value: N
|
| 62 |
GVT_ADD_TO_SF50_52 |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to Other Pay on SF50/52
Y/N Table Edit
Default Value: Y
|
| 63 |
GVT_INCLUDE_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Locality Adjustment
Y/N Table Edit
Default Value: Y
|
| 64 |
GVT_IRR_REPORTABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
IRR Reporting Settings
Y/N Table Edit
Default Value: N
|
| 65 |
GVT_IRR_LWOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Without Pay
Y/N Table Edit
Default Value: N
|
| 66 |
GVT_SF113A_LUMPSUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to SF113A Lump Sum Pymnts
Y/N Table Edit
Default Value: N
|
| 67 |
GVT_SF113A_WAGES |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to SF113A Wages
Y/N Table Edit
Default Value: N
|
| 68 |
GVT_FEFFLA |
Character(1) |
VARCHAR2(1) NOT NULL |
FEFFLA Flag
N=FEFFLA Report
Y=FEFFLA Report
Y/N Table Edit
|
| 69 |
GVT_FMLA |
Character(1) |
VARCHAR2(1) NOT NULL |
FMLA Flag
N=FMLA Report
Y=FMLA Report
Y/N Table Edit
|
| 70 |
GVT_LV_EARN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Earnings Type
B=Donate To Bank
D=Receive From Donor
E=Donate To Emergency
R=Donate To Recipient
W=Receive From Bank
|
| 71 |
INCOME_CD_1042 |
Character(2) |
VARCHAR2(2) NOT NULL |
Income Code (for 1042-S)
12=Royalties
15=Scholarship/Fellowship Grants
16=Independent Personal Services
17=Dependent Personal Services
18=Teaching
19=Studying and Training
50=Other Income
Prompt Table:
INC_CD_1042_TBL
|
| 72 |
PERMANENCY_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Permanency is used for HR Netherlands to track for Earnings and Deductions which are incidental, permanent or both.
B=Both
I=Incidental
P=Permanent
Default Value: B
|
| 73 |
TAX_CLASS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Class is used for HR Netherlands to be tracked for Earnings and Deductions.
1=Wage Tax and Social Security
2=Wage Tax, No Social Security
3=No Wage Tax, Social Security
4=No Wage Tax,No Social Security
Default Value: 1
|
| 74 |
HRS_DIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Distribution
Y/N Table Edit
Default Value: N
|
| 75 |
HP_ADMINSTIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Administrative Stipend Flag
Y/N Table Edit
Default Value: N
|
| 76 |
SUBJECT_QPIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to EI earnings indicator.
Y/N Table Edit
Default Value: Y
|