/****************************************************************
FORMULA NAME: PROMOTION_TEMPLATE
FORMULA TYPE: Promotion
DESCRIPTION: This formula determines whether or not an employee
has received a promotion as of the date earned
being passed into the formula.
When called from the promotions package, this
formula will be used to calculate the number of
promotions which have occurred over a specified
period.
To use this functionality please copy the code
into a new formula named PROMOTION with a type of
Promotion and uncomment the code.
Then, to use the default functionality, set
up an assignment change reason with a meaning of
Promotion in the lookup table EMP_ASSIGN_REASON
This formula can also be customized, by either
using different change reasons, additional change
reasons, or by using different criteria with
which to define promotion.
For instance, additional change reasons of
HQ Move and Position Change could be added in the
same way as Promotion so that the formula will
record a promotion when there is a change reason
of Promotion, HQ Move or Position Change.
Also grade changes could be used as promotion
criteria, for instance, instead of the change
reason. This would require a different database
item such as ASG_GRADE or ASG_GRADE_DATE_FROM.
The formula could return a count of 1 where
ASG_GRADE_DATE_FROM = DATE_EARNED, thus recording
grade changes as promotions.
INPUTS:
RETURNS: A count which will return a 1 if a promotion has
occurred,according to rules described above and a
0 if one has not.
DBI Required: none are required, but the default formula uses
asg_change_reason : the assignment change reason
*****************************************************************/
default for ASG_CHANGE_REASON is 'Record Reason'
l_count = 0
/**************************************************************
Example code - this will count all occurrences where Assignment
Change Reason is Promotion
**************************************************************/
/****
==
uncomment code below for default functionality, or customize
==
****/
/*
if ASG_CHANGE_REASON = 'Promotion' then
(
l_count = 1
)
else
(
l_count = 0
)
*/
return l_count

Previous  |  Next ]     [ Up  |  First  |  Last ]     (Article 732 of 732)
 
Popay Documentool