11241847067
99%
main: 96%

Ran 08 Oct 2024 06:53PM UTC

Jobs 1

Files 27

Run time 1min

Badge

Embed ▾

Committed 08 Oct 2024 06:49PM UTC coverage: 99.129%. Remained the same

Build # 11241847067

Build Type

Pull #200

github

Committed by

ghukill

Commit Message

Updates to termination reason and date

Why these changes are being introduced:

Additional feedback from HR has shown where the termination
reason and dates could be improved.

There are some edge cases that make this kind of tricky, e.g.
people that have appointments terminated, but get rehired.  Or,
employees that transfer to another DLC in the organization, where
there is no termination reason in the data warehouse, but the end
date should be their last library appointment.

How this addresses that need:
* Reworks CTEs in the employees query to focus on the
last or current library appointment for an employee
* This is used in the main body of the query to fill end date
and termination reason

Side effects of this change:
* None

Relevant ticket(s):
* https://mitlibraries.atlassian.net/browse/HRQB-20

Pull Request Pull Request #200: HRQB 20 - Updates to termination reason and date

Run Details

1024 of 1033 relevant lines covered (99.13%)

0.99 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	11241847067.1	08 Oct 2024 06:53PM UTC	0	99.13	GitHub Action Run

Source Files on build 11241847067

Detailed source file information is not available for this build.

MITLibraries / hrqb-client / 11241847067
99%
main: 96%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 11241847067

MITLibraries / hrqb-client / 11241847067 99% main: 96%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 11241847067

MITLibraries / hrqb-client / 11241847067
99%
main: 96%

README BADGES
x