Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AT_EXEMPTION

Description Source composite view contains accounts receivable exemption information.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD Academic period associated with the exemption.    

TBBESTU

TBBESTU_TERM_CODE

 
ACADEMIC_PERIOD_DESC Academic period description.    

STVTERM

STVTERM_DESC

 
ACADEMIC_YEAR Academic year associated with the academic period on this record.    

STVTERM

STVTERM_ACYR_CODE

 
ACADEMIC_YEAR_DESC Academic year description.    

STVACYR

STVACYR_DESC

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

FUNCTION

TOKODSF.F_AMOUNT_PAID

 
AUTHORIZED_AMOUNT Maximum amount authorized for a student.    

TBBESTU

TBBESTU_MAX_STUDENT_AMOUNT

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DETAIL_CODE Code defining type of transaction in accounts receivable.    

TBBEXPT

TBBEXPT_DETAIL_CODE

 
DETAIL_CODE_DESC Transaction type description.    

TBBDETC

TBBDETC_DESC

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
END_DATE End date for the academic period.    

STVTERM

STVTERM_END_DATE

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

TBBESTU

TBBESTU_EXEMPTION_CODE

 
EXEMPTION_ACTIVITY_DATE Date record was inserted or updated.    

TBBESTU

TBBESTU_ACTIVITY_DATE

 
EXEMPTION_CANCELLED Indicates if the student should be removed from the exemption.    

CALCULATION

DECODE(TBBESTU_DEL_IND)

 
EXEMPTION_DESC Exemption description.    

TBBEXPT

TBBEXPT_DESC

 
EXEMPTION_PAYMENT_CODE Exemption payment code.    

TBBEXPT

TBBEXPT_DETAIL_CODE

 
EXEMPTION_PAYMENT_DESC Exemption payment code description.    

TBBDETC

TBBDETC_DESC

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

TBBESTU

TBBESTU_EXEMPTION_PRIORITY

 
EXEMPTION_RULE_ROLL_IND Indicates if the exemption can be rolled to a new academic period.    

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.    

TBBESTU

TBBESTU_TERM_CODE_EXPIRATION

 
EXP_ACADEMIC_PERIOD_DESC Expiration academic period description.    

STVTERM

STVTERM_DESC

 
EXP_DATE Extracts date this term ends.    

STVTERM

STVTERM_DESC

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

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

TBBESTU

TBBESTU_PIDM

 
START_DATE Extracts start date for this term.    

STVTERM

STVTERM_START_DATE

 
STUDENT_EXEMPTION_ROLL_IND Indicates if the student will roll with the exemption to a new academic period.    

TBBESTU

TBBESTU_STUDENT_EXPT_ROLL_IND

 
SUB_ACADEMIC_PERIOD A session, portion or part of the academic period.    

NA

NA

 
SUB_ACADEMIC_PERIOD_DESC A session, portion or part of the academic period.    

NA

NA

 
USER_ID Unique identification code of the user who entered or last touched the transaction.    

TBBESTU

TBBESTU_USER_ID

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3