Student Information System - Database - Finances
Overview and Prerequisites
Prior to reviewing this page, please review the Generic Student Information System Integration Directory page, including prerequisites found here.
In addition, the following prerequisites are set for the specific finances integration:
Database View Prerequisites | Additional Information |
---|---|
The database view must include the following columns:
|
Additional fields could be used for display purposes (description, comments, etc.) |
User Experience
The grades services allows student to view their final grades by semester.
Property | Static Tile |
---|---|
Default Size | 1x1 |
Minimum Size | 1x1 |
Suggested Design |
Screenshots
Sample Requests
Sample Query |
---|
SELECT DISTINCT TERM_ID, TERM_NAME, PAYMENT_TYPE, STATUS, DATE, AMOUNT FROM USER_FINANCES WHERE USER_ID={userId} |
Sample Response | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Offline Functionality
Not supported.
Configuration Options
Configuration Item | Options | Default Value |
---|---|---|
Details Display | By default campusM presents the following information: payment type, status, amount, date. Additional provides fields, such as refund, can be presented | |
Default Screen |
|
Terms list |
Labels
Label | Default Value |
---|---|
Tile name on home screen | Finances |
Page title | Finances |
Link to terms | Terms |
Suggested Testing Guidelines
The following acceptance criteria is recommend to be used as part of the testing and approval process:
- User can access the Finances tile
- User can select the terms
- User can view the list of their payments with relevant information