ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

ElementEntrieselementEntryValues

ElementEntrieselementEntryValues

Columns

Name Type Description
ElementEntriesEffectiveEndDate [KEY] Date ElementEntriesEffectiveEndDate of ElementEntrieselementEntryValues
ElementEntriesEffectiveStartDate [KEY] Date ElementEntriesEffectiveStartDate of ElementEntrieselementEntryValues
ElementEntriesElementEntryId [KEY] Long ElementEntriesElementEntryId of ElementEntrieselementEntryValues
ScreenEntryValue String Entry for input values available for each entry of the element.
ElementEntryValueId [KEY] Long System-generated unique identifier for an element entry value.
InputValueId Long System-generated unique identifier for an input value.
InputValueName String Name of the element entry???s input value.
MandatoryFlag Bool MandatoryFlag of ElementEntrieselementEntryValues
DisplaySequence Int DisplaySequence of ElementEntrieselementEntryValues
HotDefaultFlag Bool HotDefaultFlag of ElementEntrieselementEntryValues
DefaultValue String DefaultValue of ElementEntrieselementEntryValues
UOM String UOM of ElementEntrieselementEntryValues
UserEnterableFlag Bool UserEnterableFlag of ElementEntrieselementEntryValues
ScreenEntryDataURL String ScreenEntryDataURL of ElementEntrieselementEntryValues
LovScreenEntryValue String Values contained within a list of values.

Pseudo-Columns

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

Name Type Description
AssignmentNumber String AssignmentNumber
EffectiveEndDate Date EffectiveEndDate
EffectiveStartDate Date EffectiveStartDate
ElementEntryId Long ElementEntryId
Intent String Intent
SysEffectiveDate String SysEffectiveDate
Finder String finder

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