Column Permission (mspp_columnpermission) table/entity reference

Messages

The following table lists the messages for the Column Permission (mspp_columnpermission) table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?
Web API Operation SDK for .NET
Create
Event: True
POST /mspp_columnpermissions
See Create
Create records
CreateMultiple
Event: True
CreateMultiple CreateMultipleRequest
Delete
Event: True
DELETE /mspp_columnpermissions(mspp_columnpermissionid)
See Delete
Delete records
Retrieve
Event: True
GET /mspp_columnpermissions(mspp_columnpermissionid)
See Retrieve
Retrieve records
RetrieveEntityChanges
Event: True
RetrieveEntityChangesRequest
RetrieveMultiple
Event: True
GET /mspp_columnpermissions
See Query data
Query data
Update
Event: True
PATCH /mspp_columnpermissions(mspp_columnpermissionid)
See Update
Update records
UpdateMultiple
Event: True
UpdateMultiple UpdateMultipleRequest
Upsert
Event: False
PATCH /mspp_columnpermissions(mspp_columnpermissionid)
See Upsert a table row
UpsertRequest
UpsertMultiple
Event: False
UpsertMultiple UpsertMultipleRequest

Events

The following table lists the events for the Column Permission (mspp_columnpermission) table. Events are messages that exist so that you can subscribe to them. Unless you added the event, you shouldn't invoke the message, only subscribe to it.

Name Web API Operation SDK for .NET
BulkRetain BulkRetain Learn to use messages with the SDK for .NET
PurgeRetainedContent PurgeRetainedContent Learn to use messages with the SDK for .NET
Retain Retain Learn to use messages with the SDK for .NET
RollbackRetain RollbackRetain Learn to use messages with the SDK for .NET
ValidateRetentionConfig ValidateRetentionConfig Learn to use messages with the SDK for .NET

Properties

The following table lists selected properties for the Column Permission (mspp_columnpermission) table.

Property Value
DisplayName Column Permission
DisplayCollectionName Column Permissions
SchemaName mspp_columnpermission
CollectionSchemaName mspp_columnpermissions
EntitySetName mspp_columnpermissions
LogicalName mspp_columnpermission
LogicalCollectionName mspp_columnpermissions
PrimaryIdAttribute mspp_columnpermissionid
PrimaryNameAttribute mspp_columnname
TableType Virtual
OwnershipType OrganizationOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

mspp_columnname

Property Value
Description The name of the custom entity.
DisplayName Column Name
IsValidForForm True
IsValidForRead True
LogicalName mspp_columnname
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 400

mspp_columnpermissionId

Property Value
Description Unique identifier for entity instances
DisplayName Column Permission
IsValidForForm False
IsValidForRead True
LogicalName mspp_columnpermissionid
RequiredLevel SystemRequired
Type Uniqueidentifier

mspp_columnpermissionprofileid

Property Value
Description
DisplayName Column Permission Profile
IsValidForForm True
IsValidForRead True
LogicalName mspp_columnpermissionprofileid
RequiredLevel ApplicationRequired
Type Lookup
Targets mspp_columnpermissionprofile

mspp_createdby

Property Value
Description Shows who created the record.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName mspp_createdby
RequiredLevel None
Type Lookup
Targets systemuser

mspp_createdon

Property Value
Description Shows the date and time when the record was created.
DisplayName Created On
IsValidForForm True
IsValidForRead True
LogicalName mspp_createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

mspp_modifiedby

Property Value
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName mspp_modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

mspp_modifiedon

Property Value
Description Shows the date and time when the record was modified.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName mspp_modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

mspp_permissions

Property Value
Description
DisplayName Permissions
IsValidForForm True
IsValidForRead True
LogicalName mspp_permissions
RequiredLevel ApplicationRequired
Type MultiSelectPicklist
DefaultFormValue
GlobalChoiceName mspp_columnpermissionvalues

mspp_permissions Choices/Options

Value Label
746610000 Create
746610001 Read
746610002 Update

statecode

Property Value
Description Status of the Column Permission
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State
DefaultFormValue
GlobalChoiceName mspp_columnpermission_statecode

statecode Choices/Options

Value Details
0 Label: Active
DefaultStatus: 1
InvariantName: Active
1 Label: Inactive
DefaultStatus: 2
InvariantName: Inactive

statuscode

Property Value
Description Reason for the status of the Column Permission
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status
DefaultFormValue
GlobalChoiceName mspp_columnpermission_statuscode

statuscode Choices/Options

Value Details
1 Label: Active
State:0
TransitionData: None
2 Label: Inactive
State:1
TransitionData: None

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

mspp_columnpermission_columnpermissionprofile

One-To-Many Relationship: mspp_columnpermissionprofile mspp_columnpermission_columnpermissionprofile

Property Value
ReferencedEntity mspp_columnpermissionprofile
ReferencedAttribute mspp_columnpermissionprofileid
ReferencingAttribute mspp_columnpermissionprofileid
ReferencingEntityNavigationPropertyName mspp_columnpermissionprofileid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_systemuser_mspp_columnpermission_createdby

One-To-Many Relationship: systemuser mspp_systemuser_mspp_columnpermission_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute mspp_createdby
ReferencingEntityNavigationPropertyName mspp_createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_systemuser_mspp_columnpermission_modifiedby

One-To-Many Relationship: systemuser mspp_systemuser_mspp_columnpermission_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute mspp_modifiedby
ReferencingEntityNavigationPropertyName mspp_modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

See also

Dataverse table/entity reference
Dataverse Web API Reference
mspp_columnpermission