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 |