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 |