Shortcuts

Support
Issue Tracker
[Services]
Questions
[uAchieve Applications]
Transferology
TES
[Training & Conferences]
Accessibility

Skip to end of metadata
Go to start of metadata

 

The Transferology Connector must access several uAchieve tables to provide the intended course equivalency and degree audit functionality. This page identifies the necessary uAchieve 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:

CURRENT_JOBS
JOB_QUEUE_SYSIN
JOB_QUEUE_DETAIL
JOB_QUEUE_LIST
JOB_QUEUE_ACCEPT
JOB_QUEUE_COURSE
JOB_QUEUE_SUBREQ
JOB_QUEUE_REQ
JOB_QUEUE_RUN
JOB_QUEUE_OUT
JOB_QUEUE_EXCEPTIONS
JOB_QUEUE_INCL_TEXT
JOB_QUEUE_MARKERS
JOB_QUEUE_REPORT
JOB_QUEUE_REQ_TEXT
JOB_QUEUE_SUBREQ_TEXT
JOB_QUEUE_DESTINATION


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