Benefits Extract Custom Data Rule

You can use this formula type to insert 3 extra fields to the delivered output file.

Contexts

The following contexts are available to formulas of this type:

• HR_RELATIONSHIP_ID
• HR_TERM_ID
• LC_DATE_FROM
• LC_DATE_TO
• PAYROLL_RELATIONSHIP_ID
• PAYROLL_TERM_ID
• LEGAL_EMPLOYER_ID
• DATE_EARNED
• HR_ASSIGNMENT_ID BUSINESS_GROUP_ID
• PERSON_ID JOB_ID
• EFFECTIVE_DATE PAYROLL_ASSIGNMENT_ID
• PAYROLL_ID
• LEGISLATIVE_DATA_GROUP_ID
• LER_ID
• OPT_ID
• ORGANIZATION_ID ACTY_BASE_RT_ID
• PGM_ID
• PL_ID
• PL_TYP_ID
• BENEFIT_RELATION_ID
• PER_IN_LER_ID

Database Items

There are no specific DBIs created for this formula type. All contexts that are available for the Participation and Rate Eligibility formula type are available for this extract formula type too.

Input Variables

Input variables aren't available to formulas of this type.

Return Variables

This formula can return a maximum of three values.

Errors

If the formula returns any other output value, then the participation process errors with BEN_91329_FORMULA_RETURN.