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 BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports
SGHE Banner Operational Data Store
Reporting View Target: PAYROLL_DIRECT_DEPOSIT_KSU
Target Column
Business Definition
Database Data Type
Source Name
Source Column
ACCOUNT_TYPE
VARCHAR2(1)
ACTIVITY_DATE
DATE
ADDRESS_SEQUENCE_NUMBER
NUMBER
ADRESS_TYPE_CODE
VARCHAR2(2)
AMOUNT
NUMBER
AP_INDICATOR
VARCHAR2(1)
BANK_ACCOUNT_NUMBER
VARCHAR2(17)
BANK_ROUTING_NUMBER
VARCHAR2(9)
DIRECT_DEPOSIT_PERCENT
NUMBER
DOCUMENT_TYPE
VARCHAR2(1)
HR_INDICATOR
VARCHAR2(1)
PERSON_UID
NUMBER
PRIORITY
NUMBER
STATUS
VARCHAR2(1)
USER_ID
VARCHAR2(30)
Ver: 8.4.1