Table Name

Fields/Virtual Attributes

COURSE_SECTIONS from COURSE.SECTIONS

(Select permission)

ID

SEC.CAPACITY

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

SEC.COURSE.NO

SEC.LOCATION

SEC.NO

SEC.SHORT.TITLE

SEC.SUBJECT

SEC.COURSE

SEC.TERM

COURSE.SECTIONS.CHGDATE

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

SEC.XLIST

SEC.STATUS

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

SEC.ACTIVE.STUDENTS

COURSE_SEC_MEETING from COURSE.SEC.MEETING

(Astra user Select and Update (for building and room assignment))

ID

COURSE.SEC.MEETING.CHGDATE

COURSE.SEC.MEETING.ID

CSM.BLDG

CSM.COURSE.SECTION

CSM.END.DATE

CSM.ROOM

CSM.START.TIME

CSM.START.DATE

CSM.END.TIME

CSM.MONDAY

CSM.TUESDAY

CSM.WEDNESDAY

CSM.THURSDAY

CSM.FRIDAY

CSM.SATURDAY

CSM.SUNDAY

CSM.INSTR.METHOD

SEC.LOCATION

COURSE_SEC_FACULTY from COURSE.SEC.FACULTY

(Select permission)

ID

CSF.FACULTY

CSF.COURSE.SECTION

PERSON_1 from PERSON

(Select permission)

ID

LAST.NAME

MIDDLE.NAME

FIRST.NAME

BUILDINGS_1 from BUILDINGS

(Select permission)

ID                

ID0

BLDG.DESC                        

BLDG.LOCATION

BUILDINGS.ID

COURSES_1 from COURSES

(Select permission)

ID                

ID0

CRS.TITLE                        

CRS.DEPTS

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