Is it valid to have a NULL Employee Number where system_person_type is 'EMP'?
Question regarding employee number for a person:
If the per_person_types.system_person_type is 'EMP', would it be expected that the person would have an employee_number in per_all_people_f? Is there any valid situation where it would not be expected to have an employee_number for such a person?
Same questions again, but this time for per_person_types.system_person_type value of 'EMP_APL'. Is it valid for employee_number to be NULL?
I am trying to determine if a scenario in iAssets is a bug or a result of data corruption. Thanks.