90 Minds Mod Squad

I think this suggestion was posted by @Beth Bowers - Sage is asking for clarification - everyone feel free to add your comments too:

From Sage:
MS‐PR058 Add the check date field to all Payroll History files.

PR_PayrollHistoryHeader – contains check date with alternate key, child tables:

–reference header above but do not have check date
• PR_PayrollHistoryDetail
• PR_PayrollHistoryDirectDeposit
• PR_PayrollHistoryMemo
• PR_PayrollHistoryMemoSettings
• PR_PayrollHistoryTaxDetail
• PR_PayrollHistoryTaxDtlOther


Tables with check date already included:
• PR_PayrollHistoryEmployerExp
• PR_PayrollHistoryEmprExpOther
• PR_PayrollHistoryTaxRepOther
• PR_PayrollHistoryTaxReporting

Is the purpose of this to for reporting, so that you do not have to include/join the header table that contains the check date? Or is there another reason that this date needs to be replicated into the history detail tables.
​

------------------------------
Moira Goggin
Executive Director
90 Minds, Inc.
------------------------------

Strictly for reporting.  It used to be there in the old Detail file.

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------