Home » Categories » Solutions by Business Process » Finance » Payroll |
Database INI Settings |
Article Number: 2029 | Rating: Unrated | Last Updated: Fri, Jun 16, 2023 at 4:52 PM
|
Datafile Software Database INI Settings The Employee database can be accessed within the Word template options as well as mirrored to SQL.You may also wish to restrict the items from the employee file that can be viewed subject to authority levels. Against each item you have the option to set: Authority Level
This option suppresses display of the item if the operator doesn’t have the authority to view showing a blank space instead. Blank allows view for all (provided have authority to view the screen as a whole), otherwise set from 0-9 as required (where 0 is highest authority and 9 is the lowest) Word Setting this option allows access to the item within the Microsoft Word link template/document actions.Note that if NO option is set then full access is given to all items. SQL Setting this option, where available, mirrors the specific item to the SQL table. Note that if NO option is set to be mirrored then the full database is mirrored. Notes Record any notes required against the employee item. This feature is primarily intended for installers to comment on how the field is to be used. CopyThe COPY button available at the foot of the screen allows you to nominate up to twenty items to be available on the Clipboard utility on the Ledger Enquiry when viewing an employee record. The Clipboard action when selected copies the employee data to the ‘clipboard’ which can then be pasted within other programs (Excel / Word for example).This option is typically used against the Employee Address. SQLThe SQL button, if available at the foot of the screen, allows you to enter matching item names on the SQL table when importing data from a SQL table to the Datafile database. AlertsThe Alerts button, if available at the foot of the screen, allows you to define alerts that require entry of notes or send an email when a trigger is first met. This could, for example, require entry of an employee note when SSP days are recorded against the employee database in payroll input or send an email to personnel when SMP dates are first recorded. |
Attachments
There are no attachments for this article.
|
Documents Enquiry
Viewed 1738 times since Tue, Mar 26, 2013
P11 Transaction File Database Structure
Viewed 5401 times since Wed, Mar 27, 2013
SWITCHES - Payments, Deductions and Repayments
Viewed 1734 times since Tue, Mar 26, 2013
Employee Optional 10/11
Viewed 1645 times since Wed, Mar 27, 2013
Windows 10 1803 Update / Windows Defender
Viewed 2409 times since Wed, May 30, 2018
HMRC Submission Viewer
Viewed 52 times since Tue, Oct 22, 2024
Employee Optional 1/11
Viewed 1719 times since Wed, Mar 27, 2013
Payroll Considerations - Link to Job Costing
Viewed 5637 times since Tue, Mar 26, 2013
Copy Pay to EMP (1/2) - Copy Pay to EMP (2/2)
Viewed 1679 times since Wed, Mar 27, 2013
STAT – Statutory Payment Details
Viewed 1127 times since Tue, Mar 26, 2013
|