PlanBalances
PlanBalances
Columns
| Name | Type | Description |
| PersonId | Long | PersonId of PlanBalances |
| PersonPlanEnrollmentId [KEY] | Long | PersonPlanEnrollmentId of PlanBalances |
| PlanName | String | PlanName of PlanBalances |
| PlanId | Long | PlanId of PlanBalances |
| PlanType | String | PlanType of PlanBalances |
| PlanStatus | String | PlanStatus of PlanBalances |
| PlanStatusMeaning | String | PlanStatusMeaning of PlanBalances |
| PlanDisplayStatusFlag | Bool | PlanDisplayStatusFlag of PlanBalances |
| EnrollmentStartDate | Date | EnrollmentStartDate of PlanBalances |
| EnrollmentEndDate | Date | EnrollmentEndDate of PlanBalances |
| BalanceAsOfBalanceCalculationDate | Double | BalanceAsOfBalanceCalculationDate of PlanBalances |
| BalanceCalculationDate | Date | BalanceCalculationDate of PlanBalances |
| PlanUnitOfMeasure | String | PlanUnitOfMeasure of PlanBalances |
| UnitOfMeasureMeaning | String | UnitOfMeasureMeaning of PlanBalances |
| SysEffectiveDate | Date | SysEffectiveDate of PlanBalances |
| EffectiveStartDate | Date | EffectiveStartDate of PlanBalances |
| EffectiveEndDate | Date | EffectiveEndDate of PlanBalances |
| Level | String | Level of PlanBalances |
| PlanEnrollmentStatus | String | PlanEnrollmentStatus of PlanBalances |
| AssignmentId | Long | AssignmentId of PlanBalances |
| AssignmentName | String | AssignmentName of PlanBalances |
| AssignmentNumber | String | AssignmentNumber of PlanBalances |
| FormattedBalance | String | FormattedBalance of PlanBalances |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BalanceAsOfDate | Date | balanceAsOfDate |
| Finder | String | finder |