|NOTES FOR PERSON-POSTINGS
- 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].|