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

Banner Operational Data Store
Composite View Target: AT_CONTRACT

Description Source composite view contains accounts receivable third party contract information.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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(6)

TBBCSTU

TBBCSTU_TERM_CODE

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

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

STVTERM

STVTERM_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

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

FUNCTION

TOKODSF.F_AMOUNT_PAID

NO

NO
AUTHORIZED_IND Indicates whether a student is preauthorized, authorized, or unauthorized to use a contract. VARCHAR2(1)

TBBCSTU

TBBCSTU_AUTH_IND

NO

NO
AUTHORIZED_NUMBER Third party issued number authorizing the student to be covered under a contract. VARCHAR2(30)

TBBCSTU

TBBCSTU_AUTH_NUMBER

NO

NO
CONTRACT_ACTIVITY_DATE Date record was inserted or updated. DATE

TBBCSTU

TBBCSTU_ACTIVITY_DATE

NO

NO
CONTRACT_DATA_ORIGIN Source system that last created or updated the data. VARCHAR2(30)

TBBCSTU

TBBCSTU_DATA_ORIGIN

NO

NO
CONTRACT_DESC Free-format description of the third party contract for the academic period. VARCHAR2(30)

TBBCONT

TBBCONT_DESC

NO

NO
CONTRACT_EXP_ACAD_PERIOD Contract expiration academic period - the last academic period the contract is rolled forward by the roll process. VARCHAR2(6)

TBBCONT

TBBCONT_TERM_CODE_EXPIRATION

NO

NO
CONTRACT_EXP_ACAD_PERIOD_DESC Academic period or term code description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
CONTRACT_EXP_DATE Extracts date this term ends. DATE

STVTERM

STVTERM_END_DATE

NO

NO
CONTRACT_NEGOTIATED_ID Identification number for the individual who negotiated the contract. VARCHAR2(0)

NA

NA

NO

NO
CONTRACT_NEGOTIATED_NAME Name of the individual who negotiated the contract. VARCHAR2(0)

NA

NA

NO

NO
CONTRACT_NUMBER Contract number associated with the third party for the academic period. NUMBER

TBBCSTU

TBBCSTU_CONTRACT_NUMBER

NO

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

TBBCSTU

TBBCSTU_CONTRACT_PRIORITY

NO

NO
CONTRACT_RULE_ROLL_IND Indicates if the contract can be rolled to a new academic period. VARCHAR2(1)

TBBCONT

TBBCONT_CONTRACT_ROLL_IND

NO

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

NA

SYSDATE

NO

NO
DETAIL_CODE_CHARGE Code defining type of transaction in accounts receivable to be posted as the charge against the third-party account. VARCHAR2(4)

TBBCONT

TBBCONT_DETAIL_CHG_CODE

NO

NO
DETAIL_CODE_CHARGE_DESC Transaction type description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

NO

NO
DETAIL_CODE_PAY Code defining type of transaction in accounts receivable to be posted as the third-party credit on the student's account. VARCHAR2(4)

TBBCONT

TBBCONT_DETAIL_PAY_CODE

NO

NO
DETAIL_CODE_PAY_DESC Transaction type description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
END_DATE End date for the academic period. DATE

NA

NA

NO

NO
MAX_AMOUNT_FROM_THIRD_PARTY Maximum third party amount for this contract. NUMBER

TBBCSTU

TBBCSTU_MAX_STUDENT_AMOUNT

NO

NO
MAX_NUMBER_STUDENTS Maximum number of students for this contract. NUMBER

NA

NA

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
MIN_AMOUNT_FROM_THIRD_PARTY Minimum third party amount for this contract. NUMBER

NA

NA

NO

NO
MIN_NUMBER_STUDENTS Minimum number of students for this contract. NUMBER

NA

NA

NO

NO
PERSON_EXP_ACAD_PERIOD Person expiration academic period - the last academic period when a person is rolled forward associated with a contract by the roll process. VARCHAR2(6)

TBBCSTU

TBBCSTU_TERM_CODE_EXPIRATION

NO

NO
PERSON_EXP_ACAD_PERIOD_DESC Person's expiration academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
PERSON_EXP_DATE Extracts date this term ends. DATE

STVTERM

STVTERM_END_DATE

NO

NO
PERSON_MAX_AMOUNT_AUTHORIZED Maximum amount authorized for a student. NUMBER

TBBCSTU

TBBCSTU_MAX_STUDENT_AMOUNT

NO

NO
PERSON_MAX_AMOUNT_PAID Maximum amount paid by the student. NUMBER

TBBCSTU

TBBCSTU_MAX_STUDENT_AMOUNT

NO

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

TBBCSTU

TBBCSTU_STU_PIDM

NO

NO
SPONSOR_REFERENCE_NUMBER Sponsor reference number. VARCHAR2(30)

TBBCSTU

TBBCSTU_SPONSOR_REF_NUMBER

NO

NO
START_DATE Extracts start date for this term. DATE

STVTERM

STVTERM_START_DATE

NO

NO
STUDENT_CONTRACT_ROLL_IND Indicates if the student will roll with the contract to a new academic period. VARCHAR2(1)

TBBCSTU

TBBCSTU_STUDENT_CONT_ROLL_IND

NO

NO
STUDENT_INACTIVATED_IND Indicates if the student should be removed from the contract. VARCHAR2(1)

CALCULATION

DECODE(TBBCSTU_DEL_IND)

NO

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

NA

NA

NO

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

NA

NA

NO

NO
THIRD_PARTY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

TBBCONT

TBBCONT_PIDM

NO

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

TBBCSTU

TBBCSTU_USER_ID

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: