Table Information for the Month End Processes Screen

Changes to the Month End Processes screen update the tables being updated by the processes this application runs.

The tables include the following:
Screen Updated Tables
Create Pool Links This screen does not update any database table.
Build Rate Application Table
  • ALLOC_APPLIC
Compute/Print Pool Rates
  • POOL_SIE_SUPPORT
Compute Burden Costs
  • PROJ_SUM
  • PROJ_BURD_SUM
Load Labor Rates
  • LAB_HS
  • OPEN_BILLING_DETL
Compute Revenue

Updated tables include:

  • PROJ_SUM
  • PROJ_BURD_SUM
  • PROJ_HIERARCHY
  • PROJ_REV_PROJ
  • PROJ_MOD_ITD_SUM

If the Track Revenue Setup Information on Compute Revenue check box is selected on the Revenue tab of the Configure Project Settings screen, the Compute Revenue process also updates the audit tables with values from the setup tables for each project, fiscal year, period, subperiod, and other applicable fields. These audit tables include the following:

  • CEIL_BURDEN_CST_ADT
  • CEIL_DIR_CST_ADT
  • CEIL_DIR_HRS_ADT
  • EMPL_CEIL_ADT
  • OVRIDE_FEE_ON_BURD_ADT
  • OVRIDE_FEE_ON_DIR_ADT
  • OVRIDE_MLT_ON_DIR_ADT
  • PROJ_ADT
  • PROJ_MOD_ADT
Update Project Status Report Tables
  • PSR_HDR
  • PSR_FINAL_DATA
Create Project Report Tables
  • RPT_REV_SUM
  • RPT_PROJ_LAB_SUM
  • RPT_PROJ_TMA
  • RPT_REVENUE_WKS