Skip to main content
CollegeSource Production

Required DARS Tables

The Transferology Connector must access several DARS tables to provide the intended course equivalency and degree audit functionality. This page identifies the necessary DARS tables for each of those functions.

Degree Audit

For the degree audit functionality to work, the database user needs visibility and permission to perform the following:

 

Select, insert, update, and delete on the following tables:

JOB_QUEUE_SYSIN

JOB_QUEUE_DESTINATION

JOB_QUEUE_DETAIL

JOB_QUEUE_LIST

JOB_QUEUE_ACCEPT

JOB_QUEUE_COURSE

JOB_QUEUE_SUBREQ

JOB_QUEUE_REQ

JOB_QUEUE_OUT

JOB_QUEUE_RUN

 

Oracle databases also need select on the following sequences:

JOBQD_SEQ_NO   

JOBQO_SEQ_NO   

JOBQR_SEQ_NO   

JOBQSI_SEQ_NO  

JOBQSO_SEQ_NO  

Course Equivalency

For the Course Equivalency functionality to work, the database user needs visibility and permission to perform the following:

 

Select on the following tables:

MASTREF

MASTREF_ADDRESS

TCA_MASTER

TCA_RULE

TCA_SOURCE

TCA_TARGET

 

 

  • Was this article helpful?