Table Name

Fields/Virtual Attributes

RULES_1 from RULES

(Select Permission)

ID

ID0

RL_CHECK_CONNECTOR (Add as ‘MV’ field with Association 'RULES_CHECK')

RL_CHECK_OPERATORS (Add as ‘MV’ field with Association 'RULES_CHECK')

RL_CHECK_VALUES Add as ‘MV’ field with Association 'RULES_CHECK')

RL_CHECK_DATA_ELEMENTS (Add as ‘MV’ field with Association 'RULES_CHECK')

RULES_ID AS FIELD(@ID,"*",1)

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

LOCATIONS_1 from LOCATIONS

(Select permission)

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)

ID                

ID0

ROOM.NAME                        

ROOM.CAPACITY

ROOMS.BLDG.ID

ROOMS.ROOM.ID

ROOM.LOCATION

X.ROOM.CONFIGURATIONS

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

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

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

COURSE_SEC_XLISTS from COURSE.SEC.XLISTS

(Select permission)

ID        

ID0

CSXL.CAPACITY                        

CSXL.PRIMARY.SECTION

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

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)

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

PERSON_ST from PERSON.ST

(Select permission)

ID        

ID0

PST.STUDENT.ACAD.CRED                        

PST.ADMISSIONS.TESTS

STUDENT_NON_COURSES from STUDENT.NON.COURSES

(Select permission)

ID        

ID0

STNC.SCORE                        

STNC.NON.COURSE

STUDENT_TERMS from STUDENT.TERMS

(Select permission)

ID        

ID0

STTR.SCHEDULE                

STTR.STUDENT.ACAD.CRED

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)

ACAD_REQMT_BLOCKS from ACAD.REQMT.BLOCKS

(Select permission)

ID        

ID0

ACRB.LABEL                

ACRB.ACAD.CRED.RULES

ACRB.COURSE.REUSE.FLAG

ACRB.MIN.GRADE

ACRB.TYPE

ACRB.COURSES

ACRB.MIN.CRED

ACRB.SUBBLOCKS

ACRB.MIN.NO.SUBBLOCKS

ACRB.PARENT.BLOCK

ACRB.ACAD.REQMT

ACRB.FROM.COURSES

ACRB.BUT.NOT.COURSES

ACRB.FROM.DEPTS

ACRB.FROM.SUBJECTS

ACRB.FROM.CRS.LEVELS

ACRB.BUT.NOT.SUBJECTS

X_ACRB_ASTRA_EFFECTIVE_DATE AS ICONV("01/01/1901", "D")

X_ACRB_MIN_CRED AS IF ACRB_PARENT_BLOCK THEN (ACRB_MIN_CRED) ELSE (TRANS("ACAD_PROGRAM_REQMTS",EXTRACT(TRANS("ACAD_REQMTS",ACRB_ACAD_REQMT,"ACR_ACAD_PROGRAM_REQMTS","X"),1,1,0),"ACPR_CRED","X"))

ACAD_REQMT_BLOCKS_ID AS FIELD(@ID,"*",1)

X_ACRB_ASTRA_COUNT_GPA AS (LEN(TRANS("ACAD_PROGRAM_REQMTS",TRANS("ACAD_REQMTS",ACRB_ACAD_REQMT,"ACR_ACAD_PROGRAM_REQMTS","X"),"ACPR_MIN_GPA","X")) GT 0)

X_ACRB_FIRST_ACPR_POINTER AS EXTRACT(TRANS("ACAD_REQMTS",ACRB_ACAD_REQMT,"ACR_ACAD_PROGRAM_REQMTS","X"),1,1,0)

X_ACRB_LOGIC_OPERATOR AS IF ACRB_TYPE EQ "10" THEN ("0") ELSE ""; IF ACRB_TYPE EQ "11" THEN ("1") ELSE @1; IF ACRB_TYPE EQ "20" THEN ("0") ELSE @2; IF ACRB_TYPE EQ "21" THEN ("1") ELSE @3; IF ACRB_TYPE EQ "30" THEN ("3") ELSE @4

X_ACRB_MIN_GRADE AS IF ACRB_MIN_GRADE NE "" THEN (ACRB_MIN_GRADE) ELSE (TRANS("ACAD_PROGRAM_REQMTS",EXTRACT(TRANS("ACAD_REQMTS",ACRB_ACAD_REQMT,"ACR_ACAD_PROGRAM_REQMTS","X"),1,1,0),"ACPR_MIN_GRADE","X")); TRANS("GRADES_1",@1,"GRD_GRADE","X")

X_ACRB_MIN_NO_SUBBLOCKS AS (LEN(ACRB_MIN_NO_SUBBLOCKS) GT 0); IF @1 EQ "1" THEN (ACRB_MIN_NO_SUBBLOCKS) ELSE ("0")

X_ACRB_COURSE_REUSE_FLAG AS IF ACRB_COURSE_REUSE_FLAG EQ "N" THEN ("0") ELSE ""; IF ACRB_COURSE_REUSE_FLAG EQ "Y" THEN ("1") ELSE @1

X_ACRB_TRANSFER_CRED AS ((TRANS("ACAD_PROGRAM_REQMTS",X_ACRB_FIRST_ACPR_POINTER,"ACPR_CRED","X")) - (TRANS("ACAD_PROGRAM_REQMTS",X_ACRB_FIRST_ACPR_POINTER,"ACPR_INSTITUTION_CRED","X")))

X_ACRB_WITHIN_INDICATOR AS "0"

ACAD_PROGRAM_REQMTS from ACAD.PROGRAM.REQMTS

(Select permission)

ID        

ID0

ACPR.CRED

ACPR.INSTITUTION.CRED

ACPR.MIN.GPA

ACPR.ACAD.REQMTS

ACPR.MIN.GRADE

ACPR.ACAD.CRED.RULES

X_ACPR_ASTRA_FALSE AS "0"

X_ACPR_ASTRA_IS_CAPTIVE AS "1"

ACPR.ACAD.PROGRAM AS FIELD(@ID,"*",1)

ACPR.CATALOG AS FIELD(@ID,"*",2)

GRADES_1 from

GRADES

(Select permission)

ID

ID0

GRD.GRADE

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