Tables populated after running PSPPYRUN - NA payroll calculation cobol process

--CAN payroll tables

SELECT * FROM PS_CAN_CHECK_YTD;

SELECT * FROM PS_CAN_DED_BALANCE;
SELECT * FROM PS_CAN_ERN_BALANCE;

SELECT * FROM PS_CAN_TAX_BALANCE;

--warning/ information messages

SELECT * FROM PS_BAS_MESSAGE;
SELECT * FROM PS_BEN_BI_MESSAGE;
SELECT * FROM PS_COBRA_MESSAGE;
SELECT * FROM PS_CALC_MESSAGE;

SELECT * FROM PS_DED_MESSAGE;
SELECT * FROM PS_PI_MESSAGE;
SELECT * FROM PS_RETRODED_MSG;
SELECT * FROM PS_RETROPAY_MSG;
SELECT * FROM PS_SV403_MESSAGE;
SELECT * FROM PS_PAY_MESSAGE;

--for current payroll

SELECT * FROM PS_BOND_LOG;
SELECT * FROM PS_DED_ARREARS;
SELECT * FROM PS_DED_PREPAY;
SELECT * FROM PS_FLSA_ADDL_DATA;
SELECT * FROM PS_GARN_EMPL_DED;
SELECT * FROM PS_GVT_CONFIRM_TBL;
SELECT * FROM PS_GVT_PAY_LIMITS;
SELECT * FROM PS_GVT_SF113G_DATA;
SELECT * FROM PS_HP_CONTPAY_DTL;
SELECT * FROM PS_INS_EARNS_BAL;
SELECT * FROM PS_LEAVE_ACCRUAL;
SELECT * FROM PS_PAY_CAL_BAL_ID;
SELECT * FROM PS_PAY_CHECK;
SELECT * FROM PS_PAY_CNTRACT_DTL;
SELECT * FROM PS_PAY_DEDUCTION;
SELECT * FROM PS_PAY_DISTRIBUTN;
SELECT * FROM PS_PAY_EARNINGS;
SELECT * FROM PS_PAY_GARNISH;
SELECT * FROM PS_PAY_GARN_OVRD;
SELECT * FROM PS_PAY_INS_EARNS;
SELECT * FROM PS_PAY_LINE;
SELECT * FROM PS_PAY_ONE_TIME;
SELECT * FROM PS_PAY_OTH_EARNS;
SELECT * FROM PS_PAY_PAGE;
SELECT * FROM PS_PAY_SPCL_EARNS;

--for general balances

SELECT * FROM PS_DEDUCTION_BAL;
SELECT * FROM PS_EARNINGS_BAL;

SELECT * FROM PS_CHECK_YTD;

SELECT * FROM PS_GARN_BALANCE;

SELECT * FROM PS_TAX1042_BALANCE;
SELECT * FROM PS_TAX_BALANCE;

--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_XREF_WRK;
SELECT * FROM PS_TL_XREFSQ_TAO;
SELECT * FROM PS_TL_XREF_TBL;

--Retro process

SELECT * FROM PS_RETRO_PAYCHECK;

--temp/staging tables with pay_line data used in pay calc process. Some of them are for future use

SELECT * FROM PS_WRK_EARNINGS;
SELECT * FROM PS_WRK_LINE;
SELECT * FROM PS_WRK_PSHUP_TXN;
SELECT * FROM PS_WRK_SEQ_CHECK;

--Tax tables

SELECT * FROM PS_PAY_TAX;
SELECT * FROM PS_PAY_TAX_1042;
SELECT * FROM PS_PAY_TAX_CAN;
SELECT * FROM PS_PAY_TAX_OVRD;
SELECT * FROM PS_PAY_CTX_OVRD;