BenefitEnrollments
BenefitEnrollments
Columns
Name | Type | Description |
EnrollmentResultId [KEY] | Long | EnrollmentResultId of BenefitEnrollments |
PersonId | Long | PersonId of BenefitEnrollments |
ProgramId | Long | ProgramId of BenefitEnrollments |
PlanTypeId | Long | PlanTypeId of BenefitEnrollments |
PlanId | Long | PlanId of BenefitEnrollments |
OptionId | Long | OptionId of BenefitEnrollments |
PersonName | String | PersonName of BenefitEnrollments |
EnrollmentCoverageStartDate | Date | EnrollmentCoverageStartDate of BenefitEnrollments |
OriginalCoverageStartDate | Date | OriginalCoverageStartDate of BenefitEnrollments |
EnrollmentCoverageEndDate | Date | EnrollmentCoverageEndDate of BenefitEnrollments |
ProgramName | String | ProgramName of BenefitEnrollments |
PlanTypeName | String | PlanTypeName of BenefitEnrollments |
PlanName | String | PlanName of BenefitEnrollments |
OptionName | String | OptionName of BenefitEnrollments |
NonMonetaryUnit | String | NonMonetaryUnit of BenefitEnrollments |
CurrencyCode | String | CurrencyCode of BenefitEnrollments |
CoverageAmount | Double | CoverageAmount of BenefitEnrollments |
SuspendFlag | Bool | SuspendFlag of BenefitEnrollments |
InterimFlag | Bool | InterimFlag of BenefitEnrollments |
ObjectVersionNumber | Int | ObjectVersionNumber of BenefitEnrollments |
CreatedBy | String | CreatedBy of BenefitEnrollments |
CreationDate | Datetime | CreationDate of BenefitEnrollments |
LastUpdateDate | Datetime | LastUpdateDate of BenefitEnrollments |
LastUpdatedBy | String | LastUpdatedBy of BenefitEnrollments |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
DependentName | String | DependentName |
EffectiveDate | Date | EffectiveDate |
ParticipantPersonId | Long | ParticipantPersonId |
Relation | String | Relation |
EffectiveDate | Date | effectiveDate |
Finder | String | finder |