Page History

The u.select 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 degree audit functionality to work, the database user needs visibility and permission to do perform the following:

selectSelect, insert, update, and delete on these 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 these 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 do perform the following:

select Select on these the following tables:

MASTREF
MASTREF_ADDRESS
TCA_MASTER
TCA_RULE
TCA_SOURCE
TCA_TARGET