Coverage Upper Limit
This formula type determines the upper bound on the benefit amount that a participant can elect as part of a compensation object.
Contexts
The following contexts are available:
- BUSINESS_GROUP_ID ( ENTERPRISE_ID)
- EFFECTIVE_DATE
- HR_ASSIGNMENT_ID
- PGM_ID
- PL_ID
- PER_IN_LER_ID
- LER_ID
- BENEFIT_RELATION_ID
- PL_TYP_ID
- OPT_ID
- ORGANIZATION_ID
- ELIG_PER_ELCTBL_CHC_ID
- ENRT_CTFN_TYP_CD
Database Items
Use only the following database items that are available to formulas of this type:
- Database items based on person’s assignment: HR_ASSIGNMENT_ID AND PERSON_ID
Input Variables
The following input variables are available:
| Input | Data Type | Required | Description |
|---|---|---|---|
| BEN_IV_RT_STRT_DT | Date | N | Rate start date |
| BEN_IV_CVG_STRT_DT | Date | N | Coverage start date |
Return Variables
The following return variables are available to formulas of this type. Any name can be used for the return variable.
| Out Variable Name | Data Type | Remarks |
|---|---|---|
| L_OUTPUT | Number | Coverage upper limit |
Sample Formula 1:
FORMULA TYPE : Coverage Upper Limit
DEFAULT FOR CMP_ASSIGNMENT_SALARY_ANNUAL_AMOUNT is 0
l_sal=CMP_ASSIGNMENT_SALARY_ANNUAL_AMOUNT
L_MX_CVG_ALWD_AMT = LEAST((5*l_sal),2000000)
RETURN L_MX_CVG_ALWD_AMT