Data

PXDBStateChangedByIDAttribute.StateChanger

PX.DataRelease 2025.2

Is used internally to represent the user who changed workflow state for the data record.

Select a row for its description 63 of 63 fields

	Field Name	Type	Display Name	Foreign Key
	`ActivationID`Nonexistent in DB	`string`		-
Description:No description available
	`AllowPasswordRecovery`	`bit`	Allow Password Recovery	-
Description:This field indicates whether the password can be recovered. The default value is true.
	`AllowedSessions`	`int`	Max. Number of Concurrent Logins	-
Description:The number of the allowed number of sessions for this user.
	`ApplicationName`	`nvarchar(32)`		-
Description:The name of the application for which the user was created.
	`Comment`	`nvarchar(255)`	Comment	-
Description:Additional information about this user.
	`ConfirmPassword`Nonexistent in DB	`string`	Confirm Password	-
Description:No description available
	`ContactID`Nonexistent in DB	`int?`	Linked Entity	-
Description:The linked contact for the user. Corresponds to the !:Contact.ContactID field.
	`CreationDate`	`datetime`	Account Creation Date	-
Description:The date and time of when the login was created.
	`DisplayName`Nonexistent in DB	`string`	Workflow State Changed By	-
Description:The full name of the user as a concatenation Users.FirstName and Users.LastName.
	`Domain`Nonexistent in DB	`string`	Domain	-
Description:The domain name of the user login
	`Email`	`nvarchar`	Email	-
Description:The email of the user.
	`Entity`Nonexistent in DB	`string`	Linked Entity	-
Description:No description available
	`ExtRef`	`nvarchar(512)`		-
Description:The user SID (Security Identifier) from AD.
	`FailedPasswordAnswerAttemptCount`	`int`	Number of Unsuccessful Attempts To Enter Recovery Answer	-
Description:The number of unsuccessful attempts to enter the answer to the Users.PasswordQuestion, after which the account should be locked.
	`FailedPasswordAnswerAttemptWindowStart`	`datetime`		-
Description:The date and time of when the user attempts to answer the Users.PasswordQuestion were exhausted.
	`FailedPasswordAttemptCount`	`int`	Number of Unsuccessful Attempts To Enter Password	-
Description:The number of unsuccessful attempts to enter the password after which the account should be locked.
	`FailedPasswordAttemptWindowStart`	`datetime`		-
Description:The date and time of when the user's attempts to login were exhausted.
	`FirstName`	`nvarchar(255)`	First Name	-
Description:The first name of the user.
	`ForbidLoginWithPassword`	`bit`	Forbid Login with Password	-
Description:This field indicates whether the login with the password has to be forbidden.
	`FullName`	`nvarchar`	Full Name	-
Description:The full name of the user as a concatenation Users.FirstName and Users.LastName.
	`GeneratePassword`Nonexistent in DB	`bool?`	Generate Password	-
Description:This field indicates whether the system needs to automatically generate the password automatically for this user. The default value is false (the user has to input the password manually).
	`GroupMask`	`varbinary`		-
Description:No description available
	`Guest`	`bit`	Guest Account	-
Description:The field indicates that login is guest account. The default value is false.
	`Included`Nonexistent in DB	`bool?`	Included	-
Description:No description available
	`IsADUser`Nonexistent in DB	`bool?`		-
Description:This field indicates whether the user login was created from AD.
	`IsApproved`	`bit`	Activate Account	-
Description:The field indicates that login was activated. The default value is true.
	`IsAssigned`	`bit`		-
Description:No description available
	`IsHidden`	`bit`		-
Description:No description available
	`IsLockedOut`Nonexistent in DB	`bool?`	Temporarily Lock Out Account	-
Description:This field indicates whether this login is temporarily locked out.
	`IsOnLine`	`bit`	Is Online	-
Description:This field indicates whether the user is online. The default value is false.
	`IsPendingActivation`	`bit`		-
Description:The field indicates that login is pending activation.
	`IsUserDisable`Nonexistent in DB	`bool?`		-
Description:Is user disabled
	`IsUserUpdated`Nonexistent in DB	`bool?`		-
Description:Is user updated
	`LastActivityDate`	`datetime`	Last Activity Date	-
Description:The date and time of the user's last activity.
	`LastLockedOutDate`	`datetime`	Last Lockout Date	-
Description:The date and time of when the login was locked out.
	`LastLoginDate`	`datetime`	Last Login Date	-
Description:The date and time of user's last login.
	`LastName`	`nvarchar(255)`	Last Name	-
Description:The last name of the user.
	`LastPasswordChangedDate`	`datetime`	Last Password Change Date	-
Description:The date and time of the last time the user changed the password.
	`LicenseStatus`Nonexistent in DB	`string`	License Status	-
Description:No description available
	`LockedOutDate`	`datetime`		-
Description:The date and time of the login lockout.
	`LoginTypeID`	`int`	User Type	-
Description:The type of the user login. Corresponds to the EPLoginType.LoginTypeID field.
	`MultiFactorOverride`	`bit`	Override Security Preferences	-
Description:This field indicates whether the security preferences will be overridden.
	`MultiFactorType`	`int`	Two-Factor Authentication	-
Description:The option of two-factor user authentication. The field can have one of the values listed in the its PXIntListAttribute. The default value is 0 ("None").
	`NewPassword`Nonexistent in DB	`string`	New Password	-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OldPassword`Nonexistent in DB	`string`	Old Password	-
Description:No description available
	`OverrideADRoles`	`bit`	Override Active Directory Roles with Local Roles	-
Description:This field indicates whether the Active Directory roles will be overridden with local roles. The default value is false.
	`OverrideLocalRolesWithOidcProviderRoles`	`bit`	Use Roles from Provider Settings	-
Description:This field indicates whether the local roles are overridden with OIDC (OpenID Connect) provider roles.
	`PKID`	`uniqueidentifier`		-
Description:The unique identifier assigned to the user login.
	`Password`Nonexistent in DB	`string`	Password	-
Description:The password of the user.
	`PasswordAnswer`	`nvarchar(255)`	Password Recovery Answer	-
Description:The answer to the question for recovering the password.
	`PasswordChangeOnNextLogin`	`bit`	Force User to Change Password on Next Login	-
Description:This field indicates that the user will have to change the password during next authentication. The default value is false.
	`PasswordChangeable`	`bit`	Allow Password Changes	-
Description:This field indicates whether the user can change the password. The default value is true.
	`PasswordNeverExpires`	`bit`	Password Never Expires	-
Description:This field indicates whether the password can expire. The default value is true.
	`PasswordQuestion`	`nvarchar(255)`	Password Recovery Question	-
Description:The question for recovering the password.
	`Phone`	`nvarchar(50)`	Phone	-
Description:The phone number of the user.
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RecoveryLink`Nonexistent in DB	`string`	Password Recovery Link	-
Description:The link for recovering the password.
	`Source`	`int`	Source	-
Description:This field indicates the location from where the user logged in. The field can have one of the values listed in the SM.PXUsersSourceListAttribute class. The default value is PXUsersSourceListAttribute.Application.
	`State`Nonexistent in DB	`string`	Status	-
Description:This fields indicates what is the current status of the user login. The field can have one of the values listed in the state.List class.
	`TwoFactorCode`Nonexistent in DB	`string`		-
Description:The code name for two-factor authentication.
	`Username`Default Navigation	`nvarchar(256)`	Workflow State Changed By	-
Description:The login name for the user. This field is a key field.
	`chkServiceManagement`Nonexistent in DB	`bool?`		-
Description:No description available