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

Banner Operational Data Store
Reporting View Target: CONTRACT_PAYMENT_DETAIL

Description Contains the contract payment detail information identifying the student charges, academic period, contract number being paid by the third party contract payment transaction number.
Key & Frequency One record per third party per transaction number per contract payment transaction
Recommended Search Columns THIRD_PARTY_UID, TRANSACTION_NUMBER, CONTRACT_PAYMENT_TRANSACTION

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period for which the contract third party contract payment was made. VARCHAR2(63)

TBRCPDT

TBRCPDT_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 Amount of the contract payment transaction recorded for this student. This may be only a portion of the total payment received from the third party in the transaction number. NUMBER

TBRCPDT

TBRCPDT_AMOUNT

BALANCE Balance of the amount recorded for this transaction number and contract payment transaction that was not applied when application of payments was run. NUMBER

TBRCPDT

TBRCPDT_BALANCE

CONTRACT_NUMBER Contract number associated with the third party and student for the academic period when the contract payment was made. NUMBER

TBRCPDT

TBRCPDT_CONTRACT_NUMBER

CONTRACT_PAYMENT_ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

TBRCPDT

TBRCPDT_ACTIVITY_DATE

CONTRACT_PAYMENT_CREATOR_ID User Id of the cashier who first created the payment detail record. VARCHAR2(63)

TBRCPDT

TBRCPDT_CREATE_USER

CONTRACT_PAYMENT_DATA_ORIGIN Source system that last created or updated the data. VARCHAR2(63)

TBRCPDT

TBRCPDT_DATA_ORIGIN

CONTRACT_PAYMENT_TRANSACTION One up number assigned to each student charge identified as paid by this third party transaction number. One or more charges may be paid and recorded as a detail record when a single payment transaction number is recorded. NUMBER

TBRCPDT

TBRCPDT_TRAN_NUMBER

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

TBRCPDT

TBRCPDT_USER_ID

FINAL_STUDENT_PAYMENT_IND Indicates if payment is final amount, which may leave balance due from student . The values are 'Y' or 'N'. The default value will be 'N'. VARCHAR2(1)

TBRCPDT

TBRCPDT_FINAL_IND

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 Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID System generated, unique, internal identification number of the student for whom payment has been made, matched to cross reference PIDM of contract charges. NUMBER

TBRCPDT

TBRCPDT_STU_PIDM

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

NA

NA

REFUND_STUDENT_AMOUNT Amount processed as credit back to student's receivable account. NUMBER

TBRCPDT

TBRCPDT_RFND_STDN_AMT

REFUND_STUDENT_IND Indicates if overage may be given to student, or should be returned to sponsor. The values are 'Y' or 'N'. The default value will be 'N'. VARCHAR2(1)

TBRCPDT

TBRCPDT_REFUND_IND

REFUND_THIRD_PARTY_AMOUNT Amount processed as refund to sponsor. NUMBER

TBRCPDT

TBRCPDT_RFND_CONT_AMT

SPONSOR_PROVIDED_NAME Name provided by the third party or contract sponsor to identify student. Name should be the same as the (account) name but not matched. VARCHAR2(255)

TBRCPDT

TBRCPDT_NAME_PROVIDED

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 or contract sponsor's current name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

TBRCPDT

TBRCPDT_CONT_PIDM

TRANSACTION_NUMBER Transaction number assigned when the payment from the third party or contract sponsor was recorded on the receivable account. NUMBER

TBRCPDT

TBRCPDT_CONT_TRAN_NUMBER

TRAN_NUMBER_PAID Transaction number of a charge in the third party or contract sponsor receivable account to which payment should be applied if specified. NUMBER

TBRCPDT

TBRCPDT_TRAN_NUMBER_PAID



Ver: 9.1