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