FACILITY_TBL_VW

(SQL View)
Index Back

Facility Table View

This Facility Table view is a replica of the base table. Facility ID happens to be in the Class Exam and Class Meeting Pattern tables which are both in scroll level 2 in the Schedule of Classes panelgroups. This view allows Facility Group to be referenced from peoplecode without ambiguity.

select setid, facility_id, effdt, eff_status, bldg_cd, room, descr, descrshort, facility_type, facility_group, location, room_capacity, generl_assign, acad_org, facility_partition, min_utlzn_pct, facility_conflict from PS_FACILITY_TBL

  • Related Language Record: FACILITY_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID_FACILITY

    Prompt Table: SETID_TBL

    2 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID

    Default Value: NEW

    Prompt Table: FACILITY_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 BLDG_CD Character(10) VARCHAR2(10) NOT NULL Building

    Prompt Table: BLDG_TBL

    6 ROOM Character(10) VARCHAR2(10) NOT NULL Room
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: FACILITY_TBL.DESCR

    9 FACILITY_TYPE Character(4) VARCHAR2(4) NOT NULL Facility Type
    AUD=Auditorium
    CBL=Cable TV
    CMLB=Computer Lab
    EXT=Exterior Space
    ITV=Interactive TV Classroom
    LAB=Laboratory
    LCTR=Lecture Room
    RSCH=Research Site
    SMNR=Seminar Room
    SPRT=Sporting Facility

    Default Value: LCTR

    10 FACILITY_GROUP Character(1) VARCHAR2(1) NOT NULL Facility Group

    Y/N Table Edit

    Default Value: N

    11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Default Value: 001

    Prompt Table: LOCATION_TBL

    12 ROOM_CAPACITY Number(4,0) SMALLINT NOT NULL Room Capacity
    13 GENERL_ASSIGN Character(1) VARCHAR2(1) NOT NULL General Assignment

    Y/N Table Edit

    Default Value: Y

    14 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TB2_VW

    15 FACILITY_PARTITION Character(2) VARCHAR2(2) NOT NULL Facility Partition
    01=First Quadrant
    02=Second Quadrant
    03=Third Quadrant
    04=Fourth Quadrant
    16 MIN_UTLZN_PCT Number(3,0) SMALLINT NOT NULL Minimum Utilization Percent
    17 FACILITY_CONFLICT Character(1) VARCHAR2(1) NOT NULL Status of Facility