Field: Work Setting Id

From Catglobe Wiki
Jump to: navigation, search



Field: Work_Setting_Id

Field: Work_Setting_Id

Type

Integer (FK)

General Description

Work setting is a feature used for specifying holidays and weekend days for users. These work settings can be set up using the work settings module. Please refer to these files for more information.

Import Group

User (Advanced)

Auto mapping

In order to ensure auto mapping then the column name in the Excel must fit with the given name in import. This name is language dependent as shown:

Business Rules

Work setting can be imported using only number. Numbers are the unique ID on the database for work setting and may differ between sites. You should contact your site administrator to know what work settings and related id’s that your site has available. The table below is therefore only an example of the work settings supported in one specific site. Other sites may use different numbers to recognize work settings.
782.gif

In case the above table was how our work setting table looked for a site, we could put in ‘8’ in the excel cell and the work setting of the user would be set to “German vacation”.

To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ work settings you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing work settings values will be kept but rather that they will be removed!

Validation

The number imported to work setting must exist in the table ‘Work_Setting’ of the systems database or be NULL or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).

Notes

N/A