# UserProvAccount: User Provisioning Account
- Name: `UserProvAccount`
- Catalog: `Salesforce`
- Schema: `Salesforce`
- Primary Keys: `id`
- Label: User Provisioning Account
## Table Columns
The columns of the table `UserProvAccount` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `ConnectedAppId` | `string` | Connected Application ID | ☐ | |
| `CreatedById` | `string` | Created by ID | ☐ | |
| `CreatedDate` | `datetime` | Date Created | ☐ | |
| `DeletedDate` | `datetime` | Deleted Date | ☐ | |
| `ExternalEmail` | `string` | External Email | ☐ | |
| `ExternalFirstName` | `string` | External First Name | ☐ | |
| `ExternalLastName` | `string` | External Last Name | ☐ | |
| `ExternalUserId` | `string` | External User ID | ☐ | |
| `ExternalUsername` | `string` | External User Name | ☐ | |
| `Id` | `string` | ID | ☐ | |
| `IsDeleted` | `boolean` | Is Deleted | ☐ | |
| `IsKnownLink` | `boolean` | Is Known Link | ☐ | |
| `LastModifiedById` | `string` | Last Modified by ID | ☐ | |
| `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | |
| `LinkState` | `string` | Link State | ☐ | |
| `Name` | `string` | Name | ☐ | |
| `SalesforceUserId` | `string` | Salesforce User ID | ☐ | |
| `Status` | `string` | Status | ☐ | |
| `SystemModstamp` | `datetime` | System Modstamp | ☐ | |