Integration Definition
In this option are defined in which events will be sent the normal hours, day and night hours for the monthly and in which events will be calculated the DSR and the form that will be calculated for the payroll.
General
Generate Admitted in the Period
Indicate whether or not employee events in the period should be generated.
Will also be considered employees admitted to the last day of the period. Employees allowed between the end of the calculation period and the last day of the period of the sheet will have the hours.
- Period from 21.08.2000 to 20.09.2000.
- Collaborator admitted on 23.09.2000.
This contributor will have no days calculated in the competence of September, but the system will calculate the hours of the day 23 day 9/30/2000.
Generate Dismissed in the Period
Indicate whether the employee events dismissed in the period should be generated or not.
Using the "N" option, the fields Calculate for Termination Personnel Administration and Resignation date, available in the Integration calculation screen, will not be visible.
Normal Daytime Hours Event
and Event Night Standard Hours Enter the event code for normal daytime / night time.
If the informed event is in one of these fields and have in your record the Design field empty, the system will inform to you check the event and enter this field.
Separate Monthly DSR Notify "S" If employees pass holders should have the DSR calculated in DSR event or notify "N" for which DSR hours are considered as normal.
Recalculate Previous Months
Inform if the company uses routine for recalculation of previous months.
When is marked "S" in this field will be enabled the following options:
- "Calculations> Integration> Recalculation": The Recalculation routine works in the same way as the Event Generation routine, but writes the data to another table (R044REC) and can generate different values as the changes are made after the events for Folha;
- "Calculations> Integration> Generate Differences": The Generate Differences routine is used to compare the differences between the standard calculation (which was for Sheet), which is in the R044MOV table, and what was recalculated (R044REC). This routine compares what has been calculated and recalculated in previous months and writes the differences in another table (R044FEC) only in the current calculation.
- For the calculation of the Calculation from 01/11/00 to 30/11/00. The company generated the integration until November 11, 2000, projecting the hours until November 30, 2000;
- In the second figure, the company recalculated the integration, generating the events until November 30, 2000;
- In the calculation of December the company generated the difference of the calculation of November.
To generate the differences to the sheet you will need to use import and export.
First Week Rule This rule is used to check the days prior to the beginning of the current period to DSR or similar specific calculations.
And there is the rule of first week registered, the control of point and Cafeteria will return in days to find the latest DSR of the previous period. From there it will run this rule. Are used the same variables of the Generation Period rule.
Generation Period Rule
Enter the code for the rule to be executed in generating, calculating variables that can be used by integration.
This rule is executed once for each day, every day, for each employee. Runs after the first week, and in some cases may have the same code.
Rule Period Projection
It is a rule that will be enforced in all days of the period. The projected period starts at the start date of the Sheet Period and goes through the date reported in the "Generate" option.
Is performed after the rule of the period, and in a few days you can run the two rules, if there is overlap between the period of Investigation and the period.
Final Calculation Rule
Enter the code for the rule to be executed in generating, calculating and adjusting the values of the events. This rule is executed once for each employee, after all other rules. Usually this rule gets calculated variables in the first week, rules generation and Projection Period, to launch events.
You can not manipulate the values in the Sheet Moves table (R044MOV) directly via cursor or ExecSQL in this rule. For this, one must use the variables that add up in the events, such as CodEvt, SomaEvtRat, among others.
Events To generate a report automatically after the Integration calculation, enter the name of the template in this field.
HRIN004.GER. When performing the Integration calculation, it is necessary to enter 'S' in the field Generate report. This way, when the calculation is finished the report opens on the screen.
Recalculation Report Events Sheet
To generate a report automatically after the Recalculation of Integration, enter the name of the template in this field.
HRIN005.GER. When performing the Integration recalculation it is necessary to inform "S" in the field Generate report. This way, when the recalculation is finished the report opens on the screen.
Generate Differences in Recalculation
Informed "S" in this field, the batch job will compare the differences between the standard calculus (which was for sheet) which is in the R044MOV table, and what was recalculated (table R044REC).
Differences will be recorded in the table R044FEC with the active calculation code at the time of execution of the routine. The generated differences can be found in Calculations> Integration> Queries> Recalculation, informing "P" in the field Type or listed on report through the HRIN006.GER template.
To send the differences that are in the R044FEC table for the sheet, you must use the import and export. If the value of an event of the R044MOV table is greater than the value of the same event in the R044REC table, the difference generated will be negative.
The option to Generate Differences in Recalculation, will only be enabled to change, if in the Integration Settings it is informed "S" in the field Recalculate Previous Months.
Integrate with success pending
- "N - No": check if the employee has a pending status with the status "Pending with employee", "Expired" or "Pending with manager";
- "S - Yes": the employee will be integrated without any validation.
Integrate with unchecked days
- "N - No": verifies if the employee has any day of the period that has not been verified yet;
- "S - Yes": the employee will be integrated without any validation.
Important
- The system checks according to the calculation period of the calculation code in which the integration is being carried out. If the employee has a calculation exception, the exception period for this verification is considered;
- The fields Integrate with success pending anControle de Ponto e Refeitóriod Integrate with unchecked days only available with Point Management module integrated with the . Therefore, if the employee is in the Point Management, the check of the "Control of days checked" is done according to these fields.
Event Overtime Bank of Hours
Enter the overtime event code for calculation integration.
Event Hours Compensated Bank of Hours
Enter the missing-time event code for calculation integration.
With this configuration of the overtime and missed events for integration, the time bank information is sent to the sheet which, consequently, meets the requirements of eSocial.
In the first month of the compulsory use of eSocial, when there is balance in the bank of hours, it is necessary to send it to the corresponding events, extras or faults. After this month, the sending will be made of the total amount of overtime and negative (only one of the events will be generated, with the difference between the positive and negative hours).
- Opening balance: -20: 00
- Positive hours: 10:00
- Negative hours: 05:00
When it is the first month of eSocial, 15:00 negative will be generated. In a normal month will be generated 05:00.
- Initial Balance: +20: 00
- Positive hours: 05:00
- Negative hours: 30:00
When it is the first month of eSocial, 5:00 negative will be generated. In a normal month will generate 25:00 negative.
Note
The registration of events must be done in Tables> Events> Events> Registration (FR008EVC), with the characteristics 58E - Extraordinary Hours - Bank of Hours and 58F - Hours Compensated - Bank of Hours, in the Personnel Administration module. It is necessary that the events are different from those already used in the registration of the bank of hours for payment of the hours.
The rule to be used is the 066 - Calculation Basis x Informed Value x Calculation Value. In addition, in the Incidents tab, it is necessary to configure, in the current history, the field ESocial Nature, which must be adjusted according to the type of event being registered, as well as the events that must be configured as "N - No".
The beginning of eSocial's obligation is verified in the field Home Newspapers, located under Companies> eSocial Settings, in the Personnel Administration module.
WPRP
Event Pagto. Daytime DSR
Tell where event code will be calculated the day DSR.
Event Pagto. DSR Night
Tell where event code will be calculated the DSR. If the company does not differentiate the DSR's night day enter the same code of the previous data.
Event Day DSR Loss Tell where event code will be calculated the hours of lost DSR diurnal.
Event Night DSR Loss Tell where event code will be calculated the time DSR loss at night.
If the company didn't differentiate DSR loss of daytime nocturnal, enter the same code of the previous data.
If the event reported in the fields Payment Day DSR Event or Event or Night Pay DSR DSR Loss Event or Day DSR Loss Event at Night your registration fields Design, Reduce Hours and empty Unit, the system will inform you that check the event and enter these fields.
Reflex Event Overtime on DSR Inform the code of the event in which the Reflection of Extras on DSR hours will be generated, which must be previously registered in Tables> Events> Registration, informing in the tab Base the codes of the Extra Hours events that should generate the reflection.
The formula used by the system to calculate this event is as follows: Reflection = ((HE * VC) / HT) * HDSR, where:
- HE: Number of Extra Hours.
- VC: Event Calculation Value (reported in field Value Calculation in Tables> Events> Registration).
- HT: Number of Work Hours.
- HDSR: Number of DSR Hours.
- Collaborator with work 190: 40, 29:20 DSR and 2:00 pm overtime with 100%.
- Converting hours to minutes: 11440 working minutes, 1760 minutes of DSR and 120 minutes of extras with 100%.
- Then apply the percentage on the extras: 120 + 100% = 240 minutes.
- Finally, the formula applies: (240/11440) * 1760 = 36.92.
- Converting the result to hours: 00:36.
Thus, the event of Reflex of Extras on DSR will be generated with the reference 00:36.
- When using Apportionment and there are Extras with different Apportionment codes, the calculation will be done separately and a Reflection event will be generated for each apportionment code;
- When there are extras with different percentages, the system performs the calculation separately for each situation and generates the event with the sum of the results;
- The system does not calculate separately for work hours and hours of nocturnal and diurnal DSR. That is, they are summed for the calculation to be carried out;
- The calculation will be made considering the overtime, work and DSR calculated by the integration, considering all the markers involved in these calculations;
- The reflex picks up the hours of the week according to what was defined in the event by the Project Calculation = "N" or by Design Competency = "S".
Event fine DSR day payment Enter the code for the daytime DSR fine payment event.
Event payment fine night DSR Enter the code for the night DSR fine event payment.
Note
Event fine DSR day payment and Event payment fine night DSR:
For integration to the Point Control and Dining, it is necessary to register the Additional Event Released in Hours (39H Rule 66) in the Personnel Administration module.
The setting made for these fields will work in conjunction with the Pay a fine for work in the DSR the Branches screens (FR030FIL) and Trade Unions ( FR014SIN).
Calculation of Mixed DSR
Refer to the Time and Cafeteria Control how to calculate the hours of DSR when timetables diurnal, nocturnal and/or mixed in the same week.
For the calculation of the Proportional and the largest, the Time and Cafeteria Control seeks the daylight hours and at night, as the time registered on the day. Are not considered cleared situations.
Night Converter for DSR Calculation
Valid option when the DSR is Proportional or the highest.
If it is informed "S", performs the conversion of the night hours only to calculate the apportionment of DSR (proportional) or to check if there are more daylight hours or at night (in the case).
Calculate DSR as Scale Tell how to calculate the DSR event.
- "S - Yes": the calculation of the DSR event will be done according to the amount of DSR's (time 9999) reported on the employee scale;
- "N - No": The DSR event will be calculated according to the number of Sundays in the period.
Pay DSR of Last Week Indicate how the company treats the payment discount of DSR when the developer lacks the last week of the period, being the day of DSR is in the next period.
The period ends on a Wednesday. The developer lack on Tuesday and the Chief determines that he will lose the DSR of the week. In this case there are two options, discounting the DSR in this period (Current option) or cash in the following period (option).
Holiday loss will be incurred in the fault period, along with loss of DSR.
In the next period, if it has not been done in the past integration, it will not be lost, since it should have already been discounted for the system. That is, for the system, the holiday loss has the same behavior as the loss of DSR, check the field Pay DSR of Last Week in the definition of integration, "DSR" tab.
If "A" is set, the DSR and Holiday discount will occur within the current month.
Period: 16/09 to 15/10
Missed on 10/14
If the field Loses DSR of Last Week is marked with option "A", the absence of the 14/10 will cause the holiday loss of 20/10 and the DSR of 22/09 to occur.
Pay holiday on day off Indicate whether the company considers the holiday occurred on day off (9996) as DSR or not.
Paying a Holiday on a Compensated Day
Indicate whether the company considers the holiday to be cleared (time 9998) as DSR or not.
This signaling only takes effect if in the Consider Holiday Hours is informed "D".
Consider Faults for Holiday Loss Please inform us if any shortages will cause the loss of the holiday:
- "1 - Do not Consider": faults occurring do not interfere in the loss of the holiday;
- "2 - Faults Before": when there is fault before the holiday the employee will not be entitled to receive the holiday;
- "3 - Faults After": when there is shortage after the holiday the employee will not be entitled to receive the holiday;
- "4 - Faults Before and After": when there are absences in the week, before or after the holiday, the employee will not receive the hours corresponding to the holiday.
Exemplo:Período de competência: 01/06 a 30/09
Período de apuração : 01/06 a 30/09
Data Situações 01/09 Trabalho 02/09 Falta 03/09 Trabalho 04/09 Trabalho 05/09 Trabalho 06/09 DSR 07/09 Feriado 08/09 Trabalho 09/09 Trabalho 10/09 Falta 11/09 Trabalho 12/09 Trabalho 13/09 DSR Neste cenário, se houver integração até o dia 11/09, considerando o campo Gerar Até Término Última Semana com a opção "S - Sim", da tela Geração de Eventos (FRGEREVE), serão gerados no evento de perda de DSR nos dias 06/09, 07/09 e 13/09.
Note
Whenever you use the above tag with value 3 or 4, the holiday will be discounted as parameterized in the Project field of the DSR payment event register.
Competence: 06/01/2016 to 06/30/2016
Trial: 05/16/2016 to 06/15/2016
Event: 4 - DSR Payment
Design: S.
Calculation of the developer:
05/05/2016 - 9997 - Holiday
05/27/2016 - Work
05/28/2016 - Fouls
05/05/2016 - 9999 - DSR
In this scenario, the DSR will only be discounted on 05/29/2016, since the holiday of 05/26/2016 is not considered by the system due to event 4 to consider only as of 01/06/2016.
Competence: 06/01/2016 to 06/30/2016
Trial: 05/16/2016 to 06/15/2016
Event: 4 - DSR Payment
Design: N.
Calculation of the developer:
05/05/2016 - 9997 - Holiday
05/27/2016 - Work
05/28/2016 - Fouls
05/05/2016 - 9999 - DSR
In this scenario, the DSR of 05/29/2016 and the holiday of 05/26/2016 will be deducted because, with the option Designate marked N, event 4 considered the days as of 05/16/2016
Consider Holiday Hours When meeting a holiday, the Point Control and Dining may consider the DSR hours reported on the employee's scale or the hours scheduled for work on the day.
Discounting Followed Dsrs
Determine whether the DSRs followed should be discounted regardless of the type of employee scale.
Discounting only from relay scales Determine whether the DSRs followed should be discounted only on relay scales previously determined through the Scale Classes screen (FR006CLE). Disabled when Discounting Followed Dsrs is set to "N - No".
Option N - No
- Access the Integration Definition screen on the DSR tab.
- In the field Discounting DSRs in a row select the option N - No so that the discount of the DSRs in a row will not occur.
- The field Discounting only from relay scales Comes by default N - No and disabled when the field Discounting DSRs in a row you also have the option N - No.
Option S - Yes
- Access the Integration Definition screen on the DSR tab.
- In the field Discounting DSRs in a row select the option S - Yes so that the DSRs in a row can be discounted.
- The field Discounting only from relay scales comes by default as N - No and is valid only when using relay scale.
Option N - No
- Access the Integration Definition screen on the DSR tab.
- In the field Discounting DSRs in a row select the option N - No so that DSRs will not be discounted in normal and relay scales.
- The field Discounting only from relay scales Comes by default N - No and disabled when the field Discounting DSRs in a row you also have the option N - No.
Note
The field option Relay Scale, of the Scale Classes screen, independent for the operation of the function of not discounting DSRs in a row.
Option S - Yes
- Go to the Scale Classes screen.
- In the field Relay Scale select the option S - Yes. And confirm that in the scale register (FR006ESC) you have this class selected.
- Access the Integration Definition screen on the DSR tab.
- In the field Discounting DSRs in a row select the option S - Yes so that the DSRs can be discounted in normal and relay scales.
- In the field Discounting only from relay scales select the option S - Yes for DSRs to be discounted only on relay scales.
DSR loss
Defines the situations in which the DSR will be lost. If these situations are cleared and exceed the limits established in this guide, the system will generate in the Integration the Day or Night DSR loss events defined in Calculations> Integration> Settings, DSR tab. You can enter up to 100 situations in the grid.
Situation
Code of the situations that cause the loss of DSR.
Code and Description (Miss Cmp)
This is related to the data type and quantity. Indicate the period in which this situation must occur for the DSR is lost.
Allows it to be reported the same situation and the same competence, but with different limits.
Code and Description (Threshold Limit)
Indicate if this situation causes loss of the DSR only when it is complete or for some amount of hours, within the period indicated in Description (Miss Cmp).
- "H - Hours": loses if there is more than the value entered in the given quantity;
- "I - Integral": loses if all the period informed in Description (Miss Cmp);
- "O - Occurrence": loses if occurs more than the amount reported.
Lim. Hours
Enter the amount that the employee must have within the period indicated in the absence competence, above which the DSR will be lost.
This information is requested only when the type is "H" or "the". In the case of occurrences, if report "1", the developer should take over a week. When informed "0" the DSR loss is generated normally.
The employee must lose the DSR if there is more than 02:00 hours a week. In this case please note:
- Fault competence = S
- Type = H
- Quantity = 02:00
The developer must lose the DSR if the situation occurs more than 02 times a week, regardless of the hours. In this case please note:
- Fault competence = S
- Type = O
- Quantity = 02
Note
When the boundary type is set to monthly, it works in parallel with the other boundary types.
Definitions:
| Situation | Cmp. Lack | Tip. Limit | Lim. Hours |
| 15 - Fouls | D | (I) | 00:00 |
| 103 - Delay | M | H | 00:00 |
Situations of the employee in the calculation period:
12/09/2015 - Fouls
10/12/2015 - Delay
Days with DSR in the period:
12/13/2015
12/20/2015
In this case, the two DSRs will be lost because there was a full fault that caused the DSR loss on 12/13/2015 and a delay in the month that resulted in the loss on 12/20/2015.
Holidays Faults
Defines the situations that can cause missed leave to lose vacation through the integration calculation. You can report up to 100 situations in the grid.
This option may only be used when there is more than one occurrence of a particular situation in the period in question. That is, if the employee has a delay in the period, it is not considered as a fault to accumulate in the calculation of the loss of vacations, but if the employee has five delays in the period, then the system should generate a absence of absence, which will count for loss of vacation.
Another possibility is when you want to generate a fault for the loss of vacation only if the sum of the hours of the situation is greater than the limit set.
It is desired to generate the missed holiday loss only if the sum of the period's delay hours is greater than 08:00 hours.
In the case of full absences, if a missed day is already considered to accumulate for the calculation of the loss of vacation days, it is recommended to use the field Lose holiday, in the register of the situation.
The calculation of the holiday entitlement days is carried out by the Personnel Administration module. The Point Control and Canteen will only generate the missed trips that will serve for this module to control the holiday entitlement.
Situation Away Missing Holidays
Please state the code of the situation with which you will be removed from the holiday absence. The calculation of integration will generate a removal with this situation.
Limit of Hours Enter the hours limit for a foul for vacation. In the generation of the hours for the sheet, the system will generate a day of loss for holidays on the date where the balance reaches this limit.
Occurrence Limit Enter the limit of occurrences (times) for a foul for vacation. In the generation of the hours for the sheet, the system will generate a day of loss for holidays on the date where the balance reaches this limit.
Grid Situations Missing Holidays
Important
- To be generated, the system checks the R010SIT fields. PerDih and R010SIT. PerDim of the situation reported here. If the employee is hourly, the PerDih field can not contain "N". If it is monthly, the PerDim field can not contain "N". If these conditions are not obeyed, the system will not generate the remoteness;
- To view the boundary Time and Cafeteria Control module sum all situations.
English
Español


