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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。