LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory
LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| OtherselectedcourseofferingsassignmentRecordId [KEY] | Long | OtherselectedcourseofferingsassignmentRecordId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionId [KEY] | Long | TransactionId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionNumber | String | TransactionNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionDate | Datetime | TransactionDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionType | String | TransactionType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionTypeMeaning | String | TransactionTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionAmount | String | TransactionAmount of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionCurrency | String | TransactionCurrency of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionReason | String | TransactionReason of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionReasonMeaning | String | TransactionReasonMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
| TransactionComments | String | TransactionComments of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingstransactionHistory |
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 |