ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses

TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses

Columns

Name Type Description
TimeRecordGroupstimeRecordGroupId [KEY] Long TimeRecordGroupstimeRecordGroupId of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
TimerecordgroupstimeRecordGroupId [KEY] Long TimerecordgroupstimeRecordGroupId of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
TimerecordstimeRecordId [KEY] Double TimerecordstimeRecordId of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
StatusId [KEY] Long StatusId of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
TimeBuildingBlockId Long TimeBuildingBlockId of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
TimeBuildingBlockVersion Int TimeBuildingBlockVersion of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
StatusName String StatusName of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
StatusCode String StatusCode of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
StatusValue String StatusValue of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses
DisplayValue String DisplayValue of TimeRecordGroupstimeRecordGroupstimeRecordstimeStatuses

Pseudo-Columns

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

Name Type Description
Finder String finder
GroupType String groupType
PersonId Long personId
PersonNumber String personNumber
StartTime Datetime startTime
StopTime Datetime stopTime
TimeRecordGroupId Long timeRecordGroupId

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