Report ID | Title | Description | Columns Included | Records Included | Developer | Requestor | Comments | Shared with | Technical Specifications |
---|
CU_BAR_SF_00001 | Item Type Table Detail | This is a dump of the Item Type Table. Prompt on SetID. | SetID, Item Type, Eff Date, Status, Descr, Short Desc, Currency, Min Amt, Max Amt, Item Code, Sec Grp, Adj Cal, Pay Terms, Pay Prior., Charge Lst, Encumber, Encmbr Pct, State, Specific, Category, All/None, Enrolled, Key Word, Key Word 2, Key Word 3, Days, Days, Days Past, Days Until, Enroll Req, Refund Ind, Earn Code, Taxable, Tuit Dep, Required, Default Amt, Earnings, Recv. from Chrg, Priority, Pmt. Priority, NRA Tax Pay FLG, NRA Tax Type, Match Charges, Local Offset, Local Payment, State Offset, State Payment, Course Class, Code, T4A Eligible, WageLossPl, T2202A Eligible, T2202A Percent, T2202A Offset, Pmt Overall Pri, Control, Acctg Dt ID, 1098-T Eligible, DEST Tuit Type, Award Type, Source, Program Code, Global Invoice | | Michael McGovern | | New report | C Keck, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00002 | Students w/Account Balances | This query pulls all students who owe money for the term - account balance, minus anticipated aid. Prompt on Business Unit and Term. | | | Michael McGovern | Dorothy Himes | New report | D Himes, S Ho, C Keck, A Kamruzzaman, P. Sunda, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00003 | Voided Transactions | This is a list of voided transactions for a certain date. Prompt on the Business Unit and Transaction Date. | | | Michael McGovern | Dorothy Himes | New report | D Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00004 | Revenue | This query totals item types by term. Prompt on Business and Account Term. | | | Michael McGovern | Maple Liu | New report | C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00005 | Revenue Detail | This query totals item types by Career, Program, Residency, Full/Part-time and Term. It also counts credits and the number of students per category. Prompt on Business and Account Term. | | | Michael McGovern | Maple Liu | New report | C Keck, A Kamruzzaman, A. Cox, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00006_1 | Item Type Totals | This is a list of item types for a term with the totals for charged and applid amounts and the difference. Prompt on Institution, Term and Item Type (optional). | | | Michael McGoverm | Dorothy Himes | New report | D Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00007 | Student Account Detail | This is a detail of the student's account activity for a term. Prompt on Institution, Term, and Emplid (optional). | | | Michael McGovern | Dorothy Himes | New report | D Himes, S Ho, C Keck, A Kamruzzaman, P. Sunda, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00008 | Acct Bals & Service Indicators | This report lists students with the prompted service indicator and their account balances. Prompt on Institution, Service Indicator and Reason Code (optional). | | | Michael McGovern | Dorothy Himes | New report | D Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00009 | Exec Program Detail | This is a list of student data and charges for those students in an executive program. Prompt on Institution, Career, Term and Student Group. | | | Michael McGovern | Vijay Sood | New report | P Sunda, C Keck, A Kamruzzaman, P. Sunda, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00010C | Charges and Related Payments | This query pulls all charges for a prompted iterm type and all related payments within a promted date range. Prompt on Institution, Term, Item Type, Date range and Emplid (optional). | | | Michael McGovern | Sandy Ho | New report | D Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00010P | Payments and Related Charges | This query pulls all payments for a prompted iterm type and all related charges within a promted date range. Prompt on Institution, Term, Item Type, Date range and Emplid (optional). | | | Michael McGovern | Sandy Ho | New report | D Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman | |
CU_BAR_SF_00011 | Student Acct Dtl by Item Type | This is a listing of all students who have had account activity for a prompted item type by term. Prompt on Institution, Term and Item Type. | | | Michael McGovern | Dorothy Himes | New report | D Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman | |