EmployeeEnrollment
Retrieves employee benefit plan enrollment records for the BenefitsAdministration schema.
View-Specific Information
The EmployeeEnrollment view provides read-only access to JD Edwards employee benefits enrollment records from the BenefitsAdministration schema. This view does not support insert, update, or delete operations.
Select
The add-in uses the JD Edwards API to process WHERE clause conditions for all columns in this table. All columns support server-side filtering via the JD Edwards QBE (Query By Example) mechanism.
The supported operators depend on the column data type:
- Text columns (PlanID, EnrSts, EndSts, AddOpt, UserID, ProgramID, WorkStnID): support =, !=, LIKE, and IN.
- Numeric columns (AddressNumber, Factor, SequenceNumber): support =, !=, <, <=, >, >=, and IN.
- Date columns (EffectiveDate, EndingDate, DateEligible, ParticipationDate, ...): support =, !=, <, <=, >, >=, and IN. Two conditions on the same date column can be combined to express a range.
For example, the following query is processed server-side:
SELECT * FROM EmployeeEnrollment WHERE AddressNumber = 1001 AND EffectiveDate >= '2024-01-01' AND PlanID = 'MEDICAL'
Columns
| Name | Type | Description |
| AddressNumber | Decimal | Address Number |
| PlanID | String | Plan ID |
| EffectiveDate | Date | Effective Date |
| EndingDate | Date | Ending Date |
| EnrSts | String | Enr Sts |
| EndSts | String | End Sts |
| DateEligible | Date | Date Eligible |
| ParticipationDate | Date | Participation Date |
| UserDefDate | Date | User Def Date |
| AddOpt | String | Add Opt |
| Factor | Decimal | Factor |
| DBABegins | Date | DBA Begins |
| DBAEnds | Date | DBA Ends |
| SequenceNumber | Decimal | Sequence Number |
| UserID | String | User ID |
| ProgramID | String | Program ID |
| WorkStnID | String | Work Stn ID |
| DateUpdated | Date | Date Updated |