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].