Penn Computing

University of Pennsylvania
Penn Computing << go backback

ROOM PROFILE Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

ROOM_PROFILE Table - Data Element Index

 

Building_Code Building in which a course section meets. A course section can have up to six meeting patterns. Each meeting pattern consists of one or more days, the time, and the location at which the course section meets. For example: a course section can meet Mondays, Wednesdays, and Fridays in Bennett Hall (BENN) and Tuesdays in Blockley Hall (BLOC).

Values:
See the BUILDING Table for values.

Fims_Building_Code Facility Information Management System (FIMS) designation for a building. For example: 0416.

Values:
Refer to the FIMS Table for values.

Fims_Floor_Code Facility Information Management System (FIMS) designation for a specific floor in a building. For example: GROUND, BASE, A, B.

Values:
Refer to the FIMS Table for values.

Fims_Room_Code Facility Information Management System (FIMS) designation for a specific room in a building. For example: 104, 301A, C41.

Values:
Refer to the FIMS Table for values.

Room_Actual_Capacity
Number of people a room can actually accommodate. For example: the room can accommodate 35 people. Room capacity should not be confused with the largest number of persons who have met in the room which may be larger or smaller than the number it was designed to hold.

Values:

List of values not available.

Room_Desc
Free form text description of a room, describing the type of room or giving a name for the room. This data element may be null. Examples of values include "CLASSROOM-TABLET ARM CHAIRS" and "MODERN LANGUAGE SEMINAR RM".

Values:

[Null]        No description or name of room provided

Text string   Description or name of room provided
Room_Design_Capacity Number of people the room is designed to hold. This data is derived from values in the Facilities Information Management System (FIMS). For example: the room is designed to hold 22 people.

Values:

List of values not available.

Room_Number Identifies the room within a building. This may contain letters, numbers, and symbols. Examples include STD-2, A4, 101, 13, and LOUNG.

Values:

List of values not available.

Room_Sched_Flag Indicates who is allowed to schedule courses and other events in this room. For example: courses and events in this room are scheduled by R (Registrar's Office).

Values:

[Null]    Unrestricted

R         Scheduled By Registrars Office

S         Scheduled By School Personnel

D         Scheduled By Department Personnel

B         Scheduled By School/Department Personnel

X         Out Of Service

Room_Dept_Priority_1 Indicates which departments receive priority when scheduling a course section for a particular room. Departments with priority have preference over those that do not. For departments with priority, all have equal claim on a room so that rooms are scheduled on a first come, first serve basis. This information can be in one of five data elements: Room_Dept_Priority_1 through Room_Dept_Priority_5.

Values:

See DEPT table for values.

Room_Dept_Priority_2 Indicates which departments receive priority when scheduling a course section for a particular room. Departments with priority have preference over those that do not. For departments with priority, all have equal claim on a room so that rooms are scheduled on a first come, first serve basis. This information can be in one of five data elements: Room_Dept_Priority_1 through Room_Dept_Priority_5.

Values:

See DEPT table for values.

Room_Dept_Priority_3 Indicates which departments receive priority when scheduling a course section for a particular room. Departments with priority have preference over those that do not. For departments with priority, all have equal claim on a room so that rooms are scheduled on a first come, first serve basis. This information can be in one of five data elements: Room_Dept_Priority_1 through Room_Dept_Priority_5.

Values:

See DEPT table for values.

Room_Dept_Priority_4 Indicates which departments receive priority when scheduling a course section for a particular room. Departments with priority have preference over those that do not. For departments with priority, all have equal claim on a room so that rooms are scheduled on a first come, first serve basis. This information can be in one of five data elements: Room_Dept_Priority_1 through Room_Dept_Priority_5.

Values:

See DEPT table for values.

Room_Dept_Priority_5
Indicates which departments receive priority when scheduling a course section for a particular room. Departments with priority have preference over those that do not. For departments with priority, all have equal claim on a room so that rooms are scheduled on a first come, first serve basis. This information can be in one of five data elements: Room_Dept_Priority_1 through Room_Dept_Priority_5.

Values:

See DEPT table for values.



Room_School_Priority_1

Indicates which schools receive priority when scheduling a course section for a particular room. Schools with priority have preference over those that do not. For schools with priority, all have equal claim on a room so that rooms are scheduled on a first come, first serve basis. This information can be in one of five data elements: Room_School_Priority_1 through Room_School_Priority_5. For example: if AS (Arts & Sciences) is assigned to Room_School_Priority_1 for Williams Room 205 and NU (Nursing) is not assigned to any of the five priority positions, then AS has scheduling priority over NU. However, if AS is assigned to Room_School_Priority_1 for Williams Room 205 and NU is assigned to Room_School_Priority_2 for Williams Room 205, then both schools have equal claim on the room and the room is assigned to the first school who has requested it.


Values:
Refer to SCHOOL table for valid values.
Room_School_Priority_2
See Room_School_Priority_1

Room_School_Priority_3
See Room_School_Priority_1
Room_School_Priority_4
See Room_School_Priority_1
Room_School_Priority_5 See Room_School_Priority_1

Room_Seating_Type
Indicates the type of seating in a particular room. For example: D (Desk Chairs), U (Auditorium Seats), L (Lab Stations).
Values:
[Null]     Not Defined

A          Tablet Arm Chairs

D          Desk Chairs

L          Lab Stations

T          Tables/Chairs

F          Drafting Desks

U          Auditorium Seats
Room_Spec_Equip_1

Indicates the various types of equipment which are
available in a particular classroom. Up to 10 different types of equipment
can be stored in each room. For example: a room can have AIR (Air
Conditioning), COT (Coat Racks), COM (Computers).

Values:
[Null]     UNIDENTIFIED

AIR        AIR CONDITIONING

ADF        AV - DOUBLE FIXED SCREEN

ASF        AV - SINGLE FIXED SCREEN

CPT        CARPETING

CBS        CHALKBOARD - SMALL

CBM        CHALKBOARD - MEDIUM

CBL        CHALKBOARD - LARGE

COT        COAT RACKS

COM        COMPUTERS

CON        CONFERENCE TABLE

EXM        USED FOR FINAL EXAM SCHEDULING

GAS        GAS FOR LAB

INS        INSTRUCTOR DESK

LAN        LANGUAGE LAB EQUIPMENT

LEC        LECTERN - TABLE TOP

LEF        LECTERN - STANDING, FIXED

LEM        LECTERN - STANDING, MOVEABLE

PRJ        OVERHEAD PROJECTOR

PIA        PIANO

POD        PODIUM

POF        PODIUM - FIXED

POM        PODIUM - MOVEABLE

RST        RAISED STAGE

SND        SOUND ISOLATION BOOTHS

TAC        TACK SPACE

TV         TELEVISION

TVC        TV CABLE HOOKUP

WAT        WATER FOR LAB

SHD        WINDOW DARKENERS

WIN        WINDOWS

FLT        FLAT ROOM (WHARTON)

TRD        TIERED ROOM (WHARTON)
Room_Spec_Equip_2 See Room_Spec_Equip_1
Room_Spec_Equip_3 See Room_Spec_Equip_1
Room_Spec_Equip_4 See Room_Spec_Equip_1
Room_Spec_Equip_5 See Room_Spec_Equip_1
Room_Spec_Equip_6 See Room_Spec_Equip_1
Room_Spec_Equip_7 See Room_Spec_Equip_1
Room_Spec_Equip_8 See Room_Spec_Equip_1
Room_Spec_Equip_9 See Room_Spec_Equip_1
Room_Spec_Equip_10 See Room_Spec_Equip_1
Room_Term_Roll_Flag Indicates whether the course sections assigned to a particular room will roll from one term to the next like term (i.e., from this Fall term to the next Fall term or from this Spring term to the next Spring term). For each course section rolled, counters and flags are reset. This process is used to reduce the amount of data entry involved in SRS in setting up course sections for a new term.

Values:
[Null]     Normal, previous term schedule rolled

N          No, do not roll previous term schedule

        
Room_Type Indicates the type of room. For example: 110 (Classroom), 350 (Conference Room), 611 (Auditorium).
Values:
[Null]   NOT DEFINED

110      CLASSROOM

210      REGULAR LABORATORY

220      SPECIAL CLASSROOM LABORATORY

260      STUDIO

350      CONFERENCE

530      AUDIO/VISUAL RADIO TV

610      ASSEMBLY

611      AUDITORIUM

Room_Wheelchair_Access

Indicates whether a room or building is wheelchair accessible. For example: null means wheelchair accessibility is unknown, Y (Yes) means the room is wheelchair, and N (No) means the room is not wheelchair accessible.
Values:
[Null]      UNKNOWN

Y           ROOM IS ACCESSIBLE BY WHEELCHAIR

N           ROOM IS NOT ACCESSIBLE BY WHEELCHAIR

ROOM PROFILE Table . Tables and Data Elements . Student Data Home . Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania