ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies

LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies

Columns

Name Type Description
LearnerLearningRecordsassignmentRecordId [KEY] Long LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
SelectedcourseofferingsassignmentRecordId [KEY] Long SelectedcourseofferingsassignmentRecordId of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
ActivelearnercommentscommentId [KEY] Long ActivelearnercommentscommentId of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
ByPersonId Long ByPersonId of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
ByPersonNumber String ByPersonNumber of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
ByPersonDisplayName String ByPersonDisplayName of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
ByPersonImageURL String ByPersonImageURL of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
CommentDate Datetime CommentDate of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
Comment String Reply comment of the learner on a comment.
LikeCount Int LikeCount of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
ReplyStatus String Status of the reply on a comment. Valid values are defined in the list ReplyStatusLOV.
ReplyStatusMeaning String ReplyStatusMeaning of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
CommentId [KEY] Long CommentId of LearnerLearningRecordsselectedCourseOfferingsactiveLearnerCommentsreplies
DataSecurityPrivilege String Data security privilege, such as Learner or Learner Manager, is the intent of the user accessing the learning assignment. Valid values are defined in the list DataSecurityPrivilegeLOV.

Pseudo-Columns

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

Name Type Description
SysEffectiveDate String SysEffectiveDate
AssignedToId Long assignedToId
AssignerAttributionType String assignerAttributionType
AssignerId Long assignerId
AssignmentRecordId Long assignmentRecordId
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