Astra Schedule Help (8.0)

HESI Tables (Colleague UniData)

Hide Navigation Pane

HESI Tables (Colleague UniData)

Previous topic Next topic  

HESI Tables (Colleague UniData)

Previous topic Next topic JavaScript is required for the print function  

Tables and Permissions

Table Name

Fields/Virtual Attributes

DEGREES_1 from DEGREES

(Select permission)

ID

DEG.DESC                

DEGREES.ADDDATE

DEGREES.ID

ACAD_PROGRAMS from ACAD.PROGRAMS

(Select permission)

ID                

ID0

ACPG.DESC                

ACPG.DEGREE

ACPG.ACAD_LEVEL

ACTIVITY.DATE

ACPG.MAJORS  (multi-valued attribute)

MAJORS_1 from MAJORS

(Select permission)

ID                

ID0

MAJ.DESC                        

MAJORS.ADDDATE

ACAD_LEVELS from ACAD.LEVELS

(Select permission)

ID                

ID0

ACLV.DESC                        

ACAD.LEVELS.ADDDATE

DIVISIONS_1 from DIVISIONS

(Select permission)

ID                

ID0

DIV.DESC                

DIVISIONS.ADD.DATE

DEPTS_1 from DEPTS

(Select permission)

ID                

ID0

DEPTS.DESC                        

DEPTS.DIVISION

DEPTS.ACTIVE.FLAG        

DEPTS.ADD.DATE

DEPTS.TYPE        

DEPTS.ID

TOPIC_CODES from TOPIC.CODES

(Select permission)

ID                

ID0

TOPC.DESC    

INSTR_METHODS from INSTR.METHODS

(Select permission)

ID                

ID0

INM.DESC                        

INSTR.METHODS.ADDDATE

INSTR.METHODS.ID

CLASSES_1 from CLASSES

(Select permission)

ID                

ID0

CLS.DESC                

CLASSES.ADDDATE

STUDENT_TYPES from STUDENT.TYPES

(Select permission)

ID                

ID0

STT.DESC                

STUDENT.TYPES.ADDDATE

SUBJECTS_1 from SUBJECTS

(Select permission)

ID                

ID0

SUBJ.DESC                        

SUBJECTS.ADDDATE

BUILDINGS_1 from BUILDINGS

(Select permission)

ID                

ID0

BLDG.DESC                        

BLDG.LOCATION

BUILDINGS.ID

TERMS_1 from TERMS

(Select permission)

ID                

ID0

TERM.DESC                        

TERM.START.DATE

TERM.END.DATE

TERMS.ID

COURSES_1 from COURSES

(Select permission)

ID                

ID0

CRS.TITLE                        

CRS.DEPTS

CRS.DIVISIONS

CRS.NAME

CRS.DESC

CRS.SHORT.TITLE

CRS.SUBJECT

CRS.MIN.CRED

CRS.MAX.CRED

CRS.PREREQS

CRS.NO

CRS.STATUS

CRS.COREQ.COURSES

CRS.START.DATE

CRS.END.DATE

CRS.COURSE.TYPES

CRS.ACAD.LEVEL

CRS.LOAD

CRS.CONTACT.HOURS

CRS.LOCATIONS

CRS.INSTR.METHODS

CRS.COREQ.COURSES.REQD.FLAG

CRS.EQUATE.CODES

CRS.ALLOW.PASS.NOPASS.FLAG

CRS.TOPIC.CODE

COURSE_SECTIONS from COURSE.SECTIONS

(Select permission)

ID        

ID0

SEC.SHORT.TITLE                

SEC.LOCATION

SEC.CAPACITY

SEC.SUBJECT

SEC.MEETING

SEC.TERM

SEC.COURSE.NO

SEC.NO

COURSE.SECTIONS.CHGDATE

SEC.COURSE

SEC.XLIST

SEC.FACULTY

SEC.ACTIVE.STUDENTS

SEC.WAITLIST.MAX

SEC.STATUS

SEC.NAME

ASTRA.SEC.ACTUAL.ENROLLMENT AS DCOUNT(SEC_ACTIVE_STUDENTS,@VM)

SEC.CURRENT.STATUS AS FIELD(SEC_STATUS,@VM,1)

COURSE.SECTIONS.ID AS FIELD(@ID,"*",1)

COURSE_SEC_MEETING from COURSE.SEC.MEETING

(Select permission)

ID        

ID0

CSM.COURSE.SECTION                        

CSM.START.DATE

CSM.END.DATE

CSM.BLDG

CSM.ROOM

CSM.INSTR.METHOD

CSM.START.TIME

CSM.END.TIME

COURSE.SEC.MEETING.CHGDATE

CSM.MONDAY

CSM.TUESDAY

CSM.WEDNESDAY

CSM.THURSDAY

CSM.FRIDAY

CSM.SATURDAY

CSM.SUNDAY

CSM.FACULTY

CSM.ROOM.SCHED.TERM

COURSE.SEC.MEETING.ID AS FIELD(@ID,"*",1)

SEC.LOCATION AS TRANS(COURSE.SECTIONS,CSM.COURSE.SECTION,'SEC.LOCATION','X')

X.CSM.CSF.FACULTY

PERSON_1 from PERSON

(Select permission)

ID        

ID0

LAST.NAME                        

FIRST.NAME

MIDDLE.NAME

PREFIX

PREFERRED.ADDRESS

NICKNAME

SUFFIX

DECEASED.DATE

PREFERRED.RESIDENCE

PERSON.CORP.INDICATOR

PERSON.EMAIL.ADDRESSES

ADDR.TYPE

ADDR.EFFECTIVE.START

ADDR.EFFECTIVE.END

PRIVACY.FLAG

COURSE_SEC_FACULTY from COURSE.SEC.FACULTY

(Select permission)

ID        

ID0

CSF.COURSE.SECTION                

CSF.FACULTY

STUDENTS_1 from STUDENTS

(Select permission)

ID        

ID0

STU.RESIDENCY.STATUS                

STU.TYPES

STU.ACAD.LEVELS

STU.ACAD.PROGRAMS

STU.TERMS

STU.NOTES

STUDENTS.CHGDATE

STU.ACTIVE.PROGRAMS AS SUBR("CC.GET.ACTIVE.PROGRAMS",@ID,STU_ACAD_PROGRAMS,"PROGRAMS","");@1

X_STU_STA_ADMIT_STATUS AS TRANS("STUDENT.ACAD.LEVELS",(@ID:"*UG"),"STA.ADMIT.STATUS","X")

X_STU_MAXIENT_CLASS AS ""; IF TRANS("STUDENT.ACAD.LEVELS",(@ID:"*UG"),"STA.CLASS","X") EQ "FR" THEN ("Freshman") ELSE @1; IF TRANS("STUDENT.ACAD.LEVELS",(@ID:"*UG"),"STA.CLASS","X") EQ "SO" THEN ("Sophomore") ELSE @2

X_STU_CURR_RESIDENCY_STATUS AS EXTRACT(STU_RESIDENCY_STATUS,1,1,0)

X_STU_MAXIENT_FIRST_NAME AS TRANS("PERSON",@ID,"FIRST.NAME","X"); IF @1 EQ "" THEN ("unavailable") ELSE @1

X_STU_FIRST_TYPE AS EXTRACT(STU_TYPES,1,1,0)

X_STU_IS_DECEASED AS ""; IF TRANS("PERSON",@ID,"DECEASED.DATE","X") THEN ("TRUE") ELSE ("FALSE")

X_STU_ASTRA_IS_GRAD AS IF STU_ACTIVE_PROGRAMS THEN ("FALSE") ELSE ("TRUE")

X_STU_ASTRA_UG_LEVEL AS IF TRANS("STUDENT.ACAD.LEVELS",(@ID:"*UG"),"STA.START.DATE","X") THEN ("UG") ELSE ("")

STU_LAST_NAME AS TRANS("PERSON",@ID,"LAST.NAME","X")

X_STU_STA_LOAD_INTENT AS IF TRANS("STUDENT.ACAD.LEVELS",(@ID:"*UG"),"STA.STUDENT.LOAD.INTENT","X") EQ "FT" THEN ("TRUE") ELSE ("FALSE")

X_STU_MAXIENT_MIDDLE_NAME AS TRANS("PERSON",@ID,"MIDDLE_NAME","X")

X_STU_ANT_GRAD_TERM AS ""

X_STU_LOAD_INTENT AS TRANS("STUDENT.ACAD.LEVELS",(@ID:"*UG"),"STA.STUDENT.LOAD.INTENT","X")