Revision as of 19:34, 2 December 2011

Database Tables/Fields - sharehim_main

Divisions (main_divisions)

Containing the 13 SDA divisions in the world

divisionID	Division ID		req.
name	Name		req.
initials	Initials	3-letter abbreviation	req.
mailing_addr	Mailing address
mailing_city	Mailing city
mailing_state	Mailing state/province
mailing_zip	Mailing zipcode
street_addr	Street address
street_city	Street city
street_state	Street state/province
street_zip	Street zipcode
country	Country
phone	Phone number	multiple formats
fax	Fax	multiple formats
coord_name	Campaign coordinator
coord_office_phone	Coord. office phone	multiple formats
coord_home_phone	Coord. home phone	multiple formats
coord_cell_phone	Coord. cell phone	multiple formats
coord_email	Coord. e-mail
coord_pw	Coord. password
coord_approved	Coord. approved	yes/no
division_secretaries	Division officers	Comma-seperated list of e-mail addresses to which the service requests reminder will also be sent to.
comments	Comments
active	Active	yes/no

Unions (main_unions)

List of all the unions within the 13 world divisions. Occasionally we pull the data from AdventistDirectory to update our list of unions.

unionID	Union ID
sda_orgID	SDA organisation ID	4-letter abbreviation originating from adventistdirectory.org
divisionID	Division ID	Division this union belongs to
name	Name
	Mailing address
	Mailing city
	Mailing state/province
	Mailing zipcode
	Street address
	Street city
	Street state/province
	Street zipcode
	Country
	Phone number	multiple formats
	Fax	multiple formats
	Campaign coordinator
	Coord. office phone	multiple formats
	Coord. home phone	multiple formats
	Coord. cell phone	multiple formats
	Coord. e-mail
	Coord. password
	Coord. approved	yes/no
	Union officers	Comma-seperated list of e-mail addresses to which the service requests reminder will also be sent to.
	Is participant in homeland program?	yes/no Not really used because all participating organizations will have a record in the conference table, even though it might be fake. \|\|
	Comments
	Active	yes/no

Conferences or missions (main_conferences)

List of SDA conferences/missions/fields.

	Conference/mission ID
	SDA organisation ID (AdmFieldID)	4-letter abbreviation originating from adventistdirectory.org
	SDA OrgMastID	6-letter abbreviation originating from adventistdirectory.org. This is the master ID from eadventist.com.
	Union ID
	Name
	Name contracted	Short name for the conference. Used in homeland system.
	Mailing address
	Mailing city
	Mailing state/province
	Mailing zipcode
	Street address
	Street city
	Street state/province
	Street zipcode
	Country
	Phone number	multiple formats
	Fax	multiple formats
	Conference e-mail
	Campaign coordinator
	Coord. office phone	multiple formats
	Coord. home phone	multiple formats
	Coord. cell phone	multiple formats
	Coord. e-mail
	Coord. password
	Coord. approved	yes/no
	Conference officers	Comma-seperated list of e-mail addresses to which the service requests reminder will also be sent to.
	Participant in homeland program?	yes/no
	Churches & pastors synchronization setting	Churches: 1 : pull from eAdventist.net all others : pull from AdventistDirectory Pastors: 0 : entered manually 1 : authorized to pull from eAdventist ((Can add more values for each different synchronization scheme we encounter with different conferences))
	Allow pastor to do final acceptance of new applicants?	yes/no 1 : pastoral approval 0 : pastor's recommendation, conference-staff final approval (fieldname should have been allow_pastors_approve_speakers!)
	Last updated via eAdventist	For non-NAD conferences this indicates last time we updated the church list from AdventistDirectory.org
	Internal comments	ONLY coadmin and admin may see/edit this.
	Public comments
	World map, X-coordinate	For the Flash world map
	World map, Y-coordinate	For the Flash world map
	Active	yes/no

Conferences' Wire Information

Information used for wiring money to the different conferences.

Conference/mission ID
SWIFT code	Only SWIFT or ABA can be filled.	cond.
ABA number	Only SWIFT or ABA can be filled.	cond.
Bank account no.		req.
Name of account holder/owner		req.
Address of account holder		req.
Bank name		req.
Bank location		req.
Use correspondent/intermediary bank?	yes/no	req.
Correspondent bank name
Correspondent bank location
Correspondent SWIFT code	Only SWIFT or ABA can be filled.
Correspondent ABA number	Only SWIFT or ABA can be filled.
Account no. of beneficiary's bank (the bank above) at the correspondent bank

Conference accepted people

People's acceptance or rejection to preach in a specific conference. Only applicable to homeland date blocks.

Conference acceptance ID
Person ID		req.
Conference ID		req.
Acceptance status	Possible values: - waiting - accepted - rejected	req.
Acceptance comments	Values set by the system: - "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) 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	req. if rejected

Hub cities - Previously Hotel cities (main_hotels)

Hotel city ID
Conference/mission ID	Only used for homeland (some hub cities for international campaigns also contain a conference because ALL records were assigned the ID when we created this field)	req. for homeland
City
Hotel name		req.
Hotel address		req.
Hotel address (line 2)		req.
Hotel country		req.
Hotel phone	multiple formats	req.
Hotel fax	multiple formats
Hotel e-mail
Hotel website
Price single room		req.
Price double room		req.
Price additional person	amount or n/a	req.
Breakfast included	yes/no (note next field)	req.
All meals included	yes/no	req.
Est. price additional meals		req.
Recomm. budget for meals outside hotel per day		req.
Aircondition	Possible values: - 0 : no - 1 : yes - 2 : not necessary	req.
Transportation	Info regarding getting from orientation to hotel city	req.
Comments	Public
Is non-hotel?	yes/no For homeland date blocks the hotel info is not required and this field should be set to yes (but not mandatory)
Active	yes/no

Date blocks' hotels (main_dateblockhotels)

Date block hotel city ID
Date block ID		req.
Hotel city ID (= hub city)		req.
Cluster ID
Date block orientation ID	Optional and ONLY used for linking a specific orientation to this hotel city in case the date block has multiple orientation sites.

Date blocks

Date block ID
Opening date		req.
Closing date		req.
Applications closing date	Should be the final cut-off date for new applicants. 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.	req.
Data lock date	After this date only administrators and co-administrators will be allowed to change all data concerning a date block: - 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)	req.
Campaign title (Homeland: Additional label)	Usually the country wherein the campaigns will be held. Homeland: optional additional label like "SWAU"	req. for international opt. for homeland
Total sites	Total number of campaign sites in this date block - must ALWAYS be kept up-to-date as available sites are calculated from this. 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...
Questions recipient	LoginID of the person from External logins who will receive questions about this date block. This person will also be the lead date block manager.
Pre-campaign manager	LoginID of a coadmin person from External logins who will be the pre-campaign manager if different from the lead manager.
Insurance reminder sent date, 1st
Insurance reminder sent date, 2nd
Service requests reminder sent date, 1st
Service requests reminder sent date, 2nd	Just before the campaign
Last incomplete notification	The date we last sent a notification to unions/conferences/campaign manager about incomplete information entered for this date block (if any)
Default sermon notes language (Material ID)	dropdown; must be a CD set Irrelevant for homeland campaigns. (Previously only used for in homeland: Divide homeland dateblocks into different languages on sign-up sheet for some conferences.) \|\| req. for international
Default sermon graphics language (Material ID)	dropdown; must be a CD set 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
Division secretaries	Comma-seperated list of e-mail addresses for one or more division secretaries. Eg. they receive e-mail reminding about insurance.
Comments	Extended public description of the date block
Note for applicants	Special information for potential applicants before applying
Application monitors	List of e-mail addresses (comma-seperated) to which an e-mail is sent everytime an application to this date block is submitted. Added because of problems in India where the division wants to monitor all applications, espacially STMs.
Hide date block details for the public?	yes/no Because of problems in India where the public should not be allowed seeing the information about the date block. \|\|
Media folder	Base folder for uploading media files (pictures, video etc.)
Show predefined unions only	yes/no Only show predefined organizations down to the union level (= excl. conferences) In connection with the table Date blocks' predefined conferences. \|\|
Active	yes/no

Date blocks' orientations

	Date block orientation ID
	Date block ID		req.
	Orientation ID		req.
	Orientation date

Date blocks' predefined conferences

This is used primarily before sites are added to the date block. After that we'll automatically know the conferences based on where the hotels are located. For homeland date blocks, though, we retain this information in order to have a quick way of determining the date blocks of a conference.

	Date block predefined conference ID
	Date block ID		req.
	Conference ID		req.

Campaign sites

Campaign site ID
Master campaign site ID	Record ID in master sites table that this site originates from
Date block hotel city ID		req.
Campaign date	- 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.	req. for homeland. currently prohibited for intl.
Campaign type	Possible options: - NULL : regular campaign - 'spk-init' : speaker-initiated campaign Homeland only.
Site name	- 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). Tried to name variable 'campaign_label' or 'homeland_label' when used in the homeland context.	see description
Beginning time	time (hh:mm:ss) Homeland only.	req. for spk-init events
Ending date	date Homeland only.	req. for spk-init events
Weekdays	Comma-separated list of 3-letter abbreviation of the weekdays the campaign will be held. Homeland only.	req. for spk-init events
Town/city		req.
Sector	NOT USED. We use the sector from the master site instead.
Address		Homeland: req. for spk-init events
State		Homeland: req. for spk-init events
Zip		Homeland: req. for spk-init events
Phone	Only used in intl. system
E-mail	Only used in intl. system
Website	Only used in intl. system
Venue type	church/rented hall/open field/stadium etc. according to table list_venue_types	Intl: always req. Homeland: req. for spk-init events
Personevent ID	Link to the speaker
Sermon graphics language	dropdown	req.
Life of Christ video language	dropdown	req.
Desired video format	NOT USED ANYMORE. No longer applicable because we now use DVDs instead of VHS tapes. dropdown
Congregations	number of congr. supp. this site Only used in intl. system.	req.
Membership	total members in supp. congr. Only used in intl. system.	req.
Est. attendance	incl. SDA & non-SDA	req.
Baptismal goal	conservative number	req.
Km from hotel		req.
Pastor Officer IDs	Comma-separated list of officerIDs. 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. \|\|
Ranking		req.
Comments
Planned pre-campaign activities	text Homeland only.
Campaign status	Possible options: - NULL - 'await_approv' Homeland only.
Active	yes/no
Copy of site ID	If this is a copy of another site the original site's ID is saved here

Outreach Teams - Previous: Master Campaign sites (main_master_sites)

List of Outreach Teams

Master site ID
SDA organization ID	Reference to the church this OLT belongs to	req. for all new records
Conference ID	Conference this OLT is in	req.
Name	Name of the OLT, usually the church name. Usually renamed to 'church_name2' in SQL output.
Person ID	In case a personal team is created this holds the link to the person (used for speaker-initiated campaigns)
Hotel ID	2009-11-16: deleted all values since homeland do not use hub cities anymore - field can be deleted entirely, once SQL queries have been checked - 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 \|\|
City	2010-11-01: Is officially no longer used but I didn't dare deleted it in the database yet. Delete it later. Search for "main_master_sites" to try to find location where it might still be used. \|\|
Graphics language	Default graphics language used within this OLT. Actually language is always decided by the site record.
Life of Christ video language	Default video language used within this OLT. Actually language is always decided by the site record.
Comments
Password	Password OLT members can use to access information for this OLT. Not really used at the moment.
Date added

Outreach Leadership Team members

Table with all memberships for the Outreach Leadership Teams (main_olts)

OLT member ID
Person ID	Person who is the member	req.
Master site ID	Team person is a member of	req.
Is OLT clerk?	yes/no
Date added		req. for all new records
Date removed	Once this field has a value the member is considered removed.

Churches

List of churches we have retrieved from AdventistDirectory.org and eAdventist.net (= SDA-DB)

	Church ID	Our own auto-generated ID
	SDA org ID	OrgMastID from SDA-DB
	SDA entity ID	OMEntity from SDA-DB
	Church name
	Street address
	Street city
	Street state
	Street zip
	Country	2-letter ISO-3166 country code
	Phone
	Language
	Ethnic group
	Sector	Our own sector value, set by the conference organizers
	Latitude
	Longitude
	Parent SDA AdmFieldID	ID of parent conference. (I believe we always have this one)
	Parent SDA OrgMastID	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?!
	Parent is not a conference?	yes/no
	Inactive?	yes/no
	Date added	Date added to our database.
	Date modifed	Date last modified in SDA-DB. Controls when we need to update this record.

Workers / Officers

List of officers (currently only pastors) we have retrieved from eAdventist.net (= SDA-DB) or other Adventist services/fields

Worker ID	Our own auto-generated ID
Conference ID	Conference the pastor is in. Not used for NAD conferences, since Officer ID (from eAdventist) is used. If we change use assign_pastor_to_church() must be reviewed.
Officer ID	ID originates from SDA-DB This is the same ID as main_people. sda_membershipID. Used only for records coming from eAdventist.net.	cond.
Local ID	The local conference's own ID for the person
First name		req.
Last name		req.
Suffix
Mailing address
Mailing city
Mailing state
Mailing zip
Mailing country	2-letter country name (ISO-3166)
E-mail
Alternative e-mail addresses	Comma-separated list (with space between comma and next address)	opt.
Cell phone
Allow SMS?	Is ShareHim allowed to send the pastor an SMS to notify him about new applicants from his church?
Person ID	Link to this person's record in our main people table if present.	opt.
Default password	Password that will be used to auto-create a login when this pastors tries to login
Date modified	Date last modified in SDA-DB. Controls when we need to update this record.	req.

Church offices

List of church offices (currently only pastors) we have retrieved from eAdventist.net (= SDA-DB)

	Church office ID	Our own auto-generated ID
	Church SDA org ID	OrgMastID of church
	Worker ID
	Officer ID	From main_officers table
	Office name	Name of office the person holds. 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) \|\|
	Is evangelistic decision-maker?	yes/no 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. \|\|
	Date modified	Last date this record was modified in our own database.

Campaign site statistics

Campaign site ID
Statistical data	serialize PHP array with statistics on attendance, Bible class attendance, and baptisms (only used for international)	req.
Baptisms during campaign	number Entered by the speakers. (only used for international)
Adjusted baptisms during campaign	number Entered by the coordinators.
Projected baptisms within 6 months after the campaign (EXCL. those during campaign)	number Entered by the speakers (only used for international)
Actual baptisms within 6 months after the campaign (EXCL. those during campaign)	number Entered by the coordinators.
Did campaign with OLT?	yes/no	Homeland only
Number of meetings	number	Homeland only
Number of visitors	number	Homeland only
Planning another campaign?	Possible values: 0 : no 1 : yes 2 : maybe	Homeland only

Campaign site statistics per conference

This data "overrides" data entered for each individual campaign site.

Conference date block statistics ID
Date block ID		req.
Conference ID		req.
Total baptisms during campaign in this conference	number
Baptisms within 6 months after the campaign in this conference (EXCL. those during campaign)	number

People

Guest speakers, support team members

Person ID
SDA membership ID	ID from eAdventist of OLT members and pastors. (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.")
Active person event ID
Legal firstname		req.
Legal lastname		req.
Title	dropdown Prefered to be set as the option "Pastor" is sometimes used to identify pastors.
Birth date		req.
Gender
Marital status	dropdown
Mailing address		req.
Mailing city		req.
Mailing state/province		req.
Mailing zipcode		req.
Street address	this is also their shipping address	req.
Street city		req.
Street state/province		req.
Street zipcode		req.
Country		req. 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.
E-mail	also their username Sometimes noemail@noemail.com or none@none.com has been put in if we don't know the address.	req. (except for special cases, eg. speakers assigned to past homeland campaigns, or check donations where we don't know the e-mail)
E-mail invalid	date 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.
Home phone	multiple formats Can have the value "Do not have" if person simply does not have this kind of number. \|\| At least one phone number is required.
Office phone	multiple formats Can have the value "Do not have" if person simply does not have this kind of number. \|\| At least one phone number is required.
Cell phone	multiple formats Can have the value "Do not have" if person simply does not have this kind of number. \|\| At least one phone number is required.
Residence division	dropdown	req.
Residence union	dropdown
Residence conference	dropdown
Residence church	text
Application date
Remmendation status	Possible values: (by sending fields/recommenders) - NULL (when not recom. processed) - waiting - recommended - unrecommended \|\|
Recommender	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 \|\|
Recommender comments
Graphics equipment request	Possible values: - not requested (0) - requested (1) - approved (2) - not available (3) \|\| req. for speakers
Sponsorship	(Voice of Prophecy)	req. for speakers
Sponsorship commitment form approved	when approved, show them on website
Sponsorship check sent date
Sermon notes language	dropdown VALIDATION: - check if this from-language is available within the desired date block. If not, give option to select another language. \|\| req. for speakers
Request hard copy notes	(this will effectively only be for their first event) Possible values: - not requested (0) - requested (1) - processed (2) \|\|
Preferred CD format	Possible values: - DVD (means using a DVD player) - DVD-R (means using a computer) (old values: CD, DVD-Combo) \|\| req. for speakers
Done boot camp?	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) \|\|
Done a campaign?	yes/no 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 campaign	text First ShareHim campaign that this person participated in as a speaker. Used for people applying for homeland campaigns. \|\|
Reference name	Pastoral applicants: ministerial sectary Lay applicants: pastor Academy students: academy & contact \|\| req. for speakers
Reference home phone	Pastoral applicants: ministerial sectary Lay applicants: pastor Academy students: academy & contact \|\| req. for speakers
Reference office phone	Pastoral applicants: ministerial sectary Lay applicants: pastor Academy students: academy \|\|
Reference cell phone	Pastoral applicants: ministerial sectary Lay applicants: pastor Academy students: academy \|\|
Reference e-mail	Pastoral applicants: ministerial sectary Lay applicants: pastor Academy students: academy \|\| req. for speakers
Password
Comments
Receive newsletter?	yes/no/null Is person signed up for the Evangeliving newsletter? NULL: setting has not been set \|\| opt.
Received mentorship material	yes/no Did we send them the mentorship material? \|\|
Portrait filename	File for thumbnail image used in stories.
Portrait is authorized?	yes/no
Outreach Leadership Team of master site ID	The church with this master site ID that this person is an OLT member of
Outreach Leadership Team special status	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. \|\|
Is editor?	Possible values: - executive (edit text/graphics, approve, add/delete stories) - associate (edit text/graphics) - text - graphics - advreview (Adventist Review editor) \|\|
Do not contact	date When person should not receive any correspondence or be contacted, register the date this was set. \|\|
Reason for not contacting	text (eg. do not want info from us, is deceased etc.) \|\| req. if "Do not contact" is set
Hide person from public?	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... \|\| req.
Person requested check for duplicate	Person indicated that they might already exist in our database.
Source	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) 99 : other manually added record

Person events

Person event ID
Person ID
Date block ID	Only for non-college/university applicants
Effective date block ID	Updated to always hold the effective date block ID for this event (also when event has been deleted)
Category	Possible values: - pastor - layman - college - academy - stm - organizer \|\|
College date block ID	Only for college/university applicants
Is standby	yes/no Is this a standby event? (Retained even though event is deleted) \|\|
Cluster ID	Only for speakers (the link to groups must of course match this link.) \|\|
Group ID	Only for speakers
Team ID	Only for STMs - linking them to their speaker (Team ID in main_teams)
Ranking ID
Associate speaker	yes/no (we know the main speaker by the team the associate speaker is member of) \|\|
Preferred hub city (date block hotel ID)	The hub city the person him/herself wishes to go to
Site-funding required	yes/no CURRENTLY NOT USED (use 'funding_required' instead) MAY NEED TO USE IT THOUGH, INSTEAD OF CALCULATING IT WITH A JOIN TO main_groups ALL THE TIME! Is currently only set a group level and must be determine through field table main_groups. grp_funding_source \|\|
Site-funding fulfilled	If fulfilled, it has the ID of the belonging log entry from sharehim_log.system_operations.operationID
Need housing?	yes/no Only used for homeland date blocks: Does the speaker need the host church to provide housing if the meeting is outside his area? \|\|
Acceptance status	Possible values: (by host fields) - NULL - accepted - rejected (Currently only used for homeland campaigns. Automatically accepted for international campaigns.) \|\|
Acceptance comments
Orientation, room ID	Other people having the same number will be staying in the same room
Orientation, private accommodation	yes/no
Hotel city, room ID	Other people having the same number will be staying in the same room
Hotel city, private accommodation	yes/no
Orientation city, flight arrival date		req. for suppl.
Orientation city, flight arrival time		req. for suppl.
Orientation city, airline		req. for suppl.
Orientation city, flight no.		req. for suppl.
Self-arranged travel to orientation	yes/no If yes none of the four fields above must be filled out \|\|
Hotel city, arrival airport
Hotel city, flight arrival date
Hotel city, flight arrival time
Hotel city, airline
Hotel city, flight no.
Last deposit reminder	Days after application date that this reminder was last sent
Last site-funding reminder	Days before opening date that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
Last hotel reservation reminder	Days before orientation that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
Last flight arrival reminder	Days before orientation that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
Last generic reminder	Days before orientation that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
Last equipment rental reminder	Days before orientation that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
Consent form for minors	NULL = not a minor 1 = pending receiving the consent form 2 = consent form received 3 = is minor, parent/guardian is coming too \|\|
No sermon notes	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) \|\|
Reported on the first insurance/service requests report that we sent out?	yes/no
Is deleted?	yes/no 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. \|\|
Is event request?	yes/no (when person does not fill out the main application form, value is not changed but kept forever event if event is deleted)
Date added	datetime (Retained even though event is deleted) \|\|
Date deposit received	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) \|\|
Date approved	datetime (by administration) 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) \|\|
Date standby expire	date The date the standby event will expire. \|\|
Date activated	datetime The date a standby event was activated. (Retained even though event is deleted) \|\|
Date deleted	datetime

Person comments

Internal comments only visible for administrators

Comment ID
Person ID		req.
Person event ID	Possible to reference a comment to a person's event	optional
Comment		req.
Comment type	Possible values: - 'phonecall' \|\| opt.
Flag	dropdown Possible values: - 1 : encourage mentorship - 2 : block all future participation - 3 : block future intl. participation - 4 : block future homeland participation \|\| optional
Date and time entered		req.
Submitter	Local ID of user from table below
From table	Origin table of this user

Personal salutations

Table with personal salutations for each user in the system

Person ID	The person the salutation is for	req.
From table	The table the "owner" of this salutation is from. Same format as $_SESSION['user_fromtable'] \|\| req.
From local ID	The ID from the table the "owner" of this salutation is from.	req.
Salutation	The salutation itself. Must be the full line.	req.

Colleges

	College ID
	Name
	Initials	Abbreviation of name
	Street address	For shipping equipment
	Street city
	Street state
	Street zip
	Country	dropdown
	Contact person
	Contact e-mail
	Contact phone
	Password	Use this to login and recommend students
	Comments
	Active	yes/no

Colleges' date blocks

Bob Sr, 2008-07: College date-block information must remain read-only for all except for the administrative few.

College date block ID
College ID		req.
Dateblock ID		req.
Person event ID (leader)	Only speakers	opt.
Student sites to reserve equip. for	numeric	req.
Funding source
Date site-funding received	date
Total site-funding amount received	number In USD. \|\|
Date travel funds requested	The date we requested Quiet Hour Ministries to send the travel funds to the college/students.	opt.
Last status reminder sent	date
Comments		opt.

Recommenders

Only for North-American division

	Recommender ID
	Firstname
	Lastname
	E-mail
	Phone
	Password
	Marker for last applicant	a marker so we can cycle through these recommenders
	Comments
	Active	yes/no

Translations

Per campaign site

	Translation ID
	Campaign site ID
	From language	dropdown acc. to available sermon notes language

Campaign material

Shipments that are due (or waiting for payment before they are due)

Shipment ID
Material ID
Personevent ID		req. to be a speaker
Shipper	A main_ext_logins.loginID reference
Paid	date Set to 2000-01-01 if payment is n/a \|\|
Postpone date	date This item will not shown on the shipping list until this date \|\|
Shipped date
Shipped method
Shipped tracking no.
Royalty billed	date Only used for graphics CDs, reporting to It Is Written \|\|

Clusters

Spanning over the whole date block. Clusters are a larger scope compared to groups. Groups can be linked to clusters. Only speakers can be members of clusters.

	Cluster ID
	Date block ID
	Cluster name	For homeland date blocks this is not used for anything really - other than it shows up on the campaign overview.
	Ranking enabled	yes/no (for ranking people)

Cluster leaders

	Cluster leader ID
	Cluster ID
	Person event ID (leader)	Speakers or organizers

Groups

Spanning over the whole date block. Only speakers can be members of groups

Group ID
Date block ID
Cluster ID
Person event ID (leader)	Only speakers
Group name
Contact name
Contact phone
Contact e-mail
Recommender personID
Reserved sites	Will effectively always be filled out.
Funding source (site-funding)	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 \|\| req.
Deposit received?	yes/no No one excepts organizers can apply before deposit has been received if funding source is 'individually'. \|\|
Partial payment date	date Has no effect if amount is not set or 0. \|\| opt.
Partial payment amount	number Has no effect if date is not set. \|\| opt.
Last site-fund reminder sent	date
Show group on availability report?	yes/no	req.
Max subdivide	Max number of hotel cities the group is allowed to span across. Default one.	req.
Ranking enabled?	yes/no (for ranking people)
Comments

Teams

Speaker linked with support team members

	Team ID
	Person event ID (speaker)

Orientation sites

Orientation ID
Date block ID
Orientation date		req.
Hotel name		req.
Hotel address		req.
Hotel address (line 2)		req.
Hotel country		req.
Hotel phone	multiple formats	req.
Hotel fax	multiple formats
Hotel e-mail
Hotel website
Price single room		req.
Price double room		req.
Price additional person	amount or n/a	req.
Breakfast included	yes/no (note next field)	req.
All meals included	yes/no	req.
Est. price additional meals		req.
Recomm. budget for meals outside hotel per day		req.
Aircondition	Possible values: - no (0) - yes (1) - not necessary (2) \|\| req.
Transportation	Info regarding getting to the orientation site	req.
Orientation comments	Public
Active	yes/no

Equipment booking

Booking of equipment Time frame of booking is decided by the period of the date block

Booking ID
College date block ID		req. if no person ID
Speaker ID (= Person ID)		req. if no college date block ID
Case ID
Booking date	The date the booking was made (just for the information)
Paid amount	Only for non-student related
Paid date	Set to 2000-01-01 if payment is n/a
Outbound date
Outbound method	dropdown
Outbound tracking no.	text (30)
Insurance	text (100) E-mail of person received the insurance information \|\|
Return date	Date it was sent from the renter
Return method	dropdown
Return tracking no.	text (30) If filled out it's a call tag, otherwise not \|\|
Return received date	Date it was received by ShareHim
Equipment checked	date
Equipment checked by initials	text (10)
Comments

Equipment stock, cases

	Case ID	Manually entered and unique ID from inventory labels
	Laptop ID
	Projector ID
	Case serial no.	text (30)
	Case purchase date
	Case value
	Invoice no.	text (15)
	Check no.	numeric (15)
	Comments
	Down	date When the case is under repair or for another reason is not available for booking \|\|
	Down status
	Discharged	date When the case has been sold and we no longer have anything to do with it \|\|
	Discharged status

Equipment stock, laptops

	Laptop ID
	Inventory ID	Manually entered and unique ID from inventory labels
	Equipment base ID	ID of the equipment base where we administrate a set of graphics equipment
	Model no.	text (30)
	Description	text (30)
	Serial no.	text (30)
	OS product key	text (30)
	Office product key	text (30)
	Service Tag	text (30)
	Express service code	text (30)
	Purchase date	date
	Laptop value	numeric
	Warranty type	dropdown: - Next day service - Next day service + complete care \|\|
	Warranty expiration date	date
	Quote no.	text (15)
	Invoice no.	text (15)
	Check no.	numeric (15)
	Comments	text
	Down	date When the laptop is under repair or has been sold and hence not available for booking \|\|
	AC adapter	yes/no
	Remote control	yes/no Remote control for mouse \|\|
	Floppy drive	yes/no

Equipment stock, projectors

	Projector ID
	Inventory ID	Manually entered and unique ID from inventory labels
	Model no.	text (30)
	Description	text (30)
	Serial no.	text (30)
	Warranty expiration date	date
	Purchase date	date
	Projector value
	Invoice no.	text (15)
	Check no.	numeric (15)
	Comments
	Down	date
	Power cord	yes/no
	Remote control	yes/no
	VGA cable	yes/no
	VCR cable	yes/no
	International adapters	yes/no
	Ground adapter	yes/no
	Extension cord	yes/no

Material stock

Sermon notes/graphics, Life of Christ videos, etc. Note: The Life of Christ videos that are active and have no format were previously those records that were the PAL version. The inactive NTSC versions are kept for historic purposes.

	Material ID
	Material group	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 \|\|
	Name
	Code	Short easy-to-read code identifying this product to use it when printing labels
	Language	dropdown
	Format	NTSC/PAL/SECAM CD/(DVD/VCD) \|\|
	Qty in stock
	Minimum qty in stock	Espacially for Life of Christ videos
	Available from	Date from which this material will be available
	Royalty organization	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 \|\|
	Shipper	ID of shipper (from external logins) (blank/null if internal)
	Active	yes/no

Stories

Story ID
Date block ID		req.
Story type	dropdown - sitereport (report about campaign site) - testimonial (personal testimony) \|\| req.
Campaign site ID
Person event ID	PersoneventID of the person who created this story, speaker or STMs
Purpose	dropdown: - public (for publishing on website) - internal (raw material for internal use) \|\| req.
Headline	self made headline/title on story
Narrative		req.
Copy of Narrative	Copy of narrative before people changes an authorized story.
Keywords	Optional additional keywords used when searching
Author name
Contact name	Person to contact for further information about this story.
Contact phone	Person to contact for further information about this story.
Contact e-mail	Person to contact for further information about this story.
Author notes	Scratch-board for author and/or editors. Not shown publicly.
Internal notes	Scratch-board for editors.
Narrative authorized	date Don't display the story in public before it's authorized \|\|
Pictures authorized	date
Content authorized	date Don't display the story in public before it's authorized \|\|
Authorized for display on Adventist Review website?	yes/no (set by ShareHim)
Approved for display on Adventist Review website?	null/yes/no (set by Adventist Review) Labels: Approved/Disabled/Not reviewed \|\|
Show thumbnail? (for testimonies)	yes/no Show thumbnail of person (of course only effective if thumbnail is uploaded) \|\|
Is news item?	yes/no
Show from (only news items)	date (from now if blank) Date is inclusive. \|\|
Show to (only news items)	date (indefinitely if blank) Date is exclusive. \|\|
Date added	datetime	req.
Date last modified	datetime	req.

Story pictures

Attached to the stories

Picture ID
Story ID		req.
Caption	long text	req.
Filename (given by the system)		req.
Original filename		req.
Is retouched?	yes/no Set to yes when original picture was retouched, either manually or cropped - as intermediate stage between original and final picture \|\| req.
Sorting ID	For rearranging the order of pictures
Upload date		req.
Active	yes/no

Surveys

Evaluation forms filled out by the speakers and STMs.

Survey ID
Date block ID		req.
Person event ID		req.
No. of campaigns participated in	Number of campaigns the person has participated in to date.	req.
[questions] x13	1-5 or null
Comments
Date added	date	req.
Is reviewed?	yes/no	req.

Donations

Received donations

	Donation ID
	Person ID
	Date received
	Donation amount
	Donation type
	Pledge ID

	...many more fields

	Receipt sent	Date receipt was sent. If we don't know the date it is set to 2001-01-01. \|\|
	Thank-you letter sent method	Possible values: - letter - email - authorize.net \|\|
	Thank-you letter sent	Date letter was sent. If no letter was sent date is set to 2000-01-01. \|\|
	Follow-Up done?	yes/no Used for non-sitefunding donations only \|\|

External logins

E.g. Caroline Conference, Quiet Hour, shippers

Login ID
Local ID	numeric (ID from div, un, conf etc.)
Firstname
Lastname
Password
E-mail
Address 1
Address 2
Phone
Alternative/local phone	An alternative phone number to campaign managers, mainly for entering local phone numbers that they use when they supervise campaigns.	opt.
Alternative/local phone until	The last date that the phone number is scheduled to be usable.	req. if phone number is specified
Access level	dropdown
Superadmin	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 \|\|
Fulltime	yes/no If coadmins are full-time or part-time managers \|\|
Approved	yes/no
Active
Comments

Password questions

	Table
	Local ID
	Question
	Answer

Field descriptions

	Description ID
	Table name
	Field name
	Public description
	Internal description

News

Information shown on the main page of the website

News ID
Headline		req.
Story		req.
ShowFrom	date
ShowTo	date
Show all on home?	yes/no Show entire news item on the front page? (normally there is a max length for items shown there) \|\| req.

ShareSynch Serial Numbers

Created serial numbers for the ShareSynch software

Serial Number ID	Internal ID
Serial Number	GS)-XXXX-XXXX	req.
Expiration date	date
Person ID	Person this serial number is connected to
Person event ID	Event this serial number is connected to (and that usually causes an expiration date)
Owner name
Owner e-mail
Activations allowed		req.
Is printed?		req.
Date created
Comments

ShareSynch activations

Activations that have been done for the different ShareSynch serial numbers

Activation ID
Serial Number		req.
Hardware ID		req.
Activation Code		req.
Activation date	timestamp	req.
Activation IP		req.
Hardware Operating System
ShareSynch software version
Reactivation dates	The dates this activation code was resent or reactivated
Is withdrawn?	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...) \|\| req.
Comments

System settings

	System administrator name	General
	System administrator e-mail	General
	E-mail sender name	Name that will appear as sender on all e-mail automatically sent by the system
	E-mail sender e-mail	E-mail that will appear as sender on all e-mail automatically sent by the system
	Days to resend unprocessed applicant	Days after application date to resend recommendation e-mails for unprocessed applicants
	Days to mark unproccessed applicant	Number of days until applicant will be highlighted as 'not processed' in the unapproved applicants list
	Days before orientation to ship Life of Christ video	Days before orientation date that we issue the shipment
	Days after date block closing date to remind about entering experience	Only used for those who have received sponsorship
	Days before opening date to send out e-mail reminding insurance coverage
	Days before opening date to send out e-mail reminding service requests
	E-mail recipient (name) of info on insurance coverage for participants
	E-mail recipient (e-mail) of info on insurance coverage for participants
	Insurance information e-mail recipient	E-mail to which we send insurance information on shipped equipment
	Case lock combination	numeric (3) Case lock on equipment cases \|\|
	Min. days to opening date to allow person use key for bypassing closing date (because of insurance and service requests reports/reminders, so should therefore always be before we send out the last insurance/serv. req. reminder)

E-mail templates

E-mail templates for e-mails that are sent out automatically

	E-mail template ID
	Reference name	identification name for this template
	Subject	Subject for the e-mail
	Body	Body for the e-mail

Email log, group e-mails

E-mails sent to group will be logged here

	Log ID
	Date
	Time
	Name
	E-mail
	Mail reference	reference to the mail sent (an ID or a file reference)
	Local ID	numeric (ID from div, un, conf etc.)
	From table	the table the user originates from

Email log, service requests reports

E-mails sent to group will be logged here

	Log ID
	Date
	Time
	Local ID	numeric (ID from div, un, conf etc.)
	From table	the table the user originates from
	E-mail
	CC	Carbon Copy recipients
	Attached files	)
	Date block ID
	Target	"host" or "sending" organization (division/union/conference)
	Batch	"first" or "second" batch of reports to this organization

Mail queue

Queues of e-mails that have been or are being sent

	Mail queue ID
	By local ID	User who made the queue
	By from table	User who made the queue
	Sender name
	Sender e-mail
	Query ID	Query ID that this queue is based upon. In case we want to make queues that are special and not based on a query this can just be left empty. \|\|
	Custom subject
	Attach files	Serialized PHP array with documents to attach to the e-mails in this queue.
	Use personal salutations?	yes/no
	Date added	datetime
	Date completed	datetime Is set when all e-mails in this queue have been sent. \|\|

System translations

Pieces of text used in the interface and which can be translated into other languages

	Translation ID
	Category	Not really used
	Tag	The tag use in the PHP code
	Langugage [en\|es\|da\|...]	The text for this tag in the given language
	Sorting ID	Not used
	Explanation	Any useful instructions for the translator about this piece of text
	Date modified	Timestamp for when the text or tag for the primary language (English) was last modified

System translators

Queues of e-mails that have been or are being sent

	Translator ID
	Language	Two-letter abbreviation for the language
	Person ID	Person ID from main_people of the person who is the translator for this language. Set to 0 if we currently have no translator. \|\|
	Last notified	Last time translator was notified about new or changed text to be translated

System log

Table is placed in a separate database.

Operation ID
Date		Req.
Time		Req.
By name	Name of user who caused this operation	Req. if avail.
By local ID	...his local ID	Req. if avail.
By from table	...originates from this table Note: Because of programming mistake this field has incorrect values until 2006-08-22 after a user has emulated somebody. Unsure when problem started (maybe 2006-06-08 or 2006-03-27). \|\| Req. if avail.
Visit ID	VisitID from WebStory statistics
IP	User's IP address at time of logging
Emulated by	Full name of person who was emulating
Action	Main name for for this action	Req.
Subaction	Subname for this action
For name	Name of user/record this action was executed upon NOTE: This can be either firstname lastname or lastname, firstname \|\|
For local ID	...caused upon this ID in the table below
For from table	...caused upon a record in this table
Person event ID	PersoneventID of person it was caused upon (if applicable)
Date block ID	DateblockID that this action is related to (if applicable)
Parameters	Any extra parameters to log. Default format: field=value¤field=value...

If a field is fit for having a value but we don't have it readily available when making the logentry then we set the value to "N/A" (or "0" for number fields) so that we later can run some queries to easily replace all these "missing" information pieces.

List tables

Venue types

- eg.: Church, open field etc. - 'venueno' only added and sorted by for the sake of Tamara entering the data

Countries

- connected to which division it's in - including the ISO-3166 two-letter codes (where codes starting with underscore (_) is self-made in order to not have empty field) - do NOT change values here without thinking of implications to the system - certain country names are used hard-coded in the script code (eg. ship_material.php) - as of 2006-09-21 used in: - main_divisions - main_unions - main_conferences - main_orientations - main_hotels - main_colleges - main_people - the divisionID is taken from Jon Brauer's XML file "2006-08 OMCountries (Jon Brauer).xml".

Currencies

- code, name, rate, date of rate, and source of rate

Material groups

- eg.: Sermon notes, Graphics CD, Life of Christ video - make no possibility to edit records, only add (and maybe delete) - do NOT change values here without thinking of implications to the system - certain material groups are used hard-coded in the script code (ship_material.php)

Equipment bases

- the different locations at which we administrate a set of graphics equipment, eg. North Carolina

Shipping methods

- eg.: UPS, FedEx

US states

Titles

- eg.: Mr., Mrs. etc.

Access levels

- eg.: admin etc.

@@ Line 7: / Line 7: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | divisionID<br>
 | Division ID
 | <br>
 | req.
 |-
 | name<br>
 | Name
 | <br>
 | req.
 |-
 | initials<br>
 | Initials
 | 3-letter abbreviation
 | req.
 |-
 | mailing_addr<br>
 | Mailing address
 | <br>
 | <br>
 |-
 | mailing_city<br>
 | Mailing city
 | <br>
 | <br>
 |-
 | mailing_state<br>
 | Mailing state/province
 | <br>
 | <br>
 |-
 | mailing_zip<br>
 | Mailing zipcode
 | <br>
 | <br>
 |-
 | street_addr<br>
 | Street address
 | <br>
 | <br>
 |-
 | street_city<br>
 | Street city
 | <br>
 | <br>
 |-
 | street_state<br>
 | Street state/province
 | <br>
 | <br>
 |-
 | street_zip<br>
 | Street zipcode
 | <br>
 | <br>
 |-
 | country<br>
 | Country
 | <br>
 | <br>
 |-
 | phone<br>
 | Phone number
 | multiple formats
 | <br>
 |-
 | fax<br>
 | Fax
 | multiple formats
 | <br>
 |-
 | coord_name<br>
 | Campaign coordinator
 | <br>
 | <br>
 |-
 | coord_office_phone<br>
 | Coord. office phone
 | multiple formats
 | <br>
 |-
 | coord_home_phone<br>
 | Coord. home phone
 | multiple formats
 | <br>
 |-
 | coord_cell_phone<br>
 | Coord. cell phone
 | multiple formats
 | <br>
 |-
 | coord_email<br>
 | Coord. e-mail
 | <br>
 | <br>
 |-
 | coord_pw<br>
 | Coord. password
 | <br>
 | <br>
 |-
 | coord_approved<br>
 | Coord. approved
 | yes/no
 | <br>
 |-
 | division_secretaries<br>
 | Division officers
 | Comma-seperated list of e-mail addresses to which the service requests reminder will also be sent to.
 | <br>
 |-
 | comments<br>
 | Comments
 | <br>
 | <br>
 |-
 | active<br>
 | Active
 | yes/no
@@ Line 128: / Line 128: @@
 |}
 <br>
-== Unions (main_unions)<br> ==
+== Unions (main_unions)<br>  ==
 List of all the unions within the 13 world divisions. Occasionally we pull the data from AdventistDirectory to update our list of unions.<br>
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | unionID<br>
 | Union ID
 | <br>
 | <br>
 |-
 | sda_orgID<br>
 | SDA organisation ID
 | 4-letter abbreviation originating from adventistdirectory.org
 | <br>
 |-
 | divisionID<br>
 | Division ID
 | Division this union belongs to<br>
 | <br>
 |-
 | name<br>
 | Name
 | <br>
 | <br>
 |-
 | <br>
 | Mailing address
 | <br>
 | <br>
 |-
 | <br>
 | Mailing city
 | <br>
 | <br>
 |-
 | <br>
 | Mailing state/province
 | <br>
 | <br>
 |-
 | <br>
 | Mailing zipcode
 | <br>
 | <br>
 |-
 | <br>
 | Street address
 | <br>
 | <br>
 |-
 | <br>
 | Street city
 | <br>
 | <br>
 |-
 | <br>
 | Street state/province
 | <br>
 | <br>
 |-
 | <br>
 | Street zipcode
 | <br>
 | <br>
 |-
 | <br>
 | Country
 | <br>
 | <br>
 |-
 | <br>
 | Phone number
 | multiple formats
 | <br>
 |-
 | <br>
 | Fax
 | multiple formats
 | <br>
 |-
 | <br>
 | Campaign coordinator
 | <br>
 | <br>
 |-
 | <br>
 | Coord. office phone
 | multiple formats
 | <br>
 |-
 | <br>
 | Coord. home phone
 | multiple formats
 | <br>
 |-
 | <br>
 | Coord. cell phone
 | multiple formats
 | <br>
 |-
 | <br>
 | Coord. e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Coord. password
 | <br>
 | <br>
 |-
 | <br>
 | Coord. approved
 | yes/no
 | <br>
 |-
 | <br>
 | Union officers
 | Comma-seperated list of e-mail addresses to which the service requests reminder will also be sent to.
 | <br>
 |-
 | <br>
 | Is participant in homeland program?
 | yes/no
@@ Line 257: / Line 257: @@
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Active
 | yes/no
@@ Line 268: / Line 268: @@
 |}
-== Conferences or missions  ==
+<br>
+== Conferences or missions (main_conferences)<br>  ==
+List of SDA conferences/missions/fields.<br>
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Conference/mission ID
 | <br>
 | <br>
 |-
 | <br>
 | SDA organisation ID (AdmFieldID)
 | 4-letter abbreviation originating from adventistdirectory.org
 | <br>
 |-
 | <br>
 | SDA OrgMastID
 | 6-letter abbreviation originating from adventistdirectory.org. This is the master ID from eadventist.com.
 | <br>
 |-
 | <br>
 | Union ID
 | <br>
 | <br>
 |-
 | <br>
 | Name
 | <br>
 | <br>
 |-
 | <br>
 | Name contracted
 | Short name for the conference. Used in homeland system.
 | <br>
 |-
 | <br>
 | Mailing address
 | <br>
 | <br>
 |-
 | <br>
 | Mailing city
 | <br>
 | <br>
 |-
 | <br>
 | Mailing state/province
 | <br>
 | <br>
 |-
 | <br>
 | Mailing zipcode
 | <br>
 | <br>
 |-
 | <br>
 | Street address
 | <br>
 | <br>
 |-
 | <br>
 | Street city
 | <br>
 | <br>
 |-
 | <br>
 | Street state/province
 | <br>
 | <br>
 |-
 | <br>
 | Street zipcode
 | <br>
 | <br>
 |-
 | <br>
 | Country
 | <br>
 | <br>
 |-
 | <br>
 | Phone number
 | multiple formats
 | <br>
 |-
 | <br>
 | Fax
 | multiple formats
 | <br>
 |-
 | <br>
 | Conference e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Campaign coordinator
 | <br>
 | <br>
 |-
 | <br>
 | Coord. office phone
 | multiple formats
 | <br>
 |-
 | <br>
 | Coord. home phone
 | multiple formats
 | <br>
 |-
 | <br>
 | Coord. cell phone
 | multiple formats
 | <br>
 |-
 | <br>
 | Coord. e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Coord. password
 | <br>
 | <br>
 |-
 | <br>
 | Coord. approved
 | yes/no
 | <br>
 |-
 | <br>
 | Conference officers
 | Comma-seperated list of e-mail addresses to which the service requests reminder will also be sent to.
 | <br>
 |-
 | <br>
 | Participant in homeland program?
 | yes/no
 | <br>
 |-
 | <br>
 | Churches &amp; pastors synchronization setting
 |
@@ Line 418: / Line 422: @@
 | <br>
 |-
 | <br>
 | Allow pastor to do final acceptance of new applicants?
 |
 yes/no
 &nbsp;: pastoral approval<br>0&nbsp;: pastor's recommendation, conference-staff final approval<br>
 (fieldname should have been allow_pastors_approve_speakers!)
@@ Line 429: / Line 433: @@
 | <br>
 |-
 | <br>
 | Last updated via eAdventist
 | For non-NAD conferences this indicates last time we updated the '''church''' list from AdventistDirectory.org
 | <br>
 |-
 | <br>
 | Internal comments
 | ONLY coadmin and admin may see/edit this.
 | <br>
 |-
 | <br>
 | Public comments
 | <br>
 | <br>
 |-
 | <br>
 | World map, X-coordinate
 | For the Flash world map
 | <br>
 |-
 | <br>
 | World map, Y-coordinate
 | For the Flash world map
 | <br>
 |-
 | <br>
 | Active
 | yes/no
@@ Line 466: / Line 470: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Conference/mission ID
 | <br>
 | <br>
 |-
 | <br>
 | SWIFT code
 | Only SWIFT or ABA can be filled.
 | cond.
 |-
 | <br>
 | ABA number
 | Only SWIFT or ABA can be filled.
 | cond.
 |-
 | <br>
 | Bank account no.
 | <br>
 | req.
 |-
 | <br>
 | Name of account holder/owner
 | <br>
 | req.
 |-
 | <br>
 | Address of account holder
 | <br>
 | req.
 |-
 | <br>
 | Bank name
 | <br>
 | req.
 |-
 | <br>
 | Bank location
 | <br>
 | req.
 |-
 | <br>
 | Use correspondent/intermediary bank?
 | yes/no
 | req.
 |-
 | <br>
 | Correspondent bank name
 | <br>
 | <br>
 |-
 | <br>
 | Correspondent bank location
 | <br>
 | <br>
 |-
 | <br>
 | Correspondent SWIFT code
 | Only SWIFT or ABA can be filled.
 | <br>
 |-
 | <br>
 | Correspondent ABA number
 | Only SWIFT or ABA can be filled.
 | <br>
 |-
 | <br>
 | Account no. of beneficiary's bank (the bank above) at the correspondent bank
 | <br>
 | <br>
 |}
@@ Line 543: / Line 547: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Conference acceptance ID
 | <br>
 | <br>
 |-
 | <br>
 | Person ID
 | <br>
 | req.
 |-
 | <br>
 | Conference ID
 | <br>
 | req.
 |-
 | <br>
 | Acceptance status
 |
 Possible values:<br>- waiting<br>- accepted<br>- rejected
 | req.<br>
 |-
 | <br>
 | Acceptance comments
 | Values set by the system:<br>
@@ Line 579: / Line 583: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Hotel city ID
 | <br>
 | <br>
 |-
 | <br>
 | Conference/mission ID
 | Only used for homeland (some hub cities for international campaigns also contain a conference because ALL records were assigned the ID when we created this field)
 | req. for homeland
 |-
 | <br>
 | City
 | <br>
 | <br>
 |-
 | <br>
 | Hotel name
 | <br>
 | req.
 |-
 | <br>
 | Hotel address
 | <br>
 | req.
 |-
 | <br>
 | Hotel address (line 2)
 | <br>
 | req.
 |-
 | <br>
 | Hotel country
 | <br>
 | req.
 |-
 | <br>
 | Hotel phone
 | multiple formats
 | req.
 |-
 | <br>
 | Hotel fax
 | multiple formats
 | <br>
 |-
 | <br>
 | Hotel e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Hotel website
 | <br>
 | <br>
 |-
 | <br>
 | Price single room
 | <br>
 | req.
 |-
 | <br>
 | Price double room
 | <br>
 | req.
 |-
 | <br>
 | Price additional person
 | amount or n/a
 | req.
 |-
 | <br>
 | Breakfast included
 | yes/no (note next field)
 | req.
 |-
 | <br>
 | All meals included
 | yes/no
 | req.
 |-
 | <br>
 | Est. price additional meals
 | <br>
 | req.
 |-
 | <br>
 | Recomm. budget for meals outside hotel per day
 | <br>
 | req.
 |-
 | <br>
 | Aircondition
 |
-Possible values:<br>- 0 : no<br>- 1 : yes<br>- 2 : not necessary
+Possible values:<br>- 0&nbsp;: no<br>- 1&nbsp;: yes<br>- 2&nbsp;: not necessary
 | req.<br>
 |-
 | <br>
 | Transportation
 | Info regarding getting from orientation to hotel city
 | req.
 |-
 | <br>
 | Comments
 | Public
 | <br>
 |-
 | <br>
 | Is non-hotel?
 | yes/no
@@ Line 693: / Line 697: @@
 | <br>
 |-
 | <br>
 | Active
 | yes/no
@@ Line 699: / Line 703: @@
 |}
 <br>
 == Date blocks' hotels (main_dateblockhotels)  ==
@@ Line 705: / Line 709: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Date block hotel city ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | req.
 |-
 | <br>
 | Hotel city ID (= hub city)
 | <br>
 | req.
 |-
 | <br>
 | Cluster ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block orientation ID
 | Optional and ONLY used for linking a specific orientation to this hotel city in case the date block has multiple orientation sites.
@@ Line 735: / Line 739: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Date block ID
 | <br>
 | <br>
 |-
 | <br>
 | Opening date
 | <br>
 | req.
 |-
 | <br>
 | Closing date
 | <br>
 | req.
 |-
 | <br>
 | Applications closing date
 | Should be the final cut-off date for new applicants.
@@ Line 757: / Line 761: @@
 | req.<br>
 |-
 | <br>
 | Data lock date
 | After this date only administrators and co-administrators will be allowed to change all data concerning a date block:<br>
 - teams<br>- groups<br>- site info (incl. translations)<br>- hotel info<br>- orientation hotel info<br>- rank sites<br>- rank speakers
@@ Line 770: / Line 774: @@
 | req.<br>
 |-
 | <br>
 | Campaign title (Homeland: Additional label)
 | Usually the country wherein the campaigns will be held.
@@ Line 777: / Line 781: @@
 | req. for international<br>opt. for homeland<br>
 |-
 | <br>
 | Total sites
 | Total number of campaign sites in this date block - must ALWAYS be kept up-to-date as available sites are calculated from this.
 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...
-|
+| <br>
 |-
 | <br>
 | Questions recipient
 | LoginID of the person from External logins who will receive questions about this date block. This person will also be the lead date block manager.
 | <br>
 |-
 | <br>
 | Pre-campaign manager
 | LoginID of a coadmin person from External logins who will be the pre-campaign manager if different from the lead manager.
 | <br>
 |-
 | <br>
 | Insurance reminder sent date, 1st
 | <br>
 | <br>
 |-
 | <br>
 | Insurance reminder sent date, 2nd
 | <br>
 | <br>
 |-
 | <br>
 | Service requests reminder sent date, 1st
 | <br>
 | <br>
 |-
 | <br>
 | Service requests reminder sent date, 2nd
 | Just before the campaign
 | <br>
 |-
 | <br>
 | Last incomplete notification
 | The date we last sent a notification to unions/conferences/campaign manager about incomplete information entered for this date block (if any)
 | <br>
 |-
 | <br>
 | Default sermon notes language (Material ID)
 | dropdown; must be a CD set
@@ Line 825: / Line 829: @@
 |-
 | <br>
 | Default sermon graphics language (Material ID)
 | dropdown; must be a CD set
@@ Line 831: / Line 835: @@
 |-
 | <br>
 | Division secretaries
 | Comma-seperated list of e-mail addresses for one or more division secretaries. Eg. they receive e-mail reminding about insurance.
 | <br>
 |-
 | <br>
 | Comments
 | Extended public description of the date block
 | <br>
 |-
 | <br>
 | Note for applicants
 | Special information for potential applicants before applying
 | <br>
 |-
 | <br>
 | Application monitors
 | List of e-mail addresses (comma-seperated) to which an e-mail is sent everytime an application to this date block is submitted. Added because of problems in India where the division wants to monitor all applications, espacially STMs.
 | <br>
 |-
 | <br>
 | Hide date block details for the public?
 | yes/no
@@ Line 857: / Line 861: @@
 |-
 | <br>
 | Media folder
 | Base folder for uploading media files (pictures, video etc.)
 | <br>
 |-
 | <br>
 | Show predefined unions only
 | yes/no
@@ Line 868: / Line 872: @@
 |-
 | <br>
 | Active
 | yes/no
@@ Line 878: / Line 882: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Date block orientation ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | req.
 |-
 | <br>
 | Orientation ID
 | <br>
 | req.
 |-
 | <br>
 | Orientation date
 | <br>
 | <br>
 |}
@@ Line 905: / Line 909: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Date block predefined conference ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | req.
 |-
 | <br>
 | Conference ID
 | <br>
 | req.
 |}
@@ Line 925: / Line 929: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Campaign site ID
 | <br>
 | <br>
 |-
 | <br>
 | Master campaign site ID
 | Record ID in master sites table that this site originates from
 | <br>
 |-
 | <br>
 | Date block hotel city ID
 | <br>
 | req.
 |-
 | <br>
 | Campaign date
-| - 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.''' &#124;&#124; req. for homeland. currently prohibited for intl.
+- Homeland: the date from the matching record in main_dateblocks<br>- International: null<br>
+'''This field can currently be used to determine if the campaign site is homeland or international.'''<br>
+| req. for homeland.<br>currently prohibited for intl. <br>
 |-
 | <br>
 | Campaign type
-| Possible options
+|
-- NULL - 'spk-init' Homeland only. &#124;&#124;
+Possible options:<br>- NULL&nbsp;: regular campaign<br> - 'spk-init'&nbsp;: speaker-initiated campaign
+Homeland only.
 |-
 | <br>
 | Site name
-| - 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). Tried to name variable 'campaign_label' or 'homeland_label' when used in the homeland context. &#124;&#124; see description
+- International: full site name (req.)<br>- 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).
+Tried to name variable 'campaign_label' or 'homeland_label' when used in the homeland context.
+| see description
 |-
 | <br>
 | Beginning time
 | time (hh:mm:ss)
-Homeland only. &#124;&#124; req. for spk-init events
+Homeland only.
+| req. for spk-init events
 |-
 | <br>
 | Ending date
 | date
-Homeland only. &#124;&#124; req. for spk-init events
+Homeland only.
+| req. for spk-init events
 |-
 | <br>
 | Weekdays
 | Comma-separated list of 3-letter abbreviation of the weekdays the campaign will be held.
-Homeland only. &#124;&#124; req. for spk-init events
+Homeland only.
+| req. for spk-init events
 |-
 | <br>
 | Town/city
 | <br>
 | req.
 |-
 | <br>
 | Sector
 | NOT USED. We use the sector from the master site instead.
 | <br>
 |-
 | <br>
 | Address
 | <br>
 | Homeland:
 req. for spk-init events
 |-
 | <br>
 | State
 | <br>
 | Homeland:
 req. for spk-init events
 |-
 | <br>
 | Zip
 | <br>
 | Homeland:
 req. for spk-init events
 |-
 | <br>
 | Phone
 | Only used in intl. system
 | <br>
 |-
 | <br>
 | E-mail
 | Only used in intl. system
 | <br>
 |-
 | <br>
 | Website
 | Only used in intl. system
 | <br>
 |-
 | <br>
 | Venue type
 | church/rented hall/open field/stadium etc. according to table list_venue_types
@@ Line 1,029: / Line 1,044: @@
 |-
 | <br>
 | Personevent ID
 | Link to the speaker
 | <br>
 |-
 | <br>
 | Sermon graphics language
 | dropdown
 | req.
 |-
 | <br>
 | Life of Christ video language
 | dropdown
 | req.
 |-
 | <br>
 | Desired video format
 | NOT USED ANYMORE. No longer applicable because we now use DVDs instead of VHS tapes.
-dropdown &#124;&#124;
+dropdown
-|-
 | <br>
+|-
+| <br>
 | Congregations
 | number of congr. supp. this site
-Only used in intl. system. &#124;&#124; req.
+Only used in intl. system.
+| req.<br>
 |-
 | <br>
 | Membership
 | total members in supp. congr.
-Only used in intl. system. &#124;&#124; req.
+Only used in intl. system.
+| req.<br>
 |-
 | <br>
 | Est. attendance
 | incl. SDA &amp; non-SDA
 | req.
 |-
 | <br>
 | Baptismal goal
 | conservative number
 | req.
 |-
 | <br>
 | Km from hotel
 | <br>
 | req.
 |-
 | <br>
 | Pastor Officer IDs
 | Comma-separated list of officerIDs.
@@ Line 1,083: / Line 1,101: @@
 |-
 | <br>
 | Ranking
 | <br>
 | req.
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Planned pre-campaign activities
 | text
-Homeland only. &#124;&#124;
+Homeland only.
 |-
 | <br>
 | Campaign status
-| Possible options:
+|
-- NULL - 'await_approv' Homeland only. &#124;&#124;
+Possible options:<br>- NULL<br>- 'await_approv'<br>
+Homeland only.
 |-
 | <br>
 | Active
 | yes/no
 | <br>
 |-
 | <br>
 | Copy of site ID
 | If this is a copy of another site the original site's ID is saved here
@@ Line 1,116: / Line 1,136: @@
 |}
-== Outreach Leadership Teams (Former name: Master Campaign sites)  ==
+<br>
-List of Outreach Leadership Teams (main_master_sites)
+== Outreach Teams - Previous: Master Campaign sites (main_master_sites)  ==
+List of Outreach Teams<br>
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Master site ID
 | <br>
 | <br>
 |-
 | <br>
 | SDA organization ID
 | Reference to the church this OLT belongs to
 | req. for all new records
 |-
 | <br>
 | Conference ID
 | Conference this OLT is in
 | req.
 |-
 | <br>
 | Name
-| Name of the OLT, usually the church name.
+|
-Usually renamed to 'church_name2' in SQL output. &#124;&#124;
+Name of the OLT, usually the church name.
+Usually renamed to 'church_name2' in SQL output.
 |-
 | <br>
 | Person ID
 | In case a personal team is created this holds the link to the person (used for speaker-initiated campaigns)
 | <br>
 |-
 | <br>
 | Hotel ID
 | 2009-11-16: deleted all values since homeland do not use hub cities anymore - field can be deleted entirely, once SQL queries have been checked
@@ Line 1,154: / Line 1,178: @@
 |-
 | <br>
 | City
 | 2010-11-01: Is officially no longer used but I didn't dare deleted it in the database yet. Delete it later.
@@ Line 1,160: / Line 1,184: @@
 |-
 | <br>
 | Graphics language
 | Default graphics language used within this OLT. Actually language is always decided by the site record.
 | <br>
 |-
 | <br>
 | Life of Christ video language
 | Default video language used within this OLT. Actually language is always decided by the site record.
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Password
 | Password OLT members can use to access information for this OLT. Not really used at the moment.
 | <br>
 |-
 | <br>
 | Date added
 | <br>
 | <br>
 |}
@@ Line 1,192: / Line 1,216: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | OLT member ID
 | <br>
 | <br>
 |-
 | <br>
 | Person ID
 | Person who is the member
 | req.
 |-
 | <br>
 | Master site ID
 | Team person is a member of
 | req.
 |-
 | <br>
 | Is OLT clerk?
 | yes/no
 | <br>
 |-
 | <br>
 | Date added
 | <br>
 | req. for all new records
 |-
 | <br>
 | Date removed
 | Once this field has a value the member is considered removed.
@@ Line 1,229: / Line 1,253: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Church ID
 | Our own auto-generated ID
 | <br>
 |-
 | <br>
 | SDA org ID
 | OrgMastID from SDA-DB
 | <br>
 |-
 | <br>
 | SDA entity ID
 | OMEntity from SDA-DB
 | <br>
 |-
 | <br>
 | Church name
 | <br>
 | <br>
 |-
 | <br>
 | Street address
 | <br>
 | <br>
 |-
 | <br>
 | Street city
 | <br>
 | <br>
 |-
 | <br>
 | Street state
 | <br>
 | <br>
 |-
 | <br>
 | Street zip
 | <br>
 | <br>
 |-
 | <br>
 | Country
 | 2-letter ISO-3166 country code
 | <br>
 |-
 | <br>
 | Phone
 | <br>
 | <br>
 |-
 | <br>
 | Language
 | <br>
 | <br>
 |-
 | <br>
 | Ethnic group
 | <br>
 | <br>
 |-
 | <br>
 | Sector
 | Our own sector value, set by the conference organizers
 | <br>
 |-
 | <br>
 | Latitude
 | <br>
 | <br>
 |-
 | <br>
 | Longitude
 | <br>
 | <br>
 |-
 | <br>
 | Parent SDA AdmFieldID
-| ID of parent conference.
+|
-(I believe we always have this one) &#124;&#124;
+ID of parent conference.
+(I believe we always have this one)
 |-
 | <br>
 | Parent SDA OrgMastID
-| 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?! &#124;&#124;
+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?!
 |-
 | <br>
 | Parent is not a conference?
 | yes/no
 | <br>
 |-
 | <br>
 | Inactive?
 | yes/no
 | <br>
 |-
 | <br>
 | Date added
 | Date added to our database.
 | <br>
 |-
 | <br>
 | Date modifed
 | Date last modified in SDA-DB. Controls when we need to update this record.
@@ Line 1,343: / Line 1,371: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Worker ID
 | Our own auto-generated ID
 | <br>
 |-
 | <br>
 | Conference ID
 | Conference the pastor is in.
-Not used for NAD conferences, since Officer ID (from eAdventist) is used. If we change use assign_pastor_to_church() must be reviewed. &#124;&#124;
+Not used for NAD conferences, since Officer ID (from eAdventist) is used. If we change use assign_pastor_to_church() must be reviewed.
-|-
 | <br>
+|-
+| <br>
 | Officer ID
 | ID originates from SDA-DB
-This is the same ID as main_people. sda_membershipID. Used only for records coming from eAdventist.net. &#124;&#124; cond.
+This is the same ID as main_people. sda_membershipID. Used only for records coming from eAdventist.net.
+| cond.<br>
 |-
 | <br>
 | Local ID
 | The local conference's own ID for the person
 | <br>
 |-
 | <br>
 | First name
 | <br>
 | req.
 |-
 | <br>
 | Last name
 | <br>
 | req.
 |-
 | <br>
 | Suffix
 | <br>
 | <br>
 |-
 | <br>
 | Mailing address
 | <br>
 | <br>
 |-
 | <br>
 | Mailing city
 | <br>
 | <br>
 |-
 | <br>
 | Mailing state
 | <br>
 | <br>
 |-
 | <br>
 | Mailing zip
 | <br>
 | <br>
 |-
 | <br>
 | Mailing country
 | 2-letter country name (ISO-3166)
 | <br>
 |-
 | <br>
 | E-mail
 | <br>
 | <br>
 |-
 | <br>
 | Alternative e-mail addresses
 | Comma-separated list (with space between comma and next address)
 | opt.
 |-
 | <br>
 | Cell phone
 | <br>
 | <br>
 |-
 | <br>
 | Allow SMS?
 | Is ShareHim allowed to send the pastor an SMS to notify him about new applicants from his church?
 | <br>
 |-
 | <br>
 | Person ID
 | Link to this person's record in our main people table if present.
 | opt.
 |-
 | <br>
 | Default password
 | Password that will be used to auto-create a login when this pastors tries to login
 | <br>
 |-
 | <br>
 | Date modified
 | Date last modified in SDA-DB. Controls when we need to update this record.
@@ Line 1,447: / Line 1,477: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Church office ID
 | Our own auto-generated ID
 | <br>
 |-
 | <br>
 | Church SDA org ID
 | OrgMastID of church
 | <br>
 |-
 | <br>
 | Worker ID
 | <br>
 | <br>
 |-
 | <br>
 | Officer ID
 | From main_officers table
 | <br>
 |-
 | <br>
 | Office name
 | Name of office the person holds.
@@ Line 1,473: / Line 1,503: @@
 |-
 | <br>
 | Is evangelistic decision-maker?
 | yes/no
@@ Line 1,479: / Line 1,509: @@
 |-
 | <br>
 | Date modified
 | Last date this record was modified in our own database.
@@ Line 1,489: / Line 1,519: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Campaign site ID
 | <br>
 | <br>
 |-
 | <br>
 | Statistical data
 | serialize PHP array with statistics on attendance, Bible class attendance, and baptisms
-(only used for international) &#124;&#124; req.
+(only used for international)
+| req.<br>
 |-
 | <br>
 | Baptisms during campaign
 | number
-Entered by the speakers. (only used for international) &#124;&#124;
+Entered by the speakers. (only used for international)
-|-
 | <br>
+|-
+| <br>
 | Adjusted baptisms during campaign
 | number
-Entered by the coordinators. &#124;&#124;
+Entered by the coordinators.
-|-
 | <br>
+|-
+| <br>
 | Projected baptisms within 6 months after the campaign (EXCL. those during campaign)
 | number
-Entered by the speakers (only used for international) &#124;&#124;
+Entered by the speakers (only used for international)
-|-
 | <br>
+|-
+| <br>
 | Actual baptisms within 6 months after the campaign (EXCL. those during campaign)
 | number
-Entered by the coordinators. &#124;&#124;
+Entered by the coordinators.
+| <br>
 |-
 | <br>
 | Did campaign with OLT?
 | yes/no
 | Homeland only
 |-
 | <br>
 | Number of meetings
 | number
 | Homeland only
 |-
 | <br>
 | Number of visitors
 | number
 | Homeland only
 |-
 | <br>
 | Planning another campaign?
-| Possible values:
+|
-&nbsp;: no 1&nbsp;: yes 2&nbsp;: maybe &#124;&#124; Homeland only
+Possible values:<br>0&nbsp;: no<br>1&nbsp;: yes<br>2&nbsp;: maybe
+| Homeland only<br>
 |}
 == Campaign site statistics per conference  ==
-This data "overrides" data entered for each individual campaign site
+This data "overrides" data entered for each individual campaign site.
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Conference date block statistics ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | req.
 |-
 | <br>
 | Conference ID
 | <br>
 | req.
 |-
 | <br>
 | Total baptisms during campaign in this conference
 | number
 | <br>
 |-
 | <br>
 | Baptisms within 6 months after the campaign in this conference (EXCL. those during campaign)
 | number
@@ Line 1,584: / Line 1,620: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Person ID
 | <br>
 | <br>
 |-
 | <br>
 | SDA membership ID
 | ID from eAdventist of OLT members and pastors.
-(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.") &#124;&#124;
+(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.")
+| <br>
 |-
 | <br>
 | Active person event ID
 | <br>
 | <br>
 |-
 | <br>
 | Legal firstname
 | <br>
 | req.
 |-
 | <br>
 | Legal lastname
 | <br>
 | req.
 |-
 | <br>
 | Title
 | dropdown
-Prefered to be set as the option "Pastor" is sometimes used to identify pastors. &#124;&#124;
+Prefered to be set as the option "Pastor" is sometimes used to identify pastors.
 |-
 | <br>
 | Birth date
 | <br>
 | req.
 |-
 | <br>
 | Gender
 | <br>
 | <br>
 |-
 | <br>
 | Marital status
 | dropdown
 | <br>
 |-
 | <br>
 | Mailing address
 | <br>
 | req.
 |-
 | <br>
 | Mailing city
 | <br>
 | req.
 |-
 | <br>
 | Mailing state/province
 | <br>
 | req.
 |-
 | <br>
 | Mailing zipcode
 | <br>
 | req.
 |-
 | <br>
 | Street address
 | this is also their shipping address
 | req.
 |-
 | <br>
 | Street city
 | <br>
 | req.
 |-
 | <br>
 | Street state/province
 | <br>
 | req.
 |-
 | <br>
 | Street zipcode
 | <br>
 | req.
 |-
 | <br>
 | Country
 | <br>
 | req.
 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.
 |-
 | <br>
 | E-mail
 | also their username
-Sometimes noemail@noemail.com or none@none.com has been put in if we don't know the address. &#124;&#124; req. (except for special cases, eg. speakers assigned to past homeland campaigns, or check donations where we don't know the e-mail)
+Sometimes noemail@noemail.com or none@none.com has been put in if we don't know the address.<br>
+| req. (except for special cases, eg. speakers assigned to past homeland campaigns, or check donations where we don't know the e-mail) <br>
 |-
 | <br>
 | E-mail invalid
 | date
-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. &#124;&#124;
+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.
 |-
 | <br>
 | Home phone
 | multiple formats
@@ Line 1,696: / Line 1,734: @@
 |-
 | <br>
 | Office phone
 | multiple formats
@@ Line 1,702: / Line 1,740: @@
 |-
 | <br>
 | Cell phone
 | multiple formats
@@ Line 1,708: / Line 1,746: @@
 |-
 | <br>
 | Residence division
 | dropdown
 | req.
 |-
 | <br>
 | Residence union
 | dropdown
 | <br>
 |-
 | <br>
 | Residence conference
 | dropdown
 | <br>
 |-
 | <br>
 | Residence church
 | text
 | <br>
 |-
 | <br>
 | Application date
 | <br>
 | <br>
 |-
 | <br>
 | Remmendation status
 | Possible values: (by sending fields/recommenders)
@@ Line 1,739: / Line 1,777: @@
 |-
 | <br>
 | Recommender
 | Pastor/layman/academy in NAD:
@@ Line 1,745: / Line 1,783: @@
 |-
 | <br>
 | Recommender comments
 | <br>
 | <br>
 |-
 | <br>
 | Graphics equipment request
 | Possible values:
@@ Line 1,756: / Line 1,794: @@
 |-
 | <br>
 | Sponsorship
 | (Voice of Prophecy)
 | req. for speakers
 |-
 | <br>
 | Sponsorship commitment form approved
 | when approved, show them on website
 | <br>
 |-
 | <br>
 | Sponsorship check sent date
 | <br>
 | <br>
 |-
 | <br>
 | Sermon notes language
 | dropdown
@@ Line 1,777: / Line 1,815: @@
 |-
 | <br>
 | Request hard copy notes
 | (this will effectively only be for their first event)
@@ Line 1,783: / Line 1,821: @@
 |-
 | <br>
 | Preferred CD format
 | Possible values:
@@ Line 1,789: / Line 1,827: @@
 |-
 | <br>
 | Done boot camp?
 | Has person taken the ShareHim boot camp training program?
@@ Line 1,795: / Line 1,833: @@
 |-
 | <br>
 | Done a campaign?
 | yes/no
@@ Line 1,801: / Line 1,839: @@
 |-
 | <br>
 | First campaign
 | text
@@ Line 1,807: / Line 1,845: @@
 |-
 | <br>
 | Reference name
 | Pastoral applicants: ministerial sectary
@@ Line 1,813: / Line 1,851: @@
 |-
 | <br>
 | Reference home phone
 | Pastoral applicants: ministerial sectary
@@ Line 1,819: / Line 1,857: @@
 |-
 | <br>
 | Reference office phone
 | Pastoral applicants: ministerial sectary
@@ Line 1,825: / Line 1,863: @@
 |-
 | <br>
 | Reference cell phone
 | Pastoral applicants: ministerial sectary
@@ Line 1,831: / Line 1,869: @@
 |-
 | <br>
 | Reference e-mail
 | Pastoral applicants: ministerial sectary
@@ Line 1,837: / Line 1,875: @@
 |-
 | <br>
 | Password
 | <br>
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Receive newsletter?
 | yes/no/null
@@ Line 1,853: / Line 1,891: @@
 |-
 | <br>
 | Received mentorship material
 | yes/no
@@ Line 1,859: / Line 1,897: @@
 |-
 | <br>
 | Portrait filename
 | File for thumbnail image used in stories.
 | <br>
 |-
 | <br>
 | Portrait is authorized?
 | yes/no
 | <br>
 |-
 | <br>
 | Outreach Leadership Team of master site ID
 | The church with this master site ID that this person is an OLT member of
 | <br>
 |-
 | <br>
 | Outreach Leadership Team special status
 | number
@@ Line 1,882: / Line 1,920: @@
 |-
 | <br>
 | Is editor?
 | Possible values:
@@ Line 1,888: / Line 1,926: @@
 |-
 | <br>
 | Do not contact
 | date
@@ Line 1,894: / Line 1,932: @@
 |-
 | <br>
 | Reason for not contacting
 | text
@@ Line 1,900: / Line 1,938: @@
 |-
 | <br>
 | Hide person from public?
 | number
@@ Line 1,908: / Line 1,946: @@
 |-
 | <br>
 | Person requested check for duplicate
 | Person indicated that they might already exist in our database.
 | <br>
 |-
 | <br>
 | Source
 | Indication of how this person originally got into the database. Possible values (also defined in main_peopleedit.php):
@@ Line 1,925: / Line 1,963: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Person event ID
 | <br>
 | <br>
 |-
 | <br>
 | Person ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | Only for non-college/university applicants
 | <br>
 |-
 | <br>
 | Effective date block ID
 | Updated to always hold the effective date block ID for this event (also when event has been deleted)
 | <br>
 |-
 | <br>
 | Category
 | Possible values:
@@ Line 1,951: / Line 1,989: @@
 |-
 | <br>
 | College date block ID
 | Only for college/university applicants
 | <br>
 |-
 | <br>
 | Is standby
 | yes/no
@@ Line 1,962: / Line 2,000: @@
 |-
 | <br>
 | Cluster ID
 | Only for speakers
@@ Line 1,968: / Line 2,006: @@
 |-
 | <br>
 | Group ID
 | Only for speakers
 | <br>
 |-
 | <br>
 | Team ID
 | Only for STMs - linking them to their speaker (Team ID in main_teams)
 | <br>
 |-
 | <br>
 | Ranking ID
 | <br>
 | <br>
 |-
 | <br>
 | Associate speaker
 | yes/no
@@ Line 1,989: / Line 2,027: @@
 |-
 | <br>
 | Preferred hub city (date block hotel ID)
 | The hub city the person him/herself wishes to go to
 | <br>
 |-
 | <br>
 | Site-funding required
 | yes/no
@@ Line 2,000: / Line 2,038: @@
 |-
 | <br>
 | Site-funding fulfilled
 | If fulfilled, it has the ID of the belonging log entry from sharehim_log.system_operations.operationID
 | <br>
 |-
 | <br>
 | Need housing?
 | yes/no
@@ Line 2,011: / Line 2,049: @@
 |-
 | <br>
 | Acceptance status
 | Possible values: (by host fields)
@@ Line 2,017: / Line 2,055: @@
 |-
 | <br>
 | Acceptance comments
 | <br>
 | <br>
 |-
 | <br>
 | Orientation, room ID
 | Other people having the same number will be staying in the same room
 | <br>
 |-
 | <br>
 | Orientation, private accommodation
 | yes/no
 | <br>
 |-
 | <br>
 | Hotel city, room ID
 | Other people having the same number will be staying in the same room
 | <br>
 |-
 | <br>
 | Hotel city, private accommodation
 | yes/no
 | <br>
 |-
 | <br>
 | Orientation city, flight arrival date
 | <br>
 | req. for suppl.
 |-
 | <br>
 | Orientation city, flight arrival time
 | <br>
 | req. for suppl.
 |-
 | <br>
 | Orientation city, airline
 | <br>
 | req. for suppl.
 |-
 | <br>
 | Orientation city, flight no.
 | <br>
 | req. for suppl.
 |-
 | <br>
 | Self-arranged travel to orientation
 | yes/no
@@ Line 2,068: / Line 2,106: @@
 |-
 | <br>
 | Hotel city, arrival airport
 | <br>
 | <br>
 |-
 | <br>
 | Hotel city, flight arrival date
 | <br>
 | <br>
 |-
 | <br>
 | Hotel city, flight arrival time
 | <br>
 | <br>
 |-
 | <br>
 | Hotel city, airline
 | <br>
 | <br>
 |-
 | <br>
 | Hotel city, flight no.
 | <br>
 | <br>
 |-
 | <br>
 | Last deposit reminder
 | Days after application date that this reminder was last sent
 | <br>
 |-
 | <br>
 | Last site-funding reminder
 | Days before opening date that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
 | <br>
 |-
 | <br>
 | Last hotel reservation reminder
 | Days before orientation that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
 | <br>
 |-
 | <br>
 | Last flight arrival reminder
 | Days before orientation that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
 | <br>
 |-
 | <br>
 | Last generic reminder
 | Days before orientation that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
 | <br>
 |-
 | <br>
 | Last equipment rental reminder
 | Days before orientation that this reminder was last sent (not necessarily the actual day, but the day according to the schedule (xday))
 | <br>
 |-
 | <br>
 | Consent form for minors
 | NULL = not a minor
@@ Line 2,129: / Line 2,167: @@
 |-
 | <br>
 | No sermon notes
 | yes/no
@@ Line 2,135: / Line 2,173: @@
 |-
 | <br>
 | Reported on the first insurance/service requests report that we sent out?
 | yes/no
 | <br>
 |-
 | <br>
 | Is deleted?
 | yes/no
@@ Line 2,146: / Line 2,184: @@
 |-
 | <br>
 | Is event request?
 | yes/no (when person does not fill out the main application form, value is not changed but kept forever event if event is deleted)
 | <br>
 |-
 | <br>
 | Date added
 | datetime
@@ Line 2,157: / Line 2,195: @@
 |-
 | <br>
 | Date deposit received
 | datetime
@@ Line 2,163: / Line 2,201: @@
 |-
 | <br>
 | Date approved
 | datetime (by administration)
@@ Line 2,169: / Line 2,207: @@
 |-
 | <br>
 | Date standby expire
 | date
@@ Line 2,175: / Line 2,213: @@
 |-
 | <br>
 | Date activated
 | datetime
@@ Line 2,181: / Line 2,219: @@
 |-
 | <br>
 | Date deleted
 | datetime
@@ Line 2,193: / Line 2,231: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Comment ID
 | <br>
 | <br>
 |-
 | <br>
 | Person ID
 | <br>
 | req.
 |-
 | <br>
 | Person event ID
 | Possible to reference a comment to a person's event
 | optional
 |-
 | <br>
 | Comment
 | <br>
 | req.
 |-
 | <br>
 | Comment type
 | Possible values:
@@ Line 2,219: / Line 2,257: @@
 |-
 | <br>
 | Flag
 | dropdown
@@ Line 2,225: / Line 2,263: @@
 |-
 | <br>
 | Date and time entered
 | <br>
 | req.
 |-
 | <br>
 | Submitter
 | Local ID of user from table below
 | <br>
 |-
 | <br>
 | From table
 | Origin table of this user
@@ Line 2,247: / Line 2,285: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Person ID
 | The person the salutation is for
 | req.
 |-
 | <br>
 | From table
 | The table the "owner" of this salutation is from.
@@ Line 2,258: / Line 2,296: @@
 |-
 | <br>
 | From local ID
 | The ID from the table the "owner" of this salutation is from.
 | req.
 |-
 | <br>
 | Salutation
 | The salutation itself. Must be the full line.
@@ Line 2,273: / Line 2,311: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | College ID
 | <br>
 | <br>
 |-
 | <br>
 | Name
 | <br>
 | <br>
 |-
 | <br>
 | Initials
 | Abbreviation of name
 | <br>
 |-
 | <br>
 | Street address
 | For shipping equipment
 | <br>
 |-
 | <br>
 | Street city
 | <br>
 | <br>
 |-
 | <br>
 | Street state
 | <br>
 | <br>
 |-
 | <br>
 | Street zip
 | <br>
 | <br>
 |-
 | <br>
 | Country
 | dropdown
 | <br>
 |-
 | <br>
 | Contact person
 | <br>
 | <br>
 |-
 | <br>
 | Contact e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Contact phone
 | <br>
 | <br>
 |-
 | <br>
 | Password
 | Use this to login and recommend students
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Active
 | yes/no
@@ Line 2,350: / Line 2,388: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | College date block ID
 | <br>
 | <br>
 |-
 | <br>
 | College ID
 | <br>
 | req.
 |-
 | <br>
 | Dateblock ID
 | <br>
 | req.
 |-
 | <br>
 | Person event ID (leader)
 | Only speakers
 | opt.
 |-
 | <br>
 | Student sites to reserve equip. for
 | numeric
 | req.
 |-
 | <br>
 | Funding source
 | <br>
 | <br>
 |-
 | <br>
 | Date site-funding received
 | date
 | <br>
 |-
 | <br>
 | Total site-funding amount received
 | number
@@ Line 2,391: / Line 2,429: @@
 |-
 | <br>
 | Date travel funds requested
 | The date we requested Quiet Hour Ministries to send the travel funds to the college/students.
 | opt.
 |-
 | <br>
 | Last status reminder sent
 | date
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | opt.
 |}
@@ Line 2,413: / Line 2,451: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Recommender ID
 | <br>
 | <br>
 |-
 | <br>
 | Firstname
 | <br>
 | <br>
 |-
 | <br>
 | Lastname
 | <br>
 | <br>
 |-
 | <br>
 | E-mail
 | <br>
 | <br>
 |-
 | <br>
 | Phone
 | <br>
 | <br>
 |-
 | <br>
 | Password
 | <br>
 | <br>
 |-
 | <br>
 | Marker for last applicant
 | a marker so we can cycle through these recommenders
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Active
 | yes/no
@@ Line 2,465: / Line 2,503: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Translation ID
 | <br>
 | <br>
 |-
 | <br>
 | Campaign site ID
 | <br>
 | <br>
 |-
 | <br>
 | From language
 | dropdown acc. to available sermon notes language
@@ Line 2,487: / Line 2,525: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Shipment ID
 | <br>
 | <br>
 |-
 | <br>
 | Material ID
 | <br>
 | <br>
 |-
 | <br>
 | Personevent ID
 | <br>
 | req. to be a speaker
 |-
 | <br>
 | Shipper
 | A main_ext_logins.loginID reference
 | <br>
 |-
 | <br>
 | Paid
 | date
@@ Line 2,513: / Line 2,551: @@
 |-
 | <br>
 | Postpone date
 | date
@@ Line 2,519: / Line 2,557: @@
 |-
 | <br>
 | Shipped date
 | <br>
 | <br>
 |-
 | <br>
 | Shipped method
 | <br>
 | <br>
 |-
 | <br>
 | Shipped tracking no.
 | <br>
 | <br>
 |-
 | <br>
 | Royalty billed
 | date
@@ Line 2,547: / Line 2,585: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Cluster ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | <br>
 |-
 | <br>
 | Cluster name
 | For homeland date blocks this is not used for anything really - other than it shows up on the campaign overview.
 | <br>
 |-
 | <br>
 | Ranking enabled
 | yes/no (for ranking people)
@@ Line 2,572: / Line 2,610: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Cluster leader ID
 | <br>
 | <br>
 |-
 | <br>
 | Cluster ID
 | <br>
 | <br>
 |-
 | <br>
 | Person event ID (leader)
 | Speakers or organizers
@@ Line 2,594: / Line 2,632: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Group ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | <br>
 |-
 | <br>
 | Cluster ID
 | <br>
 | <br>
 |-
 | <br>
 | Person event ID (leader)
 | Only speakers
 | <br>
 |-
 | <br>
 | Group name
 | <br>
 | <br>
 |-
 | <br>
 | Contact name
 | <br>
 | <br>
 |-
 | <br>
 | Contact phone
 | <br>
 | <br>
 |-
 | <br>
 | Contact e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Recommender personID
 | <br>
 | <br>
 |-
 | <br>
 | Reserved sites
 | Will effectively always be filled out.
 | <br>
 |-
 | <br>
 | Funding source (site-funding)
 | Possible values:
@@ Line 2,650: / Line 2,688: @@
 |-
 | <br>
 | Deposit received?
 | yes/no
@@ Line 2,656: / Line 2,694: @@
 |-
 | <br>
 | Partial payment date
 | date
@@ Line 2,662: / Line 2,700: @@
 |-
 | <br>
 | Partial payment amount
 | number
@@ Line 2,668: / Line 2,706: @@
 |-
 | <br>
 | Last site-fund reminder sent
 | date
 | <br>
 |-
 | <br>
 | Show group on availability report?
 | yes/no
 | req.
 |-
 | <br>
 | Max subdivide
 | Max number of hotel cities the group is allowed to span across. Default one.
 | req.
 |-
 | <br>
 | Ranking enabled?
 | yes/no (for ranking people)
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |}
@@ Line 2,700: / Line 2,738: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Team ID
 | <br>
 | <br>
 |-
 | <br>
 | Person event ID (speaker)
 | <br>
 | <br>
 |}
@@ Line 2,715: / Line 2,753: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Orientation ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | <br>
 |-
 | <br>
 | Orientation date
 | <br>
 | req.
 |-
 | <br>
 | Hotel name
 | <br>
 | req.
 |-
 | <br>
 | Hotel address
 | <br>
 | req.
 |-
 | <br>
 | Hotel address (line 2)
 | <br>
 | req.
 |-
 | <br>
 | Hotel country
 | <br>
 | req.
 |-
 | <br>
 | Hotel phone
 | multiple formats
 | req.
 |-
 | <br>
 | Hotel fax
 | multiple formats
 | <br>
 |-
 | <br>
 | Hotel e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Hotel website
 | <br>
 | <br>
 |-
 | <br>
 | Price single room
 | <br>
 | req.
 |-
 | <br>
 | Price double room
 | <br>
 | req.
 |-
 | <br>
 | Price additional person
 | amount or n/a
 | req.
 |-
 | <br>
 | Breakfast included
 | yes/no (note next field)
 | req.
 |-
 | <br>
 | All meals included
 | yes/no
 | req.
 |-
 | <br>
 | Est. price additional meals
 | <br>
 | req.
 |-
 | <br>
 | Recomm. budget for meals outside hotel per day
 | <br>
 | req.
 |-
 | <br>
 | Aircondition
 | Possible values:
@@ Line 2,811: / Line 2,849: @@
 |-
 | <br>
 | Transportation
 | Info regarding getting to the orientation site
 | req.
 |-
 | <br>
 | Orientation comments
 | Public
 | <br>
 |-
 | <br>
 | Active
 | yes/no
@@ Line 2,833: / Line 2,871: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Booking ID
 | <br>
 | <br>
 |-
 | <br>
 | College date block ID
 | <br>
 | req. if no person ID
 |-
 | <br>
 | Speaker ID (= Person ID)
 | <br>
 | req. if no college date block ID
 |-
 | <br>
 | Case ID
 | <br>
 | <br>
 |-
 | <br>
 | Booking date
 | The date the booking was made (just for the information)
 | <br>
 |-
 | <br>
 | Paid amount
 | Only for non-student related
 | <br>
 |-
 | <br>
 | Paid date
 | Set to 2000-01-01 if payment is n/a
 | <br>
 |-
 | <br>
 | Outbound date
 | <br>
 | <br>
 |-
 | <br>
 | Outbound method
 | dropdown
 | <br>
 |-
 | <br>
 | Outbound tracking no.
 | text (30)
 | <br>
 |-
 | <br>
 | Insurance
 | text (100)
@@ Line 2,889: / Line 2,927: @@
 |-
 | <br>
 | Return date
 | Date it was sent from the renter
 | <br>
 |-
 | <br>
 | Return method
 | dropdown
 | <br>
 |-
 | <br>
 | Return tracking no.
 | text (30)
@@ Line 2,905: / Line 2,943: @@
 |-
 | <br>
 | Return received date
 | Date it was received by ShareHim
 | <br>
 |-
 | <br>
 | Equipment checked
 | date
 | <br>
 |-
 | <br>
 | Equipment checked by initials
 | text (10)
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |}
@@ Line 2,930: / Line 2,968: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Case ID
 | Manually entered and unique ID from inventory labels
 | <br>
 |-
 | <br>
 | Laptop ID
 | <br>
 | <br>
 |-
 | <br>
 | Projector ID
 | <br>
 | <br>
 |-
 | <br>
 | Case serial no.
 | text (30)
 | <br>
 |-
 | <br>
 | Case purchase date
 | <br>
 | <br>
 |-
 | <br>
 | Case value
 | <br>
 | <br>
 |-
 | <br>
 | Invoice no.
 | text (15)
 | <br>
 |-
 | <br>
 | Check no.
 | numeric (15)
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Down
 | date
@@ Line 2,981: / Line 3,019: @@
 |-
 | <br>
 | Down status
 | <br>
 | <br>
 |-
 | <br>
 | Discharged
 | date
@@ Line 2,992: / Line 3,030: @@
 |-
 | <br>
 | Discharged status
 | <br>
 | <br>
 |}
@@ Line 3,002: / Line 3,040: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Laptop ID
 | <br>
 | <br>
 |-
 | <br>
 | Inventory ID
 | Manually entered and unique ID from inventory labels
 | <br>
 |-
 | <br>
 | Equipment base ID
 | ID of the equipment base where we administrate a set of graphics equipment
 | <br>
 |-
 | <br>
 | Model no.
 | text (30)
 | <br>
 |-
 | <br>
 | Description
 | text (30)
 | <br>
 |-
 | <br>
 | Serial no.
 | text (30)
 | <br>
 |-
 | <br>
 | OS product key
 | text (30)
 | <br>
 |-
 | <br>
 | Office product key
 | text (30)
 | <br>
 |-
 | <br>
 | Service Tag
 | text (30)
 | <br>
 |-
 | <br>
 | Express service code
 | text (30)
 | <br>
 |-
 | <br>
 | Purchase date
 | date
 | <br>
 |-
 | <br>
 | Laptop value
 | numeric
 | <br>
 |-
 | <br>
 | Warranty type
 | dropdown:
@@ Line 3,068: / Line 3,106: @@
 |-
 | <br>
 | Warranty expiration date
 | date
 | <br>
 |-
 | <br>
 | Quote no.
 | text (15)
 | <br>
 |-
 | <br>
 | Invoice no.
 | text (15)
 | <br>
 |-
 | <br>
 | Check no.
 | numeric (15)
 | <br>
 |-
 | <br>
 | Comments
 | text
 | <br>
 |-
 | <br>
 | Down
 | date
@@ Line 3,099: / Line 3,137: @@
 |-
 | <br>
 | AC adapter
 | yes/no
 | <br>
 |-
 | <br>
 | Remote control
 | yes/no
@@ Line 3,110: / Line 3,148: @@
 |-
 | <br>
 | Floppy drive
 | yes/no
@@ Line 3,120: / Line 3,158: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Projector ID
 | <br>
 | <br>
 |-
 | <br>
 | Inventory ID
 | Manually entered and unique ID from inventory labels
 | <br>
 |-
 | <br>
 | Model no.
 | text (30)
 | <br>
 |-
 | <br>
 | Description
 | text (30)
 | <br>
 |-
 | <br>
 | Serial no.
 | text (30)
 | <br>
 |-
 | <br>
 | Warranty expiration date
 | date
 | <br>
 |-
 | <br>
 | Purchase date
 | date
 | <br>
 |-
 | <br>
 | Projector value
 | <br>
 | <br>
 |-
 | <br>
 | Invoice no.
 | text (15)
 | <br>
 |-
 | <br>
 | Check no.
 | numeric (15)
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Down
 | date
 | <br>
 |-
 | <br>
 | Power cord
 | yes/no
 | <br>
 |-
 | <br>
 | Remote control
 | yes/no
 | <br>
 |-
 | <br>
 | VGA cable
 | yes/no
 | <br>
 |-
 | <br>
 | VCR cable
 | yes/no
 | <br>
 |-
 | <br>
 | International adapters
 | yes/no
 | <br>
 |-
 | <br>
 | Ground adapter
 | yes/no
 | <br>
 |-
 | <br>
 | Extension cord
 | yes/no
@@ Line 3,222: / Line 3,260: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Material ID
 | <br>
 | <br>
 |-
 | <br>
 | Material group
 | Current list:
@@ Line 3,233: / Line 3,271: @@
 |-
 | <br>
 | Name
 | <br>
 | <br>
 |-
 | <br>
 | Code
 | Short easy-to-read code identifying this product to use it when printing labels
 | <br>
 |-
 | <br>
 | Language
 | dropdown
 | <br>
 |-
 | <br>
 | Format
 | NTSC/PAL/SECAM
@@ Line 3,254: / Line 3,292: @@
 |-
 | <br>
 | Qty in stock
 | <br>
 | <br>
 |-
 | <br>
 | Minimum qty in stock
 | Espacially for Life of Christ videos
 | <br>
 |-
 | <br>
 | Available from
 | Date from which this material will be available
 | <br>
 |-
 | <br>
 | Royalty organization
 | Current list:
@@ Line 3,275: / Line 3,313: @@
 |-
 | <br>
 | Shipper
 | ID of shipper (from external logins) (blank/null if internal)
 | <br>
 |-
 | <br>
 | Active
 | yes/no
@@ Line 3,290: / Line 3,328: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Story ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | req.
 |-
 | <br>
 | Story type
 | dropdown
@@ Line 3,306: / Line 3,344: @@
 |-
 | <br>
 | Campaign site ID
 | <br>
 | <br>
 |-
 | <br>
 | Person event ID
 | PersoneventID of the person who created this story, speaker or STMs
 | <br>
 |-
 | <br>
 | Purpose
 | dropdown:
@@ Line 3,322: / Line 3,360: @@
 |-
 | <br>
 | Headline
 | self made headline/title on story
 | <br>
 |-
 | <br>
 | Narrative
 | <br>
 | req.
 |-
 | <br>
 | Copy of Narrative
 | Copy of narrative before people changes an authorized story.
 | <br>
 |-
 | <br>
 | Keywords
 | Optional additional keywords used when searching
 | <br>
 |-
 | <br>
 | Author name
 | <br>
 | <br>
 |-
 | <br>
 | Contact name
 | Person to contact for further information about this story.
 | <br>
 |-
 | <br>
 | Contact phone
 | Person to contact for further information about this story.
 | <br>
 |-
 | <br>
 | Contact e-mail
 | Person to contact for further information about this story.
 | <br>
 |-
 | <br>
 | Author notes
 | Scratch-board for author and/or editors. Not shown publicly.
 | <br>
 |-
 | <br>
 | Internal notes
 | Scratch-board for editors.
 | <br>
 |-
 | <br>
 | Narrative authorized
 | date
@@ Line 3,378: / Line 3,416: @@
 |-
 | <br>
 | Pictures authorized
 | date
 | <br>
 |-
 | <br>
 | Content authorized
 | date
@@ Line 3,389: / Line 3,427: @@
 |-
 | <br>
 | Authorized for display on Adventist Review website?
 | yes/no (set by ShareHim)
 | <br>
 |-
 | <br>
 | Approved for display on Adventist Review website?
 | null/yes/no (set by Adventist Review)
@@ Line 3,400: / Line 3,438: @@
 |-
 | <br>
 | Show thumbnail? (for testimonies)
 | yes/no
@@ Line 3,406: / Line 3,444: @@
 |-
 | <br>
 | Is news item?
 | yes/no
 | <br>
 |-
 | <br>
 | Show from (only news items)
 | date (from now if blank)
@@ Line 3,417: / Line 3,455: @@
 |-
 | <br>
 | Show to (only news items)
 | date (indefinitely if blank)
@@ Line 3,423: / Line 3,461: @@
 |-
 | <br>
 | Date added
 | datetime
 | req.
 |-
 | <br>
 | Date last modified
 | datetime
@@ Line 3,440: / Line 3,478: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Picture ID
 | <br>
 | <br>
 |-
 | <br>
 | Story ID
 | <br>
 | req.
 |-
 | <br>
 | Caption
 | long text
 | req.
 |-
 | <br>
 | Filename (given by the system)
 | <br>
 | req.
 |-
 | <br>
 | Original filename
 | <br>
 | req.
 |-
 | <br>
 | Is retouched?
 | yes/no
@@ Line 3,471: / Line 3,509: @@
 |-
 | <br>
 | Sorting ID
 | For rearranging the order of pictures
 | <br>
 |-
 | <br>
 | Upload date
 | <br>
 | req.
 |-
 | <br>
 | Active
 | yes/no
@@ Line 3,493: / Line 3,531: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Survey ID
 | <br>
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | req.
 |-
 | <br>
 | Person event ID
 | <br>
 | req.
 |-
 | <br>
 | No. of campaigns participated in
 | Number of campaigns the person has participated in to date.
 | req.
 |-
 | <br>
 | [questions] x13
 | 1-5 or null
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |-
 | <br>
 | Date added
 | date
 | req.
 |-
 | <br>
 | Is reviewed?
 | yes/no
@@ Line 3,540: / Line 3,578: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Donation ID
 | <br>
 | <br>
 |-
 | <br>
 | Person ID
 | <br>
 | <br>
 |-
 | <br>
 | Date received
 | <br>
 | <br>
 |-
 | <br>
 | Donation amount
 | <br>
 | <br>
 |-
 | <br>
 | Donation type
 | <br>
 | <br>
 |-
 | <br>
 | Pledge ID
 | <br>
 | <br>
 |-
 | <br>
 | <br>
 | <br>
 | <br>
 |-
 | <br>
 | ...many more fields
 | <br>
 | <br>
 |-
 | <br>
 | <br>
 | <br>
 | <br>
 |-
 | <br>
 | Receipt sent
 | Date receipt was sent.
@@ Line 3,591: / Line 3,629: @@
 |-
 | <br>
 | Thank-you letter sent method
 | Possible values:
@@ Line 3,597: / Line 3,635: @@
 |-
 | <br>
 | Thank-you letter sent
 | Date letter was sent.
@@ Line 3,603: / Line 3,641: @@
 |-
 | <br>
 | Follow-Up done?
 | yes/no
@@ Line 3,609: / Line 3,647: @@
 |-
 | <br>
 | <br>
 | <br>
 | <br>
 |}
@@ Line 3,621: / Line 3,659: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Login ID
 | <br>
 | <br>
 |-
 | <br>
 | Local ID
 | numeric (ID from div, un, conf etc.)
 | <br>
 |-
 | <br>
 | Firstname
 | <br>
 | <br>
 |-
 | <br>
 | Lastname
 | <br>
 | <br>
 |-
 | <br>
 | Password
 | <br>
 | <br>
 |-
 | <br>
 | E-mail
 | <br>
 | <br>
 |-
 | <br>
 | Address 1
 | <br>
 | <br>
 |-
 | <br>
 | Address 2
 | <br>
 | <br>
 |-
 | <br>
 | Phone
 | <br>
 | <br>
 |-
 | <br>
 | Alternative/local phone
 | An alternative phone number to campaign managers, mainly for entering local phone numbers that they use when they supervise campaigns.
 | opt.
 |-
 | <br>
 | Alternative/local phone until
 | The last date that the phone number is scheduled to be usable.
 | req. if phone number is specified
 |-
 | <br>
 | Access level
 | dropdown
 | <br>
 |-
 | <br>
 | Superadmin
 | 0 / 1 / 2
@@ Line 3,689: / Line 3,727: @@
 |-
 | <br>
 | Fulltime
 | yes/no
@@ Line 3,695: / Line 3,733: @@
 |-
 | <br>
 | Approved
 | yes/no
 | <br>
 |-
 | <br>
 | Active
 | <br>
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |}
@@ Line 3,715: / Line 3,753: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Table
 | <br>
 | <br>
 |-
 | <br>
 | Local ID
 | <br>
 | <br>
 |-
 | <br>
 | Question
 | <br>
 | <br>
 |-
 | <br>
 | Answer
 | <br>
 | <br>
 |}
@@ Line 3,740: / Line 3,778: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Description ID
 | <br>
 | <br>
 |-
 | <br>
 | Table name
 | <br>
 | <br>
 |-
 | <br>
 | Field name
 | <br>
 | <br>
 |-
 | <br>
 | Public description
 | <br>
 | <br>
 |-
 | <br>
 | Internal description
 | <br>
 | <br>
 |}
@@ Line 3,772: / Line 3,810: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | News ID
 | <br>
 | <br>
 |-
 | <br>
 | Headline
 | <br>
 | req.
 |-
 | <br>
 | Story
 | <br>
 | req.
 |-
 | <br>
 | ShowFrom
 | date
 | <br>
 |-
 | <br>
 | ShowTo
 | date
 | <br>
 |-
 | <br>
 | Show all on home?
 | yes/no
@@ Line 3,810: / Line 3,848: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Serial Number ID
 | Internal ID
 | <br>
 |-
 | <br>
 | Serial Number
 | GS)-XXXX-XXXX
 | req.
 |-
 | <br>
 | Expiration date
 | date
 | <br>
 |-
 | <br>
 | Person ID
 | Person this serial number is connected to
 | <br>
 |-
 | <br>
 | Person event ID
 | Event this serial number is connected to (and that usually causes an expiration date)
 | <br>
 |-
 | <br>
 | Owner name
 | <br>
 | <br>
 |-
 | <br>
 | Owner e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Activations allowed
 | <br>
 | req.
 |-
 | <br>
 | Is printed?
 | <br>
 | req.
 |-
 | <br>
 | Date created
 | <br>
 | <br>
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |}
@@ Line 3,872: / Line 3,910: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Activation ID
 | <br>
 | <br>
 |-
 | <br>
 | Serial Number
 | <br>
 | req.
 |-
 | <br>
 | Hardware ID
 | <br>
 | req.
 |-
 | <br>
 | Activation Code
 | <br>
 | req.
 |-
 | <br>
 | Activation date
 | timestamp
 | req.
 |-
 | <br>
 | Activation IP
 | <br>
 | req.
 |-
 | <br>
 | Hardware Operating System
 | <br>
 | <br>
 |-
 | <br>
 | ShareSynch software version
 | <br>
 | <br>
 |-
 | <br>
 | Reactivation dates
 | The dates this activation code was resent or reactivated
 | <br>
 |-
 | <br>
 | Is withdrawn?
 | Possible values:
@@ Line 3,927: / Line 3,965: @@
 |-
 | <br>
 | Comments
 | <br>
 | <br>
 |}
@@ Line 3,937: / Line 3,975: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | System administrator name
 | General
 | <br>
 |-
 | <br>
 | System administrator e-mail
 | General
 | <br>
 |-
 | <br>
 | E-mail sender name
 | Name that will appear as sender on all e-mail automatically sent by the system
 | <br>
 |-
 | <br>
 | E-mail sender e-mail
 | E-mail that will appear as sender on all e-mail automatically sent by the system
 | <br>
 |-
 | <br>
 | Days to resend unprocessed applicant
 | Days after application date to resend recommendation e-mails for unprocessed applicants
 | <br>
 |-
 | <br>
 | Days to mark unproccessed applicant
 | Number of days until applicant will be highlighted as 'not processed' in the unapproved applicants list
 | <br>
 |-
 | <br>
 | Days before orientation to ship Life of Christ video
 | Days before orientation date that we issue the shipment
 | <br>
 |-
 | <br>
 | Days after date block closing date to remind about entering experience
 | Only used for those who have received sponsorship
 | <br>
 |-
 | <br>
 | Days before opening date to send out e-mail reminding insurance coverage
 | <br>
 | <br>
 |-
 | <br>
 | Days before opening date to send out e-mail reminding service requests
 | <br>
 | <br>
 |-
 | <br>
 | E-mail recipient (name) of info on insurance coverage for participants
 | <br>
 | <br>
 |-
 | <br>
 | E-mail recipient (e-mail) of info on insurance coverage for participants
 | <br>
 | <br>
 |-
 | <br>
 | Insurance information e-mail recipient
 | E-mail to which we send insurance information on shipped equipment
 | <br>
 |-
 | <br>
 | Case lock combination
 | numeric (3)
@@ Line 4,008: / Line 4,046: @@
 |-
 | <br>
 | Min. days to opening date to allow person use key for bypassing closing date (because of insurance and service requests reports/reminders, so should therefore always be before we send out the last insurance/serv. req. reminder)
 | <br>
 | <br>
 |}
@@ Line 4,020: / Line 4,058: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | E-mail template ID
 | <br>
 | <br>
 |-
 | <br>
 | Reference name
 | identification name for this template
 | <br>
 |-
 | <br>
 | Subject
 | Subject for the e-mail
 | <br>
 |-
 | <br>
 | Body
 | Body for the e-mail
@@ Line 4,047: / Line 4,085: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Log ID
 | <br>
 | <br>
 |-
 | <br>
 | Date
 | <br>
 | <br>
 |-
 | <br>
 | Time
 | <br>
 | <br>
 |-
 | <br>
 | Name
 | <br>
 | <br>
 |-
 | <br>
 | E-mail
 | <br>
 | <br>
 |-
 | <br>
 | Mail reference
 | reference to the mail sent (an ID or a file reference)
 | <br>
 |-
 | <br>
 | Local ID
 | numeric (ID from div, un, conf etc.)
 | <br>
 |-
 | <br>
 | From table
 | the table the user originates from
@@ Line 4,094: / Line 4,132: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Log ID
 | <br>
 | <br>
 |-
 | <br>
 | Date
 | <br>
 | <br>
 |-
 | <br>
 | Time
 | <br>
 | <br>
 |-
 | <br>
 | Local ID
 | numeric (ID from div, un, conf etc.)
 | <br>
 |-
 | <br>
 | From table
 | the table the user originates from
 | <br>
 |-
 | <br>
 | E-mail
 | <br>
 | <br>
 |-
 | <br>
 | CC
 | Carbon Copy recipients
 | <br>
 |-
 | <br>
 | Attached files
 | )
 | <br>
 |-
 | <br>
 | Date block ID
 | <br>
 | <br>
 |-
 | <br>
 | Target
 | "host" or "sending" organization (division/union/conference)
 | <br>
 |-
 | <br>
 | Batch
 | "first" or "second" batch of reports to this organization
@@ Line 4,156: / Line 4,194: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Mail queue ID
 | <br>
 | <br>
 |-
 | <br>
 | By local ID
 | User who made the queue
 | <br>
 |-
 | <br>
 | By from table
 | User who made the queue
 | <br>
 |-
 | <br>
 | Sender name
 | <br>
 | <br>
 |-
 | <br>
 | Sender e-mail
 | <br>
 | <br>
 |-
 | <br>
 | Query ID
 | Query ID that this queue is based upon.
@@ Line 4,187: / Line 4,225: @@
 |-
 | <br>
 | Custom subject
 | <br>
 | <br>
 |-
 | <br>
 | Attach files
 | Serialized PHP array with documents to attach to the e-mails in this queue.
 | <br>
 |-
 | <br>
 | Use personal salutations?
 | yes/no
 | <br>
 |-
 | <br>
 | Date added
 | datetime
 | <br>
 |-
 | <br>
 | Date completed
 | datetime
@@ Line 4,220: / Line 4,258: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Translation ID
 | <br>
 | <br>
 |-
 | <br>
 | Category
 | Not really used
 | <br>
 |-
 | <br>
 | Tag
 | The tag use in the PHP code
 | <br>
 |-
 | <br>
 | Langugage [en&#124;es&#124;da&#124;...]
 | The text for this tag in the given language
 | <br>
 |-
 | <br>
 | Sorting ID
 | Not used
 | <br>
 |-
 | <br>
 | Explanation
 | Any useful instructions for the translator about this piece of text
 | <br>
 |-
 | <br>
 | Date modified
 | Timestamp for when the text or tag for the primary language (English) was last modified
@@ Line 4,262: / Line 4,300: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Translator ID
 | <br>
 | <br>
 |-
 | <br>
 | Language
 | Two-letter abbreviation for the language
 | <br>
 |-
 | <br>
 | Person ID
 | Person ID from main_people of the person who is the translator for this language.
@@ Line 4,278: / Line 4,316: @@
 |-
 | <br>
 | Last notified
 | Last time translator was notified about new or changed text to be translated
@@ Line 4,290: / Line 4,328: @@
 {| cellspacing="0" cellpadding="8" border="1"
 |-
 | <br>
 | Operation ID
 | <br>
 | <br>
 |-
 | <br>
 | Date
 | <br>
 | Req.
 |-
 | <br>
 | Time
 | <br>
 | Req.
 |-
 | <br>
 | By name
 | Name of user who caused this operation
 | Req. if avail.
 |-
 | <br>
 | By local ID
 | ...his local ID
 | Req. if avail.
 |-
 | <br>
 | By from table
 | ...originates from this table
@@ Line 4,321: / Line 4,359: @@
 |-
 | <br>
 | Visit ID
 | VisitID from WebStory statistics
 | <br>
 |-
 | <br>
 | IP
 | User's IP address at time of logging
 | <br>
 |-
 | <br>
 | Emulated by
 | Full name of person who was emulating
 | <br>
 |-
 | <br>
 | Action
 | Main name for for this action
 | Req.
 |-
 | <br>
 | Subaction
 | Subname for this action
 | <br>
 |-
 | <br>
 | For name
 | Name of user/record this action was executed upon
@@ Line 4,352: / Line 4,390: @@
 |-
 | <br>
 | For local ID
 | ...caused upon this ID in the table below
 | <br>
 |-
 | <br>
 | For from table
 | ...caused upon a record in this table
 | <br>
 |-
 | <br>
 | Person event ID
 | PersoneventID of person it was caused upon (if applicable)
 | <br>
 |-
 | <br>
 | Date block ID
 | DateblockID that this action is related to (if applicable)
 | <br>
 |-
 | <br>
 | Parameters
 | Any extra parameters to log. Default format: field=value¤field=value...

Difference between revisions of "Userlevel:Admin:Technical Documentation - Websites:Database Tables-Fields, sharehim main"

Revision as of 19:34, 2 December 2011

Contents

Database Tables/Fields - sharehim_main

Divisions (main_divisions)

Unions (main_unions)

Conferences or missions (main_conferences)

Conferences' Wire Information

Conference accepted people

Hub cities - Previously Hotel cities (main_hotels)

Date blocks' hotels (main_dateblockhotels)

Date blocks

Date blocks' orientations

Date blocks' predefined conferences

Campaign sites

Outreach Teams - Previous: Master Campaign sites (main_master_sites)

Outreach Leadership Team members

Churches

Workers / Officers

Church offices

Campaign site statistics

Campaign site statistics per conference

People

Person events

Person comments

Personal salutations

Colleges

Colleges' date blocks

Recommenders

Translations

Campaign material

Clusters

Cluster leaders

Groups

Teams

Orientation sites

Equipment booking

Equipment stock, cases

Equipment stock, laptops

Equipment stock, projectors

Material stock

Stories

Story pictures

Surveys

Donations

External logins

Password questions

Field descriptions

News

ShareSynch Serial Numbers

ShareSynch activations

System settings

E-mail templates

Email log, group e-mails

Email log, service requests reports

Mail queue

System translations

System translators

System log

List tables

Venue types

Countries

Currencies

Sponsors

Material groups

Equipment bases

Shipping methods

US states

Titles

Access levels

Navigation menu

Search