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