Column Name | Data Type | Description |
---|---|---|
Plan Type | VARCHAR2 | The name of the plan type code. |
Plan | VARCHAR2 | The name of the Benefit Plan Code. |
Description | VARCHAR2 | Text to further describe the Benefit Plan. |
Participation Rule | LEXICON | A lexicon of values from X_PARTICIPATION_RULE that indicate if the Benefit Plan is Optional or Required. |
STATUS | LEXICON | A lexicon of values from X_ENROLLMENT_STATUS. This value indicates if the employee is Enrolled in the benefit or not. |
Column Name | Data Type | Description |
---|---|---|
Name | VARCHAR2 | The name of the contact. |
Gender | LEXICON | A Lexicon with a list of Genders that could apply to the contact. The lexicon can be found at X_GENDER. |
Relation | LEXICON | A lexicon with a list of Relations such as 'Brother'. The lexicon values can be found at X_RELATION. |
Benefit% | NUMBER | A percentage used to indicate the percentage of the benefit that an employee is to receive. For example, 50% of a Life Insurance Plan. |
Start Date | DATE | A date that identifies the start of the period of time for which the contact will become a benefit recipient. |
End Date | DATE | A date that identifies the enmd of the period of time for which the contact will become a benefit recipient. |
Bond Participation | LEXICON | A lexicon that indicates the participation type of the BOND. Lexicon values can be found at X_BOND_PARTICIPATION. |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation