Difference between revisions of "Userlevel:Admin:Technical Documentation - Websites:Database Tables-Fields, sharehim main"
(Added new people fields) |
(→Column Prefixes for all Database Tables) |
||
(26 intermediate revisions by the same user not shown) | |||
Line 97: | Line 97: | ||
|- | |- | ||
| main_churchoffices | | main_churchoffices | ||
− | | | + | | choff |
|- | |- | ||
| main_clusterleaders | | main_clusterleaders | ||
Line 397: | Line 397: | ||
|- | |- | ||
| temp_users | | temp_users | ||
− | | | + | | tusr |
|- | |- | ||
| temp_users_wp | | temp_users_wp | ||
Line 1,153: | Line 1,153: | ||
| dateblockID | | dateblockID | ||
| Date block ID | | Date block ID | ||
− | | | + | | |
− | | | + | | |
|- | |- | ||
| opening_date | | opening_date | ||
| Opening date | | Opening date | ||
− | | | + | | |
| req. | | req. | ||
|- | |- | ||
| closing_date | | closing_date | ||
| Closing date | | Closing date | ||
− | | | + | | |
| req. | | req. | ||
|- | |- | ||
− | | appl_closed_date | + | | appl_closed_date |
| Applications closing date | | Applications closing date | ||
− | | Should be the final cut-off date for new applicants. | + | | NO LONGER USED. Only kept for historic purposes. |
+ | 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. | 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. | ||
− | | | + | | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
|- | |- | ||
| title | | title | ||
Line 1,190: | Line 1,178: | ||
| Usually the country wherein the campaigns will be held. | | Usually the country wherein the campaigns will be held. | ||
Homeland: optional additional label like "SWAU" | Homeland: optional additional label like "SWAU" | ||
− | |||
| req. for international<br>opt. for homeland<br> | | req. for international<br>opt. for homeland<br> | ||
|- | |- | ||
Line 1,197: | Line 1,184: | ||
| Total number of campaign sites in this date block - must ALWAYS be kept up-to-date as available sites are calculated from this. | | 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... | 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... | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| | | | ||
|- | |- | ||
| db_trip_price | | db_trip_price | ||
| Trip price | | Trip price | ||
− | | | + | | Only used in 2015 |
| | | | ||
|- | |- | ||
| db_appl_donation_amount | | db_appl_donation_amount | ||
| Application donation amount | | Application donation amount | ||
− | | Not | + | | Not used from 2015 forward |
| | | | ||
|- | |- | ||
| db_2nd_donation_date | | db_2nd_donation_date | ||
| 2nd donation deadline date | | 2nd donation deadline date | ||
− | | Also occasionally called "middle deadline" | + | | Not used from 2016 forward |
+ | Also occasionally called "middle deadline" | ||
| | | | ||
|- | |- | ||
| db_2nd_donation_amount | | db_2nd_donation_amount | ||
| 2nd donation amount | | 2nd donation amount | ||
− | | | + | | |
− | + | ||
| | | | ||
|- | |- | ||
| db_final_donation_date | | db_final_donation_date | ||
| Final donation deadline date | | Final donation deadline date | ||
− | | This value is also used for site-funding date block pre-2013 (instead of sitefund_deadline_unix that was always calculated) | + | | Not used from 2016 forward |
+ | This value is also used for site-funding date block pre-2013 (instead of sitefund_deadline_unix that was always calculated) | ||
| | | | ||
|- | |- | ||
Line 1,238: | Line 1,220: | ||
| db_child_discount | | db_child_discount | ||
| Discount amount for children | | Discount amount for children | ||
− | | | + | | |
| | | | ||
|- | |- | ||
| db_youth_discount | | db_youth_discount | ||
| Discount amount for youth | | Discount amount for youth | ||
− | | | + | | |
| | | | ||
|- | |- | ||
Line 1,264: | Line 1,246: | ||
| Questions recipient | | Questions recipient | ||
| intl_managerID of the person from main_intl_managers who will receive questions about this date block. This person will also be the lead date block manager. | | intl_managerID of the person from main_intl_managers who will receive questions about this date block. This person will also be the lead date block manager. | ||
− | | | + | | |
|- | |- | ||
| precampaign_manager | | precampaign_manager | ||
| Pre-campaign manager | | Pre-campaign manager | ||
| intl_managerID of the person from main_intl_managers who will be the pre-campaign manager if different from the lead manager. | | intl_managerID of the person from main_intl_managers who will be the pre-campaign manager if different from the lead manager. | ||
− | | | + | | |
|- | |- | ||
| notify_sent_insurance_first | | notify_sent_insurance_first | ||
| Insurance reminder sent date, 1st | | Insurance reminder sent date, 1st | ||
− | | | + | | |
− | | | + | | |
|- | |- | ||
| notify_sent_insurance_second | | notify_sent_insurance_second | ||
− | | Insurance reminder sent date, 2nd | + | | Insurance reminder sent date, 2nd |
− | | | + | | No longer used, we now only send one insurance request per date block |
− | | | + | | |
|- | |- | ||
| notify_sent_servreq_first | | notify_sent_servreq_first | ||
| Service requests reminder sent date, 1st | | Service requests reminder sent date, 1st | ||
− | | | + | | |
− | | | + | | |
|- | |- | ||
| notify_sent_servreq_second | | notify_sent_servreq_second | ||
| Service requests reminder sent date, 2nd | | Service requests reminder sent date, 2nd | ||
| Just before the campaign | | Just before the campaign | ||
− | | | + | | |
|- | |- | ||
| last_incomplete_notification<br> | | last_incomplete_notification<br> | ||
| Last incomplete notification | | 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) | | The date we last sent a notification to unions/conferences/campaign manager about incomplete information entered for this date block (if any) | ||
− | | | + | | |
+ | |- | ||
+ | | db_default_sharesynch_prefix | ||
+ | | Default ShareSynch prefix | ||
+ | | dropdown; must be a CD set (now we mainly use db_default_sharesynch_prefix instead) | ||
+ | Irrelevant for homeland campaigns. (Previously only used for in homeland: Displayed in the popup box for approving and selecting material for an applicant.) | ||
+ | | | ||
|- | |- | ||
| default_graphics_lang | | default_graphics_lang | ||
− | | Default sermon graphics language | + | | Default sermon graphics language |
− | | | + | | (Now we mainly use db_default_sharesynch_prefix instead) |
− | + | ||
| | | | ||
|- | |- | ||
Line 1,305: | Line 1,292: | ||
| Comments | | Comments | ||
| Extended public description of the date block | | Extended public description of the date block | ||
− | | | + | | |
|- | |- | ||
| applicant_note | | applicant_note | ||
| Note for applicants | | Note for applicants | ||
| Special information for potential applicants before applying | | Special information for potential applicants before applying | ||
− | | | + | | |
|- | |- | ||
| db_fly_to_airport_iata | | db_fly_to_airport_iata | ||
| IATA airport code to fly to | | IATA airport code to fly to | ||
| The IATA code of the airport that participants should be flying to (so that we can look up prices) | | The IATA code of the airport that participants should be flying to (so that we can look up prices) | ||
− | | | + | | |
|- | |- | ||
| application_monitors | | application_monitors | ||
| Application monitors | | 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. | | 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. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| | | | ||
|- | |- | ||
Line 1,331: | Line 1,312: | ||
| Media folder | | Media folder | ||
| Base folder for uploading media files (pictures, video etc.) | | Base folder for uploading media files (pictures, video etc.) | ||
− | | | + | | |
|- | |- | ||
| predefined_unions_only | | predefined_unions_only | ||
Line 1,339: | Line 1,320: | ||
| | | | ||
|- | |- | ||
− | | active | + | | active |
| Active | | Active | ||
| yes/no | | yes/no | ||
− | | | + | | |
|} | |} | ||
Line 1,728: | Line 1,709: | ||
== Churches == | == Churches == | ||
− | List of churches we have retrieved from AdventistDirectory.org and eAdventist.net (= SDA-DB) | + | List of churches we have retrieved from AdventistDirectory.org and eAdventist.net (= SDA-DB) |
{| cellspacing="0" cellpadding="8" border="1" | {| cellspacing="0" cellpadding="8" border="1" | ||
|- | |- | ||
− | | | + | | |
− | | Church ID | + | | Church ID |
− | | Our own auto-generated ID | + | | Our own auto-generated ID |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | SDA org ID | + | | SDA org ID |
− | | OrgMastID from SDA-DB | + | | OrgMastID from SDA-DB - Don't trust it as an ID, their data management is sometimes a bit shaky. |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | SDA entity ID | + | | SDA entity ID |
− | | OMEntity from SDA-DB | + | | OMEntity from SDA-DB - Don't trust it as an ID, their data management is sometimes a bit shaky. |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Church name | + | | Church name |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Street address | + | | Street address |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Street city | + | | Street city |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Street state | + | | Street state |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Street zip | + | | Street zip |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Country | + | | Country |
− | | 2-letter ISO-3166 country code | + | | 2-letter ISO-3166 country code |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Phone | + | | Phone |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Language | + | | Language |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Ethnic group | + | | Ethnic group |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Sector | + | | Sector |
− | | Our own sector value, set by the conference organizers | + | | Our own sector value, set by the conference organizers |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Latitude | + | | Latitude |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Longitude | + | | Longitude |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Parent SDA AdmFieldID | + | | Parent SDA AdmFieldID |
− | | | + | | |
− | ID of parent conference. | + | ID of parent conference. |
− | (I believe we always have this one) | + | (I believe we always have this one) |
|- | |- | ||
− | | | + | | |
− | | Parent SDA OrgMastID | + | | Parent SDA OrgMastID |
− | | | + | | |
− | ID of parent conference. | + | 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?! | + | (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? | + | | Parent is not a conference? |
− | | yes/no | + | | yes/no |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Inactive? | + | | Inactive? |
− | | yes/no | + | | yes/no |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Date added | + | | Date added |
− | | Date added to our database. | + | | Date added to our database. |
− | | | + | | |
|- | |- | ||
− | | | + | | |
− | | Date modifed | + | | Date modifed |
− | | Date last modified in SDA-DB. Controls when we need to update this record. | + | | Date last modified in SDA-DB. Controls when we need to update this record. |
− | | | + | | |
|} | |} | ||
Line 2,104: | Line 2,085: | ||
|} | |} | ||
− | == People == | + | == People (main_people) == |
Guest speakers, support team members | Guest speakers, support team members | ||
Line 2,181: | Line 2,162: | ||
| req. | | req. | ||
|- | |- | ||
− | | | + | | street_addr |
| Street address | | Street address | ||
| this is also their shipping address | | this is also their shipping address | ||
| req. | | req. | ||
|- | |- | ||
− | | | + | | street_city |
| Street city | | Street city | ||
− | | | + | | |
| req. | | req. | ||
|- | |- | ||
− | | | + | | street_state |
| Street state/province | | Street state/province | ||
− | | | + | | |
| req. | | req. | ||
|- | |- | ||
− | | | + | | street_zip |
| Street zipcode | | Street zipcode | ||
− | | | + | | |
| req. | | req. | ||
|- | |- | ||
− | | | + | | country |
| Country | | Country | ||
− | | | + | | |
| req. | | 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. | 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. | ||
Line 2,244: | Line 2,225: | ||
Can have the value "Do not have" if person simply does not have this kind of number. | Can have the value "Do not have" if person simply does not have this kind of number. | ||
| At least one phone number is required. | | At least one phone number is required. | ||
+ | |- | ||
+ | | p_is_baptized | ||
+ | | Is baptized? | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| residence_division | | residence_division | ||
Line 2,271: | Line 2,257: | ||
| | | | ||
|- | |- | ||
− | | | + | | appl_date |
| Application date | | Application date | ||
− | | | + | | Started converting the name into p_date_added (eg. in get_people() ) |
− | | | + | | |
|- | |- | ||
− | | | + | | recommend_status |
| Remmendation status | | Remmendation status | ||
| | | | ||
Line 2,283: | Line 2,269: | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | recommender |
| Recommender | | Recommender | ||
| | | | ||
Line 2,292: | Line 2,278: | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | recommender_comments |
| Recommender comments | | Recommender comments | ||
| <br> | | <br> | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | sermon_language |
| Sermon notes language | | Sermon notes language | ||
| | | | ||
Line 2,311: | Line 2,297: | ||
| | | | ||
|- | |- | ||
− | | | + | | preferred_cd_format |
| Preferred CD format | | Preferred CD format | ||
| | | | ||
Line 2,320: | Line 2,306: | ||
| req. for speakers<br> | | req. for speakers<br> | ||
|- | |- | ||
− | | | + | | done_bootcamp |
| Done boot camp? | | Done boot camp? | ||
| | | | ||
Line 2,331: | Line 2,317: | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | done_intl_campaign |
| Done a campaign? | | Done a campaign? | ||
| yes/no | | yes/no | ||
Line 2,338: | Line 2,324: | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | first_campaign |
| First campaign | | First campaign | ||
| text | | text | ||
Line 2,345: | Line 2,331: | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | ref_name |
| Reference name | | Reference name | ||
| Pastoral applicants: ministerial sectary | | Pastoral applicants: ministerial sectary | ||
Line 2,352: | Line 2,338: | ||
| req. for speakers<br> | | req. for speakers<br> | ||
|- | |- | ||
− | | | + | | ref_home_phone |
− | | Reference home phone | + | | Reference home phone |
| | | | ||
− | + | This field is used to determine whether we are waiting for pastor info for an intl. applicant. Therefore if applicant is part of a group that has a designated recommender this field MUST be set to 000-000-0000 so that system doesn't wait for this number to be entered before starting processing the application. | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
| req. for speakers<br> | | req. for speakers<br> | ||
|- | |- | ||
− | | | + | | ref_office_phone |
| Reference office phone | | Reference office phone | ||
| | | | ||
Line 2,371: | Line 2,352: | ||
Academy students: academy | Academy students: academy | ||
− | |||
| | | | ||
|- | |- | ||
− | | | + | | ref_cell_phone |
| Reference cell phone | | Reference cell phone | ||
| | | | ||
Line 2,382: | Line 2,362: | ||
Academy students: academy | Academy students: academy | ||
− | |||
| | | | ||
|- | |- | ||
− | | | + | | ref_email |
| Reference e-mail | | Reference e-mail | ||
| | | | ||
Line 2,392: | Line 2,371: | ||
Lay applicants: pastor<br> | Lay applicants: pastor<br> | ||
− | Academy students: academy | + | Academy students: academy |
− | + | ||
| req. for speakers<br> | | req. for speakers<br> | ||
|- | |- | ||
Line 2,432: | Line 2,410: | ||
| opt. | | opt. | ||
|- | |- | ||
− | | | + | | received_mentorship_material |
| Received mentorship material | | Received mentorship material | ||
| yes/no<br> | | yes/no<br> | ||
Line 2,438: | Line 2,416: | ||
| | | | ||
|- | |- | ||
− | | | + | | portrait_filename |
| Portrait filename | | Portrait filename | ||
| File for thumbnail image used in stories. | | File for thumbnail image used in stories. | ||
− | | | + | | |
|- | |- | ||
− | | | + | | portrait_filename_authorized |
| Portrait is authorized? | | Portrait is authorized? | ||
| yes/no | | yes/no | ||
− | | | + | | |
|- | |- | ||
− | | | + | | olt_leader |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
| Outreach Leadership Team special status | | Outreach Leadership Team special status | ||
| | | | ||
Line 2,464: | Line 2,437: | ||
| | | | ||
|- | |- | ||
− | | | + | | is_editor |
| Is editor? | | Is editor? | ||
| | | | ||
Possible values:<br>- executive (edit text/graphics, approve, add/delete stories)<br>- associate (edit text/graphics)<br>- text<br>- graphics<br>- advreview (Adventist Review editor) | Possible values:<br>- executive (edit text/graphics, approve, add/delete stories)<br>- associate (edit text/graphics)<br>- text<br>- graphics<br>- advreview (Adventist Review editor) | ||
+ | | | ||
+ | |- | ||
+ | | no_general_mailings | ||
+ | | No general mailings | ||
| | | | ||
+ | Whether or not the person has requested not to receive general (non-campaign related) emails.<br> | ||
+ | <br> | ||
+ | Possible values:<br> | ||
+ | 0 : no<br> | ||
+ | 1 : yes | ||
+ | | req. | ||
|- | |- | ||
− | | | + | | dont_contact |
| Do not contact | | Do not contact | ||
| | | | ||
Line 2,480: | Line 2,463: | ||
| | | | ||
|- | |- | ||
− | | | + | | dont_contact_reason |
| Reason for not contacting | | Reason for not contacting | ||
| text | | text | ||
Line 2,487: | Line 2,470: | ||
| req. if "Do not contact" is set<br> | | req. if "Do not contact" is set<br> | ||
|- | |- | ||
− | | | + | | hide_person_from_public |
| Hide person from public? | | Hide person from public? | ||
| | | | ||
Line 2,500: | Line 2,483: | ||
| req. | | req. | ||
|- | |- | ||
− | | | + | | requested_check_for_dupe |
| Person requested check for duplicate | | Person requested check for duplicate | ||
| Person indicated that they might already exist in our database. | | Person indicated that they might already exist in our database. | ||
Line 2,510: | Line 2,493: | ||
| | | | ||
|- | |- | ||
− | | | + | | p_source |
| Source | | Source | ||
| | | | ||
Line 2,532: | Line 2,515: | ||
* 99: other manually added record | * 99: other manually added record | ||
− | | | + | | |
+ | |- | ||
+ | | p_date_modified | ||
+ | | Date modified | ||
+ | | | ||
+ | Timestamp for when the record was last modified. Automatically updated whenever a change occurs. | ||
+ | |||
+ | Used eg. in synchronization with Salesforce. | ||
+ | | | ||
|} | |} | ||
Line 3,325: | Line 3,316: | ||
| grp_funding_source | | grp_funding_source | ||
| Funding source (site-funding) | | Funding source (site-funding) | ||
− | | | + | | Possible values: |
− | 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. | | req. | ||
|- | |- | ||
Line 3,333: | Line 3,326: | ||
| Basic price of entire trip | | Basic price of entire trip | ||
| Overrides dateblock setting if set | | Overrides dateblock setting if set | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_appl_donation_amount | ||
+ | | Application donation amount | ||
+ | | Overrides dateblock setting if set | ||
+ | | opt. | ||
+ | |- | ||
+ | | db_appl_donation_amount_children | ||
+ | | Application donation amount for children | ||
+ | | See 'max_child_age' in get_fixed_application_amounts() for a definition of children. | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_earlybird_discount | ||
+ | | Early-bird discount amount | ||
+ | | | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_earlybird_until | ||
+ | | Early-bird discount deadline | ||
+ | | | ||
+ | | req. if grp_earlybird_discount is set | ||
+ | |- | ||
+ | | grp_2nd_donation_date | ||
+ | | 2nd donation deadline date | ||
+ | | Overrides dateblock setting if set | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_2nd_donation_amount | ||
+ | | 2nd donation amount | ||
+ | | Overrides dateblock setting if set | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_final_donation_date | ||
+ | | Final donation deadline date | ||
+ | | Overrides dateblock setting if set | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_discount | ||
+ | | Discount amount | ||
+ | | The amount of discount applicants will get according to the rule specified in grp_discount_rule. | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_discount_rule | ||
+ | | The rule by which to apply the discount | ||
+ | | Possible values: | ||
+ | * 'speaker': all speakers | ||
+ | * 'firsttime': all first-time participants | ||
+ | * 'firsttime_speaker': all first-time speakers | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_appl_closed_date | ||
+ | | Applications closing date | ||
+ | | Overrides dateblock setting if set. | ||
+ | |||
+ | 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. | ||
| opt. | | opt. | ||
|- | |- | ||
Line 3,343: | Line 3,393: | ||
| Single room fee | | Single room fee | ||
| Overrides dateblock setting if set | | Overrides dateblock setting if set | ||
+ | | opt. | ||
+ | |- | ||
+ | | grp_manual_price_info | ||
+ | | Manual price information | ||
+ | | Textual explanation of price that overrides any set prices and don't require payment from participant | ||
| opt. | | opt. | ||
|- | |- | ||
Line 3,382: | Line 3,437: | ||
- 'non-us' : make them confirm that they will bring computer/projector/remote<br> | - 'non-us' : make them confirm that they will bring computer/projector/remote<br> | ||
- 'non-us-flex' : give them option to indicate whether or not they can bring a projector | - 'non-us-flex' : give them option to indicate whether or not they can bring a projector | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| req. | | req. | ||
|- | |- | ||
Line 3,551: | Line 3,600: | ||
{| cellspacing="0" cellpadding="8" border="1" | {| cellspacing="0" cellpadding="8" border="1" | ||
|- | |- | ||
− | | | + | | bookingID |
| Booking ID | | Booking ID | ||
| <br> | | <br> | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | collegedateblockID |
| College date block ID | | College date block ID | ||
− | | | + | | |
− | | | + | | cond. |
|- | |- | ||
− | | | + | | personeventID |
− | | | + | | Person event ID |
− | | | + | | |
− | | | + | | cond. |
|- | |- | ||
− | | | + | | eqbk_personID |
+ | | Person ID | ||
+ | | | ||
+ | | cond. | ||
+ | |- | ||
+ | | caseID | ||
| Case ID | | Case ID | ||
| <br> | | <br> | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | eqbk_from_date |
+ | | Booked from date | ||
+ | | | ||
+ | | req. | ||
+ | |- | ||
+ | | eqbk_to_date | ||
+ | | Booked to date | ||
+ | | | ||
+ | | req. | ||
+ | |- | ||
+ | | bookingdate | ||
| Booking date | | Booking date | ||
| The date the booking was made (just for the information) | | The date the booking was made (just for the information) | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | paid_amount |
| Paid amount | | Paid amount | ||
| Only for non-student related | | Only for non-student related | ||
− | | | + | | |
|- | |- | ||
− | | | + | | paid_date |
| Paid date | | Paid date | ||
| Set to 2000-01-01 if payment is n/a | | Set to 2000-01-01 if payment is n/a | ||
− | | | + | Set to 1999-12-01 if payment is done through participating in an intl. event |
+ | | | ||
|- | |- | ||
− | | | + | | eqbk_ship_addr |
− | | | + | | Custom address to send the equipment to instead of the person's mailing address |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | eqbk_ship_city |
+ | | | ||
+ | | | ||
+ | | | ||
+ | |- | ||
+ | | eqbk_ship_state | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |- | ||
+ | | eqbk_ship_zip | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |- | ||
+ | | eqbk_ship_country | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |- | ||
+ | | outbound_method | ||
| Outbound method | | Outbound method | ||
| dropdown | | dropdown | ||
− | | | + | | |
|- | |- | ||
− | | | + | | outbound_tracking |
| Outbound tracking no. | | Outbound tracking no. | ||
| text (30) | | text (30) | ||
− | | | + | | |
|- | |- | ||
− | | | + | | outbound_date |
+ | | Outbound date | ||
+ | | | ||
+ | | | ||
+ | |- | ||
+ | | insurance | ||
| Insurance | | Insurance | ||
| text (100) | | text (100) | ||
− | E-mail of person received the insurance information | + | E-mail of person received the insurance information |
− | + | | | |
|- | |- | ||
| <br> | | <br> | ||
Line 3,621: | Line 3,711: | ||
| text (30) | | text (30) | ||
If filled out it's a call tag, otherwise not | If filled out it's a call tag, otherwise not | ||
− | + | | | |
|- | |- | ||
| <br> | | <br> | ||
Line 4,558: | Line 4,648: | ||
{| cellspacing="0" cellpadding="8" border="1" | {| cellspacing="0" cellpadding="8" border="1" | ||
|- | |- | ||
− | | | + | | ss_serial_numberID |
| Serial Number ID | | Serial Number ID | ||
| Internal ID | | Internal ID | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | ss_serial_number |
| Serial Number | | Serial Number | ||
− | | | + | | AA-XXXX-XXXX |
+ | |||
+ | AA will be a designator for which product it is. The old prefixes SH and GS always translates to CA (HWOH English). | ||
| req. | | req. | ||
|- | |- | ||
− | | | + | | expiration_date |
| Expiration date | | Expiration date | ||
| date | | date | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | ssser_personID |
| Person ID | | Person ID | ||
| Person this serial number is connected to | | Person this serial number is connected to | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | personeventID |
| Person event ID | | Person event ID | ||
| Event this serial number is connected to (and that usually causes an expiration date) | | Event this serial number is connected to (and that usually causes an expiration date) | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | owner_name |
| Owner name | | Owner name | ||
| <br> | | <br> | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | owner_email |
| Owner e-mail | | Owner e-mail | ||
| <br> | | <br> | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | activations_allowed |
| Activations allowed | | Activations allowed | ||
| <br> | | <br> | ||
| req. | | req. | ||
|- | |- | ||
− | | | + | | is_printed |
| Is printed? | | Is printed? | ||
| <br> | | <br> | ||
| req. | | req. | ||
|- | |- | ||
− | | <br> | + | | ssser_install_progress |
+ | | Progress of the installation process by the user | ||
+ | | 0 : not started at all | ||
+ | |||
+ | 10 : clicked the Windows button on /download-sermons to download ShareSynch<br> | ||
+ | 11 : clicked the Mac button on /download-sermons to download ShareSynch<br> | ||
+ | 12 : clicked the iOS button on /download-sermons to download ShareSynch | ||
+ | |||
+ | 20 : completed the activation process | ||
+ | | req. | ||
+ | |- | ||
+ | | date_created | ||
| Date created | | Date created | ||
| <br> | | <br> | ||
| <br> | | <br> | ||
|- | |- | ||
− | | | + | | comments |
| Comments | | Comments | ||
| <br> | | <br> | ||
Line 4,901: | Line 5,004: | ||
== Mail queue == | == Mail queue == | ||
− | Queues of | + | Queues of emails that have been or are being sent |
{| cellspacing="0" cellpadding="8" border="1" | {| cellspacing="0" cellpadding="8" border="1" | ||
|- | |- | ||
− | | | + | | mail_queueID |
| Mail queue ID | | Mail queue ID | ||
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | by_localID |
| By local ID | | By local ID | ||
| User who made the queue | | User who made the queue | ||
− | | | + | | |
|- | |- | ||
− | | | + | | by_fromtable |
| By from table | | By from table | ||
| User who made the queue | | User who made the queue | ||
− | | | + | | |
|- | |- | ||
− | | | + | | sender_name |
| Sender name | | Sender name | ||
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | sender_email |
− | | Sender | + | | Sender email |
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | queryID |
| Query ID | | Query ID | ||
| Query ID that this queue is based upon. | | 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. | In case we want to make queues that are special and not based on a query this can just be left empty. | ||
− | |||
| | | | ||
|- | |- | ||
− | | | + | | custom_subject |
| Custom subject | | Custom subject | ||
− | | | + | | |
− | | | + | | |
|- | |- | ||
− | | | + | | attach_files |
| Attach files | | Attach files | ||
− | | Serialized PHP array with documents to attach to the | + | | Serialized PHP array with documents to attach to the emails in this queue. |
− | | | + | | |
|- | |- | ||
− | | | + | | use_personal_salutations |
| Use personal salutations? | | Use personal salutations? | ||
| yes/no | | yes/no | ||
− | | | + | | |
|- | |- | ||
− | | | + | | bounce_to_sender |
+ | | Should bounces (emails that cannot reach their destination) be returned to sender? If not, they will be returned to a generic email account and risk not being noticed. | ||
+ | | yes/no | ||
+ | | | ||
+ | |- | ||
+ | | incl_invalid_emails | ||
+ | | Should we send to email addresses we have previously registered as being invalid (eg. bounced)? | ||
+ | | yes/no | ||
+ | | | ||
+ | |- | ||
+ | | date_added | ||
| Date added | | Date added | ||
| datetime | | datetime | ||
− | | | + | | |
|- | |- | ||
− | | | + | | date_completed |
| Date completed | | Date completed | ||
| datetime | | datetime | ||
− | Is set when all | + | Is set when all emails in this queue have been sent. |
− | + | ||
| | | | ||
|} | |} |
Latest revision as of 17:59, 27 February 2017
Contents
- 1 Column Prefixes for all Database Tables
- 2 Database Tables/Fields - sharehim_main
- 2.1 Divisions (main_divisions)
- 2.2 Unions (main_unions)
- 2.3 Conferences or missions (main_conferences)
- 2.4 Conferences' Wire Information
- 2.5 Conference accepted people
- 2.6 Hub cities - Previously Hotel cities (main_hotels)
- 2.7 Date blocks' hotels (main_dateblockhotels)
- 2.8 Date blocks
- 2.9 Date blocks' orientations
- 2.10 Date blocks' predefined conferences
- 2.11 Campaign sites (main_sites)
- 2.12 Outreach Teams - Previous: Master Campaign sites (main_master_sites)
- 2.13 Outreach Leadership Team members
- 2.14 Churches
- 2.15 Workers / Officers
- 2.16 Church offices
- 2.17 Campaign site statistics
- 2.18 Campaign site statistics per conference
- 2.19 People (main_people)
- 2.20 Person events (main_personevents)
- 2.21 Person comments
- 2.22 Personal salutations
- 2.23 Colleges
- 2.24 Colleges' date blocks
- 2.25 Recommenders
- 2.26 Translations
- 2.27 Campaign material
- 2.28 Clusters
- 2.29 Cluster leaders
- 2.30 Groups
- 2.31 Teams
- 2.32 Orientation sites
- 2.33 Equipment booking
- 2.34 Equipment stock, cases
- 2.35 Equipment stock, laptops
- 2.36 Equipment stock, projectors
- 2.37 Material stock
- 2.38 Stories
- 2.39 Story pictures
- 2.40 Surveys
- 2.41 Donations
- 2.42 External logins
- 2.43 Password questions
- 2.44 Field descriptions
- 2.45 News
- 2.46 ShareSynch Serial Numbers
- 2.47 ShareSynch activations
- 2.48 System settings
- 2.49 E-mail templates
- 2.50 Email log, group e-mails
- 2.51 Email log, service requests reports
- 2.52 Mail queue
- 2.53 System translations
- 2.54 System translators
- 2.55 System log
- 2.56 Venue types
- 2.57 Countries
- 2.58 Currencies
- 2.59 Sponsors
- 2.60 Material groups
- 2.61 Equipment bases
- 2.62 Shipping methods
- 2.63 US states
- 2.64 Titles
- 2.65 Access levels
Column Prefixes for all Database Tables
list_accesslevels | acl |
list_accounts | acct |
list_activity_types | - |
list_canadaprovinces | province |
list_countries | - |
list_country_locale_formats | dtnl?? |
list_countrycurrencies | - |
list_currencies | (ccy) |
list_digitaldocs | ddoc |
list_donation_labels | - |
list_electricity_sockets | elsock |
list_electricitystandards | elstd |
list_equip_bases | eqbase |
list_graphics_languages | - |
list_materialgroups | - |
list_officer_positions | - |
list_precamp_types | precamp_type |
list_relationship_links | - |
list_royalty_orgs | - |
list_sermon_languages | - |
list_sharesynch_prefixes | sspre |
list_sharesynch_series | ssprod |
list_shipping_methods | - |
list_titles | - |
list_usps_zipcode_zones | - |
list_usstates | usstate |
list_venue_types | venue |
list_worker_statuses | - |
main_account_transactions | actr |
main_campaign_material | cmat |
main_churches | ch / church |
main_churchoffices | choff |
main_clusterleaders | |
main_clusters | |
main_collegedateblocks | cdb |
main_colleges | coll |
main_conf_accepts | cfacc |
main_conf_launches | |
main_conf_organizers | cforg |
main_conf_sectors | |
main_conferences | cf |
main_conferences_wireinfo | |
main_dateblock_requests | |
main_dateblockadmins | dba |
main_dateblockconfs | dbcf |
main_dateblockhotels | dbh |
main_dateblockorientations | dbo |
main_dateblocks | db |
main_divisions | div |
main_donations | don |
main_equip_batteries | eqbt |
main_equip_booking | eqbk |
main_equip_booking_payments | - |
main_equip_cases | cas |
main_equip_laptops | eq |
main_equip_projectors | proj |
main_event_budgetlines | ev_item |
main_event_budgets | |
main_ext_logins | xusr |
main_ext_shippers | extsh |
main_faq | |
main_groups | grp |
main_hotels | hot |
main_institutions | instt |
main_intl_managers | intmgr |
main_mail_contents | mc |
main_master_sites | ms / chtm |
main_material_restocking | mrest |
main_material_stock | mstck |
main_news | |
main_officers | wrk |
main_olts | oltm |
main_orders | ordr |
main_orders_items | ordrln |
main_orders_payments | - |
main_orientations | or |
main_people | p |
main_people_addresses | padr |
main_people_emails | pml |
main_people_namecorrections | pcor |
main_people_phones | ptel |
main_people_tags | ptag |
main_personcomments | |
main_personevents | pe |
main_personsalutations | psal |
main_pledges | pldg |
main_precamp_events | precamp |
main_rallies | |
main_recommenders | rec |
main_relationships | |
main_relationships_foreign | |
main_seminar_registrations | semreg |
main_sharesynch_activations | ssact |
main_sharesynch_personal_serials | pser |
main_sharesynch_serials | ssser |
main_sitefunding_notes | sfnot |
main_sitefunding_requests | sfreq |
main_sitefunding_requests_details | sfrd |
main_sitefunds_donations_applied | sfda |
main_sites | si |
main_sites_conf_statistics | sics |
main_sites_statistics | sist |
main_sociallogins | slog |
main_stories | st |
main_storypictures | stpic |
main_surveys | |
main_teams | tm |
main_terminology | |
main_training_accepts | teacc |
main_training_entities | te |
main_training_entities_conferences | - |
main_translations | sitr |
main_unions | un |
main_videos_newsmagazines | |
main_videos_official | |
satel_people | |
system_buffer | |
system_ctl_errors | err |
system_emailtemplates | |
system_fielddesc | |
system_ip_access | |
system_mail_queue | mq |
system_queries | qry |
system_settings | set / setting |
system_short_urls | surl |
system_translations | transl |
system_translators | |
temp_available_sites | |
temp_cached_address_latlon | |
temp_homeland_matching_stats | |
temp_new_churches | tmch |
temp_users | tusr |
temp_users_wp | wpusr |
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.
conferenceID |
Conference/mission ID | |
|
sda_orgID |
SDA organisation ID (AdmFieldID) | 4-letter abbreviation originating from adventistdirectory.org | |
sda_orgmastID |
SDA OrgMastID | 6-letter abbreviation originating from adventistdirectory.org. This is the master ID from eadventist.com. | |
unionID |
Union ID | |
|
name |
Name | |
|
name_contracted |
Name contracted | Short name for the conference. Used in homeland system. | |
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 | |
conf_email |
Conference e-mail | |
|
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 | |
conference_officers |
Conference officers | Comma-seperated list of e-mail addresses to which the service requests reminder will also be sent to. | |
homeland_particip |
Participant in homeland program? | yes/no | |
eadventist_authorized |
Churches & pastors synchronization setting |
Churches: Pastors: For 2 and up we also ask them to fill in the local ID for the church on the Church List page since we need that to be able to automatically link the pastors that are being fed by the local conference's database. |
|
allow_pastors_assign_speakers |
Allow pastor to do final acceptance of new applicants? |
0 : pastor's recommendation, conference-staff final approval | |
last_eadventist_update |
Last updated via eAdventist | For non-NAD conferences this indicates last time we updated the church list from AdventistDirectory.org | |
internal_comments |
Internal comments | ONLY coadmin and admin may see/edit this. | |
comments |
Public comments | |
|
world_x |
World map, X-coordinate | For the Flash world map | |
world_y |
World map, Y-coordinate | For the Flash world map | |
active |
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: |
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) Values set AND used by the system (only when status=waiting): |
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: |
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. | |
|
And then all the same fields as main_hotels. Note that dbh_active is currently used actively use (= cannot be set to No) and is only there to retain historic values. |
Date blocks
dateblockID | Date block ID | ||
opening_date | Opening date | req. | |
closing_date | Closing date | req. | |
appl_closed_date | Applications closing date | NO LONGER USED. Only kept for historic purposes.
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. |
|
title | 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 |
totalsites | 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... |
|
db_trip_price | Trip price | Only used in 2015 | |
db_appl_donation_amount | Application donation amount | Not used from 2015 forward | |
db_2nd_donation_date | 2nd donation deadline date | Not used from 2016 forward
Also occasionally called "middle deadline" |
|
db_2nd_donation_amount | 2nd donation amount | ||
db_final_donation_date | Final donation deadline date | Not used from 2016 forward
This value is also used for site-funding date block pre-2013 (instead of sitefund_deadline_unix that was always calculated) |
|
db_final_donation_amount | Final donation amount | Not applicable to date blocks from 2015 forward | |
db_child_discount | Discount amount for children | ||
db_youth_discount | Discount amount for youth | ||
db_singleroom_premium | Single room fee | can be overriden by group and individually in pe_singleroom_premium | |
db_allow_nongroup_appl | Allow non-group applications | Allow people to apply without selecting a group? | |
db_ask_language_skill | Ask language skill | Language that applicant should be asked whether or not he speaks it | opt. |
question_recipient | Questions recipient | intl_managerID of the person from main_intl_managers who will receive questions about this date block. This person will also be the lead date block manager. | |
precampaign_manager | Pre-campaign manager | intl_managerID of the person from main_intl_managers who will be the pre-campaign manager if different from the lead manager. | |
notify_sent_insurance_first | Insurance reminder sent date, 1st | ||
notify_sent_insurance_second | Insurance reminder sent date, 2nd | No longer used, we now only send one insurance request per date block | |
notify_sent_servreq_first | Service requests reminder sent date, 1st | ||
notify_sent_servreq_second | Service requests reminder sent date, 2nd | Just before the campaign | |
last_incomplete_notification |
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) | |
db_default_sharesynch_prefix | Default ShareSynch prefix | dropdown; must be a CD set (now we mainly use db_default_sharesynch_prefix instead)
Irrelevant for homeland campaigns. (Previously only used for in homeland: Displayed in the popup box for approving and selecting material for an applicant.) |
|
default_graphics_lang | Default sermon graphics language | (Now we mainly use db_default_sharesynch_prefix instead) | |
comments | Comments | Extended public description of the date block | |
applicant_note | Note for applicants | Special information for potential applicants before applying | |
db_fly_to_airport_iata | IATA airport code to fly to | The IATA code of the airport that participants should be flying to (so that we can look up prices) | |
application_monitors | 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. | |
mediafolder | Media folder | Base folder for uploading media files (pictures, video etc.) | |
predefined_unions_only | 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 | 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 (main_sites)
siteID |
Campaign site ID | |
|
master_siteID |
Master campaign site ID | Record ID in master sites table that this site originates from | |
dateblockhotelID |
Date block hotel city ID | |
req. |
campaign_date |
Campaign date |
- Homeland: the date from the matching record in main_dateblocks 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 |
Campaign type |
Possible options: Homeland only. |
|
name |
Site name/Campaign label |
- International: full site name (req.) Should be renamed to 'si_campaign_label'. Deprecated name used in the homeland is 'campaign_label'. |
see description |
campaign_begin_time |
Beginning time | time (hh:mm:ss)
Homeland only. |
req. for spk-init events |
campaign_end_date |
Ending date | date
Homeland only. |
req. for spk-init events and for events where speaker want to rent equipment from us |
campaign_weekdays |
Weekdays | Comma-separated list of 3-letter abbreviation of the weekdays the campaign will be held.
Homeland only. |
req. for spk-init events |
city |
Town/city | |
req. |
site_addr |
Address | |
Homeland:
req. for spk-init events |
site_state |
State | |
Homeland:
req. for spk-init events |
site_zip |
Zip | |
Homeland:
req. for spk-init events |
site_phone |
Phone | Only used in intl. system | |
site_email |
Only used in intl. system | | |
site_website |
Website | Only used in intl. system | |
venue_type |
Venue type | church/rented hall/open field/stadium etc. according to table list_venue_types | Intl:
always req. Homeland: req. for spk-init events |
personeventID |
Personevent ID | Link to the speaker | |
graphics_lang |
Sermon graphics language |
dropdown Only used in homeland. |
req. homeland only |
lifeochrist_lang |
Life of Christ video language | dropdown | req. |
video_format |
Desired video format | NOT USED ANYMORE. No longer applicable because we now use DVDs instead of VHS tapes.
dropdown |
|
congregations |
Congregations | number of congr. supp. this site
Only used in intl. system. |
req. |
membership |
Membership | total members in supp. congr.
Only used in intl. system. |
req. |
est_attendance |
Est. attendance | incl. SDA & non-SDA | req. |
baptismal_goal |
Baptismal goal | conservative number | req. |
km_from_hotel |
Km from hotel | |
req. |
pastor_workerIDs |
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 |
Ranking | |
req. |
comments |
Comments | |
|
planned_precamp_acts |
Planned pre-campaign activities | text
Homeland only. | |
campaign_status |
Campaign status |
Possible options: Homeland only. | |
active |
Active | yes/no | |
copyof |
Copy of site ID | If this is a copy of another site the original site's ID is saved here | |
date_added | Date added |
Outreach Teams - Previous: Master Campaign sites (main_master_sites)
List of Outreach Teams
master_siteID |
Master site ID | |
|
sda_orgID |
SDA organization ID | Reference to the church this OLT belongs to | req. for all new records |
conferenceID |
Conference ID | Conference this OLT is in | req. |
name |
Name |
Name of the OLT, usually the church name. Should be renamed to 'chtm_name'. Deprecated names are 'olt_name', 'church_name', and 'church_name2' in SQL output. |
|
ms_personID |
Person ID | In case a personal team is created this holds the link to the person (used for speaker-initiated campaigns) | |
hotelID |
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 |
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_lang |
Graphics language | Default graphics language used within this OLT. Actually language is always decided by the site record. | |
lifeofchrist_lang |
Life of Christ video language | Default video language used within this OLT. Actually language is always decided by the site record. | |
comments |
Comments | |
|
pw |
Password |
Password OLT members can use to access information for this OLT. Not really used at the moment. Usually renamed to 'olt_pw'. |
|
date_added |
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 - Don't trust it as an ID, their data management is sometimes a bit shaky. | ||
SDA entity ID | OMEntity from SDA-DB - Don't trust it as an ID, their data management is sometimes a bit shaky. | ||
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) | |
|
|
| |
|
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)
churchofficeID | Church office ID | Our own auto-generated ID | |
church_sda_orgID | Church SDA org ID | OrgMastID of church | |
workerID | Worker ID | |
|
office_name | 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) |
|
evangelistic_decision | 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_added | Data added | ||
date_modified | Date modified | Last date this record was modified in our own database. | |
date_removed | Date removed |
The date the pastor was no longer holding this office. Is set to 2000-01-01 if we don't know (= lost) the actual date. |
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: |
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 (main_people)
Guest speakers, support team members
PersonID 20531 with the name "Miscellaneous People" is not a specific person but can be used when a record in this table is required but we don't have or want to register any details about the person.
personID | Person ID | ||
sda_membershipID | 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_personeventID | Active person event ID | ||
legal_firstname | Legal firstname | req. | |
legal_lastname | Legal lastname | req. | |
title | Title | dropdown
Prefered to be set as the option "Pastor" is sometimes used to identify pastors. |
|
birthdate | Birth date | req. | |
gender | Gender | ||
marital_status | Marital status | dropdown | |
mailing_addr | Mailing address | req. | |
mailing_city | Mailing city | req. | |
mailing_state | Mailing state/province | req. | |
mailing_zip | Mailing zip/postal code | req. | |
street_addr | Street address | this is also their shipping address | req. |
street_city | Street city | req. | |
street_state | Street state/province | req. | |
street_zip | Street zipcode | req. | |
country | 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. | |
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) | ||
p_email_verified | E-mail verified | date Date when e-mail addr was verified |
|
email_invalid | 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 | 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 | 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 | 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. |
p_is_baptized | Is baptized? | ||
residence_division | Residence division | dropdown | req. |
residence_union | Residence union | dropdown | |
residence_conference | Residence conference | dropdown | |
residence_church | Name of residence church | text | |
residence_churchID | Residence church ID | number
Coming from main_churches.churchID |
|
appl_date | Application date | Started converting the name into p_date_added (eg. in get_people() ) | |
recommend_status | Remmendation status |
Possible values: (by sending fields/recommenders) |
|
recommender | Recommender |
Pastor/layman/academy in NAD: College students: |
|
recommender_comments | Recommender comments | |
|
sermon_language | Sermon notes language |
dropdown VALIDATION: |
req. for speakers |
p_speaks_languages | Speaks languages | Languages that person speaks, or partly speaks | |
preferred_cd_format | Preferred CD format |
Possible values: (old values: CD, DVD-Combo) |
req. for speakers |
done_bootcamp | Done boot camp? |
Has person taken the ShareHim boot camp training program? Possible values: (Being any type of pastor resolves to the same effect as saying yes) |
|
done_intl_campaign | 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 | First campaign | text
First ShareHim campaign that this person participated in as a speaker. Used for people applying for homeland campaigns. |
|
ref_name | Reference name | Pastoral applicants: ministerial sectary
Lay applicants: pastor Academy students: academy & contact |
req. for speakers |
ref_home_phone | Reference home phone |
This field is used to determine whether we are waiting for pastor info for an intl. applicant. Therefore if applicant is part of a group that has a designated recommender this field MUST be set to 000-000-0000 so that system doesn't wait for this number to be entered before starting processing the application. |
req. for speakers |
ref_office_phone | Reference office phone |
Pastoral applicants: ministerial sectary Lay applicants: pastor Academy students: academy |
|
ref_cell_phone | Reference cell phone |
Pastoral applicants: ministerial sectary Lay applicants: pastor Academy students: academy |
|
ref_email | Reference e-mail |
Pastoral applicants: ministerial sectary Lay applicants: pastor Academy students: academy |
req. for speakers |
emergency_name | Emergency contact name | Name of person to contact in case of emergency | |
emergency_email | Emergency e-mail | ||
emergency_phone | Emergency phone no. | ||
p_emergency_phone_alt | Alternate emergency phone no. | ||
pw | Password | Hash value | |
comments | Comments | ||
receive_newsletter | Receive newsletter? | Is person signed up for the Evangeliving newsletter? NULL: has not been set |
opt. |
received_mentorship_material | Received mentorship material | yes/no Did we send them the mentorship material? |
|
portrait_filename | Portrait filename | File for thumbnail image used in stories. | |
portrait_filename_authorized | Portrait is authorized? | yes/no | |
olt_leader | Outreach Leadership Team special status |
number 0 = ordinary OLT member (default) 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 | Is editor? |
Possible values: |
|
no_general_mailings | No general mailings |
Whether or not the person has requested not to receive general (non-campaign related) emails. |
req. |
dont_contact | Do not contact |
date When person should not receive any correspondence or be contacted, register the date this was set. |
|
dont_contact_reason | 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 | Hide person from public? |
number 0 = no 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)? |
req. |
requested_check_for_dupe | Person requested check for duplicate | Person indicated that they might already exist in our database. | |
p_authorizenet_cust_refID | Customer Reference ID from Authorize.net CIM system | ||
p_source | Source |
Indication of how this person originally got into the database. Possible values (also defined in main_peopleedit.php):
|
|
p_date_modified | Date modified |
Timestamp for when the record was last modified. Automatically updated whenever a change occurs. Used eg. in synchronization with Salesforce. |
Person events (main_personevents)
Homeland vs international: To determine if event is homeland you can use "eff_dateblockID IS NULL AND is_deleted = 0" for homeland and "eff_dateblockID IS NOT NULL AND is_deleted = 0" for international. For deleted events there is no sure way to determine it using this table only.
personeventID |
Person event ID | |
|
personID |
Person ID | |
|
dateblockID |
Date block ID | Only for non-college/university applicants | |
eff_dateblockID |
Effective date block ID | Updated to always hold the effective date block ID for this event (also when event has been deleted) | |
pe_eff_siteID | Effective site ID |
Updated to always hold the effective site ID for this event (mainly to make it easier to deal with associate speakers and STMs) - currently only filled out for homeland campaigns (but we might want to use it for intl as well). It's maintained even if event is deleted. |
|
categorymoved |
Category |
Possible values: |
|
collegedateblockIDmoved |
College date block ID | Only for college/university applicants | |
is_standby |
Is standby |
yes/no Is this a standby event? (Retained even though event is deleted) |
|
clusterID |
Cluster ID | Only for speakers
(the link to groups must of course match this link.) |
|
groupID |
Group ID | DEPRECATED! Only contains the groupID for main speakers and organizer. Eventually field should be removed. | |
pe_groupID |
Group ID | For speakers (both main and associate speakers), organizers, and support team members | |
teamID |
Team ID | Only for STMs - linking them to their speaker (Team ID in main_teams) | |
rankingID |
Ranking ID | |
|
cospeaker |
Associate speaker | yes/no
(we know the main speaker by the team the associate speaker is member of) || |
|
stm_purpose | STM purpose | For support team members: reason for them to be part of the trip | |
pref_dateblockhotelID |
Preferred hub city (date block hotel ID) | The hub city the person him/herself wishes to go to | |
pe_autodeduct_fees | Automatically charge creditcard/echeck according to fee schedule | yes/no | req. |
sitefund_fulfilled |
Site-funding fulfilled | If fulfilled, it has the ID of the belonging log entry from sharehim_log.system_operations.operationID | |
orientation_roomID |
Orientation, room ID | Other people having the same number will be staying in the same room | |
orientation_private_acc |
Orientation, private accommodation | yes/no | |
hotel_roomID |
Hotel city, room ID | Other people having the same number will be staying in the same room | |
hotel_private_acc |
Hotel city, private accommodation | yes/no | |
pe_share_room_with |
People to share room with | If person has not choosen a single room this field contains the names of the people they want to share a room with (if any specific desires). | |
pe_want_singleroom |
Want single room? | yes/no Whether person desires to stay in a single room and has accepted paying the premium |
|
pe_singleroom_premium |
Premium to pay for single room | number The amount the person has to pay for staying in a single room. |
|
orientation_flight_arr_date |
Orientation city, flight arrival date | |
req. for suppl. |
orientation_flight_arr_time |
Orientation city, flight arrival time | |
req. for suppl. |
orientation_airline |
Orientation city, airline | |
req. for suppl. |
orientation_flight |
Orientation city, flight no. | |
req. for suppl. |
orientation_selfarranged |
Self-arranged travel to orientation | yes/no
If yes none of the four fields above must be filled out || |
|
hotel_airport |
Hotel city, arrival airport | |
|
hotel_flight_arr_date |
Hotel city, flight arrival date | |
|
hotel_flight_arr_time |
Hotel city, flight arrival time | |
|
hotel_airline |
Hotel city, airline | |
|
hotel_flight |
Hotel city, flight no. | |
|
last_deposit_reminder |
Last deposit reminder | Days after application date that this reminder was last sent | |
last_sitefund_reminder |
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_hotelreserv_reminder |
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_flightarrival_reminder |
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 |
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_equiprental_reminder |
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)) | |
pe_brings_projector | Will he/she bring a projector? | Possible options: - 'no' : no, only a computer |
|
pe_parent_guardian_name | Parent/guardian name | Name of parent or guardian being responsible for this minor | |
minor_consentform |
Consent form for minors |
NULL = not a minor Is set to NULL when event is deleted if it was 1 or 3. |
|
no_sermonnotes |
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 (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 | opt. |
|
Comment | |
req. |
|
Comment type |
Possible values: |
opt. |
|
Flag |
dropdown Possible values: |
opt. |
|
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 | |
|
|
|
| |
|
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_shippers.ext_shipperID 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
groupID | Group ID | |
|
dateblockID | Date block ID | |
|
clusterID | Cluster ID | |
|
personeventID | Person event ID (leader) | Only speakers | |
name | Group name | |
|
contact_name | Contact name | |
|
contact_phone | Contact phone | |
|
contact_email | Contact e-mail | |
|
recommender_personID | Recommender personID | |
|
reserved_sites | Reserved sites | Will effectively always be filled out. | |
grp_funding_source | Funding source (site-funding) | Possible values:
|
req. |
grp_trip_price | Basic price of entire trip | Overrides dateblock setting if set | opt. |
grp_appl_donation_amount | Application donation amount | Overrides dateblock setting if set | opt. |
db_appl_donation_amount_children | Application donation amount for children | See 'max_child_age' in get_fixed_application_amounts() for a definition of children. | opt. |
grp_earlybird_discount | Early-bird discount amount | opt. | |
grp_earlybird_until | Early-bird discount deadline | req. if grp_earlybird_discount is set | |
grp_2nd_donation_date | 2nd donation deadline date | Overrides dateblock setting if set | opt. |
grp_2nd_donation_amount | 2nd donation amount | Overrides dateblock setting if set | opt. |
grp_final_donation_date | Final donation deadline date | Overrides dateblock setting if set | opt. |
grp_discount | Discount amount | The amount of discount applicants will get according to the rule specified in grp_discount_rule. | opt. |
grp_discount_rule | The rule by which to apply the discount | Possible values:
|
opt. |
grp_appl_closed_date | Applications closing date | Overrides dateblock setting if set.
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. |
opt. |
grp_includes_airfare | Does the price include airfare? | yes/no | opt. |
grp_singleroom_premium | Single room fee | Overrides dateblock setting if set | opt. |
grp_manual_price_info | Manual price information | Textual explanation of price that overrides any set prices and don't require payment from participant | opt. |
grp_deposit_received | Deposit received? | yes/no
No one excepts organizers can apply before deposit has been received if funding source is 'individually'. |
|
partial_payment_date | Partial payment date | date
Has no effect if amount is not set or 0. |
opt. |
partial_payment_amount | Partial payment amount | number
Has no effect if date is not set. |
opt. |
last_sitefund_reminder | Last site-fund reminder sent | date | |
grp_allow_select_lodging | Allow participants to indicate their lodging preferences? | yes/no | req. |
grp_equipment_options | Non-US equipment options | Equipment options to show on non-US application forms Possible values: |
req. |
show_on_availability | Show group on availability report? | yes/no | req. |
max_subdivide | Max subdivide | Max number of hotel cities the group is allowed to span across. Default one. | req. |
ranking_enabled | Ranking enabled? | yes/no (for ranking people) | |
comments | 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: |
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
bookingID | Booking ID | |
|
collegedateblockID | College date block ID | cond. | |
personeventID | Person event ID | cond. | |
eqbk_personID | Person ID | cond. | |
caseID | Case ID | |
|
eqbk_from_date | Booked from date | req. | |
eqbk_to_date | Booked to date | req. | |
bookingdate | Booking date | The date the booking was made (just for the information) | |
paid_amount | Paid amount | Only for non-student related | |
paid_date | Paid date | Set to 2000-01-01 if payment is n/a
Set to 1999-12-01 if payment is done through participating in an intl. event |
|
eqbk_ship_addr | Custom address to send the equipment to instead of the person's mailing address | ||
eqbk_ship_city | |||
eqbk_ship_state | |||
eqbk_ship_zip | |||
eqbk_ship_country | |||
outbound_method | Outbound method | dropdown | |
outbound_tracking | Outbound tracking no. | text (30) | |
outbound_date | Outbound date | ||
insurance | 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: | |
|
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: 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: If royalties must be paid when issueing this item select here which organization it must be reported to. | |
|
Shipper | ID of external shipper (from main_ext_shippers.ext_shipperID) (blank/null if internal) | |
|
Active | yes/no | |
Stories
|
Story ID | |
|
|
Date block ID | |
req. |
|
Story type |
dropdown Possible values: |
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 | Possible values: - online - echeck - check (= paper check) |
|
|
Pledge ID | |
|
ccard_no |
Credit Card/Account Number | For credit cards: last 4 digits of credit card number For eCheck: last 4 digits of bank account number |
|
|
...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
|
Login ID | |
|
|
Local ID | numeric (ID from div, un, conf etc.) | |
|
Firstname | |
|
|
Lastname | |
|
|
Password | |
|
|
|
| |
|
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 Only superadmin can see password, change information, add and delete users in external logins. Only superadmin can emulate and set password (set_pw.php) for admin and coadmin. Associate admins: the only difference between associate admins and normal admins is that they have less menu item on the menuadmin.php page (no restrictions or anything else). |
|
|
Fulltime |
yes/no If coadmins are full-time or part-time managers |
|
|
Approved | yes/no | |
|
Active | yes/no | |
|
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. |
Created serial numbers for the ShareSynch software
ss_serial_numberID | Serial Number ID | Internal ID | |
ss_serial_number | Serial Number | AA-XXXX-XXXX
AA will be a designator for which product it is. The old prefixes SH and GS always translates to CA (HWOH English). |
req. |
expiration_date | Expiration date | date | |
ssser_personID | Person ID | Person this serial number is connected to | |
personeventID | Person event ID | Event this serial number is connected to (and that usually causes an expiration date) | |
owner_name | Owner name | |
|
owner_email | Owner e-mail | |
|
activations_allowed | Activations allowed | |
req. |
is_printed | Is printed? | |
req. |
ssser_install_progress | Progress of the installation process by the user | 0 : not started at all
10 : clicked the Windows button on /download-sermons to download ShareSynch 20 : completed the activation process |
req. |
date_created | Date created | |
|
comments | Comments | |
|
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: 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 | |
|
|
|
| |
|
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 | |
|
|
| |
|
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 emails that have been or are being sent
mail_queueID | Mail queue ID | ||
by_localID | By local ID | User who made the queue | |
by_fromtable | By from table | User who made the queue | |
sender_name | Sender name | ||
sender_email | Sender email | ||
queryID | 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 | Custom subject | ||
attach_files | Attach files | Serialized PHP array with documents to attach to the emails in this queue. | |
use_personal_salutations | Use personal salutations? | yes/no | |
bounce_to_sender | Should bounces (emails that cannot reach their destination) be returned to sender? If not, they will be returned to a generic email account and risk not being noticed. | yes/no | |
incl_invalid_emails | Should we send to email addresses we have previously registered as being invalid (eg. bounced)? | yes/no | |
date_added | Date added | datetime | |
date_completed | Date completed | datetime
Is set when all emails 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
- column prefix: 'cntry_'
- 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
Sponsors
- eg.: Quiet Hour Ministries, and later on maybe The Voice of Prophecy
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.