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.NOSEC.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.DATECSM.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 CSF.COURSE_ SECTIONS_ID |
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.NOCRS.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 |
Comments
Please sign in to leave a comment.