Colleague HESI Tables (UniData)

 

Table Name Fields/Virtual Attributes
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

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) 

NOTE: "Active" student status at end of term is used for section enrollment calculation. If census enrollment is  available, access to that data is needed to enhance historical comparison. Please contact your project manager to coordinate integration.

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

 


Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.