COURSE_CATALOG - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
COURSE_IDENTIFICATION |
COURSE SUBJECT AND COURSE NUMBER COMBINED |
|
FUNCTION |
? |
UNKNOWN |
SUBJECT |
SUBJECT CODE THAT THE ATTRIBUTE IS ASSOCIATED WITH |
|
SCBCRSE |
SCBCRSE_SUBJ_CODE |
UNKNOWN |
SUBJECT_DESC |
HIGH SCHOOL SUBJECT DESCRIPTION |
|
STVSUBJ |
STVSUBJ_DESC |
UNKNOWN |
COURSE_NUMBER |
COURSE NUMBER PORTION OF THIS SUBJECT IDENTIFICATION. |
|
SCBCRSE |
SCBCRSE_CRSE_NUMBER |
UNKNOWN |
COURSE_VERSION |
IDENTIFIES THE COURSE VERSION NUMBER. |
|
|
|
|
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. |
|
SCBCRSE |
SCBCRSE_EFF_TERM |
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 |
ACTIVE_COURSE_IND |
INDICATES THIS COURSE IS ACTIVE. |
|
FUNCTION |
F_ACTIVE_COUIRSE_IND |
UNKNOWN |
STATUS |
STATUS OF THE ACADEMIC OUTCOME AND IDENTIFIES THOSE OUTCOMES THAT ARE PENDING OR AWARDED. |
|
SCBCRSE |
SCBCSRE_CSTA_CODE |
UNKNOWN |
STATUS_DESC |
DESCRIPTION FOR THE STATUS CODE . |
|
STVCSTA |
STVCSTA_DESC |
UNKNOWN |
COURSE_COREQ_COUNT |
NUMBER OF COURSE CO-REQUISITES ASSOCIATED WITH A COURSE. |
|
FUNCTION |
F_CHECK_FOR_COURSE_COREQS |
UNKNOWN |
COURSE_PREREQS_COUNT |
NUMBER OF COURSE PRE-REQUISITES ASSOCIATED WITH THE COURSE. |
|
FUNCTION |
F_CHECK_FOR_COURSE_PREREQS |
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 |
NOT AVAILABLE |
UNKNOWN |
REPEATABLE_COURSE_IND |
INDICATES IF THE COURSE CAN BE REPEATED. |
|
FUNCTION |
? |
UNKNOWN |
NUMBER_OF_REPEATS_ALLOWED |
|
|
|
|
|
MAXIMUM_REPEAT_CREDITS |
|
|
SCBCRSE |
SCBCRSE_MAX_RPT_UNITS |
UNKNOWN |
REPEAT_STATUS_CODE |
REPEAT STATUS CODE USED FOR REPORTING PURPOSES. |
|
SCBCRSE |
SCBCRSE_REPS_CODE |
UNKNOWN |
REPEAT_STATUS_DESC |
DESCRIPTION OF THE REPEAT STATUS CODE. |
|
STVREPS |
STVREPS_DESC |
UNKNOWN |
COLLEGE |
FIRST LAYER OF THE INSTITUTION ORGANIZATION. |
|
SCBCRSE |
SCBCRSE_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_DESC |
NAME OF THE THIRD LAYER (DEPARTMENT) OF THE INSTITUTION ORGANIZATION. |
|
STVDEPT |
STVDEPT_DESC |
UNKNOWN |
DIVISION |
SECOND LAYER OF THE INSTITUTION ORGANIZATION. |
|
SCBCRSE |
SCBCRSE_DIVS_CODE |
UNKNOWN |
DIVISION_DESC |
NAME OF THE SECOND LAYER (DIVISION) OF THE INSTITUTION ORGANIZATION. |
|
STVDIVS |
STVDIVS_DESC |
UNKNOWN |
COURSE_CLASS_LEVEL |
NORMAL YEAR IN SCHOOL FOR STUDENT WHO TAKE THIS CLASS (FIRST YEAR, SECOND YEAR, ETC.). ETL PROCESSING MIGHT BE MODIFIED TO PULL INFORMATION AS DEFINED BY THE INSTITUTION IF APPROPRIATE OTHERWISE NOT POPULATED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
COURSE_CLASS_LEVEL_DESC |
INSTITUTIONAL DESCRIPTION OF THE YEAR IN SCHOOL. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
COURSE_LEVEL_COUNT |
NUMBER OF LEVEL CREDIT GROUPS ASSOCIATED WITH THE COURSE. EXAMPLE INCLUDE IN UNDERGRADUATE, GRADUATE, ETC. |
|
FUNCTION |
F_STUDENT_CHECK_FOR_MORE |
UNKNOWN |
MAJOR |
MAJOR SUBJECT AREA OF THE PERSON'S ACADEMIC STUDY. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
MAJOR_DESC |
NAME OF THE STUDENT'S MAJOR SUBJECT AREA. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
CONTINUING_EDUCATION_IND |
CONTINUING EDUCATION INDICATOR. |
|
SCBCRSE |
SCBCSRE_CEU_IND |
UNKNOWN |
CREDIT_MIN |
MINIMUM NUMBER OF CREDITS FOR WHICH A COURSE MAY BE OFFERED. CREDIT VALUE WILL CONTROL THE NUMBER OF CREDITS FOR WHICH SECTIONS CAN BE SCHEDULED AND FOR WHICH STUDENTS MAY REGISTER. |
|
SCBCRSE |
SCBCRSE_CREDIT_HR_LOW |
UNKNOWN |
CREDIT_MAX |
MINIMUM NUMBER OF CREDITS FOR WHICH A COURSE MAY BE OFFERED. CREDIT VALUE WILL CONTROL THE NUMBER OF CREDITS FOR WHICH SECTIONS CAN BE SCHEDULED AND FOR WHICH STUDENTS MAY REGISTER. |
|
SCBCRSE |
SCBCRSE_CREDIT_HR_HIGH |
UNKNOWN |
CREDIT_IND |
THIS FIELD DEFINES WHETHER THE COURSE CAN BE OFFERED FOR VARIABLE CREDIT. OR/TO IS USED TO SPECIFY THE RELATIONSHIP BETWEEN LOW AND HIGH CREDITS VALUES. AN OR/TO VALUE MUST EXIST TO ENTER CREDITS HIGH. |
|
SCBCRSE |
SCBCRSE_CREDIT_HR_IND |
UNKNOWN |
BILLING_MIN |
|
|
SCBCRSE |
SCBCRSE_BILLING_MIN |
UNKNOWN |
BILLING_MAX |
|
|
SCBCRSE |
SCBCRSE_BILLING_MAX |
UNKNOWN |
BILLING_IND |
|
|
SCBCRSE |
SCBCRSE_BILLING_IND |
UNKNOWN |
CONTACT_MIN |
CONTAINS THE SUM OF LOW LECTURE, LAB AND OTHERS HOURS COLUMNS. CONTACT HOURS DIVIDED BY 10 ARE THE CONTINUING EDUCATION UNITS FOR A CONTINUING ED COURSE. THIS CALCULATED VALUE IS STORED IN THE CREDIT HOUR FIELD WHEN THE CONTINUING EDUCATION INDICATOR FOR Y |
|
SCBCRSE |
SCBCRSE_CONT_HR_LOW |
UNKNOWN |
CONTACT_MAX |
CONTAINS THE SUM OF HIGH LECTURE, LAB AND OTHERS HOURS COLUMNS. CONTACT HOURS DIVIDED BY 10 ARE THE CONTINUING EDUCATION UNITS FOR A CONTINUING ED COURSE. THIS CALCULATED VALUE IS STORED IN THE CREDIT HOUR FIELD WHEN THE CONTINUING EDUCATION INDICATOR FOR Y |
|
SCBCRSE |
SCBCRSE_CONT_HR_HIGH |
UNKNOWN |
CONTACT_IND |
THIS COLUMN CONTAINS THE LITERAL TO OR OR TO DEFINE THE RELATIONSHIP BETWEEN THE LOW AND HIGH CONTACT HOURS |
|
SCBCRSE |
SCBCRSE_CONT_HR_IND |
UNKNOWN |
FA_FEDERAL_CREDITS |
NUMBER OF ELIGIBLE CREDITS FOR THIS COURSE FOR FEDERAL FINANCIAL AID REPORTING |
|
NA |
NOT AVAILABLE |
UNKNOWN |
FA_STATE_CREDITS |
NUMBER OF ELIGIBLE CREDITS FOR THIS COURSE FOR STATE FINANCIAL AID REPORTING |
|
NA |
NOT AVAILABLE |
UNKNOWN |
FA_COUNTY_CREDITS |
NUMBER OF ELIGIBLE CREDITS FOR THIS COURSE FOR COUNTY FINANCIAL AID REPORTING |
|
NA |
NOT AVAILABLE |
UNKNOWN |
REPORT_FEDERAL_CREDITS |
NUMBER OF ELIGIBLE CREDITS FOR THIS COURSE FOR FEDERAL REPORTING PURPOSES |
|
NA |
NOT AVAILABLE |
UNKNOWN |
REPORT_STATE_CREDITS |
NUMBER OF ELIGIBLE CREDITS FOR THIS COURSE FOR STATE REPORTING PURPOSES |
|
NA |
NOT AVAILABLE |
UNKNOWN |
REPORT_COUNTY_CREDITS |
NUMBER OF ELIGIBLE CREDITS FOR THIS COURSE FOR COUNTY REPORTING PURPOSES |
|
NA |
NOT AVAILABLE |
UNKNOWN |
TITLE_SHORT_DESC |
DISPLAYS THE SHORT TITLE OF THE COURSE. |
|
SCBCRSE |
SCBCRSE_TITLE |
UNKNOWN |
TITLE_LONG_DESC |
DISPLAYS THE LONG TITLE OF THE COURSE. |
|
SHRTCKN |
SHRTCKN_LONG_COURSE_TITLE |
UNKNOWN |
DEFAULT_GRADE_TYPE |
DEFAULT GRADE TYPE FLAG. |
|
DECODE |
SCRGMOD_DEFAULT_IND |
UNKNOWN |
DEFAULT_GRADE_TYPE_DESC |
DESCRIPTION OF THE DEFAULT GRADING TYPE (E.G. PASS/FAIL, LETTER, NUMERIC). |
|
STVGMOD |
STVGMOD_DESC |
UNKNOWN |
GRADE_TYPE_COUNT |
NUMBER OF GRADE SCHEMES ASSOCIATED WITH THE SCHEDULE OFFERING. THIS WILL EITHER BE ONE IF SPECIFIED ON THE SECTION |
|
FUNCTION |
? |
UNKNOWN |
ATTRIBUTE_COUNT |
NUMBER OF ATTRIBUTES ASSOCIATED WITH THE PERSON AS A FACULTY MEMBER. |
|
MSKFUNC |
F_COUNT_COURSE_ATTRIBUTES |
UNKNOWN |
SCHEDULE_COUNT |
NUMBER OF SCHEDULE TYPES OR INSTRUCTIONAL MODES ASSOCIATED WITH THE COURSE. |
|
FUNCTION |
F_STUDENT_CHECK_FOR_MORE |
UNKNOWN |
TAXONOMY_OF_PROGRAM_CODE |
TAXONOMY OF PROGRAM CODE |
|
SCBSUPP |
SCBSUPP_TOPS_CODE |
UNKNOWN |
TAXONOMY_OF_PROGRAM_DESC |
NAME OF TAXONOMY OF PROGRAM CODE |
|
STVTOPS |
STVTOPS_DESC |
UNKNOWN |
OCCUPATIONAL_COURSE_CODE |
OCCUPATIONAL COURSE INDICATOR CODE |
|
SCBSUPP |
SCBSUPP_OCCS_CODE |
UNKNOWN |
OCCUPATIONAL_COURSE_DESC |
DESCRIPTION FOR THE OCCUPATIONAL COURSE CODE. |
|
STVOCCS |
STVOCCS_DESC |
UNKNOWN |
COURSE_CLASSIFICATION_CODE |
CLASSIFICATION CODE DESIGNATING COURSE SUBJECT MATTER GROUPING |
|
SCBSUPP |
SCBSUPP_CCSL_CODE |
UNKNOWN |
COURSE_CLASSIFICATION_DESC |
DESCRIPTIVE NAME GIVEN TO THE CLASSIFICATION OF COURSE SUBJECT MATTER |
|
STVCCSL |
STVCCSL_DESC |
UNKNOWN |
CLASSIFICATION_INSTRUCT_PROG |
TEXT DESCRIBING THE AREA OF STUDY. FOR EXAMPLE DESCRIPTION ASSOCIATED WITH THE CIP CODES USED IN INTEGRATED POSTSECONDARY EDUCATION DATA SYSTEM (IPEDS) REPORTING IN THE US. |
|
STVCIPC |
STVCIPC_DESC |
UNKNOWN |
CLASS_INSTRUCT_PROG_DESC |
CLASSIFICATION OF INSTRUCTIONAL PROGRAMS (CIP) CODE ASSIGNED TO AN AREA OF STUDY USED FOR GOVERNMENTAL REPORTING. |
|
SCBCRSE |
SCBCRSE_CIPC_CODE |
UNKNOWN |
COURSE_APPROVAL |
THIS FIELD IS USED TO RECORD THE TYPE OF REQUIREMENTS A COURSE IS APPROVED TO FULFILL. |
|
SCBCRSE |
SCBCRSE_APRV_CODE |
UNKNOWN |
COURSE_APPROVAL_DESC |
SPECIAL TYPE OF APPROVAL REQUIRED FOR REGISTRATION (E.G. DEAN'S, INSTRUCTOR'S, ETC.). |
|
STVAPRV |
STVAPRV_DESC |
UNKNOWN |
COOPERATIVE_EDUCATION_IND |
COOPERATIVE EDUCATION INDICATOR |
|
SCBSUPP |
SCBSUPP_COOP_ED_IND |
UNKNOWN |
COURSE_CREDIT_CATEGORY |
CODE FOR CALIFORNIA MIS PROCESS FOR FIELD CB22. |
|
SCBSUPP |
SCBSUPP_CREDIT_CATEGORY_IND |
UNKNOWN |
COURSE_INFO1 |
GENERIC TEXT FIELD FOR INSTITUTIONAL DEFINED REPORTING. |
|
SCBSUPP |
SCBSUPP_CUDA_CODE |
UNKNOWN |
COURSE_INFO2 |
GENERIC TEXT FIELD FOR INSTITUTIONAL DEFINED REPORTING. |
|
SCBSUPP |
SCBSUPP_CUDB_CODE |
UNKNOWN |
COURSE_INFO3 |
GENERIC TEXT FIELD FOR INSTITUTIONAL DEFINED REPORTING. |
|
SCBSUPP |
SCBSUPP_CUDC_CODE |
UNKNOWN |
COURSE_INFO4 |
GENERIC TEXT FIELD FOR INSTITUTIONAL DEFINED REPORTING. |
|
SCBSUPP |
SCBSUPP_CUDD_CODE |
UNKNOWN |
COURSE_INFO5 |
GENERIC TEXT FIELD FOR INSTITUTIONAL DEFINED REPORTING. |
|
SCBSUPP |
SCBSUPP_CUDE_CODE |
UNKNOWN |
COURSE_INFO6 |
GENERIC TEXT FIELD FOR INSTITUTIONAL DEFINED REPORTING. |
|
SCBSUPP |
SCBSUPP_CUDF_CODE |
UNKNOWN |
DURATION_UNIT_CODE |
DURATION UNIT CODE INDICATES THE TYPE OF DURATION THE COURSE IS OFFERED FOR |
|
SCBCRSE |
SCBCRSE_DUNT_CODE |
UNKNOWN |
COURSE_DURATION |
THIS FIELD INDICATIONS THE NORMAL COURSE LENGTH IN THE DURATION UNITS LISTED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |