Entity SystemUser

Description of Entity SystemUser

This entity would hold the number of users using the application. Only if the user enters the User Identity and the User password correctly then they would be allowed into the system. This table would also determined which module the user can have access to.


List of all Dependencies of the Entity SystemUser

Name

Code

Class Name

Relation_9786

Relation_9786

Reference

Relation_11089

Relation_11089

Reference

Relation_160134

Relation_160134

Reference

Relation_1834511

Relation_1834511

Reference

Relation_1926593

Relation_1926593

Reference

Relationship_753

Relationship_753

Reference

Relationship_755

Relationship_756

Reference

Relation_728

Relation_728

Reference


List of Attributes of the Entity SystemUser

Name

Code

User ID

UserId

Password

UserPassword

Expiry Date

ExpiryDate

FirstTimeLogin

FirstTimeLogin

SysPersonalSysId

SysPersonalSysId

IsDirServices

IsDirServices

DirServicesUserName

DirServicesUserName

DirServicesDomainName

DirServicesDomainName

LastFailDateTime

LastFailDateTime

AccumulatedFails

AccumulatedFails

RemLastProcessDate

RemLastProcessDate


Entity Attribute User ID of the Entity SystemUser

Card of Attribute User ID of the Entity SystemUser

Name

User ID

Code

UserId

Data Type

char(20)

Mandatory

Yes


Description of Attribute User ID of the Entity SystemUser

This attribute is the user login identity for the application. This is the primary key for the SystemUser table.


Entity Attribute Password of the Entity SystemUser

Card of Attribute Password of the Entity SystemUser

Name

Password

Code

UserPassword

Data Type

char(50)

Mandatory

No


Description of Attribute Password of the Entity SystemUser

This attribute holds the password for the user identity.


Entity Attribute Expiry Date of the Entity SystemUser

Card of Attribute Expiry Date of the Entity SystemUser

Name

Expiry Date

Code

ExpiryDate

Data Type

date

Mandatory

No


Description of Attribute Expiry Date of the Entity SystemUser

This attribute would record the expiry date for the user to access the system. This expiry date would only be checked upon starting up the system. If there isn't a date set, there is no expiry date for the user to access the system.
It is in the format: DD-MM-YYYY.


Entity Attribute FirstTimeLogin of the Entity SystemUser

Card of Attribute FirstTimeLogin of the Entity SystemUser

Name

FirstTimeLogin

Code

FirstTimeLogin

Data Type

smallint

Mandatory

No


Description of Attribute FirstTimeLogin of the Entity SystemUser

Indicates if it is a first time login for the user, in a form of a checkbox.


Entity Attribute SysPersonalSysId of the Entity SystemUser

Card of Attribute SysPersonalSysId of the Entity SystemUser

Name

SysPersonalSysId

Code

SysPersonalSysId

Data Type

integer

Mandatory

No


Description of Attribute SysPersonalSysId of the Entity SystemUser

A system generated identity. It is blind to the user. This also holds the primary key for the SystemUser table.


Entity Attribute IsDirServices of the Entity SystemUser

Card of Attribute IsDirServices of the Entity SystemUser

Name

IsDirServices

Code

IsDirServices

Data Type

smallint

Mandatory

No


Description of Attribute IsDirServices of the Entity SystemUser

Indicates if there are any direct services for the user, in a form of a checkbox.


Entity Attribute DirServicesUserName of the Entity SystemUser

Card of Attribute DirServicesUserName of the Entity SystemUser

Name

DirServicesUserName

Code

DirServicesUserName

Data Type

char(200)

Mandatory

No


Description of Attribute DirServicesUserName of the Entity SystemUser

A username for the direct services the user can use.


Entity Attribute DirServicesDomainName of the Entity SystemUser

Card of Attribute DirServicesDomainName of the Entity SystemUser

Name

DirServicesDomainName

Code

DirServicesDomainName

Data Type

char(200)

Mandatory

No


Description of Attribute DirServicesDomainName of the Entity SystemUser

The domain name of the direct services.


Entity Attribute LastFailDateTime of the Entity SystemUser

Card of Attribute LastFailDateTime of the Entity SystemUser

Name

LastFailDateTime

Code

LastFailDateTime

Data Type

timestamp

Mandatory

No


Description of Attribute LastFailDateTime of the Entity SystemUser

Shows the date and time of the last fail login.


Entity Attribute AccumulatedFails of the Entity SystemUser

Card of Attribute AccumulatedFails of the Entity SystemUser

Name

AccumulatedFails

Code

AccumulatedFails

Data Type

integer

Mandatory

No


Description of Attribute AccumulatedFails of the Entity SystemUser

The accumulated number of login fails.


Entity Attribute RemLastProcessDate of the Entity SystemUser

Card of Attribute RemLastProcessDate of the Entity SystemUser

Name

RemLastProcessDate

Code

RemLastProcessDate

Data Type

date

Mandatory

No


Description of Attribute RemLastProcessDate of the Entity SystemUser

Shows the last processed date of the system user.
It is in the format: DD-MM-YYYY.