Functional Description
Purpose
based on the gap status in records in the Appraisal table, F087711. If the competency level is updateable, then the function determines if any
records exist in F0800609 to be updated. The function must be passed the employee's address number, the competency type and the
competency code. The function will return a Competency Level Updateable flag and Found Records to Update flag.
The Competency Level Updateable flag indicates if the employee competency level is updateable. The Found Records to Update flag
indicates if there are any records in the Gap Analysis table, F0800609 to update. Therefore if the Competency Level Updateable flag = '1' the
competency level is updateable and if Competency Level Updateable flag = '0' the competency level is not updateable. Additionally, if the
Records Found flag = '1' there are records present in the F0800609 to update and if Records Found flag = '0' there are no records in F0800609 to
update.
There are basically three scenarios that can take place, which are all based upon the gap status in records in F087711. A gap status of
'3' or '4' means the performance appraisal is locked and under review. Therefore, no records should be updated. If there are any
performance appraisals with a status less than'3' then there are records to update. The first scenario is, if no records have a status of '3' or '4' and
there is a record with a status less than '3' the Competency Level Updateable flag = '1' and the Records Found flag = '1'. This means the
Competency Level is updateable and there are records to update. The second scenario is, if no records have a status of '3' or '4' and there is
no record with a status less than '3' the Competency Level Updateable flag = '1' and Records Found flag = '1'. This means the competency
level is updateable, but there are no records in F0800609 to update. The third scenario is, if one or more records have a status of '3' or '4'
the Competency Level Updateable flag = '0' and therefore the competency level is not updateable so no F0800609 records need to be updated.
Setup Notes and Prerequisites
Special Logic
Technical Specification
The Competency Level Updateable flag indicates if the employee competency level is updateable. The Found Records to Update flag
indicates if there are any records in the Gap Analysis table, F0800609 to update. Therefore if the Competency Level Updateable flag = '1' the
competency level is updateable and if Competency Level Updateable flag = '0' the competency level is not updateable. Additionally, if the
Records Found flag = '1' there are records present in the F0800609 to update and if Records Found flag = '0' there are no records in F0800609 to
update.
D0500530 - Update GAP Competency Level
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| mnAddressNumber | AN8 | MATH_NUMERIC | REQ | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| szCompentencyType | CMPE | char | REQ | INPUT |
A code that identifies a competency table or category for which you can track employee competencies. Valid values
| ||||
| szCompentencyCode | CMPC | char | REQ | INPUT |
A code that specifies a competency within a competency type. For example, a competency for the competency type "Skill" might be "C
| ||||
| cFoundRecordsToUpdateFlag | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
| cCompLevelUpdateable | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
| None |
| None |