Saint Edwards — Integrations¶
Integration Overview¶
| # | External System | Direction | Type | Status |
|---|---|---|---|---|
| INT-001 | SIS (Student Information System) | Inbound | Direct integration | Active |
| INT-002 | eway (credit card) | Outbound | API | Active |
| INT-003 | Bank (direct debit / ABA) | Outbound | File (ABA) | Active |
INT-001: SIS Integration¶
Purpose¶
Imports debtor (family) and student records into NetSuite to support the automated billing configurator.
Technical Details¶
- Protocol: Direct integration
- Direction: SIS → NetSuite
- Data: Debtors, students, year levels, student type flags (staff children, boarding, etc.)
- Frequency: Per billing cycle (or as needed)
Notes¶
The SIS integration is reliable and supports the automated configurator. Student data is used directly in Step 2 (verify families) and Step 3 (verify students) of the configurator.
INT-002: eway (Credit Card Processing)¶
Purpose¶
Processes credit card payments from parents as part of the daily RPS run.
Technical Details¶
- Protocol: API (eway payment gateway)
- Direction: NetSuite → eway
- Trigger: Daily scheduled script, per RPS processing date
- Response: Authorization code —
00= approved; other codes = declined - Data: Card details (stored encrypted), payment amount, reference
Flow¶
- Daily script picks up all credit card RPS records with today's processing date
- Submits payment request to eway API
- Receives authorization response
- On success: creates payment record in NetSuite, applies to invoice
- On failure: stores decline code on RPS record for school follow-up
INT-003: Bank — Direct Debit (ABA File)¶
Purpose¶
Processes direct debit payments from parents via ABA file upload to the school's bank portal.
Technical Details¶
- Protocol: File-based (ABA format)
- Direction: NetSuite → ABA file → Bank portal
- Trigger: Daily scheduled script, per RPS processing date
- Format: Australian Bankers' Association (ABA) fixed-width file
Flow¶
- Daily script generates ABA file containing all direct debit RPS records for today
- School downloads file from NetSuite
- School uploads file to bank portal
- Bank processes direct debits (typically overnight)
- School downloads bank report and applies deposit in NetSuite
- Payments move from Undeposited Funds to bank account
Authentication¶
| Method | Used For | Notes |
|---|---|---|
| OTP (One-Time Password) | Parent payment suitelet | Unique URL per family (debtor code + transaction ID); OTP verification on access |