Custom Database Views
Users are granted access to these views within the Banner database by
demonstrated need. Access is currently only granted to users with Brio training.
|
GZVMAIL (pdf) This view provides access to mail information from GURMAIL (accessible through forms SUAMAIL, GUIMAIL, RUAMAIL, PUAMAIL) through reporting tools as well as population selection. Updated 3/9/2004 NS_AF_PERIOD_BUDGET_ACTUAL (pdf) Period Operating Account Ledger and Selected General Account Ledger Balance Updated 3/5/2003 NS_AF_PERIOD_NETASSET_RELEASE (pdf) Selective Operating and General Ledger by Period Updated 3/5/2003 NS_AF_YEARLY_BALANCE_SHEET (pdf) Yearly Balance Sheet Information Updated 10/02/2002 NS_AG_EVENTS (pdf) General Event & Meeting Details Updated 5/30/2002 NS_AR_AWARD_DETAIL_BY_TERM (pdf) Award Detail by Term Updated 5/14/2002 NS_AR_AWARD_DETAIL_BY_YEAR (pdf) Award Detail by Year Updated 5/14/2002 NS_AR_HEOP (pdf) Student HEOP Status for Financial Aid Updated 5/30/2002 NS_AS_ACCOUNT_BALANCE (pdf) Student Account Balance by Term Updated 3/5/2003 NS_AS_ADDRESS (pdf) Student Addresses Updated 5/14/2002 NS_AS_ADDRESS_FIXED_POS (pdf) Student Addresses with Fixed Position Updated 5/14/2002 NS_AS_ADM_CHECKLIST (pdf) Student Admissions with all Checklist Updated 4/22/2003 NS_AS_ADM_INTEREST (pdf) Student Admissions with all Interests Updated 4/22/2003 NS_AS_ADMISSION_DECISION (pdf) Student Admission Decision Information Updated 5/14/2002 NS_AS_ADMISSIONS (pdf) Complete Student Admissions Information Updated 12/09/2002 NS_AS_ADMISSIONS_APPLICANT (pdf) Student Admission Applicant Information Updated 5/14/2002 NS_AS_CATALOG_SCHEDULE (pdf) All Course Section Schedule Detail by Term Updated 10/02/2002 NS_AS_COHORT (pdf) NS Cohort View Updated 5/9/2003 NS_AS_DEGREE_INFO (pdf) Student Degree Information Updated 10/02/2002 NS_AS_DORM_HISTORY (pdf) Dorm Room Assignment History Repeating Updated 5/30/2002 NS_AS_DORM_REQ_REPEATING (pdf) Dorm Room Requirement Repeating Attributes Updated 5/30/2002 NS_AS_DORM_REQUIREMENT (pdf) Dorm Room Assignment and Requirements Updated 5/30/2002 NS_AS_DORM_ROSTER (pdf) Dorm Room Vacancy and Assignment Updated 3/5/2003 NS_AS_DORM_USAGE (pdf) Dorm Room Usage Updated 5/30/2002 |
NS_AS_EMAIL (pdf) Student Email Addresses Updated 5/14/2002 NS_AS_EMAIL_FIXED_POS (pdf) Student Email Addresses with Fixed Position Updated 5/14/2002 NS_AS_GF_ACADEMIC_HISTORY (pdf) GF Student Academic History Updated 3/5/2003 NS_AS_HOLD_INFO (pdf) Student Hold Information Updated 5/14/2002 NS_AS_IMMUNIZATION (pdf) Student Immunization Information Updated 5/14/2002 NS_AS_INTERNATIONAL (pdf) International Student Information Updated 5/14/2002 NS_AS_POPSEL (pdf) Population Selection Extract Data Updated 5/14/2002 NS_AS_RESIDENTIAL_LIFE (pdf) Student room and meal application and assignment including personal data Updated 10/02/2002 NS_AS_SNAPSHOT (pdf) NS Student Registration Snapshot View Updated 5/9/2003 NS_AS_SPAPERS (pdf) General Person Information Updated 10/02/2002 NS_AS_TIME_STATUS (pdf) Student Time Status Updated 5/14/2002 NS_AS_TRANSCRIPT_COMMENT (pdf) Student Level and Term Transcript Comment Updated 10/02/2002 NS_AS_XLST (pdf) This view provides access to cross-listed course information. It can be used with Brio and as part of a Banner population selection query. Updated 3/9/2004 NS_AT_CHARGEPAYMENT_DETAIL (pdf) Charge Payment Detail Transactions Updated 10/02/2002 RZVLOAN (pdf) Provide the ability to access Electronic Loan and Loan Disbursement Information, and loan volume by lender and guarantor. Updated 4/22/2004 SZVAPPT (pdf) Admissions Recruiting Appointment Information Updated 4/22/2004 SZVCONT (pdf) This view provides access to Admissions recruiting contact information. It can be used with Brio and as part of a Banner population selection query. Updated 3/9/2004 SZVFOLK (pdf) This view provides access to a student's parent/guardian information for up to three parent/guardians. It can be used with Brio and as part of a Banner population selection query. Updated 3/9/2004 SZVINTS (pdf) This view provides access to Admissions recruiting interests information. It can be used with Brio and as part of a Banner population selection query. Updated 3/9/2004 SZVPREL (pdf) This view provides access to Electronic Admissions Prospect information. It can be used with Brio and as part of a Banner population selection query. Updated 3/9/2004 SZVRCMT (pdf) This view provides access to Admissions Recruiting Comment information. It can be used with Brio and as part of a Banner population selection query. Updated 3/9/2004 |
