# PermissionSetLicense: Permission Set Licenses - Name: `PermissionSetLicense` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Permission Set Licenses ## Table Columns The columns of the table `PermissionSetLicense` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `DeveloperName` | `string` | Developer Name | ☐ | | | `ExpirationDate` | `datetime` | Expiration Date | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `Language` | `string` | Language | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `MasterLabel` | `string` | Master Label | ☐ | | | `MaximumPermissionsAccessCMC` | `boolean` | Maximum Permissions Access CMC | ☐ | | | `MaximumPermissionsActivateContract` | `boolean` | Maximum Permissions Activate Contract | ☐ | | | `MaximumPermissionsActivateOrder` | `boolean` | Maximum Permissions Activate Order | ☐ | | | `MaximumPermissionsAllowEmailIC` | `boolean` | Maximum Permissions Allow Email IC | ☐ | | | `MaximumPermissionsAllowUniversalSearch` | `boolean` | Maximum Permissions Allow Universal Search | ☐ | | | `MaximumPermissionsAllowViewEditConvertedLeads` | `boolean` | Maximum Permissions Allow View Edit Converted Leads | ☐ | | | `MaximumPermissionsAllowViewKnowledge` | `boolean` | Maximum Permissions Allow View Knowledge | ☐ | | | `MaximumPermissionsApiEnabled` | `boolean` | Maximum Permissions API Enabled | ☐ | | | `MaximumPermissionsAssignPermissionSets` | `boolean` | Maximum Permissions Assign Permission Sets | ☐ | | | `MaximumPermissionsAssignTopics` | `boolean` | Maximum Permissions Assign Topics | ☐ | | | `MaximumPermissionsAuthorApex` | `boolean` | Maximum Permissions Author Apex | ☐ | | | `MaximumPermissionsBulkApiHardDelete` | `boolean` | Maximum Permissions Bulk API Hard Delete | ☐ | | | `MaximumPermissionsBulkMacrosAllowed` | `boolean` | Maximum Permissions Bulk Macros Allowed | ☐ | | | `MaximumPermissionsCampaignInfluence2` | `boolean` | Maximum Permissions Campaign Influence 2 | ☐ | | | `MaximumPermissionsCanApproveFeedPost` | `boolean` | Maximum Permissions Can Approve Feed Post | ☐ | | | `MaximumPermissionsCanInsertFeedSystemFields` | `boolean` | Maximum Permissions Can Insert Feed System Fields | ☐ | | | `MaximumPermissionsCanUseNewDashboardBuilder` | `boolean` | Maximum Permissions Can Use New Dashboard Builder | ☐ | | | `MaximumPermissionsChatterComposeUiCodesnippet` | `boolean` | Maximum Permissions Chatter Compose UI Code Snippet | ☐ | | | `MaximumPermissionsChatterEditOwnPost` | `boolean` | Maximum Permissions Chatter Edit Own Post | ☐ | | | `MaximumPermissionsChatterEditOwnRecordPost` | `boolean` | Maximum Permissions Chatter Edit Own Record Post | ☐ | | | `MaximumPermissionsChatterFileLink` | `boolean` | Maximum Permissions Chatter File Link | ☐ | | | `MaximumPermissionsChatterInternalUser` | `boolean` | Maximum Permissions Chatter Internal User | ☐ | | | `MaximumPermissionsChatterInviteExternalUsers` | `boolean` | Maximum Permissions Chatter Invite External Users | ☐ | | | `MaximumPermissionsChatterOwnGroups` | `boolean` | Maximum Permissions Chatter Own Groups | ☐ | | | `MaximumPermissionsConfigCustomRecs` | `boolean` | Maximum Permissions Config Custom Recs | ☐ | | | `MaximumPermissionsConnectOrgToEnvironmentHub` | `boolean` | Maximum Permissions Connect Org to Environment Hub | ☐ | | | `MaximumPermissionsContentAdministrator` | `boolean` | Maximum Permissions Content Administrator | ☐ | | | `MaximumPermissionsConvertLeads` | `boolean` | Maximum Permissions Convert Leads | ☐ | | | `MaximumPermissionsCreateCustomizeDashboards` | `boolean` | Maximum Permissions Create Customize Dashboards | ☐ | | | `MaximumPermissionsCreateCustomizeFilters` | `boolean` | Maximum Permissions Create Customize Filters | ☐ | | | `MaximumPermissionsCreateCustomizeReports` | `boolean` | Maximum Permissions Create Customize Reports | ☐ | | | `MaximumPermissionsCreateDashboardFolders` | `boolean` | Maximum Permissions Create Dashboard Folders | ☐ | | | `MaximumPermissionsCreatePackaging` | `boolean` | Maximum Permissions Create Packaging | ☐ | | | `MaximumPermissionsCreateReportFolders` | `boolean` | Maximum Permissions Create Report Folders | ☐ | | | `MaximumPermissionsCreateTopics` | `boolean` | Maximum Permissions Create Topics | ☐ | | | `MaximumPermissionsCreateWorkspaces` | `boolean` | Maximum Permissions Create Workspaces | ☐ | | | `MaximumPermissionsCustomizeApplication` | `boolean` | Maximum Permissions Customize Application | ☐ | | | `MaximumPermissionsCustomMobileAppsAccess` | `boolean` | Maximum Permissions Custom Mobile Apps Access | ☐ | | | `MaximumPermissionsCustomSidebarOnAllPages` | `boolean` | Maximum Permissions Custom Sidebar on All Pages | ☐ | | | `MaximumPermissionsDataExport` | `boolean` | Maximum Permissions Data Export | ☐ | | | `MaximumPermissionsDelegatedTwoFactor` | `boolean` | Maximum Permissions Delegated Two Factor | ☐ | | | `MaximumPermissionsDeleteActivatedContract` | `boolean` | Maximum Permissions Delete Activated Contract | ☐ | | | `MaximumPermissionsDeleteTopics` | `boolean` | Maximum Permissions Delete Topics | ☐ | | | `MaximumPermissionsDistributeFromPersWksp` | `boolean` | Maximum Permissions Distribute from Personal Workspace | ☐ | | | `MaximumPermissionsEditActivatedOrders` | `boolean` | Maximum Permissions Edit Activated Orders | ☐ | | | `MaximumPermissionsEditBrandTemplates` | `boolean` | Maximum Permissions Edit Brand Templates | ☐ | | | `MaximumPermissionsEditCaseComments` | `boolean` | Maximum Permissions Edit Case Comments | ☐ | | | `MaximumPermissionsEditEvent` | `boolean` | Maximum Permissions Edit Event | ☐ | | | `MaximumPermissionsEditHtmlTemplates` | `boolean` | Maximum Permissions Edit HTML Templates | ☐ | | | `MaximumPermissionsEditKnowledge` | `boolean` | Maximum Permissions Edit Knowledge | ☐ | | | `MaximumPermissionsEditMyDashboards` | `boolean` | Maximum Permissions Edit My Dashboards | ☐ | | | `MaximumPermissionsEditMyReports` | `boolean` | Maximum Permissions Edit My Reports | ☐ | | | `MaximumPermissionsEditOppLineItemUnitPrice` | `boolean` | Maximum Permissions Edit Opp Line Item Unit Price | ☐ | | | `MaximumPermissionsEditPublicDocuments` | `boolean` | Maximum Permissions Edit Public Documents | ☐ | | | `MaximumPermissionsEditPublicTemplates` | `boolean` | Maximum Permissions Edit Public Templates | ☐ | | | `MaximumPermissionsEditReadonlyFields` | `boolean` | Maximum Permissions Edit Read Only Fields | ☐ | | | `MaximumPermissionsEditTask` | `boolean` | Maximum Permissions Edit Task | ☐ | | | `MaximumPermissionsEditTopics` | `boolean` | Maximum Permissions Edit Topics | ☐ | | | `MaximumPermissionsEmailAdministration` | `boolean` | Maximum Permissions Email Administration | ☐ | | | `MaximumPermissionsEmailMass` | `boolean` | Maximum Permissions Email Mass | ☐ | | | `MaximumPermissionsEmailSingle` | `boolean` | Maximum Permissions Email Single | ☐ | | | `MaximumPermissionsEmailTemplateManagement` | `boolean` | Maximum Permissions Email Template Management | ☐ | | | `MaximumPermissionsEnableNotifications` | `boolean` | Maximum Permissions Enable Notifications | ☐ | | | `MaximumPermissionsExportReport` | `boolean` | Maximum Permissions Export Report | ☐ | | | `MaximumPermissionsFlowUFLRequired` | `boolean` | Maximum Permissions Flow UFL Required | ☐ | | | `MaximumPermissionsForceTwoFactor` | `boolean` | Maximum Permissions Force Two Factor | ☐ | | | `MaximumPermissionsGovernNetworks` | `boolean` | Maximum Permissions Govern Networks | ☐ | | | `MaximumPermissionsIdentityConnect` | `boolean` | Maximum Permissions Identity Connect | ☐ | | | `MaximumPermissionsIdentityEnabled` | `boolean` | Maximum Permissions Identity Enabled | ☐ | | | `MaximumPermissionsImportCustomObjects` | `boolean` | Maximum Permissions Import Custom Objects | ☐ | | | `MaximumPermissionsImportLeads` | `boolean` | Maximum Permissions Import Leads | ☐ | | | `MaximumPermissionsImportPersonal` | `boolean` | Maximum Permissions Import Personal | ☐ | | | `MaximumPermissionsInstallPackaging` | `boolean` | Maximum Permissions Install Packaging | ☐ | | | `MaximumPermissionsLightningExperienceUser` | `boolean` | Maximum Permissions Lightning Experience User | ☐ | | | `MaximumPermissionsManageAnalyticSnapshots` | `boolean` | Maximum Permissions Manage Analytic Snapshots | ☐ | | | `MaximumPermissionsManageAuthProviders` | `boolean` | Maximum Permissions Manage Auth Providers | ☐ | | | `MaximumPermissionsManageBusinessHourHolidays` | `boolean` | Maximum Permissions Manage Business Hour Holidays | ☐ | | | `MaximumPermissionsManageCallCenters` | `boolean` | Maximum Permissions Manage Call Centers | ☐ | | | `MaximumPermissionsManageCases` | `boolean` | Maximum Permissions Manage Cases | ☐ | | | `MaximumPermissionsManageCategories` | `boolean` | Maximum Permissions Manage Categories | ☐ | | | `MaximumPermissionsManageChatterMessages` | `boolean` | Maximum Permissions Manage Chatter Messages | ☐ | | | `MaximumPermissionsManageContentPermissions` | `boolean` | Maximum Permissions Manage Content Permissions | ☐ | | | `MaximumPermissionsManageContentProperties` | `boolean` | Maximum Permissions Manage Content Properties | ☐ | | | `MaximumPermissionsManageContentTypes` | `boolean` | Maximum Permissions Manage Content Types | ☐ | | | `MaximumPermissionsManageCustomPermissions` | `boolean` | Maximum Permissions Manage Custom Permissions | ☐ | | | `MaximumPermissionsManageCustomReportTypes` | `boolean` | Maximum Permissions Manage Custom Report Types | ☐ | | | `MaximumPermissionsManageDashbdsInPubFolders` | `boolean` | Maximum Permissions Manage Dashboards in Public Folders | ☐ | | | `MaximumPermissionsManageDataCategories` | `boolean` | Maximum Permissions Manage Data Categories | ☐ | | | `MaximumPermissionsManageDataIntegrations` | `boolean` | Maximum Permissions Manage Data Integrations | ☐ | | | `MaximumPermissionsManageDynamicDashboards` | `boolean` | Maximum Permissions Manage Dynamic Dashboards | ☐ | | | `MaximumPermissionsManageEmailClientConfig` | `boolean` | Maximum Permissions Manage Email Client Config | ☐ | | | `MaximumPermissionsManageEncryptionKeys` | `boolean` | Maximum Permissions Manage Encryption Keys | ☐ | | | `MaximumPermissionsManageExchangeConfig` | `boolean` | Maximum Permissions Manage Exchange Config | ☐ | | | `MaximumPermissionsManageHealthCheck` | `boolean` | Maximum Permissions Manage Health Check | ☐ | | | `MaximumPermissionsManageInteraction` | `boolean` | Maximum Permissions Manage Interaction | ☐ | | | `MaximumPermissionsManageInternalUsers` | `boolean` | Maximum Permissions Manage Internal Users | ☐ | | | `MaximumPermissionsManageIpAddresses` | `boolean` | Maximum Permissions Manage IP Addresses | ☐ | | | `MaximumPermissionsManageKnowledge` | `boolean` | Maximum Permissions Manage Knowledge | ☐ | | | `MaximumPermissionsManageKnowledgeImportExport` | `boolean` | Maximum Permissions Manage Knowledge Import Export | ☐ | | | `MaximumPermissionsManageLeads` | `boolean` | Maximum Permissions Manage Leads | ☐ | | | `MaximumPermissionsManageLoginAccessPolicies` | `boolean` | Maximum Permissions Manage Login Access Policies | ☐ | | | `MaximumPermissionsManageMobile` | `boolean` | Maximum Permissions Manage Mobile | ☐ | | | `MaximumPermissionsManageNetworks` | `boolean` | Maximum Permissions Manage Networks | ☐ | | | `MaximumPermissionsManagePasswordPolicies` | `boolean` | Maximum Permissions Manage Password Policies | ☐ | | | `MaximumPermissionsManageProfilesPermissionsets` | `boolean` | Maximum Permissions Manage Profiles Permission Sets | ☐ | | | `MaximumPermissionsManagePvtRptsAndDashbds` | `boolean` | Maximum Permissions Manage Private Reports and Dashboards | ☐ | | | `MaximumPermissionsManageRemoteAccess` | `boolean` | Maximum Permissions Manage Remote Access | ☐ | | | `MaximumPermissionsManageReportsInPubFolders` | `boolean` | Maximum Permissions Manage Reports in Public Folders | ☐ | | | `MaximumPermissionsManageRoles` | `boolean` | Maximum Permissions Manage Roles | ☐ | | | `MaximumPermissionsManageSearchPromotionRules` | `boolean` | Maximum Permissions Manage Search Promotion Rules | ☐ | | | `MaximumPermissionsManageSessionPermissionSets` | `boolean` | Maximum Permissions Manage Session Permission Sets | ☐ | | | `MaximumPermissionsManageSharing` | `boolean` | Maximum Permissions Manage Sharing | ☐ | | | `MaximumPermissionsManageSolutions` | `boolean` | Maximum Permissions Manage Solutions | ☐ | | | `MaximumPermissionsManageSynonyms` | `boolean` | Maximum Permissions Manage Synonyms | ☐ | | | `MaximumPermissionsManageTwoFactor` | `boolean` | Maximum Permissions Manage Two Factor | ☐ | | | `MaximumPermissionsManageUnlistedGroups` | `boolean` | Maximum Permissions Manage Unlisted Groups | ☐ | | | `MaximumPermissionsManageUsers` | `boolean` | Maximum Permissions Manage Users | ☐ | | | `MaximumPermissionsMassInlineEdit` | `boolean` | Maximum Permissions Mass Inline Edit | ☐ | | | `MaximumPermissionsMergeTopics` | `boolean` | Maximum Permissions Merge Topics | ☐ | | | `MaximumPermissionsModerateChatter` | `boolean` | Maximum Permissions Moderate Chatter | ☐ | | | `MaximumPermissionsModerateNetworkUsers` | `boolean` | Maximum Permissions Moderate Network Users | ☐ | | | `MaximumPermissionsModifyAllData` | `boolean` | Maximum Permissions Modify All Data | ☐ | | | `MaximumPermissionsModifySecureAgents` | `boolean` | Maximum Permissions Modify Secure Agents | ☐ | | | `MaximumPermissionsNewReportBuilder` | `boolean` | Maximum Permissions New Report Builder | ☐ | | | `MaximumPermissionsPasswordNeverExpires` | `boolean` | Maximum Permissions Password Never Expires | ☐ | | | `MaximumPermissionsPublishPackaging` | `boolean` | Maximum Permissions Publish Packaging | ☐ | | | `MaximumPermissionsResetPasswords` | `boolean` | Maximum Permissions Reset Passwords | ☐ | | | `MaximumPermissionsRunFlow` | `boolean` | Maximum Permissions Run Flow | ☐ | | | `MaximumPermissionsRunReports` | `boolean` | Maximum Permissions Run Reports | ☐ | | | `MaximumPermissionsSalesConsole` | `boolean` | Maximum Permissions Sales Console | ☐ | | | `MaximumPermissionsScheduleReports` | `boolean` | Maximum Permissions Schedule Reports | ☐ | | | `MaximumPermissionsSelectFilesFromSalesforce` | `boolean` | Maximum Permissions Select Files from Salesforce | ☐ | | | `MaximumPermissionsSendAnnouncementEmails` | `boolean` | Maximum Permissions Send Announcement Emails | ☐ | | | `MaximumPermissionsSendSitRequests` | `boolean` | Maximum Permissions Send Site Requests | ☐ | | | `MaximumPermissionsShareInternalArticles` | `boolean` | Maximum Permissions Share Internal Articles | ☐ | | | `MaximumPermissionsShowCompanyNameAsUserBadge` | `boolean` | Maximum Permissions Show Company Name as User Badge | ☐ | | | `MaximumPermissionsSolutionImport` | `boolean` | Maximum Permissions Solution Import | ☐ | | | `MaximumPermissionsSubmitMacrosAllowed` | `boolean` | Maximum Permissions Submit Macros Allowed | ☐ | | | `MaximumPermissionsSubscribeToLightningReports` | `boolean` | Maximum Permissions Subscribe to Lightning Reports | ☐ | | | `MaximumPermissionsTransferAnyCase` | `boolean` | Maximum Permissions Transfer Any Case | ☐ | | | `MaximumPermissionsTransferAnyEntity` | `boolean` | Maximum Permissions Transfer Any Entity | ☐ | | | `MaximumPermissionsTransferAnyLead` | `boolean` | Maximum Permissions Transfer Any Lead | ☐ | | | `MaximumPermissionsTwoFactorApi` | `boolean` | Maximum Permissions Two Factor API | ☐ | | | `MaximumPermissionsUseTeamReassignWizards` | `boolean` | Maximum Permissions Use Team Reassign Wizards | ☐ | | | `MaximumPermissionsViewAllActivities` | `boolean` | Maximum Permissions View All Activities | ☐ | | | `MaximumPermissionsViewAllData` | `boolean` | Maximum Permissions View All Data | ☐ | | | `MaximumPermissionsViewAllUsers` | `boolean` | Maximum Permissions View All Users | ☐ | | | `MaximumPermissionsViewContent` | `boolean` | Maximum Permissions View Content | ☐ | | | `MaximumPermissionsViewDataAssessment` | `boolean` | Maximum Permissions View Data Assessment | ☐ | | | `MaximumPermissionsViewDataCategories` | `boolean` | Maximum Permissions View Data Categories | ☐ | | | `MaximumPermissionsViewEncryptedData` | `boolean` | Maximum Permissions View Encrypted Data | ☐ | | | `MaximumPermissionsViewEventLogFiles` | `boolean` | Maximum Permissions View Event Log Files | ☐ | | | `MaximumPermissionsViewHealthCheck` | `boolean` | Maximum Permissions View Health Check | ☐ | | | `MaximumPermissionsViewHelpLink` | `boolean` | Maximum Permissions View Help Link | ☐ | | | `MaximumPermissionsViewMyTeamsDashboards` | `boolean` | Maximum Permissions View My Teams Dashboards | ☐ | | | `MaximumPermissionsViewPublicDashboards` | `boolean` | Maximum Permissions View Public Dashboards | ☐ | | | `MaximumPermissionsViewPublicReports` | `boolean` | Maximum Permissions View Public Reports | ☐ | | | `MaximumPermissionsViewSetup` | `boolean` | Maximum Permissions View Setup | ☐ | | | `MaximumPermissionsWorkCalibrationUser` | `boolean` | Maximum Permissions Work Calibration User | ☐ | | | `MaximumPermissionsWorkDotComUserPerm` | `boolean` | Maximum Permissions Work.com User Permission | ☐ | | | `PermissionSetLicenseKey` | `string` | Permission Set License Key | ☐ | | | `Status` | `string` | Status | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `TotalLicenses` | `int32` | Total Licenses | ☐ | | | `UsedLicenses` | `int32` | Used Licenses | ☐ | |