.. index::
   tbl1_People_Events

==================
tbl1_People_Events
==================

.. default-role:: doc

:Description:

     Possible employment events for a person used in the `tbl1_Person_History` table

:Relation:

     one to one with `tbl1_Statuses` where tbl1_People_Events.RelatedStatusCode = tbl1_Statuses.id

:Footnote:

   This behavior is related to other notes about people status/active/inactive etc.
   This is an evolving area of Solutions where we might want to change things.
   But for now the RelatedStatusCode field in this table indicates the status a person should be given
   after the particular event takes place



Columns
=======


**ID** ``int(11) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**EventName** ``varchar(255) DEFAULT NULL``

   :Description:

      Description of event (for example Hired, Retired)

   :Options:

      ``display="true", null="true", search="false", type=""``


**RelatedStatusCode** ``smallint(6) DEFAULT NULL``

   :Description:

      status code related to the status a person should be after this event happens

   :Relation:

      relates to ID field in `tbl1_Statuses` table

   :Options:

      ``display="true", null="true", search="false", type=""``


**contact_email** ``varchar(60) DEFAULT NULL``

   :Description:

      If this event happens, email of person who should be contacted?

   :Options:

      ``display="true", null="true", search="false", type=""``


**event_email_template** ``mediumtext DEFAULT NULL``

   :Description:

      Email template if this event happens

   :Options:

      ``display="true", null="true", search="false", type=""``


**title_from_usage** ``smallint(6) DEFAULT NULL``

   :Description:

      Person's title after this event

   :Footnote:

      This relates to the beginnings of a feature in Solutions never fully implemented.
      The concept was that there are different event-related values we might want to save.
      In this case, related to a "promotion" event, we would want to remember the person's title both
      before and after the promotion took place.

   :Options:

      ``display="true", null="true", search="false", type=""``


**title_to_usage** ``smallint(6) DEFAULT NULL``

   :Description:

      Person's title after this event

   :Options:

      ``display="true", null="true", search="false", type=""``


**last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()``

   :Options:

      ``display="true", null="true", search="false", type=""``