Using the Error Table

When periodic processing encounters erroneous or missing data for an individual, it stops processing for that individual and continues with the next available individual. Examples of data errors include:

  • Missing date of birth

  • Missing date of hire

  • Unresolved date alias

When data errors occur, the system writes a row of data to the PS_PA_EE_ERR_TBL table. This table contains seven fields:

  • EMPLID

  • BENEFIT_PLAN

  • ASOFDATE

  • RUN_CNTL_ID

  • PGM_NAME

  • PARA_NAME

  • ERR_MSG

You can use this information to troubleshoot and correct the data error. After the data is corrected, you can delete the rows in PS_PA_EE_ERR_TBL and rerun periodic processing for the affected individuals.