How to add a new TMS or HR Text Field

How to add a new TMS or HR Text Field

This articleis designed to show the user how to create a new alpha field onto either a TMS or HR Manager Panel.


Note: Before performing these instructions please ensure a recent backup of the TMS database has been taken by your IT department prior, as this will involve modifying existing tables.


  1. Load DBDEF.EXE via your WinTMS directory and log in as MASTER.


  1. From the main screen choose ‘Maintain tables’.




  1. From the table, select the relevant table, e.g. ‘TMSEMP’ and click ‘Modify’




  1. From the Fields table, scroll to the bottom of the existing fields and add a new field on the blank line.  Include the Field Name, the Type, the Length, and a Caption:




  |



  1. Click OK to exit out of all of the options screens, click YES to the ‘Rebuild data for modified tables’ and OK once completed.






How to add the new Field to a Panel


  1. Click ‘Maintain Panels’, select the required panel the new field should be added to and click on the ‘Modify’ button.




  1. From the Modify Panel screen click the ‘Add’ button to add the new field.




  |


  1. Select ‘Edit’ as the type and click OK.




  1. From the ‘Get field’ box select the Table and the Field from the drop-down menu.




  1. The field properties should be a suitable size, but can be amended if necessary.


  2. Click OK and the new field will be added to the top of the panel as a white square with a black border.  


  1. Select the field and drag it into a more convenient place on the panel and click OK.




  1. Close the ‘Maintain Panel’ section and exit out of the DEBDEF application.


  1. Reload TMS/HR Manager and go to the panel where the field was added, e.g., the ‘Personal’ tab within the ‘Personal details’ option of HR Manager.  The new field should now be in place.




    • Related Articles

    • How to add a new TMS or HR Lookup Field

      This article is designed to show the user how to create a new look up on the TMS system and add the new Lookup to an existing panel. Note: Before performing these instructions please ensure a recent backup of the TMS database has been taken by your ...

    • Create New User

      From Maintain User> Add We enter the NEW user's Username, in this case SUSANG and pressed OK Next we completed the Edit User screen . We entered the User's Full Name and Profile. We clicked on the Set Password button and gave the User a temp password ...

    • Employee in TMS but not in HR Manager

      To check the Employee Type License for that employee, select the employee in WINTMS.  Then under the Employee Menu, go to Change Employee Type.    Then select Set Licence Options.   And ensure that the HR Licence is checked.   

    • Add employee

      The Add employee page enables you to add a new Employee to the system in addition to amending their licences and selecting their details type. The Add employee page is only available to Supervisors with Employee > Add enabled in their TMS user ...

    • Upgrading V8 User manual

      Introduction This article is intended to guide through the six stages required to upgrade an existing installation of Mitrefinch TMS for Windows and WebTMS v8. It is intended for an IT professional who is familiar with the Mitrefinch software ...