Note: The “Installing the DC1 Time Client” document is removed and can be found as a separate document included on the installation CD for Time Client.
What this document contains:
- General information
- Installation information
- Tables and files
- Authority control
- System values
- Attesting
- Communication
- Manufacturing reporting
- Payroll system interface
- Project reporting
- Panel texts
- Windows Client
- General
- Various system and terminal tables
General information
This document contains the activities to go through to prepare DC1 Time for usage after it has been installed on your computer.
DC1 Time has interfaces to the following types of systems:
- Manufacturing system
- Project system
- Payroll system
For DC1 Manufacturing and for DC1 Project Management the interfaces are complete.
Interface capabilities
For other manufacturing and project systems and for the payroll system some additional work has to be done to adapt the interfaces to the specific system that is used. See Interface capabilities.
Installation information
For a description on how to install the system on the iSeries, see the DC1 Technical Implementation Guide available on the Iptor Intranet.
Installation of a new company
For a description on how to generate a new company or how to copy one, see the DC1 Technical Implementation Guide (available on the Iptor Intranet) and the Panel help.
Loading data
Mandatory entries for the different files and tables are described. For a more thorough explanation of code usage and the operation of the different maintenance programs, see the Panel help.
The following area is also described:
There are a number of tables and files in DC1 Time that need to be initialised before the system can be used.
Prerequisites
To maintain the tables described you must have System Administration authority. For more information, see section Authority control below.
Tables and files
Some of the basic data maintenance functions have been added into the Table maintenance program table and are available for selection under application TME.
A number of enquiry programs have been added into the Enquiry program table and are available for selection under application TME.
Time shares the batch job table with DC1 Manufacturing. The table will be set up during company creation.
Number series table
Time will – when needed – open two number series into DC1. One for Card id numbers (301) and one for Consolidated order numbers (302).
Mandatory tables
The following tables should be maintained before you start using the system:
- User profile table
- System value table
- Process table
- Terminal tables (if external reporting terminals will be used)
Preloaded tables
The following tables are preloaded when a DC1 company is created or when running the Update preloaded application tables menu item.
Note: If update is repeated, then only new records are added. Existing records are not changed.
- Job schedule control table (TMJSCD)
- Process message table (TMMSGE)
- Process table (TMPROC)
- System program table (TMSPGM)
- System value group table (TMSYSG)
- System value table (TMSYSV)
- Terminal table (TMTRML)
- Terminal client table (TMTRMC)
- Terminal function list (TMTRMF)
- Terminal standard function table (TMTRMS)
- Job parameters table (MFJBPS)
Authority control
In addition to the menu item/program level authority in DC1 and the possibilities to tailor menus with Medea, there is an authority control in Time. The purpose of this control is to limit the access to only relevant information. These authority levels are maintained in the Time User profile table.
DC1 System Administrator
If you sign on as a DC1 System Administrator you are automatically granted access to all parts of the Time application.
The Time User profile table is an extension of the DC1 user profile table. The user id’s, created in the DC1 user profile table will automatically be created in the Time User profile table if the Time application is active. Deleting records is also done from the maintenance panel for the DC1 user profile table.
Maintenance of the records in the Time User profile table can be done from the Work with DC1 user profiles menu item. In the suite of panels there is one panel where the data specific for Time is maintained.
System administration authority
The system administration authority switch controls the access to application control information. If this field is set to NO (default value when created), then access is denied to the following functions:
- System value group maintenance
- System value maintenance
- User profile maintenance
- Process message maintenance
- Process maintenance
- System program table maintenance
Data authority
The data authority specifies the “user class”. It defines which functions that can be used and limits the data that can be accessed.
The following authorities can be assigned:
Code | Description |
---|---|
NONE | This value is assigned to user profiles that are not using DC1 Time or user profiles only using the time reporting functions. In the time reporting functions, a card number is used for identification and control of access to data. |
EMPLOYEE | The user has access to personal data also from programs where a card number is not used for identification. |
ATTEST GROUP | The user has full control over data related to specified attest groups. This means that the user acts as an attestor controlling and calculating the reported time of other employees. When this authority level is used the authorised attest groups must be stated in the Attestor table. |
ALL | The user has access to all data related to employees and most basic data.
Note: Be restrictive to grant this level. Attest group authority should, in most cases, be sufficient. |
System values
The system values are company level parameters used to set up and customise the system. The system values control which functions that are active and the behaviour of functions in different parts of the application.
The System value table is preloaded when the DC1 company is created, but the preloaded values should be checked and adjusted before the system is used.
The system values are grouped as follows:
Value | Description |
---|---|
Attesting/Calculation | System values controlling the functionality in the attesting and calculation routines. |
Communication | System values controlling the communication between Time and reporting terminals. |
Manufacturing reporting | System values controlling manufacturing reporting and the interface between Time and a manufacturing system. |
Payroll system interface | System values controlling the interface between DC1 Time and a payroll system. |
Project reporting | System values controlling project reporting and the interface between Time and a project system. |
Panel text | System values containing texts used on application panels. |
Windows Client | System values for configuration of the Windows Reporting Client. |
General | System values having a general influence in the application. |
The system values are described by the following headings:
- System value code and short description
- Purpose (detailed description)
- Valid values
Note: The preloaded value is in bold and underlined. - Special considerations
- Dependencies with other system values
Attesting
System value code | Purpose | Valid values | Considerations | Dependent/Related system values |
---|---|---|---|---|
ATTBALAUT (Day balance attest method) | Specifies the attest method for day balances. | 1 = Manual 2 = Automatic if no exceptions 3 = Automatic |
Selecting value 3 means that there will be no manual attest procedure for the day balances. Only attested day balance records can be processed further, i.e. transferred to Payroll system.
Note: For what is regarded as an exception, see the Panel help for Attesting overview. |
ATTCLKAUT |
ATTCLKAUT (TR journal attest method) | Specifies the attest method for the time reporting journal. | 1 = Manual 2 = Automatic if no exceptions 3 = Automatic if no errors |
Selecting value 3 means that there will be no manual attest procedure for the TR journal. Only attested journal can be calculated.
Note: For what is regarded as an exception or error, see the Panel help for Attesting overview. |
ATTBALAUT |
ATTDFTMOD (Default mode attest) | On Work with attesting – Calendar day overview this system value determines the default display mode. | 1 = Hours display 2 = Status display 3 = Manufacturing hours display |
You can also toggle between the display modes by clicking a function key on the Attesting panel. | None |
ATTSTRMTH (Attest start method) | Determines how the Work with attesting function will be started. | 1 = Bypass attest group panel 2 = Display attest group panel |
If the user is defined as an Attest responsible for only one attest group the system can bypass the attest group selection panel and go directly to the Attesting overview panel.
The attest group selection panel will always appear for users responsible for several attest groups and for users having authority to all data. |
None |
RMVZERBAL (Remove zero balances) | Specifies if day balances with zero hours should be removed in the calculation process. | 0 = Do not remove 1 = Remove before day total calculation 2 = Remove after day total calculation 3 = Remove both before and after day total calculation |
N/A | None |
WTPOTMRED (Wage type for reduction of overtime) | To convert reduced overtime to ordinary presence time when full time before overtime is required and requested overtime is reduced. | A valid wage type for presence time. The code must be entered with five digits. If the wage type code is less than five digits it must be entered with leading zeros. | N/A | None |
Communication
System value code | Purpose | Valid values | Considerations |
---|---|---|---|
LOGINMSG (Log incoming messages) | Determines if the incoming terminal messages are logged. This will make it possible to trace errors in the incoming messages. | 0 = Do not log 1 = Log |
This only controls the communication with reporting terminals. System process activities will always be logged and the payroll process log has a control of its own. |
STDDTAQLIB (Standard data queue library) | Used as the default data queue library when defining the communication processes. | No limitations. A special value *DBF can be used for the company file library.
Preloaded value is *DBF. |
It is recommended that you keep the preloaded value. |
STDJOBQ (Standard job queue) | Specifies the name of the job queue where the process server jobs are sent. | No limitations. A special value *SYS can be used for the DC1 default job queue.
Preloaded value is *SYS. |
N/A |
STDSBS (Standard subsystem) | Specifies the name of the subsystem under which all process server jobs will run. | No limitations. A special value *SYS can be used for the DC1 default subsystem Preloaded value is *SYS. | If the subsystem is not active it will be started automatically. The preloaded value directs the process server jobs into the same subsystem as other DC1 routines (like direct print). The influence on machine workload depends on how many processes are running simultaneously. When tuning the system performance you may want to change the setting. |
SYSPROC (System process) | Specifies the name of the system process. The system process takes care of several batch type system tasks like sending requests to DC1 Manufacturing. | No limitations.
Preloaded value is TMESYS. |
This should always be active and is automatically started when signing on an DC1 company. |
Manufacturing reporting
System value code | Purpose | Valid values | Considerations | Dependent/Related system values |
---|---|---|---|---|
ADJOPRCLK (Adjust operation start/stop method) | Specifies how start and stop times for operations are adjusted when start or stop is automatically created when clocking in before start of working hours or out after working hours. | 0 = No adjustment 1 = Adjust to start/end of working hours if time code not used. 2 = Adjust to start/end of flexitime if time code not used. 3 = Adjust with a fixed number of minutes. |
N/A | ADJOPRSTP and ADJOPRSTR if value 3 is selected. |
ADJOPRSTP (Adjust operation stop) | Specifies in number of minutes the time between stop for the ongoing operation and the clocking out. | Any value in the range 00 – 99.
Preloaded value is 00. |
N/A | This system value is used only when ADJOPRCLK = 3. |
ADJOPRSTR (Adjust operation start) | Specifies in number of minutes the time between the clocking in and start of the ongoing operation. | Any value in the range 00 – 99.
Preloaded value is 00. |
N/A | This system value is used only when ADJOPRCLK = 3. |
ADJOPRSTST (Adjust operation start/stop non auto) | Specifies how the start and stop times for operations are adjusted when clocking in and then clocking start before start of working hours or clocking stop after end of working hours and then clocking out. | 0 = No adjustment 1 = Adjust to start/end of working hours 2 = Adjust to start/end of flexitime |
N/A | Adjustment is only done when clocking in or out without time code. |
CHKPRODORD (Check production order) | Specifies if production order and operation information should be retrieved from the manufacturing system and validated. By setting this to 1 a complete validation will be done (following the rules in DC1 Manufacturing). | 0 = Do not validate 1 = Validate production order/operation |
The standard system only has the capability to validate against DC1 Manufacturing. If another manufacturing system is used this system value should be set as 0. | None |
CONSDIVMTH (Division method for consolidated order.) | Specifies how the time reported for a consolidated order will be divided among the operations of the consolidated order. | 1 = Number of operations 2 = Remaining time 3 = Remaining quantity |
N/A | USECONSORD |
INORDFROM (Indirect order number from) | Specifies start number for the interval used for indirect orders. | Any number in the range 0000001 – 9999999.
Preloaded value is 0000900. |
N/A | Must be less than the value of INORDTO |
INORDTO (Indirect order number to) | Specifies last number for the interval used for indirect orders. | Any number in the range 0000001 – 9999999.
Preloaded value is 0000999. |
N/A | The value must be greater than the value of INORDFROM |
MNDREACDE (Mandatory reason code) | Specifies if reason code is mandatory when reporting rejected quantity. | 0 = Optional 1 = Mandatory |
N/A | None |
PRODBFLIB (Manufacturing data base library) | Specifies the name of the library containing the manufacturing system database files needed when transferring reported manufacturing transactions. This library will be automatically added to the library list when performing the transfer. | No limitations.
Preloaded value is blank. |
You do not need to specify this if DC1 Manufacturing is used. | None |
PROOBJLIB (Manufacturing object library) | Specifies the name of the library containing the manufacturing system program objects, etc., needed when transferring the reported production transactions. This library will be automatically added to the library list when performing the transfer. | No limitations.
Preloaded value is blank. |
You do not need to specify this if DC1 Manufacturing is used. | None |
PROUPDTPE (Manufacturing update type) | Controls transfer of manufacturing transactions from Time to the manufacturing system. | 0 = No update. Do not transfer. 1 = Delayed. Transfer when running the batch job MAN_TRANSF. 2 = Immediate. Transfer automatically when reported. |
The recommended method when DC1 Manufacturing is used is immediate. | None |
USECONSORD (Use consolidated order) | Specifies if consolidated order reporting is used. | 0 = Consolidated order reporting is not used. 1 = Consolidated order reporting is used. |
N/A | USEPRODREP Manufacturing reporting must also be activated if consolidated order reporting is used. |
USEGRPREP (Use group reporting) | Specifies if group reporting is used. | 0 = Group reporting is not used. 1 = Group reporting is used. |
N/A | USEPRODREP Manufacturing reporting must also be activated if group reporting is used. |
USEPRODREP (Use production reporting) | Specifies if the manufacturing reporting functions are used. | 0 = Manufacturing reporting is not used. 1 = Manufacturing reporting is used. |
N/A | None |
PWADJSTST (Adjust start/stop inside deviation) | Is used when creating balances for piecework with wage type from operation or work centre in DC1 Manufacturing.
This system value controls if start and stop times inside the accepted deviation are adjusted. |
1 = Always adjust to start or end of working hours. 2 = Adjust start time when equal to IN and adjust stop time when equal to OUT. |
N/A | N/A |
PWREPWT (Replace wage type) | Is used when creating balances for piecework with wage type from operation or work centre in DC1 Manufacturing.
This system value controls if balances with wage type from manufacturing should be created as additional balances or if they should replace balances created from the day scheme. |
0 = Do not replace wage type from scheme. 1 = Replace wage type from scheme. |
N/A | N/A |
PWTRSUM (Transaction summation) | Is used when creating balances for piecework with wage type from operation or work centre in DC1 Manufacturing.
This system value controls if balances from manufacturing should be summed up per order/operation or if one balance record should be created for each start/stop. |
0 = Do not sum per order/operation. 1 = Sum per order/operation. |
N/A | N/A |
Payroll system interface
System value code | Purpose | Valid values | Considerations | Dependent/Related system values |
---|---|---|---|---|
SALFROM (Interface from Payroll system) | Specifies if the interface from Payroll system is used. The purpose of this interface is to share some of the basic data stored in Time with a Payroll system. The principle is that all changes to such data are made in the Payroll system and then sent as requests to Time. | 0 = Interface from Payroll is not in use. 1 = It is in use. |
Note: The Payroll system used in conjunction with Time must be able to send these impulses. This always requires some programming work. If the interface is activated the Payroll process (see that system value) will be automatically activated during DC1 company sign on. | SALPROC |
SALLOGERR (Log Payroll errors) | Specifies if the errors, found in the contents of the impulses retrieved in the interface from Payroll, should be put in the error log. This could be useful during the test running. | 0 = Errors will not be logged. 1 = Will be logged. |
N/A | None |
SALPROC (Payroll process) | Specifies the name of the communication process used for the interface from Payroll. This interface takes care of the shared database between Payroll and Time. | No limitations.
Preloaded value is TMESAL. |
If the interface is in use the payroll process is automatically activated in the company during DC1 company sign on. | SALFROM |
SALTO (Interface to Payroll system) | Specifies if the Interface to Payroll system is used. The purpose of this interface is to send the calculated day balances as wage transactions to the Payroll system. | 0 = Interface to Payroll is not in use. 1 = Is in use. |
Note: The Payroll system used in conjunction with Time must be able to receive the transactions created in Time. This always requires some programming work.
When the interface is activated the functions dealing with Payroll transfer become available, otherwise the access is denied. |
None |
SALTRANSF (Payroll transfer steps) | Determines how the Payroll transfer routine is performed. It can be configured as one process creating/sending the wage transactions immediately to Payroll system, or as two processes: the first creating the transfer material in Time and the second creating/sending the wage transactions after confirmation. | 1 = Run as a single step. 2 = Run in two steps with full control. |
Note: If a single process is used it is not possible to cancel the transfer request.
If run in two steps, then the Work with payroll transfer function can be used to monitor the transfer requests. |
None |
NBRDAYABS (Number of days with absence) | Controls if transactions with absence should be sent to the payroll system for non-working days inside a period of absence. The system value specifies required number of days with absence. The days with absence must have the same wage type and the code Absence for holiday must be YES. | Number in range 1-9.
Preloaded value is 6. |
N/A | N/A |
Project reporting
System value code | Purpose | Valid values | Considerations | Dependent/Related system values |
---|---|---|---|---|
POMUPDTPE (Project update type) | Controls the transfer of project transactions from Time to the project system. | 0 = No update. Do not transfer. 1 = Delayed. Transfer when running the batch job PRJ_TRANSF. 2 = Immediate. Transfer when reported. |
The recommended method when DC1 Project is used is immediate.
Note: The immediate update will occur when stop is reported. |
None |
PRJDBFLIB (Project data base library) | Specifies the name of the library containing the project system database files needed when transferring reported project transactions. This library will be automatically added to the library list when performing the transfer. | No limitations.
Preloaded value is blank. |
You do not need to specify this if DC1 Project is used. | None |
USEPROJREP (Use project reporting) | Specifies if the project reporting functions are used. | 0 = Project reporting is not used. 1 = Project reporting is used. |
N/A | None |
Panel texts
System value code | Purpose | Valid values | Considerations | Dependent/Related system values |
---|---|---|---|---|
TXTPFXCON (Consolidated order prefix) | Specifies the prefix for references to consolidated orders when displayed in various time reporting panels. | No limitations.
Preloaded value is blank. |
The prefix is a part of the reference field shown in various time reporting panels. The space for the reference is limited and if prefix is used it should, if possible, be limited to one or two characters. | None |
TXTPFXCOS (Cost centre prefix) | Specifies the prefix for references to cost centres when displayed in various time reporting panels. | No limitations.
Preloaded value is C:. |
The prefix is a part of the reference field shown in various time reporting panels. The space for the reference is limited and if prefix is used it should, if possible, be limited to one or two characters. | None |
TXTPFXGRP (Work group prefix) | Specifies the prefix for references to work groups when displayed in various time reporting panels. | No limitations.
Preloaded value is G:. |
The prefix is a part of the reference field shown in various time reporting panels. The space for the reference is limited and if prefix is used it should, if possible, be limited to one or two characters. | None |
TXTPFXMAN (Manufacturing operation prefix) | Specifies the prefix for references to manufacturing operations when displayed in various time reporting panels. | No limitations.
Preloaded value is blank. |
The prefix is a part of the reference field shown in various time reporting panels. The space for the reference is limited and if prefix is used it should, if possible, be limited to one or two characters. | None |
TXTPFXPRJ (Project activity prefix) | Specifies the prefix for references to project activities when displayed in various time reporting panels. | No limitations.
Preloaded value is A:. |
The prefix is a part of the reference field shown in various time reporting panels. The space for the reference is limited and if prefix is used it should, if possible, be limited to one or two characters.
This system value is only used when DC1 Project is used. |
None |
TXTPFXPRO (Project code prefix) | Specifies the prefix for references to projects when displayed in various time reporting panels. | No limitations.
Preloaded value is P:. |
The prefix is a part of the reference field shown in various time reporting panels. The space for the reference is limited and if prefix is used it should, if possible, be limited to one or two characters.
This system value is only used when DC1 Project is not used. |
None |
TXTPFXQUO (Quotation activity prefix) | Specifies the prefix for references to quotation activities when displayed in various time reporting panels. | No limitations.
Preloaded value is Q:. |
The prefix is a part of the reference field shown in various time reporting panels. The space for the reference is limited and if prefix is used it should, if possible, be limited to one or two characters.
This system value is only used when DC1 Project is used. |
None |
TXTSEPCHR (Separator character for references) | Specifies the character used to separate different parts of the reference field when displayed in various time reporting panels. | Any single character.
Preloaded value is /. |
N/A | None |
Windows Client
System value code | Purpose | Valid values | Considerations | Dependent/Related system values |
---|---|---|---|---|
CARDLEN (Card id. number positions) | Specifies the length of the card id. string used for time reporting. | Any number in the range 00 – 20.
Preloaded value is 04 |
N/A | CARDPOS |
CARDPOS (Card id. number positions) | Specifies which positions in the entered card id. string that will be used as the actual card id.number. | The position of the first character of the card id. number is entered in character one and two, the position of the second character in the card id. number is entered in character three and four and so on.
Preloaded value is 01020304. In this case the card id. number consists of character one, two, three and four of the entered string. |
N/A | CARDLEN |
CHKONLINE (Check on line interval) | Specifies, in number of minutes, how often the Client terminal will check if it is on line. | Any number in the range 00 – 99.
Preloaded value is 10. |
N/A | None |
DSPDEPSEC (Department section used) | Specifies if department sections are allowed to be displayed among the work centres on the client terminals. | 0 = Department sections not displayed. 1 = Department sections will be displayed. |
N/A | None |
KEEPJRN (Keep journal number of days) | Specifies how many days the time reporting journal is saved in the client terminals. | Any number in the range 001 – 999.
Preloaded value is 030. |
N/A | None |
LODCALBWD (Load calendar backwards) | Specifies for how many days in past time calendar information will be loaded to the client terminals. | Any number in the range 001 – 999.
Preloaded value is 007. |
N/A | None |
LODCALFWD (Load calendar backwards) | Specifies for how many future days calendar information will be loaded to the client terminals. | Any number in the range 0001 – 999.
Preloaded value is 014. |
N/A | None |
RTVMAIL (Retrieve mail interval) | Specifies, in number of minutes, how often the Client terminal will retrieve messages from the iSeries. | Any number in the range 01 – 99.
Preloaded value is 10. |
N/A | None |
General
System value code | Purpose | Valid values | Considerations | Dependent/Related system values |
---|---|---|---|---|
ABSCDEADJ (Adjust time at control of absence code) | Specifies number of minutes which are added to the start time and subtracted from the end time of working hours when checking the use of time codes for absence when clocking in or out. | Any number in the range of 00-99.
Preloaded value is 00. |
N/A | ABSCDECTL |
ABSCDECTL (Absence code control) | Specifies how time codes for absence will be controlled when clocking IN or OUT using the time reporting panels or the Windows Client. | 0 = No control. 1 = Warning if clocking during working hours without code. 2 = Absence code mandatory if clocking during working hours. 3 = Absence codes not allowed. |
N/A | None |
ADJZONRCV (Adjust zone when received) | Determines if a time zone adjustment should be performed for the clocked times received from a reporting terminal.
The adjustment should be made when the time zone of the server (iSeries) differs from the actual time where the terminal is used but the terminal, for some reason, uses the server system time. |
0 = Do not perform time zone adjustment. 1 = Perform it. |
When using the DC1 Time Windows Reporting Client the system value should be set as zero. When starting and at specified intervals the terminal retrieves the system date and time from the iSeries and if there is a time zone adjustment the time in the terminal will be adjusted. | The adjustment is specified by the system value TIMEZONE. |
CHKCCFIN (Check cost centres against DC1 Financials) | Specifies if cost centres should be validated against DC1 Financials at maintenance. | 0 or 1.
Preloaded value is 0. |
N/A | None |
DFTST0P (Stop ongoing default) | Specifies the default value for Stop ongoing when clocking out. | 0 = Default value will be NO. 1 = Default value will be YES. |
N/A | PMTONGACT |
PMTONGACT (Prompt for ongoing action) | Specifies if the system should prompt for continue/stop when clocking in/out and there is an ongoing action. | 0 = Default value will be NO. 1 = Default value will be YES. |
N/A | DFTSTP |
PRECDEADJ (Adjust time at control of presence code) | Specifies the number of minutes that are subtracted from the start time and added to the end time of the working hours when checking the use of time codes for presence/overtime when clocking in or out. | Any number in the range of 00-99.
Preloaded value is 00. |
N/A | PRECDECTL |
LOGTRJRN (Log TR journal) | Specifies if manual changes of the TR journal should be logged. | 0 = NO 1 = YES |
N/A | N/A |
NBRDECTIM (Number of decimals for time) | Number of decimals when reporting additional time. | 0 = No decimal 1 = One decimal 2 = Two decimals |
N/A | N/A |
PRECDECTL (Presence code control) | Specifies how time codes for presence will be controlled when clocking IN or OUT using the time reporting panels or the Windows Client. | 0 = No control. 1 = Warning if clocking in before or out after working hours without code. 2 = Presence code mandatory if clocking in before or out after working hours. 3 = Presence codes not allowed. |
N/A | None |
TIMEZONE (Time zone adjustment ) | Specifies if a time zone adjustment should be performed.
The adjustment is made when the iSeries system time zone differs from the actual time where reporting is done. |
The value must be in a range -23,…, +00,…,+23.
The preloaded value is +00. |
Time zone adjustment may be necessary in international environments when the same iSeries is serving companies in different time zones. | None |
USEPRESREP (Use presence reporting) | Specifies if presence reporting is used. | 0 = Presence reporting is not used. 1 = Presence reporting is used. |
The value 0 can, e.g., be used if Time is used only for manufacturing reporting. Only start and stop is reported. | None |
Various system and terminal tables
System program table
The System program table (TMSPGM) in Time contains a list of batch routines that Time executes using the system process. An example of this is when ordering the time calculation directly from the attesting panels or when trying to delete a basic data record (like wage type).
The system process uses this table to determine if a completion message should be sent and to retrieve the text of the completion message when a task has been performed. The message is sent to the message queue of the user sending the request.
If completion messages should not be sent, then the switch can be turned off for individual tasks.
Process table
A process is an iSeries server job that is waiting for requests to perform different tasks. The requests are called messages and they must follow a predefined syntax so that the process driver program will be able to recognise which task that should be performed.
The Process table is accessed through the Work with processes menu item. Three processes are preloaded:
- TRM (Terminal)
- TMESAL (Payroll)
- TMESYS (System)
The system process and payroll process only receive messages and use data queues for the messages. The terminal processes can both receive and send messages and can use either data queues or files for incoming and outgoing messages.
At company generation, the associated data queues and data areas that must exist for a process are only created for the system process. You must, therefore, use the process maintenance function and create the necessary objects for the terminal and payroll processes.
Terminal
The terminal process or processes in Time serve the communication between the iSeries and external reporting terminals. The table is preloaded with one process for terminal communication, but you can create any number of this type of processes.
When a request is sent the external reporting terminal must supply the terminal name as an identifier for Time. By means of the configuration parameters in Time the request is sent to the right process.
The preloaded receiver programs contain the logic to receive the standard messages sent from the Windows Reporting Client and these messages types are defined in the Process message table.
It is possible to attach other reporting terminal systems to Time or define other types of requests by writing a new receiver program and define the message type.
Payroll
This process serves the interface from the payroll system, i.e., receiving and updating basic data. There can only be one payroll process.
The interface from the payroll system is described in Interface capabilities.
System
The system process is always running. It is used to:
- perform some batch tasks like employee calendar generation and time calculation (if not requested from Work with batch jobs),
- perform tasks related to the interface between Time and other applications as the manufacturing system, project system.
Job schedule control table
The purpose of this table is to facilitate the creation of scheduled jobs. Instead of directly using OS/400 commands, the table can be used to create and maintain scheduled job entries for three types of jobs:
- Start system process
- Stop system process
- Time calculation
The table is preloaded with one record for each type of job. For time calculation additional records can be created. This makes it for instance possible to run time calculation for different groups as different scheduled jobs.
The records in the table refer to a job description. The default job description, which is included in the shipment, is TMEJOBDSCD.
Before you activate any scheduled jobs, check that the initial library list of the job description contains the same product and system libraries as the initial library list of the environment in which you are working. To check the initial library list, select the Work with environments menu item and choose the applicable environment.
Job parameters table
This table is preloaded with all batch jobs available within DC1 Time. For each batch job the table contains default values for job attributes such as job queue and output queue as well as job specific parameters.
The Work with reports/jobs menu item contains functionality to maintain job attributes and parameters. New versions of a job can be created with different settings of parameters.
For documentation describing the parameters of the batch job, see the Panel help.
Parameters of type date, week or month can be defined by a formula and the actual value is then calculated when the job is executed. For further information, see the Panel help.
Job group table
A job group consists of a number of jobs that are executed together. For instance, instead of individually submitting each job that is run in the daily batch a job group containing these jobs is created and the job group is submitted.
The jobs in a job group and their parameters must have been defined in the Job parameters table.
Terminal tables
The terminal tables contain configuration parameters for external reporting terminals and must be maintained if external reporting terminals are used.
All external terminals must be defined in the Terminal table. If the Windows Reporting Client is used, then the configuration parameters in the Terminal client table should also be checked.