NOTES FOR  PERSON-POSTINGS TABLE: - This table contain records that uniquely identify a person, on particular post in a particular country AND in particular time frame. - One person can be posted to the same country many times and each time in a particular time frame. - City field may or may not contain any value. - All appointment date related fields [year, month, day] may contain invalid or empty value. If these fields are concatenated as date field, the resulting date field may be invalid. If used, the appointment fields [or concatenated date field] should be used as a string/text value [not as date] .
FIELD IN A RECORD	FIELD DESCRIPTION
PERSON_ID	Person unique identifier
LAST_NAME	Person's last name
FIRST_NAME	Person's first name
POSTING_ID	Posting unique identifier.  uniquely identifies a person posting in particular country and in particular time frame
TITLE_SHORT_ENG	Person's abbreviated title in English
TITLE_SHORT_FRA	Person's abbreviated title in French
TITLE_DESCRIPTION_ENG	Person's full title name in English
TITLE_DESCRIPTION_FRA	Person's full title name in French
COUNTRY_NAME_ENG	Country name in English
COUNTRY_NAME_FRA	Country name in French
COUNTRY_ID	Country unique identifier
City	City name in English. May contain no value [empty].
APPT_YEAR	Year when a person was appointed to posting. May contain invalid or no value [empty].
APPT_MONTH	Month when a person was appointed to posting. May contain invalid or no value [empty].
APPT_DAY	Day when a person was appointed to posting. May contain invalid or no value [empty].