LearnerLearningRecordscompletionDetailsclassrooms
LearnerLearningRecordscompletionDetailsclassrooms
Columns
Name | Type | Description |
LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsclassrooms |
CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsclassrooms |
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
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 |