Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

The _proj fields exist in many of the Munis Payroll/HR tables and are used to segregate data.

  • proj 0 is for live records
  • proj 1 is for records in the Terminated programs
  • proj 2-100 are for Personnel Actions that have not yet been posted to the live records
  • proj 101-200 and 1001-2000 are for Salary & Benefit Projections (where _proj = the Salary & Benefit Projection Run #)
  • proj 201-300 are for Retro Pay files
  • proj 401-499 are for Attendance Bonus Pay Runs
  • proj 401-500 are used with Mass Step Increases, Mass Contract Increases, Mass Index Step Increases and Pay Band Increase processing
  • proj 501-600 are for Longevity
  • proj 900-902 are used for ESS Accruals records. 
    • 900 reflects time that has been requested through ESS
    • 901 reflects time that has been requested through ESS and subsequently Approved
    • 902 reflects time that has been requested through ESS and subsequently Denied
  • proj 999 used for applicants
  • proj 5000-5999 are used for a holding place for Employee Import

...