| Table of Contents | ||||
|---|---|---|---|---|
|
...
1. Eraser - Hover your curser over the filter until you see the eraser. Click the eraser to remove clear the individual filter.
2. Reset Data - Next to the information button on the right end of the header bar, click the return arrow to clear all report filters and reset data to defaultits original state. Note that some filters are included in the default report data.
...
Note: Do not use both filter options at the same time. Using filters from the header and the filters menu at the same time may lead to unexpected data results.
| Note |
|---|
Caution: The data points on the menu are separated into 3 lists:
Once you are done viewing data with filters, it is good practice to clear all data filters by clicking the Reset Data (arrow at the top of the report header bar) to return data to its original state. |
...
IAC_PNDAPV - Pending Approval, displays commitments that require approval based on the type of commitment entry: A=Add, C=Change
IAC_STATCD - Commitment Status, displays select either Current /(most recent sequence of the commitment) or the Historical/all sequences to view all of the changes made to Historical (the original commitment and all edited commitments before the current): C=Current (default), H=Historical.
...
To download a report, click on the report name and you will see the ellipsis (3 dots) to the right of the report header. Click the 3 dots ellipsis and select the Export data option.
...
To work with the data in Excel, you must first click the Enable Editing button. Also, note the Applied filters in the first row. These are the filters that were applied to the data in the downloaded report. This can greatly affect your data analysis. If this is not what was expected, click the Data Reset in GradPoint and download the report again.
Comparing Committed / Awarded / Paid Amounts
...
...
To get the total of funding details amount that have has not been paid out to students in an AidID (e.g. Block Grant):
Filter the commitments so that only one AidID is displaying by selecting one AidID in the column ‘Pro_IAC’, column J.
Hover your curser over the header of column N, Committed. Using the Commitment Details report, select only one AIDID before download the report.
Download report and click the Enable Editing button.
Click to highlight the “Committed” column (column N). The sum of the column will display at the bottom of the spreadsheet.
Repeat this step 3 for “Awarded” (column O, Awarded), and “Paid” (column P, Paid ) to get the the sum for of each.
You can use the report to check if a student’s student was paid amount is less than the what you committed amount to them by comparing amounts in column N, Committed, and column P, Paidthe student’s committed / awarded / paid amounts. Possible reasons for this are:
Graduate student must be registered in 8+ units, in good standing to be eligible for campus funding.
Fees may have been paid by another commitment, to the maximum of the fee assessed.
The commitment was awarded but not yet disbursed since the disbursement date for the commitment has not yet passed. Consult the Graduate Division Annual Support Calendar for disbursement dates.