| 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 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 |
| LOCATIONS_1 from LOCATIONS(Select permission)(optional - only required if importing rooms from SIS) |
ID ID0 LOC.DESC LOCATIONS.ID |
| BUILDINGS_1 from BUILDINGS(Select permission) |
ID ID0 BLDG.DESC BLDG.LOCATION BUILDINGS.ID |
| ROOMS_1 from ROOMS(Select permission)(optional - only required if importing rooms from SIS) |
ID ID0 ROOM.NAME ROOM.CAPACITY ROOMS.BLDG.ID ROOMS.ROOM.ID ROOM.LOCATION |
| 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 (multi-valued attribute) CRS.DIVISIONS (multi-valued attribute) CRS.NAME CRS.DESC CRS.SHORT.TITLE CRS.SUBJECT CRS.MIN.CRED CRS.MAX.CRED CRS.PREREQS CRS.NO CRS.STATUS CRS.COREQ.COURSES (multi-valued attribute) CRS.START.DATE CRS.END.DATE CRS.COURSE.TYPES CRS.ACAD.LEVEL CRS.LOAD CRS.CONTACT.HOURS (multi-valued attribute) CRS.LOCATIONS (multi-valued attribute) CRS.INSTR.METHODS CRS.COREQ.COURSES.REQD.FLAG (multi-valued attribute) CRS.EQUATE.CODES (multi-valued attribute) 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') |
| 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") |
| STUDENT_ACAD_CRED from STUDENT.ACAD.CRED(Select permission) |
ID ID0 STC.PERSON.ID STC.TITLE STC.ACAD.LEVEL STC.SUBJECT STC.COURSE STC.STATUS (Add as ‘MV’ field with Association ‘STC_STATUSES’) STC.CRED STC.CRED.TYPE STC.CMPL.CRED STC.VERIFIED.GRADE STC.TERM STC.ATT.CRED STC.GRADE.PTS STC.REPL.CODE STC_CURRENT_STATUS AS EXTRACT(STC_STATUS,1,1,0) STUDENT.ACAD.CRED.CHGDATE STUDENT.ACAD.CRED.ID AS FIELD(@ID,"*",1) X_STC_CRS_ALLOW_PASS_NOPASS AS IF TRANS("COURSES_1",STC_COURSE,"CRS_ALLOW_PASS_NOPASS_FLAG","X") EQ "N" THEN ("1") ELSE ("0") X_STC_REPL_FLAG AS IF STC_REPL_CODE EQ "R" THEN ("1") ELSE ("0") X_STC_GRD_GRADE AS TRANS('GRADES_1',STC_VERIFIED_GRADE,'GRD_GRADE','X') |
| STUDENT_PROGRAMS from STUDENT.PROGRAMS(Select permission) |
ID ID0 STPR.ANT.CMPL.DATE STPR.CATALOG STPR.LOCATION STPR.STATUS STPR.DEPT STPR.STUDENT STPR.ACAD.LEVEL AS TRANS("ACAD_PROGRAMS",STPR_ACAD_PROGRAM,"ACPG_ACAD_LEVEL","X") STPR.ACAD.PROGRAM STPR.MINORS STPR.CURRENT.STATUS AS FIELD(STPR_STATUS,@VM,1) X_STPR_DEGREE_SIS_KEY AS ((((STPR_STUDENT:"_"):X_STPR_ACPG_DEGREE):"_"):STPR_ACAD_PROGRAM) X_STPR_ACPG_DEGREE AS TRANS("ACAD_PROGRAMS",STPR_ACAD_PROGRAM,"ACPG_DEGREE","X") X_STPR_PRIMARY_DEGREE AS IF STPR_CURRENT_STATUS EQ "A" AND STPR_ACAD_LEVEL EQ "UG" THEN ("TRUE") ELSE ("FALSE") X_STPR_ACPG_MAJORS AS TRANS("ACAD_PROGRAMS",STPR_ACAD_PROGRAM,"ACPG_MAJORS","X") (multi-valued attribute) |
| PERSON_ST from PERSON.ST(Select permission) |
ID ID0 PST.STUDENT.ACAD.CRED PST.ADMISSIONS.TESTS (multi-valued attribute) |
| STUDENT_NON_COURSES from STUDENT.NON.COURSES(Select permission) |
ID ID0 STNC.SCORE STNC.NON.COURSE |
| ACAD_REQMTS from ACAD.REQMTS(Select permission) |
ID ID0 ACR.DESC ACR.COMMENTS ACR.ACAD.PROGRAM.REQMTS ACR.CATALOGS ACR.PREREQ.COURSE ACR.TOP.REQMT.BLOCK X_ACR_IS_PREREQ AS (LEN(ACR_PREREQ_COURSE) GT 0) XL_ACR_ACPR_CATALOGS SUBR('-FIELDS',ACR_ACAD_PROGRAM_REQMTS,"*",2,1) |
| STUDENT_COURSE_SEC from STUDENT.COURSE.SEC(Select permission)NOTE: This is required for section to academic history relationships starting with the release of the new "Smart Schedule Sandbox" in Platinum. |
SCS_STUDENT_ACAD_CRED SCS_COURSE_SECTION |
Comments
0 comments
Please sign in to leave a comment.