Go To View:
-- Select a View --
ACADEMIC_HISTORY_EVENT
ACADEMIC_OUTCOME
ACADEMIC_OUTCOME_SLOT
ACADEMIC_STUDY
ACADEMIC_STUDY_EXTENDED
ACCOUNT_ATTRIBUTES
ACCOUNT_HIERARCHY
ACCOUNT_HIERARCHY_FISCAL
ACCOUNT_INDEX
ACCOUNT_TYPE_ATTRIBUTES
ACTIVITY
ACTIVITY_ATTRIBUTES
ADDRESS
ADDRESS_BY_RULE
ADDRESS_CURRENT
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
ALTERNATIVE_ID
ANNUAL_GIVING
ANNUAL_GIVING_SLOT
APPLICANT_NEED
APPLICANT_PERIOD_STATUS
APPLICANT_RESOURCE
APPLICATION_OF_PAYMENT
APPL_OF_PAY_DETAIL_ACCOUNTING
ATTRIBUTE_SETS
AUDIT_COURSE_NEEDED
AUDIT_STUDENT_BLOCK
AUDIT_STUDENT_COURSE
AUDIT_STUDENT_NON_COURSE
AUTHORIZATION
AUTHORIZATION_ACCOUNTING
AUTHORIZATION_APPROVAL_HISTORY
AUTHORIZATION_ITEM
AUTHORIZATION_ITEM_TAX
AUTHORIZATION_ITINERARY
AUTHORIZATION_STATUS_HISTORY
AWARD_BY_AID_YEAR
AWARD_BY_FUND
AWARD_BY_PERSON
AWARD_DISBURSEMENT
BARGAINING_UNIT
BARG_UNIT_SLOT
BENEFICIARY_DEPENDENT
BENEFICIARY_SLOT
BENEFIT_DEDUCTION
BLOCK_REGISTRATION_COURSE
BUDGET_AVAILABILITY_LEDGER
BUDGET_DETAIL
BUDGET_REQUEST_TEXT
CALENDAR_DATE_HIERARCHY
CAMPAIGN
CAMPAIGN_COMMENT
CAMPAIGN_DESIGNATION
CAMPAIGN_EXPENSE
CAMPAIGN_FUNDRAISER
CAMPAIGN_GIVING_HISTORY
CAMPAIGN_MAIL
CAMPAIGN_SOLICITATION
CERTIFICATION
CERTIFICATION_SLOT
CHART_ATTRIBUTES
COMBINED_ACADEMIC_OUTCOME
COMMUNICATION
COMMUNICATION_SLOT
CONSTITUENT
CONSTITUENT_CONF_COMMENT
CONSTITUENT_CONF_COMMENT_SUBJ
CONSTITUENT_CONTACT
CONSTITUENT_ENTITY
CONSTITUENT_PLAN
CONSTITUENT_STAFF_ASSIGN
CONTACT
CONTACT_SLOT
CONTRACT
CONTRACT_PAYMENT_DETAIL
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
DELEGATE_ASSIGNMENT
DEPOSIT
DESIGNATION
DESIGNATION_ACCOUNTING
DESIGNATION_ADJUSTMENT
DESIGNATION_ATTRIBUTE
DESIGNATION_CLASS_YEAR
DESIGNATION_COMMENT
DESIGNATION_COMMENT_SUBJ
DESIGNATION_FINAID_FUND
DESIGNATION_GIVING_HISTORY
DESIGNATION_ID
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
ENROLLMENT_WITHDRAWAL
EVENT
EVENT_INVITEE
EXCLUSION
EXCLUSION_SLOT
EXEMPTION
FACULTY
FACULTY_APPOINTMENT_HISTORY
FACULTY_ATTRIBUTE
FACULTY_ATT_SLOT
FACULTY_DEPARTMENT_COLLEGE
FACULTY_FEEDBACK
FACULTY_FEEDBACK_DETAIL
FACULTY_RANK_HISTORY
FACULTY_SABBATICAL_HISTORY
FACULTY_TRACKING
FAMILY_MEDICAL_LEAVE_HISTORY
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_ADJUSTMENT_TEXT
FIXED_ASSET_ATTRIBUTES
FIXED_ASSET_DEPRECIATED_ITEM
FIXED_ASSET_FUNDING_SOURCE
FIXED_ASSET_ITEM
FIXED_ASSET_TEXT
FMLA_LEAVE_COMMENT
FOAPAL_NO_ATTRIBUTES
FUNDING_INTEREST
FUNDING_INTEREST_SLOT
FUND_ATTRIBUTES
FUND_HIERARCHY
FUND_HIERARCHY_FISCAL
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_DETAIL
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_DEFERRED_COST
GRANT_EVENT
GRANT_EVENT_STATUS
GRANT_FUND
GRANT_FUND_SLOT
GRANT_LEDGER
GRANT_PERSONNEL
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_ACCOUNTING_TAX_RATE
INVOICE_CHECK
INVOICE_ITEM
INVOICE_ITEM_ACCOUNTING
INVOICE_TAX_RATE
INVOICE_TAX_RATE_SLOT
INVOICE_TEXT
JOURNAL_VOUCHER_TEXT
LABOR_COST_DISTRIBUTION
LEAVE_ACCRUAL
LEAVE_BALANCE
LEAVE_BALANCE_SLOT
LOAN_AGGREGATES
LOAN_APPLICATION
LOAN_DISBURSEMENT
LOCATION_ATTRIBUTES
LOCATION_HIERARCHY
LOCATION_HIERARCHY_FISCAL
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
MPV_ACADEMIC_STANDING
MPV_ADVISOR_NAME
MPV_ALL_PROGRAM
MPV_AUDIT
MPV_BLOCK_TYPE
MPV_GEOGRAPHIC_DIVISION
MPV_PROGRAM
MPV_REGISTRATION_PLAN
MPV_REGISTRATION_PLAN_COURSE
MPV_STUDENT_CLASSIFICATION
MPV_STUDENT_POPULATION
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
NON_YEAR_USER_DEFINED_FIELDS
OFFERING_COREQ
OFFERING_GRADE_TYPE
OFFERING_PREREQ
OPERATING_LEDGER
ORGANIZATIONAL_CONSTITUENT
ORGANIZATION_ATTRIBUTES
ORGANIZATION_CONTACT
ORGANIZATION_CONTACT_SLOT
ORGANIZATION_ENTITY
ORGANIZATION_ENTITY_ADDRESS
ORGANIZATION_FUNDING_AREA
ORGANIZATION_HIERARCHY
ORGANIZATION_HIERARCHY_FISCAL
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
PERIOD_BUDGET_COMPONENT
PERSON
PERSONNEL_ACTION
PERSONNEL_ACTION_COMMENT
PERSONNEL_ACTION_EARNING
PERSONNEL_ACTION_GENERAL
PERSONNEL_ACTION_LABOR_DIST
PERSON_ADDRESS
PERSON_DETAIL
PERSON_INTERNATIONAL
PERSON_SENSITIVE
PERSON_SENSITIVE_RACE
PERSON_SENSITIVE_RACE_SLOT
PERSON_VETERAN
PHONE_ASSIGNMENT
PLAN_TEMPLATE_COURSE
PLEDGE
PLEDGE_ASSOCIATED_ENTITY
PLEDGE_AUXILIARY
PLEDGE_CONDITIONAL
PLEDGE_INSTALLMENT
PLEDGE_MATCHING
PLEDGE_MATCHING_TRANSACTION
PLEDGE_TRANSACTION
PORTFOLIO
PORTFOLIO_SUMMARY
POSITION_BUDGET
POSITION_DEFINITION
POSITION_LABOR_DISTRIBUTION
POSN_LABOR_DIST_SLOT
PREVIOUS_DEGREE
PREVIOUS_EDUCATION
PREVIOUS_EDUCATION_ATTENDANCE
PREVIOUS_EDUCATION_SLOT
PRE_STUDENT
PROFILE_DEFAULT_ACCOUNTING
PROGRAM_ATTRIBUTES
PROGRAM_HIERARCHY
PROGRAM_HIERARCHY_FISCAL
PROJECTED_SEATS_NEEDED
PROJECT_INTEREST
PROPOSAL
PROPOSAL_TEXT
PROSPECT_CONFIDENTIAL_COMMENT
PROSPECT_CONF_COMMENT_SUBJ
PROSPECT_CONTACT_EXPENSE
PROSPECT_CONTACT_STAFF
PROSPECT_INFO
PROSPECT_MOVES_MANAGEMENT
PROSPECT_PROPOSAL
PROSPECT_PROPOSAL_MASTER
PROSPECT_PROPOSAL_PROJECT
PROSPECT_PROPOSAL_RESULT
PROSPECT_STAFF_ASSIGNMENT
PURCHASE_ORDER
PURCHASE_ORDER_ACCOUNTING
PURCHASE_ORDER_ITEM
PURCHASE_ORDER_ITEM_ACCOUNTING
PURCHASE_ORDER_ITEM_SUMMARY
PURCHASE_ORDER_ITEM_TEXT
PURCHASE_ORDER_TAX_RATE
PURCHASE_ORDER_TEXT
RECEIVABLE_ACCOUNT
RECEIVABLE_ACCOUNTING
RECEIVABLE_ACCOUNT_DETAIL
RECEIVABLE_SUMMARY
RECEIVED_ITEM
RECEIVED_ITEM_TEXT
RECRUITMENT_ATTRIBUTE
RECRUITMENT_COHORT
RECRUITMENT_INFORMATION
RECRUITMENT_LEARNED
RECRUITMENT_SOURCE
RECRUITMENT_SOURCE_SLOT
REFERENCE
REFERENCE_SLOT
REGISTRATION_PLAN
REGISTRATION_PLAN_COURSE
REIMBURSEMENT
REIMBURSEMENT_ACCOUNTING
REIMBURSEMENT_APPROVAL_HISTORY
REIMBURSEMENT_ITEM
REIMBURSEMENT_ITEM_TAX
REIMBURSEMENT_ITINERARY
REIMBURSEMENT_STATUS_HISTORY
RELATIONSHIP
REQUIREMENT_SLOT
RETURNED_ITEM
RETURNED_ITEM_TEXT
REVIEW
REVIEW_SLOT
ROOM_ASSIGNMENT
SALUTATION
SATISFACTORY_ACAD_PROGRESS
SCHEDULE_ATTRIBUTE
SCHEDULE_OFFERING
SECONDARY_SCHOOL_SUBJECT
SKILL
SKILL_SLOT
SOLICITATION
SOLICITOR_ASSIGNMENT
SOLICITOR_ASSIGNMENT_RESULT
SOLICITOR_ORGANIZATION
SOLICITOR_ORGANIZATION_COMMENT
SOLICITOR_ORGANIZATION_GOAL
SOLICITOR_ORG_FUNDRAISER
SOLICITOR_ORG_FUNDRAISER_GOAL
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_ATTRIBUTE_SLOT
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_TAX_NOTIFICATION
STUDENT_TRANSFERRED_COURSE
STUDENT_WORK_EXPERIENCE
TAX
TELEPHONE
TELEPHONE_CURRENT
TEST
TEST_PERCENTILE
TEST_SLOT
TRACKING_REQUIREMENT_SLOT
TRANSACTION_HISTORY
TRANSCRIPT_COMMENT
TRAVEL_AND_EXPENSE_PROFILE
USER_DEFINED_FIELDS
VALIDATION
VENDOR
VENDOR_TAXABLE_REPORTING
VENDOR_TEXT
VENDOR_TYPE
VETERAN_CERTIFICATION
VISA
VISA_CURRENT
YEARLY_DEDUCTION
YEAR_TYPE_DEFINITION
RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: ADRYEAR
Advancement Reporting View Meta Data Reports
SGHE Banner Operational Data Store
Reporting View Source: ADRYEAR - NULL
Source Column
Source Form
Target Type
Target
Target Column
Calculation Formula
ADRYEAR_ACTIVITY_DATE
ADADESG
REPORTING VIEW
DESIGNATION_CLASS_YEAR
ACTIVITY_DATE
ADRYEAR_DESG
ADADESG
REPORTING VIEW
DESIGNATION_CLASS_YEAR
DESIGNATION
ADRYEAR_USER
ADADESG
REPORTING VIEW
DESIGNATION_CLASS_YEAR
DESIGNATION_CLASS_YEAR_USER_ID
ADRYEAR_YEAR
ADADESG
REPORTING VIEW
DESIGNATION_CLASS_YEAR
DESIGNATION_CLASS_YEAR
Ver: 8.5