UserTable::getMap

static function getMap()
{
	$emptyValue = serialize([]);
	$emptyValue2 = serialize([0]);

	$additionalFields = [
		(new ExpressionField(
			'IS_INTRANET_USER',
			'CASE WHEN
				((%s IS NOT NULL AND %s != '' . $emptyValue . '' AND %s != '' . $emptyValue2 . '') AND
				(%s IS NULL OR %s NOT IN ('' . implode('', '', self::filterExternalUserTypes(['bot'])) . '')))
				OR (%s = 'bot')
				THEN 'Y'
				ELSE 'N'
			END',
			['UF_DEPARTMENT', 'UF_DEPARTMENT', 'UF_DEPARTMENT', 'EXTERNAL_AUTH_ID', 'EXTERNAL_AUTH_ID', 'EXTERNAL_AUTH_ID'],
			['values' => ['N', 'Y']]
		))->configureValueType(BooleanField::class)
	];

	return array_merge(parent::getMap(), $additionalFields);
}