Banner ODS Reporting Views

Below a list of Banner Operational Data Store (ODS) reporting views within a Subject Area or Security Role.  Only active or populated views are included in a subject area.

Banner ODS Reporting Views by Security Roles 

Security Role

Reporting View

Description

Key & Frequency

Accounts Receivable

APPLICATION_OF_PAYMENT

Contains accounts receivable information for payments applied to charges Reporting can be by the payment transaction number, charge transaction number, applied amount, posting document, cashier, and session information.

Multiple rows per account per payment transaction.

Accounts Receivable

CONTRACT

Contains third party contract and exemption information for a student including academic period, contract number, contract description, contract expiration date, third party, detail code, and account ID

One row per academic period per person per contract priority. 

Accounts Receivable

DEPOSIT

Contains accounts receivable deposits including account ID, detail code, academic period, transaction number, original amount, balance amount, payment detail code, post cashier, deposit entry date, deposit receipt number, minimum remaining deposit amount, and posting document.

One row per account per transaction number.

Accounts Receivable

EXEMPTION

Contains student exemption information inclucing academic period, account ID, exemption priority, exemption, authorized amount, amount paid, exemption payment code, detail code, and expiration date.

One row per person per academic period per exemption priority.

Accounts Receivable

INSTALLMENT_PLAN

Contains installment plan information (short-term loans, tuition payment plans, etc.) for each account inlcuding installment plan reference number, academic period, number of payments, first installment date, plan amount, interest rate, and late fee amount.

One row per installment reference number.

Accounts Receivable

MISCELLANEOUS_TRANSACTION

Contains miscellaneous transaction detail for receivable accounting. This includes receipt number, payment and charge detail codes, cashier, amount, transaction description, payment and charge accounting distribution, external accounting line, credit card number, posting document, person name and address. Used to track payments and charges not on a student's account.

One row per receipt number per user per transaction number

Accounts Receivable

RECEIVABLE_ACCOUNT

Contains general account information for each person or non person including name, tax ID, account balance, current amount due, deposit balance, hold counts, delinquency, collection information, and credit limit

One row per account.

Accounts Receivable

RECEIVABLE_ACCOUNT_DETAIL

Contains account transaction detail for all payments and charges including academic period, detail code, category, priority, entry date, transaction amount, balance, bill date, due date, post cashier, and posting document.

One row per account per transaction number.

Accounts Receivable

RECEIVABLE_ACCOUNTING

Contains detail code ledger accounting distribution information by effective date for debits and credits to be sent to post into the ledgers. This includes the percentage each accounting transaction is applied to on each transaction amount. Use this view joining to the detail codes by effective date in other views to determine actual accounting for reconciliation.

One row per detail code per effective date.

Accounts Receivable

RECEIVABLE_SUMMARY

Contains summarized totals for amount and balance by term, category and detail code.

One row per academic period per category per detail code.

Admissions

ADMISSIONS_APPLICATION

Contains data specific to an application to study at the institution submitted by the person. Multiple academic years and or academic periods are available for comparison reporting.

One row per person per academic period per application number. 

Admissions

ADMISSIONS_ATTRIBUTE

Contains data that is a characteristic for the admissions applicant to be tracked for the application number in the academic period.

One row per person per academic period per application number per attribute.

Admissions

ADMISSIONS_COHORT

Contains data that identifies the applicant as a member of a group to be tracked within the system with their anticipated start and end academic period. This information is used for special reporting.

One row per person per application number per academic period per cohort.

Admissions

ADMISSIONS_DECISION

Contains data for all admission decisions recorded for the application. Data Includes decision, description, sequence of entry and effective date of decision.

One row per person per academic period per application number per decision number per decision.

Admissions

ADMISSIONS_DECISION_SLOT

Uses data from the ADMISSIONS_DECISION reporting view. Displays up to 5 sets of values based on the last decisions recorded for the academic period and application number.

One row per person per academic period per application number.

Admissions

ADMISSIONS_REQUIREMENT

Contains data about items or other documents required from the applicant before the institution considers their application complete and ready for admission consideration. Details include the most recent request date and the requirement received date

One row per person per academic period per application number per requirement.

Admissions

ADMISSIONS_SOURCE

Contains all the sources or ways that the applicant heard about the institution and primary source the application was submitted.

One row per person per academic period per application number per institution (or source).

Admissions

ADMISSIONS_SOURCE_SLOT

Uses data from the ADMISSIONS_SOURCE reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of SOURCE and a delivered or institution defined internal code. Delivered internal codes of ADMSSRCE may be used independently by the institution.

One row per person per profile code per admissions source rule.

Admissions

CONTACT

Contains all of the contacts an inquirer has had with the institution.

One row per person per contact type per contact date.

Admissions

CONTACT_SLOT

Uses data from the CONTACT reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of CONTACTS and a delivered or institution defined internal code. Delivered internal codes of ADMSCTYP, RECRCTYP may be used independently by the institution.

One row per person per profile code per contact rule.

Admissions

GOVERNMENT_ADMISSIONS

Contains the common data required for government reporting on application statistics for a time frame. Contain only the academic period and person who have to the institution with all details regarding that application. This reporting view may be joined with other reporting views for external and or internal report requirements.

One row per person per academic period per application number.

Admissions

INTEREST

Contains any interests associated with a person.

One row per person per interest.

Admissions

INTEREST_SLOT

Uses data from the INTEREST reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of INTERESTS and a delivered or institution defined internal code. Delivered internal codes of ADMSINTS or RECRINTS may be used independently by the institution.

One row per person per profile code per interest rule.

Admissions

PRE_STUDENT

Contains detail data for persons who are current active students at the institution. For example, persons who are either an applicant or a prospect of the institution. They will have one pre student record even if they have multiple inquiry records and/or applications. Details included in the pre student will include last secondary and last post secondary institution attended when appropriate. It will also include a count of test scores recorded in the system for the person.

One row per person.

Admissions

RECRUITMENT_INFORMATION

Contains data for all inquiries made by persons considering or planning to study at the institution. Details include the type of contact, dates and academic study or program of interest, etc.

One row per person per academic period per recruit number.

Admissions

RECRUITMENT_SOURCE

Contains the institution (agency or organization) that was the major influence on the recruit to contact the institution to request information.

One row per person per academic period per recruit number per institution (source).

Admissions

RECRUITMENT_SOURCE_SLOT

Uses data from the RECRUITMENT_SOURCE reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of SOURCE and a delivered or institution defined internal code. Delivered internal codes of RECRSRCE may be used independently by the institution.

One row per person per recruit number per profile code per recruitment source rule.

Admissions

REQUIREMENT_SLOT

Uses data from the ADMISSIONS_REQUIREMENT reporting view. Displays up to 7 sets of values based on the defined display rule(s) with an internal group of CHECK LIST and a delivered or institution defined internal code. Delivered internal codes of ADMSCHKL may be used independently by the institution.

One row per person per application number per profile code per requirement rule.

Admissions

TEST

Contains data about test scores for a person.

One row per person per test type per test date.

Admissions

TEST_SLOT

Uses data from the TEST reporting view. Displays up to 7 sets of values based on the defined display rule(s) with an internal group of TEST and a delivered or institution defined internal code. Delivered internal codes of (FAPLTEST or ADMSTEST or ACTC or SATM or SATV) may be used independently by the institution.

One row per person per profile code per test rule.

Common

ACADEMIC_PROGRAM_VIEW (DBA_Apps)

Contains information about each academic program.

One row per college, degree, level, and major.

Common

ADDRESS

Contains all addresses for an entity, person, institution, or organization.

One row per entity per address type per address number per address start date and address end date.

Common

ADDRESS_BY_RULE

Contains all addresses for an entity/person, institution, or organization per the display rules.

One address per entity per address type per address number per address rule.

Common

ADDRESS_CURRENT

Contains all active addresses for an entity/person, institution, or organization.

One address per entity per address type per address sequence number.

Common

ADDRESS_PREFERRED

Contains all preferred addresses for an entity/person, institution, or organization.

One row per entity per address type per address sequence number.

Common

COMBINED_ACADEMIC_OUTCOME

Contains an overall list of all the degrees, awards, certificates, etc for the person as awarded by this institution or through an external institution educational experience. These academic outcomes will not be duplicated for the person, institution, degree and major or program recorded on the individual records.

One row per person per outcome_number.

Common

COMMUNICATION

Contains all mailing/communication data for a person.

One row per person per communication.

Common

COMMUNICATION_SLOT

Uses data from the COMMUNICATION reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of MAIL and a delivered or institution defined internal code. Delivered internal codes of RECRLETR (not like 'ALUM%') may be used independently by the institution.

One row per person per profile code per communication rule.

Common

EVENT

Contains all data for a scheduled event.

One row per event.

Common

HOLD

Contains all of the holds (restrictions) for a person.

One row per person per hold per hold from date and hold to date.

Common

HOLD_SLOT

Uses data from the HOLD reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of HOLDS and a delivered or institution defined internal code. Delivered internal codes of (STDNHOLD or RESDHOLD or ARHOLD or GRDCHGHOLD) may be used independently by the institution.

One row per person per profile code per hold rule.

Common

INST_CHARACTERISTIC_SLOT

Uses data from the INSTITUTION_CHARACTERISTIC reporting view. Displays up to 10 sets of values based on the defined display rule(s) with an internal group of CHARACTER and an institution defined internal code. Delivered sample internal code of INSTCHAR may be used or additional internal codes may be defined by the institution.

One row per institution per calendar year.

Common

INSTITUTION

Contains all data that is common to institutions across administrative models and products.

One row per institution.

Common

INSTITUTION_CHARACTERISTIC

Contains institution characteristics associated with the institution within a calendar year.

One row per institution per calendar year per institution characteristic.

Common

INSTITUTION_DEMOGRAPHIC

Contains calendar year demographic data and statistical information associated with a background institution that may be used for reporting and comparing admission prospects and students.

One row per institution per calendar year.

Common

ORGANIZATION_ENTITY

Contains all data that is common to organizations across administrative models and products. Also includes basic information about an entity, e.g., a third party paying a students charges, a company matching the gift of an alumnus, or a vendor supplying goods or services. The Organization table reflects only the most current data; it does not track changes.

One row per entity. 

Common

ORGANIZATION_ENTITY_ADDRESS

Contains information used to add a mailing address to a report or print a mailing label. Since the main purpose of this reporting view is to support correspondence, only persons who are not deceased will appear in this reporting view. All organizations and companies that are active will be selected for this reporting view.

One row per entity per address rule..

Common

PERSON_ADDRESS

Contains information used to add a mailing address to a report or print a mailing label. Since the main purpose of this reporting view is to support correspondence, only persons who are not deceased will appear in this reporting view. All organizations and companies that are active will be selected for this reporting view.

One row per person, organization, company, vendor, etc. per address rule.

Common

PERSON_DETAIL_UT

Contains demographic data common to a person across the ODS data model and the institution enterprise. The data is specific to a person independent of whether that person is a student, faculty member, or employee, alumnus, etc. Data reflects only the most current information; changes are not tracked in the ODS.

One row per person. SSN is masked.

Common

PERSON_INTERNATIONAL_UT

Contains international student information, as well as information regarding their visa and passport as recorded in the ERP system.

One row per person. SSN is masked.

Common

PERSON_SENSITIVE_RACE

Contains information pertaining to the race(s) of the person.

One per person per race.

Common

PERSON_SENSITIVE_RACE_SLOT

Contains information pertaining to the race(s) of the person.

One per person

Common

PERSON_SENSITIVE_UT

Contains person data that is considered sensitive information that can be secured and accessed only by authorized staff.

One row per person. SSN is masked.

Common

PERSON_UT

Contains demographic data common to a person across the ODS data model and the institution enterprise. The data is specific to a person independent of whether that person is a student, faculty member, or employee, alumnus, etc. Data reflects only the most current information; changes are not tracked in the ODS.

One row per person. SSN is masked.

Common

PREVIOUS_EDUCATION

Contains the data related to all secondary and post-secondary institutions a person has attended. This data may be used as admission criteria or when predicting success factors.

One row per person per institution.

Common

PREVIOUS_EDUCATION_SLOT

Uses data from the PREVIOUS_EDUCATION view, displays up to 3 sets of data pertaining to previous education in order of ascending degree date.

One row per person.

Common

SECONDARY_SCHOOL_SUBJECT

Contains the data associated with the classes taken by pre-students in high school. Typically these classes are used when processing an application.

One row per person per institution per subject.

Common

TELEPHONE

Contains all telephone data for an entity/person, organization or institution.

One row per entity per phone type per phone sequence number.

Common

TELEPHONE_PREFERRED

Contains the primary active telephone data associated with the preferred address of an entity/person, organization or institution.

One row per entity per phone type.

Common

VALIDATION

 

 

Common

YEAR_TYPE_DEFINITION

Contains the necessary information that ties each academic/aid period to a type of reporting year. This allows reporting by a type of year and provides the institution with a year map.

One row per year type per year code.

Faculty

FACULTY_APPOINTMENT_HISTORY

Provides historical information about faculty appointments.

One row per person per action date.

Faculty

FACULTY_ATT_SLOT

Uses data from the FACULTY_ATTRIBUTE reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of ATTRIBUTES and a delivered or institution defined internal code. Delivered internal codes of FACLATTR may be used independently by the institution.

One row per person per academic period per profile code per attribute rule.

Faculty

FACULTY_ATTRIBUTE

Contains the faculty attributes (instution assigned reporting values) associated with an insturctor or academic staff member. The attributes can be used to group faculty for reporting.

One row per person per academic period per faculty attribute.

Faculty

FACULTY_DEPARTMENT_COLLEGE

Contains institution organization association with the instructor or academic staff member by academic period. The details will include all college and department associates along with indication of the the home administrative college and or department, and the percentage responsibility for the home organization.

One row per person per academic period per college and or department combination.

Faculty

FACULTY_RANK_HISTORY

Provides historical information about faculty rankings.

One row per person per action date.

Faculty

FACULTY_SABBATICAL_HISTORY

Provides historical information about faculty sabbaticals.

One row per person per action date.

Faculty

FACULTY_TRACKING

Faculty Tracking contains a snapshot view of general faculty information combined with the most recent (if any) appointment, rank and sabbatical information

One row per person.

Faculty

NON_INSTRUCTIONAL_ASSIGNMENT

Contains detail data about the non-teaching assignments for an instructor that are used in calculating the instructor's workload. These details can be used with the instructional assignments to determine the faculty members total workload.

One row per person per academic period per non instructional type.

Faculty

NONINSTRUCT_ASSIGN_SLOT

Uses data from the NONINSTRUCT_ASSIGN reporting view. Displays up to 6 sets of values based on the defined display rule(s) with an internal group of FACULTY ASSIGNMENTS and a delivered or institution defined internal code. Delivered internal codes of FACLNIST may be used independently by the institution.

One row per person (instructor) per academic period per profile period per assignment rule.

Finance

ACCOUNT_HIERARCHY

Contains a list of all general ledger and operating ledger accounts with associated hierarchy levels, account type, internal account type, account class and account pool. Used to support roll up reporting.

One row per chart of accounts per account.

Finance

ACCOUNT_INDEX

Contains a list of all account index codes with their associated chart of accounts, effective dates, next change dates, fund codes, organization codes, account codes, program codes, activity codes, location codes, and override indicators.

One row per chart of accounts per account index per effective date per next change date.

Finance

BUDGET_AVAILABILITY_LEDGER

Contains summary and current amounts for adopted budget, budget adjustments, encumbrances, budget reservations, and remaining balances by budget control keys of fund, organization code, account, and program for a fiscal year and period. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, and program.

One row per chart of accounts per fiscal year and period per fund per organization code per account per program per commitment type.

Finance

ENCUMBRANCE

Contains encumbrance document number, type of encumbrance, encumbrance status, encumbrance posted date, encumbrance last change document, completion indicator, and approval indicator for the financial commitment.

One row per encumbrance document number.

Finance

ENCUMBRANCE_ACCOUNTING

Contains encumbrance document number, item, sequence number, accounting distirbution, and encumbrance status for the financial commitment.

One row per encumbrance document number per item per sequence number.

Finance

ENCUMBRANCE_LEDGER

Contains encumbrance ledger posted amounts for initial commitments, current adjustments, and current liquidations by fiscal year and period for each individual encumbrance document number and accounting distribution.

One row per encumbance document number per item per sequence number for each fiscal year and period.

Finance

ENCUMBRANCE_TEXT

Contains text lines associated with general encumbrances. 

One row per encumbrance document number per each line of text.

Finance

FOAPAL_NO_ATTRIBUTES

Contains a list of all accounting distribution elements that are not associated with a set code, or an attribute type, and/or an attribute value. This is used for exception reporting to assist in attaching reporting attributes to the various accounting distribution elements.

One row per chart of accounts per accounting distribution element.

Finance

FUND_HIERARCHY

Contains a list of all funds with associated hierarchy levels, fund type, internal fund type, fund pool, financial manager, termination date, and expenditure end dates. Used to support roll up reporting.

One row per chart of accounts per fund.

Finance

FUND_HIERARCHY_UT

Include only fund hierarchy related information. View is much faster than FUND_HIERARCHY.

One row per chart of accounts per fund.

Finance

GENERAL_LEDGER

Contains general ledger account/fund information for each fiscal year and period with period beginning and ending balances, and current actuals. Additional reporting can be by financial manager or the various hierarchy levels of the fund and account.

One row per chart of accounts per fiscal year per fund per account per fiscal period.

Finance

GRANT_BILLING_DETAIL

Contains details for billed and unbilled grant transactions. Reporting can be by grant, letter of credit, payment management system code, billing account distribution or document key, billing period date, and billing run and hold or release dates.

One row per document per document type per sequence number per item per submission number per fund per account class per account per reversal indicator.

Finance

GRANT_FUND

Contains all fund information associated to a grant as well as the general grant information. Multiple funds can be associated to one grant at any one point in time and/or over a period of time. Also lists grant indirect cost and cost share codes versus fund indirect cost and cost share codes.

One row per grant ID per chart of accounts per fund.

Finance

GRANT_FUND_SLOT

Uses data from the GRANT_FUND reporting view. Displays up to 10 fund codes assigned to a grant listed in order of descending termination date.

One row per grant ID.

Finance

GRANT_LEDGER

Contains grant ledger information representing inception to date amounts as well as current period amounts for adopted budgets, budget adjustments, actual activity, encumbrances, budget reservations, and remaining balance for each unique combination of accounting distribution. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.

One row per chart of accounts per grant ID per grant year per grant period per fund per organization code per account per program per activity per location.

Finance

GRANT_VIEW

Contains information defining the grant itself. The principal investigator, federal ID, sponsor number, agency and agency information with hierachy data, various amounts, responsible organization with hierarchy data, various dates, letter of credit number, payment management system code, location, type of grant, indirect cost and cost share codes.

One row per grant ID.

Finance

INVOICE

Contains general invoice and vendor information including invoice type, purchase order, vendor, vendor invoice number, third party information, one time vendor information, invoice date, payment due date, transaction date, cancel date, open paid indicator, and total approved amount.

One row per invoice.

Finance

INVOICE_ACCOUNTING

Contains general invoice accounting data including, purchase order, fiscal year/period, accounting distribution, bank, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.

One row per invoice per item per sequence number.

Finance

INVOICE_CHECK

Contains check payment information for each invoice including bank information, check type, check date, check net amount, cancel indicator, cancel date, and reconciliation date.

One row for invoice per check number per bank.

Finance

INVOICE_ITEM

Contains invoice items with purchase order, and commodity information. This includes each base and converted amount for unit price, taxes, discounts and additional charges as well as approved quantity.

One row per invoice per invoice item.

Finance

INVOICE_TAX_RATE

Contains tax rates, amounts, and rebates as it relates to the invoice at an item or accounting level. This includes who the tax should be paid to.

One row per invoice per item per sequence number per tax rate.

Finance

INVOICE_TAX_RATE_SLOT

Uses data from the INVOICE_TAX_RATE reporting view. Displays the last 8 tax rates, amounts and rebates applied to each invoice and item. 

One row per invoice per item listing up to 8 tax rates for each item.

Finance

LOCATION_HIERARCHY

Contains a list of all locations with associated hierarchy levels. Used to support roll up reporting.

One row per chart of accounts per location.

Finance

OPERATING_LEDGER

Contains summary and current amounts for adopted budget, budget adjustments, encumbrances, budget reservations, and remaining balances by accounting distribution for a fiscal year and period. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program and location.

One row per chart of accounts per fiscal year per fiscal period per fund per organization code per account per program per activity per location per commitment type. 

Finance

ORGANIZATION_HIERARCHY

Contains a list of all organization codes with associated hierarchy levels, organization pool, and financial manager. Used to support roll up reporting.

One row per chart of accounts per organization code.

Finance

ORGANIZATION_HIERARCHY_UT

iNclude only organization hierarchy related information. View is much faster than ORGANIZATION_HIERARCHY.

One row per chart of accounts per organization code.

Finance

PROGRAM_HIERARCHY

Contains a list of all programs with associated hierarchy levels. Used to support roll up reporting.

One row per chart of accounts per program.

Finance

TRANSACTION_HISTORY

Contains source transaction accounting distirbution history and ledger posting detail information. This includes the type of document, ledger indicator, which ledger field updated, rule process, rule class, document reference number, bank, vendor, budget period, and accounting distribution. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location. Used to reconcile the various ledgers and provide detail financial activity.

Multiple rows for each source financial transaction.

Financial Aid

APPLICANT_NEED

Contains detail data for the financial aid applicant's need information by aid year. Details will potentially include data loaded with calculations for total family contributions, gross need, cost of education and unmet need based on either a federal method or an institution method.

One row per person per aid year.

Financial Aid

AWARD_BY_FUND

Contains total amount of aid awarded by financial aid fund within an aid year. Detail data may include the aid year, academic period, financial aid fund, fund source, fund type, fund detail code, and federal financial aid fund identification code.

One row per aid year per fund.

Financial Aid

AWARD_BY_PERSON

Contains detail data for each person who was made an offer of a financial aid fund award within the aid year. Details may includes person, academic period, financial aid fund, fund source, fund type, fund detail code, award status, disbursement finalize indicator and award amount information.

One row per person per aid year and per fund.

Financial Aid

AWARD_DISBURSEMENT

Contains data regarding the award disbursements scheduled or posted for a person by financial aid fund and academic period. Details will include academic period, disbursement ID, disbursed date, scheduled date, disbursed amount, scheduled amount, disbursed percentage and disbursement load.

One row per person per aid year per disbursement ID or transaction number.

Financial Aid

FINAID_APPLICANT_STATUS

Contains data for the aid year and the person who has applied for financial aid for the aid year. Details may includes application locked indicator, budget group, administrative group, packaging group, tracking group, financial aid application status data, and budget type.

One row per aid year and person.

Financial Aid

FINAID_BUDGET_COMP_SLOT

Uses data from the FINAID_BUDGET_COMPONENT reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of BUDGET COMPS and a delivered or institution defined internal code. Delivered internal codes of FAPLBCMP may be used independently by the institution.

One row per person per aid year per profile code per component rule.

Financial Aid

FINAID_BUDGET_COMPONENT

Contains the budget component details for the person for the budget group assigned for the aid year. Details may include budget type, budget component amount, total budget.

One row per aid year per budget type per budget component per budget group per person.

Financial Aid

FINAID_ENROLLMENT

Contains details regarding the person's enrollment information by aid year and academic period that is used as the data for why an award had a financial aid disbursements. Data may include total anticipated credits, total actual credits, total billing credits, total freeze credits, total earned credits and total adjusted credits.

One row per aid year per academic period per person.

Financial Aid

FINAID_FUND

Contains data regarding a financial aid fund for an aid year. Details may includes fund source, fund type, fund detail code, federal financaial aid fund identification, need based indicator, budget allocated amount, transfer amount, prior balance, total allocated amount, original offered amounts, accepted amount, declined amount, canceled amount, authorized amount and memoed amount.

One row per aid year per fund.

Financial Aid

FINAID_TRACKING_REQUIREMENT

Contains detail data on the tracking requirements for a financial aid applicant for the aid year. Data may include requirement, satisfied indicator, status, waived reason disbursement requirement indicators and memo indicator, etc.

One row per aid year per person per requirement.

Financial Aid

GOVERNMENT_FA_FUND

Contains a set of common data identified for known governmental reporting regarding a financial aid fund. Detail data includes aid year, financial aid source type, financial aid type with reporting group for external or internal.

One row per aid year per academic period per financial aid source type per financial aid type per fund.

Financial Aid

GOVERNMENT_FINANCIAL_AID

Contains common data identified for known governmental reporting regarding financial aid students. Detail data may include academic period, student level, financial aid fund title or name, fund source type, financial aid type, offerred amount, accepted amount, declined amount, paid amount, disbursed amount, etc.

One row per aid year per academic period per fund per person.

Financial Aid

LOAN_APPLICATION

Contains data from a loan application submitted by a person for an aid year. Detail data may include loan application number, citizen indicator, alien registration number, driver's license number, addresses, phone numbers, and detailed loan data for various loans.

One row per aid year per loan application number.

Financial Aid

NEED_ANALYSIS

Contains data usually loaded from a federally supplied electronic media. Detail data will include all data collected regarding student need for the aid year and student. Data may include parental contribution, student contribution, interface tape code, application number, state/province of residence, and other need based data for doing needs analysis either using a federal or institution method of calculation.

One row per aid year per person per interface tape code per application number.

Financial Aid

SATISFACTORY_ACAD_PROGRESS

Contains data on the student's satisfactory academic progress for the aid year as defined by a federal standard for calculation. 

One row per person per aid year per academic period.

Financial Aid

TRACKING_REQUIREMENT_SLOT

Uses data from the FINAID_TRACKING_REQUIREMENT reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of TRACKING REQS and a delivered or institution defined internal code. Delivered internal codes of FAPLTREQ may be used independently by the institution.

One row per person per aid year per profile code per requirement rule.

Financial Aid

USER_DEFINED_FIELDS

Contains the data from the financial aid user-defined fields that may be populated by aid year for the person.

One row per aid year per person.

Human Resources

BARG_UNIT_SLOT

Uses data from the BARG_UNIT reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of BARGAINING UNIT and a delivered or institution defined internal code. Delivered internal codes of PAYRBARG may be used independently by the institution.

One row per person per profile code per bargaining unit rule.

Human Resources

BARGAINING_UNIT

Contains bargaining unit information related to an employee.

One row per person per bargaining unit per effective date.

Human Resources

BENEFICIARY_DEPENDENT

Contains employee beneficiary information.

One row per person per beneficiary per sequence number per relationship.

Human Resources

BENEFICIARY_SLOT

Uses data from the BENEFICIARY_DEPENDENT view, displays up to five sets of values pertaining to beneficiaries.

One row per person per carrier.

Human Resources

BENEFIT_DEDUCTION

Contains employee benefit deduction detail.

One row per person per carrier per effective date.

Human Resources

EMPL_EARN_CY_SLOT

Uses data from the EMPL_EARN_CY reporting view. Displays up to 8 sets of values based on the defined display rule(s) with an internal group of EARNING and a delivered or institution defined internal code. Delivered internal codes of PAYREARN may be used independently by the institution.

One row per entity per profile code per earning_rule.

Human Resources

EMPLOYEE

Contains current employee data.

One row per person.

Human Resources

EMPLOYEE_EARNING_CY

Contains earnings information for the employee for the calendar year..

One row per person per position per job suffix per calendar year per earnings.

Human Resources

EMPLOYEE_EARNING_FY

Contains earnings information for the employee for the fiscal year.

One row per person per position per job suffix per employer per fiscal year per quarter per month per earnings.

Human Resources

EMPLOYEE_POSITION

Contains assignment details for an employee's current and historical positions.

One row per person per position per job suffix.

Human Resources

LABOR_COST_DISTRIBUTION

Contains all labor distribution information pertaining to an employee's positions.

One row per person per position per job suffix per effective date.

Human Resources

LEAVE_ACCRUAL

Contains leave accrual information specific to each payroll.

One row per payroll identifier per calendar year per payroll number per leave per person or one row per payroll identifier per calendar year per payroll number per leave per position (depending on whether the value in mpt_leave_accrual_position_accrual_indicator = N or Y)

Human Resources

LEAVE_BALANCE

Contains leave balance information for the employee.

One row per person per leave.

Human Resources

LEAVE_BALANCE_SLOT

Uses data from the LEAVE_BALANCE reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of LEAVE and a delivered or institution defined internal code. Delivered internal codes of PAYRLEAV may be used independently by the institution.

One row per person per profile code per leave balance rule.

Human Resources

PAYROLL_DISTRIBUTION

Contains organization payroll distribution information specific to each payroll.

One row per payroll identifier per calendar year per payroll number per event sequence number per person per transaction number.

Human Resources

PAYROLL_DOCUMENT_UT

Contains payroll document (check and direct deposit) information specific to each payroll. Sensitve bank routing numbers are masked.

One row per payroll identifier per calendar year per payroll number per event sequence number per person. (In cases where a direct deposit is split amongst two or more accounts, a unique row would be created for each bank account number to which pay is depositied).

Human Resources

PAYROLL_EARNING

Contains earnings information specific to each payroll.

One row per payroll identifier per calendar year per payroll number per event sequence number per position per shift per earning per person.

Human Resources

PAYROLL_EMPLOYEE_POSITION

Contains payroll history and related job history information specific to each payroll.

One row per payroll identifier per calendar year per payroll number per event sequence number per position per job suffix per shift number per person.

Human Resources

POSITION_BUDGET

Contains information pertaining to the funding of the position.

One row per position per fiscal year per budgeted organization per budget per budget phase per effective date.

Human Resources

POSITION_DEFINITION

Contains detailed information concerning available positions.

One row per position.

Human Resources

POSITION_LABOR_DISTRIBUTION

Contains labor distribution information for the position.

One row per position per labor distribution per fiscal year.

Human Resources

POSN_LABOR_DIST_SLOT

Uses data from the POSITION_LABOR_DISTRIBUTION view, displays up to ten sets of values pertaining to ledger accounts.

One row per position per fiscal year.

Human Resources

TAX

Contains detailed employee tax information.

One row per person per tax deduction per effective date.

Medical

MEDICAL_INFORMATION

Contains the detailed medical data for a person who has a disability.

One row per person per disability.

Medical

MEDICAL_INFORMATION_SLOT

Uses data from the MEDICAL_INFORMATION reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of MEDICAL and a delivered or institution defined internal code. Delivered internal codes of STDNMEDI may be used independently by the institution.

One row per person per profile code per medical rule.

Payroll

MONTHLY_DEDUCT_SLOT

Uses data from the MONTHLY_DEDUCTION view, displays 12 months of employee and employer deductions from payroll and summarizes those amounts by quarter.

One row per person per payroll deduction year per carrier.

Payroll

MONTHLY_DEDUCTION

Contains monthly details regarding all employee deductions.

One row per person per employer per payroll deduction month per payroll deduction year per carrier.

Payroll

PAYROLL_DEDUCTION

Contains payroll deduction information specific to each payroll..

One row per payroll identifier per calendar year per payroll number per event sequence number per deduction per person.

Payroll

PAYROLL_DOCUMENT

Contains payroll document (check and direct deposit) information specific to each payroll.

One row per payroll identifier per calendar year per payroll number per event sequence number per person. (In cases where a direct deposit is split amongst two or more accounts, a unique row would be created for each bank account number to which pay is depositied).

Payroll

YEARLY_DEDUCTION

Contains summarized payroll deduction information for each quarter and year-to-date (YTD).

One row per person per year per carrier.

Registrar

ACADEMIC_OUTCOME

Contains data about all awards sought and/or earned by a student. Details includes program of academic study, majors, degree GPA, total credits earned, institutional and departmental honors, etc. To see only the awarded academic outcomes use GOVERNMENT_ACADEMIC_OUTCOME.

One row per person per outcome number.

Registrar

ACADEMIC_OUTCOME_SLOT

Uses data from the ACADEMIC_OUTCOME reporting view. Displays up to 3 sets of values based on the student level. Currently, there are no associated display rules so the three last academic outcomes brought into the ODS tables will be displayed.

One row per person per student level.

Registrar

GPA

Contains detail data for any type of student grade point average (GPA) or Average. Details include all the data required to calculate different types of GPAs. The current data loaded includes only overall level (undergraduate, graduate), academic period GPA information.

One row per person per GPA time indicator (time based or not) per GPA group (cummulative or period) per academic study area (level) per GPA type (institution or transfer) per academic period.

Registrar

GPA_BY_LEVEL

Contains grade point average or average details for a person by student level of academic study. Details include the component data used to calculate the GPA..

One row per person per academic study area (level).

Registrar

GPA_BY_TERM

Contains grade point average or average details for a person by academic period. Details include the component data used to calculate the GPA..

One row per person per academic period.

Registrar

STUDENT_COURSE

Contains detail data for student courses recorded in the system. Courses taken by the studen maybe registered (in progress course), graded (institutional history), and transfered (transfer credit granted) courses. This reporting view shows all courses associated with the student in a single reporting view. Indicators permit the report user to identify groupings of courses for selected reporting needs.

One row per person per academic period per subject and course number.

Registrar

STUDENT_COURSE_GRADE_CHANGE

Contains all details and history of the grade changes for the subject or course completed by the student. Data includes the grade change reason and date so that analytical and statistical reporting on grades can be done.

One row per person per academic period per subject and course number per final grade sequence number.

Registrar

VISA

Contains information pertaining to visa's.

One row per person per visa type per visa number.

Registrar

VISA_CURRENT

Contains current visa information.

One row per person per visa type per visa number.

Secure

PERSON

Contains demographic data common to a person across the ODS data model and the institution enterprise. The data is specific to a person independent of whether that person is a student, faculty member, or employee, alumnus, etc. Data reflects only the most current information; changes are not tracked in the ODS.

One row per person.

Secure

PERSON_DETAIL

Contains demographic data common to a person across the ODS data model and the institution enterprise. The data is specific to a person independent of whether that person is a student, faculty member, or employee, alumnus, etc. Data reflects only the most current information; changes are not tracked in the ODS.

One row per person.

Secure

PERSON_INTERNATIONAL

Contains international student information, as well as information regarding their visa and passport as recorded in the ERP system.

One row per person.

Secure

PERSON_SENSITIVE

Contains person data that is considered sensitive information that can be secured and accessed only by authorized staff.

One row per person.

Secure

PERSON_VETERAN

Contains information on persons' who are veterans as indicated in the ERP system.

One row per person.

Student

ACADEMIC_STUDY

Contains data for each program/curriculum in which the student is considered an active student and the student is permitted to enroll for the academic period. A student will have one record for each different academic study recorded for the person.

One row per person per academic period per primary program indicator.

Student

ADVISOR

Contains data about the advisors assigned to a person. Details include advisor type description and the primary advisor identification.

One row per person per academic period per advisor.

Student

ADVISOR_SLOT

Uses data from the ADVISOR reporting view. Displays up to 2 sets of values based on the person advisor relationship and academic period. Currently there are no associated display rules.

One row per person per academic period.

Student

COURSE_ATT_SLOT

Uses data from the COURSE_ATTRIBUTE reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of ATTRIBUTES and a delivered or institution defined internal code. Delivered internal codes of CRSEATTR may be used independently by the institution.

One row per subject and course number per profile code per attribute rule.

Student

COURSE_ATTRIBUTE

Contains data about attributes associated with a course or offering. These attributes are used to identify characteristics of the course. For example, first year, second year, writing skill, science lab, computer skill, etc.

One row per subject and course number per academic period per course attribute.

Student

COURSE_CATALOG

Contains details for a subject (course) offered as part of the instruction in an academic study program. Details tracked will be specific to each academic period for which the subject could be offered. Academic periods will end when the course has an end academic period or when the status associated with the subject makes it not available to be scheduled.

One row per subject and course number per academic period in which the course was active.

Student

COURSE_COREQ

Contains data about a course identification (subject and course number) for the corequisite that must be taken in the same academic period as the subject and course number for which this record.

One row per subject and course number per academic period per course identification for the corequisite.

Student

COURSE_LEVEL

Contains data about the type of credit can be earned for a course. For example, the levels might be Undergraduate, Graduate, Credit, Apprenticeship, etc. This would permit the reporting of which student level transcripts this course can appear.

One row per subject and course number per academic period per course level.

Student

COURSE_LEVEL_SLOT

Uses data from the COURSE_LEVEL reporting view. Displays up to 4 sets of values based on the course levels recorded for the course identification for the academic period.

One row per course identification per academic period.

Student

COURSE_PREREQ

Contains data about a course identification (subject and course number) for the prerequisite that must be taken in a previous academic period as the subject and course number for which this is recorded. Details include whether it may alternatively be taken in the same academic period.

One row per subject and course number per academic period per course identification for the prerequisite.

Student

COURSE_PREREQ_COMBINED

Contains data about a course identification (subject and course number) for the prerequisite that must be taken in a previous academic period as the subject and course number for this record. Details include whether it may alternatively be taken in the same academic period. Data will be presented combining all prerequisite conditions into a single text string opposed to the individula rows in teh COURSE_PREREQ.

One row per subject and course number per academic period per course identification (subject and course number).

Student

COURSE_SCHEDULE

Contains details of the offering delivery type (lecture, lab, internet, etc) and its weight in calculating the instructor's work load.

One row per subject and course number per academic period per schedule.

Student

COURSE_SCHEDULE_SLOT

Uses data from the COURSE_SCHEDULE reporting view. Displays up to 4 sets of values based on the defined display rule(s) with an internal group of SCHEDULE TYPE and a delivered or institution defined internal code. Delivered internal codes of CRSESCHD may be used independently by the institution.

One row per subject and course number per adacemic period per profile code per schedule rule.

Student

ENROLLMENT

Contains enrollment data for those persons with registration activity in an academic period. Note the persons permitted register who may or may not have a row in ENROLLMENT can be obtained using the STUDENT reportiing view. All active and permited to register persons will have program or curriculum will have a row in the ACADEMIC STUDY reporting view.

One row per person per academic period enrolled.

Student

FACULTY

Contains detail information from the student administration arena for the academic staff member. The staff members assignments can be viewed and reported using the INSTRUCTIONAL ASSIGNMENT and NON INSTRUCTIONAL ASSIGNMENT reporting view.

One row per faculty member per academic period.

Student

FIELD_OF_STUDY

Audit trail of all fields of study assigned to a curricula for a student or learner.

One row per occurrence of field of study per curricula per student or learner.

Student

GOVERNMENT_ACADEMIC_OUTCOME

Contains the common data required for government reporting on the number of academic outcomes completed for the time frame. Contain only the academic period and person who have completed an academic study (award, degree, certificate, etc.). This reporting view may be joined with other reporting views for external and or internal report requirements.

One row per person per academic period per outcome number.

Student

GOVERNMENT_COURSE

Contains common data on course registration used for government reporting. Details are included for the courses (subjects) that are registered or in progress (where the course is count in enrolled and not be deducted from the counts) for the academic period reported. It may be joined with other reporting views required for external or internal reporting requirements.

One row per person per academic period per subject and course number.

Student

GOVERNMENT_STUDENT

Contains data for enrolled students required for government reporting. Details are included only for those persons who have a row in ENROLLMENT for the academic period reported. This reporting view with other reporting views to meet external or internal reporting requirements.

One row per person per academic period.

Student

INSTRUCT_ASSIGN_SLOT

Uses data from the INSTRUCTIONAL ASSIGNMENT reporting view. Displays up to 3 sets of values when more than one instructor is assigned to a course reference number. Currently there are no associated display rules.

One row per course reference number per academic period per instructor assigned.

Student

INSTRUCTIONAL_ASSIGNMENT

Contains all instructor assignments for scheduled offerings of a course (subject) for the academic period or faculty contract time frame. Details include faculty human resource position and job suffix, percent responsibility, etc. These details can be used with the no instructional assignments to determine the faculty members total workload.

One row per person per academic period per course reference number.

Student

MEETING_TIME

Contains details for the section meeting dates, days, times, buildings and rooms.

One row per course reference number per academic period per meeting time combination.

Student

MEETING_TIME_SLOT

Uses data from the MEETING TIME reporting view. Displays up to 10 sets of values when more than one meeting time exists for a course reference number. Details include the meeting dates, days, times, building and room number. Currently there are no associated display rules.

One row per course reference number per academic period.

Student

OFFERING_COREQ

Contains course reference number section specific corequisite data for two or more subject and course numbers that must be taken in the same academic period.

One row per academic period per course reference number per course reference number corequisite.

Student

OFFERING_GRADE_TYPE

Contains grade options or types of grades available for this schedule offering (section). This data will be either a specific grade type specified for the section or one or more values permited for the course identification from the course catalog.

One row per academic period per course reference number per grade type.

Student

OFFERING_PREREQ

Contains data about a section that either uses the data defined for the course identification (subject and course number) or overridden for this course reference number as the set of prerequisite that must be satisfied prior to registering for this schedule offering (section). Details include whether it may alternatively be taken in the same academic period.

One row per academic period per course reference number per prerequisite course identification.

Student

OUTCOME_HONOR

Contains details regarding honors granted either by the institution or by a department of the institution to a person for a qualifying academic outcome (award, degree, certificate, etc.).

One per person per outcome number per honor.

Student

OUTCOME_INSTITUTIONAL_HONOR

Contains details regarding honors granted by the institution to a person for a qualifying academic outcome (award, degree, certificate, etc.).

One per person per outcome number per honor.

Student

SCHEDULE_ATTRIBUTE

Contains data about attributes associated with a schedule offering. These attributes are used to identify characteristics of the section or offering. For example, first year, second year, writing skill, science lab, computer skill, etc.

One row per academic period per course reference number and schedule attribute.

Student

SCHEDULE_OFFERING

Contains detail data for a section (schedule offering) of a subject or course within a specific time period like an academic period.

One row per course reference number per academic period and sub academic period.

Student

SPORT

Contains data regarding persons who are involved in official institution sports activities and need to be tracked within the system. For example, the NCAA details required for reporting on students participating in the sport are accessed using this reporting view.

One row per person per academic period per activity.

Student

SPORT_SLOT

Uses data from the SPORT reporting view. Displays up to 5 sets of values based on the sport activities recorded for the academic period. There are currently no sequence rules available for this repeating view.

One row per person per academic period.

Student

STUDENT_UT

Contains data for the student for the academic period that will not be different when the person is admitted to more than one academic study within the timeframe. Includes indicators reflecting student current status in several important groupings to make reporting groups easier for the reporting user. Details include whether the current student status at the institution will permit the student to enroll or if the student is a new admit in the academic period.

One row per person per academic period.

Student

STUDENT_ACTIVITY

Contains data about activities associated with a person within a time frame. Details include other codes that permit the activites to be grouped different ways for reporting purposes like activity type and activity category.

One row per person per academic period per activity.

Student

STUDENT_ATTRIBUTE

Contains characteristics to be tracked within the system for the student. Data tracked will assist in grouping the students for reporting purposes.

One row per person per academic period per student attribute.

Student

STUDENT_COHORT

Contains data that identifies thestudent as a member of a group to be tracked within the system with their anticipated start and end academic period. This information is used for special reporting.

One row per person per academic period per cohort.

Student

STUDENT_COHORT_SLOT

Uses data from the STUDENT_COHORT reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of COHORT and a delivered or institution defined internal code. Delivered internal codes of STDNCHRT may be used independently by the institution.

One row per person per academic period start and academic period end per profile code per cohort rule.

Student

STUDENT_COURSE_ATT_SLOT

Uses data from the STUDENT_COURSE_ATTRIBUTE reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of ATTRIBUTES and a delivered or institution defined internal code. Delivered internal codes of HISTATTR may be used independently by the institution.

One row per person per academic period per course sequence number per profile code per attribute rule.

Student

STUDENT_COURSE_ATTRIBUTE

Contains data about the student course attributes associated with a subject and course number completed by the person. Reporting requirements for these student course attributes include grouping the courses to complete specific academic completion requirements and reporting on those.

One row per person per academic period per subject and course number per course attribute.

Student

STUDENT_COURSE_REG_AUDIT

Contains audit information for all student registration activity.

One row per sequence number per course request number per student per academic period.

Student

STUDENT_COURSE_UT

Grade information is masked. Contains detail data for student courses recorded in the system. Courses taken by the studen maybe registered (in progress course), graded (institutional history), and transfered (transfer credit granted) courses. This reporting view shows all courses associated with the student in a single reporting view. Indicators permit the report user to identify groupings of courses for selected reporting needs.

One row per person per academic period per subject and course number.

Student

STUDENT_WORK_EXPERIENCE

Contains details of any student work experienc completed as a portion of their academic study. This will include but not be limited to cooperative education, internship, apprenticeship, sandwich courses and detail information regarding each experience.

One row per person per student level per academic period per work experience employer.

Last Updated: 1/4/12