Banner Table and Data Detail
The interface selects data from various Banner tables to make academic sections, meetings, cross-list information, instructors, subjects, courses, and activity statuses available within Astra Schedule. The following tables detail the Banner fields being used and their corresponding Astra Schedule values.
Sections
SIS Database Value |
Astra Schedule Value |
|---|---|
SSBSECT_TERM_CODE |
TermCode |
SSBSECT_CRN |
CRN |
SSBSECT_CRSE_NUMB |
CourseNumber |
SSBSECT_SUBJ_CODE |
Subject |
SSBSECT_SEQ_NUMB |
SectionNumber |
SSBSECT_SSTS_CODE |
StatusCode |
SSBSECT_SCHD_CODE |
MeetingType |
SSBSECT_CAMP_CODE |
Campus |
SSBSECT_CRSE_TITLE |
Title |
SSBSECT_CREDIT_HRS |
CreditHrs |
SSBSECT_SESS_CODE |
SsbsectSessCode |
SSBSECT_LINK_IDENT |
LinkIdent |
SSBSECT_PRNT_IND |
PrntInd |
SSBSECT_GRADABLE_IND |
GradableInd |
SSBSECT_CENSUS_2_ENRL |
CensEnrl2 |
SSBSECT_CENSUS_2_DATE |
CensEnrlDate2 |
SSBSECT_CENSUS_ENRL |
CensEnrl |
SSBSECT_CENSUS_ENRL_DATE |
CensEnrlDate |
SSBSECT_PROJ_ENRL |
ProjEnrl |
SSBSECT_MAX_ENRL |
MaxEnrl |
SSBSECT_ENRL |
Enrl |
SSBSECT_SEATS_AVAIL |
SeatsAvail |
SSBSECT_TOT_CREDIT_HRS |
TotCreditHrs |
SSBSECT_ACTIVITY_DATE |
ActivityDate |
SSBSECT_RESERVED_IND |
ReservedInd |
SSBSECT_WAIT_CAPACITY |
WaitCapacity |
SSBSECT_WAIT_COUNT |
WaitCount |
SSBSECT_WAIT_AVAIL |
WaitAvail |
SSBSECT_LEC_HR |
LecHR |
SSBSECT_LAB_HR |
LabHR |
SSBSECT_OTH_HR |
OthHR |
SSBSECT_CONT_HR |
ContHR |
SSBSECT_CAPP_PREREQ_TEST_IND |
CappPrereqTestInd |
SSBSECT_INSM_CODE |
InstructorMethod |
Section Meetings
SIS Database Value |
Astra Schedule Value |
|---|---|
SSRMEET_TERM_CODE |
TermCode |
SSRMEET_CRN |
CRN |
SSRMEET_DAYS_CODE |
DaysCode |
SSRMEET_DAY_NUMBER |
DayNumber |
SSRMEET_BEGIN_TIME |
BeginTime |
SSRMEET_END_TIME |
EndTime |
SSRMEET_BLDG_CODE |
BldgCode |
SSRMEET_ROOM_CODE |
RoomCode |
SSRMEET_ACTIVITY_DATE |
ActivityDate |
SSRMEET_START_DATE |
StartDate |
SSRMEET_END_DATE |
EndDate |
SSRMEET_CATAGORY |
Catagory |
SSRMEET_SUN_DAY |
SunDay |
SSRMEET_MON_DAY |
MonDay |
SSRMEET_TUE_DAY |
TueDay |
SSRMEET_WED_DAY |
WedDay |
SSRMEET_THU_DAY |
ThuDay |
SSRMEET_FRI_DAY |
FriDay |
SSRMEET_SAT_DAY |
SatDay |
SSRMEET_OVER_RIDE |
OverRide |
SSRMEET_CREDIT_HR_SESS |
CreditHRSess |
SSRMEET_MEET_NO |
MeetNo |
SSRMEET_HRS_WEEK |
HrsWeek |
SSRMEET_FUNC_CODE |
FuncCode |
SSRMEET_SCHS_CODE |
SchsCode |
SSRMEET_MTYP_CODE |
MtypCode |
SSRMEET_DATA_ORIGIN |
DataOrigin |
SSRMEET_SCHD_CODE |
MeetingType |
SSRMEET_USER_ID |
UserId |
Section Meeting Cross-list Information
SIS Database Value |
Astra Schedule Value |
|---|---|
SSBXLST_TERM_CODE |
TermCode |
SSRXLST_XLST_GROUP |
CrossListNumber |
SSBXLST_MAX_ENRL |
CrossListTotEnrollment |
SSBXLST_ENRL |
CrossListEnrollment |
|
|
SSRXLST_CRN |
CRN |
SSRXLST_XLST_GROUP |
CrossListNumber |
SSRXLST_TERM_CODE |
TermCode |
Section Meeting Instructors
SIS Database Value |
Astra Schedule Value |
|---|---|
SIRASGN_PIDM |
PIDM |
SIRASGN_PRIMARY_IND |
PrimaryIND |
SIRASGN_CRN |
CRN |
SIRASGN_CATEGORY |
Category |
SIRASGN_TERM_CODE |
TermCode |
Instructor Record Information
SIS Database Value |
Astra Schedule Value |
|---|---|
SPRIDEN_PIDM |
Pidm |
SPRIDEN_ID |
UserName |
SPRIDEN_FIRST_NAME |
FirstName |
SPRIDEN_LAST_NAME |
LastName |
SPRIDEN_MI |
MiddleInitial |
SPRIDEN.SPRIDEN_ENTITY_IND |
EntityIndicator |
SPRIDEN_CHANGE_IND |
(IS NULL) |
|
|
SIBINST_FCST_CODE |
Status |
SIBINST_FCTG_CODE |
Category |
SIBINST_FSTP_CODE |
EmploymentStatus |
SIBINST_ADVR_IND |
AdvisorIndicator |
SIBINST_SCHD_IND |
AllowToSchedule |
SIBINST_ACTIVITY_DATE |
ActivityDate |
SIBINST_TERM_CODE_EFF |
(=MAX) |
|
|
SIRDPCL_COLL_CODE |
College |
SIRDPCL_DEPT_CODE |
Department |
SIRDPCL_HOME_IND |
PrimaryDepartmentIndicator |
SIRDPCL_ACTIVITY_DATE |
(=MAX SIRDPCL_TERM_CODE_EFF) |
|
|
GOREMAL_EMAL_CODE |
EmailType |
GOREMAL_DISP_WEB_IND |
PublishEmailAddress |
GOREMAL_EMAIL_ADDRESS |
EmailAddress |
GOREMAL_PREFERRED_IND |
(='Y') |
GOREMAL_STATUS_IND |
(='A') |
GOREMAL_ACTIVITY_DATE |
(=MAX) |
Subject and Course Information
SIS Database Value |
Astra Schedule Value |
|---|---|
SCBCRSE_SUBJ_CODE |
ScbcrseSubjCode |
SCBCRSE_CRSE_NUMB |
ScbcrseCrseNumb |
SCBCRSE_EFF_TERM |
ScbcrseEffTerm |
SCBCRSE_COLL_CODE |
ScbcrseCollCode |
SCBCRSE_DIVS_CODE |
ScbcrseDivsCode |
SCBCRSE_DEPT_CODE |
ScbcrseDeptCode |
SCBCRSE_CSTA_CODE |
ScbcrseCstaCode |
SCBCRSE_TITLE |
ScbcrseTitle |
SCBCRSE_CIPC_CODE |
ScbcrseCipcCode |
SCBCRSE_CREDIT_HR_IND |
ScbcrseCreditHRInd |
SCBCRSE_CREDIT_HR_LOW |
ScbcrseCreditHRLow |
SCBCRSE_CREDIT_HR_HIGH |
ScbcrseCreditHRHigh |
SCBCRSE_LEC_HR_IND |
ScbcrseLecHRInd |
SCBCRSE_LEC_HR_LOW |
ScbcrseLecHRLow |
SCBCRSE_LEC_HR_HIGH |
ScbcrseLecHRHigh |
SCBCRSE_LAB_HR_IND |
ScbcrseLabHRInd |
SCBCRSE_LAB_HR_LOW |
ScbcrseLabHRLow |
SCBCRSE_LAB_HR_HIGH |
ScbcrseLabHRHigh |
SCBCRSE_OTH_HR_IND |
ScbcrseOthHRInd |
SCBCRSE_OTH_HR_LOW |
ScbcrseOthHRLow |
SCBCRSE_OTH_HR_HIGH |
ScbcrseOthHRHigh |
SCBCRSE_BILL_HR_IND |
ScbcrseBillHRInd |
SCBCRSE_BILL_HR_LOW |
ScbcrseBillHRLow |
SCBCRSE_BILL_HR_HIGH |
ScbcrseBillHRHigh |
SCBCRSE_APRV_CODE |
ScbcrseAprvCode |
SCBCRSE_REPEAT_LIMIT |
ScbcrseRepeatLimit |
SCBCRSE_PWAV_CODE |
ScbcrsePwavCode |
SCBCRSE_TUIW_IND |
ScbcrseTuiwInd |
SCBCRSE_ADD_FEES_IND |
ScbcrseAddFeesInd |
SCBCRSE_ACTIVITY_DATE |
ActivityDate |
SCBCRSE_CONT_HR_LOW |
ScbcrseContHRLow |
SCBCRSE_CONT_HR_IND |
ScbcrseContHRInd |
SCBCRSE_CONT_HR_HIGH |
ScbcrseContHRHigh |
SCBCRSE_CEU_IND |
ScbcrseCeuInd |
SCBCRSE_REPS_CODE |
ScbcrseRepsCode |
SCBCRSE_MAX_RPT_UNITS |
ScbcrseMaxRptUnits |
SCBCRSE_CAPP_PREREQ_TEST_IND |
ScbcrseCappPrereqTestInd |
SCBCRSE_DUNT_CODE |
ScbcrseDuntCode |
SCBCRSE_NUMBER_OF_UNITS |
ScbcrseNumberOfUnits |
SCBCRSE_DATA_ORIGIN |
ScbcrseDataOrigin |
SCBCRSE_USER_ID |
ScbcrseUserId |
Page url: ?bannersisinterfaceaddendum_3.htm