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(63)	TBBCSTU	TBBCSTU_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	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(63)	TBBCSTU	TBBCSTU_AUTH_NUMBER	NO	NO
CONTRACT_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	TBBCSTU	TBBCSTU_ACTIVITY_DATE	NO	NO
CONTRACT_DATA_ORIGIN	Source system that last created or updated the data.	VARCHAR2(63)	TBBCSTU	TBBCSTU_DATA_ORIGIN	NO	NO
CONTRACT_DESC	Free-format description of the third party contract for the academic period.	VARCHAR2(255)	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(63)	TBBCONT	TBBCONT_TERM_CODE_EXPIRATION	NO	NO
CONTRACT_EXP_ACAD_PERIOD_DESC	Academic period or term code description.	VARCHAR2(255)	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(255)	NA	NA	NO	NO
CONTRACT_NEGOTIATED_NAME	Name of the individual who negotiated the contract.	VARCHAR2(255)	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
COURSES_COVERED_COUNT	Count of courses covered for payment by this contract.	NUMBER	NA	NA	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(63)	TBBCONT	TBBCONT_DETAIL_CHG_CODE	NO	NO
DETAIL_CODE_CHARGE_DESC	Transaction type description.	VARCHAR2(255)	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(63)	TBBCONT	TBBCONT_DETAIL_PAY_CODE	NO	NO
DETAIL_CODE_PAY_DESC	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC	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
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
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	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(63)	TBBCSTU	TBBCSTU_TERM_CODE_EXPIRATION	NO	NO
PERSON_EXP_ACAD_PERIOD_DESC	Person expiration academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
PERSON_EXP_DATE	Extracts date this term ends.	DATE	STVTERM	STVTERM_END_DATE	NO	NO
PERSON_FULL_NAME	Person's full name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PERSON_ID	Person's identification number.	VARCHAR2(63)	NA	NA	NO	NO
PERSON_MAX_AMOUNT_AUTHORIZED	Maximum amount paid by the 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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
SPONSOR_REFERENCE_NUMBER	Sponsor reference number.	VARCHAR2(63)	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(63)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	A session, portion or part of the academic period.	VARCHAR2(255)	NA	NA	NO	NO
THIRD_PARTY_ID	Third party or contract sponsor's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
THIRD_PARTY_NAME	Third party or contract sponsor's current name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	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(63)	TBBCSTU	TBBCSTU_USER_ID	NO	NO

Ver: 9.2