Reporting View Target: CONTRACT

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

Banner Operational Data Store
Reporting View Target: CONTRACT

Description 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.
Key & Frequency One row per academic period per person per contract priority.
Recommended Search Columns PERSON_UID
ACADEMIC_PERIOD, THIRD_PARTY_UID, CONTRACT_NUMBER
ACADEMIC_PERIOD, PERSON_UID, CONTRACT_NUMBER

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)
TBBCSTU

TBBCSTU_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_IND Authorized Indicator Indicates whether a student is preauthorized, authorized, or unauthorized to use a contract. VARCHAR2(1)
TBBCSTU

TBBCSTU_AUTH_IND

AUTHORIZED_NUMBER Authorized Number Third party issued number authorizing the student to be covered under a contract. VARCHAR2(63)
TBBCSTU

TBBCSTU_AUTH_NUMBER

CONTRACT_ACTIVITY_DATE Contract Activity Date Date that information for this record in the table was entered or last updated. DATE
TBBCSTU

TBBCSTU_ACTIVITY_DATE

CONTRACT_DATA_ORIGIN Contract Data Origin Source system that last created or updated the data. VARCHAR2(63)
TBBCSTU

TBBCSTU_DATA_ORIGIN

CONTRACT_DESC Contract Description Free-format description of the third party contract for the academic period. VARCHAR2(255)
TBBCONT

TBBCONT_DESC

CONTRACT_EXP_ACAD_PERIOD Contract Exp Acad Period Contract expiration academic period - the last academic period the contract is rolled forward by the roll process. VARCHAR2(63)
TBBCONT

TBBCONT_TERM_CODE_EXPIRATION

CONTRACT_EXP_ACAD_PERIOD_DESC Contract Exp Acad Period Description Academic period or term code description. VARCHAR2(255)
STVTERM

STVTERM_DESC

CONTRACT_EXP_DATE Contract Exp Date Extracts date this term ends. DATE
STVTERM

STVTERM_END_DATE

CONTRACT_NEGOTIATED_ID Contract Negotiated ID Identification number for the individual who negotiated the contract. VARCHAR2(255)
NA

NA

CONTRACT_NEGOTIATED_NAME Contract Negotiated Name Name of the individual who negotiated the contract. VARCHAR2(255)
NA

NA

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

TBBCSTU_CONTRACT_NUMBER

CONTRACT_PRIORITY 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

CONTRACT_RULE_ROLL_IND Contract Rule Roll Indicator Indicates if the contract can be rolled to a new academic period. VARCHAR2(1)
TBBCONT

TBBCONT_CONTRACT_ROLL_IND

COURSES_COVERED_COUNT Courses Covered Count Count of courses covered for payment by this contract. NUMBER
NA

NA

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

TBBCONT_DETAIL_CHG_CODE

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

TBBDETC_DESC

DETAIL_CODE_PAY 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(63)
TBBCONT

TBBCONT_DETAIL_PAY_CODE

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

TBBDETC_DESC

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

NA

MAX_AMOUNT_FROM_THIRD_PARTY Maximum Amount From Third Party Maximum third party amount for this contract. NUMBER
TBBCSTU

TBBCSTU_MAX_STUDENT_AMOUNT

MAX_NUMBER_STUDENTS Maximum Number Students Maximum number of students for this contract. NUMBER
NA

NA

MIN_AMOUNT_FROM_THIRD_PARTY Minimum Amount From Third Party Minimum third party amount for this contract. NUMBER
NA

NA

MIN_NUMBER_STUDENTS Minimum Number Students Minimum number of students for this contract. NUMBER
NA

NA

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_EXP_ACAD_PERIOD 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(63)
TBBCSTU

TBBCSTU_TERM_CODE_EXPIRATION

PERSON_EXP_ACAD_PERIOD_DESC Person Exp Acad Period Description Person expiration academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

PERSON_EXP_DATE Person Exp Date Extracts date this term ends. DATE
STVTERM

STVTERM_END_DATE

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)
NA

NA

PERSON_MAX_AMOUNT_AUTHORIZED Person Maximum Amount Authorized Maximum amount paid by the student. NUMBER
TBBCSTU

TBBCSTU_MAX_STUDENT_AMOUNT

PERSON_MAX_AMOUNT_PAID Person Maximum Amount Paid Maximum amount paid by the student. NUMBER
TBBCSTU

TBBCSTU_MAX_STUDENT_AMOUNT

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

TBBCSTU_STU_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

SPONSOR_REFERENCE_NUMBER Sponsor Reference Number Sponsor reference number. VARCHAR2(63)
TBBCSTU

TBBCSTU_SPONSOR_REF_NUMBER

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

STVTERM_START_DATE

STUDENT_CONTRACT_ROLL_IND Student Contract Roll Indicator Indicates if the student will roll with the contract to a new academic period. VARCHAR2(1)
TBBCSTU

TBBCSTU_STUDENT_CONT_ROLL_IND

STUDENT_INACTIVATED_IND Student Inactivated Indicator Indicates if the student should be removed from the contract. VARCHAR2(1)
CALCULATION

DECODE(TBBCSTU_DEL_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

THIRD_PARTY_ID Third Party ID Third party or contract sponsor's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

THIRD_PARTY_NAME Third Party Name Third party or contract sponsor's current name. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

THIRD_PARTY_UID Third Party UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER
TBBCONT

TBBCONT_PIDM

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

TBBCSTU_USER_ID

Ver: 9.2

Description	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.
Key & Frequency	One row per academic period per person per contract priority.
Recommended Search Columns	PERSON_UID ACADEMIC_PERIOD, THIRD_PARTY_UID, CONTRACT_NUMBER ACADEMIC_PERIOD, PERSON_UID, CONTRACT_NUMBER

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)	TBBCSTU	TBBCSTU_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_IND	Authorized Indicator	Indicates whether a student is preauthorized, authorized, or unauthorized to use a contract.	VARCHAR2(1)	TBBCSTU	TBBCSTU_AUTH_IND
AUTHORIZED_NUMBER	Authorized Number	Third party issued number authorizing the student to be covered under a contract.	VARCHAR2(63)	TBBCSTU	TBBCSTU_AUTH_NUMBER
CONTRACT_ACTIVITY_DATE	Contract Activity Date	Date that information for this record in the table was entered or last updated.	DATE	TBBCSTU	TBBCSTU_ACTIVITY_DATE
CONTRACT_DATA_ORIGIN	Contract Data Origin	Source system that last created or updated the data.	VARCHAR2(63)	TBBCSTU	TBBCSTU_DATA_ORIGIN
CONTRACT_DESC	Contract Description	Free-format description of the third party contract for the academic period.	VARCHAR2(255)	TBBCONT	TBBCONT_DESC
CONTRACT_EXP_ACAD_PERIOD	Contract Exp Acad Period	Contract expiration academic period - the last academic period the contract is rolled forward by the roll process.	VARCHAR2(63)	TBBCONT	TBBCONT_TERM_CODE_EXPIRATION
CONTRACT_EXP_ACAD_PERIOD_DESC	Contract Exp Acad Period Description	Academic period or term code description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
CONTRACT_EXP_DATE	Contract Exp Date	Extracts date this term ends.	DATE	STVTERM	STVTERM_END_DATE
CONTRACT_NEGOTIATED_ID	Contract Negotiated ID	Identification number for the individual who negotiated the contract.	VARCHAR2(255)	NA	NA
CONTRACT_NEGOTIATED_NAME	Contract Negotiated Name	Name of the individual who negotiated the contract.	VARCHAR2(255)	NA	NA
CONTRACT_NUMBER	Contract Number	Contract number associated with the third party for the academic period.	NUMBER	TBBCSTU	TBBCSTU_CONTRACT_NUMBER
CONTRACT_PRIORITY	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
CONTRACT_RULE_ROLL_IND	Contract Rule Roll Indicator	Indicates if the contract can be rolled to a new academic period.	VARCHAR2(1)	TBBCONT	TBBCONT_CONTRACT_ROLL_IND
COURSES_COVERED_COUNT	Courses Covered Count	Count of courses covered for payment by this contract.	NUMBER	NA	NA
DETAIL_CODE_CHARGE	Detail Code Charge	Code defining type of transaction in accounts receivable to be posted as the charge against the third-party account.	VARCHAR2(63)	TBBCONT	TBBCONT_DETAIL_CHG_CODE
DETAIL_CODE_CHARGE_DESC	Detail Code Charge Description	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
DETAIL_CODE_PAY	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(63)	TBBCONT	TBBCONT_DETAIL_PAY_CODE
DETAIL_CODE_PAY_DESC	Detail Code Pay Description	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
END_DATE	End Date	End date for the academic period.	DATE	NA	NA
MAX_AMOUNT_FROM_THIRD_PARTY	Maximum Amount From Third Party	Maximum third party amount for this contract.	NUMBER	TBBCSTU	TBBCSTU_MAX_STUDENT_AMOUNT
MAX_NUMBER_STUDENTS	Maximum Number Students	Maximum number of students for this contract.	NUMBER	NA	NA
MIN_AMOUNT_FROM_THIRD_PARTY	Minimum Amount From Third Party	Minimum third party amount for this contract.	NUMBER	NA	NA
MIN_NUMBER_STUDENTS	Minimum Number Students	Minimum number of students for this contract.	NUMBER	NA	NA
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_EXP_ACAD_PERIOD	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(63)	TBBCSTU	TBBCSTU_TERM_CODE_EXPIRATION
PERSON_EXP_ACAD_PERIOD_DESC	Person Exp Acad Period Description	Person expiration academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
PERSON_EXP_DATE	Person Exp Date	Extracts date this term ends.	DATE	STVTERM	STVTERM_END_DATE
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)	NA	NA
PERSON_MAX_AMOUNT_AUTHORIZED	Person Maximum Amount Authorized	Maximum amount paid by the student.	NUMBER	TBBCSTU	TBBCSTU_MAX_STUDENT_AMOUNT
PERSON_MAX_AMOUNT_PAID	Person Maximum Amount Paid	Maximum amount paid by the student.	NUMBER	TBBCSTU	TBBCSTU_MAX_STUDENT_AMOUNT
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	TBBCSTU	TBBCSTU_STU_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
SPONSOR_REFERENCE_NUMBER	Sponsor Reference Number	Sponsor reference number.	VARCHAR2(63)	TBBCSTU	TBBCSTU_SPONSOR_REF_NUMBER
START_DATE	Start Date	Extracts start date for this term.	DATE	STVTERM	STVTERM_START_DATE
STUDENT_CONTRACT_ROLL_IND	Student Contract Roll Indicator	Indicates if the student will roll with the contract to a new academic period.	VARCHAR2(1)	TBBCSTU	TBBCSTU_STUDENT_CONT_ROLL_IND
STUDENT_INACTIVATED_IND	Student Inactivated Indicator	Indicates if the student should be removed from the contract.	VARCHAR2(1)	CALCULATION	DECODE(TBBCSTU_DEL_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
THIRD_PARTY_ID	Third Party ID	Third party or contract sponsor's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
THIRD_PARTY_NAME	Third Party Name	Third party or contract sponsor's current name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
THIRD_PARTY_UID	Third Party UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBBCONT	TBBCONT_PIDM
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	TBBCSTU	TBBCSTU_USER_ID