Cmc.Nexus
The following table shows the mapping of classes and properties in the Cmc.Nexus entity to tables and fields in the Anthology Student database.
Anthology Class | Anthology Property | Anthology Student Table.Field Name | Comments |
---|---|---|---|
AddressBase | |||
AddressTypeId | N/A | This property is required in the contract; however, the current mapping logic ignores the value provided since the only address attributes currently being updated are those on the SyStudent record. | |
City | SyStudent.City, SyStaff.City, SyAddress.City | Depends on if SyStudent, SyStaff, or SyAddress record is in context. | |
CountryId | SyStudent.SyCountryId, SyStaff.SyCountryId, SyAddress.SyCountryId | Depends on if SyStudent, SyStaff, or SyAddress record is in context. | |
CountryName | SyAddress.Country | N/A for SyStudent and SyStaff records | |
CountyId | SyStudent.SyCountyId, SyAddress.SyCountyId | Depends on if SyStudent or SyAddress record is in context. N/A for SyStaff | |
CountyName | SyAddress.County | N/A for SyStudent and SyStaff records | |
DoNotContact | N/A | ||
DoNotContactOverride | N/A | ||
EffectiveBeginDate | SyAddress.BeginDate | N/A for SyStudent and SyStaff records | |
EffectiveEndDate | SyAddress.EndDate | N/A for SyStudent and SyStaff records | |
FirstName | N/A | ||
Id | SyAddress.SyAddressId or NULL | ||
IsNotValid | SyStudent.BadAddr | N/A for SyStaff and SyAddress records | |
IsPreferred | N/A | ||
IsSeasonal | SyAddress.Yearly | N/A for SyStudent and SyStaff records | |
LastName | SyAddress.LastName | N/A for SyStudent and SyStaff records | |
Note | N/A | ||
PhoneNumber | SyStudent.Phone, Systaff.Phone, SyAddress.Phone | Depends on if SyStudent, SyStaff, or SyAddress record is in context. | |
PostalCode | SyStudent.Zip, SyStaff.Zip, SyAddress.Zip | Depends on if SyStudent, SyStaff, or SyAddress record is in context. | |
StateId | N/A | ||
StateName | SyStudent.State, SyStaff.State, SyAddress.State | Depends on if SyStudent, SyStaff, or SyAddress record is in context. | |
StreetAddress | SyStudent.Addr1, SyStaff.Addr1, SyAddress.Addr1 | Depends on if SyStudent, SyStaff, or SyAddress record is in context. | |
TitleId | SyAddress.TitleID | N/A for SyStudent and SyStaff records | |
BusinessUnit | |||
Id | SyCampus.SyCampusId | ||
Ethnicity | |||
Id | SyStudentAmRace.AmRaceId | ||
FunctionalRole | |||
RoleType | N/A | An enum property. 0= Unknown, 1= Prospect, 2=Student, 3=Staff | |
Group | The Group class in Anthology maps to the SyGroups table in Anthology Student. Eventually, the SyStaffGroup and SyEmpGroups tables will also be mapped to this entity. The Anthology domain merges Staff Groups, Student Groups, and Employer Groups into one Group and Group Membership class. This brings consistency to all functionality for the Groups concept in Anthology. Additionally, Groups in Anthology are able to mix membership between Person and Organizations within a single Group. | ||
AdvisorRelationshipTypeId | SyStaffGroup.AdvisorModule | ||
AssociatedBusinessUnits | SyGroups.SyCampusGrpId, SyCampusList.SyCampusId | ||
Code | SyGroups.Code | ||
ExpirationDate | SyGroups.DateExpires | ||
Id | SyGroups.SyGroupsId | Mapping occurs between Anthology Student and Anthology: For Student Group: GroupId = (SyGroupsId * 10 ) + 1 |
|
IsActive | SyGroups.Active | ||
IsPublic | SyGroups.PublicGroup | ||
IsStaffGroup | N/A or True if mapping from Staffgroup | No mapping as all Staff Groups in Anthology Student are stored in SyStaffGroup; however, the value in this Anthology property determines which table gets updated in Anthology Student. If this is True, then SyStaffGroup is updated. | |
IsSystem | N/A | ||
MembershipFunctionalRoles | N/A | No mapping. Anthology Group entity allows membership in a group from different entities. | |
Name | SyGroups.Descrip | ||
OwnerUserId | SyGroups.SyStaffId | ||
StaffGroupBusinessUnitId | N/A | No mapping. Method for determining which Business units (Campuses in Anthology Student) a given staff user is associated with is implemented differently in Anthology than in Anthology Student. | |
StaffGroupType | N/A | ||
Usage | N/A | ||
GroupMembership | |||
AddedDate | SyStudGrp.DateAdded | ||
AddedUserId | StudGrp.UserIdOn | ||
GroupId | SyGroups.SyGroupsId | Mapping occurs between Anthology Student and Anthology: For Student Group: GroupId = (SyGroupsId * 10 ) + 1 |
|
Id | SyStudGrp.SyStudGrpId | ||
IsActive | SyStudGrp.Active | ||
OrganizationId | N/A | ||
PersonId | SyStudGrp.SyStudentId (CONVERTED) | ||
RemovedDate | SyStudGrp.DateOff | ||
RemovedUserId | SyStudGrp.UserIdOff | ||
Nationality | |||
Id | SyStudent.AmNationalityId | ||
Organization | No mapping is currently done for this class. | ||
Addresses | N/A | ||
DateCreated | N/A | ||
Id | N/A | ||
Name | N/A | ||
Note | N/A | ||
OrganizationContacts | N/A | ||
OrganizationUrl | N/A | ||
OwnerId | N/A | ||
Phones | N/A | ||
PrimaryContactId | N/A | ||
SicCode | N/A | ||
Person | |||
Addresses | Collection of PersonAddress | ||
BirthCountryId | N/A | ||
BirthDate | SyStudent.Dob | ||
Cases | N/A | ||
Emails | Collection of PersonEmail | ||
Ethnicities | Collection of PersonEthnicity | ||
FirstName | SyStudent.FirstName, SyStaff.FirstName | Depends on if SyStudent or SyStaff record is in context. | |
FunctionalRoles | See FunctionalRole | Students, Prospects are added when mapping from SyStudent. | |
GenderId | SyStudent.AmSexId | ||
HasDisability | SyStudent.Disabled | ||
Id | SyStudent.SyStudentId (CONVERTED), SyStaff.SyStaffId (CONVERTED) | ||
Interactions | Collection of Interaction (see Interaction class in CMC.Nexus.Crm) | ||
Interests | N/A | ||
LastContactDate | SyStudent.LastActivityDate | ||
LastName | SyStudent.LastName, SyStaff.LastName | Depends on if SyStudent or SyStaff record is in context. | |
MaidenName | SyStudent.MaidenName | ||
MaritalStatusId | SyStudent.AmMaritalId | ||
MiddleName | SyStudent.MiddleName | ||
Name | N/A | ||
Nationalities | Collection of Nationality where Id field maps to SyStudent.AmNationalityId. | Contract supports multiple values; however, only the first value provided is updated to SyStudent.AmNationalityId. | |
NickName | SyStudent.NickName | ||
Phones | Collection of PhoneBase | ||
PreferredLanguageId | N/A | ||
Prospects | Read-only collection of Prospect | This is a read-only collection. No data provided in this collection will be persisted to the Anthology Student database. See Prospect class in CMC.Nexus.SIS.Admissions for additional information. | |
Salutations | N/A | ||
Ssn | SyStudent.Ssn | ||
Students | Read-only collection of Student | This is a read-only collection. No data provided in this collection will be persisted to the Anthology Student database. See Student class in CMC.Nexus.SIS for additional information. | |
SuffixId | SyStudent.AmSuffixId | Not mapped in Saved events. | |
TitleId | SyStudent.AmTitleId | ||
Veteran | SyStudent.Vet | ||
PersonAddress | Inherits from AddressBase. | ||
PersonDocument | |||
ApprovalDate | CmDocument.DateApproved | ||
AwardYear | CmDocument.AwardYear | ||
CreatedbyUserId | CmDocument.AddUserId | Documents added via automated Document Scheduler processes may not contain a value for this field. | |
DocumentCategoryId | CmDocument.SyModuleId | ||
DocumentStatusId | CmDocument.CmDocStatusId | ||
DocumentTypeId | CmDocument.CmDocTypeId | ||
DueDate | CmDocument.DateDue | ||
ExpirationDate | CmDocument.DateExpires | ||
Id | CmDocument.CmDocumentId | ||
ModifiedByUserID | CmDocument.UserId | Documents added via automated Document Scheduler processes may not contain a value for this field. | |
Note | CmDocument.Comments | ||
PersonId | CmDocument.SyStudentId (CONVERTED) | ||
ProspectId | CmDocument.SyStudentId | ||
ReceivedDate | CmDocument.DateRecv | ||
RequestDate | CmDocument.DateReq | ||
SentDate | CmDocument.DateSent | ||
StudentId | CmDocument.SyStudentId | StudentId and ProspectId are purposely both mapped to CmDocument.SyStudentId | |
WorkflowInstanceId | CmDocument.WorkflowInstanceId | ||
PersonEmail | |||
DisplayName | N/A | ||
EmailAddress | SyStudent.Email, SyStaff.Email, SyStaff.Email_ReplyTo | Depends on if SyStudent or SyStaff record is in context. | |
EmailTypeId | If SyStaff.Email, set to "1". If SyStaff.Email_ReplyTo, set to "2". | EmailType is enum for now: 1 = PRIMARY, 2 = SECONDARY | |
PersonEthnicity | |||
Ethnicities | Collection of Ethnicity where Id field maps to SyStudentAmRace.AmRaceId. | Multiple values for Ethnicity can be provided. | |
IsHispanicLatino | SyStudent.IsHispanic | ||
PersonId | SyStudentAmRace.SyStudentId (CONVERTED) | ||
PersonPhone | Inherits from PhoneBase | ||
PhoneBase | |||
DoNotContact | N/A | ||
DoNotContactOverride | N/A | ||
Extension | N/A | There is an Ext for Work phone, but not Phone in SyStudent. | |
IsNotValid | SyStudent.Badphone | ||
IsPreferred | N/A | ||
PhoneNumber | SyStudent.Phone, SyStaff.Phone, SyStaff.WorkFaxPhone, SyStaff.WorkPhone, SyStaff.HomePhone | Depends on if SyStudent or SyStaff record is in context. | |
PhoneTypeId | If SyStaff.Phone, set to "1". If SyStaff.WorkFaxPhone, set to "2". If SyStaff.CellPhone, set to "3". If SyStaff.HomePhone, set to "4" | PhoneType is enum for now: 1=HOME, 2=WORK, 3=MOBILE, 4=OTHER |