UserAccounts

Columns


Name	Type	Description
UserId [KEY]	Long	Unique identifier for the user.
Username	String	User name, a unique identifier for a user's account.
SuspendedFlag	Bool	Indicates whether the user, as part of termination, is suspended. If suspended, the user can be reactivated. Valid values are Yes and No.
PersonId	Long	Unique identifier of the person record linked to the user account.
PersonNumber	String	Person number of the person record linked to the user account.
CredentialsEmailSentFlag	Bool	Indicates whether the user name and password credentials were sent to the user after the account was created. The default value is Yes. Valid values are Yes and No.
GUID	String	Globally unique identifier for the user account.
CreatedBy	String	CreatedBy of UserAccounts
CreationDate	Datetime	CreationDate of UserAccounts
LastUpdatedBy	String	LastUpdatedBy of UserAccounts
LastUpdateDate	Datetime	LastUpdateDate of UserAccounts

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。