Astra Schedule Help (8.0)

Ellucian Colleague Database Access

Hide Navigation Pane

Ellucian Colleague Database Access

Previous topic Next topic  

Ellucian Colleague Database Access

Previous topic Next topic JavaScript is required for the print function  

Data Access

The Astra Schedule database user must have access to the following Colleague tables.

 

noteNOTE:  If you are using Oracle for your database, synonyms must be created for each table as the Astra Schedule user to facilitate direct queries against the database.

 

Use the commands displayed below to create the proper synonyms via SQL Developer, Toad, or other database administration tool. Log in to the Colleague database as the Astra Schedule user that was created for use in the import/export process before running these commands.

 

Note that <COLLEAGUE_SCHEMA> should be replaced with the name of your schema. (Example:  COLL_PRODUCTION.COURSE_SECTIONS)

 

Run the following commands:

 

CREATE SYNONYM COURSE_SECTIONS FOR <COLLEAGUE_SCHEMA>.COURSE_SECTIONS;

CREATE SYNONYM COURSE_SEC_MEETING FOR <COLLEAGUE_SCHEMA>.COURSE_SEC_MEETING;

CREATE SYNONYM SEC_STATUSES FOR <COLLEAGUE_SCHEMA>.SEC_STATUSES;

CREATE SYNONYM STC_STATUSES FOR <COLLEAGUE_SCHEMA>.STC_STATUSES;

CREATE SYNONYM STUDENT_COURSE_SEC FOR <COLLEAGUE_SCHEMA>.STUDENT_COURSE_SEC;

CREATE SYNONYM COURSE_SEC_FACULTY FOR <COLLEAGUE_SCHEMA>.COURSE_SEC_FACULTY;

CREATE SYNONYM PEOPLE_EMAIL FOR <COLLEAGUE_SCHEMA>.PEOPLE_EMAIL;

CREATE SYNONYM PERSON FOR <COLLEAGUE_SCHEMA>.PERSON;

 

*All tables require select access unless specified

 

Platinum (MSSQL only)

HESI

Astra Schedule

Used for…

ACAD_CREDENTIALS

 

 

Students

ACAD_LEVELS

ACAD_LEVELS

 

Lookups,

Students

ACAD_PROGRAM_REQMTS

 

 

pgm rule

student

ACAD_PROGRAM_REQMTS_LS

 

 

Pgm Rules

ACAD_PROGRAMS

ACAD_PROGRAMS

 

Lookups,

Students

ACAD_PROGRAMS_LS

 

 

Students

ACAD_REQMT_BLOCKS

 

 

Pgm Rules

ACAD_REQMT_BLOCKS_LS

 

 

Pgm Rules

ACAD_REQMTS

 

 

Pgm Rules

ADMIT_STATUSES

ADMIT_STATUSES

 

Lookups

APPROVAL_STATUS

APPROVAL_STATUS

 

Courses

BUILDINGS

 

 

CampusBuildingRoom

CATALOGS

CATALOGS

 

Courses

CLASSES

CLASSES

 

Lookups

COURSE_CONTACT

COURSE_CONTACT

 

Courses

COURSE_COREQS

COURSE_COREQS

 

Courses

COURSE_DEPTS

COURSE_DEPTS

 

Courses

COURSE_EQUATE_CODES_LS

COURSE_EQUATE_CODES_LS

 

Courses

COURSE_SEC_FACULTY

COURSE_SEC_FACULTY

COURSE_SEC_FACULTY

Sections

COURSE_SEC_MEETING

COURSE_SEC_MEETING

COURSE_SEC_MEETING

(read and write access)

Section import and export

COURSE_SECTIONS

COURSE_SECTIONS

COURSE_SECTIONS

Courses,

Section import and export

COURSES

COURSES

COURSES

Lookups,

Courses,

Sections,

Pgm Rules

COURSES_LS

COURSES_LS

 

Courses,

Students

DEGREES

DEGREES

 

Lookups,

Students

DEPTS

DEPTS

 

Courses,

Lookups,

Pgm Rules

DIVISIONS

DIVISIONS

 

Lookups

GRADES

 

 

Pgm Rules,

Students

HIATUS_CODES

HIATUS_CODES

 

Lookups

INSTR_METHODS

INSTR_METHODS

 

Courses,

Lookups

LOCATIONS

LOCATIONS

 

CampusBuildingRoom,

Courses

MAJORS

MAJORS

 

Lookups,

Students

MINORS

MINORS

 

Lookups,

Students

PEOPLE_EMAIL

PEOPLE_EMAIL

PEOPLE_EMAIL

Sections

PERSON

PERSON

PERSON

Sections

PROGRAM_STATUS

PROGRAM_STATUS

 

Lookups

ROOMS

ROOMS

 

CampusBuildingRoom,

Section import and export

RPHONES

 

 

CampusBuildingRoom

RULES

 

 

Pgm Rules

RULES_CHECK

 

 

Pgm Rules

SEC_STATUSES

SEC_STATUSES

SEC_STATUSES

Section import and export

STC_STATUSES

STC_STATUSES

STC_STATUSES

Sections

STPR_MAJOR_LIST

 

 

Students

STPR_MINOR_LIST

 

 

Students

STPR_STATUSES

 

 

Students

STU_TYPE_INFO

 

 

Students

STUDENT_ACAD_CRED

STUDENT_ACAD_CRED

 

Courses,

Sections

STUDENT_ACAD_LEVELS

 

 

Students

STUDENT_COURSE_SEC

STUDENT_COURSE_SEC

STUDENT_COURSE_SEC

Sections,

Students

STUDENT_HIATUS

 

 

Students

STUDENT_NON_COURSES

STUDENT_NON_COURSES

 

Lookups,

Students

STUDENT_PROGRAMS

 

 

Students

STUDENT_TYPES

STUDENT_TYPES

 

Lookups

SUBJECTS

SUBJECTS

 

Lookups,

Pgm Rules,

Courses,

Sections

TERMS

TERMS

 

Sections,

Students,

Terms,

Courses

VALS

VALS

 

CampusBuildingRoom,

Lookups,

Pgm Rules

 

Details related to the queries used, including specific SIS fields involved, will be provided upon request.  Additionally, the queries can be found in the XML import and/or export spoke files in your installation.  For example, in a standard installation these files would be located in C:\Ad Astra\%YourInstance%\Files\ATEConfiguration\Spokes\SIS.