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