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.
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:
|
|
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 |