ACADEMIC_STUDY - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
PERSON_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SGBSTDN |
SGBSTDN_PIDM |
UNKNOWN |
ACADEMIC_YEAR |
ACADEMIC YEAR ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_ACYR_CODE |
UNKNOWN |
ACADEMIC_YEAR_DESC |
DESCRIPTION OF THE ACADEMIC YEAR ASSOCIATED WITH THIS RECORD. |
|
STVACYR |
STVACYR_DESC |
UNKNOWN |
ACADEMIC_PERIOD |
IDENTIFIES THE ACADEMIC PERIOD OR TERM ASSOCIATED WITH THIS INFORMATION. |
|
SGBSTDN |
SGBSTDN_TERM_CODE_EFF |
UNKNOWN |
ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
SUB_ACADEMIC_PERIOD |
IDENTIFIES THE SUB ACADEMIC PERIOD OR PART OF TERM ASSOCIATED WITH THE INFORMATION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
SUB_ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE SUB ACADEMIC PERIOD OR SESSION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PROGRAM |
IDENTIFIES THE PROGRAM OF STUDY OR THE COURSE OF STUDY BEING SOUGHT OR AWARDED TO THE STUDENT. |
|
SGBSTDN |
SGBSTDN_PROGRAM_1 |
UNKNOWN |
PROGRAM_DESC |
CURRICULUM PROGRAM DESCRIPTION |
|
SMRPRLE |
SMRPRLE_PROGRAM_DESC |
UNKNOWN |
PRIMARY_PROGRAM_IND |
SPECIFIES WHETHER THIS IS YOUR PRIMARY PROGRAM OF STUDY. |
|
FUNCTION |
? |
UNKNOWN |
START_DATE |
DATE THE SKILL WAS LEARNED. |
|
OLR |
NOT AVAILABLE |
UNKNOWN |
CURRENT_TIME_STATUS |
"SYSTEM CALCULATED TIME STATUS FOR THE ACADEMIC PERIOD (E.G. FULL TIME OR PART TIME, ETC.)." |
|
SFRTHST |
SFRTHST_TMST_CODE |
UNKNOWN |
CURRENT_TIME_STATUS_DESC |
DESCRIPTION FOR THE TIME STATUS. |
|
STVTMST |
STVTMST_DESC |
UNKNOWN |
CURRENT_TIME_STATUS_DATE |
SPECIFIES THE DATE ASSOCIATED WITH THE TIME STATUS CODE. |
|
SFRTHST |
SFBETRM_TMST_CODE |
UNKNOWN |
PROGRAM_NUMBER |
UNIQUE IDENTIFIER NUMBER FOR THE STUDENT'S ACADEMIC STUDY. FOR SCT BANNER, IT WILL BE SET TO 001 FOR THE PRIMARY CURRICULUM AND 002 FOR THE SECONDARY CURRICULUM. |
|
MANUAL |
PROGRAMATICALLY SET |
UNKNOWN |
CATALOG_ACADEMIC_PERIOD |
CURRICULUM CATALOG ACADEMIC PERIOD. |
|
SGBSTDN |
SGBSTDN_TERM_CODE_CTLG_1 |
UNKNOWN |
CATALOG_ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
STUDENT_LEVEL |
CURRICULUM LEVEL |
|
SGBSTDN |
SGBSTDN_LEVL_CODE |
UNKNOWN |
STUDENT_LEVEL_DESC |
DESCRIPTION FOR THE LEVEL OF ACADEMIC STUDY ASSOCIATED WITH THIS GPA. |
|
STVLEVL |
STVLEVL_DESC |
UNKNOWN |
DEGREE |
AWARD, DEGREE, CERTIFICATE, ETC DEFINED TO DOCUMENT SUCCESSFUL COMPLETION OF THE REQUIREMENTS FOR THIS ACADEMIC OUTCOME. |
|
SGBSTDN |
SGBSTDN_DEGC_CODE_1 |
UNKNOWN |
DEGREE_DESC |
DESCRIPTION OF THE OUTCOME, AWARD, DEGREE, CERTIFICATION, ETC. SOUGHT OR GRANTED. |
|
STVDEGC |
STVDEGC_DESC |
UNKNOWN |
AWARD_CATEGORY |
TYPICALLY THE GOVERNMENTAL CATEGORIES TO GROUP ACADEMIC OUTCOMES FOR REPORTING. |
|
STVDEGC |
STVDEGC_ATAC_CODE |
UNKNOWN |
AWARD_CATEGORY_DESC |
NAME FOR THE GOVERNMENTAL REPORTING CATEGORY. |
|
STVATAC |
STVATAC_DESC |
UNKNOWN |
MAJOR |
MAJOR SUBJECT AREA OF THE PERSON'S ACADEMIC STUDY. |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_1 |
UNKNOWN |
MAJOR_DESC |
NAME OF THE STUDENT'S MAJOR SUBJECT AREA. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
CAMPUS |
IDENTIFIES THE CAMPUS ASSOCIATED WITH THE RECORD. |
|
SGBSTDN |
SGBSTDN_CAMP_CODE |
UNKNOWN |
CAMPUS_DESC |
NAME OF THE CAMPUS ASSOCIATED WITH THE RECORD. |
|
STVCAMP |
STVCAMP_DESC |
UNKNOWN |
COLLEGE |
FIRST LAYER OF THE INSTITUTION ORGANIZATION. |
|
SGBSTDN |
SGBSTDN_COLL_CODE_1 |
UNKNOWN |
COLLEGE_DESC |
NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. |
|
STVCOLL |
STVCOLL_DESC |
UNKNOWN |
YEAR_ADMITTED |
ACADEMIC YEAR ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_ACYR_CODE |
UNKNOWN |
YEAR_ADMITTED_DESC |
|
|
STVACYR |
STVACYR_DESC |
UNKNOWN |
ACADEMIC_PERIOD_ADMITTED |
ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
SGBSTDN |
SGBSTDN_TERM_CODE_ADMIT |
UNKNOWN |
ACADEMIC_PERIOD_ADMITTED_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
SUB_ACADEMIC_PERIOD_ADMITTED |
ACADEMIC PERIOD OR SUB ACADEMIC PERIOD ASSOCIATED WITH THE INFORMATION ON THE ACADEMIC STUDY INFORMATION RECORD. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
SUB_ACADEMIC_PERIOD_ADMIT_DESC |
ACADEMIC PERIOD OR SUB ACADEMIC PERIOD ASSOCIATED WITH THE SESSION CODE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
START_DATE_ADMITTED |
NON ACADEMIC PERIOD BASED ADMISSIONS FIELD. DATE YOU STARTED STUDYING. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
YEAR_MATRICULATED |
ACADEMIC YEAR ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_ACYR_CODE |
UNKNOWN |
YEAR_MATRICULATED_DESC |
MATRICULATION YEAR DESCRIPTION. |
|
STVACYR |
STVACYR_DESC |
UNKNOWN |
ACADEMIC_PERIOD_MATRICULATED |
ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
SGBSTDN |
SGBSTDN_TERM_CODE_MATRIC |
UNKNOWN |
ACADEMIC_PERIOD_MATRIC_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
SUB_ACADEMIC_PERIOD_MATRIC |
MATRICULATION SUB ACADEMIC PERIOD OF THE STUDENT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
SUB_ACAD_PERIOD_MATRIC_DESC |
MATRICULATION SUB ACADEMIC PERIOD OF THE STUDENT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
START_DATE_MATRICULATED |
MATRICULATION START DATE OF THE STUDENT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
MATRICULATED_IND |
STUDENT IS MATRICULATED IN THIS ACADEMIC STUDY, 'Y' - YES OR 'N' - NO. |
|
DECODE |
SGBSTDN_TERM_CODE_MATRIC |
UNKNOWN |
ADMISSIONS_POPULATION |
"TYPE OF ADMISSION THIS APPLICANT IS SEEKING OR GRANTED (E.G.. EARLY ADMIT, REGULAR ADMIT, MATURE, SPECIAL, ETC.)." |
|
SGBSTDN |
SGBSTDN_ADMT_CODE |
UNKNOWN |
ADMISSIONS_POPULATION_DESC |
DESCRIPTION FOR THE ADMISSION TYPE. |
|
STVADMT |
STVADMT_DESC |
UNKNOWN |
DEPARTMENT |
SYSTEM GENERATED NUMBER THAT IS INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON. |
|
SGBSTDN |
SGBSTDN_DEPT_CODE |
UNKNOWN |
DEPARTMENT_DESC |
NAME OF THE THIRD LAYER (DEPARTMENT) OF THE INSTITUTION ORGANIZATION. |
|
STVDEPT |
STVDEPT_DESC |
UNKNOWN |
FIRST_CONCENTRATION |
"CONCENTRATION OR STUDY EMPHASIS ATTACHED TO THE MAJOR FOR THE STUDENT (E.G.. CHEMICAL, ELECTRICAL, INDUSTRIAL ENGINEERING, ETC.)." |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_CONC_1 |
UNKNOWN |
FIRST_CONCENTRATION_DESC |
NAME OF THE CONCENTRATION SUBJECT AREA OR EMPHASIS OF STUDY. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
SECOND_CONCENTRATION |
CONCENTRATION OR STUDY EMPHASIS ATTACHED TO THE MAJOR FOR THE STUDENT. EXAMPLE |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_CONC_1_2 |
UNKNOWN |
SECOND_CONCENTRATION_DESC |
NAME OF THE CONCENTRATION SUBJECT AREA OR EMPHASIS OF STUDY. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
THIRD_CONCENTRATION |
CONCENTRATION OR STUDY EMPHASIS ATTACHED TO THE MAJOR FOR THE STUDENT. EXAMPLE |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_CONC_1_3 |
UNKNOWN |
THIRD_CONCENTRATION_DESC |
NAME OF THE CONCENTRATION SUBJECT AREA OR EMPHASIS OF STUDY. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
SECOND_MAJOR |
MAJOR SUBJECT AREA OF THE PERSON'S ACADEMIC STUDY. |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_1_2 |
UNKNOWN |
SECOND_MAJOR_DESC |
NAME OF THE STUDENT'S MAJOR SUBJECT AREA. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
SECOND_DEPARTMENT |
THIRD LAYER OF THE INSTITUTION ORGANIZATION. |
|
SGBSTDN |
SGBSTDN_DEPT_CODE_1_2 |
UNKNOWN |
SECOND_DEPARTMENT_DESC |
NAME OF THE THIRD LAYER (DEPARTMENT) OF THE INSTITUTION ORGANIZATION. |
|
STVDEPT |
STVDEPT_DESC |
UNKNOWN |
SECOND_MAJOR_CONC_1 |
CONCENTRATION OR STUDY EMPHASIS ATTACHED TO THE MAJOR FOR THE STUDENT. EXAMPLE |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_CONC_121 |
UNKNOWN |
SECOND_MAJOR_CONC_1_DESC |
NAME OF THE CONCENTRATION SUBJECT AREA OR EMPHASIS OF STUDY. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
SECOND_MAJOR_CONC_2 |
CONCENTRATION OR STUDY EMPHASIS ATTACHED TO THE MAJOR FOR THE STUDENT. EXAMPLE |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_CONC_122 |
UNKNOWN |
SECOND_MAJOR_CONC_2_DESC |
NAME OF THE CONCENTRATION SUBJECT AREA OR EMPHASIS OF STUDY. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
SECOND_MAJOR_CONC_3 |
CONCENTRATION OR STUDY EMPHASIS ATTACHED TO THE MAJOR FOR THE STUDENT. EXAMPLE |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_CONC_123 |
UNKNOWN |
SECOND_MAJOR_CONC_3_DESC |
NAME OF THE CONCENTRATION SUBJECT AREA OR EMPHASIS OF STUDY. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
FIRST_MINOR |
MINOR SUBJECT AREA OF THE PERSON'S ACADEMIC STUDY. |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_MINR_1 |
UNKNOWN |
FIRST_MINOR_DESC |
NAME OF THE STUDENT'S MINOR SUBJECT AREA. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
SECOND_MINOR |
MINOR SUBJECT AREA OF THE PERSON'S ACADEMIC STUDY. |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_MINR_1_2 |
UNKNOWN |
SECOND_MINOR_DESC |
NAME OF THE STUDENT'S MINOR SUBJECT AREA. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
NON_TRADITIONAL_IND |
INDICATES IF THIS ACADEMIC STUDY IS OR IS NOT A TRADITIONAL TYPE OF STUDY. (E.G. NON-DEGREE GRANTING OR ACCELERATED.) |
|
NA |
NULL |
UNKNOWN |
ENROLLMENT_STATUS |
STUDENT ENROLLMENT STATUS CODE. |
|
SFBETRM |
SFBETRM_ESTS_CODE |
UNKNOWN |
ENROLLMENT_STATUS_DESC |
DESCRIPTION FOR THE STUDENT REGISTRATION STATUS. |
|
STVESTS |
STVESTS_DESC |
UNKNOWN |
ENROLLMENT_STATUS_DATE |
SPECIFIES THE DATE OF THE ENROLLMENT STATUS. |
|
SFBETRM |
SFBETRM_ESTS_DATE |
UNKNOWN |
ENROLLMENT_ADD_DATE |
DATE OF THE INITIAL REGISTRATION FOR THIS ACADEMIC PERIOD. |
|
SFBETRM |
SFBETRM_ADD_DATE |
UNKNOWN |
REGISTRATION_REASON |
NUMBER OF SPORTS RECORDS FOR THE PERSON IN THE ACADEMIC PERIOD. |
|
SFBETRM |
SFBETRM_RGRE_CODE |
UNKNOWN |
REGISTRATION_REASON_DESC |
DESCRIPTION OF THE REGISTRATION REASON CODE. |
|
STVRGRE |
STVRGRE_DESC |
UNKNOWN |
STUDENT_POPULATION |
TYPE OF STUDENT THE APPLICANT WILL BECOME IF ADMITTED. |
|
SGBSTDN |
SGBSTDN_STYP_CODE |
UNKNOWN |
STUDENT_POPULATION_DESC |
DESCRIPTION FOR THE STUDENT TYPE (E.G. NEW FRESHMAN, TRANSFER, ETC.) USED IN FEDERAL REPORTING. |
|
STVSTYP |
STVSTYP_DESC |
UNKNOWN |
STUDENT_MEETING_TIME |
SESSION OF THE STUDENT'S NORMAL ATTENDANCE. |
|
SGBSTDN |
SGBSTDN_SESS_CODE |
UNKNOWN |
STUDENT_MEETING_TIME_DESC |
DESCRIPTION FOR THE STUDENT'S SESSION (E.G. DAY, EVENING, WEEKEND, ETC.). |
|
STVSESS |
STVSESS_DESC |
UNKNOWN |
STUDENT_RATE |
IDENTIFIES A SPECIFIC ASSESSMENT RATE OF THE STUDENT FOR THE ACADEMIC PERIOD. |
|
SGBSTDN |
SGBSTDN_RATE_CODE |
UNKNOWN |
STUDENT_RATE_DESC |
DESCRIPTION OF THE RATE EXEMPTION CODE GRANTED TO THE PERSON. THIS WILL EFFECT THE AMOUNT SOME CHARGES GENERATED. |
|
STVRATE |
STVRATE_DESC |
UNKNOWN |
BLOCK_SCHEDULE |
BLOCK SCHEDULE ASSIGNED TO THE STUDENT. |
|
SGBSTDN |
SGBSTDN_BLCK_CODE |
UNKNOWN |
BLOCK_SCHEDULE_DESC |
DESCRIPTION FOR THE BLOCK SCHEDULE GROUP. |
|
STVBLCK |
STVBLCK_DESC |
UNKNOWN |
LEAVE_REASON |
LEAVE CODE ASSOCIATED WITH THE STUDENT FOR THIS ACADEMIC PERIOD. |
|
SGBSTDN |
SGBSTDN_LEAV_CODE |
UNKNOWN |
LEAVE_REASON_DESC |
DESCRIPTION FOR THE TYPE OF LEAVE GRANTED. |
|
STVLEAV |
STVLEAV_DESC |
UNKNOWN |
LEAVE_DATE_FROM |
START DATE OF THE STUDENT LEAVE. |
|
SGBSTDN |
SGBSTDN_LEAV_FROM_DATE |
UNKNOWN |
LEAVE_DATE_TO |
END DATE OF THE STUDENT LEAVE. |
|
SGBSTDN |
SGBSTDN_LEAV_TO_DATE |
UNKNOWN |
ACADEMIC_STANDING |
ACADEMIC STANDING OR PROGRESS OF THE STUDENT. |
|
SGBSTDN |
SGBSTDN_ASTD_CODE |
UNKNOWN |
ACADEMIC_STANDING_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S ACADEMIC STANDING. |
|
STVASTD |
STVASTD_DESC |
UNKNOWN |
ACADEMIC_STANDING_ACAD_PERIOD |
ACADEMIC STANDING OR PROGRESS OF THE STUDENT. |
|
SGBSTDN |
SGBSTDN_ASTD_CODE |
UNKNOWN |
ACAD_STANDING_ACAD_PERIOD_DESC |
ENDING ACADEMIC PERIOD. |
|
FUNCTION |
F_GET_END_SIRDPCL_TERM |
UNKNOWN |
GRAD_ACADEMIC_PERIOD_INTENDED |
INTENDED ACADEMIC PERIOD OF GRADUATION OF THE STUDENT. |
|
SGBSTDN |
SGBSTDN_TERM_CODE_GRAD |
UNKNOWN |
GRAD_ACAD_PERIOD_INTENDED_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
GRAD_YEAR_INTENDED |
INTENDED ACADEMIC YEAR OF GRADUATION OF THE STUDENT. |
|
SGBSTDN |
SGBSTDN_ACYR_CODE |
UNKNOWN |
GRAD_YEAR_INTENDED_DESC |
NAME OF THE INTENDED ACADEMIC YEAR OF GRADUATION. |
|
STVACYR |
STVACYR |
UNKNOWN |
EXPECTED_GRADUATION_DATE |
ACADEMIC STUDY COMPLETION DATE OF A STUDENT IN A DIRECT LOAN APPLICATION. |
|
SGBSTDN |
SGBSTDN_EXP_GRAD_DATE |
UNKNOWN |
DUAL_DEGREE |
DUAL DEGREE CODE. |
|
SGBSTDN |
SGBSTDN_DEGC_CODE_DUAL |
UNKNOWN |
DUAL_DEGREE_DESC |
NAME OF THE DUAL DEGREE CODE. |
|
STVDEGC |
STVDEGC_DESC |
UNKNOWN |
DUAL_DEGREE_LEVEL |
LEVEL ASSOCIATED WITH THE DUAL DEGREE. |
|
SGBSTDN |
SGBSTDN_LEVL_CODE_DUAL |
UNKNOWN |
DUAL_DEGREE_LEVEL_DESC |
DESCRIPTION FOR THE LEVEL OF ACADEMIC STUDY ASSOCIATED WITH THIS GPA. |
|
STVLEVL |
STVLEVL_DESC |
UNKNOWN |
DUAL_DEGREE_COLLEGE |
FIRST LAYER OF THE INSTITUTION ORGANIZATION. |
|
SGBSTDN |
SGBSTDN_COLL_CODE_DUAL |
UNKNOWN |
DUAL_DEGREE_COLLEGE_DESC |
NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. |
|
STVCOLL |
STVCOLL_DESC |
UNKNOWN |
DUAL_DEGREE_DEPARTMENT |
THIRD LAYER OF THE INSTITUTION ORGANIZATION. |
|
SGBSTDN |
SGBSTDN_DEPT_CODE_DUAL |
UNKNOWN |
DUAL_DEGREE_DEPARTMENT_DESC |
NAME OF THE THIRD LAYER (DEPARTMENT) OF THE INSTITUTION ORGANIZATION. |
|
STVDEPT |
STVDEPT_DESC |
UNKNOWN |
DUAL_DEGREE_MAJOR |
MAJOR SUBJECT AREA OF THE PERSON'S ACADEMIC STUDY. |
|
SGBSTDN |
SGBSTDN_MAJR_CODE_DUAL |
UNKNOWN |
DUAL_DEGREE_MAJOR_DESC |
NAME OF THE STUDENT'S MAJOR SUBJECT AREA. |
|
STVMAJR |
STVMAJR_DESC |
UNKNOWN |
PRIMARY_ADVISOR_TYPE |
PRIMARY ADVISOR TYPE CODE. |
|
SGRADVR |
SGRADVR_ADVR_CODE |
UNKNOWN |
PRIMARY_ADVISOR_TYPE_DESC |
ADVISING TYPE ASSOCIATED WITH THE PRIMARY ADVISOR. |
|
STVADVR |
STVADVR_DESC |
UNKNOWN |
PRIMARY_ADVISOR_PERSON_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SGRADVR |
SGRADVR_ADVR_PIDM |
UNKNOWN |
PRIMARY_ADVISOR_NAME_FMIL |
FULL NAME WITH THE FIRST NAME MIDDLE NAME LAST NAME. |
|
FUNCTION |
F_FORMAT_NAME |
UNKNOWN |
PRIMARY_ADVISOR_NAME_LFMI |
FULL NAME WITH THE LAST NAME, FIRST NAME, MIDDLE NAME. |
|
FUNCTION |
F_FORMAT_NAME |
UNKNOWN |
ADVISOR_COUNT |
NUMBER OF ADVISORS ASSIGNED TO THIS STUDENT. |
|
FUNCTION |
F_COUNT_ADVISORS |
UNKNOWN |
STUDENT_CLASSIFICATION |
SPECIFIES THE ACADEMIC PERIOD OR SUB ACADEMIC PERIOD ASSOCIATED WITH THE SESSION CODE. |
|
FUNCTION |
F_CLASS_FNC |
UNKNOWN |
STUDENT_CLASSIFICATION_DESC |
SUM OF THE BILLINGS FOR THE STUDENT. |
|
STVCLAS |
STVCLAS_DESC |
UNKNOWN |
GRADUATED_IND |
INDICATES THE STUDENT HAS COMPLETED THE REQUIREMENTS FOR ONE OR MORE OUTCOMES OR AWARDS IN THIS RECORD. |
|
FUNCTION |
F_CLASS_FNC |
UNKNOWN |
ENROLLED_IND |
"INDICATES THE STUDENT IS ENROLLED IN THIS ACADEMIC YEAR, ACADEMIC PERIOD AND OR SUB ACADEMIC PERIOD." |
|
FUNCTION |
F_ENROLLED_THIS_TERM |
UNKNOWN |
REGISTERED_IND |
"INDICATES THIS PERSON HAS ENROLLMENT RECORDS FOR THIS ACADEMIC YEAR, ACADEMIC PERIOD AND OR SUB ACADEMIC PERIOD." |
|
FUNCTION |
F_REGISTERED_THIS_TERM |
UNKNOWN |
INTENDED_TIME_STATUS |
FULLTIME-PART-TIME INDICATOR. IF NOT NULL |
|
SGBSTDN |
SGBSTDN_FULL_PART_IND |
UNKNOWN |
STUDENT_FTE |
SPECIFIES THE PORTION OF A FULL TIME EQUIVALENT REPRESENTED BY THIS STUDENT IN THIS ACADEMIC STUDY. CURRENTLY THIS COLUMN IS LEFT NULL. |
|
FUNCTION |
NULL |
UNKNOWN |
FTE_DIVISOR |
CURRENTLY THE FTE DIVISOR IS LEFT NULL. WILL BE ADDED IN THE NEXT RELEASE. |
|
FUNCTION |
NULL |
UNKNOWN |
FTE_IND |
STUDENT IS A FULL TIME EQUIVALENT, 'Y' - YES OR 'N' - NO. |
|
FUNCTION |
NULL |
UNKNOWN |
ACADEMIC_STANDING_END |
ACADEMIC STANDING OR PROGRESS ASSOCIATED WITH THE PERSON AT THE END OF THE ACADEMIC PERIOD. |
|
SHRTTRM |
SHRTTRM_ASTD_CODE_END_OF_TERM |
UNKNOWN |
ACAD_STANDING_END_DESC |
NAME OF THE ACADEMIC STANDING THAT IS ASSIGNED AT THE END OF THE ACADEMIC PERIOD. |
|
STVASTD |
STVASTD_DESC |
UNKNOWN |
ACADEMIC_STANDING_END_DATE |
DATE ASSOCIATED WITH THE PERSON'S END OF ACADEMIC PERIOD ACADEMIC STANDING. |
|
SHRTTRM |
SHRTTRM_ASTD_DATE_END_OF_TERM |
UNKNOWN |
DEANS_LIST_DATE |
DEAN'S LIST DATE. DATE ON WHICH THE DEAN'S LIST CODE WAS ENTERED. |
|
SHRTTRM |
SHRTTRM_ASTD_DATE_DL |
UNKNOWN |
DEANS_LIST_VALUE |
DEAN'S LIST CODE. IDENTIFIES IF THE STUDENT QUALIFIED FOR DEAN'S LIST FOR THE KEY ACADEMIC PERIOD. |
|
SHRTTRM |
SHRTTRM_ASTD_CODE_DL |
UNKNOWN |
DEANS_LIST_DESC |
DESCRIPTION ASSOCIATED WITH THE STUDENTS DEANS LIST CODE. |
|
STVASTD |
STVASTD_DESC |
UNKNOWN |
SPECIAL_EXAM_CREDIT |
SPECIAL EXAM CREDIT CODE. IDENTIFIES A SPECIAL EXAMINATION THE STUDENT TOOK DURING THE KEY ACADEMIC PERIOD. |
|
SHRTTRM |
SHRTTRM_EXAM_CODE |
UNKNOWN |
SPECIAL_EXAM_DESC |
DESCRIPTION FOR THE SPECIAL EXAMINATION CREDIT CODE. |
|
STVEXAM |
STVEXAM_DESC |
UNKNOWN |
TRANSFER_TO_INSTITUTION |
TRANSFER INSTITUTION CODE. INSTITUTION TO WHICH THE STUDENT WILL TRANSFER. |
|
SHRTTRM |
SHRTTRM_SBGI_CODE_TRANS |
UNKNOWN |
TRANSFER_TO_INSTITUTION_DESC |
NAME OF THE SOURCE/BACKGROUND INSTITUTION. |
|
STVSBGI |
STVSBGI_DESC |
UNKNOWN |
WITHDRAWAL_REASON |
WITHDRAWAL REASON CODE. IDENTIFIES THE REASON FOR THE STUDENT'S WITHDRAWAL FROM THIS INSTITUTION. |
|
SHRTTRM |
SHRTTRM_WRSN_CODE |
UNKNOWN |
WITHDRAWAL_REASON_DESC |
DESCRIPTION FOR THE WITHDRAWAL REASON CODE. |
|
STVWRSN |
STVWRSN_DESC |
UNKNOWN |