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