Go To View:  -- Select a View -- AA_DEGREES ACADEMIC_HISTORY_EVENT ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACCOUNT_ADDL_INFO_KSU ACCOUNT_ATTRIBUTES ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL ACCOUNT_INDEX ACCOUNT_TYPE_ATTRIBUTES ACTIVITY ACTIVITY_ATTRIBUTES ADDRESS ADDRESS_BY_RULE ADDRESS_BY_RULE_KSU ADDRESS_CURRENT ADDRESS_DATES_KSU ADDRESS_PREFERRED ADDRESS_SLOT_KSU ADMINISTRATOR ADMISSIONS_ADDL_INFO_KSU ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_DECISION_SLOT ADMISSIONS_RATING ADMISSIONS_REQUIREMENT ADMISSIONS_REQ_SLOT_KSU ADMISSIONS_SOURCE ADMISSIONS_SOURCE_SLOT ADVANCEMENT_ADDRESS_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_DEGREE_SLOT_KSU ADVANCEMENT_EMPLOYER_KSU ADVANCEMENT_RATING ADVANCEMENT_RATING_SLOT ADVISOR ADVISOR_SLOT ALTERNATIVE_ID ANNUAL_GIVING ANNUAL_GIVING_SLOT APPLICANT_NEED APPLICANT_RESOURCE APPLICATION_OF_PAYMENT APPLIED_CURRICULUM_KSU APPL_OF_PAY_DETAIL_ACCOUNTING APP_ADMT_CURRICULUM_KSU APP_QUESTIONS_KSU ATTRIBUTE_SETS 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 BEST_ACTC_KSU BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL BUDGET_REQUEST_TEXT BURSAR_QUEUE_KSU 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 COMPLETE_TERM_WITHDRAWAL_KSU 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 COURSE_TEXT_KSU 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 DESTINATION_KENT_KSU DONOR_CATEGORY DONOR_CATEGORY_SLOT EFFORT_CERTIFICATION_KSU EMAIL_KSU EMPLOYEE EMPLOYEE_ADDL_INFO_KSU EMPLOYEE_EARNING_CY EMPLOYEE_EARNING_FY EMPLOYEE_POSITION EMPLOYMENT_HISTORY EMPL_EARN_CY_SLOT EM_CAMPAIGN EM_COMMUNICATION EM_INTERACTION EM_ORGANIZATION EM_VALIDATION 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_COMMENTS_KSU FINAID_ENROLLMENT FINAID_FUND FINAID_HOLD FINAID_MESSAGE FINAID_RESOURCES_KSU 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 GEO_REGION_KSU GIFT GIFT_ASSOCIATED_ENTITY GIFT_AUXILIARY GIFT_MATCHING GIFT_MATCHING_DETAIL GIFT_MATCHING_TRANSACTION GIFT_MEMO GIFT_MULTIPLE GIFT_SOCIETY GIFT_SOCIETY_ADDL_INFO_KSU 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_LEVEL_KSU GPA_BY_TERM GPS_GOAL_DATA_KSU GRAD_FEE_WAIVER_ACCT_REC_KSU 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_PERSONNEL_KSU 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 NEED_ANALYSIS NEED_ANALYSIS_ADDL_INFO_KSU 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_FUNDING_AREA ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL OUTCOME_DEPARTMENTAL_HONOR OUTCOME_HONOR OUTCOME_INSTITUTIONAL_HONOR PAST_EMPLOYMENT_SLOT PAYROLL_ATTENDANCE PAYROLL_DEDUCTION PAYROLL_DIRECT_DEPOSIT_KSU 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 PLEDGE PLEDGE_ASSOCIATED_ENTITY PLEDGE_AUXILIARY PLEDGE_CONDITIONAL PLEDGE_CONDITION_KSU PLEDGE_INSTALLMENT PLEDGE_KSU PLEDGE_MATCHING PLEDGE_MATCHING_TRANSACTION PLEDGE_TRANSACTION PORTFOLIO PORTFOLIO_SUMMARY POSITION_BUDGET POSITION_CLASS_KSU 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 PROJECT_INTEREST PROPOSAL PROPOSAL_TEXT PROSPECT_CONFIDENTIAL_COMMENT PROSPECT_CONF_COMMENT_SUBJ PROSPECT_CONTACT_EXPENSE 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 PYR_EMPL_POSN_ADDL_INFO_KSU 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 REC_ACCT_DETAIL_ADDL_INFO_KSU REFERENCE REFERENCE_SLOT REGISTRATION_HOLD_OVERRIDE_KSU 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 SALUTATION_SLOT_KSU SATISFACTORY_ACAD_PROGRESS SCHEDULE_ATTRIBUTE SCHEDULE_OFFERING SECONDARY_SCHOOL_SUBJECT SECTION_TEXT_KSU 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_ADDL_INFO_KSU 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_GRADE_CHG_KSU STUDENT_COURSE_REG_AUDIT STUDENT_EXTENDED STUDENT_TAX_NOTIFICATION STUDENT_TRANSFERRED_COURSE STUDENT_WORK_EXPERIENCE TAX TELEPHONE TELEPHONE_CURRENT TEST TEST_SLOT TRACKING_REQUIREMENT_SLOT TRANSACTION_HISTORY TRANSCRIPT_COMMENT TRAVEL_AND_EXPENSE_PROFILE USER_DEFINED_FIELDS VALIDATION VENDOR VENDOR_ADDL_INFO_KSU VENDOR_MULTIPLE_INVOICE_KSU 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 WEB_LEAVE_REPORTING_KSU YEARLY_DEDUCTION YEAR_TYPE_DEFINITION

RETURN TO REPORTING VIEW REPORTS LIST

Composite View Source: MEASURES Advancement Reporting View Meta Data Reports

SGHE Banner Operational Data Store

Reporting View Source: MEASURES - NULL

Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
CAMPAIGN_TRANSACTION_AMOUNT_EXPRESSION	TBD				PIDM_GDES_CAMP_AMT
GIFT_PREMIUM_COUNT_EXPRESSION	TBD				NULL
HARD_CREDIT_AMOUNT_EXPRESSION	TBD				CASE WHEN (SOURCE_TABLE = 'AGRGDES') and (AMOUNT - NVL(AGRGMLT_CREDIT_AGG,0)) is null THEN AMOUNT WHEN (SOURCE_TABLE = 'AGRGDES') and (AMOUNT - NVL(AGRGMLT_CREDIT_AGG,0)) is not null THEN (AMOUNT - NVL(AGRGMLT_CREDIT_AGG,0)) WHEN (SOURCE_TABLE = 'AGRGMMO') THEN 0 WHEN (SOURCE_TABLE = 'AGRGMLT') THEN NVL(AMOUNT, 0) END
MATCH_GIFT_AMOUNT_EXPRESSION	TBD				CASE WHEN (SOURCE_TABLE = 'AGRGDES' AND AGRMGIF_EMPR_GIFT_NO IS NOT NULL) THEN NVL(AMOUNT, 0) WHEN (SOURCE_TABLE = 'AGRGMMO') THEN 0 WHEN (SOURCE_TABLE = 'AGRGMLT') THEN 0 ELSE 0 END
MATCH_GIFT_COUNT_EXPRESSION	TBD				CASE WHEN (SOURCE_TABLE = 'AGRGDES' AND AGRMGIF_EMPR_GIFT_NO IS NOT NULL) THEN GIFT_NO WHEN (SOURCE_TABLE = 'AGRGMMO' AND AGRMGIF_EMPR_GIFT_NO IS NOT NULL) THEN GIFT_NO WHEN (SOURCE_TABLE = 'AGRGMLT') THEN NULL ELSE NULL END
MATCH_GIFT_SOFT_CREDIT_AMOUNT_EXPRESSION	TBD				CASE WHEN (SOURCE_TABLE = 'AGRGDES') THEN 0 WHEN (SOURCE_TABLE = 'AGRGMMO' AND AGRMGIF_EMPR_GIFT_NO IS NOT NULL) THEN NVL(AMOUNT, 0) WHEN (SOURCE_TABLE = 'AGRGMLT') THEN 0 ELSE 0 END
NON_MATCHED_SOFT_CREDIT_AMOUNT_EXPRESSIO N	TBD				CASE WHEN (SOURCE_TABLE = 'AGRGDES') THEN 0 WHEN (SOURCE_TABLE = 'AGRGMMO' AND AGRMGIF_EMPR_GIFT_NO IS NULL) THEN NVL(AMOUNT, 0) WHEN (SOURCE_TABLE = 'AGRGMLT') THEN 0 ELSE 0 END
OVERALL_TRANSACTION_AMOUNT_EXPRESSION	TBD				GDES_AMNT
PLEDGE_GROUP_IDENTIFIER_EXPRESSION	TBD				CASE WHEN PLEDGE_NO != 0 THEN PLEDGE_NO ELSE NULL END
SOFT_CREDIT_AMOUNT_EXPRESSION	TBD				CASE WHEN (SOURCE_TABLE = 'AGRGDES') THEN 0 WHEN (SOURCE_TABLE = 'AGRGMMO') THEN NVL(AMOUNT,0) WHEN (SOURCE_TABLE = 'AGRGMLT') THEN 0 END
TRANSACTION_COUNT_EXPRESSION	TBD				GIFT_NO

Ver: 8.4.1