Go To View:
-- Select a View --
ACADEMIC_HISTORY_EVENT
ACADEMIC_OUTCOME
ACADEMIC_OUTCOME_SLOT
ACADEMIC_STUDY
ACADEMIC_STUDY_EXTENDED
ACCOUNT_ATTRIBUTES
ACCOUNT_HIERARCHY
ACCOUNT_INDEX
ACCOUNT_TYPE_ATTRIBUTES
ACTIVITY
ACTIVITY_ATTRIBUTES
ADDRESS
ADDRESS_BY_RULE
ADDRESS_CURRENT
ADDRESS_MV
ADDRESS_PREFERRED
ADMINISTRATOR
ADMISSIONS_APPLICATION
ADMISSIONS_ATTRIBUTE
ADMISSIONS_COHORT
ADMISSIONS_DECISION
ADMISSIONS_DECISION_SLOT
ADMISSIONS_RATING
ADMISSIONS_REQUIREMENT
ADMISSIONS_SOURCE
ADMISSIONS_SOURCE_SLOT
ADVANCEMENT_RATING
ADVANCEMENT_RATING_SLOT
ADVISOR
ADVISOR_SLOT
ANNUAL_GIVING
ANNUAL_GIVING_SLOT
APPLICANT_NEED
APPLICANT_RESOURCE
APPLICATION_OF_PAYMENT
APPL_OF_PAY_DETAIL_ACCOUNTING
ATTRIBUTE_SETS
AWARD_BY_AID_YEAR
AWARD_BY_FUND
AWARD_BY_PERSON
AWARD_DISBURSEMENT
BARGAINING_UNIT
BARG_UNIT_SLOT
BENEFICIARY_DEPENDENT
BENEFICIARY_SLOT
BENEFIT_DEDUCTION
BUDGET_AVAILABILITY_LEDGER
BUDGET_DETAIL
CALENDAR_DATE_HIERARCHY
CAMPAIGN_GIVING_HISTORY
CERTIFICATION
CERTIFICATION_SLOT
CHART_ATTRIBUTES
COMBINED_ACADEMIC_OUTCOME
COMMUNICATION
COMMUNICATION_SLOT
CONSTITUENT
CONSTITUENT_CONTACT
CONSTITUENT_ENTITY
CONSTITUENT_PLAN
CONSTITUENT_STAFF_ASSIGN
CONTACT
CONTACT_SLOT
CONTRACT
COURSE_ATTRIBUTE
COURSE_ATT_SLOT
COURSE_CATALOG
COURSE_COREQ
COURSE_LEVEL
COURSE_LEVEL_SLOT
COURSE_OFFERING_FEES
COURSE_PREREQ
COURSE_PREREQ_COMBINED
COURSE_SCHEDULE
COURSE_SCHEDULE_SLOT
CROSS_REFERENCE_SLOT
CURRENT_EMPLOYMENT
DEGREE
DEGREE_SLOT
DEPOSIT
DESIGNATION_GIVING_HISTORY
DONOR_CATEGORY
DONOR_CATEGORY_SLOT
EMPLOYEE
EMPLOYEE_EARNING_CY
EMPLOYEE_EARNING_FY
EMPLOYEE_POSITION
EMPLOYMENT_HISTORY
EMPL_EARN_CY_SLOT
ENCUMBRANCE
ENCUMBRANCE_ACCOUNTING
ENCUMBRANCE_LEDGER
ENCUMBRANCE_TEXT
ENDOWMENT_ATTRIBUTES
ENDOWMENT_DISTRIBUTION
ENDOWMENT_SUMMARIZED_UNITS
ENDOWMENT_UNITS
ENROLLMENT
EVENT
EVENT_INVITEE
EXCLUSION
EXCLUSION_SLOT
EXEMPTION
FACULTY
FACULTY_APPOINTMENT_HISTORY
FACULTY_ATTRIBUTE
FACULTY_ATT_SLOT
FACULTY_DEPARTMENT_COLLEGE
FACULTY_RANK_HISTORY
FACULTY_SABBATICAL_HISTORY
FACULTY_TRACKING
FIELD_OF_STUDY
FINAID_APPLICANT_STATUS
FINAID_BUDGET_COMPONENT
FINAID_BUDGET_COMP_SLOT
FINAID_COMMENTS
FINAID_ENROLLMENT
FINAID_FUND
FINAID_HOLD
FINAID_MESSAGE
FINAID_TRACKING_REQUIREMENT
FIXED_ASSET_ACCOUNTING_HISTORY
FIXED_ASSET_ACCOUNTING_SOURCE
FIXED_ASSET_ADJUSTMENT
FIXED_ASSET_ATTRIBUTES
FIXED_ASSET_DEPRECIATED_ITEM
FIXED_ASSET_FUNDING_SOURCE
FIXED_ASSET_ITEM
FIXED_ASSET_TEXT
FOAPAL_NO_ATTRIBUTES
FUNDING_INTEREST
FUNDING_INTEREST_SLOT
FUND_ATTRIBUTES
FUND_HIERARCHY
FUND_MESSAGE_RULE
FUND_TEXT
FUND_TYPE_ATTRIBUTES
GENERAL_LEDGER
GEOGRAPHIC_REGION
GEOGRAPHIC_REGION_INSTITUTION
GIFT
GIFT_ASSOCIATED_ENTITY
GIFT_AUXILIARY
GIFT_MATCHING
GIFT_MATCHING_TRANSACTION
GIFT_MEMO
GIFT_MULTIPLE
GIFT_SOCIETY
GIFT_SOCIETY_SLOT
GIFT_TRANSACTION
GOVERNMENT_ACADEMIC_OUTCOME
GOVERNMENT_ADMISSIONS
GOVERNMENT_COURSE
GOVERNMENT_FA_FUND
GOVERNMENT_FINANCIAL_AID
GOVERNMENT_STUDENT
GPA
GPA_BY_LEVEL
GPA_BY_TERM
GRANT_APPLIED_PAYMENTS
GRANT_ATTRIBUTES
GRANT_BILLING_DETAIL
GRANT_FUND
GRANT_FUND_SLOT
GRANT_LEDGER
GRANT_RECEIVABLE_ACCT_DETAIL
GRANT_TEXT
GRANT_VIEW
HOLD
HOLD_SLOT
HR_APPLICATION
HR_APPLICATION_STATUS
HR_APPL_STAT_SLOT
HR_REQUISITION
INSTALLMENT_PLAN
INSTITUTION
INSTITUTION_CHARACTERISTIC
INSTITUTION_DEMOGRAPHIC
INSTRUCTIONAL_ASSIGNMENT
INSTRUCT_ASSIGN_SLOT
INST_CHARACTERISTIC_SLOT
INTEREST
INTEREST_SLOT
INTERNET_ADDRESS
INTERNET_ADDRESS_CURRENT
INTERVIEW
INTERVIEW_SLOT
INVOICE
INVOICE_ACCOUNTING
INVOICE_CHECK
INVOICE_ITEM
INVOICE_TAX_RATE
INVOICE_TAX_RATE_SLOT
LABOR_COST_DISTRIBUTION
LEAVE_ACCRUAL
LEAVE_BALANCE
LEAVE_BALANCE_SLOT
LOAN_AGGREGATES
LOAN_APPLICATION
LOAN_DISBURSEMENT
LOCATION_ATTRIBUTES
LOCATION_HIERARCHY
MAIL
MAIL_SLOT
MEAL_ASSIGNMENT
MEDICAL_INFORMATION
MEDICAL_INFORMATION_SLOT
MEETING_TIME
MEETING_TIME_SLOT
MEMBERSHIP
MEMBERSHIP_INTEREST
MEMO
MISCELLANEOUS_TRANSACTION
MONTHLY_DEDUCTION
MONTHLY_DEDUCT_SLOT
NEED_ANALYSIS
NEED_ANALYSIS_DEMOGRAPHIC
NEED_ANALYSIS_FEDERAL_METHOD
NEED_ANALYSIS_INST_METHOD
NEED_ANALYSIS_ISIR_SPECIFIC
NEED_ANALYSIS_OVERRIDE
NEED_ANALYSIS_PROFILE_SPECIFIC
NONINSTRUCT_ASSIGN_SLOT
NON_INSTRUCTIONAL_ASSIGNMENT
OFFERING_COREQ
OFFERING_GRADE_TYPE
OFFERING_PREREQ
OPERATING_LEDGER
ORGANIZATIONAL_CONSTITUENT
ORGANIZATION_ATTRIBUTES
ORGANIZATION_CONTACT
ORGANIZATION_CONTACT_SLOT
ORGANIZATION_ENTITY
ORGANIZATION_ENTITY_ADDRESS
ORGANIZATION_HIERARCHY
OUTCOME_DEPARTMENTAL_HONOR
OUTCOME_HONOR
OUTCOME_INSTITUTIONAL_HONOR
PAST_EMPLOYMENT_SLOT
PAYROLL_ATTENDANCE
PAYROLL_DEDUCTION
PAYROLL_DISTRIBUTION
PAYROLL_DOCUMENT
PAYROLL_EARNING
PAYROLL_EMPLOYEE_POSITION
PAYROLL_LABOR_DIST_OVERRIDE
PAYROLL_POSITION_TIMESHEET
PAYROLL_TIMESHEET
PERSON
PERSON_ADDRESS
PERSON_DETAIL
PERSON_INTERNATIONAL
PERSON_SENSITIVE
PERSON_SENSITIVE_RACE
PERSON_SENSITIVE_RACE_SLOT
PERSON_VETERAN
PHONE_ASSIGNMENT
PLEDGE
PLEDGE_ASSOCIATED_ENTITY
PLEDGE_AUXILIARY
PLEDGE_CONDITIONAL
PLEDGE_INSTALLMENT
PLEDGE_MATCHING
PLEDGE_MATCHING_TRANSACTION
PLEDGE_TRANSACTION
POSITION_BUDGET
POSITION_DEFINITION
POSITION_LABOR_DISTRIBUTION
POSN_LABOR_DIST_SLOT
PREVIOUS_DEGREE
PREVIOUS_EDUCATION
PREVIOUS_EDUCATION_ATTENDANCE
PREVIOUS_EDUCATION_SLOT
PRE_STUDENT
PROGRAM_ATTRIBUTES
PROGRAM_HIERARCHY
PROPOSAL
PROSPECT_INFO
PROSPECT_PROPOSAL
PURCHASE_ORDER
PURCHASE_ORDER_ACCOUNTING
PURCHASE_ORDER_ITEM
PURCHASE_ORDER_ITEM_SUMMARY
PURCHASE_ORDER_TAX_RATE
RECEIVABLE_ACCOUNT
RECEIVABLE_ACCOUNTING
RECEIVABLE_ACCOUNT_DETAIL
RECEIVABLE_SUMMARY
RECEIVED_ITEM
RECRUITMENT_ATTRIBUTE
RECRUITMENT_COHORT
RECRUITMENT_INFORMATION
RECRUITMENT_LEARNED
RECRUITMENT_SOURCE
RECRUITMENT_SOURCE_SLOT
REFERENCE
REFERENCE_SLOT
RELATIONSHIP
REQUIREMENT_SLOT
RETURNED_ITEM
REVIEW
REVIEW_SLOT
ROOM_ASSIGNMENT
SALUTATION
SATISFACTORY_ACAD_PROGRESS
SCHEDULE_ATTRIBUTE
SCHEDULE_OFFERING
SECONDARY_SCHOOL_SUBJECT
SKILL
SKILL_SLOT
SOLICITATION
SPECIAL_ACTIVITY
SPECIAL_ACTIVITY_SLOT
SPECIAL_ACTIVITY_YEAR
SPECIAL_ACTIVITY_YEAR_SLOT
SPECIAL_PURPOSE_GROUP
SPECIAL_PURPOSE_SLOT
SPORT
SPORT_SLOT
STUDENT
STUDENT_ACTIVITY
STUDENT_ATTRIBUTE
STUDENT_COHORT
STUDENT_COHORT_SLOT
STUDENT_COURSE
STUDENT_COURSE_ATTRIBUTE
STUDENT_COURSE_ATT_SLOT
STUDENT_COURSE_GRADE_CHANGE
STUDENT_COURSE_REG_AUDIT
STUDENT_EXTENDED
STUDENT_WORK_EXPERIENCE
TAX
TELEPHONE
TEST
TEST_SLOT
TRACKING_REQUIREMENT_SLOT
TRANSACTION_HISTORY
TRANSCRIPT_COMMENT
USER_DEFINED_FIELDS
VALIDATION
VENDOR
VENDOR_TYPE
VISA
VISA_CURRENT
YEARLY_DEDUCTION
YEAR_TYPE_DEFINITION
RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SORBACD
Student Reporting View Meta Data Reports
SGHE Banner Operational Data Store
Reporting View Source: SORBACD - NULL
Source Column
Source Form
Target Type
Target
Target Column
Calculation Formula
SORBACD_ACCREDITATION_TYPE
SOABGIY
REPORTING VIEW
INSTITUTION_DEMOGRAPHIC
ACCREDITATION_TYPE
DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N')
SORBACD_CALENDAR_TYPE
SOABGIY
REPORTING VIEW
INSTITUTION_DEMOGRAPHIC
CALENDAR_TYPE
NA
SORBACD_CREDIT_TRANS_VALUE
SOABGIY
REPORTING VIEW
INSTITUTION_DEMOGRAPHIC
CREDIT_WEIGHT
NA
SORBACD_DEMO_YEAR
SOABGIY
REPORTING VIEW
INSTITUTION_DEMOGRAPHIC
CALENDAR_YEAR
NA
SORBACD_STATE_APPROV_IND
SOABGIY
DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N')
Ver: 8.1