Officer can be imported as part of Learner, Applicant and Organisation FROM JUNE 2022 Imports. The officer can be specified either as a PICS Officer Code or as a Name.
If the Officer code is specified and found in PICS it will be used.
If the Officer code is not specified or not found but the Full name or Surname and First names are specified any matching Officer will be used or a new Officer record created.
The Import field for the Officer code can be suffixed with the fieldnames below.
Suffix | Example Column name | Example Data |
|---|---|---|
_OFFFULLNAME | MAIN_OFFICER_OFFFULLNAME | Davey Jones |
_OFFSURNAME | MAIN_OFFICER_OFFSURNAME | Jones |
_OFFFIRSTNAME | MAIN_OFFICER_OFFFIRSTNAME | Davey |
_OFFPHONE | MAIN_OFFICER_OFFPHONE | 01603492620 |
_OFFEMAIL | MAIN_OFFICER_OFFEMAIL | davey@help.com |