LearnerLearningRecordscompletionDetailsselectedCourseOfferingsuserActionHints
LearnerLearningRecordscompletionDetailsselectedCourseOfferingsuserActionHints
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingsuserActionHints |
| CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingsuserActionHints |
| SelectedcourseofferingsassignmentRecordId [KEY] | Long | SelectedcourseofferingsassignmentRecordId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingsuserActionHints |
| InitialLearningRecordStatusHintESS | String | Hint for the initial learning record status for learner self-service assignments. |
| InitialLearningRecordSubStatusHintESS | String | Hint for the initial learning record substatus for manager self-service assignments. |
| ShowEnrollmentFormESS | String | Hint to show the learning record request form for learner self-service assignments. |
| InitialLearningRecordStatusHintMSS | String | Hint for the initial learning record status for manager self-service assignments. |
| ShowEnrollmentFormMSS | String | Hint to show learning record request form for manager self-service assignments. |
| PaymentTypesAccepted | String | Payment types accepted for the learning record, such as manual payment, online payment, or no payment. Valid values are defined in the PaymentTypesAcceptedLOV. |
| PendingPrereqTimeoutInDaysESS | Double | Hint for the number of days a learner has to complete prerequisites before they're withdrawn for learner self-service. |
| PendingPrereqTimeoutInDaysMSS | Double | Hint for the number of days a learner has to complete prerequisites before they're withdrawn for manager self-service. |
| ViewModeESS | String | Hint for the view mode for learner self-service. Valid values are defined in the ViewModeESSLOV. |
| EnrollmentQuestionnaireIdESS | Long | Unique identifier for the enrollment questionnaire for learner self-service assignments. |
| EnrollmentQuestionnaireNumberESS | String | User-friendly number for identifying the enrollment questionnaire for learner self-service assignments. |
| EnrollmentQuestionnaireIdMSS | Long | Unique identifier for the enrollment questionnaire for manager self-service assignments. |
| EnrollmentQuestionnaireNumberMSS | String | User-friendly number for identifying the enrollment questionnaire for manager self-service assignments. |
| IsSelfServiceUserForumEnabled | String | Hint to identify whether the self-service user forum is enabled for the learning item. |
| IsEnrolleeForumEnabled | String | Hint to identify whether the enrollee forum is enabled for the learning item. |
| DataSecurityPrivilege | String | Data security privilege for the user accessing the learning assignment, such as Learner or Learner Manager. Valid values are defined in the DataSecurityPrivilegeLOV. |
| CanEditAssignmentHint | String | Hint to identify whether a user can edit the assignment. Examples include Can delete, Can withdraw, and No edit. Valid values are defined in the CanEditAssignmentHintLOV. |
| CanManageLearningItem | String | Hint to identify whether a user can manage the learning item. |
| RefundRuleForILTActivity | String | Hint for a refund rule for the instructor-led activity. |
| RefundRuleForSPActivity | String | Hint for a refund rule for the self-paced activity. |
| InitialLearningRecordStatusHintESSMeaning | String | Description of the value of the initialLearningRecordStatusHintESS attribute. |
| InitialLearningRecordSubStatusHintESSMeaning | String | Description of the value of the initialLearningRecordSubStatusHintESS attribute. |
| ShowEnrollmentFormESSMeaning | String | Description of the value of the showEnrollmentFormESS attribute. |
| InitialLearningRecordStatusHintMSSMeaning | String | Description of the value of the initialLearningRecordStatusHintMSS attribute. |
| ShowEnrollmentFormMSSMeaning | String | Description of the value of the showEnrollmentFormMSS attribute. |
| PaymentTypesAcceptedMeaning | String | Description of the value of the paymentTypesAccepted attribute. |
| ViewModeESSMeaning | String | Description of the value of the viewModeESS attribute. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SysEffectiveDate | String | SysEffectiveDate |
| AssignedToId | Long | assignedToId |
| AssignerAttributionType | String | assignerAttributionType |
| AssignerId | Long | assignerId |
| AssignmentRecordId | Long | assignmentRecordId |
| Finder | String | finder |
| LearnerId | Long | learnerId |
| LearningItemId | Long | learningItemId |
| LearningItemTitle | String | learningItemTitle |
| ManagerId | Long | managerId |