Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_HISTORY_EXISTS_IND	Academic History Exists Indicator	Indicates whether the student has academic history information for the academic period.	VARCHAR2(1)	FUNCTION	SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA
ACADEMIC_OUTCOME_ENROLLED_IND	Academic Outcome Enrolled Indicator	Indicates if the student is officially enrolled in an academic outcome in this enrollment time frame.	VARCHAR2(1)	FUNCTION	MSKFUNC.F_DEGR_ENROLLED_IND
ACADEMIC_PERIOD	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)	SGBSTDN	SGBSTDN_TERM_CODE_EFF
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_STUDY_MATRIC_IN_COUNT	Academic Study Matric IN Count	Matriculation academic period for the student.	NUMBER	CALCULATION	DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0,1)+DECODE(SGBSTDN_LEVL_CODE_2,NULL,0,DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0,1))
ACADEMIC_YEAR	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	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACAD_OUTCOME_COMPLETED_COUNT	Acad Outcome Completed Count	Count of outcomes completed, e.g., total number of certificates, diploma, awards, degrees that the student has been awarded.	NUMBER	FUNCTION	SOKODSF.F_COUNT_COMPLETED_OUTCOMES
ACAD_STUDY_REGISTERED_IN_COUNT	Acad Study Registered IN Count	Count of academic studies or programs in which the student is formally registered in sections.	NUMBER	NA	NA
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ADMIT_IND	Admit Indicator	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
ADVISOR_COUNT	Advisor Count	Count of current active advisors assigned to the student.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADVISORS
ADVISOR_NAME_LIST	Advisor List	List of the names of the advisors for this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (ADVISOR_NAME_LFMI, '-')
AID_ENROLLMENT_PERIOD	Financial Aid Enrollment Period	Aid enrollment period associated with the award schedule. This period can span multiple student terms.	VARCHAR2(63)	FUNCTION	MRKFUNC.F_GET_AID_ENROLL_PERIOD
AID_ENROLLMENT_PERIOD_DESC	Financial Aid Enrollment Period Description	Aid enrollment period description.	VARCHAR2(255)	FUNCTION	MRKFUNC.F_GET_AID_ENROLL_PERIOD
AID_YEAR	Financial Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(63)	FUNCTION	MRKFUNC.F_GET_AID_ENROLL_PERIOD
AID_YEAR_DESC	Financial Aid Year Description	Financial aid year name.	VARCHAR2(255)	FUNCTION	MRKFUNC.F_GET_AID_ENROLL_PERIOD
APPLICANT_IND	Applicant Indicator	Indicates whether the person has applied for admissions for this academic period and student level.	VARCHAR2(1)	FUNCTION	F_LEVEL_APPL_FNC
AR_CHARGES_ACCEPT_IND_DESC	AR Charges Accept Indicator Description	AR charge acceptance description. Values are none, accepted or confirmed	VARCHAR2(255)	CALCULATION	DECODE(SFBETRM_AR_IND)
AR_CHRGS_ACCEPTANCE_IND	Ar Chrgs Acceptance Indicator	Indicates whether enrollment charges have been accepted by the student based on the institution requirements.	VARCHAR2(1)	SFBETRM	SFBETRM_AR_IND
BLOCK_REGISTRATION_COUNT	Block Registration Count	Count of block registration codes assigned to the student.	NUMBER	FUNCTION	MSKFUNC.F_GET_BLOCK_REG_CNT
BLOCK_REGISTRATION_DESC_LIST	Block Registration Description List	List of all the descriptions for the block registration codes assigned or selected by this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (BLOCK_REGISTRATION_DESC, '-')
BLOCK_REGISTRATION_LIST	Block Registration List	List of all the block registration codes assigned or selected by this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (BLOCK_REGISTRATION, '-')
COHORT_COUNT	Cohort Count	Count of all the current active student cohort codes recorded for the person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_COHORTS
COHORT_DESC_LIST	Cohort Description List	List of all the descriptions for the cohort codes associated with this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (COHORT_DESC, '-')
COHORT_LIST	Cohort List	List of all the cohort codes assigned to this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (COHORT, '-')
CONTINUING_EDUCATION_IND	Continuing Education Indicator	Indicates whether the course earns continuing education units instead of credits.	VARCHAR2(1)	NA	NA
CURRENT_TIME_STATUS	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_DESC	Current Time Status Description	Current time status description.	VARCHAR2(255)	STVTMST	STVTMST_DESC
DEANS_LIST_DATE	Deans List Date	Date on which the Dean's List code was recorded.	DATE	SHRTTRM	SHRTTRM_ASTD_DATE_DL
DEANS_LIST_DESC	Deans List Description	Student's deans list code description.	VARCHAR2(255)	STVASTD	STVASTD_DESC
DEANS_LIST_VALUE	Deans List Value	Identifies whether the student qualified for the dean's list this academic period.	VARCHAR2(63)	SHRTTRM	SHRTTRM_ASTD_CODE_DL
DEPOSIT_IND	Deposit Indicator	Indicates whether the student has paid an admissions deposit.	VARCHAR2(1)	FUNCTION	F_PAID_ADMISSIONS_DEPOSIT
EDUCATIONAL_GOAL	Educational Goal	Educational goal recorded for the student.	VARCHAR2(63)	SGBSTDN	SGBSTDN_EGOL_CODE
EDUCATIONAL_GOAL_DESC	Educational Goal Description	Educational goal description.	VARCHAR2(255)	STVEGOL	STVEGOL_DESC
EDUCATION_LEVEL	Education Level	Highest level of education completed by the person.	VARCHAR2(63)	SGBSTDN	SGBSTDN_EDLV_CODE
EDUCATION_LEVEL_DESC	Education Level Description	Description of the highest level of education recorded for the person.	VARCHAR2(255)	STVEDLV	STVEDLV_DESC
ENROLLED_IND	Enrolled Indicator	Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount.	VARCHAR2(1)	FUNCTION	SOKODSF.F_ENROLLED_THIS_TERM
ENROLLMENT_EXISTS_IND	Enrollment Exists Indicator	Indicates whether the student has current enrollment information for the academic period.	VARCHAR2(1)	CALCULATION	DECODE(SFBETRM_PIDM, NULL, 'N', 'Y')
FINANCIAL_AID_AWARDED_IND	Financial Financial Aid Awarded Indicator		VARCHAR2(1)	FUNCTION	MRKFUNC.F_GET_FIN_AID_AWARDED_IND
FINANCIAL_AID_DISBURSED_IND	Financial Financial Aid Disbursed Indicator		VARCHAR2(1)	FUNCTION	MRKFUNC.F_GET_FIN_AID_DISBURSED_IND
FINANCIAL_AID_LOAN_IND	Financial Financial Aid Loan Indicator		VARCHAR2(1)	FUNCTION	MRKFUNC.F_GET_FIN_AID_LOAN_IND
FIN_AID_APPLICANT_IND	Fin Aid Applicant Indicator	Indicates whether the student is receiving any financial aid for the award year of the associated term.	VARCHAR2(1)	FUNCTION	F_FINAID_APPLICANT_IND
GRADE_MAILER_CHG_DATE	Grade Mailer Change Date	Date a revised or duplicate grade mailer was sent to the student.	DATE	SHRTTRM	SHRTTRM_GRADE_MAILER_CHG_DATE
GRADE_MAILER_DUP_DATE	Grade Mailer Duplicate Date	Date a duplicate grade mailer was sent.	DATE	SHRTTRM	SHRTTRM_GRADE_MAILER_DUP_DATE
GRADE_MAILER_DUP_IND	Grade Mailer Duplicate Indicator	Indicates whether a duplicate grade mailer should be sent to the student.	VARCHAR2(1)	SHRTTRM	SHRTTRM_GRADE_MAILER_DUP
GRADE_MAILER_STATUS	Grade Mailer Status	Status of the grade mailer.	VARCHAR2(1)	SHRTTRM	SHRTTRM_RECORD_STATUS_IND
GRADE_MAILER_STATUS_DATE	Grade Mailer Status Date	Date associated with the status of the grade mailer.	DATE	SHRTTRM	SHRTTRM_RECORD_STATUS_DATE
GRADE_MAILER_STATUS_DESC	Grade Mailer Status Description	Description of the grade mailer status.	VARCHAR2(255)	CALCULATION	DECODE(SHRTTRM_RECORD_STATUS_IND)
GRADE_MAILING_DATE	Grade Mailing Date	Date a grade mailer was sent to the student.	DATE	SHRTTRM	SHRTTRM_GRADE_MAILING_DATE
GRADUATE_CREDIT_ELIG_IND	Graduate Credit Elig Indicator	Indicates eligibility of student to take graduate courses for credit for this academic period.	VARCHAR2(1)	SGBSTDN	SGBSTDN_GRAD_CREDIT_APPR_IND
HOLD_COUNT	Hold Count	Count of the number of holds or restrictions to institution activities recorded for this person. Included may be stop of registration, receipt of a transcript or processing of graduation, etc.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_HOLDS
HOLD_DESC_LIST	Hold Description List	List of the descriptions for all the holds assigned to this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (HOLD_DESC, '-')
HOLD_LIST	Hold List	List of all the holds assigned to this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (HOLD, '-')
HOLD_ORIGINATING_OFFICE_LIST	Hold Originating Office List	List of the offices that originated the holds for this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (HOLD_ORIGINATING_OFFICE, '-')
HOLD_ORIGIN_DESC_LIST	Hold Originating Office Description List	List of the names of the offices that originated the holds for this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (HOLD_ORIGINATING_OFFICE_DESC, '-')
HOUSING_IND	Housing Indicator	Idicates if the student has an institution housing assignement.	VARCHAR2(1)	FUNCTION	F_HOUS_THIS_TERM
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
INQUIRER_IND	Inquirer Indicator	Indicates whether the student has any recruiting information.	VARCHAR2(1)	FUNCTION	F_INQUIRER_FNC
INST_AID_RECIPIENT_IND	Inst Aid Recipient Indicator	Indicates whether the student is receiving institutional financial aid for this academic period.	VARCHAR2(1)	FUNCTION	F_INST_AID_FNC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME
ORIENTATION_SESSION	Orientation Session	Orientation session assigned to the student.	VARCHAR2(63)	SGBSTDN	SGBSTDN_ORSN_CODE
ORIENTATION_SESSION_DESC	Orientation Session Description	Orientation session description associated with the orientation session code.	VARCHAR2(255)	STVORSN	STVORSN_DESC
OUTCOME_NUMBER	Outcome Number	Sequence number identifying a unique outcome record for the student.	NUMBER	SORLCUR	SORLCUR_ROLLED_SEQNO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPRIDEN	SPRIDEN_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRESS_EVALUATION	Progress Evaluation	Progress evaluation as stored on the student record for this academic study.	VARCHAR2(63)	SGBSTDN SHRTTRM STVPREV	SGBSTDN_PREV_CODE SHRTTRM_PREV_CODE STVPREV_CODE
PROGRESS_EVALUATION_DESC	Progress Evaluation Description	Progress evaluation description.	VARCHAR2(255)	STVPREV	STVPREV_DESC
PROSPECT_IND	Prospect Indicator	Indicates whether this person has a prospect record.	VARCHAR2(1)	FUNCTION	F_PROSPECT_FNC
REGISTERED_IND	Registered Indicator	Indicates the student is registered in the academic period when at least one student course has a course registration status defined with a 'yes' in the include in section enrolled indicator.	VARCHAR2(1)	FUNCTION	SOKODSF.F_REGISTERED_THIS_TERM
REGISTRATION_REASON	Registration Reason	Recorded reason for the registration or in some cases reason for the registration withdrawal. Institution defined codes are used.	VARCHAR2(63)	SFBETRM	SFBETRM_RGRE_CODE
REGISTRATION_REASON_DESC	Registration Reason Description	Recorded registration reason description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
RESIDENCY	Residency	Residency code for the student identifying the type of charges the student will incur.	VARCHAR2(63)	SGBSTDN	SGBSTDN_RESD_CODE
RESIDENCY_DESC	Residency Description	Residency code description.	VARCHAR2(255)	STVRESD	STVRESD_DESC
RESIDENCY_IND	Residency Indicator	Identifies whether the student is considered in or out of the district for enrollment charges. Typically this indicates in or out of state or province but may also be in or out of county or in or out of the European Union, etc.	VARCHAR2(1)	FUNCTION	DECODE(STVRESD_IN_STATE_IND)
SPORT_COUNT	Sport Count	Count of the number of sports activity recorded for the person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_SPORTS
SPORT_DESC_LIST	Sport Description List	List of the descriptions for each of the sports in which the student is participating.	VARCHAR2(4000)	FUNCTION	LISTAGG (ACTIVITY_DESC, '-')
SPORT_LIST	Sport List	List of all the sports in which the student is participating.	VARCHAR2(4000)	FUNCTION	LISTAGG (ACTIVITY, '-')
STUDENT_ATTRIBUTE_COUNT	Student Attribute Count	Count of student attributes recorded for the student.	NUMBER	FUNCTION	MSKFUNC.F_GET_STDNT_ATTR_CNT
STUDENT_ATTRIBUTE_DESC_LIST	Student Attribute Description List	List of the descriptions for all the student attributes assigned to this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (STUDENT_ATTRIBUTE_DESC, '-')
STUDENT_ATTRIBUTE_LIST	Student Attribute List	List of all the student attributes associated with this student.	VARCHAR2(4000)	FUNCTION	LISTAGG (STUDENT_ATTRIBUTE, '-')
STUDENT_CLASSIFICATION	Student Classification	Identifies the student's current class at the institution. The typical VALUES are first year, second year, or freshman, sophomore, etc..	VARCHAR2(63)	FUNCTION	F_CLASS_CALC_FNC
STUDENT_CLASSIFICATION_BOAP	Student Classification - Beginning of Academic Period	Identifies the students 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 Classification Description	Student classification description.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC
STUDENT_CLASS_BOAP_DESC	Student Classification - Beginning of Academic Period Description	Beginning of academic period student classification.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC
STUDENT_PLAN_ACTIVE_IND	Student Plan Active Indicator	Indicates whether this student has an active Banner registration plan.	VARCHAR2(1)	FUNCTION	MSKFUNC.F_GET_REG_PLAN_IND
STUDENT_PLAN_EXISTS_IND	Student Plan Exists Indicator	Indicates whether this student has a Banner registration plan.	VARCHAR2(1)	FUNCTION	MSKFUNC.F_GET_REG_PLAN_IND
STUDENT_STATUS	Student Status	Student's current status for the academic period. May include active and permitted to register, inactive and stop registration, graduated, etc.	VARCHAR2(63)	SGBSTDN	SGBSTDN_STST_CODE
STUDENT_STATUS_DESC	Student Status Description	Student's status description.	VARCHAR2(255)	STVSTST	STVSTST_DESC
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	NA	NA
THIRD_PARTY_PLAN_ACTIVE_IND	Third Party Plan Active Indicator	Indicates whether this student has an active third party plan such as Degree Works.	VARCHAR2(1)	FUNCTION	MDKFUNC.F_GET_THIRD_PARY_PLAN_IND
THIRD_PARTY_PLAN_EXISTS_IND	Third Party Plan Exists Indicator	Indicates whether this student has a third party plan such as Degree Works.	VARCHAR2(1)	FUNCTION	MDKFUNC.F_GET_THIRD_PARY_PLAN_IND
TOTAL_BILLING	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	Total Continuing Education Unit 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	Total Continuing Education Unit Credits	Sum of the continuing education units for the student for this academic period.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TOTAL_CREDITS	Total Credits	Sum of the registered credits for the student for this academic period.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TOTAL_NON_CEU_BILLING	Total Non Continuing Education Unit 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	Total Non Continuing Education Unit 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_CENTER	Transfer Center	Institution defined to identify the student association with a transfer center. May be used to identify a standard set of transfer procedures by state/province articulation agreements, etc.	VARCHAR2(63)	SGBSTDN	SGBSTDN_TRCN_CODE
TRANSFER_CENTER_DESC	Transfer Center Description	Transfer center description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
VETERAN_CATEGORY	Veteran Category	Veteran category as standardized by the federal government to track attendance of particular veteran types or groups.	VARCHAR2(1)	SPBPERS	SPBPERS_VERA_IND
VETERAN_CATEGORY_DESC	Veteran Category Description	Person's veteran category description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
VETERAN_CERTIFICATION_CREDITS	Veteran Certification Credits	Number of credits registered as reported to veteran's administration for this certification.	NUMBER	SGRVETN	SGRVETN_VETC_CODE
VETERAN_CERTIFICATION_DATE	Veteran Certification Date	Date the veteran certification was entered or last updated.	DATE	SGRVETN	SGRVETN_VETC_DATE
VETERAN_FILE_NO	Veteran File Number	Veteran administration assigned identification number.	VARCHAR2(255)	SPBPERS	SPBPERS_VETC_FILE_NUMBER
VETERAN_SPECIAL_DISABLED_IND	Veteran Special Disabled Indicator	Indicates whether the person has been qualified as a disabled veteran.	VARCHAR2(1)	SPBPERS	SPBPERS_SDVET_IND
VETERAN_TYPE	Veteran Type	Veteran type associated with the person record. This may indicate if the persons is a gulf war veteran, etc.	VARCHAR2(1)	SGRVETN	SGRVETN_VETC_CODE
VETERAN_TYPE_DESC	Veteran Type Description	Veteran type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC

Ver: 9.2