.. index::
   tbl1_Person_History

===================
tbl1_Person_History
===================

.. default-role:: doc

:Description:

   List of employment events for a person

:Relation:

   many-to-one on tbl1_Person_History.PersonID = tbl1_People.personID
   one-to-one on tbl1_Person_History.EventCode = tbl1_People_Events.id



Columns
=======


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

   :Options:

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


**PersonID** ``int(11) DEFAULT NULL``

   :Description:

      id of person

   :Relation:

          relates to PersonID in tbl1_People table

   :Options:

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


**Timestamp** ``datetime DEFAULT NULL``

   :Description:

          Date/time event was logged

   :Options:

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


**EventDate** ``datetime DEFAULT NULL``

   :Description:

          Date of event

   :Options:

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


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

   :Description:

          id code of event as in the `tbl1_People_Events` table

   :Relation:

          one-to-one relationship where tbl1_Person_History.EventCode = tbl1_People_Events.id

   :Options:

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


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

   :Description:

      Name of corresponding event

   :Options:

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


**EventSession** ``varchar(20) DEFAULT NULL``

   :Description:

      Fall, Spring or Summer

   :Options:

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


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

   :Description:

      Semester Year the event happened

   :Options:

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


**ExpectedEndDate** ``datetime DEFAULT NULL``

   :Description:

      For evants like away on Sabbatical, this is expected end date of event

   :Options:

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


**EventNotes** ``mediumtext DEFAULT NULL``

   :Description:

      Notes about the event

   :Options:

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


**title_category_from** ``varchar(15) DEFAULT NULL``

   :Options:

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


**title_from** ``varchar(100) DEFAULT NULL``

   :Options:

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


**title_category_to** ``varchar(15) DEFAULT NULL``

   :Description:

      For events where a person's category changes, this is category before the 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** ``varchar(100) DEFAULT NULL``

   :Description:

      For events where a person's category changes, this is category after the 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=""``