ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

TimeRecordEventRequeststimeRecordEventtimeRecordEventAttribute

TimeRecordEventRequeststimeRecordEventtimeRecordEventAttribute

Columns

Name Type Description
TimeRecordEventRequeststimeRecordEventRequestId [KEY] Long TimeRecordEventRequeststimeRecordEventRequestId of TimeRecordEventRequeststimeRecordEventtimeRecordEventAttribute
TimerecordeventtimeRecordEventId [KEY] Long TimerecordeventtimeRecordEventId of TimeRecordEventRequeststimeRecordEventtimeRecordEventAttribute
TimeAttributeFieldId Long Unique identifier for the field that the time attribute is associated with.
TimeRecordEventAttributeId [KEY] Long Unique identifier for the time record event attribute.
TimeRecordEventId Long Unique identifier for the time record event.
AttributeValue String Value of the attribute to import with the time record event, such as Regular or Overtime.
ChangeReason String Reason for the change associated with the time record event attribute for audit purposes, such as missing time entry or incorrect time entry. The valid values are defined in the lookup HcmLookupPVO1. These lookup codes are added by the customer.
AttributeName String Name of the attribute to import with the time record event, such as Payroll Time Type. Valid values are defined in the lookup TimeAttibuteFieldPVO1.

Pseudo-Columns

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

Name Type Description
Finder String finder
TimeRecordEventRequestId Long timeRecordEventRequestId

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