Batches
Batch is a set of workers information, with which it is possible to carry out some processes as issuing of reports or generation of evaluations. It is possible to define multiple batches, assigning them different codes. Each one of the companies on the database has its own set of batches. Therefore, only the batches linked to the active company will be visible on this window.
It is possible to select workers from the batch through a rule. For this, check information about the Filter button, as follows.
It is possible to define that only the user who has registered the batch may change it. For this, there is the Control Batches per Users field, in Others > Indications.
Batch
Report a code to register this batch. The code may be between 01 and 99.
Description
Report a name to identify this batch, with up to 20 positions.
- Type: Report the type of worker;
- Information: Report the worker information to be included in this batch;
- Name: The name of the selected worker is displayed, only for consultation.
Filter
It is enabled only when inserting a register. It allows to call a window on which the user may report the rule code that has only one WHERE clause, that must be assigned to the StrLot system variable.
In this rule, it is also possible to build relations with other tables from the database, according to the examples 2 and 3 below: Based on this WHERE clause, the system will carried out a SELECT in the R034FUN table and will bring the selected workers to the grid of the Batch window.
Example 1:
Rule to the filter:
@ Colaboradores da Filial 2 @
StrLot = " WHERE R034FUN.CODFIL = 2";
Example 2:
Rule to the filter:
@ Colaboradores Demitidos a Partir de 01/01/2001 @
definir alfa StrDatAfa;
MontaData(01, 01, 2001, DatAfa);
ConverteDataBanco(DatAfa, StrDatAfa);
StrLot = ",R038AFA WHERE R038AFA.NUMEMP = R034FUN.NUMEMP AND \
R038AFA.TIPCOL = R034FUN.TIPCOL AND R038AFA.NUMCAD = R034FUN.NUMCAD \
AND R038AFA.DATAFA >= " + StrDatAfa + " AND R038AFA.SITAFA = 7";
Example 3:
Rule to the filter:
@ Retorna colaborador com tipo de apuração = 2 @
StrLot = ",R038APU WHERE R038APU.NUMEMP = R034FUN.NUMEMP AND R038APU.TIPCOL = R034FUN.TIPCOL \
AND R038APU.NUMCAD = r034fun.numcad AND R038APU.APUPON = 2 and \
R038APU.INIAPU = (SELECT MAX(INIAPU) FROM R038APU WHERE NUMEMP=R034FUN.NUMEMP AND \
TIPCOL=R034FUN.TIPCOL AND NUMCAD=R034FUN.NUMCAD)";
Veja também:
English
Español
