RETURN TO STUDENT META DATA REPORTS

STUDENT_COURSE - 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. SFRSTCR SFRSTCR_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. SFRSTCR SFRSTCR_TERM_CODE UNKNOWN
ACADEMIC_PERIOD IDENTIFIES THE ACADEMIC PERIOD OR TERM ASSOCIATED WITH THIS INFORMATION. SHRTCKN SHRTCKN_TERM_CODE UNKNOWN
ACADEMIC_PERIOD IDENTIFIES THE ACADEMIC PERIOD OR TERM ASSOCIATED WITH THIS INFORMATION. SHRTRCE SHRTRCE_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. SFRSTCR SFRSTCR_PTRM_CODE (NOT ON OLR) UNKNOWN
SUB_ACADEMIC_PERIOD_DESC DESCRIPTION OF THE SUB ACADEMIC PERIOD OR SESSION. STVPTRM STVPTRM_DESC UNKNOWN
COURSE_IDENTIFICATION COURSE SUBJECT AND COURSE NUMBER COMBINED FUNCTION COMBINE SSBSECT COLUMNS UNKNOWN
SUBJECT SUBJECT CODE THAT THE ATTRIBUTE IS ASSOCIATED WITH SSBSECT SSBSECT_SUBJ_CODE UNKNOWN
SUBJECT_DESC HIGH SCHOOL SUBJECT DESCRIPTION STVSUBJ STVSUBJ_DESC UNKNOWN
COURSE_NUMBER COURSE NUMBER PORTION OF THIS SUBJECT IDENTIFICATION. SSBSECT SSBSECT_CRSE_NUMB UNKNOWN
COURSE_SECTION_NUMBER SECTION NUMBER OF A COURSE. SSBSECT SSBSECT_SEQ_NO UNKNOWN
COURSE_VERSION IDENTIFIES THE COURSE VERSION NUMBER. NA NOT AVAILABLE UNKNOWN
COURSE_REFERENCE_NUMBER COURSE REFERENCE NUMBER. SFRSTCR SFRSTCR_CRN UNKNOWN
START_DATE DATE THE SKILL WAS LEARNED. SFRAREG OR SSBSECT SFRAREG_START_DATE UNKNOWN
END_DATE DATE THE SKILL WAS ENDED. SFRAREG SFRAREG_END_DATE UNKNOWN
END_DATE DATE THE SKILL WAS ENDED. SSBSECT SSBSECT_END_DATE UNKNOWN
EXTENSIONS NUMBER OF EXTENSIONS GRANTED TO AN OPEN LEARNING STUDENT TO COMPLETE THE INSTRUCTION SFRAREG SFRAREG_EXTENSION_NUMBER UNKNOWN
FINALIZED_COMPLETION_DATE DATE AN OPEN LEARNING STUDENT COMPLETED THE STUDY NA NOT AVAILABLE UNKNOWN
INSTITUTION_COURSE_IND THIS FIELD STORES A 'Y' OR 'N' TO INDICATE IF THE COURSE WAS TAKEN AT THE INSTITUTION OR NOT. FUNCTION NOT AVAILABLE UNKNOWN
IN_PROGRESS_COURSE_IND THIS FIELD STORES A 'Y' OR 'N' TO INDICATE IF THE COURSE IS IN PROGRESS AND NOT YET GRADED. FUNCTION NOT AVAILABLE UNKNOWN
TRANSFER_COURSE_IND THIS FIELD STORES A 'Y' OR 'N' TO INDICATE IF THE COURSE IS A TRANSFER COURSE OR NOT. FUNCTION NOT AVAILABLE UNKNOWN
REGISTRATION_STATUS COURSE REGISTRATION STATUS ASSOCIATED WITH THIS SECTION OR OFFERING . SFRSTCR SFRSTCR_RSTS_CODE UNKNOWN
REGISTRATION_STATUS_DESC DESCRIPTION FOR THE COURSE REGISTRATION STATUS. STVRSTS STVRSTS_DESC UNKNOWN
REGISTRATION_STATUS_DATE DATE ASSOCIATED WITH THE COURSE REGISTRATION STATUS OF THIS SECTION OR OFFERING . SFRSTCR SFRSTCR_RSTS_DATE UNKNOWN
SPECIAL_APPROVAL_IND SPECIAL APPROVAL RECEIVED INDICATOR FOR THIS SECTION OR OFFERING . SFRSTCR SFRSTCR_APPR_RECEIVED_IND UNKNOWN
REGISTRATION_ERROR_FLAG IDENTIFIES AN ERROR ASSOCIATED WITH THE REGISTRATION OF THIS SECTION OR OFFERING . SFRSTCR SFRSTCR_ERROR_FLAG UNKNOWN
REGISTRATION_SEQUENCE_NUMBER REGISTRATION SEQUENCE NUMBER. SFRSTCR SFRSTCR_REG_SEQ UNKNOWN
COURSE_LEVEL LEVEL OF THE COURSE FOR THIS STUDENT. SFRSTCR SFRSTCR_LEVL_CODE UNKNOWN
COURSE_LEVEL LEVEL OF THE COURSE FOR THIS STUDENT. SHRTATC SHRTATC_TLVL_CODE UNKNOWN
COURSE_LEVEL LEVEL OF THE COURSE FOR THIS STUDENT. SHRTCKL SHRTCKL_LEVL_CODE UNKNOWN
COURSE_LEVEL_DESC DESCRIPTION FOR THE LEVEL OF ACADEMIC STUDY ASSOCIATED WITH THIS GPA. STVLEVL STVLEVL_DESC UNKNOWN
COLLEGE FIRST LAYER OF THE INSTITUTION ORGANIZATION. SCBCRSE SCBCRSE_COLL_CODE UNKNOWN
COLLEGE FIRST LAYER OF THE INSTITUTION ORGANIZATION. SHRTCKN SHRTCKN_COLL_CODE UNKNOWN
COLLEGE FIRST LAYER OF THE INSTITUTION ORGANIZATION. SSBOVRR SSBOVRR_COLL_CODE UNKNOWN
COLLEGE_DESC NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. STVCOLL STVCOLL_DESC UNKNOWN
DEPARTMENT SYSTEM GENERATED NUMBER THAT IS INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON. SCBCRSE SCBCRSE_DEPT_CODE UNKNOWN
DEPARTMENT SYSTEM GENERATED NUMBER THAT IS INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON. SSBOVRR SSBOVRR_DEPT_CODE UNKNOWN
DEPARTMENT SYSTEM GENERATED NUMBER THAT IS INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON. SHRTCKN SHRTCKN_DEPT_CODE UNKNOWN
DEPARTMENT_DESC NAME OF THE THIRD LAYER (DEPARTMENT) OF THE INSTITUTION ORGANIZATION. STVDEPT STVDEPT_DESC UNKNOWN
DIVISION SECOND LAYER OF THE INSTITUTION ORGANIZATION. SCBCRSE SCBCRSE_DEPT_CODE UNKNOWN
DIVISION SECOND LAYER OF THE INSTITUTION ORGANIZATION. SSBOVRR SSBOVRR_DIVS_CODE UNKNOWN
DIVISION SECOND LAYER OF THE INSTITUTION ORGANIZATION. SHRTCKN SHRTCKN_DIVS_CODE UNKNOWN
DIVISION_DESC NAME OF THE SECOND LAYER (DIVISION) OF THE INSTITUTION ORGANIZATION. STVDIVS STVDIVS_DESC UNKNOWN
COURSE_TITLE_SHORT SHORT COURSE TITLE. SSBSECT SSBSECT_TITLE UNKNOWN
COURSE_TITLE_LONG LONG COURSE TITLE. SSRSYLN SSRSYLN_LONG_COURSE_TITLE UNKNOWN
GRADABLE_IND THIS FIELD IS USED TO SPECIFY WHETHER OR NOT THE OFFERING IS GRADABLE. IT IS A REQUIRED FIELD AND Y - YES SSBSECT SSBSECT_GRADABLE_IND UNKNOWN
SCHEDULE_TYPE INSTRUCTIONAL TYPE OF THE SECTION. SSBSECT SSBSECT_SCHD_CODE UNKNOWN
SCHEDULE_TYPE_DESC DESCRIPTION OF THE SCHEDULE OR INSTRUCTION TYPE FOR A COURSE. STVSCHD STVSCHD_DESC UNKNOWN
INSTRUCTION_METHOD THIS FIELD IDENTIFIES THE INSTRUCTIONAL METHOD OF THE SECTION. SSBSECT SSBSECT_INSM_CODE UNKNOWN
INSTRUCTION_METHOD_DESC INSTRUCTIONAL METHOD GTVINSM GTVINSM_DESC UNKNOWN
COURSE_BILLING NUMBER OF BILLING UNITS FOR THIS SECTION. SFRSTCR SFRSTCR_BILL_HR UNKNOWN
CREDITS_ATTEMPTED CREDITS ATTEMPTED THAT ARE FLAGGED AS APPLICABLE TO THIS ACADEMIC OUTCOME. NA NOT AVAILABLE UNKNOWN
CREDITS_PASSED CREDITS ATTEMPTED THAT ARE FLAGGED AS APPLICABLE TO THIS ACADEMIC OUTCOME. NA NOT AVAILABLE UNKNOWN
QUALITY_POINTS QUALITY POINTS TOTALED FOR ALL COURSES OR SUBJECTS USED TO SATISFY THE REQUIREMENTS FOR THIS ACADEMIC OUTCOME. NA NOT AVAILABLE UNKNOWN
CREDITS_EARNED CREDITS ATTEMPTED THAT ARE FLAGGED AS APPLICABLE TO THIS ACADEMIC OUTCOME. NA NOT AVAILABLE UNKNOWN
COURSE_CREDITS NUMBER OF CREDIT HOURS FOR THIS SECTION SFRSTCR SFRSTCR_CREDIT_HR UNKNOWN
HOURS_ATTENDED THIS COLUMN CONTAINS THE NUMBER OF HOURS THE STUDENT ATTENDED THIS SECTION. SFRSTCR SFRSTCR_ATTEND_HR UNKNOWN
FINAL_GRADE GRADE CODE ASSOCIATED WITH THIS SECTION OR OFFERING . SFRSTCR SFRSTCR_GRDE_CODE UNKNOWN
MID_TERM_GRADE MID-TERM GRADE CODE ASSOCIATED WITH THIS SECTION OR OFFERING. SFRSTCR SFRSTCR_GRDE_CODE_MID UNKNOWN
INCOMPLETE_EXT_DATE INSTITUTIONAL COURSE INCOMPLETE EXTENSION DATE. EXTENSION DATE ASSOCIATED WITH AN INCOMPLETE GRADE. NA NOT AVAILABLE UNKNOWN
FINAL_GRADE_DATE DATE ASSOCIATED WITH THE GRADE OF THIS SECTION OR OFFERING . SFRSTCR SFRSTCR_GRDE_DATE UNKNOWN
FINAL_GRADE_ROLL_IND NA NOT AVAILABLE UNKNOWN
FINAL_GRADE_QUALITY_POINTS QUALITY POINTS ASSOCIATED WITH THE GRADE. SHRGRDE SHRGRDE_QUALITY_POINTS UNKNOWN
FINAL_GRADE_TRADITIONAL_IND TRADITIONAL INDICATOR FOR THE FINAL GRADE. SHRGRDE SHRGRDE_TRADITIONAL_IND UNKNOWN
GRADE_TYPE DISPLAYS VALUE WHEN ONLY ONE GRADING MODE IS AVAILABLE FOR THIS OFFERING. FOR EXAMPLE, ONLY LETTER GRADES OR ONLY PASS/FAIL OPTION? SFRSTCR SFRSTCR_GMOD_CODE UNKNOWN
GRADE_TYPE_DESC DESCRIPTION OF THE DEFAULT GRADING TYPE (E.G. PASS/FAIL, LETTER, NUMERIC). STVGMOD STVGMOD_DESC UNKNOWN
COUNT_IN_GPA_IND SPECIFIES IF THE COURSE GRADE SHOULD BE USED IN THE CALCULATION OF THE GPA. SHRGRDE SHRGRDE_GPA_IND UNKNOWN
REPEAT_COURSE_IND REPEAT COURSE INDICATOR. INDICATES WHETHER THE COURSE WAS TAKEN AS A REPEAT COURSE BY THE STUDENT. NA NOT AVAILABLE UNKNOWN
SECTION_ADD_DATE DATE OF THE STUDENT WAS ENROLLED IN THIS OFFERING OR SECTION. SFRSTCR SFRSTCR_ADD_DATE UNKNOWN
CAMPUS IDENTIFIES THE CAMPUS ASSOCIATED WITH THE RECORD. SHRTCKN SHRTCKN_CAMP_CODE UNKNOWN
CAMPUS IDENTIFIES THE CAMPUS ASSOCIATED WITH THE RECORD. SSBSECT SSBSECT_CAMP_CODE UNKNOWN
CAMPUS_DESC NAME OF THE CAMPUS ASSOCIATED WITH THE RECORD. STVCAMP STVCAMP_DESC UNKNOWN
REGISTRATION_USER_ID USER ID OF THE PERSON WHO ENTERED THE REGISTRATION REQUEST. SFRSTCR SFRSTCR_USER UNKNOWN
COURSE_ATTRIBUTES_COUNT THIS FIELD WILL CONTAIN THE NUMBER OF COURSE ATTRIBUTES WHICH EXIST THAT STIPULATE THAT PASSING THIS COURSE WILL SATISFY AN OUTCOME REQUIREMENT. FUNCTION ? UNKNOWN
TRANSFER_COURSE_INSTITUTION TRANSFERRING INSTITUTION CODE. NA NOT AVAILABLE UNKNOWN
TRANSFER_COURSE_INST_DESC NAME OF THE TRANSFERRING INSTITUTION WHERE THE TRANSFER COURSER ORIGINATED. NA NOT AVAILABLE UNKNOWN