LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsclassrooms
LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsclassrooms
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsclassrooms |
| PrimaryselectedcourseofferingassignmentRecordId [KEY] | Long | PrimaryselectedcourseofferingassignmentRecordId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsclassrooms |
| CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsclassrooms |
| ClassroomId [KEY] | Long | System-generated primary key for a classroom. |
| ClassroomNumber | String | User-friendly number for identifying a classroom. |
| ClassroomTitle | String | Name of the classroom. |
| ClassroomDescription | String | Description of the classroom. |
| IsPrimaryClassroom | String | Indicates whether the classroom is a primary classroom. The default value is N. Valid values are Y and N. |
| LocationName | String | Location of the classroom. |
| LocationAddressLine1 | String | Location address line 1. |
| LocationAddressLine2 | String | Location address line 2. |
| LocationAddressLine3 | String | Location address line 3. |
| LocationCity | String | City of the classroom. |
| LocationCountry | String | Country of the classroom. |
| LocationZipCode | String | Postal code of the classroom. |
| LocationLongitude | Double | Longitude of the classroom. |
| LocationLatitude | Double | Latitude of the classroom. |
| LocationDisplayString | String | Complete classroom address in the string format. |
| LocationSingleLineString | String | Location of the classroom expressed as a single line string. |
| ContactPersonId | Long | Identifier for the person who's the classroom contact. |
| ContactPersonNumber | String | Person number for the classroom contact person. |
| ContactPersonDisplayName | String | Display name for the person who's the classroom contact. |
| ContactPersonPrimaryEmailAddress | String | Primary email address of the person who's the classroom contact. |
| ContactPersonPrimaryPhoneNumber | String | Primary phone number for the person who's the classroom contact. |
| ContactPersonImageURL | String | Image URL for the person who's the classroom contact. |
| IsPrimaryClassroomMeaning | String | Description of the value of the isPrimaryClassroom attribute. |
| Attachments | String | attachments |
| ClassroomDFFs | String | classroomDFFs |
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 |