BenefitEnrollmentsproviders
BenefitEnrollmentsproviders
Columns
Name | Type | Description |
BenefitEnrollmentsEnrollmentResultId [KEY] | Long | BenefitEnrollmentsEnrollmentResultId of BenefitEnrollmentsproviders |
ProviderOrganizationId [KEY] | Long | ProviderOrganizationId of BenefitEnrollmentsproviders |
PlanId | Long | PlanId of BenefitEnrollmentsproviders |
OrganizationId | Long | OrganizationId of BenefitEnrollmentsproviders |
OrganizationName | String | OrganizationName of BenefitEnrollmentsproviders |
PolicyNumber | String | PolicyNumber of BenefitEnrollmentsproviders |
CustomerNumber | Double | CustomerNumber of BenefitEnrollmentsproviders |
EffectiveStartDate | Date | EffectiveStartDate of BenefitEnrollmentsproviders |
EffectiveEndDate | Date | EffectiveEndDate of BenefitEnrollmentsproviders |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
DependentName | String | DependentName |
EffectiveDate | Date | EffectiveDate |
EnrollmentResultId | Long | EnrollmentResultId |
ParticipantPersonId | Long | ParticipantPersonId |
Relation | String | Relation |
EffectiveDate | Date | effectiveDate |
Finder | String | finder |