Follow

Data validation - users

When working with user data, each user has specified values that may have reference to the same or other data tables in Acubiz. Therefore, it is important that data fraud is in order, otherwise these references will not be valid and Acubiz EMS will not work properly. This could be the following scenarios (this is not an exhaustive list)

User creation

All users must specify a unique key that the user is maintained based on.

Logical test

Is this key already present in Acubiz?

Result of logical test

Yes

No

Action

The user is updated if necessary. Changes since last update

The user is created in Acubiz as a new user.

 

Specification of user approver.

This key is also the reference for the approver specified on the individual user. If an invalid reference is submitted, the user will be created without approver.

Logical test

Findes godkender som bruger-record?

Result of logical test

Yes

No

Action

The user gets the user as the manager of Acubiz

The user is created / updated with [blank] approver- no approver.

 

Indication of dimension values

If dimensions are used in Acubiz (eg, Department, Cost Center, Project, etc.), in some cases, a default dimension may be specified for each user. This could be a permanent department or a cost center. These are the Dim1 ... Dim9 fields.

Logical test

As indicated on the user, is the Dim value present as a dimension record in the dimension table?

Result of logical test

Yes

No

Action

The user gets the dim value as the default value in Acubiz

Users are created / updated with [blank] Dim value (ie no defaul value) as this is not available.

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk