JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

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 Decimal BalanceAsOfBalanceCalculationDate of PlanBalances
BalanceCalculationDate Date BalanceCalculationDate of PlanBalances
PlanUnitOfMeasure String PlanUnitOfMeasure of PlanBalances
UnitOfMeasureMeaning String UnitOfMeasureMeaning of PlanBalances
PlanTypeCode String PlanTypeCode of PlanBalances
CeilingAmount Decimal CeilingAmount 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
PlanPeriodStartDate Date PlanPeriodStartDate of PlanBalances
PlanPeriodEndDate Date PlanPeriodEndDate of PlanBalances
FormattedCeilingAmount String FormattedCeilingAmount of PlanBalances
RecipientAliasName String RecipientAliasName of PlanBalances
MultiYearCarryOverFlag Bool MultiYearCarryOverFlag of PlanBalances
SysEffectiveDate Date SysEffectiveDate of PlanBalances
BalanceAsOfDate Date BalanceAsOfDate of PlanBalances
Finder String Finder of PlanBalances

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062