POINTS FOR PARTICIPATION
the MSS, both windows and DOS versions.
- Competitor no is a system
generated field, and is therefore problematic to use as a SAPSA competitor no to track participation at
any level of match.
- WinMSS makes provision for a
national Number / alias, but only for level three matches.
- Obtaining access to the data in
the dos MSS is no problem – standard Dbase data files accessible in DOS,
but the WinMSS is written in Microsoft Access and the data and code is protected.
I can see
the following possibilities as solutions:
- Create at national level for
all clubs to use for all events an Excel spreadsheet solution to capture
and summarise the results of all matches, ending up with a full year log
of results and standings (giving rise to a standardised summary of results
for all clubs and provinces). As an offshoot of this, a spreadsheet could
be generated for emailing to SAPSA/ Provinces allowing for a simplified
import / tabulation of participation. This solution would require the
provinces to agree an overall specification for the product and forced
mandatory application at all provinces clubs. SAPSA would pick up an
additional admin cost in collating the information. Annual performance
needs to be logged regardless, so the base model does not represent any
addition load on SAPSA / provinces. It is only the collating of
participation points at club level that would be new data processing.
- An alternate (or in conjunction
with the above) would be to do the following:
- A competitor “passport” as a
record of participation at matches signed off at each match indicating
membership of SAPSA and participation in matches. This could be run on an
annual basis or as an annual insert into a competitors log of
participation. The participation record should probably be in two part,
with one part going to SAPSA at
the end of each year.
- At each match, a register of
participation should be emailed to SAPSA / provinces as an audit trail,
and a sample audit / audit on complaints can then be performed against
the competitors log if necessary.
- To me, a benefit of this
solution is that the log for a year is evidence of membership (only
available after paying for the year), and moves the admin burden to the
day of the match with a minimal audit load at SAPSA / the provinces. It
doesn’t matter where the competitor participates, it is up to him to
obtain proof of participation and not up to SAPSA/ Province to track it –
BUT SAPSA /
province has the facility to verify it against match logs or on a
sample audit basis on an annual footing to establish credibility.