Earnings Table

 Set Up HCM > Product Related  >Payroll for North America > Compensation and Earnings > Earnings Table

select ERNCD, to_char(effdt,'yyyy-mm-dd') as effdt, EFF_STATUS, DESCR, DESCRSHORT, ERN_SEQUENCE, MAINTAIN_BALANCES, BUDGET_EFFECT, ALLOW_EMPLTYPE, PAYMENT_TYPE, HRLY_RT_MAXIMUM, PERUNIT_OVR_RT, EARN_FLAT_AMT, ADD_GROSS, SUBJECT_FWT, SUBJECT_FICA, SUBJECT_FUT, SUBJECT_CIT, SUBJECT_CUI, SUBJECT_CUI_HOURS, SUBJECT_CPP, SUBJECT_QIT, SUBJECT_QPP, SUBJECT_TRUE_T4GRS, SUBJECT_TRUE_RVGRS, SUBJECT_PAY_TAX, SUBJECT_REG, WITHHOLD_FWT, HRS_ONLY, SHIFT_DIFF_ELIG, TAX_GRS_COMPNT, SPEC_CALC_RTN, FACTOR_MULT, FACTOR_RATE_ADJ, FACTOR_HRS_ADJ, FACTOR_ERN_ADJ, GL_EXPENSE, SUBTRACT_EARNS, DEDCD_PAYBACK, TAX_METHOD, EARN_YTD_MAX, BASED_ON_TYPE, BASED_ON_ERNCD, BASED_ON_ACC_ERNCD, AMT_OR_HOURS, PNA_USE_SGL_EMPL, ELIG_FOR_RETROPAY, USED_TO_PAY_RETRO, EFFECT_ON_FLSA, FLSA_CATEGORY, REG_PAY_INCLUDED, TIPS_CATEGORY, ADD_DE, SUBJECT_T4A, SUBJECT_RV2, GVT_BENEFITS_RATE, GVT_CPDF_ERNCD, GVT_OTH_PAY, GVT_PAY_CAP, GVT_PREM_PAY, GVT_OT_PAY_IND, GVT_ADD_TO_SF50_52, GVT_INCLUDE_LOC, GVT_IRR_REPORTABLE, GVT_IRR_LWOP, GVT_SF113A_LUMPSUM, GVT_SF113A_WAGES, GVT_FEFFLA, GVT_FMLA, GVT_LV_EARN_TYPE, INCOME_CD_1042, PERMANENCY_NLD, TAX_CLASS_NLD, HRS_DIST_SW, HP_ADMINSTIP_FLAG, SUBJECT_QPIP

from ps_EARNINGS_TBL 

where erncd like 'MP%';