Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_HISTORY_EXISTS_IND	This Y/N indicator reflects whether or not Academic History (SHRTTRM) data exists for specified PIDM and Term Code.	VARCHAR2(1)	CONSTANT	'Y'
ACADEMIC_PERIOD	This field identifies the academic period or term associated with the information on the student information record.	VARCHAR2(6)	SHRTTRM	SHRTTRM_TERM_CODE
ACADEMIC_PERIOD_DESC	This field specifies the academic period or term associated with the academic period code.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	This field identifies the academic year associated with the information on the student information record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	This field specifies the academic year associated with the academic year code.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
AR_CHGS_ACCEPTANCE_IND	This field identifies the term charges acceptance indicator.	VARCHAR2(1)	CONSTANT	'Y'
ASSESSMENT_DATE	This field identifies the date of the assessment for this term.	DATE	NA	NA
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
CURRENT_TIME_STATUS	This field identifies the system calculated time status for the academic period(e.g. full time, part time, etc.)	VARCHAR2(2)	NA	NA
CURRENT_TIME_STATUS_DATE	This field specifies the date associated with the time status code.	DATE	NA	NA
CURRENT_TIME_STATUS_DESC	This field specifies the time status associated with the time status code.	VARCHAR2(30)	NA	NA
DEANS_LIST_DATE	Deans List Date. Date on which the deans list code was entered.	DATE	SHRTTRM	SHRTTRM_ASTD_DATE_DL
DEANS_LIST_DESC	Description associated with the students Deans List code.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
DEANS_LIST_VALUE	Deans List Code. Identifies if the student qualified for deans list for the key term.	VARCHAR2(2)	SHRTTRM	SHRTTRM_ASTD_CODE_DL
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
ENROLLED_IND	This is a Y or N field to indicate if the student has enrollment with a status that indicates to include the student in headcounts.	VARCHAR2(1)	CONSTANT	'Y'
ENROLLMENT_ADD_DATE	This field identifies the date of the initial registration for this term.	DATE	NA	NA
ENROLLMENT_EXISTS_IND	This Y/N indicator reflects whether or not Enrollment (SFBETRM) data exists for specified PIDM and Term Code.	VARCHAR2(1)	CONSTANT	'N'
ENROLLMENT_STATUS	This field identifies the student enrollment status code.	VARCHAR2(2)	CONSTANT	'EL'
ENROLLMENT_STATUS_DATE	This field indicates the date of the enrollment status.	DATE	NA	NA
ENROLLMENT_STATUS_DESC	This field specifies the student registration status associated with the status code.	VARCHAR2(30)	STVESTS	STVESTS_DESC
GRADE_MAILER_CHG_DATE	Indicates the date a revised or duplicate grade mailer was sent to the student.	DATE	SHRTTRM	SHRTTRM_GRADE_MAILER_CHG_DATE
GRADE_MAILER_DUP	Specifies that duplicate grade mailer should be sent to the student. Valid value is Y - Send duplicate mailer.	VARCHAR2(1)	SHRTTRM	SHRTTRM_GRADE_MAILER_DUP
GRADE_MAILER_DUP_DATE	Indicates date duplicate grade mailer was sent.	DATE	SHRTTRM	SHRTTRM_GRADE_MAILER_DUP_DATE
GRADE_MAILING_DATE	Indicates the date grade mailer was sent to the student.	DATE	SHRTTRM	SHRTTRM_GRADE_MAILING_DATE
HOUSING_IND	This is a Y or N field to indicate if the student is receiving housing this term.	VARCHAR2(1)	FUNCTION	F_HOUS_THIS_TERM
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
PERSON_UID	The internal number used to uniquely identify an individual.	NUMBER(8)	SHRTTRM	SHRTTRM_PIDM
PRE_CATALOG_IND	Specifies if the term course information is based on the existing Banner catalog or is conversion data being entered prior to the Banner catalog. Valid values are: Y - Pre-catalog , and N - Current Catalog.	VARCHAR2(1)	SHRTTRM	SHRTTRM_PRE_CATALOG_IND
RECORD_SOURCE_IND	Indicates sourse of how record was created. Valid values are: S - System created during grade roll process, and U - User created.	VARCHAR2(1)	SHRTTRM	SHRTTRM_UPDATE_SOURCE_IND
RECORD_STATUS_DATE	Date associated with the status of the record.	DATE	SHRTTRM	SHRTTRM_RECORD_STATUS_DATE
RECORD_STATUS_IND	Specifies the status of the term record. Valid values are: G - Grade Mailer Pending, C - Grade Mailer processing complete, R - Revised Grade Mailer Pending, N - New Record.	VARCHAR2(1)	SHRTTRM	SHRTTRM_RECORD_STATUS_IND
REGISTERED_IND	This is a Y or N field to indicate if the student is registered for the current term.	VARCHAR2(1)	CONSTANT	'Y'
REGISTRATION_REASON	Student Registration Reason Code.	VARCHAR2(2)	NA	NA
REGISTRATION_REASON_DESC	This field defines the Registration Reason associated with the Registration Reason code.	VARCHAR2(30)	NA	NA
SPECIAL_EXAM_CREDIT	Special Exam Credit Code. Identifies a special examination the student took during the key term.	VARCHAR2(2)	SHRTTRM	SHRTTRM_EXAM_CODE
SPECIAL_EXAM_DESC	This is the description for the special examination credit code.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
SUB_ACADEMIC_PERIOD	This field identifies the session or part of the academic period associated with the information on the student information record.	VARCHAR2(6)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	This field identifies the description of the session or part of the academic period associated with the information on the student information record.	VARCHAR2(30)	NA	NA
TOTAL_BILLING	This is the sum of the billings for the student.	NUMBER	CONSTANT	0
TOTAL_CEU_BILLING	This is the sum of the Continuing Education Unit billings for the student.	NUMBER	CONSTANT	0
TOTAL_CEU_CREDITS	This is the sum of the Continuing Education Units for the student, identified by the flag of CEU on the study level.	NUMBER	FUNCTION	SOKODSF.F_CALC_HISTORY_HOURS
TOTAL_CREDITS	This is the sum of the credit hours for the student.	NUMBER	FUNCTION	SOKODSF.F_CALC_HISTORY_HOURS
TOTAL_NON_CEU_BILLING	This is the sum of the Non Continuing Education Unit billings for the student.	NUMBER	CONSTANT	0
TOTAL_NON_CEU_CREDITS	This is the sum of credit hours for the student that are not at study levels associated with CEUs.	NUMBER	FUNCTION	SOKODSF.F_CALC_HISTORY_HOURS
TRANSFER_TO_INSTITUTION	Transfer Institution Code. Institution to which the student will transfer.	VARCHAR2(6)	SHRTTRM	SHRTTRM_SBGI_CODE_TRANS
TRANSFER_TO_INSTITUTION_DESC	The description of the institution transfer to.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
VETERAN_TYPE	This field identifies the specific veteran type associated with the person record.	VARCHAR2(1)	FUNCTION	SOKODSF.F_GET_CURR_VETC_CODE
VETERAN_TYPE_DESC	This field specifies the veteran type (e.g. non-veteran, ROTC, Chapter 32 Post Vietnam) associated with the veteran type code.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
WITHDRAWAL_REASON	Withdrawal Reason Code. Identifies the reason for the students withdrawal from this institution.	VARCHAR2(2)	SHRTTRM	SHRTTRM_WRSN_CODE
WITHDRAWAL_REASON_DESC	This is the description for the withdrawal reason code.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: 8.1