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.

Cmc.Nexus Mapping
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