| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
SCRCORQ_COREQ
|
|
Defines the corequisite course subj_code + crse_numb for the catalog corequisite courses
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SIRASGN_CONCAT
|
|
Defines Faculty Assignment Type Code
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SIRASGN_CONCAT_DESC
|
|
Defines Faculty Assignment Type Code description
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSBDESC_CONCAT
|
|
Defines the Course section descriptive text
|
VARCHAR2(4000 CHAR)
|
|
|
|
|
SSBFSEC_CONCAT
|
|
Defines the Mid term, Final term and Wait list display indicator
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSBOVRR_CONCAT
|
|
Defines the Concatenated field of Test Code, Pre req requirements, Level code, Min grade, min Score
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSBOVRR_CONCAT_DESC
|
|
Defines the Overide code for College, Taxonomy of Program, Division and Department
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSBSECT_ACAD_CUT_OFF_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_ACCL_CODE
|
|
|
VARCHAR2(2 CHAR)
|
|
|
|
|
SSBSECT_ACCT_CODE
|
|
|
VARCHAR2(2 CHAR)
|
|
|
|
|
SSBSECT_ACTIVITY_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_BEST_OF_COMP
|
|
|
NUMBER(3)
|
|
|
|
|
SSBSECT_BILL_HRS
|
|
|
VARCHAR2(20 CHAR)
|
|
|
|
|
SSBSECT_CAMP_CODE
|
|
|
VARCHAR2(3 CHAR)
|
|
|
|
|
SSBSECT_CAPP_PREREQ_TEST_IND
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
SSBSECT_CENSUS_2_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_CENSUS_2_ENRL
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_CENSUS_ENRL
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_CENSUS_ENRL_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_CONT_HR
|
|
|
VARCHAR2(20 CHAR)
|
|
|
|
|
SSBSECT_CREDIT_HRS
|
|
|
VARCHAR2(20 CHAR)
|
|
|
|
|
SSBSECT_CRN
|
|
|
VARCHAR2(5 CHAR)
|
|
|
|
|
SSBSECT_CRSE_NUMB
|
|
|
VARCHAR2(5 CHAR)
|
|
|
|
|
SSBSECT_CRSE_TITLE
|
|
|
VARCHAR2(100 CHAR)
|
|
|
|
|
SSBSECT_DATA_ORIGIN
|
|
|
VARCHAR2(100 CHAR)
|
|
|
|
|
SSBSECT_DROP_CUT_OFF_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_DUNT_CODE
|
|
|
VARCHAR2(4 CHAR)
|
|
|
|
|
SSBSECT_ENRL
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_ENRL_CUT_OFF_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_GMOD_CODE
|
|
|
VARCHAR2(50 CHAR)
|
|
|
|
|
SSBSECT_GMOD_CODE_DESC
|
|
|
VARCHAR2(2000 CHAR)
|
|
|
|
|
SSBSECT_GRADABLE_IND
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
SSBSECT_GSCH_NAME
|
|
|
VARCHAR2(10 CHAR)
|
|
|
|
|
SSBSECT_INSM_CODE
|
|
|
VARCHAR2(5 CHAR)
|
|
|
|
|
SSBSECT_INTG_CDE
|
|
|
VARCHAR2(5 CHAR)
|
|
|
|
|
SSBSECT_LAB_HR
|
|
|
VARCHAR2(20 CHAR)
|
|
|
|
|
SSBSECT_LEARNER_REGSTART_FDATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_LEARNER_REGSTART_FDATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_LEARNER_REGSTART_TDATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_LEC_HR
|
|
|
VARCHAR2(20 CHAR)
|
|
|
|
|
SSBSECT_LINK_IDENT
|
|
|
VARCHAR2(2 CHAR)
|
|
|
|
|
SSBSECT_MAX_ENRL
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_NUMBER_OF_EXTENSIONS
|
|
|
NUMBER(3)
|
|
|
|
|
SSBSECT_NUMBER_OF_UNITS
|
|
|
NUMBER(7,2)
|
|
|
|
|
SSBSECT_OTH_HR
|
|
|
VARCHAR2(20 CHAR)
|
|
|
|
|
SSBSECT_PRIOR_ENRL
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_PRNT_IND
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
SSBSECT_PROJ_ENRL
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_PTRM_CODE
|
|
|
VARCHAR2(3 CHAR)
|
|
|
|
|
SSBSECT_PTRM_END_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_PTRM_START_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_PTRM_WEEKS
|
|
|
NUMBER(3)
|
|
|
|
|
SSBSECT_REG_FROM_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_REG_ONEUP
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_REG_TO_DATE
|
|
|
DATE
|
|
|
|
|
SSBSECT_RESERVED_IND
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
SSBSECT_SAPR_CODE
|
|
|
VARCHAR2(2 CHAR)
|
|
|
|
|
SSBSECT_SCHD_CODE
|
|
|
VARCHAR2(3 CHAR)
|
|
|
|
|
SSBSECT_SEATS_AVAIL
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_SEQ_NUMB
|
|
|
VARCHAR2(3 CHAR)
|
|
|
|
|
SSBSECT_SESS_CODE
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
SSBSECT_SSTS_CODE
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
SSBSECT_SUBJ_CODE
|
|
|
VARCHAR2(4 CHAR)
|
|
|
|
|
SSBSECT_SUBSET_OF_COMP
|
|
|
NUMBER(3)
|
|
|
|
|
SSBSECT_TERM_CODE
|
|
|
VARCHAR2(6 CHAR)
|
|
|
|
|
SSBSECT_TOT_CREDIT_HRS
|
|
|
NUMBER(9,3)
|
|
|
|
|
SSBSECT_TUIW_IND
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
SSBSECT_USER_ID
|
|
|
VARCHAR2(100 CHAR)
|
|
|
|
|
SSBSECT_VOICE_AVAIL
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
SSBSECT_WAIT_AVAIL
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_WAIT_CAPACITY
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSECT_WAIT_COUNT
|
|
|
NUMBER(4)
|
|
|
|
|
SSBSSEC_CONCAT
|
|
Defines the Mid term, Final term and Grade detail display indicator
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSBXLST_CONCAT
|
|
Defines Cross List Group Identifier
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSBXLST_CONCAT_DESC
|
|
Defines description of the cross list enrollment
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRATTR_CONCAT
|
|
Defines the attribute code of the section
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRATTR_CONCAT_DESC
|
|
Defines the attribute code description of the section
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRBLCK_CONCAT
|
|
Defines the Block Schedule Code
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRBLCK_CONCAT_DESC
|
|
Defines the Block Schedule Code Descriptions
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRCORQ_CONCAT
|
|
Defines the course reference number of the section co-requisite you are creating
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRFEES_CONCAT
|
|
Defines the type of fee code to fee assessment
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRFEES_CONCAT_DESC
|
|
Defines the type of fee code descriptions to fee assessment
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRLINK_CONCAT
|
|
Defines the link connector of the course section for which you are creating a link
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRMEET_CONCAT
|
|
Defines the course section contract code description
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRARE_CONCAT
|
|
Defines the Area Restriction(s) of students for which Section registration restrictions exist
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRARE_CONCAT_DESC
|
|
Defines the Area Restriction descriptions of students for which Section registration restrictions exist
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRCLS_CONCAT
|
|
Defines the class code(s) for the classes to be restricted
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRCLS_CONCAT_DESC
|
|
Defines the class code(s) descriptions for the classes to be restricted
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRCMP_CONCAT
|
|
Defines the Section campus restriction campus code
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRCMP_CONCAT_DESC
|
|
Defines the Section campus restriction campus code descriptions
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRCOL_CONCAT
|
|
Defines the college code for the college(s) you are restricting from the course section you are creating
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRCOL_CONCAT_DESC
|
|
Defines the college code descriptions for the college(s) you are restricting from the course section you are creating
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRDEG_CONCAT
|
|
Defines the degree codes of students for which Section registration restrictions exist
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRDEG_CONCAT_DESC
|
|
Defines the degree code descriptions of students for which Section registration restrictions exist
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRESV_CONCAT
|
|
Defines the Reserved Seat codes for Section Level, Major, and Class with the Waitlist count and Waitlist availability coun
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRESV_CONCAT_DESC
|
|
Defines the Reserved Seat code descriptions for Section Level, Major, and Class cod
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRLVL_CONCAT
|
|
Defines the Section Level Restriction Level Code
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRLVL_CONCAT_DESC
|
|
Defines the Section Level Restriction Level Code descriptions
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRMAJ_CONCAT
|
|
Defines the major code values for the major(s) you are restricting from the course section
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRMAJ_CONCAT_DESC
|
|
Defines the major code descriptions for the major(s) you are restricting from the course section
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRPRG_CONCAT
|
|
Defines the Program(s) of students for which Section registration restrictions exist
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRPRG_CONCAT_DESC
|
|
Describes the program code
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRRTST_CONCAT
|
|
Defines the attribute code of the section
|
VARCHAR2(4000 CHAR)
|
|
|
|
|
SSRSCCD_CONCAT
|
|
Defines the course section contract code
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRSCCD_CONCAT_DESC
|
|
Defines the course section contract code description
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRSPRT_CONCAT
|
|
Defines Partition code for schedule section entry
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRSPRT_CONCAT_DESC
|
|
Defines Partition code decription for schedule section entry
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRSRDF_CONCAT
|
|
Defines Room definition/attribute code for schedule section entry.
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRSRDF_CONCAT_DESC
|
|
Defines Room definition/attribute code description for schedule section entry.
|
VARCHAR2(3000 CHAR)
|
|
|
|
|
SSRSYLN_LONG_COURSE_TITLE
|
|
Defines the long title of the section
|
VARCHAR2(4000 CHAR)
|
|
|
|
|
SSRSYLN_SECTION_URL
|
|
Defines the URL of the section
|
VARCHAR2(4000 CHAR)
|
|
|
|
|
SSRSYLO_LEARNING_OBJECTIVES
|
|
Defines the learning objective of the section
|
VARCHAR2(4000 CHAR)
|
|
|
|
|
SSRSYRM_REQ_MATERIALS
|
|
Defines the required materials of the section
|
VARCHAR2(4000 CHAR)
|
|
|
|
|
SSRSYTR_TECH_REQUIREMENT
|
|
Defines the technical requirement of the section
|
VARCHAR2(4000 CHAR)
|
|
|
|
|
SSRTEXT_CONCAT
|
|
Defines the text/comments that have been defined for a section
|
VARCHAR2(4000 CHAR)
|
|
|
|
|
SSRXLST_CONCAT
|
|
Defines Cross List Group Identifier Number
|
VARCHAR2(3000 CHAR)
|
|
|
|