FACILITY_TBL_VW(SQL View) |
Index Back |
---|---|
Facility Table ViewThis 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 |
# | 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 |