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 11 added 24 lines
||Name|| Null? ||Type|| Notes
|[LEAVE_TYPE_CODE] | NOT NULL | VARCHAR2(16)| Must be a valid Leave Policy Type entry from the [IAPT] screen
|[LEAVE_POLICY_CODE]| NOT NULL | VARCHAR2(16) | Must be a valid Leave Policy entry from the [IALP] screen
|[ENTITY_CODE] | NOT NULL | VARCHAR2(16)| Used to link to the EMPLOYEE records on [IEEI]
|[PERSON_CODE ] | NOT NULL | VARCHAR2(16)| Used to link to the EMPLOYEE records on [IEEI]
|[EMPLOYMENT_TYPE] | | VARCHAR2(30)| Used to link to the EMPLOYEE records on [IEEI]
|[HIRE_DATE] | | DATE |Used to link to the EMPLOYEE records on [IEEI]
|[LEAVE_POLICY_YEAR]| NOT NULL | NUMBER(5,0)| Must be set to the four digit year the records ends in.
|[UNOFFICIAL] | NOT NULL | VARCHAR2(30)| Must be a valid lexicon entry. Typically set to '1', for Official
|[START_DATE] | | DATE |Must be set to the anniversary of the Leave Policy start date from [IALP]
|[END_DATE] | | DATE |Must be set to the anniversary of the Leave Policy end date from [IALP]
|[LEAVE_POLICY_STATUS]| | VARCHAR2(30)| Must be a valid lexicon entry. Typically set to '01', for Active
|[EVALUATED_BY] | | VARCHAR2(50)| Must be a valid user from the [IMUS] screen. Typically set to 'P2K'
|[EVALUATED_DATE] | | DATE |
|[ENTITLEMENT_FROZEN] | | VARCHAR2(4)| Check mark field. Typically left blank.
|[LAST_PAYNO_PROCESSED]| | NUMBER(5,0)|
|[SERVICE_EVALUATION_DATE]| | DATE |Last date the records was processed through system. Set to [START_DATE]
|[ENTITLEMENT_GIVEN_DATE] | | DATE |Last date the any time was earned for this bank. Typically set tot [START_DATE]
|[AC_CODE] | | VARCHAR2(16)| Attendance Component Code for bank. Typically set to either [A290|AC-A290], [A300|AC-A300] or [A900|AC-A900]
|[EFFECTIVE] | | DATE| Date this record becomes active. Typically set to HIRE_DATE.
|[ACCRUAL_TYPE] | | VARCHAR2(30)| Must be a valid lexicon entry. Typically set to '03' for Entitlement. This will be replaced during [UACALC]/[UPCALC]
|[ACCRUAL_VALUE] | | VARCHAR2(200)|
|[ACCRUAL_VALUE_OVERRIDE]| | VARCHAR2(200)| Typically left blank.
|[ACCRUAL_VALUE_BASIS] | | VARCHAR2(30)| Must be a valid lexicon entry. Typically set to '07', for Hourly
At line 13 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-900] 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 15 changed one line
The [A290|AC-A290], [A300|AC-A300] and [A900|AC-A900] [AC_CODES] track time only. If you have any leave banks that track the dollars associate to this time, you will also need to loaded and convert the [A380|AC-A380], [A370|AC-A370] and [A950|AC-A950]. These are the current year amount earned, current year amount paid and the amount owing at year end. Since most leave banks are tracking time and not dollars, it is rare to convert these AC codes.
The [A290|AC-A290], [A300|AC-A300] and [A900|AC-A900] [AC CODES|AC_CODE] track time only. If you have any leave banks that track the dollars associate to this time, you will also need to loaded and convert the [A380|AC-A380], [A370|AC-A370] and [A950|AC-A950]. These are the current year amount earned, current year amount paid and the amount owing at year end. Since most leave banks are tracking time and not dollars, it is rare to convert these AC codes.
This page (revision-4) was last changed on 26-Nov-2021 10:22 by JEscottTop