Missing data in the labor report ENT_LBR_064

Owned by Genhan Chen
Apr 19, 2018
1 min read

Problem

Gladys reported the issue about the pay period 201713 data are missing in the report ENT_LBR_064.

The following screenshot shows the criteria she entered:

 

See the generated report in ACS PT OT Report PP201715 to PP201808 ENT_LBR_064.xlsx

This is a very interesting situation. Only Department 59 does not have the correct data for the Pay Period 201723 (414).

Solution

In this case, the data need to be reloaded into the table LBR_SUMM_T in the ENT_REPORTS schema. The procedure LBR_SUMM_GSD_SP is developed for updating the data for Dept 59.

If LBR_SUMM_T cannot get updated, we need to find and truncate all the records for Dept 59 and PP 201723. Then run the procedure LBR_SUMM_GSD_SP again.

The following two procedures are used to update the table LBR_SUMM_T:

  • LBR_SUMM_SP - Inserts "Labor Distribution Summary" records in LBR_SUMM_T table
  • LBR_SUMM_GSD_SP - Inserts "Labor Distribution Summary" records for GSD (General Service Data) in LBR_SUMM_T table

/wiki/spaces/CPMS/pages/7110678