Re: data structure question

Author: Stephen Russell

Posted: 2013-12-18 at 14:59:09

Per your description you need to create a billing table to cross reference

the gymnast to the parent.

Having paid for a granddaughters gymnastics before I paid no matter if she

were there or not. You pay in advance monthly and there is credit for

injury only. Maybe they had pay per visit rates and we never would pay

that higher rate?

On Wed, Dec 18, 2013 at 2:40 PM, Gary Jeurink <g.jeurink@charter.net> wrote:

> I'm trying to throw together a gymnastics school in a cloud that includes

> skill tracking, an attendance and billing system. Since I don't have

> accounting experience, I need help with the invoice structure so I have

> questions.

>

> Tables involved as I have progressed so far: classes, students,

> clients(person billed), spots(current list of students per class), and

> sessions

>

> A session can be 4-weeks, 5-weeks or 11-weeks (summer option where a

> customer may pick which of the 11 weeks they want to attend).

>

>

>

> In the end I want to take roll per class. classID, studentID, sessionID,

> (date?). This is where I get hazy. Where do I put attended/absent fields

> when it will be class/session/date related.

>

> Class-1 could meets Mondays at 4pm. (Labor day-off..1-less week) Class-2

> could meet up to 4-times per week. A student could be enrolled in more than

> 1-class (discount-eligible). Client-12 may have multiple children (also

> discount eligible).

>

>

>

> I'm thinking my invoice to bill clients for a session, will be the same

> table I take enrollment in. It gets complicated as we try to allow

> occasional make-ups when other classes have room to accommodate an extra

> student. We also allow a student to jump in for the last week of a session

> as openings permit and we would pro-rate that session so they only pay from

> their start and forward. We have waiting lists for most of our classes

> (which means a scheduled make-up is rare).

>

>

>

> My overall goal is to take attendance and note skill achievements with

> i-pads or equivalent device out in the gym and let our office manage the

> billing. A cloud would be ideal where parents could check student progress

> and interact with notes to and from coaches and so on.

>

>

>

> I'm not afraid of doing the work but I'm not sure how to proceed and I

> don't

> want to make a big fluffy data records that never get used.

>

>

>

> Gary Jeurink

>

>

>

> --- StripMime Report -- processed MIME parts ---

> multipart/alternative

> text/plain (text body -- kept)

> text/html

> ---

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAJidMYKaDWHFVX-7XTYKM2XvQUJktDgxwSQ0ROKKUq023xxDiA@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2013 Stephen Russell