A rental is created when some other organization wants to rent the meeting space and housing at MMC. These events are not sponsored nor advertised by the center. Housing assignments are made by the coordinator by filling in a form on the global web. This information is brought into Reg periodically via a cron job or on demand (Grab New).
Table: rental
- alt_packet
- filename (in /var/Reg/documents) of an alternate guest packet
- arrangement_sent
- date that the arrangement letter was sent
- arrangement_by
- who sent the arrangement letter
- av_request
- special audio/visual requests
- av_request_cost
- cost of special audio/visual requests
- badge_title
- A short version of the title to fit on the badges.
- balance
- the outstanding balance
- cancelled
- boolean - was this rental cancelled? Set/Unset by a menu link. this is obsolete - we now rely on the status - does it contain 'cancel'?
- color
- RGB values for the DailyPic display.
- comment
- free text describing the rental
- contract_exception
- optional text describing any exceptions to the standard contract
- contract_received
- date the contract was received
- contract_sent
- date the contract was sent out
- coordinator_id
- foreign key to person
- counts
- the number of people attending the rental each day from start to end - space separated
- created_by
- foreign key to user who created the rental
- cs_person_id
- foreign key to person
- day_retreat
- is this a retreat just for the day? no housing needed.
- deposit
- how much deposit is required?
- edate
- date the rental ends
- email
- email address for the rental to put on the little web page (if desired)
- end_hour
- time the rental will end (and people will leave)
- expected
- how many people are expected? - obsolete
- fch_encoded
- the encoded form of fixed_cost_houses
- fixed_cost_houses
- lines describing houses with a fixed cost. designed specifically for economy dorms where there is only a pad on the floor.
- glnum
- a General Ledger number computed from the sdate
- grid_code
- a hard to guess code for the grid URL
- grid_max
- the maximum of the daily counts
- grid_stale
- is the web grid in need of refreshing? - OBSOLETE
- housecost_id
- foreign key to housecost
- housing_charge
- total cost from the housing grid
- housing_note
- free text describing any issues with the rental housing
- housing_request
- special housing request
- housing_request_cost
- cost of special housing request
- id
- unique id
- image
- does this rental have an image?
- invoice_sent
- date the invoice was sent by email
- in_group_name
- contract is in the group name instead of contract signer
- linked
- should this rental be included on the online Event calendar?
- lunches
- an encoded (essentially binary) field for when lunches are requested.
- max
- the maximum number of people expected. this is used to determine the financial obligation of the renter.
- meal_request
- special requests for meals
- meal_request_cost
- cost of special requests for meals
- meeting_request
- special meeting place request
- meeting_request_cost
- cost of special meeting place request
- mmc_does_reg
- will we be doing registration for this event? if so, a parallel hybrid program will be created.
- mp_cost_tier
- the meeting place cost tier (1 .. 4)
- mp_deposit
- Deposit is taken from meeting place reservations. Only effective in new contracts (April 2022). Otherwise the deposit is taken directly from the deposit field.
- name
- a brief name of the rental for internal purposes
- new_contract
- use the new contract (started March 2022)
- other_request
- special other request
- other_request_cost
- cost of special other request
- phone
- phone number for the web page, if wanted
- pr_alert
- This rental has an effect on PRs. This column contains text to 'pop up' when a person registers for a PR whose dates overlap with this rentals's dates.
- program_id
- foreign key to program
- proposal_id
- foreign key to proposal
- received_by
- foreign key to user
- refresh_days
- what days should the bedding be refreshed? This is an encoded field similar to lunches. This is used for longer term rentals.
- rental_canceled
- date the rental was canceled (by Host or by MMC)
- rental_created
- date the rental was created
- rental_follows
- does another rental follow this one? used in generating the make up list.
- sdate
- date the rental starts
- sent_by
- foreign key to user
- staff_ok
- has the staff okayed this rental?
- start_hour
- time the rental begins
- status
- tentative, sent, received, arranged, due, done, cancel_mmc, cancel_host
- subtitle
- secondary description of the rental for the web
- summary_id
- foreign key to summary
- tentative
- has this rental not been confirmed yet? checked at first, unchecked automatically when a contract is sent out.
- title
- primary description of the rental for the web
- url
- a URL of the rental for the web
- webdesc
- a longer description of the rental for the web.
Relations