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 |
Comments
Please sign in to leave a comment.