ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

LearnerLearningRecordsselectedCourseOfferingsofferingPrimaryClassroom

LearnerLearningRecordsselectedCourseOfferingsofferingPrimaryClassroom

Columns

Name Type Description
LearnerLearningRecordsassignmentRecordId [KEY] Long LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordsselectedCourseOfferingsofferingPrimaryClassroom
SelectedcourseofferingsassignmentRecordId [KEY] Long SelectedcourseofferingsassignmentRecordId of LearnerLearningRecordsselectedCourseOfferingsofferingPrimaryClassroom
ClassroomId [KEY] Long System-generated primary key for the primary classroom.
ClassroomNumber String User-friendly number for identifying the primary classroom.
ClassroomTitle String Name of the primary classroom.
ClassroomDescription String Description of the primary classroom.
LocationName String Location name of the primary classroom.
LocationAddressLine1 String Location address line 1.
LocationAddressLine2 String Location address line 2.
LocationAddressLine3 String Location address line 3.
LocationCity String City of the primary classroom.
LocationCountry String Country of the primary classroom.
LocationZipCode String Postal code of the primary classroom.
LocationLongitude Double Longitude of the primary classroom.
LocationLatitude Double Latitude of the primary classroom.
LocationDisplayString String Complete classroom address in string format.
LocationSingleLineString String Location of the classroom expressed as a single line string.
ContactPersonId Long Classroom contact person identifier.
ContactPersonNumber String Identifier of the person number who's the classroom contact.
ContactPersonDisplayName String Display name for the person who's the classroom contact.
ContactPersonPrimaryEmailAddress String Primary email address of the classroom contact person.
ContactPersonPrimaryPhoneNumber String Primary phone number for the person who's the classroom contact.
ContactPersonImageURL String Image URL for the person who's the classroom contact.

Pseudo-Columns

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

Name Type Description
SysEffectiveDate String SysEffectiveDate
AssignedToId Long assignedToId
AssignerAttributionType String assignerAttributionType
AssignerId Long assignerId
AssignmentRecordId Long assignmentRecordId
DataSecurityPrivilege String dataSecurityPrivilege
Finder String finder
LearnerId Long learnerId
LearningItemId Long learningItemId
LearningItemTitle String learningItemTitle
ManagerId Long managerId

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