Faculty_Office_Hours table
Each record describes a faculty member’s office hours. There is 1 record for every different time span, CRN, day of the week. Examples:
Â
TERM ID LAST_NAME CRN MON_DAY TUE_DAY WED_DAY THU_DAY FRI_DAY SAT_DAY SUN_DAY FROM_DATE TO_DATE FROM_TIME TO_TIME
200720 @12345678 Thomas 20362 M W F2007-01-16 2007-05-15 1010 1100
200720 @12345678 Thomas 21755 M W F 2007-01-16 2007-05-15 0910 1100
200720 @12345678 Thomas 21509 T R 2007-01-16 2007-05-15 1210 1300
200720 @12345678 Thomas 20392 M W F 2007-01-16 2007-05-15 1010 1100
Â
Oracle source: ReportsNet. FACULTY_OFFICE_HOURS view
Oracle objects: SPRIDEN, SIROFFC, STVTERM
Updated: hourly
Oracle Field/Calc | DW Field | Description or Sample |
siroffc.SIROFFC_TERM_CODE | TERM | 200710 (Fall = 10, Spring = 20, Summer = 30) |
stvterm.STVTERM_DESC | TERM_DESC | Fall 2006 |
spriden.SPRIDEN_ID | ID | Banner Id (@12345678) of Faculty member |
spriden.SPRIDEN_PIDM | PIDM | Up to 10-digit unique Banner id for the faculty member |
spriden.SPRIDEN_LAST_NAME | LAST_NAME | Â |
spriden.SPRIDEN_FIRST_NAME | FIRST_NAME | Â |
spriden.SPRIDEN_MI | MIDDLE_NAME | Banner uses the Sproden_Mi field for full middle names as well as initials |
siroffc.SIROFFC_CRN | CRN | Course for which the office hours are scheduled |
siroffc.SIROFFC_MON_DAY | MON_DAY | Contains an ‘M’ for Monday office hours |
siroffc.SIROFFC_TUE_DAY | TUE_DAY | Contains a ‘T’ for Tuesday office hours |
siroffc.SIROFFC_WED_DAY | WED_DAY | Contains a ‘W’ for Wednesday office hours |
siroffc.SIROFFC_THU_DAY | THU_DAY | Contains an ‘R’ for Thursday office hours |
siroffc.SIROFFC_FRI_DAY | FRI_DAY | Contains an ‘F’ for Friday office hours |
siroffc.SIROFFC_SAT_DAY | SAT_DAY | Contains an ‘S’ for Saturday office hours |
siroffc.SIROFFC_SUN_DAY | SUN_DAY | Contains a ‘U’ for Sunday office hours |
case when to_char(siroffc.SIROFFC_FROM_DATE,'yyyy') < 1000 then to_date(to_char(siroffc.SIROFFC_FROM_DATE,'MM/dd')||'/20'||to_char(siroffc.SIROFFC_FROM_DATE,'yy'),'MM/dd/yyyy') else siroffc.SIROFFC_FROM_DATE | FROM_DATE | The from date when the office hours are valid |
case when to_char(siroffc.SIROFFC_TO_DATE,'yyyy') < 1000 then to_date(to_char(siroffc.SIROFFC_TO_DATE,'MM/dd')||'/20'||to_char(siroffc.SIROFFC_TO_DATE,'yy'),'MM/dd/yyyy') else siroffc.SIROFFC_TO_DATE | TO_DATE | The to date when the office hours are valid |
siroffc.SIROFFC_FROM_TIME | FROM_TIME | office hours begin time (24-hour) (1310) |
siroffc.SIROFFC_TO_TIME | TO_TIME | office hours end time (24-hour) (1400) |
COS_AM_PM_TIME(siroffc.SIROFFC_FROM_TIME) | DISPLAY_FROM_TIME | office hours begin time, for display (1:10PM) |
COS_AM_PM_TIME(siroffc.SIROFFC_TO_TIME) | DISPLAY_TO_TIME | Office hours end time, for display (2:00PM) |
siroffc.SIROFFC_LOCATION | OFFICE_LOCATION | Location of office |
siroffc.SIROFFC_DISPLAY_IND | DISPLAY_IND | Y/N: Banner uses this to control if the record’s information should be displayed to a student. For the EIS, this value is ignored. |
decode(siroffc.SIROFFC_PHONE_AREA, null, '', '(' || siroffc.SIROFFC_PHONE_AREA || ') ' || siroffc.SIROFFC_PHONE_NUMBER ||' ' || siroffc.SIROFFC_PHONE_EXTN), | PHONE | Office phone number (not currently populated) |
siroffc.SIROFFC_TELE_CODE | TELE_CODE | Type of phone number in Phone: BI: Billing BU: Business or work CL: Cellular Phone Number CN: Confidential/Unlisted EMER: Emergency Contact FAX: Fax HOM: Student Home HQ: Corporate Headquarters MA: Mailing MG: Matching Gift PA: Parents PR: Permanent RE: Remittance SB: Corporate Subsidiary SC: School Campus SE: Seasonal TE: Temporary TTY: Relay Operator for the Deaf |
Â