You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 28 Next »

Report IDTitleDescriptionColumns IncludedRecords IncludedDeveloperRequestorCommentsShared withTechnical Specifications
CU_BAR_SF_00001Item Type Table DetailThis 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_00002Students w/Account BalancesThis query pulls all students who owe money for the term - account balance, minus anticipated aid.  Prompt on Business Unit and Term.  Michael McGovernDorothy HimesNew report D Himes, S Ho, C Keck, A Kamruzzaman, P. Sunda, T.Lodhi, P.Ackerman  
CU_BAR_SF_00003Voided TransactionsThis is a list of voided transactions for a certain date.  Prompt on the Business Unit and Transaction Date.  Michael McGovernDorothy HimesNew report D Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman 
CU_BAR_SF_00004RevenueThis query totals item types by term.  Prompt on Business and Account Term.  Michael McGovernMaple Liu New reportC Keck, A Kamruzzaman, T.Lodhi, P.Ackerman 
CU_BAR_SF_00005Revenue DetailThis 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 McGovernMaple LiuNew reportC Keck, A Kamruzzaman, A. Cox, T.Lodhi, P.Ackerman 
 CU_BAR_SF_00006_1Item 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 reportD Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman  
CU_BAR_SF_00007Student Account DetailThis is a detail of the student's account activity for a term.  Prompt on Institution, Term, and Emplid (optional).  Michael McGovernDorothy HimesNew reportD Himes, S Ho, C Keck, A Kamruzzaman, P. Sunda, T.Lodhi, P.Ackerman 
CU_BAR_SF_00008Acct Bals & Service IndicatorsThis report lists students with the prompted service indicator and their account balances.  Prompt on Institution, Service Indicator and Reason Code (optional).  Michael McGovernDorothy HimesNew reportD Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman 
CU_BAR_SF_00009Exec Program DetailThis is a list of student data and charges for those students in an executive program.  Prompt on Institution, Career, Term and Student Group.  Michael McGovernVijay SoodNew report P Sunda, C Keck, A Kamruzzaman, P. Sunda, T.Lodhi, P.Ackerman 
CU_BAR_SF_00010CCharges and Related PaymentsThis 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 McGovernSandy HoNew reportD Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman 
CU_BAR_SF_00010PPayments and Related ChargesThis 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 McGovernSandy HoNew reportD Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman 
CU_BAR_SF_00011Student Acct Dtl by Item TypeThis 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 McGovernDorothy HimesNew reportD Himes, S Ho, C Keck, A Kamruzzaman, T.Lodhi, P.Ackerman 
  • No labels