Table Changes in Spectrum 2024 R1

A list of the database table changes made since the most recent release.

For reference purposes only

This information is intended for use in creating customized reports.

New Tables

This version has six new Tables.
  • PA_GLOBAL_TID_EMAIL
  • PA_GLOBAL_TID_MAP
  • PR_CHECK_AUTO_DEP_ALLOC_HIST_MC
  • PR_CHECK_AUTO_DEP_ALLOC_MC
  • PR_OVERTIME_PAY_EXEMPTION_MC
  • ST_STRIPE_PAYMENT_TRANSACTIONS_MC

New Views

This version has three new Table Views.
  • PR_CHECK_AUTO_DEP_ALLOC_HIST_CRYPTO
  • PR_CHECK_AUTO_DEP_ALLOC_HIST_CRYPTO_MC
  • PR_OVERTIME_PAY_EXEMPTION

New Columns

New columns listed by table.
TableColumn(s) Added
PR_EMPLOYEE_MASTER_3_MCBenefit_Code
WS_TEMP_PO_HEADER_MCAccrue_PO_Costs

Deleted Objects - none

No database objects were deleted in this version.