| 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. | Last Name, First Name, Middle Name, Empl ID, Phone, Email, Balance, Anticipated Aid, Net Difference | 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. | Name, Cashier, Register, Void Code, Receipt #, Curr Date, Total, Appr Stat | 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. | Acct Term, Item Type, Description, Key Word, Total Amount | 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. | Career, Prim Prog, Resident?, Full/Part, Item Type, Description, Key Word, Student Count, Credits, Total Amount | 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). | Session, Item Type, Acct Type, Item Code, Descr, Key Word, Acct Nbr, Item Type Total, Applied Total, Difference | 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). | Last Name, First Name, Middle Name, Empl ID, Item Type, Item Description, Item Amt, Applied, Balance | 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). | Last Name, First Name, Middle Name, Empl ID, Service Indicator, Reason Code, Active Term, Active Dt, Balance | 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. | Empl ID, Last Name, First Name, Middle Name, Program, Plan, Preferred Email, Preferred Phone, Sex, Country, Mail Address 1, Mail Address 2, City, State, Postal, Status, Admit Term, Take Prgrs, Total, GPA, Strt Level, Subject, Catalog, Session, Section, Descr, Unit Taken, Grade, Item Type, Item Amt, Applied, Descr | 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). | Last Name, First Name, Middle Name, Empl ID, Charge Item Type, Charge Description, Charge Amount, Effective Date, Payment Item Type, Payment Description, Payment Amount | 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). | Last Name, First Name, Middle Name, Empl ID, Payment Item Type, Payment Description, Payment Amount, Effective Date, Charge Item Type, Charge Description, Charge Amount | 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. | Last Name, First Name, Middle Name, Empl ID, Item Type, Item Description, Last Activ, Item Amt, Applied, Difference | Michael McGovern | Dorothy Himes | New report | D Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman |
Page History
Overview
Content Tools