Age group data warehouse reconciliation

Image

On this date*

Membership on April 28, 2025 cooked four different ways

  • Membership (method: meta): 1173
  • Membership (method: eagles): 1173
  • Membership (method: mcfly): 1172
  • Membership (method: cher): 1171

Differences

  • Subsequent rejoiners (eagles minus mcfly) = 1
  • Late renewals (mcfly minus cher) = 1

People who rejoined the club after April 28, 2025

NameAGMember
since
Member
until
Last Event
before 28-Apr-25
Last Event
date
Last Event
expired
David RobinsonM452006-01-212025-05-29lapsed2025-04-211970-01-01

1 members

Number of rejoiners (should match eagles minus mcfly) : 1

Late renewals after April 28, 2025

NameAGMember
since
Member
until
Last Event
before 28-Apr-25
Last Event
date
Last Event
expired
Mairi McInnesF452018-01-102026-04-10free renewal2024-04-102025-04-10

1 members

Number of late renewals (should match mcfly minus cher) : 1

Missing date of birth or gender

NameAGMember
since
Member
until
Last Event
before 28-Apr-25
Last Event
date
Last Event
expired

0 members

Number of people missing date of birth or gender : 0

Missing from the data warehouse

NameAGMember
since
Member
until
Last Event
before 28-Apr-25
Last Event
date
Last Event
expired

0 members

Number of people in the membership database but missing from the dw : 0