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