Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	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	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	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	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	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	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	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	Contract Payment Data Origin	Source system that last created or updated the data.	VARCHAR2(63)	TBRCPDT	TBRCPDT_DATA_ORIGIN
CONTRACT_PAYMENT_TRANSACTION	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	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	Final Student Payment Indicator	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	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	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_ID	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	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 Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REFUND_STUDENT_AMOUNT	Refund Student Amount	Amount processed as credit back to student's receivable account.	NUMBER	TBRCPDT	TBRCPDT_RFND_STDN_AMT
REFUND_STUDENT_IND	Refund Student Indicator	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	Refund Third Party Amount	Amount processed as refund to sponsor.	NUMBER	TBRCPDT	TBRCPDT_RFND_CONT_AMT
SPONSOR_PROVIDED_NAME	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 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	TBRCPDT	TBRCPDT_CONT_PIDM
TRANSACTION_NUMBER	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 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.2