Faculty_Office_Hours table

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