Target Column	Business Definition	Database Data Type	Source Name	Source Column
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)	TBBEXPT	TBBEXPT_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_PAID	Amount credited to the student account or charged to the contract or exemption.	NUMBER	FUNCTION	TOKODSF.F_AMOUNT_PAID
AUTHORIZED_AMOUNT	Maximum amount authorized for a student.	NUMBER	TBBESTU	TBBESTU_MAX_STUDENT_AMOUNT
DETAIL_CODE	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TBBEXPT	TBBEXPT_DETAIL_CODE
DETAIL_CODE_DESC	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
END_DATE	End date for the academic period.	DATE	STVTERM	STVTERM_END_DATE
EXEMPTION	Priority of this exemption for the student, if the student is authorized for more than one exemption.	VARCHAR2(63)	TBBESTU	TBBESTU_EXEMPTION_CODE
EXEMPTION_CANCELLED_IND	Indicates that the exemption was cancelled after initial processing and updates were made for the account holder within accounts receivable.	VARCHAR2(1)	CALCULATION	DECODE(TBBESTU_DEL_IND)
EXEMPTION_DESC	Exemption description.	VARCHAR2(255)	TBBEXPT	TBBEXPT_DESC
EXEMPTION_PAYMENT_CODE	Exemption payment code.	VARCHAR2(63)	TBBEXPT	TBBEXPT_DETAIL_CODE
EXEMPTION_PAYMENT_DESC	Exemption payment code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
EXEMPTION_PRIORITY	Indicates the priority of this contract for the student, if the student is authorized for more than one contract.	NUMBER	TBBESTU	TBBESTU_EXEMPTION_PRIORITY
EXEMPTION_RULE_ROLL_IND	Indicates if the exemption can be rolled to a new academic period.	VARCHAR2(1)	TBBEXPT	TBBEXPT_EXEMPTION_ROLL_IND
EXP_ACADEMIC_PERIOD	Expiration academic period - the last academic period when the person is rolled forward associated with the exemption.	VARCHAR2(63)	TBBESTU	TBBESTU_TERM_CODE_EXPIRATION
EXP_ACADEMIC_PERIOD_DESC	Expiration academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
EXP_DATE	Extracts date this term ends.	DATE	STVTERM	STVTERM_END_DATE
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	Person's full name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_ID	Person's identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	TBBESTU	TBBESTU_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
START_DATE	Extracts start date for this term.	DATE	STVTERM	STVTERM_START_DATE
STUDENT_EXEMPTION_ROLL_IND	Indicates if the student will roll with the exemption to a new academic period.	VARCHAR2(1)	TBBESTU	TBBESTU_STUDENT_EXPT_ROLL_IND
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	A session, portion or part of the academic period.	VARCHAR2(255)	NA	NA
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	TBBESTU	TBBESTU_USER_ID

Ver: 9.1