PlanBalancesplanBalanceDetails
PlanBalancesplanBalanceDetails
Columns
Name | Type | Description |
PlanBalancespersonPlanEnrollmentId [KEY] | Long | PlanBalancespersonPlanEnrollmentId of PlanBalancesplanBalanceDetails |
PersonAccrualEntryDtlId [KEY] | Long | PersonAccrualEntryDtlId of PlanBalancesplanBalanceDetails |
TransactionDate | Date | TransactionDate of PlanBalancesplanBalanceDetails |
TransactionTypeCode | String | TransactionTypeCode of PlanBalancesplanBalanceDetails |
TransactionTypeName | String | TransactionTypeName of PlanBalancesplanBalanceDetails |
Value | String | Value of PlanBalancesplanBalanceDetails |
Status | String | Status of PlanBalancesplanBalanceDetails |
AdditionalInformation | String | AdditionalInformation of PlanBalancesplanBalanceDetails |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
SysEffectiveDate | String | SysEffectiveDate |
AssignmentId | Long | assignmentId |
BalanceAsOfDate | Date | balanceAsOfDate |
Finder | String | finder |
Level | String | level |
PersonId | Long | personId |
PersonPlanEnrollmentId | Long | personPlanEnrollmentId |
PlanId | Long | planId |