Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Accounts Receivable Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: EXEMPTION

Description Contains student exemption information including academic period, account ID, exemption priority, exemption, authorized amount, amount paid, exemption payment code, detail code, and expiration date.
Key & Frequency One row per person per academic period per exemption priority.
Recommended Search Columns PERSON_UID, EXEMPTION
EXEMPTION, START_DATE, END_DATE, PERSON_UID
ACADEMIC_PERIOD, PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)

TBBEXPT

TBBEXPT_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AMOUNT_PAID Amount credited to the student account or charged to the contract or exemption. NUMBER

FUNCTION

TOKODSF.F_AMOUNT_PAID

AUTHORIZED_AMOUNT Maximum amount authorized for a student. NUMBER

TBBESTU

TBBESTU_MAX_STUDENT_AMOUNT

DETAIL_CODE Code defining type of transaction in accounts receivable. VARCHAR2(63)

TBBEXPT

TBBEXPT_DETAIL_CODE

DETAIL_CODE_DESC Transaction type description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

END_DATE End date for the academic period. DATE

STVTERM

STVTERM_END_DATE

EXEMPTION Priority of this exemption for the student, if the student is authorized for more than one exemption. VARCHAR2(63)

TBBESTU

TBBESTU_EXEMPTION_CODE

EXEMPTION_CANCELLED_IND Indicates that the exemption was cancelled after initial processing and updates were made for the account holder within accounts receivable. VARCHAR2(1)

CALCULATION

DECODE(TBBESTU_DEL_IND)

EXEMPTION_DESC Exemption description. VARCHAR2(255)

TBBEXPT

TBBEXPT_DESC

EXEMPTION_PAYMENT_CODE Exemption payment code. VARCHAR2(63)

TBBEXPT

TBBEXPT_DETAIL_CODE

EXEMPTION_PAYMENT_DESC Exemption payment code description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

EXEMPTION_PRIORITY Indicates the priority of this contract for the student, if the student is authorized for more than one contract. NUMBER

TBBESTU

TBBESTU_EXEMPTION_PRIORITY

EXEMPTION_RULE_ROLL_IND Indicates if the exemption can be rolled to a new academic period. VARCHAR2(1)

TBBEXPT

TBBEXPT_EXEMPTION_ROLL_IND

EXP_ACADEMIC_PERIOD Expiration academic period - the last academic period when the person is rolled forward associated with the exemption. VARCHAR2(63)

TBBESTU

TBBESTU_TERM_CODE_EXPIRATION

EXP_ACADEMIC_PERIOD_DESC Expiration academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

EXP_DATE Extracts date this term ends. DATE

STVTERM

STVTERM_END_DATE

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PERSON_FULL_NAME Person's full name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_ID Person's identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

TBBESTU

TBBESTU_PIDM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

START_DATE Extracts start date for this term. DATE

STVTERM

STVTERM_START_DATE

STUDENT_EXEMPTION_ROLL_IND Indicates if the student will roll with the exemption to a new academic period. VARCHAR2(1)

TBBESTU

TBBESTU_STUDENT_EXPT_ROLL_IND

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC A session, portion or part of the academic period. VARCHAR2(255)

NA

NA

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

TBBESTU

TBBESTU_USER_ID



Ver: 8.5