Versions Compared

Key

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

...

Payroll uses this report to replace the the two Microsoft Access Queries, “PERS 1R7 Deduction 6% Query” and STRS 1R5 Deduction 2% at 62 Query”. The two lists those reports provided return are combined into one output here. Then Vicky requested I add in the 1R6 BDCA code as well

​🔘 Options

Options

Description

BDCA CODE

Choose the BDCA Code you want to look at or All for all three BDCA Code options.

📄 Results

Field Name

Data Source/Logic

Description (sample)

SPRIDEN_LAST_NAME

SPRIDEN.SPRIDEN_LAST_NAME

The Last Name of the employee

SPRIDEN_FIRST_NAME

SPRIDEN.SPRIDEN_FIRST_NAME

The First Name of the employee

SPRIDEN_ID

SPRIDEN.SPRIDEN_ID

the Banner ID of the employee

PDRDEDN_BDCA_CODE

PDRDEDN.PDRDEDN_BDCA_CODE

The BDCA_CODE when the BDCA_CODE is 1R7 or 1R5 or 1R6

PDRDEDN_OPT_CODE1

PDRDEDN.PDRDEDN_OPT_CODE1

Uses the Option Code E2 or EE for BDCA Code 1R7 and Option Code 62 or E for BDCA Code 1R5 or Option Code E for BDCA Code 1R6

PDRDEDN_EFFECTIVE_DATE

MAX(PDRDEDN.PDRDEDN_EFFECTIVE_DATE)

The Employer Amount when the BDCA_CODE is I50

...