Reporting View Target: EXEMPTION

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

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 Name Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD 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 Academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

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

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

ADMINISTRATIVE_GROUP 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 Paid Amount credited to the student account or charged to the contract or exemption. NUMBER
FUNCTION

TOKODSF.F_AMOUNT_PAID

AUTHORIZED_AMOUNT Authorized Amount Maximum amount authorized for a student. NUMBER
TBBESTU

TBBESTU_MAX_STUDENT_AMOUNT

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

TBBEXPT_DETAIL_CODE

DETAIL_CODE_DESC Detail Code Description Transaction type description. VARCHAR2(255)
TBBDETC

TBBDETC_DESC

END_DATE End Date End date for the academic period. DATE
STVTERM

STVTERM_END_DATE

EXEMPTION 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 Exemption Cancelled Indicator 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 Exemption description. VARCHAR2(255)
TBBEXPT

TBBEXPT_DESC

EXEMPTION_PAYMENT_CODE Exemption Payment Code Exemption payment code. VARCHAR2(63)
TBBEXPT

TBBEXPT_DETAIL_CODE

EXEMPTION_PAYMENT_DESC Exemption Payment Description Exemption payment code description. VARCHAR2(255)
TBBDETC

TBBDETC_DESC

EXEMPTION_PRIORITY 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 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 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 Exp Academic Period Description Expiration academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

EXP_DATE Exp Date Extracts date this term ends. DATE
STVTERM

STVTERM_END_DATE

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

NA

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

NA

PERSON_FULL_NAME Person Full Name Person's full name. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_ID Person ID Person's identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

TBBESTU_PIDM

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

NA

START_DATE Start Date Extracts start date for this term. DATE
STVTERM

STVTERM_START_DATE

STUDENT_EXEMPTION_ROLL_IND Student Exemption Roll Indicator 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 Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)
NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description A session, portion or part of the academic period. VARCHAR2(255)
NA

NA

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

TBBESTU_USER_ID

Ver: 9.2

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 Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	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	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	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 Paid	Amount credited to the student account or charged to the contract or exemption.	NUMBER	FUNCTION	TOKODSF.F_AMOUNT_PAID
AUTHORIZED_AMOUNT	Authorized Amount	Maximum amount authorized for a student.	NUMBER	TBBESTU	TBBESTU_MAX_STUDENT_AMOUNT
DETAIL_CODE	Detail Code	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TBBEXPT	TBBEXPT_DETAIL_CODE
DETAIL_CODE_DESC	Detail Code Description	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
END_DATE	End Date	End date for the academic period.	DATE	STVTERM	STVTERM_END_DATE
EXEMPTION	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	Exemption Cancelled Indicator	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	Exemption description.	VARCHAR2(255)	TBBEXPT	TBBEXPT_DESC
EXEMPTION_PAYMENT_CODE	Exemption Payment Code	Exemption payment code.	VARCHAR2(63)	TBBEXPT	TBBEXPT_DETAIL_CODE
EXEMPTION_PAYMENT_DESC	Exemption Payment Description	Exemption payment code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
EXEMPTION_PRIORITY	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	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	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	Exp Academic Period Description	Expiration academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
EXP_DATE	Exp Date	Extracts date this term ends.	DATE	STVTERM	STVTERM_END_DATE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_FULL_NAME	Person Full Name	Person's full name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_ID	Person ID	Person's identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	TBBESTU	TBBESTU_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
START_DATE	Start Date	Extracts start date for this term.	DATE	STVTERM	STVTERM_START_DATE
STUDENT_EXEMPTION_ROLL_IND	Student Exemption Roll Indicator	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	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	A session, portion or part of the academic period.	VARCHAR2(255)	NA	NA
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	TBBESTU	TBBESTU_USER_ID