Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_HISTORY_EXISTS_IND	Indicates whether or not academic history (SHRTGPA) data exists for specified PIDM and term code.	VARCHAR2(1)	FUNCTION	SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA
ACADEMIC_PERIOD	Academic period or time frame for this student enrollment record.	VARCHAR2(6)	SFBETRM	SFBETRM_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC
AR_CHGS_ACCEPTANCE_IND	Indicates whether enrollment charges have been accepted by the student based on the institution requirements.	VARCHAR2(1)	SFBETRM	SFBETRM_AR_IND
ASSESSMENT_DATE	Date student enrollment charges were determined and posted to the student account.	DATE	SFBETRM	SFBETRM_ASSESSMENT_DATE
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
CURRENT_TIME_STATUS	System-calculated time status for the academic period based on institution defined rules. For example, full time, part time, etc.	VARCHAR2(2)	SFBETRM	SFBETRM_TMST_CODE
CURRENT_TIME_STATUS_DATE	Date the system-calculated time status for the academic period based on institution defined rules. For example, full time, part time, etc.	DATE	SFBETRM	SFBETRM_TMST_DATE
CURRENT_TIME_STATUS_DESC	Current time status description.	VARCHAR2(30)	STVTMST	STVTMST_DESC
DEANS_LIST_DATE	Date on which the Dean's List code was recorded.	DATE	NA	NA
DEANS_LIST_DESC	Student's dean's list code description.	VARCHAR2(30)	NA	NA
DEANS_LIST_VALUE	Identifies whether the student qualified for the dean's list this academic period.	VARCHAR2(2)	NA	NA
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
ENROLLED_IND	Indicates whether the student's enrollment status includes them in headcounts.	VARCHAR2(1)	FUNCTION	F_ENROLLED_THIS_TERM
ENROLLMENT_ADD_DATE	Date of the initial registration for this academic period.	DATE	SFBETRM	SFBETRM_ADD_DATE
ENROLLMENT_EXISTS_IND	Indicates whether or not enrollment (SFBETRM) data exists for specified PIDM and term code.	VARCHAR2(1)	CONSTANT	'Y'
ENROLLMENT_STATUS	Student's current enrollment status for this section or schedule offering.	VARCHAR2(2)	SFBETRM	SFBETRM_ESTS_CODE
ENROLLMENT_STATUS_DATE	Date for the last update to enrollment status.	DATE	SFBETRM	SFBETRM_ESTS_DATE
ENROLLMENT_STATUS_DESC	Student's enrollment status description.	VARCHAR2(30)	STVESTS	STVESTS_DESC
GRADE_MAILER_CHG_DATE	Indicates the date a revised or duplicate grade mailer was sent to the student.	DATE	NA	NA
GRADE_MAILER_DUP	Specifies that duplicate grade mailer should be sent to the student.	VARCHAR2(1)	NA	NA
GRADE_MAILER_DUP_DATE	Indicates date duplicate grade mailer was sent.	DATE	NA	NA
GRADE_MAILING_DATE	Indicates the date grade mailer was sent to the student.	DATE	NA	NA
HOUSING_IND	Indicates whether the student has institution housing for this academic period.	VARCHAR2(1)	FUNCTION	F_HOUS_THIS_TERM
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	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	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	SFBETRM	SFBETRM_PIDM
PRE_CATALOG_IND	Specifies if the term course information is based on the existing catalog or is conversion data being entered prior to the catalog.	VARCHAR2(1)	NA	NA
RECORD_SOURCE_IND	Indicates source of how record was created.	VARCHAR2(1)	NA	NA
RECORD_STATUS_DATE	Date associated with the status of the record.	DATE	NA	NA
RECORD_STATUS_IND	Specifies the status of the term record.	VARCHAR2(1)	NA	NA
REGISTERED_IND	Indicates whether the student is registered for the current academic period.	VARCHAR2(1)	FUNCTION	F_REGISTERED_THIS_TERM
REGISTRATION_REASON	Reason recorded for the student registration. May be the reason registered or the reason the registration is withdrawn depending on the institution's definition.	VARCHAR2(2)	SFBETRM	SFBETRM_RGRE_CODE
REGISTRATION_REASON_DESC	Registration reason description.	VARCHAR2(30)	STVRGRE	STVRGRE_DESC
SPECIAL_EXAM_CREDIT	Identifies that special examination credit was granted to the student in this academic period.	VARCHAR2(2)	NA	NA
SPECIAL_EXAM_DESC	Description for the special examination credit.	VARCHAR2(30)	NA	NA
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	Sum of the billing units used to calculate the charges for this student in this academic period.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TOTAL_CEU_BILLING	Sum of the continuing education unit billing units used to calculate the charges for this student for this academic period.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TOTAL_CEU_CREDITS	Sum of the continuing education units for the student for this academic period.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TOTAL_CREDITS	Sum of the registered credits for the student for this academic period.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TOTAL_NON_CEU_BILLING	Sum of the billing units for this student in the academic period that are not identified as earning continuing education units but regular credits.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TOTAL_NON_CEU_CREDITS	Sum of the credits for this student in the academic period that are not identified as earning continuing education units.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TRANSFER_TO_INSTITUTION	Institution to which the student will transfer.	VARCHAR2(6)	NA	NA
TRANSFER_TO_INSTITUTION_DESC	Name of the institution the student plans to attend.	VARCHAR2(30)	NA	NA
VETERAN_TYPE	Veteran type associated with the person record.	VARCHAR2(1)	FUNCTION	SOKODSF.F_GET_CURR_VETC_CODE
VETERAN_TYPE_DESC	Description for the type of veteran.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
WITHDRAWAL_REASON	Reason for the student's withdrawal from this institution. May be defined as accepted elsewhere, financial difficulty, etc.	VARCHAR2(2)	NA	NA
WITHDRAWAL_REASON_DESC	Reason for withdrawal description.	VARCHAR2(30)	NA	NA
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