SETIDBLDG_CDPrompt Table: BLDG_TBL
ROOMFACILITY_VW(SQL View) |
Index Back |
|---|---|
Facility ViewA Building, Room combination within a SetID should correspond to only one Facility ID. This view is used to check if a given room number isn't already accounted for by an existing Facility ID. |
| select a.setid, a.bldg_cd, a.room, a.facility_id from PS_FACILITY_TBL a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BLDG_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Building
Prompt Table: BLDG_TBL |
| 3 | ROOM |
Character(10) | VARCHAR2(10) NOT NULL | Room |
| 4 | FACILITY_ID | Character(10) | VARCHAR2(10) NOT NULL | Facility ID |