Not really used because all participating organizations will have a record in the conference table, even though it might be fake. ||

Churches:
1 : pull from eAdventist.net
all others : pull from AdventistDirectory

Pastors:
0 : entered manually
1 : authorized to pull from eAdventist
2 : authorized to pull from Adventist.org.uk

For 2 and up we also ask them to fill in the local ID for the church on the Church List page since we need that to be able to automatically link the pastors that are being fed by the local conference's database.
((Can add more values for each different synchronization scheme we encounter with different conferences))

0 : pastor's recommendation, conference-staff final approval
1 : pastoral approval, no notification to conference organizer when approved
2 : pastoral approval, with notication to conference organizer when approved
9 : automatic approval, no notification to conference nor pastor

(fieldname should have been allow_pastors_approve_speakers!)

Possible values:
- waiting
- accepted
- rejected

- "Done campaign" (when accepted) (value also used to unset it in case an qualifying event(s) are deleted, so it should not be modified)
- "Int'l recommended" (when accepted)
- "Auto-accepted eA pastor" (when automatically set to accepted by the Obtain Pastor Login procedure in login_link_pastor.php)
- "Trained by training entity" (when automatically set as accepted in home conference after their studies have been completed at an institution)

Values set AND used by the system (only when status=waiting):
- "Pastor: ?": pending pastor response
- "Pastor: yes": pastor consented
- "Pastor: caution: [a reason]": pastor cautioned

Possible values:
- 0 : no
- 1 : yes
- 2 : not necessary

For homeland date blocks the hotel info is not required and this field should be set to yes (but not mandatory)

And then all the same fields as main_hotels.

Note that dbh_active is currently used actively use (= cannot be set to No) and is only there to retain historic values.

Date is inclusive, so after this date no new applications are accepted. When converted to a Unix timestamp we add one day minus one second, so that the calculation is correct AND if converted back to only a date it is still the same date.

- teams
- groups
- site info (incl. translations)
- hotel info
- orientation hotel info
- rank sites
- rank speakers

This date MUST be after applications closed date.

As of 2007-12-05 the detailed definition was:
- people cannot remove themselves from campaigns after this date, but all other accesslevels can (eventdelete.php).
- conference coordinators for international campaigns (not conference organizers) cannot do these things after this date (but admin and coadmin can always do all of these things):
* add campaign sites
* edit campaign sites
* add hub cities to a date block
* edit orientation hotel info
- people cannot themselves re-arrange their team and group membership after this date.
- ranking of sites and speakers can only be changed by admin and coadmin after this date.

(PS. Hotel reservation is locked on date block opening date)

Homeland: optional additional label like "SWAU"

For homeland campaigns this is currently kept updated to equal the number sites that have been set up for this date. Would be more useful to only count the sites where a speaker had been matched...

An empty value here causes the system to revert to the pre-2013 system where only speakers would be paying.

Irrelevant for homeland campaigns. (Previously only used for in homeland: Displayed in the popup box for approving and selecting material for an applicant.) || req. for international opt. for homeland

Because of problems in India where the public should not be allowed seeing the information about the date block.

Only show predefined organizations down to the union level (= excl. conferences) In connection with the table Date blocks' predefined conferences.

- Homeland: the date from the matching record in main_dateblocks
- International: null

This field can currently be used to determine if the campaign site is homeland or international.

Possible options:
- NULL : regular campaign
- 'spk-init' : speaker-initiated campaign

Homeland only.

- International: full site name (req.)
- Homeland: only an optional additional label (req. for Speaker-Initiated Events though) that is added to the date (and the church name, which we get from the site's master site).

Should be renamed to 'si_campaign_label'. Deprecated name used in the homeland is 'campaign_label'.

Homeland only.

Homeland only.

Homeland only.

req. for spk-init events

req. for spk-init events

req. for spk-init events

always req. Homeland: req. for spk-init events

dropdown

Only used in homeland.

dropdown

Only used in intl. system.

Only used in intl. system.

The pastors of this church (master site) from eAdventist at the time the site was set up or when a speaker was assigned. Automatically set by the system. ||

Homeland only.

Possible options:
- NULL
- 'await_approv'

Homeland only.

Name of the OLT, usually the church name.

Should be renamed to 'chtm_name'. Deprecated names are 'olt_name', 'church_name', and 'church_name2' in SQL output.

- search for "main_master_sites" and "'tblname' => 'master_sites'" and edit acl_add_master_site() and i_master_sites.php/php_functions_i_master_sites.php

Search for "main_master_sites" to try to find location where it might still be used.

Password OLT members can use to access information for this OLT. Not really used at the moment.

Usually renamed to 'olt_pw'.

ID of parent conference.

(I believe we always have this one)

ID of parent conference.

(this one we don't yet have for the churches we've retrieved through the webpages) CAN WE JUST DROP THIS FIELD BECAUSE IT SEEMS TO THE CHURCH'S SDAORGID REPLACED WITH "11" ON THE END?!

Not used for NAD conferences, since Officer ID (from eAdventist) is used. If we change use assign_pastor_to_church() must be reviewed.

This is the same ID as main_people. sda_membershipID. Used only for records coming from eAdventist.net.

NOTE!! If this is expanded to be anything else than pastors we need to change the method in assign_campaign_site() we use to determine if speaker is pastor as well in get_pastors_churches() and probably other functions as well (since they only check for the existence of a church office record and not the office name value)

In case a church has multiple pastors this can indicate which pastor is responsible for evangelistic decisions. Used to know which pastor we can ask to recommend a speaker.

The date the pastor was no longer holding this office.

Is set to 2000-01-01 if we don't know (= lost) the actual date.

(only used for international)

Entered by the speakers. (only used for international)

Entered by the coordinators.

Entered by the speakers (only used for international)

Entered by the coordinators.

Possible values:
0 : no
1 : yes
2 : maybe

(This ID is the same as main_officers.officerID. Brian: "Yes, the PersonID is the same Officer ID that we use for Pastors web service.")

Prefered to be set as the option "Pastor" is sometimes used to identify pastors.

Required for different reasons (and more I haven't written here): These people go in to the regular table of people where we have speakers and so on, and that field has always been required. Besides having a name without connected to a country can be pretty ambigious. The more information we have about a person the better. It also helps us to know which division they are in which is required in case they apply for a campaign.

Sometimes noemail@noemail.com or none@none.com has been put in if we don't know the address.

Date when e-mail addr was verified

If the e-mail address is not working register here the date it was discovered. Reminders, news letters etc. will not be sent to this person then.

Can have the value "Do not have" if person simply does not have this kind of number.

Can have the value "Do not have" if person simply does not have this kind of number.

Can have the value "Do not have" if person simply does not have this kind of number.

Coming from main_churches.churchID

Possible values: (by sending fields/recommenders)
- NULL (when not recom. processed)
- waiting
- recommended
- unrecommended

Pastor/layman/academy in NAD:
- stores the ID of the recommender to which an e-mail was sent at time of application

College students:
- college date block ID

dropdown

VALIDATION:
- check if this from-language is available within the desired date block. If not, give option to select another language.

Possible values:
- DVD (means using a DVD player)
- DVD-R (means using a computer)

(old values: CD, DVD-Combo)

Has person taken the ShareHim boot camp training program?

Possible values:
- 0 : no
- 1 : yes
- 2 : is an ordained/licensed pastor
- 3 : is a retired pastor

(Being any type of pastor resolves to the same effect as saying yes)

Determined automatically by the system, cannot be manually set (as of today at least). No means only that we do not know if they have done a campaign. NOTE: now this does not only include international campaigns, even though the field name indicates that. Also having done a homeland campaign will now result in this being set to yes.

First ShareHim campaign that this person participated in as a speaker. Used for people applying for homeland campaigns.

Lay applicants: pastor Academy students: academy & contact

Pastoral applicants: ministerial sectary

Lay applicants: pastor

Academy students: academy & contact

Pastoral applicants: ministerial sectary

Lay applicants: pastor

Academy students: academy

Pastoral applicants: ministerial sectary

Lay applicants: pastor

Academy students: academy

Pastoral applicants: ministerial sectary

Lay applicants: pastor

Academy students: academy

NULL: has not been set
0: no
1: yes, in e-mail format
2: yes, in hardcopy format

Did we send them the mentorship material?

number

0 = ordinary OLT member (default)
1 = is OLT leader
2 = is OLT secretary

NOTE: cannot move this field to main_olts because we have people set as leaders/secretaries who are not member of any particular OLT.

Possible values:
- executive (edit text/graphics, approve, add/delete stories)
- associate (edit text/graphics)
- text
- graphics
- advreview (Adventist Review editor)

date

When person should not receive any correspondence or be contacted, register the date this was set.

(eg. do not want info from us, is deceased etc.)

number

0 = no
1 = yes
2 = yes and also hide from any logged in users not part of the same campaign
3 = yes and also hide from any logged in users except admins

NOTE!! CURRENTLY 1, 2 and 3 makes no difference on the website. All cause a behaviour equal to 3.

Should the person name and critical personal details (name, address, and phone numbers) be hidden from public/non-logged in users (or from logged in users except those participating in the same date block, or even everybody but admins and co-admins)?
If yes:
- hidden on mainly the campaign overview
- if they are organizers they are currently NOT hidden
- hidden in get_dateblock_people()
- hidden in get_people_availability()
- hidden in get_person_info()
- skip showing personal portrait on stories
- hidden in other functions too...

Indication of how this person originally got into the database. Possible values (also defined in main_peopleedit.php):

• 1: applied internationally
• 2: applied homeland acceptance
• 3: homeland pastor
• 4: made a donation/pledge
• 5: conference organizer/sector leader
• 6: OLT member
• 7: signed up for newsletter
• 8: order received from GoodSalt.com
• 9: is translator for homeland system
• 10: homeland speaker (assigned to past campaign => not accepted in conf)
• 11: non-ShareHim related homeland speaker
• 12: given a ShareSynch serial number (version C sermons)
• 13: Signed up for a ShareHim festival
• 14: Imported from "BobsContacts" from Zimbra/Outlook
• 15: recommender for applicants to international trips
• 99: other manually added record

Updated to always hold the effective site ID for this event (mainly to make it easier to deal with associate speakers and STMs) - currently only filled out for homeland campaigns (but we might want to use it for intl as well).

It's maintained even if event is deleted.

Possible values:
- pastor
- layman
- college
- academy
- stm
- organizer

yes/no

Is this a standby event?

(Retained even though event is deleted)

(the link to groups must of course match this link.)

(we know the main speaker by the team the associate speaker is member of) ||

If yes none of the four fields above must be filled out ||

- 'no' : no, only a computer
- 'probably_can' : probably yes
- 'probably_cannot' : probably not
- 'yes' : yes, both computer and projector
- 'renting' : applicant will be renting equipment from ShareHim

NULL = not a minor
1 = pending receiving the consent form
2 = consent form received
3 = is minor, parent/guardian is coming too

Is set to NULL when event is deleted if it was 1 or 3.

yes/no

Whether or not the person should receive sermon notes/graphics for this event. Used with the "missing notes" report. This value is basically only informational. Extended to this use:

0 : nothing skipped
1 : skip sermon notes
2 : skip Jesus video
3 : skip both sermon notes and Jesus video

(3 is automatically set when setting a speaker for past homeland campaign or when setting a non-ShareHim-related speaker for a homeland campaign)

Is set to yes when we delete an event but keep the database record because material has been shipped concerning this event, and because we want to keep a historical record.

(Retained even though event is deleted)

datetime

Date we have received the deposit for the direct campaign cost (international only). The field Site-funding required will determine if this is necessary. If it is, only after that point we initiate the application process.

Set to 2000-01-01 when bypassed by admins (when auto-approved was requested when event was added)

Set to 2000-01-02 for events before we implemented this procedure

Set to 2000-01-03 when event is in an individually funded group (where leader has already paid the deposit)

Must have a value for the event to be considered approved, no matter what the category is.

Set to 2000-01-01 when it is unknown.

(Retained even though event is deleted)

The date the standby event will expire.

The date a standby event was activated.

(Retained even though event is deleted)

Possible values:
- 'phonecall'

dropdown

Possible values:
- 1 : encourage mentorship
- 2 : block all future participation
- 3 : block future intl. participation
- 4 : block future homeland participation

Same format as $_SESSION['user_fromtable']

In USD.

Set to 2000-01-01 if payment is n/a ||

This item will not shown on the shipping list until this date ||

Only used for graphics CDs, reporting to It Is Written ||

Possible values:
- 'sharehim': ShareHim is responsible
- 'individually': each group member is responsible, but deposit for ALL must be received before any can apply
- ' indiv_owndep': each group member is responsible, all applicants must pay their own deposit at time of application
- 'collectively': group is responsible collectively

No one excepts organizers can apply before deposit has been received if funding source is 'individually'.

Has no effect if amount is not set or 0.

Has no effect if date is not set.

Possible values:
- 'skip' : don't show the equipment subpage at all
- 'non-us' : make them confirm that they will bring computer/projector/remote
- 'non-us-flex' : give them option to indicate whether or not they can bring a projector

Skip asking for parent/guardian name for applicants to this group?

Possible values:
- no (0)
- yes (1)
- not necessary (2)

E-mail of person received the insurance information ||

If filled out it's a call tag, otherwise not

When the case is under repair or for another reason is not available for booking ||

When the case has been sold and we no longer have anything to do with it ||

dropdown:
- Next day service
- Next day service + complete care

When the laptop is under repair or has been sold and hence not available for booking ||

Remote control for mouse ||

Current list:
- Notes/graphics CD
- Graphics CD
- Life of Christ video
- Hardcopy (language must correspond exactly with sermon languages)

Must not be changed without considering consequences for rest of the system. Some of these values are used hard-coded in the script code

NTSC/PAL/SECAM

CD/(DVD/VCD)

Current list:
- It Is Written
- Present Solutions

If royalties must be paid when issueing this item select here which organization it must be reported to.

dropdown

Possible values:
- sitereport (report about campaign site)
- testimonial (personal testimony)

dropdown:

- public (for publishing on website)

- internal (raw material for internal use)

Don't display the story in public before it's authorized ||

Don't display the story in public before it's authorized ||

Labels: Approved/Disabled/Not reviewed ||

Show thumbnail of person (of course only effective if thumbnail is uploaded) ||

Date is inclusive.

Date is exclusive.

Set to yes when original picture was retouched, either manually or cropped - as intermediate stage between original and final picture

If we don't know the date it is set to 2001-01-01. ||

- letter - email - authorize.net ||

If no letter was sent date is set to 2000-01-01. ||

Used for non-sitefunding donations only ||

0 / 1 / 2

1 = is superadmin
2 = is associate admin (lower than regular admin).

Only superadmin can see password, change information, add and delete users in external logins.

Only superadmin can emulate and set password (set_pw.php) for admin and coadmin.

Associate admins: the only difference between associate admins and normal admins is that they have less menu item on the menuadmin.php page (no restrictions or anything else).

yes/no

If coadmins are full-time or part-time managers

Show entire news item on the front page? (normally there is a max length for items shown there) || req.

Possible values:
0 = is not withdrawn (default)
1 = withdrawn, allow re-activation
2 = withdrawn, disallow re-activation

Activation code can be withdrawn, either by the user deactivating the computer (1) or ShareHim revoking it (2).

In case of 2, the software needs to register that this activation code is now invalid, so that later attempts to use the same activation code we fail (but what if they format the hardware?!). But, if the code is then regranted, we can only reactivation the software through online activation, otherwise we can't be sure that the revoked code is now active again! Well, for a solid solution the hardware should actually be encrypted together with a date, so that the activation code would be different when the computer was reactivated, and then this whole matter woudn't be an issue. (Or we could also just issue a completely new serial number...)

Case lock on equipment cases ||