Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_HISTORY_EXISTS_IND	Indicates whether the student has academic history information for the academic period.	VARCHAR2(1)	CONSTANT FUNCTION	'Y' SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA
ACADEMIC_OUTCOME_ENROLLED_IND	Indicates that the student counts in the headcount, has current academic period credits registered greater than 0, and has been admitted to an academic outcome that grants a degree or award.	VARCHAR2(1)	FUNCTION	MSKFUNC.F_DEGR_ENROLLED_IND
ACADEMIC_PERIOD	Academic period or time frame for this student enrollment record.	VARCHAR2(63)	SFBETRM	SFBETRM_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_STANDING_END	Academic standing or progress indicator for the student as determined after the grades are processed for the academic period. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution.	VARCHAR2(63)	SHRTTRM	SHRTTRM_ASTD_CODE_END_OF_TERM
ACADEMIC_STANDING_END_DATE	Date that the academic standing no longer applies to the student. This may have been derived from the end date of the academic period for which the academic standing was applied as an override.	DATE	SHRTTRM	SHRTTRM_ASTD_DATE_END_OF_TERM
ACADEMIC_STANDING_END_DESC	Academic standing description.	VARCHAR2(255)	STVASTD	STVASTD_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ADMIT_IND	Indicates whether the student has been admitted to the institution for the academic period and student level in this record.	VARCHAR2(1)	FUNCTION	F_LEVEL_ADMITTED_FNC
APPLICANT_IND	Indicates whether the person has applied for admissions for this academic period and student level.	VARCHAR2(1)	FUNCTION	F_LEVEL_APPL_FNC
AR_CHRGS_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
CONTINUING_EDUCATION_IND	Indicates whether the student is considered a continuing education student. Taking courses to earn continuing education units instead of credits.	VARCHAR2(1)	NA	NA
CURRENT_TIME_STATUS	System-calculated time status for the academic period based on institution defined rules. For example, full time, part time, etc.	VARCHAR2(63)	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(255)	STVTMST	STVTMST_DESC
DEPOSIT_IND	Indicates whether the student has paid an admissions deposit.	VARCHAR2(1)	FUNCTION	F_PAID_ADMISSIONS_DEPOSIT
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 the student has current enrollment information for the academic period.	VARCHAR2(1)	CALCULATION CONSTANT	DECODE(SFBETRM_PIDM, NULL, 'N', 'Y') 'Y'
ENROLLMENT_STATUS	Student's current enrollment status for this section or schedule offering.	VARCHAR2(63)	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(255)	STVESTS	STVESTS_DESC
FIN_AID_APPLICANT_IND	Indicates whether the student is receiving any financial aid for the award year of the associated term.	VARCHAR2(1)	FUNCTION	F_FINAID_APPLICANT_IND
FTE_DIVISOR	Identifies the portion of full time equated load the student is currently registered for in this academic study for this academic period.	NUMBER	FUNCTION	MSKFUNC.F_GET_DIVISOR_FTE
GRADUATED_IND	Indicates whether the person has graduated or earned any academic outcomes to date.	VARCHAR2(1)	FUNCTION	SOKODSF.F_CHECK_FOR_GRADUATE_IND
HOUSING_IND	Indicates whether the student has institution housing for this academic period.	VARCHAR2(1)	FUNCTION	F_HOUS_THIS_TERM
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INQUIRER_IND	Indicates whether the student has any recruiting information.	VARCHAR2(1)	FUNCTION	F_INQUIRER_FNC
INST_AID_RECIPIENT_IND	Indicates whether the student is receiving institutional financial aid for this academic period.	VARCHAR2(1)	FUNCTION	F_INST_AID_FNC
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
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SFBETRM	SFBETRM_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROSPECT_IND	Indicates whether this person has a prospect record.	VARCHAR2(1)	FUNCTION	F_PROSPECT_FNC
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(63)	SFBETRM	SFBETRM_RGRE_CODE
REGISTRATION_REASON_DESC	Registration reason description.	VARCHAR2(255)	STVRGRE	STVRGRE_DESC
SPECIAL_EXAM_CREDIT	Identifies that special examination credit was granted to the student in this academic period.	VARCHAR2(63)	SHRTTRM	SHRTTRM_EXAM_CODE
SPECIAL_EXAM_DESC	Description for the special examination credit.	VARCHAR2(255)	STVEXAM	STVEXAM_DESC
STUDENT_CLASSIFICATION	Identifies the student classification (i.e. year in school) after grades have been processed for this academic period. For example, first year, second year or freshman, sophomore, etc. This may be the same value as the Student Classification BOAP or when appropriate be the value to begin the next academic period.	VARCHAR2(63)	FUNCTION	F_CLASS_CALC_FNC
STUDENT_CLASSIFICATION_BOAP	Identifies the student�s classification (i.e. class or year in school) when the academic period begins, for example, first year, second year or freshman, sophomore, etc. This will be the same value as the Student Classification when the previous academic period ended.	VARCHAR2(63)	FUNCTION	SGKCLAS.F_CLASS_CODE
STUDENT_CLASSIFICATION_DESC	Student's current year of study description.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC
STUDENT_CLASS_BOAP_DESC	Beginning of academic period student classification.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC
STUDENT_FTE	Calculated value that represents the portion of full time equivalent represented by this student for this academic period.	NUMBER	FUNCTION	MSKFUNC.F_GET_DIVISOR_FTE
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	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(63)	SHRTTRM	SHRTTRM_SBGI_CODE_TRANS
TRANSFER_TO_INSTITUTION_DESC	Name of the institution the student plans to attend.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC
WITHDRAWAL_REASON	Reason for the student's withdrawal from this institution. May be defined as accepted elsewhere, financial difficulty, etc.	VARCHAR2(63)	SHRTTRM	SHRTTRM_WRSN_CODE
WITHDRAWAL_REASON_DESC	Reason for withdrawal description.	VARCHAR2(255)	STVWRSN	STVWRSN_DESC

Ver: 8.1