Tables / Calculations / Time and Cafeteria Control Module / Hour bank / Maintenance

Maintenance

Database maintenance hours can be consulted all releases occurred in the active period, performed by calculation, event generation or typed in the proper maintenance.

You can only change or delete the "D" source postings, that is, the postings you enter in maintenance. Entries with origin "A" can only be changed in the Calculation, and the entries with origin "G" and "N" can only be changed through the generation of events.

On the window, in addition to being shown the Bank releases, you can show the beginning and ending balances of the period and positive and negative hours that win in the active period.

Important

The scopes defined on the tab of database registration hours are observed according to the schedules and historical collaborator on the date of each release.
Whenever the ExecSql command is used to change an entry in the R011LAN table, you must also update the R011ASS table, and vice versa, so that data integrity is maintained between these two tables.

Opening balance
Displays the beginning balance, before being considered the launches that occurred within the period.

Grid launches

In this grid are shown the launches of hours corresponding to the period of investigation.

Date
This date corresponds to the day they were cleared overtime or fouls.

Situation
Code for the situation in which the hours were calculated.

Origin
The source of the release can be:

THE - Calculated in the calculation or launched in the screen of contests of collaborators.
B - Early Payment, through the integration when you use the Add Payment option.
D - Entered on the hours bank maintenance screen.
G - Calculated in event integration.
N - Calculated when integrating events, when using the Undo Debit option.
O - Others, can be an imported release or rule via insert.
R - Calculated via rule using the IncLanBhr function.
F - Migration by branch transfer with registration change.

Amount
Value of the hours posted.

Compensation Limit
Maximum period for compensation of the hours of the launch.

At the bottom of the window displays the following information:

Final balance -corresponds to the hours to be compensated in the next periods. If there are entries in the Bank whose maximum compensation ends the active period, those hours will be deducted from the Final balance and will be shown in the field Hours to win.

Hours Month

Positive- Displays a sum of positive releases occurred hours within the active calculation.
Negatives - Displays a sum of the negative hours of the postings that occurred within the active calculation.

Hours to Win

Positive-Displays total hours of positive releases with deadline (DatCmp field of R011LAN table) between the start and end dates of the active calculation. These hours will be paid in the calculation of integration.
Negative-Displays total hours of the negative postings with closing date (field DatCmp R011LAN table) between the start and end dates of the active calculation. These hours will be deducted from the calculation of integration.