|
||
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") |