Program To Help for Developers

Table: program

allow_dup_regs

Can a person sign up more than once? Personal Retreats have this field set to 'yes'. Other programs could have it set as well. If not set we prohibit a duplicate registration.

alt_packet

filename (in /var/Reg/documents) of an alternate guest packet

badge_title

A short description of the program for badges.

bank_account

Where do registrations payments go? To the MMI bank account ('mmi'), the MMC bank account ('mmc'), or both accounts ('both')?

cancelled

boolean - Has this program been cancelled? Set/Unset via a menu link.

canpol_id

foreign key to canpol

category_id

foreign key to category

children_welcome

Are children welcome to attend with parents?

cl_template

confirmation letter template file name. Mostly it is 'default' but can vary. It lives in root/static/templates/letter.

collect_total

Should we collect the total amount due when registering online?

color

RGB values for the color of the program in the DailyPic.

commuting

Are people allowed to commute for this program?

confnote

A note that is included in ALL confirmation notes.

covid_vax

Is proof of a COVID vaccination required?

created_by

the user who created the program - foreign key to user

deposit

the amount required to deposit when registering.

discount_code

discount code for this program

discount_pct

the percentage discount for this program given the code

dncc_why

an obsolete field

donation

Registrants pay what they want - by donation.

donation_minimum

What is the minimum donation amount? Could be 0.

donation_msg

What text should be displayed before the donation text box?

donation_tiers

A string describing the tiers of donation choices like: 25 50* 100 other OR 50 100

donation_zero_msg

If there is not minimum and someone pays nothing what should we say?

do_not_compute_costs

Should we not compute the costs of this program? = Obsolete

economy

Is Economy housing available?

edate

end date of the program

end_reg_date_time

format: mm/dd/yyyy hh:mm - after what date/time should registrations be closed?

extradays

How many extra days after the end date for the extended version of this program?

facebook_event_id

an id referencing the event on facebook. not a foreign key.

footnotes

A field containing *, **, +, or % - denoting what kind of CEU credits are available for this program. Rather cryptic! This was inherited directly from old reg.

full_tuition

For extended programs what is the tuition for the full length?

glnum

General Ledger number for this program for accounting purposes. This is computed based on the start date.

housecost_id

foreign key to housecost

housing_not_needed

No housing is needed for this program - perhaps it is being held away from MMC?

id

unique id

kayakalpa

Shall we include a note about Kaya Kalpa information in the confirmation letter?

level_id

For MMI programs this indicates the type of course. CS YSC1, CS YSC2, ..., Certificate, ... Course

linked

Shall this program's web page be linked to the others?

lunches

An encoded (essentially binary) field describing which days of the program have lunch.

manual_reg_finance

registrations will initially have manual finance not automatic

max

What is the expected maximum registrations for the program? This number of registrations will be enforced. After it is reached registrations will be closed.

name

A name for the program - used internally for identification.

not_on_calendar

Should this program not be included on the calendar? Default no (meaning yes include).

notify_on_reg

A list of email addresses to email when people register for the program.

percent_tuition

What percentage of the tuition should be collected when someone registers online? Default is 0. This would be in addition to the specified deposit.

pr_alert

This program has an effect on PRs. This column contains text to 'pop up' when a person registers for a PR whose dates overlap with this program's dates.

prog_end

Time the program ends on the last day.

prog_start

Time the program begins on the first day.

program_created

date the program was created

ptemplate

the template file to be used for generating the program web page. Defaults to default.tt2 in root/static/templates/web.

refresh_days

a binary encoded field to indicate which days that the rooms should be refreshed (new linen). Mostly for programs longer than a week. It is used when creating the 'make up' list.

reg_by_day

Registrants can choose which days they want to attend.

reg_count

The number of current registrants. This field keeps changing as people sign up and cancel. Too difficult and time consuming to keep recomputing it.

reg_end

Time that registration ends on the first day.

reg_msg

An optional message to appear near the top of the first registration page.

reg_start

Time that registration begins on the first day.

rental_id

foreign key to rental - if the program is a 'hybrid'.

req_pay

Do registrations for this program allow requested payments?

retreat

Is this an MMC yoga retreat?

sbath

Are singles with bath allowed?

school_id

foreign key to school

sdate

start date of the program.

single

Are singles allowed for this program?

strangers_share

Can strangers share a double?

subtitle

A secondary description of the program. For the web page.

summary_id

foreign key to summary

tub_swim

should we mention the hot tub and lake swimming in the conf letter?

title

A short description of the program for the web page.

tuition

A charge for the program - mostly for the presenter.

tuition_name

An alternate name for 'tuition'

tuition_rolled

Is tuition rolled into the housing cost?

unlinked_dir

Obsolete. For unlinked programs (see the linked attribute) this is a directory name on www.mountmadonna.org that will contain the program.

url

A web URL containing further information about the program.

waiver_needed

Registrants for this program must sign a waiver.

webdesc

A long description of the program.

webready

Is this program ready to be Exported?

Relations