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 EXCEPTION_APPLIED EXCEPTION_DETAIL 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 SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA_SLOT 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 WCV_EXTR_COURSE_DETAILS WCV_EXTR_INSTITUTION_DETAILS WCV_EXTR_PERSON_DETAILS WCV_EXTR_STUD_CLASSIFICATION YEARLY_DEDUCTION YEAR_TYPE_DEFINITION

RETURN TO REPORTING VIEW REPORTS LIST

Composite View Source: GROUP_COUNT_EXPRESSIONS Advancement Reporting View Meta Data Reports

Banner Operational Data Store

Reporting View Source: GROUP_COUNT_EXPRESSIONS - NULL

Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
ACTIVE_PHONE_IND_EXPRESSION					SPRTELE_STATUS_IND
ACTIVITY_COUNT_EXPRESSION					ENTITY_KEY || '{' || MULTI_SOURCE_KEY || '{' || ACTIVITY -- ( INGRP1.ENTITY_KEY * 100 ) + INGRP1.MULTI_SOURCE_KEY + ( INGRP1.ADVANCEMENT_ACTIVITY_KEY * 0.01 )
ACTIVITY_RECORD_COUNT_EXPRESSION					( ENTITY_KEY * 100000000 ) + ( ACTIVITY_LEADERSHIP_SEQ_NUMBER * 1000000 ) + ( MULTI_SOURCE_KEY * 10000 ) + ACTIVITY_YEAR + ( ADVANCEMENT_ACTIVITY_KEY * 0.01 )
ADVANCEMENT_ACT_GROUP_KEY_EXPRESSION					ENTITY_KEY * 100 + MULTI_SOURCE_KEY
ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY
ADVANCEMENT_DEG_CONC_GRP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( APRADEG_SEQ_NO * 0.01 )
ADVANCEMENT_DEG_DEPT_GRP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( APRADEG_SEQ_NO * 0.01 )
ADVANCEMENT_DEG_HONR_COUNT_EXPRESSION					( ( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( APRADEG_SEQ_NO * 0.01 ) ) + + ( ADVANCEMENT_DEG_HONR_KEY * 0.0001 )
ADVANCEMENT_DEG_HONR_GRP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( APRADEG_SEQ_NO * 0.01 )
ADVANCEMENT_DEG_MAJR_COUNT_EXPRESSION					( ( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( APRAMAJ_ADEG_SEQ_NO * 0.01 ) ) + ( ADVANCEMENT_DEG_MAJR_KEY * 0.0001 )
ADVANCEMENT_DEG_MAJR_GRP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( APRAMAJ_ADEG_SEQ_NO * 0.01 )
ADVANCEMENT_DEG_MINR_GRP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( APRADEG_SEQ_NO * 0.01 )
CONSTITUENT_INTEREST_COUNT_KEY_EXPRESSIO N					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( CONSTITUENT_INTEREST_KEY * .001 )
CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSIO N					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY
CONSTITUENT_PROFILE_COUNT_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( CONSTITUENT_PROFILE_DETAIL_KEY * .0001 )
CONSTITUENT_PROFILE_GROUP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY
DEGREE_COUNT_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( APRADEG_SEQ_NO * 0.01 )
EMAIL_COUNT_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( EMAIL_KEY * 0.001 ) + ( EMAIL_TYPE_KEY * 0.00001 )
EMAIL_GROUP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY
EXCLUSION_GROUP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY
GIFT_SOCIETY_COUNT_EXPRESSION					ENTITY_KEY || '{' || MULTI_SOURCE_KEY || '{' || GIFT_SOCIETY -- ( INGRP1.ENTITY_KEY * 100 ) + INGRP1.MULTI_SOURCE_KEY + ( INGRP1.GIFT_SOCIETY_KEY * .001 )
GIFT_SOCIETY_GROUP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY
GIFT_SOCIETY_PREMIUM_GROUP_KEY_EXPRESSIO N					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( GIFT_SOCIETY_YEAR_KEY * .001 ) + ( GIFT_SOCIETY_KEY * .000001 )
GIFT_SOCIETY_RECORD_COUNT_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( GIFT_SOCIETY_KEY * .001 ) + ( GIFT_SOCIETY_YEAR_KEY * .000001 )
PHONE_COUNT_EXPRESSION					( ( ENTITY_KEY * 100000000 ) + ( PHONE_KEY * 100 ) + ( MULTI_SOURCE_KEY ) + ( PHONE_TYPE_KEY * 0.1 ) + ( SPRTELE_SEQNO * 0.0001 ) )
PHONE_GROUP_KEY_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY
PHONE_UNLISTED_IND_EXPRESSION					SPRTELE_UNLIST_IND
PRIMARY_PHONE_IND_EXPRESSION					SPRTELE_PRIMARY_IND
SPECIAL_PURPOSE_COUNT_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( SPECIAL_PURPOSE_KEY * 0.01 )
SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION					ENTITY_KEY * 100 + MULTI_SOURCE_KEY
SPECIAL_PURPOSE_RECORD_COUNT_EXPRESSION					( TO_NUMBER ( TO_CHAR ( SPECIAL_PURPOSE_DATE , 'YYYYMMDD' ) ) * 10000000000 ) + ( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( SPECIAL_PURPOSE_KEY * 0.01 ) + ( SPECIAL_PURPOSE_TYPE_KEY * 0.0001 )
SPECIAL_PURPOSE_TYPE_COUNT_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( SPECIAL_PURPOSE_TYPE_KEY * 0.01 )
VARIABLE_PURPOSE_COUNT_EXPRESSION					( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( VARIABLE_PURPOSE_KEY * 0.001 )
VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION					ENTITY_KEY * 100 + MULTI_SOURCE_KEY

Ver: 9.1