Tables populated after running PSPPYBLD

--running the PSPPYBLD process - Create Paysheet


SELECT * FROM PS_PAY_CAL_BAL_ID WHERE PAY_END_DT='30-JUN-2011';
SELECT * FROM PS_PAY_CTX_OVRD -- CAN payroll
SELECT * FROM PS_PAY_EARNINGS WHERE PAY_END_DT='30-APR-2011' ;
SELECT * FROM PS_PAY_DEDUCTION WHERE PAY_END_DT='31-JaN-2011';
SELECT * FROM PS_PAY_PAGE WHERE PAY_END_DT='30-JUN-2011';
SELECT * FROM PS_PAY_LINE WHERE PAY_END_DT='31-JaN-2011';
SELECT * FROM PS_PAY_OTH_EARNS WHERE PAY_END_DT='30-JUN-2011';
SELECT * FROM PS_PAY_ONE_TIME WHERE PAY_END_DT='30-JUN-2011';
SELECT * FROM PS_PAY_GARN_OVRD;
SELECT * FROM PS_PAY_TAX_OVRD;

--error/ info messages
SELECT * FROM PS_CALC_MESSAGE
SELECT * FROM PS_COBRA_MESSAGE
SELECT * FROM PS_BAS_MESSAGE;
SELECT * FROM PS_BEN_BI_MESSAGE;
SELECT * FROM PS_DED_MESSAGE WHERE EMPLID='AV19'; -- no rows
SELECT * FROM PS_PAY_MESSAGE;
SELECT * FROM PS_PI_MESSAGE; -- Payroll Interface
SELECT * FROM PS_RETRODED_MSG;
SELECT * FROM PS_RETROPAY_MSG;

--Time and Labor tables
SELECT * FROM PS_PY_LDTLEMP_RC;
SELECT * FROM PS_PY_LDTLEMP_TBL;
SELECT * FROM PS_PY_LDTLEMP_WRK1;
SELECT * FROM PS_PY_LDTLEMP_WRK2;
SELECT * FROM PS_PY_LDTLPMSG_TBL;
SELECT * FROM PS_PY_LDTL_RC;
SELECT * FROM PS_PY_LDTL_TBL;
SELECT * FROM PS_PY_LDTL_WRK;
SELECT * FROM PS_PY_PYBL_TM_WRK;
SELECT * FROM PS_PY_XREF_WRK --Work Record for T&L Update