tbl1_Person_History¶
- 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=""