The marketing database is made up of two tables in MarketingDB – SCHOOLS2 and SCHOOL_CONTACTS2
The tables are joined on a 1 to many relationship but there is one particular contact_type that is different.
contact_type = ‘CURRENT’
The ‘CURRENT’ contact_type means the current primary contact for the yearbook. A school can have many contact types but this is the most important for the marketing database.
Other contact types are Assistant Principals, Teacher, secretaries, etc. The following are a list of valid contact types. More can be added to the CONTACT_STATUS table as needed
| ACTIVITIES DIRECTOR | Activities Director |
| CURRENT | Current Yearbook Advisor |
| GRADUATION COORDINATOR | Graduation Coordinator |
| OBSOLETE | Obsolete – No Longer Contact |
| PTA/PTO | Current PTA/PTO Yearbook Contact |
| TEACHER | Teacher |
| TREASURER | Treasurer |
| VICE PRINCIPAL | Vice Principal |
Valid Advisor Coding values
Only use the value that is in ALL Caps
- EMAIL – Email collected
- PRINCIPAL EMAIL – Principal Email Collected (this doesn’t make sense)
- DUPLICATE – This school is a duplicate of another school
- NO YEARBOOK
- LEFT VOICEMAIL
- WRONG NUMBER
- NO ANSWER
- WON’T SHARE
- OTHER
