Create Additional Pay

/c/MAINTAIN_PAYROLL_DATA_US.ADDITIONAL_PAY.USA

 Payroll for North America > Employee Pay Data USA > Create Additional Pay

Level 0

select EMPLID, EMPL_RCD, ERNCD, RECORD_SOURCE 

from ps_ADDL_PAY_ERNCD  

where erncd like 'M%';

Level 1

select EMPLID, EMPL_RCD, ERNCD, to_char(effdt,'yyyy-mm-dd') as effdt, RECORD_SOURCE 

from ps_ADDL_PAY_EFFDT  

where erncd like 'M%';

Level 2

select EMPLID, EMPL_RCD, ERNCD, to_char(effdt,'yyyy-mm-dd') as effdt, ADDL_SEQ, DEPTID, JOBCODE, POSITION_NBR, ACCT_CD, GL_PAY_TYPE, ADDL_PAY_SHIFT, OTH_HRS, HOURLY_RT, OTH_PAY, ADDLPAY_REASON, SEPCHK, EARNINGS_END_DT, GOAL_AMT, GOAL_BAL, OK_TO_PAY, DISABLE_DIR_DEP, PRORATE_ADDL_PAY, PRORATE_CUI_WEEKS, PAY_PERIOD1, PAY_PERIOD2, PAY_PERIOD3, PAY_PERIOD4, PAY_PERIOD5, STATE, LOCALITY, TAX_PERIODS, TAX_METHOD, ADDL_PAY_FREQUENCY, DED_TAKEN, DED_SUBSET_ID, DED_TAKEN_GENL, DED_SUBSET_GENL, PLAN_TYPE, BUSINESS_UNIT, COMP_RATECD, RECORD_SOURCE 

from PS_ADDL_PAY_DATA 

where erncd like 'M%';