Users
Available since: v1.0.0
| File | Snapshot | Delta | Frequency |
|---|---|---|---|
| users/users_yyyy_MM_dd.csv | :white_check_mark: | :white_check_mark: | Daily |
| Attribute | Required? | Value | Description |
|---|---|---|---|
| USER_ID | Yes | NUMBER | Id field used to uniquely identify user. |
| LOGIN | Yes | VARCHAR2(64 BYTE) | Username used for login |
| FIRST_NAME | VARCHAR2(40 BYTE) | ||
| MIDDLE_NAME | VARCHAR2(40 BYTE) | ||
| LAST_NAME | VARCHAR2(40 BYTE) | ||
| Yes | VARCHAR2(64 BYTE) | ||
| EMAIL_STATUS | NUMBER | 1 = verified 2 = not verified | |
| RECEIVE_EMAIL | 0 or 1 | The front-ends can pass this along to indicate that the user has agreed to receive newsletters or other non subscription-related information from the service | |
| GENDER | NUMBER | Determined by front-end how it’s set (e.g. 1=Male, 2=Female) | |
| DATE_OF_BIRTH | DATE | ||
| PHONENUM | VARCHAR2(15 BYTE) | ||
| MOBILENUM | VARCHAR2(15 BYTE) | ||
| MOBILE_STATUS | 0 or 1 | Can be used to indicate that mobile number has been verified | |
| RECEIVE_SMS | 0 or 1 | Can be set to indicate that the end-user has agreed to receive sms from the service | |
| ADDRESS | VARCHAR2(64 BYTE) | ||
| POSTAL_CODE | VARCHAR2(10 BYTE) | ||
| CITY | VARCHAR2(30 BYTE) | ||
| STATE | VARCHAR2(20 BYTE) | As in “Texas”, “Califorinia” | |
| COUNTRY | VARCHAR2(40 BYTE) | ||
| STATUS | NUMBER | Used to delete users that have been inactive for a long period. This is not done automatically, but upon request. 0 or null = active 1 = passive 2 = delete_warning sent to user 3 = deleted (by system) 4 = deleted (by admin) 5 = frozen (For customers who have voluntarily suspended their account) 6 = blocked (For customers who haven’t paid their bills) | |
| STATUS_DATE | DATE | Date the status was updated | |
| NICKNAME | VARCHAR2(40 BYTE) | ||
| INFO_RESTRICTED | 0 or 1 | ||
| CURRENT_PLAYQUEUE_ID | NUMBER | Used to keep track of the main play queue of the user | |
| RECEIVE_FAVORITE_EMAIL | 0 or 1 | Indicates if the user wants to receive e-mails with update on shows marked as favorite | |
| UPDATE_TIME | DATE | ||
| REIGSTRATON_DATE | DATE | ||
| JWT_SUBJECT_ID | VARCHAR2(256 BYTE) | If user is migrated, this column holds the ID of the user in the identity provider. The format of the value is {issuer}|{subject} as seen in the token issued by the identity provider.Available since 2.9.0 |