This page (revision-16) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by JMyers

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
16 26-Nov-2021 10:22 3 KB jmyers to previous
15 26-Nov-2021 10:22 3 KB jmyers to previous | to last
14 26-Nov-2021 10:22 2 KB jmyers to previous | to last
13 26-Nov-2021 10:22 9 KB jmyers to previous | to last
12 26-Nov-2021 10:22 9 KB jmyers to previous | to last
11 26-Nov-2021 10:22 9 KB jmyers to previous | to last
10 26-Nov-2021 10:22 2 KB JMyers to previous | to last
9 26-Nov-2021 10:22 2 KB JMyers to previous | to last
8 26-Nov-2021 10:22 2 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JMyers to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 318 bytes JMyers to last

Page References

Incoming links Outgoing links
IVBEN
IVBEN

Version management

Difference between version and

At line 1 changed 2 lines
[{TableOfContents }]
!!!ENROLLMENTS INTERFACE FILE
Enrollments Interface File
At line 4 changed 32 lines
The Enrollments Interface File screen is used to import the list of benefit plans and coverages that an employee has elected to participate in into the software data structures. The plan, coverage and Benefit Components must be defined in the benefit module before loading in ENROLLMENT records.
Enrollments Interface File data is maintained on the [INF_CV_ENROLLMENTS] table.
----
;[ID|ID]:This field identifies the enrollment record within the database.
;[Entity|ENTITY_CODE]:The entity associated with the enrollment files will be defined in this field.
;[Person Code|PERSON_CODE]:The employee associated with the enrollment files will be defined in this field.
;[Employment Type|EMPLOYMENT_TYPE]:The employee's employment type is listed in this field.
;[Date of Hire|HIRE_DATE]:The employee's hire date is displayed in this field.
;[Plan|PLAN_CODE]:The plan the employee enrolled in is displayed in this field.
;[Effective as Of|EFFECTIVE]:This field holds the date from when an employee is enrolled into the coverage.
;[Expires On|EXPIRY]:This is the date after which the employee is no longer enrolled in the coverage.
;[Change Reason|CHANGE_CODE]:The change reason, a user-defined table, allows users to track why information has been created or changed as of an effective date.
;[Coverage|COVERAGE_CODE]:The coverage that the employee is enrolled in is displayed in this field.
;[Frequency|FREQUENCY_CODE]:This is the frequency of the benefit cycle for this coverage for the employee.
;[Participation Rule|PARTICIPATION_RULE]:This field indicates whether participation in a benefit plan or coverage is mandatory or optional.
;[Coverage Step|COVERAGE_STEP_CODE]:The coverage step the employee is at is displayed in this field.
;[Description|DESCRIPTION]:A description of the plan enrollment will be displayed in this field.
;[Unofficial|UNOFFICIAL]:This field indicates whether an update process of the system has or has not yet committed the record.
;[Status|ENROLLMENT_STATUS]:The employee's enrollment status will be displayed in this field.
;[Start Date of Eligibility|ELIGIBILITY_START_DATE]/[Eligibility to End of|ELIGIBILITY_END_DATE]:The dates the employee is eligible for the the plan are displayed these fields
;[Premium to Start on|PREMIUM_START_DATE]/[Premium to End on|PREMIUM_END_DATE]:The dates the premium is effective are displayed in these fields.
;[Registration #|PLAN_REG_NUMBER]:The plan registration number is displayed in this field.
;[Evidence of Insurance|EVIDENCE_OF_INSURANCE]:If this toggle is ON, there is a hard copy of “Evidence of Insurance” that has been received. If this toggle is OFF, there was no hard copy provided.
;[Percentage|PERCENTAGE]:This field indicates the benefit percentage an employee receives in the event of a claim.
;[BC Code|BC_CODE]:The benefit component associated with this coverage is identified in this field.
;[Amount $|AMOUNT]:This is the value of the person's coverage component amount.
;[O/R Amount $|AMOUNT_OVERRIDE]:This field provides the value of any override amount entered by the user.
----
![Notes|Edit:Internal.IVBEN]
[{InsertPage page='Internal.IVBEN' default='Click to create a new notes page'}]
The INF_CV_ENROLLMENTS table is used to import the list of benefit plans and coverage’s that an employee has elected to participate in into the software data structures. The Plan, Coverage and Benefit Components must be defined in the benefit module before loading in ENROLLMENT records
This page (revision-16) was last changed on 26-Nov-2021 10:22 by jmyersTop