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. |