The following table shows the fields used for the enrollment questions and answers. This information can assist you in generating data reports with SAP Crystal Reports.
| Table/Field | Type | Length | Description |
|---|---|---|---|
|
tBenefit_Election_Plan_Questions |
|
|
|
|
BenefitElectionPlanQuestionIdNo |
Int |
N/A |
Question Id |
|
BenefitPlanIdNo |
Int |
N/A |
Benefit Plan Id |
|
BenefitElectionPlanQuestionOrder |
TinyInt |
N/A |
Question Order |
|
BenefitElectionPlanQuestion |
VarChar |
150 |
Question |
|
BenefitElectionPlanQuestionTypeIdNo |
Int |
N/A |
Question Type -12900 = Drop Down List -12901 = Radio Buttons -12902 = Text Box |
|
BenefitElectionPlanQuestionValues |
VarChar |
200 |
Question Values |
|
BenefitElectionPlanQuestionRequiredInd |
Bit |
N/A |
Question Required Indicator |
|
BenefitElectionPlanQuestionInactiveInd |
Bit |
N/A |
Question Inactive Indicator |
|
BenefitElectionPlanQuestionTimestamp |
Timestamp |
N/A |
Timestamp |
|
tEmployee_Open_Enrollment_Benefit_Plan_Answer |
|
|
|
|
EmployeeOpenEnrollmentBenefitPlanIdNo |
Int |
N/A |
Benefit Plan Id |
|
BenefitElectionPlanQuestionIdNo |
Int |
N/A |
Question Id |
|
EmployeeOpenEnrollmentBenefitPlanAnswer |
VarChar |
100 |
Answer |
|
EmployeeOpenEnrollmentBenefitPlanAnswerTimestamp |
Timestamp |
N/A |
Timestamp |
|
tEmployee_Life_Event_Benefit_Plan_Answer |
|
|
|
|
EmployeeLifeEventBenefitPlanIdNo |
Int |
N/A |
Benefit Plan Id |
|
BenefitElectionPlanQuestionIdNo |
Int |
N/A |
Question Id |
|
EmployeeLifeEventBenefitPlanAnswer |
VarChar |
100 |
Answer |
|
EmployeeLifeEventBenefitPlanAnswerTimestamp |
Timestamp |
N/A |
Timestamp |