This page (revision-4) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 6 KB JEscott to previous
3 26-Nov-2021 10:22 6 KB JEscott to previous | to last
2 26-Nov-2021 10:22 3 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
CONVERTING ATTENDANCE BANKS
CONVERTING ATTENDANCE BANKS

Version management

Difference between version and

At line 3 changed one line
The application stores the information for employee leave balances in a set of tables accessible from the [IALA] screen. This screen reads from the [P2K_AT_LEAVE_ACCRUALS] and it dependent table [P2K_AT_LEAVE_ACCRUAL_DETAILS]. The process of converting these records is to load them into the interface table, [INF_CV_ACCRUALS], first and run the conversion procedure to move them from this table into the two application tables.
The application stores the information for employee leave balances in a set of tables accessible from the [IALA] screen. This screen reads from the [P2K_AT_LEAVE_ACCRUALS] and it dependent table [P2K_AT_LEAVE_ACCRUAL_DETAILS]. The process of converting these records is to load them into the interface table, INF_CV_ACCRUALS, first and run the conversion procedure to move them from this table into the two application tables.
At line 37 changed one line
Each leave bank will have a minimum of one record in the [INF_CV_ACCRUALS] table with all the “NOT NULL” fields filled in, as well as the [AC_CODE] and [ACCRUAL_VALUE]. This record will have the [AC_CODE] set to [A290|AC-A290] and the [ACCRUAL_VALUE] set to the amount of time the employee has available in the bank. However, it is highly recommended that the [A300|AC-A300] record also be loaded and converted to accurately calculate the amount of time remaining in the leave bank. [A900|AC-A900] will also need to be loaded and converted if the bank allows the rolling over of time from one year to the next.
Each leave bank will have a minimum of one record in the INF_CV_ACCRUALS table with all the “NOT NULL” fields filled in, as well as the [AC_CODE] and [ACCRUAL_VALUE]. This record will have the [AC_CODE] set to [A290|AC-A290] and the [ACCRUAL_VALUE] set to the amount of time the employee has available in the bank. However, it is highly recommended that the [A300|AC-A300] record also be loaded and converted to accurately calculate the amount of time remaining in the leave bank. [A900|AC-A900] will also need to be loaded and converted if the bank allows the rolling over of time from one year to the next.
At line 45 removed 5 lines
----
![Notes|Edit:Internal.CONVERTING+ATTENDANCE+BANKS]
[{InsertPage page='Internal.CONVERTING+ATTENDANCE+BANKS' default='Click to create a new notes page'}]
This page (revision-4) was last changed on 26-Nov-2021 10:22 by JEscottTop