Cmc.Nexus.Sis.StudentAccounts

The following table shows the mapping of classes and properties in the Cmc.Nexus.Sis.StudentAccounts entity to tables and fields in the Anthology Student database.

Cmc.Nexus.Sis.StudentAccounts Mapping
Anthology Class Anthology Property Anthology Student Table.Field Name Comments
AccountChargeTransaction  
  ChargeCodeId SaTrans.SaBillCode Contract property is Id; however, billcode in SaTrans is char. So, Id is retrieved from SaBillCode.
InvoiceNumber SaTrans.Ref  
AccountSummary  
  AccountBalance AdEnroll.ArBalance  
  AccountStatuses Collection of AccountStatusDetail Multiple Account Statuses are allowed. Currently, in Anthology Student each different account status specified for an enrollment is an instance in SaEnrollAcctStatus.
  BillingMethodId AdEnroll.SabillingMethodId  
  BusinessUnitId N/A  
  Id AdEnroll.AdEnrollId  
  PersonId SyStudent.SyStudentId (CONVERTED)
  StudentEnrollmentPeriodId AdEnroll.AdEnrollId  
AccountTransaction  
  AddUserId SaTrans.AddUserId  
  AccountChargeTransaction - Derived Type See AccountChargeTransaction class.  
  AccountPaymentTransaction - Derived Type See AccountPaymentTransaction class.  
  Amount SaTrans.Amount  
  BillingPeriodId SaTrans.AdtermId  
  BusinessUnitId SaTrans.SyCampusId  
  Description SaTrans.Descrip  
  Id SaTrans.SaTransId  
  PersonId SaTrans.SyStudentId (CONVERTED)
  PostDate SaTrans.PostDate  
  ProspectId SaTrans.SyStudentId  
  Reference SaTrans.Ref  
  StudentBillingPeriodId SaTrans.FaPmtPeriodId  
  StudentEnrollmentPeriodId SaTrans.AdEnrollId  
  TransactionDate SaTrans.Date  
  TransactionType SaTrans.Type  
AccountPaymentTransaction  
  CheckNumber SaTrans.CheckNo  
ReceiptNumber SaTrans.ReceiptNo  
AccountStatusDetail  
  AccountStatusId SaCollectionAccountStatus.
SaAcctStatusID
For a CollectionAccount event, the fields listed in the column to the left are returned .

For an AccountSummary event, the following fields are returned:

  • SaEnrollAcctStatus.SaAcctStatusID
  • SaEnrollAcctStatus.SaEnrollAcctStatusID

Id SaCollectionAccountStatus.
SaCollectionAccountStatusID
CollectionAccount  
  AccountStatuses Collection of AccountStatusDetail Multiple Account Statuses are allowed. Currently, in Anthology Student each different account status specified for a collection account is an instance in SaCollectionAccountStatus.
  BlockStatement SaCollections.BlockStatement  
  DunningProcessOff SaCollections.DunningProcessoff  
  Id SaCollections.SaCollectionsId  
  LastStatementAmount SaCollections.StatementAmount  
  LastStatementDate SaCollections.StatementDate  
  PaymentPlanSummaryId SaCollections.FaStudentAidId  
  PersonId SaCollections.SyStudentId (CONVERTED)
  ProspectId SaCollections.SyStudentId  
  ReadyForCollectionDate SaCollections.ReadyForCollectionDate  
  StatementNote SaCollections.StatementMemo  
  StudentEnrollmentPeriodI SaCollections.AdEnrollId  
StudentPaymentPlan  
  FirstPaymentDate FaStudentAid.FirstPayDate  
  FundSourceId FaStudentAid.FaFundSourceId  
  Id FaStudentAid.FaStudentAidId  
  InterestOnlyUntilDate FaStudentAid.IntOnlyuntilDate  
  InterestRate FaStudentAid.InterestRate  
  Note FaStudentAid.Comment  
  NumberOfPayments FaStudentAid.NumberPayments  
  PaidPayments Collection of StudentPaymentPlanPayment This entity collection is not mapped in Saved or Saving events.
  PaymentAmount FaStudentAid.PaymentAmount  
  PaymentFrequency N/A This appears to just be a field on the UI in Anthology Student and is not persisted in the database.
  PaymentFrequencyDays FaStudentAid.PaymentFreq  
  PrincipalAmount FaStudentAid.PrincipalBalance  
  Refunds Collection of Refund (see Cmc.Nexus.Sis.FinancialAid) This entity collection is not mapped in Saved or Saving events.
  ScheduledPayments Collection of StudentPaymentPlanScheduledPayment  
  SecondaryInterestRate FaStudentAid.SecondaryInterestRate  
  SecondaryInterestRateEffectiveDate FaStudentAid.
SecondaryInterestRateEffDate
 
  StatementAddressId FaStudentAid.SyAddressId  
  Status FaStudentAid.Status  
  StudentAcademicYearId FaStudentAid.FaStudentAyId  
StudentPaymentPlanPayment  
  InterestAmount FaDisb.InterestAmount  
PrincipalAmount FaDisb.ActualAmount – FaDisb.InterestAmount Field for PrincipalAmount does not exist in FaDisb schema. Amount is calculated by subtracting InterestAmount from ActualAmount.
StudentPaymentPlanScheduledPayment  
  InterestAmount FaSched.InterestAmount  
PrincipalAmount FaSched.PrincipalAmount  
StudentPaymentPlanStatement  
  AmountDue SaStatementHistory.StatementAmtDue  
  AmountPastDue N/A  
  ClosingDate SaStatementHistory.ClosingDate  
  GeneratedDate SaStatementHistory.DatePrinted  
  Id SaStatementHistory.SaStatementHistoryId  
  StudentPaymentPlanId SaStatementHistory.FaStudentAidId