Skip to main content
CollegeSource Support

Linking Course Catalog Data


The uAchieve Planner displays various information about a course based upon the course's catalog information. When viewing courses on the roadmap or the plan, the course's title and hours are easily identified. Hours information is heavily used in the Planner, as hours are adjusted accordingly based upon building roadmaps and/or plans to determine completion status. Additional information can be retrieved about a specific course, including course department, number, title, hours, a longer course description, as well as any additional information about the course that is customizable by you. We provide up to four custom fields that can be labeled and displayed as part of the course information. We also provide the option to display back to the end users the course availability, along with any prerequisite and/or corequisite course requirements that a specific course might have.

There are currently two methods to choose from to make this course catalog information available within uAchieve Planner.

  • Load the CollegeSource course catalog tables directly. (DCP_CAT_CRS, DCP_CAT_CRS_AVAIL, and DCP_CAT_CRS_REQ)
  • Replace the table names of CollegeSource course catalog tables with Materialized (Oracle) or Indexed (MS SQL) views, that map the existing fields in the table to your student system's course information.
     

Be Careful
When using a blank value for INSTIDQ, INSTID, and/or INSTCD, be sure to only populate a single space and not padded spaces for the associated columns in DCP_CAT_CRS. Also, ensure that DEPARTMENT and COURSE_NUMBER values are RIGHT TRIMMED.

DCP_CAT_CRS

DCP_CAT_CRS

 

Course Catalog

CAT_CRS_ID

varchar(9)

Contains a unique id for the course. It can be a sequential number or an id that exists in your actual course catalog. Primary key to the table.

IMPORTANT: This value needs to be a unique non-null identifier for every row in the table/view. THIS value should be thought of as a primary key.

DEPARTMENT

varchar(10)

The abbreviation for the department or subject of the course

COURSE_NUMBER

varchar(10)

The course number

TITLE

varchar(65)

The course title

CREDITS

float

The course credit

DESCRIPTION

varchar(4000)

The course description

COLUMN_1
COLUMN_2
COLUMN_3
COLUMN_4

varchar(500)

Four user-defined fields that can be used for any additional data that you wish to provide in the course catalog. Labels for these fields are configured in u.direct.properties. If no column is defined, that field will not appear with course catalog information in the Planner.

INSTIDQ

varchar(2)

The INSTIDQ used for encoding in uAchieve or DARwin

INSTID

varchar(8)

The INSTID used for encoding in uAchieve or DARwin

INSTCD

varchar(3)

The INSTCD used for encoding in uAchieve or DARwin

MINIMUM_CREDITS float The minimum number of credits allowed for this course. (Not null). If you don't use variable credit, set to the same as what you set CREDITS to above.
MAXIMUM_CREDITS float The maximum number of credits allowed for this course. (Not null). If you don't use variable credit, set to the same as what you set CREDITS to above.
GRADE_LIST varchar(50) The name of the defined grade list for this course. (GRADE_LIST value from GRADE_LIST table. When left blank or NULL uses the "default" grade list.)

Grade List

The GRADE_LIST column that handles grade lists per course is not required to be set for any course. If not set, the "default" grade list will be used.

Course-Specific Planned Grades

Set up Grade Lists in the uAchieve Planner Admin area:

  • Must have a grade list defined named "default"
  • Must include the configured default grade from udirect.properties in ALL unique grade lists setup
  • Give each grad a GPA points value
  • Indicate whether grade should be excluded from GPA calculation

NOTE:
Defining grades in the Admin Help area replaces the udirect-gradeTemplate-ctx.xml file.

 

See how the course determines the list of grades to use:

DCP_CAT_CRS_AVAIL

DCP_CAT_CRS_AVAIL

 

Course Availability by Term 

AVAIL_ID

numeric(9)

Auto-assigned sequence number. Primary key to the table

CAT_CRS_ID

varchar(9)

External key identifying the course in DCP_CAT_CRS for which this row indicates availability

AVAIL_YEAR

varchar(20)

The year of the availability term

TERM

varchar(20)

The term code of the availability term

CRS_SESSION

varchar(20)

Not used at this time

COLUMN_1
COLUMN_2
COLUMN_3
COLUMN_4

varchar(500)

Not used at this time

DCP_CAT_CRS_REQ

DCP_CAT_CRS_REQ

 

Course Prerequisites and Corequisites

REQ_ID

numeric(9)

Auto-assigned sequence number. Primary key to the table

CAT_CRS_ID

varchar(9)

External key identifying the course in DCP_CAT_CRS for which this row indicates a prereq or coreq

REQ_TYPE

varchar(20)

The type of requirement, must be one of the literals: "prereq" or "coreq"

REQ_CAT_CRS_DESC

varchar(255)

The course that is a prereq or coreq for the course in DCP_CAT_CRS with the referenced CAT_CRS_ID.  Must be formatted to match the spacing defined by department length and course length in udirect.properties.

REQ_CONNECTOR char(3) The field that indicates the AND/OR relationship. Must be either AND or OR.
LEFT_PARENTHESIS char(2) Identifies start of group of courses. ***REQ_ID order is important because of display of courses. Example data: (
RIGHT_PARENTHESIS char(2) Identifies end of group of courses. ***REQ_ID order is important because of display of courses. Example data: )

 

Below is sample data in DCP_CAT_CRS_REQ:

 

REQ_ID

CAT_CRS_ID REQ_TYPE REQ_CAT_CRS_DESC REQ_CONNECTOR LEFT_PARENTHESIS RIGHT_PARENTHESIS
1 24 66596 prereq ENG 111 (null) ( (null)
2 25 66596 prereq ENG 112 OR (null) (null)
3 26 66596 prereq ENG 201 OR (null) )
4 27 66596 prereq ENG 113 AND ( (null)
5 29 66596 prereq ENG 202 OR (null) )
6 30 66596 coreq ENG 470   (  
7 31 66596 coreq ENGL 109 OR (null) )
8 32 66596 coreq FRE 410 AND ( (null)
9 33 66596 coreq FRE 415 OR (null) )

 

 

Below is a sample prerequisite/corequisite string as displayed in uAchieve Planner:

 

Banner Course Catalog Data Views

Banner Course Catalog Data Views

  • Was this article helpful?