# OwnerUsers: Exact Online Users ## Documentation: Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- divisionchr(13) || chr(10) || chr(13) || chr(10)- usernamechr(13) || chr(10) || chr(13) || chr(10)- startdate_fromchr(13) || chr(10) || chr(13) || chr(10)- startdate_to - Catalog: `ExactOnlineXML` - Schema: `XML` - Primary Keys: `username_attr` - Label: Users The data in this table is partitioned per value of the `Division` column. - Retrieve: True - Insert: True - Update: True - Delete: False - Filters on API Server: division - username - startdate_from - startdate_to ## Table Columns The columns of the table `OwnerUsers` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUTHENTICATION_ATTR` | `number` | Authentication | | Possible values: 0=No login rights, 4=Federated authentication (EIS), 10=Forms and TOTP authentication | | `BIRTHDATE` | `date` | Birth Date | | | | `BIRTHNAME` | `varchar2` | Birth Name | | | | `BIRTHNAMEPREFIX` | `varchar2` | Birth Name Prefix | | | | `DIVISION_CODE` | `varchar2` | Administration ID | ☑ | Internal unique number of the Exact Online administration. | | `DIVISION_HID` | `int64` | Administration | ☑ | Number of the Exact Online administration. Not guaranteed to be unique. | | `DIVISION_NAME` | `varchar2`(240) | Administration Name | ☑ | Name of the Exact Online administration. Not guaranteed to be unique. | | `EMAIL` | `varchar2` | Email | | | | `ENDDATE` | `date` | End Date | | End date: YYYY-MM-DD | | `FAX` | `varchar2` | Fax | | | | `FIRSTNAME` | `varchar2` | First Name | | | | `FULLNAME` | `varchar2` | Full Name | | | | `GENDER_ATTR` | `varchar2` | Gender | | | | `ID_ATTR` | `varchar2` | ID | ☑ | | | `IMAGE_BINARYDATA` | `blob` | Image Binary Data | | | | `IMAGE_ID_ATTR` | `varchar2` | Image ID | | | | `IMAGE_NAME` | `varchar2` | Image Name | | | | `INITIALS` | `varchar2` | Initials | | | | `INTERFACE_URL` | `varchar2`(4000) | Interface URL | ☑ | URL used to interface this row with Exact Online. | | `ISANONYMISED` | `boolean` | Is Anonymised | | | | `LANGUAGE_CODE_ATTR` | `varchar2` | Language Code | | | | `LANGUAGE_DESCRIPTION_TERMID_ATTR` | `number` | Language Description Term ID | | | | `LANGUAGE_DESCRIPTION` | `varchar2`(255) | Language Description | | | | `LASTNAME` | `varchar2` | Last Name | | | | `MIDDLENAME` | `varchar2` | Middle Name | | | | `MOBILE` | `varchar2` | Mobile | | | | `NATIONALITY_CODE_ATTR` | `varchar2` | Nationality Code | | | | `NATIONALITY_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `NATIONALITY_DESCRIPTION` | `varchar2`(255) | Nationality Description | | | | `NICKNAME` | `varchar2` | Nick Name | | | | `NOTE` | `varchar2` | Note | | Notes can contain many different characters, make sure to use a CDATA section. | | `PARTNERNAME` | `varchar2` | Name of Partner | | | | `PARTNERNAMEPREFIX` | `varchar2` | Partner Name Prefix | | | | `PHONE` | `varchar2` | Phone | | | | `PHONEEXT` | `varchar2` | Phone Extension | | | | `ROWNUM` | `int64` | Row Number | ☑ | Number of the row within the results, starting at 1. | | `SOCIALSECURITYNUMBER` | `varchar2` | Social Security Number | | | | `STARTDATE` | `date` | Start Date | | Start date: YYYY-MM-DD | | `TITLE_ABBREVIATION` | `varchar2` | Title Abbreviation | | | | `TITLE_CODE_ATTR` | `varchar2` | Title Code | | | | `TITLE_DESCRIPTION_TERMID_ATTR` | `number` | Title Description Term ID | | | | `TITLE_DESCRIPTION` | `varchar2`(255) | Title Description | | | | `TITLE_GENDER` | `varchar2` | Title Gender | | | | `TITLE_HEADING` | `varchar2` | Title Heading | | | | `TITLE_LANGUAGE` | `varchar2` | Title Language | | | | `USERADMINISTRATIONS` | `varchar2` | User Administrations | | | | `USERNAME_ATTR` | `varchar2` | User Name | ☑ | | | `USERTYPES` | `varchar2` | User Types | | |